Creating Series from list and dictionary in Pandas - Try It Yourself

Creating Series from list and dictionary

📖 Scenario: You work in a small shop that tracks daily sales. You want to organize sales data using pandas Series to analyze it easily.

🎯 Goal: Learn how to create pandas Series from a list and a dictionary, then display the results.

📋 What You'll Learn

Create a pandas Series from a list of sales numbers

Create a pandas Series from a dictionary of product sales

Print both Series to see the data

💡 Why This Matters

🌍 Real World

Organizing sales or measurement data in Series helps in quick analysis and visualization.

💼 Career

Data scientists and analysts often convert raw data into Series for easy manipulation and insights.

1

Create a pandas Series from a list

Import pandas as pd. Create a list called daily_sales with these exact values: 100, 150, 200, 130, 170. Then create a pandas Series called sales_series from the daily_sales list.

Pandas

import pandas as pd
# Create the list daily_sales with values 100, 150, 200, 130, 170
# Create the pandas Series sales_series from daily_sales
# Your code here

Hint

Use pd.Series() to convert a list into a Series.

2

Create a pandas Series from a dictionary

Create a dictionary called product_sales with these exact entries: 'Apples': 30, 'Bananas': 45, 'Oranges': 25. Then create a pandas Series called product_series from the product_sales dictionary.

Pandas

import pandas as pd

daily_sales = [100, 150, 200, 130, 170]
sales_series = pd.Series(daily_sales)
# Create the dictionary product_sales with Apples, Bananas, Oranges and their sales
# Create the pandas Series product_series from product_sales
# Your code here

Hint

Use pd.Series() with a dictionary to create a Series with labels.

3

Print both Series to see the data

Use two print() statements to display the sales_series and product_series.

Pandas

import pandas as pd

daily_sales = [100, 150, 200, 130, 170]
sales_series = pd.Series(daily_sales)

product_sales = {'Apples': 30, 'Bananas': 45, 'Oranges': 25}
product_series = pd.Series(product_sales)
# Print sales_series
# Print product_series
# Your code here

Hint

Use print() to show the Series data.

4

Final output check

Run the program to see the printed Series from the list and dictionary.

Pandas

import pandas as pd

daily_sales = [100, 150, 200, 130, 170]
sales_series = pd.Series(daily_sales)

product_sales = {'Apples': 30, 'Bananas': 45, 'Oranges': 25}
product_series = pd.Series(product_sales)

print(sales_series)
print(product_series)
# Run the code to see the output

Hint

The output shows the Series with index labels and values.

Practice

1. What happens when you create a pandas Series from a dictionary?

easy

A. The dictionary keys become the Series index labels automatically.

B. The dictionary values become the index labels.

C. The Series will have numeric index ignoring the dictionary keys.

D. It raises an error because Series cannot be created from dictionaries.

Solution

1. Step 1: Understand Series creation from dictionary

   When creating a Series from a dictionary, pandas uses the dictionary keys as the index labels.

2. Step 2: Identify the role of dictionary keys and values

   The dictionary values become the data in the Series, and keys become the index labels automatically.

3. Final Answer:

   The dictionary keys become the Series index labels automatically. -> Option A

4. Quick Check:

   Dictionary keys = index labels [OK]

Hint: Keys become index labels automatically when using dict [OK]

Common Mistakes:

• Confusing keys with values as index
• Thinking Series always uses numeric index
• Assuming error occurs with dict input

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

easy

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

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

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

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

Solution

1. Step 1: Recall Series constructor parameters

   The correct parameters are data first, then index for labels.

2. Step 2: Match correct syntax

   pd.Series([10, 20, 30], index=['a', 'b', 'c']) uses pd.Series([10, 20, 30], index=['a', 'b', 'c']) which is correct syntax.

3. Final Answer:

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

4. Quick Check:

   Use index= for labels in Series constructor [OK]

Hint: Use index= for labels when creating Series from list [OK]

Common Mistakes:

• Using labels= instead of index=
• Swapping data and index parameters
• Passing index before data

3. What is the output of this code?

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

medium

A. 5

B. 10

C. 15

D. KeyError

Solution

1. Step 1: Create Series from dictionary

   The Series has index labels 'x', 'y', 'z' with values 5, 10, 15 respectively.

2. Step 2: Access value by index label 'y'

   Accessing s['y'] returns the value 10.

3. Final Answer:

   10 -> Option B

4. Quick Check:

   s['y'] = 10 [OK]

Hint: Access Series by index label to get corresponding value [OK]

Common Mistakes:

• Confusing index label with position
• Expecting numeric index access
• Mistaking value for key

4. Identify the error in this code snippet:

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

medium

A. TypeError because index must be integers.

B. SyntaxError due to missing parentheses.

C. No error; code runs fine.

D. Index length does not match data length causing ValueError.

Solution

1. Step 1: Check data and index lengths

   Data has 3 elements but index has only 2 labels.

2. Step 2: Understand pandas behavior

   Pandas raises ValueError if index length does not match data length.

3. Final Answer:

   Index length does not match data length causing ValueError. -> Option D

4. Quick Check:

   Data length != index length causes ValueError [OK]

Hint: Ensure index length matches data length when creating Series [OK]

Common Mistakes:

• Assuming pandas auto-adjusts index length
• Confusing ValueError with SyntaxError
• Thinking index must be integers

5. You have a dictionary {'a': 1, 'b': 0, 'c': 3, 'd': 0}. How do you create a pandas Series from it that only includes keys with values greater than zero?

hard

A. pd.Series(d).loc[d > 0]

B. pd.Series(d).filter(lambda x: x > 0)

C. pd.Series({k: v for k, v in d.items() if v > 0})

D. pd.Series(d).dropna()

Solution

1. Step 1: Filter dictionary items with values > 0

   Use dictionary comprehension to keep only items where value > 0.

2. Step 2: Create Series from filtered dictionary

   Pass the filtered dictionary to pd.Series to create the Series with desired keys and values.

3. Final Answer:

   pd.Series({k: v for k, v in d.items() if v > 0}) -> Option C

4. Quick Check:

   Filter dict first, then create Series [OK]

Hint: Filter dict before Series creation to exclude unwanted keys [OK]

Common Mistakes:

• Using filter() which is not a Series method
• Using dropna() which removes NaNs, not zeros
• Trying to index Series with dict directly