text_plain_output_1.png image_output_1.png
import calendar

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

df = pd.read_excel('../input/flight_schedule.xlsx')

df.Date = pd.to_datetime(df.Date)
df.Time = df.Time.astype(str)
df.Time = pd.to_datetime(df.Time)

df['Weekday'] = df.Date.dt.weekday
df['Weekday'] = df['Weekday'].apply(lambda x: calendar.day_name[x])

weekdays_total = df.groupby('Weekday').size().plot.bar()
totals = []
for i in weekdays_total.patches:
    totals.append(i.get_height())
total = sum(totals)
for i in weekdays_total.patches:
    weekdays_total.text(i.get_x() + 0.0, i.get_height() - 0, i.get_height(), fontsize=12, color='black')