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”
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(____)