DataFrame.groupby(by=None, axis=0, level=None, as_index=True, sort=True, group_keys=True, squeeze=False, **kwargs)
by–以哪一个字段聚合,
axis–横向 or 纵向,
as_index–是否作为索引
sort–是否排序
事例:
import pandas as pd
import numpy as np
dict_obj = {'key1' : ['a', 'b', 'a', 'b',
'a', 'b', 'a', 'a'],
'key2' : ['one', 'one', 'two', 'three',
'two', 'two', 'one', 'three'],
'data1': pd.Series(range(1, 9), dtype = "int32"),
'data2': np.random.randint(8,size=8)}
df_obj = pd.DataFrame(dict_obj)
print(df_obj)
df_obj.groupby(by='key2', axis=0, level=None, as_index=True, sort=True, group_keys=True, squeeze=False).sum()