大Python的扁平指数

2024-10-02 16:29:38 发布

您现在位置:Python中文网/ 问答频道 /正文

我对python非常陌生,我一直在玩Panda dataframes,但是当我使用groupby时,我不再能够使用标签迭代数据帧。在

有什么能帮我的吗?在

newDF=df[df['Currency'].str.contains(currency)&df['Description'].str.contains('fx')]
newDF=newDF.rename(index=str, columns={ "Paid": "Withdrawn"})

moneyWithdrawnByUserDF=pd.DataFrame(newDF.groupby(['FirstName'])[['Withdrawn']].sum())

for index,row in moneyWithdrawnByUserDF.iterrows():
  print row['FirstName']

我得到的输出/错误如下:

^{pr2}$

谢谢你


Tags: 数据dfindex标签firstnamepandarowdataframes
1条回答
网友
1楼 · 发布于 2024-10-02 16:29:38

我想你需要改变:

moneyWithdrawnByUserDF=pd.DataFrame(newDF.groupby(['FirstName'])[['Withdrawn']].sum())

^{}

^{pr2}$

DataFrame的参数as_index=False

moneyWithdrawnByUserDF= newDF.groupby(['FirstName'], as_index=False)['Withdrawn'].sum()

相关问题 更多 >