df_econsult.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 1982 entries, 0 to 1981
Data columns (total 11 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 ODS code 1982 non-null object
1 Consult 1982 non-null object
2 Date 1982 non-null datetime64[ns]
3 Time 1982 non-null object
4 Day of week 1982 non-null object
5 Age 1970 non-null float64
6 Gender 1970 non-null object
7 Diverted 117 non-null object
8 Source 1982 non-null object
9 PracticeID 1982 non-null object
10 Diverted Reason 101 non-null object
dtypes: datetime64[ns](1), float64(1), object(9)
memory usage: 170.5+ KB
df_econsult.PracticeID.value_counts()
Female Mean Age: 38.383822363203805
Male Mean Age: 40.93088857545839
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()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 1982 entries, 0 to 1981
Data columns (total 15 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 ODS code 1982 non-null object
1 Consult 1982 non-null object
2 Date 1982 non-null datetime64[ns]
3 Time 1982 non-null object
4 Day of week 1982 non-null object
5 Age 1970 non-null float64
6 Gender 1970 non-null object
7 Diverted 117 non-null object
8 Source 1982 non-null object
9 PracticeID 1982 non-null object
10 Diverted Reason 101 non-null object
11 NEW_TIME 1982 non-null object
12 NEW_DATE 1982 non-null object
13 NEW_DATETIME 1982 non-null object
14 DATETIME_FORMAT 1982 non-null datetime64[ns]
dtypes: datetime64[ns](2), float64(1), object(12)
memory usage: 232.4+ KB
df_econsult.DATETIME_FORMAT.dt.hour.value_counts().sort_index().plot(kind ='bar', title='eConsult by Hours', color='#F39C12')