import pandas as pd
import numpy as np
df = pd.DataFrame({'key1':list('aabba'),
'key2': ['one','two','one','two','one'],
'data1': ['1','3','5','7','9'],
'data2': ['2','4','6','8','10']})
print(df)
grouped1 = df['data1'].astype(float).groupby(df['key1']).mean() #先将data1转换成浮点型,然后分组求均值
print(grouped1)
key1 key2 data1 data2
0 a one 1 2
1 a two 3 4
2 b one 5 6
3 b two 7 8
4 a one 9 10
key1
a 4.333333
b 6.000000
Name: data1, dtype: float64
Process finished with exit code 0
假设我要对均值再除以10