Rolling window calculations in Data Analysis Python - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the rolling mean with a window size of 3.

Data Analysis Python

import pandas as pd

data = pd.Series([1, 2, 3, 4, 5])
rolling_mean = data.[1](3).mean()
print(rolling_mean)

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

Arolling_window

Brolling_mean

Crolling

Dwindow

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'rolling_mean' instead of 'rolling' causes an AttributeError.

Using 'window' or 'rolling_window' are not valid pandas methods.

The rolling method creates a rolling window object to perform calculations like mean.

2fill in blank

medium

Complete the code to calculate the rolling sum with a window size of 4.

Data Analysis Python

import pandas as pd

data = pd.Series([10, 20, 30, 40, 50])
rolling_sum = data.rolling([1]).sum()
print(rolling_sum)

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

A4

B3

C2

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a window size smaller or larger than 4 changes the result.

Passing the window size as a string instead of an integer.

The window size is 4, so we pass 4 to the rolling method.

3fill in blank

hard

Fix the error in the code to calculate the rolling median with a window size of 3.

Data Analysis Python

import pandas as pd

data = pd.Series([5, 3, 8, 7, 10])
rolling_median = data.rolling(3).[1]()
print(rolling_median)

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

Amedian

Bmean

Csum

Dmode

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'mean' calculates the average, not the median.

Using 'sum' adds values instead of finding the median.

Using 'mode' is not supported directly on rolling objects.

The median method calculates the median of values in the rolling window.

4fill in blank

hard

Fill both blanks to create a rolling window of size 2 and calculate the maximum value in each window.

Data Analysis Python

import pandas as pd

data = pd.Series([4, 7, 1, 8, 5])
rolling_max = data.[1]([2]).max()
print(rolling_max)

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

Arolling

B3

C2

Dwindow

Attempts:

3 left

💡 Hint

Common Mistakes

Using window size 3 instead of 2 changes the output.

Using 'window' instead of 'rolling' causes an error.

Use rolling to create the window and pass 2 as the window size to calculate max over 2 elements.

5fill in blank

hard

Fill all three blanks to create a rolling window of size 3, calculate the minimum value, and assign it to a new variable.

Data Analysis Python

import pandas as pd

data = pd.Series([9, 2, 6, 3, 7])
rolling_min = data.[1]([2]).[3]()
print(rolling_min)

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

Arolling

B3

Cmin

Dmax

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'max' instead of 'min' returns the maximum values.

Using wrong window size changes the results.

Use rolling with window size 3 and call min() to get the minimum in each window.

Practice

1. What does the rolling(window=3).mean() function do on a data series?

easy

A. Calculates the average of every group of 3 consecutive values in the series

B. Calculates the sum of all values in the series

C. Returns the maximum value in the entire series

D. Sorts the series in ascending order

Solution

1. Step 1: Understand rolling window

   The rolling function with window=3 looks at every group of 3 consecutive values in the series.

2. Step 2: Apply mean function

   For each group of 3 values, mean() calculates their average, producing a smoothed series.

3. Final Answer:

   Calculates the average of every group of 3 consecutive values in the series -> Option A

4. Quick Check:

   Rolling mean = average over window [OK]

Hint: Rolling mean smooths data by averaging fixed-size groups [OK]

Common Mistakes:

• Thinking it sums all values instead of averaging groups
• Confusing rolling mean with overall mean
• Assuming it sorts or finds max values

2. Which of the following is the correct syntax to calculate a rolling sum with a window size of 4 on a pandas Series named data?

easy

A. data.rolling(4).sum

B. rolling(data, window=4).sum()

C. data.rolling(window=4).sum()

D. data.rolling_sum(window=4)

Solution

1. Step 1: Recall pandas rolling syntax

   The rolling function requires the window size as a named argument: rolling(window=4).

2. Step 2: Apply sum function correctly

   After rolling, call sum() to get the rolling sum over each window.

3. Final Answer:

   data.rolling(window=4).sum() -> Option C

4. Quick Check:

   Correct rolling sum syntax uses rolling(window=) [OK]

Hint: Use rolling(window=) with function, not rolling_sum() [OK]

Common Mistakes:

• Omitting 'window=' keyword argument
• Using non-existent rolling_sum method
• Calling rolling as a standalone function

3. Given the pandas Series data = pd.Series([2, 4, 6, 8, 10]), what is the output of data.rolling(window=2).sum()?

medium

A. [2, 6, 12, 20, 30]

B. [2, 4, 6, 8, 10]

C. [NaN, 3, 5, 7, 9]

D. [NaN, 6, 10, 14, 18]

Solution

1. Step 1: Understand rolling sum with window=2

   Each value is the sum of the current and previous value. The first value has no previous, so result is NaN.

2. Step 2: Calculate sums step-by-step

   Positions: NaN (no previous), 2+4=6, 4+6=10, 6+8=14, 8+10=18.

3. Final Answer:

   [NaN, 6, 10, 14, 18] -> Option D

4. Quick Check:

   Rolling sum window=2 sums pairs [OK]

Hint: First rolling sum is NaN, then sums of pairs follow [OK]

Common Mistakes:

• Ignoring NaN for first value
• Confusing sum with mean
• Adding values cumulatively instead of rolling pairs

4. What is wrong with this code snippet for calculating a rolling mean with window size 3 on a pandas DataFrame column df['values']?

rolling_means = df.rolling(3).mean()['values']

medium

A. The window size must be passed as a string, not an integer

B. The rolling function should be applied on the column, not the whole DataFrame

C. The mean() function cannot be used after rolling()

D. The syntax is correct and will work without errors

Solution

1. Step 1: Identify rolling application target

   Rolling should be applied on the Series (column) directly, not on the entire DataFrame.

2. Step 2: Correct the code

   Use df['values'].rolling(3).mean() to get rolling mean of that column.

3. Final Answer:

   The rolling function should be applied on the column, not the whole DataFrame -> Option B

4. Quick Check:

   Apply rolling on Series, not DataFrame for single column [OK]

Hint: Apply rolling on the column Series, not the whole DataFrame [OK]

Common Mistakes:

• Applying rolling on DataFrame then selecting column
• Passing window size as string
• Thinking mean() is invalid after rolling

5. You have daily sales data in a pandas Series sales. You want to calculate a 7-day rolling average but only for days where the window is fully available (no partial windows). Which parameter should you set in rolling() to achieve this?

hard

A. min_periods=7

B. center=True

C. window=7, min_periods=1

D. window=7, center=False

Solution

1. Step 1: Understand min_periods parameter

   min_periods sets the minimum number of observations in window required to have a value.

2. Step 2: Set min_periods=7 for full windows only

   Setting min_periods=7 means rolling average is calculated only when all 7 days are present, avoiding partial windows.

3. Final Answer:

   min_periods=7 -> Option A

4. Quick Check:

   min_periods=window size ensures full window data [OK]

Hint: Use min_periods equal to window size for full windows only [OK]

Common Mistakes:

• Using min_periods=1 allows partial windows
• Confusing center parameter with min_periods
• Not setting min_periods at all