用pandas实现vlookup 功能提示keyerror

Question

def dataMatching(path, xlsxList):
    df1 = pd.read_excel(path + '\\' + '下单表.xlsx',sheet_name='物料BOM', header=1)
    for i in xlsxList:
        df2 = pd.read_excel(i, header=1)
        filename = newData(a=i)
        name = filename.split('.')[0]
        if name == '供应商交货情况汇总--未交数量查询':
            df3 = pd.merge(df1, df2, how='inner', on='子物料SAP')
            print(df3.head(5))

 

Answer 1

你输出你的df1和df2看看，应该是没有子物料SAP这个呢