1. Learn
    2. /
  2. Courses
    3. /
  3. Manipulating Time Series Data in Python

Exercise

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.

Instructions

100 XP

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.