Skip to content

Instantly share code, notes, and snippets.

@loganwilliams
Created April 22, 2021 17:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save loganwilliams/405062de4b4c5aac6c128538d114a772 to your computer and use it in GitHub Desktop.
Save loganwilliams/405062de4b4c5aac6c128538d114a772 to your computer and use it in GitHub Desktop.
twint = pd.read_csv('tweets.csv', sep='\t', parse_dates=['created_at'])
twint['o2'] = twint['tweet'].apply(lambda v: 'oxygen' in v.lower() or 'o2' in v.lower())
grp = twint.groupby(pd.Grouper(freq='4H', key='created_at'))
plt.figure(figsize=(6,3))
plt.fill_between(grp.count().index, 0.25*grp.count()['id'], color="#fc8d62", alpha=1.0)
plt.fill_between(grp.sum().index, 0.25*grp.sum()['o2'], color='#7570b3', alpha=1.0)
plt.xlim(pd.to_datetime('2021-03-10'), pd.to_datetime('2021-04-22 16:00'))
plt.ylabel('Unique tweets per hour')
plt.legend(['Tweets containing "delhi" and "urgent"', 'Tweets also containing "oxygen"'], loc='upper left')
plt.tight_layout()
plt.savefig('India.png', dpi=300)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment