Series as labeled one-dimensional array in Pandas - Mini Project: Build & Apply

Series as labeled one-dimensional array

📖 Scenario: You are working with sales data for a small shop. Each product has a sales number for the day. You want to organize this data in a way that keeps the product names linked to their sales numbers.

🎯 Goal: Create a pandas Series to hold sales numbers with product names as labels. Then, select and display the sales number for a specific product.

📋 What You'll Learn

Create a pandas Series named sales with exact product names and sales numbers

Create a variable product_name to hold the product to look up

Use the product_name variable to get the sales number from the sales Series

Print the sales number for the selected product

💡 Why This Matters

🌍 Real World

Stores and businesses often track sales data by product. Using labeled data structures like pandas Series helps keep data clear and easy to analyze.

💼 Career

Data analysts and scientists use pandas Series to manage and analyze labeled data efficiently in many industries.

1

Create the sales data Series

Import pandas as pd. Create a pandas Series called sales with these exact entries: 'Apples': 30, 'Bananas': 45, 'Oranges': 25, 'Grapes': 40.

Pandas

import pandas as pd
# Create the sales Series with product names as labels
# Your code here

Hint

Use pd.Series with a dictionary where keys are product names and values are sales numbers.

2

Set the product name to look up

Create a variable called product_name and set it to the string 'Bananas'.

Pandas

import pandas as pd
sales = pd.Series({'Apples': 30, 'Bananas': 45, 'Oranges': 25, 'Grapes': 40})
# Create the product_name variable with value 'Bananas'
# Your code here

Hint

Just assign the string 'Bananas' to the variable product_name.

3

Get the sales number for the product

Use the product_name variable to get the sales number from the sales Series and store it in a variable called sales_number.

Pandas

import pandas as pd
sales = pd.Series({'Apples': 30, 'Bananas': 45, 'Oranges': 25, 'Grapes': 40})
product_name = 'Bananas'
# Get the sales number for product_name from sales
# Your code here

Hint

Use square brackets with sales[product_name] to get the value for the label stored in product_name.

4

Print the sales number

Print the variable sales_number to display the sales for the selected product.

Pandas

import pandas as pd
sales = pd.Series({'Apples': 30, 'Bananas': 45, 'Oranges': 25, 'Grapes': 40})
product_name = 'Bananas'
sales_number = sales[product_name]
# Print the sales_number
# Your code here

Hint

Use print(sales_number) to show the sales number.

Practice

1.

What is a pandas.Series best described as?

easy

A. A two-dimensional table with rows and columns

B. A one-dimensional labeled array that can hold any data type

C. A function to perform mathematical operations

D. A method to read data from a file

Solution

1. Step 1: Understand the definition of Series

   A pandas Series is a one-dimensional array with labels called an index.

2. Step 2: Compare options with definition

   A one-dimensional labeled array that can hold any data type matches the definition exactly, others describe different pandas objects or unrelated concepts.

3. Final Answer:

   A one-dimensional labeled array that can hold any data type -> Option B

4. Quick Check:

   Series = one-dimensional labeled array [OK]

Hint: Remember: Series = 1D labeled array in pandas [OK]

Common Mistakes:

• Confusing Series with DataFrame (2D)
• Thinking Series is a function or method
• Mixing Series with file operations

2.

Which of the following is the correct way to create a pandas.Series with values [10, 20, 30] and index labels ['a', 'b', 'c']?

import pandas as pd
# Choose the correct code

easy

A. pd.Series(data=[10, 20, 30], labels=['a', 'b', 'c'])

B. pd.Series(index=[10, 20, 30], data=['a', 'b', 'c'])

C. pd.Series([10, 20, 30], index=['a', 'b', 'c'])

D. pd.Series([10, 20, 30], labels=['a', 'b', 'c'])

Solution

1. Step 1: Recall Series constructor parameters

   The Series constructor uses data as first argument and index for labels.

2. Step 2: Match options with correct parameter names

   pd.Series([10, 20, 30], index=['a', 'b', 'c']) uses correct syntax: data list and index list. Others use wrong parameter names or order.

3. Final Answer:

   pd.Series([10, 20, 30], index=['a', 'b', 'c']) -> Option C

4. Quick Check:

   Use 'index' for labels in Series constructor [OK]

Hint: Use 'index' keyword for labels when creating Series [OK]

Common Mistakes:

• Using 'labels' instead of 'index'
• Swapping data and index arguments
• Passing index as 'data' parameter

3.

What will be the output of the following code?

import pandas as pd
s = pd.Series([5, 10, 15], index=['x', 'y', 'z'])
print(s['y'])

medium

A. KeyError

B. y

C. 15

D. 10

Solution

1. Step 1: Understand Series indexing by label

   Series allows access by index label. Here, 'y' corresponds to value 10.

2. Step 2: Check the printed value

   Accessing s['y'] returns 10, so print outputs 10.

3. Final Answer:

   10 -> Option D

4. Quick Check:

   Access by label 'y' returns 10 [OK]

Hint: Access Series values by index label like dictionary keys [OK]

Common Mistakes:

• Confusing label with value
• Expecting index position access with label
• Mistaking output for error

4.

Identify the error in the following code snippet:

import pandas as pd
s = pd.Series([1, 2, 3], index=['a', 'b', 'c'])
print(s['d'])

medium

A. KeyError because 'd' is not in index

B. SyntaxError due to wrong index syntax

C. No error, prints 0

D. TypeError because index labels must be integers

Solution

1. Step 1: Check index labels in Series

   The Series has index labels 'a', 'b', 'c'. 'd' is not present.

2. Step 2: Understand what happens when accessing missing label

   Accessing s['d'] raises KeyError because label 'd' does not exist.

3. Final Answer:

   KeyError because 'd' is not in index -> Option A

4. Quick Check:

   Accessing missing label causes KeyError [OK]

Hint: Accessing missing label in Series raises KeyError [OK]

Common Mistakes:

• Expecting default 0 or None for missing label
• Confusing KeyError with SyntaxError
• Thinking index labels must be integers

5.

Given a pandas.Series s = pd.Series([100, 200, 300], index=['a', 'b', 'c']), how can you add a new element with label 'd' and value 400?

hard

A. s['d'] = 400

B. s.append({'d': 400})

C. s.add('d', 400)

D. s.insert('d', 400)

Solution

1. Step 1: Recall how to add elements to Series

   You can add a new label and value by assignment using s[label] = value.

2. Step 2: Check options for correct syntax

   s['d'] = 400 uses s['d'] = 400 which adds new element. Others are invalid or incorrect methods.

3. Final Answer:

   s['d'] = 400 -> Option A

4. Quick Check:

   Assign new label with s['label'] = value [OK]

Hint: Add new item by assigning s['new_label'] = value [OK]

Common Mistakes:

• Using non-existent methods like add or insert
• Trying to append with dict without reassignment
• Confusing Series with DataFrame methods