xxxxxxxxxx
df1 = df.groupby(['Airline','DayOfWeek'], as_index=False)['id'].agg('count').reset_index()
df1.pivot(index = ['Airline'], columns = 'DayOfWeek', values = 'id').reset_index()
xxxxxxxxxx
# 30. Summarise using groupby and pivot
df1 = df.groupby(['Airline','DayOfWeek'], as_index=False)['id'].agg('count').reset_index()
df1.pivot(index = ['Airline'], columns = 'DayOfWeek', values = 'id').reset_index()