pandas tricks

 a list of aggregation function for groupby:

min, max, mean, median, sum, count, std, var, size, describe, nuniaue, idxmax, idxmin.

df.groupby([‘airline’, ‘weekday’])[‘cancelled’,’diverted’].agg([‘sum’,’mean’]).head()

df.groupby([‘airline’, ‘weekday’])[‘cancelled’,’diverted’].agg({“dist”:[‘sum’,’mean’]).head()