利用groupby对数据进行求和或者求均值聚合

Handsome_zhou

1. data2 = {'id':['one','two','three','two','one','four'],'time':[10,23,12,34,54,12]}
   
2. 
   
3. import pandas as pd
   
4. pd.DataFrame(data2)#把字典类型转换成DataFrame类型
   
5. 
   
6. 
   
7. 
   
8. data2 = pd.DataFrame(data2)
   
9. data2.groupby('id').sum()#利用groupby和sum进行求和聚合操作
   
10. 
    
11. 
    
12. data2.groupby('id').mean()#利用groupby和mean进行求均值聚合操作
    
13. 

复制代码