Forward fill and backward fill in Data Analysis Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is forward fill in data analysis?

Forward fill is a method to fill missing data by copying the last known value forward until a new value appears.

beginner

What does backward fill do in a dataset?

Backward fill fills missing values by copying the next known value backward until a previous value is found.

beginner

How do you perform forward fill on a pandas DataFrame column named 'A'?

Use df['A'].fillna(method='ffill') to fill missing values forward in column 'A'.

intermediate

Why might you choose forward fill over backward fill?

Forward fill is useful when past values logically carry forward, like filling missing sensor readings with the last known measurement.

intermediate

Can forward fill and backward fill be combined? If yes, how?

Yes, you can first apply forward fill to fill missing values, then apply backward fill to fill any remaining missing values at the start of the data.

Which pandas method fills missing values by copying the previous value forward?

A fillna(method='bfill')

B dropna()

C fillna(method='ffill')

D interpolate()

fillna(method='ffill') copies the last known value forward to fill missing data.

What does backward fill do with missing data?

A Copies the previous value forward

B Copies the next value backward

C Drops missing rows

D Replaces missing with zero

Backward fill copies the next known value backward to fill missing data.

If a dataset starts with missing values, which fill method can fill those missing values?

A Backward fill only

B Forward fill only

C Neither forward nor backward fill

D Both forward and backward fill

Backward fill can fill missing values at the start by copying the next known value backward.

Which method is best when missing data should be filled with the last known measurement?

A Forward fill

B Random fill

C Mean imputation

D Backward fill

Forward fill is best when the last known measurement logically carries forward.

What is the pandas syntax to fill missing values backward in a DataFrame column 'B'?

A df['B'].dropna()

B df['B'].fillna(method='ffill')

C df['B'].fillna()

D df['B'].fillna(method='bfill')

fillna(method='bfill') fills missing values by copying the next known value backward.

Explain how forward fill and backward fill work to handle missing data in a dataset.

Think about how missing values can be filled using nearby known values in order.

Describe a real-life example where forward fill would be a better choice than backward fill.

Consider situations where the past value logically continues until updated.

Practice

1. What does forward fill do when handling missing data in a dataset?

easy

A. It removes rows with missing values.

B. It copies the next known value backward to fill missing spots.

C. It replaces missing values with zero.

D. It copies the last known value forward to fill missing spots.

Solution

1. Step 1: Understand forward fill concept

   Forward fill means filling missing data by copying the last known value forward to the next missing spot.

2. Step 2: Compare options with definition

   "It copies the last known value forward to fill missing spots." matches this definition exactly, while others describe different methods.

3. Final Answer:

   It copies the last known value forward to fill missing spots. -> Option D

4. Quick Check:

   Forward fill = copy last known value forward [OK]

Hint: Forward fill copies previous value forward to fill gaps [OK]

Common Mistakes:

• Confusing forward fill with backward fill
• Thinking forward fill removes missing data
• Assuming forward fill replaces with zero

2. Which of the following is the correct syntax to apply forward fill on a pandas DataFrame df?

easy

A. df.fillna(method='ffill')

B. df.fillna(method='bfill')

C. df.fillna(forward=True)

D. df.fillna(direction='forward')

Solution

1. Step 1: Recall pandas fillna syntax

   In pandas, forward fill is done by fillna(method='ffill').

2. Step 2: Check options for correct syntax

   df.fillna(method='ffill') matches the correct method name 'ffill'. df.fillna(method='bfill') performs backward fill. The remaining options use invalid syntax.

3. Final Answer:

   df.fillna(method='ffill') -> Option A

4. Quick Check:

   Forward fill method = 'ffill' [OK]

Hint: Use method='ffill' for forward fill in pandas [OK]

Common Mistakes:

• Using 'bfill' instead of 'ffill' for forward fill
• Passing invalid parameters like forward=True
• Confusing method names in fillna

3. Given the DataFrame df below, what will be the result of df.bfill()?

import pandas as pd
df = pd.DataFrame({'A': [1, None, None, 4, None]})
print(df.bfill())

medium

A. A
0 1.0
1 4.0
2 4.0
3 4.0
4 NaN

B. A
0 1.0
1 1.0
2 1.0
3 4.0
4 NaN

C. A
0 1.0
1 NaN
2 NaN
3 4.0
4 NaN

D. A
0 1.0
1 4.0
2 4.0
3 4.0
4 4.0

Solution

1. Step 1: Understand backward fill on given data

   Backward fill copies the next known value backward to fill missing spots. Here, missing values at index 1 and 2 get filled with 4.0 from index 3. The last missing at index 4 has no next value, so remains NaN.

2. Step 2: Match output with options

   A 0 1.0 1 4.0 2 4.0 3 4.0 4 NaN matches this result exactly. A 0 1.0 1 4.0 2 4.0 3 4.0 4 4.0 incorrectly fills last NaN with 4.0, others do not match.

3. Final Answer:

   A 0 1.0 1 4.0 2 4.0 3 4.0 4 NaN -> Option A

4. Quick Check:

   Backward fill fills missing with next known value [OK]

Hint: Backward fill uses next known value to fill missing [OK]

Common Mistakes:

• Assuming last NaN gets filled when no next value exists
• Confusing forward and backward fill results
• Misreading index positions in output

4. You run the code below but get an error. What is the mistake?

import pandas as pd
df = pd.DataFrame({'A': [None, 2, None]})
df.fillna(method='forward')

medium

A. fillna requires inplace=True to work.

B. DataFrame cannot have None values.

C. The method name 'forward' is invalid; should be 'ffill'.

D. fillna does not accept method parameter.

Solution

1. Step 1: Check fillna method parameter

   The valid method names are 'ffill' for forward fill and 'bfill' for backward fill. 'forward' is not valid.

2. Step 2: Identify cause of error

   Using 'forward' causes a ValueError. DataFrames can have None values, fillna does not require inplace=True, and it accepts the method parameter.

3. Final Answer:

   The method name 'forward' is invalid; should be 'ffill'. -> Option C

4. Quick Check:

   Use 'ffill' for forward fill method [OK]

Hint: Use 'ffill' not 'forward' as method name in fillna [OK]

Common Mistakes:

• Using 'forward' instead of 'ffill'
• Thinking inplace=True is mandatory
• Believing fillna can't handle None values

5. You have a DataFrame df with missing values scattered in column 'B'. You want to fill missing values by first forward filling, then backward filling any remaining missing values. Which code correctly does this?

hard

A. df['B'].fillna(method='ffill', method='bfill')

B. df['B'].fillna(method='ffill').fillna(method='bfill')

C. df['B'].fillna(method='bfill').fillna(method='ffill')

D. df['B'].fillna(method=['ffill', 'bfill'])

Solution

1. Step 1: Understand chaining fillna calls

   To fill missing values first forward then backward, chain fillna calls: first with method='ffill', then on result with method='bfill'.

2. Step 2: Evaluate options for correct chaining

   df['B'].fillna(method='ffill').fillna(method='bfill') correctly chains fillna twice. df['B'].fillna(method='bfill').fillna(method='ffill') reverses order. Attempting multiple methods in one call (duplicate kwargs or list) uses invalid syntax.

3. Final Answer:

   df['B'].fillna(method='ffill').fillna(method='bfill') -> Option B

4. Quick Check:

   Chain fillna with 'ffill' then 'bfill' [OK]

Hint: Chain fillna with 'ffill' then 'bfill' to fill all gaps [OK]

Common Mistakes:

• Trying to pass multiple methods in one fillna call
• Reversing forward and backward fill order
• Not chaining calls, so some NaNs remain