Why advanced operations handle complex data in Data Analysis Python - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a list of squares for numbers 1 to 5.

Data Analysis Python

squares = [x[1]2 for x in range(1, 6)]
print(squares)

Drag options to blanks, or click blank then click option'

A//

B+

C**

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '**' will add numbers instead of squaring.

Using '*' will multiply but not square correctly in this context.

The ** operator is used to raise a number to a power. Here, x**2 squares the number.

2fill in blank

medium

Complete the code to filter numbers greater than 3 from the list.

Data Analysis Python

numbers = [1, 2, 3, 4, 5]
greater_than_three = [n for n in numbers if n [1] 3]
print(greater_than_three)

Drag options to blanks, or click blank then click option'

A<

B>

C==

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' will filter numbers less than 3, which is incorrect here.

Using '==' will only select numbers equal to 3.

The operator > checks if a number is greater than another. Here, it filters numbers greater than 3.

3fill in blank

hard

Fix the error in the code to calculate the average of a list of numbers.

Data Analysis Python

data = [10, 20, 30, 40]
average = sum(data) [1] len(data)
print(average)

Drag options to blanks, or click blank then click option'

A/

B-

C+

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' or '-' will not calculate average correctly.

Using '*' multiplies instead of dividing.

To find the average, sum all numbers and divide by the count using /.

4fill in blank

hard

Fill both blanks to create a dictionary of word lengths for words longer than 3 letters.

Data Analysis Python

words = ['apple', 'bat', 'carrot', 'dog']
lengths = {word: [1] for word in words if len(word) [2] 3}
print(lengths)

Drag options to blanks, or click blank then click option'

Alen(word)

Bword

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using word instead of len(word) will store the word itself, not its length.

Using '<=' will select words with length 3 or less, which is incorrect.

The dictionary comprehension maps each word to its length using len(word). The condition len(word) > 3 filters words longer than 3 letters.

5fill in blank

hard

Fill both blanks to create a dictionary with uppercase keys and values greater than 10.

Data Analysis Python

data = {'a': 5, 'b': 15, 'c': 25}
result = {k[1]: v for k, v in data.items() if v [2] 10}
print(result)

Drag options to blanks, or click blank then click option'

A{

Bv

C>

Dk.upper()

Attempts:

3 left

💡 Hint

Common Mistakes

Not starting with '{' will cause syntax errors.

Using 'k' instead of 'k.upper()' keeps keys lowercase.

Using '<' or '<=' will filter wrong values.

The dictionary comprehension starts with {. The keys are converted to uppercase using k.upper(). The condition v > 10 filters values greater than 10.

Practice

1. Why do advanced operations help when working with complex data in data analysis?

easy

A. They only work with small datasets.

B. They simplify handling large and varied data efficiently.

C. They remove all data from the dataset.

D. They make data more complex and harder to understand.

Solution

1. Step 1: Understand the role of advanced operations

   Advanced operations are designed to manage and simplify complex data tasks.

2. Step 2: Connect to data complexity

   They help handle large, messy, or varied data efficiently, making analysis easier.

3. Final Answer:

   They simplify handling large and varied data efficiently. -> Option B

4. Quick Check:

   Advanced operations simplify complex data handling [OK]

Hint: Advanced operations simplify big, messy data fast [OK]

Common Mistakes:

• Thinking advanced operations make data more complex
• Believing they only work on small datasets
• Assuming they delete data

2. Which of the following is the correct syntax to import the pandas library in Python for advanced data operations?

easy

A. import panda as pd

B. import pd as pandas

C. from pandas import *

D. import pandas as pd

Solution

1. Step 1: Recall standard pandas import syntax

   The common and correct way is to import pandas as pd for easy reference.

2. Step 2: Check each option

   import pandas as pd matches the standard syntax; others have errors or reversed names.

3. Final Answer:

   import pandas as pd -> Option D

4. Quick Check:

   Standard pandas import = import pandas as pd [OK]

Hint: Remember: pandas as pd is standard import [OK]

Common Mistakes:

• Misspelling 'pandas' as 'panda'
• Reversing import syntax
• Using wildcard import unnecessarily

3. What will be the output of this code snippet using pandas for advanced data handling?

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

medium

A. [4, 5, 6]

B. [1, 2, 3, 4, 5, 6]

C. [5, 7, 9]

D. Error: Cannot add columns directly

Solution

1. Step 1: Understand DataFrame and column addition

   Adding two columns in pandas adds their values element-wise.

2. Step 2: Calculate the sum for each row

   Row sums: 1+4=5, 2+5=7, 3+6=9, resulting in [5, 7, 9].

3. Final Answer:

   [5, 7, 9] -> Option C

4. Quick Check:

   Element-wise addition of columns = [5, 7, 9] [OK]

Hint: Adding columns sums values row-wise [OK]

Common Mistakes:

• Thinking columns concatenate instead of add
• Expecting a single sum value
• Assuming syntax error on addition

4. Identify the error in this code that tries to filter rows where column 'Age' is greater than 30 using pandas:

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

medium

A. No error; code runs correctly and filters rows.

B. Syntax error due to missing parentheses in condition.

C. AttributeError because 'Age' is not accessed correctly.

D. TypeError because comparison uses wrong operator.

Solution

1. Step 1: Check pandas filtering syntax

   Using df[df.Age > 30] is valid syntax to filter rows where Age > 30.

2. Step 2: Confirm no errors in code

   Code runs without error and returns rows with Age 35 only.

3. Final Answer:

   No error; code runs correctly and filters rows. -> Option A

4. Quick Check:

   Correct pandas filtering syntax = no error [OK]

Hint: Use df[df.Column > value] to filter rows [OK]

Common Mistakes:

• Using df.Age() instead of df.Age
• Forgetting to use brackets for filtering
• Using wrong comparison operators

5. You have a nested list of sales data for different stores:

sales = [[100, 200], [150, 250], [300, 400]]

Using advanced operations, which code correctly creates a flat list of all sales amounts?

hard

A. [amount for store in sales for amount in store]

B. [store + amount for store in sales for amount in store]

C. [sales[i] for i in range(len(sales))]

D. [sum(sales)]

Solution

1. Step 1: Understand nested list structure

   sales is a list of lists, each inner list has sales amounts for a store.

2. Step 2: Use nested comprehension to flatten

   List comprehension with two for loops extracts each amount from each store into one list.

3. Final Answer:

   [amount for store in sales for amount in store] -> Option A

4. Quick Check:

   Nested comprehension flattens nested lists [OK]

Hint: Use nested loops in comprehension to flatten lists [OK]

Common Mistakes:

• Trying to add lists and numbers directly
• Using single loop that returns sublists
• Using sum() incorrectly on list of lists