Series indexing and selection in Data Analysis Python - Mini Project: Build & Apply

Series indexing and selection

📖 Scenario: You work in a small bookstore. You have a list of book sales for the week stored as a pandas Series. You want to find out how many copies of certain books were sold by selecting data from this Series.

🎯 Goal: Learn how to create a pandas Series and select data from it using indexing and labels.

📋 What You'll Learn

Create a pandas Series with given book sales data

Create a list of book titles to select

Select sales data for those books from the Series

Print the selected sales data

💡 Why This Matters

🌍 Real World

Selecting specific data from a dataset is common in sales analysis, inventory management, and reporting.

💼 Career

Data analysts and scientists often need to filter and select data from Series or DataFrames to answer business questions.

1

Create the book sales Series

Import pandas as pd and create a Series called book_sales with these exact entries: 'Python Basics': 120, 'Data Science 101': 85, 'Machine Learning': 95, 'Deep Learning': 60, 'AI for Everyone': 75. Use the book titles as the index.

Data Analysis Python

# Import pandas and create the book_sales Series
# Your code here

Need a hint?

Use pd.Series() with a list of sales numbers and an index list of book titles.

2

Create a list of books to select

Create a list called selected_books with these exact book titles: 'Python Basics', 'Deep Learning', and 'AI for Everyone'.

Data Analysis Python

import pandas as pd

book_sales = pd.Series(
    [120, 85, 95, 60, 75],
    index=['Python Basics', 'Data Science 101', 'Machine Learning', 'Deep Learning', 'AI for Everyone']
)

# Create the selected_books list
# Your code here

Need a hint?

Use square brackets to create a list with the exact book titles.

3

Select sales data for chosen books

Use the selected_books list to select the sales data from book_sales and store it in a new variable called selected_sales.

Data Analysis Python

import pandas as pd

book_sales = pd.Series(
    [120, 85, 95, 60, 75],
    index=['Python Basics', 'Data Science 101', 'Machine Learning', 'Deep Learning', 'AI for Everyone']
)

selected_books = ['Python Basics', 'Deep Learning', 'AI for Everyone']

# Select sales data for selected_books
# Your code here

Need a hint?

Use square brackets with selected_books to select from book_sales.

4

Print the selected sales data

Print the selected_sales variable to see the sales numbers for the chosen books.

Data Analysis Python

import pandas as pd

book_sales = pd.Series(
    [120, 85, 95, 60, 75],
    index=['Python Basics', 'Data Science 101', 'Machine Learning', 'Deep Learning', 'AI for Everyone']
)

selected_books = ['Python Basics', 'Deep Learning', 'AI for Everyone']

selected_sales = book_sales[selected_books]

# Print the selected_sales
# Your code here

Need a hint?

Use print(selected_sales) to display the selected sales.