Compare monthly average stock prices for Facebook and Google
Now, you'll apply your new resampling skills to daily stock price series for Facebook and Google for the 2015-2016 period to compare the trend of the monthly averages.
This exercise is part of the course
Manipulating Time Series Data in Python
Exercise instructions
We have again imported pandas
as pd
and matplotlib.pyplot
as plt
for you.
- Use
pd.read_csv()
to import'stocks.csv'
and set aDateTimeIndex
based on the'date'
column usingparse_dates
andindex_col
, assign the result tostocks
and inspect using.info()
. - Create
monthly_average
by applying.resample()
with monthly frequency todata
, using.mean()
to aggregate. Plot the result usingsubplots
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import and inspect data here
stocks = ____
print(___)
# Calculate and plot the monthly averages
monthly_average = ____