我定义了两个dataframe,一个是df_kdnr,一个是result,我想在df_kdnr中按照kdnr查询textc列的值,然后赋值给result中(实现excel中的vlookup的功能),代码如下。但是没有修改过来。请帮助改一下吧,谢谢
print(row['name'])是可以打印出对应结果,但print(result)还是原来的数据
for index, row in result.iterrows():
row['name'] = df_kdnr.loc[df_kdnr['kdnr'] == row['kdnr'], 'textc'].values[0]
print(row['name'])
print(result)
改成这样就成功了。
for index, row in result.iterrows():
result.at[index, 'name'] = df_kdnr.loc[df_kdnr['kdnr'] == result.at[index, 'kdnr'], 'textc'].iloc[0]