如何用Pandas优化 Dataframe 中的嵌套循环

3lxsmp7m 于 2023-02-07 发布在其他

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

我想优化迭代，因为完成操作需要很长时间，这是我的代码

the second table

l=0
for i in df_MailBox_Total.index : 
    if pd.isnull(df_MailBox_Total.at[i,'ReceivedOrgId']):
        for j in df_SentMail_Service.index :
            if df_MailBox_Total.at[i,'MailId'] == df_SentMail_Service.at[j,'MailID']:
               df_MailBox_Total.at[i,'ReceivedOrgId'] =df_SentMail_Service.at[j,'OrgID']
               l=l+1
               break;

升

pandas

来源：https://stackoverflow.com/questions/75344913/how-to-optimise-nested-loop-in-dataframe-with-pandas

1条答案

按热度按时间

nnsrf1az1#

IIUC，使用这个：

df_MailBox_Total = (df_MailBox_Total
                         .set_index('MailId')
                         .assign(ReceivedOrgId = lambda x: x["ReceivedOrgId"]
                                .fillna(df_SentMail_Service.set_index('MailID')['OrgID']))
                         .reset_index())

赞(0）回复(0）举报 2023-02-07

我来回答

如何用Pandas优化 Dataframe 中的嵌套循环

1条答案

相关问题

热门标签

最新问答