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 exercise is part of the course
Manipulating Time Series Data in Python
Exercise instructions
We have already imported pandas
as pd
for you. We have also defined start
and end
dates.
- Create
monthly_dates
usingpd.date_range
withstart
,end
and frequency alias'M'
. - Create and print the pd.Series
monthly
, passing the list[1, 2]
as thedata
argument, and usingmonthly_dates
asindex
. - Create
weekly_dates
usingpd.date_range
withstart
,end
and frequency alias'W'
. - Apply
.reindex()
tomonthly
three times: first without additional options, then withbfill
and then withffill
,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(____)