Guest User

Untitled

a guest
Jan 16th, 2019
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. import pandas as pd
  2. import matplotlib.pyplot as plt
  3. import matplotlib.dates as mdates
  4.  
  5. df = pd.read_csv('My_df')
  6.  
  7. for x in df.columns:
  8. if 'datetime' in df[x].ftype:
  9. dates = df[x].map(lambda x: x.strftime('%d-%m-%Y'))
  10. dfdates = pd.DataFrame({x: dates, 'Count': [1 for x in range(0, len(dates))]})
  11. dfdates = dfdates.groupby(x)['Count'].size().reset_index()
  12.  
  13. fig, ax = plt.subplots(figsize=(15, 7))
  14. ax.bar(dfdates.index, dfdates['Count'])
  15. ax.xaxis.set_major_locator(mdates.WeekdayLocator())
  16. ax.xaxis.set_major_formatter(mdates.DateFormatter('%b %d'))
  17. ax.set_title(x)
  18. ax.set_ylabel('Count')
  19. ax.set_xlabel('Date')
  20. plt.show()
Add Comment
Please, Sign In to add comment