Why Pandas for data analysis - See It in Action

Why Pandas for Data Analysis

📖 Scenario: Imagine you work in a small store. You have a list of sales data with product names and amounts sold. You want to understand this data quickly and easily.

🎯 Goal: You will create a simple table of sales data using Pandas, set a filter to find products with sales above a certain number, and then display those filtered results.

📋 What You'll Learn

Create a Pandas DataFrame with exact sales data

Create a variable to hold the sales threshold

Use Pandas filtering to select products with sales above the threshold

Print the filtered DataFrame

💡 Why This Matters

🌍 Real World

Stores and businesses use Pandas to quickly analyze sales data and make decisions.

💼 Career

Data analysts and scientists use Pandas daily to clean, filter, and explore data efficiently.

1

Create the sales data table

Import the pandas library as pd. Then create a DataFrame called sales_data with two columns: 'Product' and 'Sales'. Use these exact entries: 'Apples' with 50, 'Bananas' with 30, 'Cherries' with 20, 'Dates' with 15, and 'Elderberries' with 5.

Pandas

import pandas as pd
# Create the sales_data DataFrame with the exact products and sales
# Your code here

Hint

Use pd.DataFrame with a dictionary where keys are column names and values are lists of data.

2

Set the sales threshold

Create a variable called threshold and set it to 20. This will help us find products with sales greater than this number.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Product': ['Apples', 'Bananas', 'Cherries', 'Dates', 'Elderberries'],
    'Sales': [50, 30, 20, 15, 5]
})
# Create the threshold variable and set it to 20
# Your code here

Hint

Just assign the number 20 to a variable named threshold.

3

Filter products with sales above the threshold

Create a new DataFrame called filtered_sales by selecting rows from sales_data where the 'Sales' value is greater than threshold.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Product': ['Apples', 'Bananas', 'Cherries', 'Dates', 'Elderberries'],
    'Sales': [50, 30, 20, 15, 5]
})
threshold = 20
# Filter sales_data to get products with Sales > threshold
# Your code here

Hint

Use sales_data[sales_data['Sales'] > threshold] to filter the rows.

4

Display the filtered sales data

Print the filtered_sales DataFrame to see the products with sales above the threshold.

Pandas

import pandas as pd
sales_data = pd.DataFrame({
    'Product': ['Apples', 'Bananas', 'Cherries', 'Dates', 'Elderberries'],
    'Sales': [50, 30, 20, 15, 5]
})
threshold = 20
filtered_sales = sales_data[sales_data['Sales'] > threshold]
# Print the filtered_sales DataFrame
# Your code here

Hint

Use print(filtered_sales) to show the filtered table.

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