Get Started

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.

This is a part of the course

“Manipulating Time Series Data in Python”

View Course

Exercise instructions

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.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# 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(____)
Edit and Run Code