Why indexing matters in Pandas - See It in Action

Why indexing matters

📖 Scenario: Imagine you have a small store and you keep track of your sales data. You want to find sales information quickly and easily. Using indexing in pandas helps you do that.

🎯 Goal: You will create a sales data table, set an index to organize it by product names, and then use that index to find sales data quickly.

📋 What You'll Learn

Create a pandas DataFrame with sales data

Set the product names as the index of the DataFrame

Use the index to select sales data for a specific product

Print the selected sales data

💡 Why This Matters

🌍 Real World

Indexing helps you quickly find and organize data in tables, like looking up products in a store inventory.

💼 Career

Data scientists use indexing to efficiently access and analyze data, making their work faster and more accurate.

1

Create the sales data DataFrame

Import pandas as pd. Create a DataFrame called sales_data with these exact columns and values: 'Product' with values 'Apple', 'Banana', 'Cherry'; 'Quantity' with values 10, 20, 15; and 'Price' with values 0.5, 0.3, 0.2.

Pandas

import pandas as pd
# Create the sales_data DataFrame with the given columns and values
# Your code here

Need a hint?

Use pd.DataFrame and pass a dictionary with keys as column names and values as lists of data.

2

Set the product names as the index

Set the 'Product' column as the index of the sales_data DataFrame using set_index and save it back to sales_data.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Product': ['Apple', 'Banana', 'Cherry'],
    'Quantity': [10, 20, 15],
    'Price': [0.5, 0.3, 0.2]
})
# Set 'Product' as the index of sales_data
# Your code here

Need a hint?

Use sales_data.set_index('Product') and assign it back to sales_data.

3

Select sales data for a specific product using the index

Use the index to select the row for 'Banana' from sales_data and save it in a variable called banana_data.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Product': ['Apple', 'Banana', 'Cherry'],
    'Quantity': [10, 20, 15],
    'Price': [0.5, 0.3, 0.2]
})
sales_data = sales_data.set_index('Product')
# Select the row for 'Banana' using the index and save it to banana_data
# Your code here

Need a hint?

Use sales_data.loc['Banana'] to get the row for Banana.

4

Print the selected sales data

Print the variable banana_data to display the sales information for Banana.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Product': ['Apple', 'Banana', 'Cherry'],
    'Quantity': [10, 20, 15],
    'Price': [0.5, 0.3, 0.2]
})
sales_data = sales_data.set_index('Product')
banana_data = sales_data.loc['Banana']
# Print banana_data
# Your code here

Need a hint?

Use print(banana_data) to show the sales data for Banana.