[Pandas] 根据某列分组进行求和

导入数据

import pandas as pd
 
df = pd.DataFrame([['A',12,0,0],
                   ['A',0,37,0],
                   ['A',0,0,18],
                   ['B',123,0,0],
                   ['B',110,49,61]
                  ], 
                   columns = ['team','value1','value2','value3'])

df

问题:  根据字段'team'分组分别对字段'value1'、'value2'和'value3'进行求和

# df = df.groupby(by=['team'])['value1','value2','value3'].sum().reset_index()

calculated_list = ['value1','value2','value3']
df = df.groupby(by=['team'])[calculated_list].sum().reset_index()

df

---

groupby分组聚合操作https://blog.youkuaiyun.com/Hudas/article/details/127961579