Why Python is the top choice for data analysis in Data Analysis Python - See It in Action

Why Python is the Top Choice for Data Analysis

📖 Scenario: Imagine you are a new data analyst at a company. Your manager asks you to understand why Python is the best tool for analyzing data. You will explore simple data and see how Python helps make data analysis easy and clear.

🎯 Goal: You will create a small data set, set a threshold to filter data, use a loop to find values above the threshold, and print the results. This will show why Python is great for data analysis.

📋 What You'll Learn

Create a dictionary with exact data values

Create a threshold variable

Use a for loop with specific variable names to filter data

Print the filtered results exactly

💡 Why This Matters

🌍 Real World

Data analysts often need to filter and summarize data quickly. Python lets them do this with simple code that is easy to read and change.

💼 Career

Knowing how to handle data with Python is a key skill for data analyst jobs. It helps you work efficiently and communicate results clearly.

1

Create the data dictionary

Create a dictionary called sales_data with these exact entries: 'January': 150, 'February': 200, 'March': 170, 'April': 220, 'May': 180.

Data Analysis Python

# Create the sales_data dictionary with given month and sales values
# Your code here

Hint

Use curly braces {} to create a dictionary. Each entry has a month as a key and a number as a value.

2

Set the sales threshold

Create a variable called threshold and set it to 180.

Data Analysis Python

sales_data = {'January': 150, 'February': 200, 'March': 170, 'April': 220, 'May': 180}
# Create the threshold variable with value 180
# Your code here

Hint

Just assign the number 180 to the variable named threshold.

3

Filter months with sales above threshold

Create an empty list called high_sales_months. Use a for loop with variables month and sales to iterate over sales_data.items(). Inside the loop, add month to high_sales_months if sales is greater than threshold.

Data Analysis Python

sales_data = {'January': 150, 'February': 200, 'March': 170, 'April': 220, 'May': 180}
threshold = 180
# Create an empty list high_sales_months
# Use a for loop with month, sales in sales_data.items()
# Add month to high_sales_months if sales > threshold
# Your code here

Hint

Remember to create an empty list first. Then use a for loop with the exact variable names. Use an if statement to check sales against threshold.

4

Print the filtered months

Write a print statement to display the high_sales_months list.

Data Analysis Python

sales_data = {'January': 150, 'February': 200, 'March': 170, 'April': 220, 'May': 180}
threshold = 180
high_sales_months = []
for month, sales in sales_data.items():
    if sales > threshold:
        high_sales_months.append(month)
# Print the high_sales_months list
# Your code here

Hint

Use print(high_sales_months) to show the list of months with sales above 180.

Practice

1. Why is Python considered a top choice for data analysis?

easy

A. It is the fastest programming language

B. It has many libraries that make data handling easy

C. It only works with small datasets

D. It requires complex syntax to analyze data

Solution

1. Step 1: Understand Python's libraries for data

   Python offers libraries like pandas and NumPy that simplify data handling and analysis.

2. Step 2: Compare other options

   Options A, C, and D are incorrect because Python is not the fastest language, works with large datasets, and has simple syntax.

3. Final Answer:

   It has many libraries that make data handling easy -> Option B

4. Quick Check:

   Python's libraries = Easy data analysis [OK]

Hint: Remember: Python's strength is its helpful libraries [OK]

Common Mistakes:

• Thinking Python is the fastest language
• Believing Python only works with small data
• Assuming Python syntax is complex

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

easy

A. from pandas import pd

B. import pandas from pd

C. import pandas as pd

D. import pd as pandas

Solution

1. Step 1: Recall Python import syntax

   The correct syntax to import a library with an alias is 'import library as alias'.

2. Step 2: Match with options

   import pandas as pd matches this syntax. Options B, C, and D have incorrect order or keywords.

3. Final Answer:

   import pandas as pd -> Option C

4. Quick Check:

   Correct import syntax = import pandas as pd [OK]

Hint: Use 'import library as alias' to shorten names [OK]

Common Mistakes:

• Using 'import pandas from pd' which is invalid
• Confusing 'from' and 'import' order
• Trying to alias the library incorrectly

3. What will be the output of this Python code?

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

medium

A. (2, 2)

B. (2, 4)

C. (4, 2)

D. (1, 2)

Solution

1. Step 1: Understand DataFrame shape

   The DataFrame has 2 rows and 2 columns from the dictionary keys and lists.

2. Step 2: Check the shape attribute

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

3. Final Answer:

   (2, 2) -> Option A

4. Quick Check:

   Rows and columns count = (2, 2) [OK]

Hint: DataFrame shape = (rows, columns) [OK]

Common Mistakes:

• Confusing rows with columns count
• Expecting shape to return data values
• Misreading dictionary structure

4. Find the error in this Python code for data analysis:

import numpy as np
arr = np.array([1, 2, 3])
print(arr.sum())

medium

A. No error, code runs correctly

B. Incorrect import statement

C. Missing parentheses in np.array

D. sum() is not a valid method for numpy arrays

Solution

1. Step 1: Check import and array creation

   Importing numpy as np and creating an array with np.array() is correct.

2. Step 2: Verify sum method usage

   Calling arr.sum() correctly computes the sum of array elements.

3. Final Answer:

   No error, code runs correctly -> Option A

4. Quick Check:

   Correct numpy usage = No error, code runs correctly [OK]

Hint: numpy arrays have sum() method for totals [OK]

Common Mistakes:

• Thinking sum() is invalid for numpy arrays
• Assuming import statement is wrong
• Missing parentheses in array creation

5. You want to quickly visualize data trends using Python. Which library is best suited for this task?

medium

A. flask

B. scikit-learn

C. requests

D. matplotlib

Solution

1. Step 1: Identify libraries for visualization

   matplotlib is a popular Python library for creating charts and graphs.

2. Step 2: Eliminate unrelated libraries

   scikit-learn is for machine learning, requests for web requests, flask for web apps, so they don't fit visualization.

3. Final Answer:

   matplotlib -> Option D

4. Quick Check:

   Visualization library = matplotlib [OK]

Hint: Use matplotlib for quick data charts [OK]

Common Mistakes:

• Confusing scikit-learn with visualization
• Choosing web libraries for data plotting
• Not knowing matplotlib's purpose