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 `iloc` Property

The iloc property in Pandas allows us to access specific parts of a DataFrame using numerical positions.

You can use iloc to access:

A single element;
A single row;
A single column;
A range of rows;
A range of columns;
A range of rows and columns.

General Syntax

DataFrame.iloc[row_position, column_position]

You can also slice:

DataFrame.iloc[start_row:end_row, start_col:end_col]

Example


              12345678910111213141516171819202122232425
            
import pandas as pd

df = pd.DataFrame({
    'Name': ['Alice', 'Bob', 'Charlie', 'Daisy'],
    'Age': [25, 30, 35, 28],
    'City': ['New York', 'Paris', 'London', 'Berlin']
})

# Single element
print('>> Single Element:\n', df.iloc[1, 2])

# Single row
print('\n>> Single Row:\n', df.iloc[2])

# Single column
print('\n>> Single Column:\n', df.iloc[:, 1])

# Range of rows
print('\n>> Range of Rows:\n', df.iloc[1:3])

# Range of columns
print('\n>> Range of Columns:\n', df.iloc[:, 0:2])

# Range of rows and columns
print('\n>> Range of Rows & Columns:\n', df.iloc[1:3, 0:2])

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 10

Kysy tekoälyä

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 `iloc` Property

The iloc property in Pandas allows us to access specific parts of a DataFrame using numerical positions.

You can use iloc to access:

A single element;
A single row;
A single column;
A range of rows;
A range of columns;
A range of rows and columns.

General Syntax

DataFrame.iloc[row_position, column_position]

You can also slice:

DataFrame.iloc[start_row:end_row, start_col:end_col]

Example


              12345678910111213141516171819202122232425
            
import pandas as pd

df = pd.DataFrame({
    'Name': ['Alice', 'Bob', 'Charlie', 'Daisy'],
    'Age': [25, 30, 35, 28],
    'City': ['New York', 'Paris', 'London', 'Berlin']
})

# Single element
print('>> Single Element:\n', df.iloc[1, 2])

# Single row
print('\n>> Single Row:\n', df.iloc[2])

# Single column
print('\n>> Single Column:\n', df.iloc[:, 1])

# Range of rows
print('\n>> Range of Rows:\n', df.iloc[1:3])

# Range of columns
print('\n>> Range of Columns:\n', df.iloc[:, 0:2])

# Range of rows and columns
print('\n>> Range of Rows & Columns:\n', df.iloc[1:3, 0:2])

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 10

some-alt