User Tools

Site Tools


data:pandas_groupby

This is an old revision of the document!


how to group dataframe by date on multiple cplumns

df1 = a.groupby(['date'])['price'].agg(['first','max', 'min', 'last'])
df2 = a.groupby(['date'])['volume'].agg(['sum'])
df3 = pd.concat([df1, df2[['sum']]], axis=1)
df3.head()
 
df3a = a.groupby('date').agg({'price': ['first','max', 'min', 'last'],'volume': ['sum']})
data/pandas_groupby.1520864894.txt.gz · Last modified: by aistis