pandas中分组/聚合函数的用法

一。对Series进行的聚合

df = pd.DataFrame({'key1': ['a', 'a', 'b', 'b', 'a'],
                  'key2': ['one', 'two', 'one', 'two', 'one'],
                  'data1': np.random.randint(1, 10, 5),
                  'data2': np.random.randint(1, 10, 5)})
df

grouped = df['data1'].groupby(df['key1']).mean()

以data1的数据用key1【键】进行分组,mean()聚合函数

---

自定义分组的键

key=[1,2,1,1,2]
df['data1'].groupby(key).mean()

多层分组

df['data1'].groupby([df['key1'], df['key2']]).mean()

对DataFrame的分组和series基本相同

means = df.groupby(['key1', 'key2']).mean()['data1']
d