Missing data strategies decision in Pandas - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the simplest way to handle missing data in a dataset?

The simplest way is to remove rows or columns that contain missing values using methods like dropna() in pandas.

beginner

What does 'imputation' mean in the context of missing data?

Imputation means filling in missing values with estimated ones, such as the mean, median, or a constant value.

intermediate

When should you prefer imputing missing data instead of dropping it?

Imputation is preferred when dropping data would cause loss of too much information or bias the results.

beginner

What pandas function can you use to fill missing values with the column mean?

You can use df['column'].fillna(df['column'].mean()) to replace missing values in a column with its mean.

intermediate

Name one risk of using mean imputation for missing data.

Mean imputation can reduce data variability and may bias the analysis if data is not missing at random.

Which pandas method removes rows with missing values?

A replace()

B fillna()

C isnull()

D dropna()

dropna() removes rows or columns with missing values.

What is a common strategy to fill missing numeric data?

A Remove all data

B Fill with string 'missing'

C Fill with mean

D Fill with random text

Filling missing numeric data with the mean is a common imputation method.

When is dropping missing data NOT a good idea?

A When missing data is rare

B When missing data is large and important

C When data is complete

D When data is categorical

Dropping data is bad if it causes loss of important information.

Which pandas method fills missing values with a specified value?

A fillna()

B dropna()

C isnull()

D notnull()

fillna() replaces missing values with a given value.

What is a potential downside of mean imputation?

A Reduces data variability and may bias results

B Removes all missing data

C Increases data variability

D Creates new missing values

Mean imputation reduces variability and can bias analysis.

Explain the main strategies to handle missing data and when to use each.

Think about removing vs filling missing values and their effects.

Describe how to use pandas to fill missing values with the mean of a column.

Focus on pandas functions for imputation.

Practice

1.

What is the main purpose of using dropna() in pandas?

easy

A. To remove rows or columns that contain missing data

B. To replace missing data with zeros

C. To fill missing data with the mean value

D. To convert data types of columns

Solution

1. Step 1: Understand dropna() function

   dropna() removes rows or columns that have missing values (NaN).

2. Step 2: Compare with other options

   Replacing missing data or converting data types are done by other functions like fillna() or astype().

3. Final Answer:

   To remove rows or columns that contain missing data -> Option A

4. Quick Check:

   dropna() removes missing data rows/columns [OK]

Hint: Remember: dropna drops missing data, fillna fills it [OK]

Common Mistakes:

• Confusing dropna with fillna
• Thinking dropna fills missing values
• Assuming dropna changes data types

2.

Which of the following is the correct syntax to fill missing values in a DataFrame df with the value 0?

?

easy

A. df.fillna(0)

B. df.dropna(0)

C. df.fill(na=0)

D. df.replace(na=0)

Solution

1. Step 1: Recall fillna syntax

   The correct method to fill missing values is fillna() with the value as argument.

2. Step 2: Check each option

   df.fillna(0) uses df.fillna(0) which is correct. Others have wrong method names or parameters.

3. Final Answer:

   df.fillna(0) -> Option A

4. Quick Check:

   Use fillna(value) to fill missing values [OK]

Hint: fillna fills missing values; dropna removes rows/columns [OK]

Common Mistakes:

• Using dropna instead of fillna
• Wrong method name like fill() or replace()
• Passing parameters incorrectly

3.

Given the DataFrame df below, what will be the output of df.fillna(method='ffill')?

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

medium

A. Removes rows with missing values

B. Fills missing values with zero

C. Fills missing values by propagating last valid observation forward

D. Raises an error due to wrong method

Solution

1. Step 1: Understand forward fill method

   method='ffill' fills missing values by copying the last known non-missing value forward.

2. Step 2: Apply to DataFrame

   For column A: 1 stays, None becomes 1, 3 stays, None becomes 3. For B: None stays None (no previous), 2 stays, None becomes 2, 4 stays.

3. Final Answer:

   Fills missing values by propagating last valid observation forward -> Option C

4. Quick Check:

   ffill copies last valid value forward [OK]

Hint: ffill copies previous value forward to fill NaNs [OK]

Common Mistakes:

• Thinking fillna(method='ffill') fills with zero
• Confusing ffill with dropping rows
• Expecting error from method parameter

4.

What is wrong with the following code if the goal is to remove all rows with missing data from DataFrame df?

df.fillna(drop=True)

medium

A. The code should use df.dropna(inplace=True) to modify in place

B. fillna() does not have a drop parameter; use dropna() instead

C. The parameter drop=True should be dropna=True

D. The code is correct and will remove rows with missing data

Solution

1. Step 1: Check method and parameters

   fillna() is for filling missing values and does not accept a drop parameter.

2. Step 2: Correct method for removing rows

   To remove rows with missing data, use dropna() instead.

3. Final Answer:

   fillna() does not have a drop parameter; use dropna() instead -> Option B

4. Quick Check:

   Use dropna() to remove missing data rows [OK]

Hint: Use dropna() to remove rows, fillna() to replace values [OK]

Common Mistakes:

• Using fillna() with invalid parameters
• Confusing fillna and dropna functions
• Expecting fillna to remove rows

5.

You have a DataFrame df with many missing values scattered randomly. You want to keep as much data as possible but avoid rows with more than 2 missing values. Which pandas method and parameter combination is best?

hard

A. Use df.fillna(method='bfill') to fill missing values backward

B. Use df.fillna(0) to replace all missing values with zero

C. Use df.dropna(axis=1) to drop columns with missing values

D. Use df.dropna(thresh=len(df.columns)-2) to drop rows with more than 2 missing values

Solution

1. Step 1: Understand the threshold parameter

   dropna(thresh=n) keeps rows with at least n non-missing values.

2. Step 2: Calculate threshold for max 2 missing values

   If total columns are len(df.columns), then rows must have at least len(df.columns) - 2 non-missing values to keep.

3. Step 3: Evaluate other options

   Filling with zero or backward fill changes data but does not drop rows. Dropping columns removes data unnecessarily.

4. Final Answer:

   Use df.dropna(thresh=len(df.columns)-2) to drop rows with more than 2 missing values -> Option D

5. Quick Check:

   dropna(thresh) keeps rows with enough non-NaNs [OK]

Hint: Use dropna(thresh) to keep rows with few missing values [OK]

Common Mistakes:

• Using fillna instead of dropping rows
• Dropping columns instead of rows
• Misunderstanding thresh parameter