Convert monthly to weekly data

You have learned in the video how to use .reindex() to conform an existing time series to a DateTimeIndex at a different frequency.

Let's practice this method by creating monthly data and then converting this data to weekly frequency while applying various fill logic options.

Diese Übung ist Teil des Kurses

Manipulating Time Series Data in Python

Kurs anzeigen

Anleitung zur Übung

We have already imported pandas as pd for you. We have also defined start and end dates.

Create monthly_dates using pd.date_range with start, end and frequency alias 'M'.
Create and print the pd.Series monthly, passing the list [1, 2] as the data argument, and using monthly_dates as index.
Create weekly_dates using pd.date_range with start, end and frequency alias 'W'.
Apply .reindex() to monthly three times: first without additional options, then with bfill and then with ffill, print()-ing each result.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

# Set start and end dates
start = '2016-1-1'
end = '2016-2-29'

# Create monthly_dates here
monthly_dates = ____

# Create and print monthly here
monthly = ____
print(____)

# Create weekly_dates here
weekly_dates = ____

# Print monthly, reindexed using weekly_dates
print(____)
print(____)
print(____)

Code bearbeiten und ausführen