Pandas: First Steps

Kurssisisältö

Pandas: First Steps

Pandas: First Steps

1. Getting Started

Introduction to Pandas Series Task: Coffee Orders Series Task: Barista's Favorites Coffees Accessing Elements from a Series Task: Drink of the Hour Task - Signature Drinks Task: Mid-Morning Specials Task - Fetching the Mid-Shift Drinks Operations over Series Task: Modifying a single element Task: Modifying the Entire Series Task: Modifying Part of a Series Task: Processing the Restock of Inventory

2. Basics of Dataframes

What is a DataFrame?Task: Creating a Table of Popular Coffee Drinks Task: Tracking Coffee Bean Deliveries Task: Weekly Coffee Sales Report Adding new Columns Task: Finding Total Sales Per Drink Task: Calculating Total Sales Revenue Adding new Rows Task: Adding a New Employee to the Café Team Task: Adding New Coffee Types to the Café Menu

3. Fetching Data from DataFrames

The `head()` Method Task: Preview the Coffee Menu The `tail()` Method Task: Finding the Most Expensive Coffees The `sample()` Method Task: Randomly Select Customer Orders for Quality Check Extracting Multiple Columns Task: Extracting the Total Profit Task: Extract Sales Data For Analysis The `iloc` Property Task: Access Sales Data at Café Pandasia - Part 1 Task: Access Sales Data at Café Pandasia - Part 2 Task: Access Sales Data at Café Pandasia - Part 3

The `tail()` Method

The tail() method fetches the last few rows from a dataframe.

It also returns 5 rows by default. A custom number of rows can be specified using the n named parameter.

Syntax

js

Example


              12345678910111213141516171819
            
import pandas as pd

# Create a simple DataFrame about a bookstore
books = pd.DataFrame({
    'Title': [
        'The Alchemist', '1984', 'To Kill a Mockingbird', 'The Great Gatsby',
        'Moby Dick', 'Pride and Prejudice', 'War and Peace', 'The Hobbit',
        'Crime and Punishment', 'Jane Eyre'
    ],
    'Author': [
        'Paulo Coelho', 'George Orwell', 'Harper Lee', 'F. Scott Fitzgerald',
        'Herman Melville', 'Jane Austen', 'Leo Tolstoy', 'J.R.R. Tolkien',
        'Fyodor Dostoevsky', 'Charlotte Brontë'
    ],
    'Stock': [12, 8, 15, 7, 3, 10, 5, 9, 4, 6]
})

print('Show the last 7 books in the list:')
print(books.tail(n=3))

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 3

Kysy tekoälyä

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

Kurssisisältö

Pandas: First Steps

Pandas: First Steps

1. Getting Started

Introduction to Pandas Series Task: Coffee Orders Series Task: Barista's Favorites Coffees Accessing Elements from a Series Task: Drink of the Hour Task - Signature Drinks Task: Mid-Morning Specials Task - Fetching the Mid-Shift Drinks Operations over Series Task: Modifying a single element Task: Modifying the Entire Series Task: Modifying Part of a Series Task: Processing the Restock of Inventory

2. Basics of Dataframes

What is a DataFrame?Task: Creating a Table of Popular Coffee Drinks Task: Tracking Coffee Bean Deliveries Task: Weekly Coffee Sales Report Adding new Columns Task: Finding Total Sales Per Drink Task: Calculating Total Sales Revenue Adding new Rows Task: Adding a New Employee to the Café Team Task: Adding New Coffee Types to the Café Menu

3. Fetching Data from DataFrames

The `head()` Method Task: Preview the Coffee Menu The `tail()` Method Task: Finding the Most Expensive Coffees The `sample()` Method Task: Randomly Select Customer Orders for Quality Check Extracting Multiple Columns Task: Extracting the Total Profit Task: Extract Sales Data For Analysis The `iloc` Property Task: Access Sales Data at Café Pandasia - Part 1 Task: Access Sales Data at Café Pandasia - Part 2 Task: Access Sales Data at Café Pandasia - Part 3

The `tail()` Method

The tail() method fetches the last few rows from a dataframe.

It also returns 5 rows by default. A custom number of rows can be specified using the n named parameter.

Syntax

js

Example


              12345678910111213141516171819
            
import pandas as pd

# Create a simple DataFrame about a bookstore
books = pd.DataFrame({
    'Title': [
        'The Alchemist', '1984', 'To Kill a Mockingbird', 'The Great Gatsby',
        'Moby Dick', 'Pride and Prejudice', 'War and Peace', 'The Hobbit',
        'Crime and Punishment', 'Jane Eyre'
    ],
    'Author': [
        'Paulo Coelho', 'George Orwell', 'Harper Lee', 'F. Scott Fitzgerald',
        'Herman Melville', 'Jane Austen', 'Leo Tolstoy', 'J.R.R. Tolkien',
        'Fyodor Dostoevsky', 'Charlotte Brontë'
    ],
    'Stock': [12, 8, 15, 7, 3, 10, 5, 9, 4, 6]
})

print('Show the last 7 books in the list:')
print(books.tail(n=3))

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 3

some-alt