Main page example flights.groupby(['year', 'month', 'day']) using pandas only

[paulrougieux]

The main example in the readme could be re-written as such using only pandas:

import pandas
flights = pandas.read_csv('~/downloads/flights.csv')
df = (flights
      .groupby(['year', 'month', 'day'])
      .agg({'arr_delay': 'mean',
            'dep_delay': 'mean'})
      .query("arr_delay>30 & dep_delay>30")
     )

Note I exported the flights data set from R with

library(nycflights13)
write.csv(flights,"~/downloads/flights.csv",` row.names=FALSE)

[paulrougieux]

You can obviously add a rename with :

df.rename(columns={'arr_delay':'arr','dep_delay':'dep'})