df_econsult.info()

df_econsult.PracticeID.value_counts()

plt.rcParams['figure.figsize'] = (8, 4) df_econsult['Date'].dt.weekday.value_counts().sort_index().plot(kind='bar', title='Brompton Health PCN - eConsults / WEEKDAY')

for p in practices: df_econsult[ (df_econsult.PracticeID == p) ]['Date'].dt.weekday.value_counts().sort_index().plot(kind='bar', title=f'{p} - eConsults per day of the week', color='#00AFBB') plt.show()

df_econsult.Consult.value_counts().head(20).plot(kind ='bar')

df_econsult['Diverted Reason'].value_counts().plot(kind='bar')

df_econsult['NEW_TIME'] = (df_econsult.Time.astype(str)) df_econsult['NEW_DATE'] = (df_econsult.Date.astype(str))

df_econsult['NEW_DATETIME'] = (df_econsult['NEW_DATE']+ " "+df_econsult['NEW_TIME'])

df_econsult['DATETIME_FORMAT'] = pd.to_datetime(df_econsult.NEW_DATETIME)

df_econsult.info()

df_econsult.DATETIME_FORMAT.dt.hour.value_counts().sort_index().plot(kind ='bar', title='eConsult by Hours', color='#F39C12')