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])

cats = ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday']
df['Weekday'] = df['Weekday'].astype('category', categories=cats, ordered=True)
df