python - 当我尝试合并两个 Pandas 数据框时，为什么会出现 ValueError

Question

我正在尝试合并两个熊猫数据框。以下是数据帧的头部信息。

hosts.head()
    Edition     NOC
0   1896    GRE
1   1900    FRA
2   1904    USA
3   1908    GBR
4   1912    SWE

reshaped.head()
    Edition     NOC     Change
0   1896    AFG     NaN
1   1900    AFG     NaN
2   1904    AFG     NaN
3   1908    AFG     NaN
4   1912    AFG     NaN

下面是错误信息。请建议这里有什么问题以及如何纠正它。谢谢。

merged = pd.merge(reshaped, hosts)
ValueError                                Traceback (most recent call last)
<ipython-input-167-b8f539a538e3> in <module>
      1 # Merge reshaped and hosts: merged
----> 2 merged = pd.merge(reshaped, hosts)
........................................
........................................
ValueError: You are trying to merge on object and int64 columns.

标签： pythonpandasmerge