Smoothed daily downloads

MediumAppleresamplerolling· 20 XP

Daily download counts jump around with weekends and promotions. The App Store team tracks a 7-day moving average instead.

From downloads.csv, keep iPhone downloads that are not re-downloads (is_redownload is False). Count them per day with resample("D"), then store the 7-day rolling average, rounded to 1 decimal, as a Series. The first 6 days have no full window, so they're missing.

Expected answer

Store your answer in result.

Hints, the later steps and the answer come with Pro.

import pandas as pd

downloads = pd.read_csv("downloads.csv", parse_dates=["downloaded_at"])
result = ...