Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import matplotlib.pyplot as plt
- import matplotlib.dates as mdates
- df = pd.read_csv('My_df')
- for x in df.columns:
- if 'datetime' in df[x].ftype:
- dates = df[x].map(lambda x: x.strftime('%d-%m-%Y'))
- dfdates = pd.DataFrame({x: dates, 'Count': [1 for x in range(0, len(dates))]})
- dfdates = dfdates.groupby(x)['Count'].size().reset_index()
- fig, ax = plt.subplots(figsize=(15, 7))
- ax.bar(dfdates.index, dfdates['Count'])
- ax.xaxis.set_major_locator(mdates.WeekdayLocator())
- ax.xaxis.set_major_formatter(mdates.DateFormatter('%b %d'))
- ax.set_title(x)
- ax.set_ylabel('Count')
- ax.set_xlabel('Date')
- plt.show()
Add Comment
Please, Sign In to add comment