Plotting mean frequency
Lastly, we'll create a per-day average of the mentions of both hashtags and plot them across time. We'll first create proportions from the two boolean Series by the day, then we'll plot them.
matplotlib.pyplot has been imported as plt and ds_tweets has been loaded for you.
This exercise is part of the course
Analyzing Social Media Data in Python
Exercise instructions
- Generate the mean number of tweets with the
pythoncolumn with.resample()and.mean()methods..resample()takes one argument,'1 d', to produce daily averages. - Do the same with the
rstatscolumn. - Plot a line for
#pythonusage withmean_python. Usemean_python.index.dayas the x-axis. - Do the same with
mean_rstats.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Average of python column by day
mean_python = ____[____].____(____).____()
# Average of rstats column by day
mean_rstats = ____[____].____(____).____()
# Plot mean python by day(green)/mean rstats by day(blue)
plt.plot(____, ____, color = 'green')
plt.plot(____, ____, ____)
# Add labels and show
plt.xlabel('Day'); plt.ylabel('Frequency')
plt.title('Language mentions over time')
plt.legend(('#python', '#rstats'))
plt.show()