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.
Questo esercizio fa parte del corso
Manipulating Time Series Data in Python
Istruzioni dell'esercizio
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.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# Inspect data
print(____)
# Set the frequency to calendar daily
co = ____
# Plot the data
# Set frequency to monthly
co = ____
# Plot the data