我有两个表格需整理,需将B表的家庭住址的人员姓名和A表的逐一比对,相同的将A表的家庭住址改为B表的,没有的在A表同一家庭住址后边添加上,备注为物业登记。用chatgpt生成程序运行老提示keyerror:'家庭住址'。代码如下(不全):
import pandas as pd
A_data = pd.read_excel('A表.xlsx')
B_data = pd.read_excel('B表.xlsx'
merge_data = pd.merge(A_data, B_data, on='家庭住址', how='left'
for _, row in B_data.iterrows():
address = row['家庭住址']
name = row['人员姓名']
a_names = merge_data.loc[merge_data['家庭住址'] == address, '人员姓名'].tolist
import pandas as pd
A_data = pd.read_excel('A表.xlsx')
B_data = pd.read_excel('B表.xlsx'
merge_data = pd.merge(A_data, B_data, on='家庭住址', how='left'
for _, row in B_data.iterrows():
address = row['家庭住址']
name = row['人员姓名']
a_names = merge_data.loc[merge_data['家庭住址'] == address, '人员姓名'].tolist