pandas groupby同时计算字符串与数值型的问题
groupby 同时对字符串与数值型数据进行求和时,只能对数值型求和。
import pandas as pd
data = pd.DataFrame({'A':[1,1,2,2,2],'B':[1,2,3,4,5],'C':['1','2','3','4','5']})
data
data.info()
data.groupby(['A'])['B','C'].sum().reset_index()
data['C'] = data['C'].astype(int)
data.info()
data.groupby(['A'])['B','C'].sum().reset_index()