Why Pandas for data analysis - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why is Pandas preferred for handling tabular data?

Pandas is widely used for data analysis. Which reason best explains why Pandas is preferred for handling tabular data?

A It provides easy-to-use data structures like DataFrame and Series that allow fast data manipulation and analysis.

B It is a tool for writing machine learning models without any data preprocessing.

C It is a database management system optimized for large-scale data storage.

D It is mainly designed for creating visualizations and charts from data.

💡 Hint

Think about what makes working with rows and columns easier in Pandas.

Pandas offers DataFrame and Series, which are like tables and columns. These structures make it simple to select, filter, and transform data quickly.

❓ Predict Output

intermediate

Output of Pandas DataFrame filtering

What is the output of this code snippet?

Pandas

import pandas as pd

df = pd.DataFrame({'A': [1, 2, 3, 4], 'B': [5, 6, 7, 8]})
filtered = df[df['A'] > 2]
print(filtered)

A

   A  B
0  1  5
1  2  6
2  3  7
3  4  8

B

   A  B
0  1  5
1  2  6

C

   A  B
2  3  7
3  4  8

D

Empty DataFrame
Columns: [A, B]
Index: []

💡 Hint

Look at the condition used to filter rows.

The code filters rows where column 'A' has values greater than 2, so only rows with A=3 and A=4 remain.

❓ data_output

advanced

Result of groupby and aggregation in Pandas

Given the DataFrame below, what is the result of grouping by 'Category' and calculating the sum of 'Value'?

Pandas

import pandas as pd

df = pd.DataFrame({'Category': ['A', 'B', 'A', 'B', 'C'], 'Value': [10, 20, 30, 40, 50]})
grouped = df.groupby('Category').sum()
print(grouped)

A

          Value
Category       
A            40
B            60
C            50

B

          Value
Category       
A            30
B            40
C            50

C

          Value
Category       
A            10
B            20
C            50

D

          Value
Category       
A            70
B            60
C            50

💡 Hint

Sum the 'Value' for each unique 'Category'.

Category 'A' has values 10 and 30 (sum 40), 'B' has 20 and 40 (sum 60), 'C' has 50.

🔧 Debug

advanced

Identify the error in this Pandas code

What error does this code produce?

Pandas

import pandas as pd

df = pd.DataFrame({'X': [1, 2, 3], 'Y': [4, 5, 6]})
result = df['Z'] + 1
print(result)

A TypeError: unsupported operand type(s) for +: 'int' and 'str'

B ValueError: operands could not be broadcast together

C No error, prints a Series with values [2, 3, 4]

D KeyError: 'Z'

💡 Hint

Check if the column 'Z' exists in the DataFrame.

The DataFrame has columns 'X' and 'Y' only. Accessing 'Z' raises a KeyError.

🚀 Application

expert

Pandas operation to combine and summarize data

You have two DataFrames: one with sales data and one with product info. Which Pandas operation correctly merges these and calculates total sales per product?

Pandas

import pandas as pd

sales = pd.DataFrame({'ProductID': [1, 2, 1, 3], 'Quantity': [5, 3, 2, 4]})
products = pd.DataFrame({'ProductID': [1, 2, 3], 'Name': ['Pen', 'Pencil', 'Eraser']})

A

merged = sales.merge(products)
total = merged.groupby('ProductID')['Quantity'].count()
print(total)

B

merged = pd.merge(sales, products, on='ProductID')
total = merged.groupby('Name')['Quantity'].sum()
print(total)

C

merged = pd.concat([sales, products], axis=1)
total = merged.groupby('ProductID')['Quantity'].sum()
print(total)

D

merged = sales.join(products, on='ProductID')
total = merged.groupby('ProductID')['Quantity'].mean()
print(total)

💡 Hint

Think about joining on a common column and then grouping by product name.

Option B merges on 'ProductID', then groups by 'Name' to sum quantities, giving total sales per product.

Practice

1. Why is pandas a popular tool for data analysis?

easy

A. It only works with images and videos.

B. It makes working with tables of data easy and fast.

C. It is mainly used for creating websites.

D. It replaces all programming languages.

Solution

1. Step 1: Understand pandas purpose

   Pandas is designed to handle and analyze data tables efficiently.

2. Step 2: Compare options with pandas use

   Options A, B, and D describe unrelated uses or exaggerations, so they are incorrect.

3. Final Answer:

   It makes working with tables of data easy and fast. -> Option B

4. Quick Check:

   Data tables + easy use = C [OK]

Hint: Pandas is for easy and fast table data handling [OK]

Common Mistakes:

• Thinking pandas is for web development
• Confusing pandas with image tools
• Believing pandas replaces all coding

2. Which of the following is the correct way to import pandas in Python?

easy

A. import pd as pandas

B. import pandas from pd

C. from pandas import pd

D. import pandas as pd

Solution

1. Step 1: Recall pandas import syntax

   The standard way is to import pandas with alias pd using 'import pandas as pd'.

2. Step 2: Check other options for syntax errors

   Options A, B, and C have incorrect syntax or order and will cause errors.

3. Final Answer:

   import pandas as pd -> Option D

4. Quick Check:

   Standard import = D [OK]

Hint: Use 'import pandas as pd' to import pandas [OK]

Common Mistakes:

• Using wrong import order
• Confusing 'from' and 'import' keywords
• Swapping alias and module names

3. What will the following code output?

import pandas as pd
data = {'Name': ['Anna', 'Bob'], 'Age': [25, 30]}
df = pd.DataFrame(data)
print(df.shape)

medium

A. (2, 2)

B. (2, 1)

C. (1, 2)

D. (3, 2)

Solution

1. Step 1: Understand DataFrame creation

   The data dictionary has 2 keys (columns) and 2 values each (rows), so DataFrame has 2 rows and 2 columns.

2. Step 2: Interpret df.shape output

   df.shape returns a tuple (rows, columns), so it will be (2, 2).

3. Final Answer:

   (2, 2) -> Option A

4. Quick Check:

   Rows=2, Columns=2 = B [OK]

Hint: DataFrame shape = (rows, columns) from data dict size [OK]

Common Mistakes:

• Confusing rows and columns order
• Counting keys as rows
• Misreading shape output as list

4. Find the error in this code snippet:

import pandas as pd
data = {'A': [1, 2], 'B': [3, 4]}
df = pd.DataFrame(data)
print(df['C'])

medium

A. TypeError because data is not a list

B. SyntaxError due to missing comma

C. KeyError because column 'C' does not exist

D. No error, prints column 'C'

Solution

1. Step 1: Check DataFrame columns

   DataFrame has columns 'A' and 'B' only, no 'C'.

2. Step 2: Accessing missing column

   Trying to print df['C'] causes a KeyError because 'C' is not found.

3. Final Answer:

   KeyError because column 'C' does not exist -> Option C

4. Quick Check:

   Missing column access = KeyError = A [OK]

Hint: Access only existing columns to avoid KeyError [OK]

Common Mistakes:

• Assuming missing columns print empty
• Confusing KeyError with SyntaxError
• Ignoring error messages

5. You have a CSV file with sales data. Which pandas feature helps you quickly load and analyze this data?

medium

A. pd.read_csv() to load data and DataFrame methods to analyze

B. pd.plot() to create charts directly from CSV

C. pd.save_excel() to convert CSV to Excel

D. pd.clean_data() to fix all errors automatically

Solution

1. Step 1: Identify pandas function for CSV loading

   pd.read_csv() is the standard function to load CSV files into DataFrames.

2. Step 2: Use DataFrame methods for analysis

   Once loaded, DataFrame methods help explore and analyze data quickly.

3. Final Answer:

   pd.read_csv() to load data and DataFrame methods to analyze -> Option A

4. Quick Check:

   Load CSV + analyze = pd.read_csv + DataFrame [OK]

Hint: Use pd.read_csv() to load CSV files fast [OK]

Common Mistakes:

• Thinking pd.plot() loads data
• Believing pandas auto-fixes data errors
• Confusing saving and loading functions