Numerical Computing with Python

How to do it...

1. Read in the flights dataset; write a statement to find the total and average miles flown; and the maximum and minimum arrival delay for each airline for each weekday:

>>> flights = pd.read_csv('data/flights.csv')>>> airline_info = flights.groupby(['AIRLINE', 'WEEKDAY'])\                          .agg({'DIST':['sum', 'mean'],                                 'ARR_DELAY':['min', 'max']}) \                          .astype(int)>>> airline_info.head(7)

2. Both the rows and columns are labeled by a MultiIndex with two levels. Let's squash it down to just a single level. To address the columns, we use the MultiIndex method, get_level_values. Let's display the output of each level and then concatenate both levels ...