Reproducible analysis patterns in Data Analysis Python - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to import the pandas library with its common alias.

Data Analysis Python

import [1] as pd

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

Anumpy

Bpandas

Cmatplotlib

Dseaborn

Attempts:

3 left

💡 Hint

Common Mistakes

Using numpy instead of pandas

Forgetting the alias 'as pd'

Importing visualization libraries instead

We use import pandas as pd to import the pandas library with the alias pd, which is a common practice for easier code writing.

2fill in blank

medium

Complete the code to read a CSV file named 'data.csv' into a DataFrame.

Data Analysis Python

df = pd.[1]('data.csv')

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

Ato_csv

Bopen_csv

Cload_csv

Dread_csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using to_csv which writes files

Using load_csv which does not exist

Using open_csv which is not a pandas function

The function pd.read_csv() reads a CSV file into a pandas DataFrame.

3fill in blank

hard

Fix the error in the code to save the DataFrame 'df' to a CSV file named 'output.csv' without the index.

Data Analysis Python

df.to_csv('output.csv', [1]=False)

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

Aindex

Bno_index

Cinclude_index

Ddrop_index

Attempts:

3 left

💡 Hint

Common Mistakes

Using include_index which is not a valid parameter

Using no_index or drop_index which do not exist

Forgetting to set index to False

The parameter index=False tells pandas not to write row numbers to the CSV file.

4fill in blank

hard

Fill both blanks to create a reproducible random sample of 10 rows from DataFrame 'df'.

Data Analysis Python

sample_df = df.sample(n=[1], random_state=[2])

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

A10

B42

C100

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Not setting random_state causing different samples each run

Using too large or zero sample size

Confusing n with frac parameter

We use n=10 to select 10 rows and random_state=42 to make the sampling reproducible.

5fill in blank

hard

Fill all three blanks to create a dictionary comprehension that maps each word to its length only if the length is greater than 3.

Data Analysis Python

lengths = { [1]: [2] for [3] in words if len([3]) > 3 }

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

Aword

Blen(word)

Ditem

Attempts:

3 left

💡 Hint

Common Mistakes

Using different variable names inconsistently

Not filtering words with length greater than 3

Using len(item) without defining item

The comprehension uses word as the key, len(word) as the value, and iterates over word in words.

Practice

1. What is the main goal of reproducible analysis in data science?

easy

A. To ensure the analysis can be repeated with the same results

B. To make the code run faster

C. To use the latest software versions

D. To create complex visualizations

Solution

1. Step 1: Understand reproducible analysis meaning

   Reproducible analysis means you can run your work again and get the same results.

2. Step 2: Identify the main goal

   The main goal is to make sure the analysis is repeatable and reliable.

3. Final Answer:

   To ensure the analysis can be repeated with the same results -> Option A

4. Quick Check:

   Reproducible analysis = repeatable results [OK]

Hint: Focus on repeatability and consistent results [OK]

Common Mistakes:

• Thinking speed or software version is the main goal
• Confusing reproducibility with visualization quality

2. Which of the following is the correct way to define a function in Python for reproducible analysis?

easy

A. def load_data():
return pd.read_csv('data.csv')

B. function load_data() {
return read.csv('data.csv')
}

C. load_data() => pd.read_csv('data.csv')

D. def load_data:
return pd.read_csv('data.csv')

Solution

1. Step 1: Identify Python function syntax

   Python functions start with 'def', followed by name and parentheses, then a colon.

2. Step 2: Check each option

   def load_data(): return pd.read_csv('data.csv') uses correct Python syntax. function load_data() { return read.csv('data.csv') } is JavaScript style. load_data() => pd.read_csv('data.csv') is incorrect Python syntax. def load_data: return pd.read_csv('data.csv') misses parentheses after function name.

3. Final Answer:

   def load_data():\n return pd.read_csv('data.csv') -> Option A

4. Quick Check:

   Python function = def name(): [OK]

Hint: Remember Python functions use def name(): [OK]

Common Mistakes:

• Using JavaScript or other language syntax
• Omitting parentheses after function name
• Missing colon at the end of function definition

3. Given the code below, what will be the output of print(cleaned_data.shape)?

import pandas as pd

def load_data():
    return pd.DataFrame({'A': [1, 2, None], 'B': [4, None, 6]})

def clean_data(df):
    return df.dropna()

data = load_data()
cleaned_data = clean_data(data)
print(cleaned_data.shape)

medium

A. (2, 2)

B. (0, 2)

C. (3, 2)

D. (1, 2)

Solution

1. Step 1: Understand the data and cleaning

   Original data has 3 rows and 2 columns. Rows with null are dropped by dropna(). Only the first row has no null values.

2. Step 2: Count remaining rows and columns

   After dropna(), only 1 row remains with 2 columns, so shape is (1, 2).

3. Final Answer:

   (1, 2) -> Option D

4. Quick Check:

   dropna() removes rows with null = (1, 2) [OK]

Hint: dropna() removes rows with missing values [OK]

Common Mistakes:

• Counting rows with null as valid
• Confusing columns count
• Assuming dropna() removes columns

4. Identify the error in the following reproducible analysis script:

def analyze_data():
    data = pd.read_csv('data.csv')
    cleaned = data.dropna
    return cleaned.describe()

result = analyze_data()
print(result)

medium

A. Incorrect file path in read_csv

B. Missing parentheses after dropna method call

C. Missing return statement in function

D. print statement syntax error

Solution

1. Step 1: Check method usage in code

   dropna is a method and must be called with parentheses: dropna()

2. Step 2: Identify error effect

   Without parentheses, cleaned is a method object, not a DataFrame, causing error on describe() call.

3. Final Answer:

   Missing parentheses after dropna method call -> Option B

4. Quick Check:

   Method call needs () = error if missing [OK]

Hint: Always add () when calling methods [OK]

Common Mistakes:

• Forgetting parentheses on method calls
• Assuming dropna is a property, not a method
• Ignoring error messages about method objects

5. You want to create a reproducible analysis script that loads data, cleans it by removing rows with missing values, and then calculates the mean of column 'score'. Which of the following code snippets correctly implements this pattern?

hard

A. def load_data:
return pd.read_csv('data.csv')

clean_data = lambda df: df.dropna()
mean_score = clean_data(data)['score'].mean()
print(mean_score)

B. data = pd.read_csv('data.csv')
clean = data.dropna
mean_score = clean['score'].mean()
print(mean_score)

C. def load_data():
return pd.read_csv('data.csv')

def clean_data(df):
return df.dropna()

def analyze(df):
return df['score'].mean()

# Run full analysis
raw = load_data()
clean = clean_data(raw)
result = analyze(clean)
print(result)

D. def load_data():
return pd.read_csv('data.csv')

clean_data = data.dropna()
mean_score = clean_data['score'].mean()
print(mean_score)

Solution

1. Step 1: Check function definitions and calls

   def load_data(): return pd.read_csv('data.csv') def clean_data(df): return df.dropna() def analyze(df): return df['score'].mean() # Run full analysis raw = load_data() clean = clean_data(raw) result = analyze(clean) print(result) defines functions for loading, cleaning, and analyzing, then runs them in order, ensuring reproducibility.

2. Step 2: Verify correctness of each step

   Functions use correct syntax, dropna() is called properly, and mean is calculated on cleaned data.

3. Final Answer:

   The code that defines functions for loading, cleaning, and analyzing, then calls them sequentially -> Option C

4. Quick Check:

   Functions + proper calls = reproducible script [OK]

Hint: Use functions and call them in sequence [OK]

Common Mistakes:

• Forgetting parentheses on dropna()
• Not defining functions properly
• Using variables before assignment