group by aggregate pandas code example
Example 1: pandas groupby aggregate quantile
# 50th Percentile
def q50(x):
return x.quantile(0.5)
# 90th Percentile
def q90(x):
return x.quantile(0.9)
my_DataFrame.groupby(['AGGREGATE']).agg({'MY_COLUMN': [q50, q90, 'max']})
Example 2: how can i aggregate without group by in pandas
df.groupby(lambda _ : True).agg(new_col_name = ('col_name', 'agg_function'))