数据帧合并给出“进程以退出代码 137 完成(被信号 9 中断:SIGKILL)" [英] Dataframe merge gives `Process finished with exit code 137 (interrupted by signal 9: SIGKILL)`

问题描述

我使用数据框合并 3 次来获得我想要的结果

I use dataframe merge 3 times to get my desire results

def write_dips(writer):
    df_dips = pd.read_excel(file_path, sheet_name='DipsSummary')
    df_sales = pd.read_excel(file_path, sheet_name='SaleSummary')
    df_delivery = pd.read_excel(file_path, sheet_name='DeliverySummary')
    df_mapping = pd.read_csv(mappingfilepath, delimiter=',', skiprows=[1])

    df_dips = df_dips.merge(df_mapping, left_on='Site', right_on='SHIP TO NAME',how='left')
    df_dips = df_dips.merge(df_sales, left_on ='IDASS ID', right_on='IdassId',how='left')
    df_dips = df_dips.merge(df_delivery, left_on='SHIP-TO PARTY', right_on='Ship-To Party', how='left')

当我尝试执行第三个合并选项时，出现以下错误；

When I try to do 3rd merge option I get following error;

进程以退出代码 137 结束(被信号 9:SIGKILL 中断)

Process finished with exit code 137 (interrupted by signal 9: SIGKILL)

我该如何解决这个问题?

How can I overcome this issue?

推荐答案

我在每次合并时都使用了 fillna(0).

I overcame by using fillna(0) at each merge.

def write_dips(writer):
    df_dips = pd.read_excel(file_path, sheet_name='DipsSummary')
    df_sales = pd.read_excel(file_path, sheet_name='SaleSummary')
    df_delivery = pd.read_excel(file_path, sheet_name='DeliverySummary')
    df_mapping = pd.read_csv(mappingfilepath, delimiter=',', skiprows=[1])

df_dips = df_dips.merge(df_mapping, left_on='Site', right_on='SHIP TO NAME',how='left').fillna(0)
df_dips = df_dips.merge(df_sales, left_on ='IDASS ID', right_on='IdassId',how='left').fillna(0)
df_dips = df_dips.merge(df_delivery, left_on='SHIP-TO PARTY', right_on='Ship-To Party', how='left').fillna(0)

这篇关于数据帧合并给出“进程以退出代码 137 完成(被信号 9 中断:SIGKILL)"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！