作者:手机用户2602916737 | 来源:互联网 | 2023-02-03 11:04
为什么以下因KeyError'NUM'而失败?
result = pandas.merge(sdf_subset, dfgeom, how='inner', on=['ID', 'NUM'])
列'ID'存在于sdf_subset中,'NUM'存在于dfgeom中.我检查了数据类型,两者都是Int64.
有任何想法吗?
1> Allen..:
# you need to use left_on and right_on if the joining key is different between the dataframes.
result = pandas.merge(sdf_subset, dfgeom, how='inner', left_on='ID', right_on='NUM')