Set and change time series frequency
In the video, you have seen how to assign a frequency to a DateTimeIndex, and then change this frequency.
Now, you'll use data on the daily carbon monoxide concentration in NYC, LA and Chicago from 2005-17.
You'll set the frequency to calendar daily and then resample to monthly frequency, and visualize both series to see how the different frequencies affect the data.
This exercise is part of the course
Manipulating Time Series Data in Python
Exercise instructions
We have already imported pandas as pd and matplotlib.pyplot as plt and we have already loaded the co_cities.csv file in a variable co.
- Inspect
cousing.info(). - Use
.asfreq()to set the frequency to calendar daily. - Show a plot of
'co'usingsubplots=True. - Change the the frequency to monthly using the alias
'M'. - Show another plot of
cousingsubplots=True.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Inspect data
print(____)
# Set the frequency to calendar daily
co = ____
# Plot the data
# Set frequency to monthly
co = ____
# Plot the data