时间戳

首页 > 解决方案 > 合并后 Pandas 返回 KeyError

python - 合并后 Pandas 返回 KeyError

问题描述

我的代码很简单，而且我是 Pandas 的初学者。尝试合并后它给了我一个 KeyError 。我确实检查了两列是否具有相同的名称并且它是正确的。我确信这是一件简单的事情，但我正在寻找 Panda Docs，但我一无所获。

import pandas as pd

df = pd.read_excel('test1.xlsx')

df2 = pd.read_excel('test2.xlsx')

left = pd.merge(df, df2, on=['Nome','Data de Admissão'], how='left')

我得到的错误是：

File "c:/Users/raphael.gomes/Desktop/main/pandas2.py", line 7, in <module>
    left = pd.merge(df, df2, on=['Nome','Data de Admissão'], how='left')
  File "C:\Program Files (x86)\Python38-32\lib\site-packages\pandas\core\reshape\merge.py", line 105, in merge
    op = _MergeOperation(
  File "C:\Program Files (x86)\Python38-32\lib\site-packages\pandas\core\reshape\merge.py", line 698, in __init__
    ) = self._get_merge_keys()
  File "C:\Program Files (x86)\Python38-32\lib\site-packages\pandas\core\reshape\merge.py", line 1095, in _get_merge_keys     
    right_keys.append(right._get_label_or_level_values(rk))
  File "C:\Program Files (x86)\Python38-32\lib\site-packages\pandas\core\generic.py", line 1779, in _get_label_or_level_values
    raise KeyError(key)
KeyError: 'Nome'

标签： pythonexcelpandas

解决方案

推荐阅读