pandas 合并两个 Dataframe 时出现空 Dataframe

zed5wv10 于 2022-12-21 发布在其他

关注(0)|答案(1)|浏览(270)

import pandas as pd

df1 = pd.DataFrame({'HPI': [10, 20, 30, 40, 50],'INT': [1, 2, 3, 4, 5],'IND': [50, 60, 70, 80, 90]},index=[2001, 2002, 2003, 2004, 2005])

df2 = pd.DataFrame({'HPI': [11, 22, 33, 44, 55],'INT': [6, 7, 8, 9, 0],'IND': [51, 62, 73, 84, 95]},index=[2006, 2007, 2008, 2009, 2010])

merge = pd.merge(df1, df2,on=['HPI', 'INT', 'IND'])
print(merge)

代码的输出为空数据框列：[HPI、INT、IND]索引：[]

pandas

来源：https://stackoverflow.com/questions/74833094/empty-dataframe-on-merging-two-dataframe