pandas中的groupby在组合具有NaN [duplicate]的列时出错

2ic8powd 于 2023-09-29 发布在其他

关注(0)|答案(1)|浏览(243)

此问题已在此处有答案：

Change column type in pandas（16个回答）
5天前关闭。
我有下面的 Dataframe ，我想合并三列["Area (ha)", "Yield (tn per ha)", "Production (tn)"]，这样就不存在NaN：

Country Crop    Season  Year    Area    Yield   Production
0   Argentina   maize   1   2000    3088715     
22  Argentina   maize   1   2000    3088715     
44  Argentina   maize   1   2000    3088715     
66  Argentina   maize   1   2000    3088715     
88  Argentina   maize   1   2000    3088715     
110 Argentina   maize   1   2000    3088715     
132 Argentina   maize   1   2000    3088715     
154 Argentina   maize   1   2000    3088715     
176 Argentina   maize   1   2000    3088715     
198 Argentina   maize   1   2000    3088715     
220 Argentina   maize   1   2000    3088715     
242 Argentina   maize   1   2000    3088715     
264 Argentina   maize   1   2000    3088715     
8754    Argentina   maize   1   2000        5.433   
8776    Argentina   maize   1   2000        5.433   
8798    Argentina   maize   1   2000        5.433   
8820    Argentina   maize   1   2000        5.433   
8842    Argentina   maize   1   2000        5.433   
8864    Argentina   maize   1   2000        5.433   
8886    Argentina   maize   1   2000        5.433   
8908    Argentina   maize   1   2000        5.433   
8930    Argentina   maize   1   2000        5.433   
8952    Argentina   maize   1   2000        5.433   
8974    Argentina   maize   1   2000        5.433   
8996    Argentina   maize   1   2000        5.433   
9018    Argentina   maize   1   2000        5.433   
17508   Argentina   maize   1   2000            16780650
17530   Argentina   maize   1   2000            16780650
17552   Argentina   maize   1   2000            16780650
17574   Argentina   maize   1   2000            16780650
17596   Argentina   maize   1   2000            16780650
17618   Argentina   maize   1   2000            16780650
17640   Argentina   maize   1   2000            16780650
17662   Argentina   maize   1   2000            16780650
17684   Argentina   maize   1   2000            16780650
17706   Argentina   maize   1   2000            16780650
17728   Argentina   maize   1   2000            16780650
17750   Argentina   maize   1   2000            16780650
17772   Argentina   maize   1   2000            16780650

以下是我尝试的：df.groupby(["Country", "Crop", "Season", "Year"], dropna=False).mean().reset_index()
然而，我得到这个错误：*** TypeError: agg function failed [how->mean,dtype->object]
我该怎么修复它？预期输出为：

Country Crop    Season  Year    Area    Yield   Production
Argentina   maize   1   2000    3088715 5.433   5.433

pandas

来源：https://stackoverflow.com/questions/77161326/groupby-in-pandas-giving-error-when-combining-columns-with-nans

1条答案

按热度按时间

dddzy1tm1#

在分组前填充nan值

df["Area"].fillna(0, inplace=True)
df["Production"].fillna(0, inplace=True)

赞(0）回复(0）举报 2023-09-29

我来回答

pandas中的groupby在组合具有NaN [duplicate]的列时出错

1条答案

相关问题

热门标签

最新问答