Skip to main content
 首页 » 编程设计

python之Pandas header 确实存在但仍然出现 KeyError

2024年11月01日15insus

当我运行我的代码时出现Keyerror 'stackoverflow'。

e0 = pd.read_csv(working_dir+"E0.txt",sep=',') 
e0['MTM'] = e0['stack_over_flow'] 

我确实输出了 e0 的列,并且在我的列中得到了 stack_over_flow。

b'Super_user' 
b'Personal_finance' 
b'stack_over_flow' 

我还尝试从 .txt 文件中手动删除 b,但仍然出现相同的错误。有人可以帮忙吗?

回溯:

Traceback (most recent call last): 
 
  File "<ipython-input-74-99e71d524b4b>", line 1, in <module> 
    runfile('C:/AppData/FinRecon/py_code/python3/DataJoin.py', wdir='C:/AppData/FinRecon/py_code/python3') 
 
  File "C:\Users\stack\AppData\Local\Continuum\anaconda3\anaconda3_32bit\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 827, in runfile 
    execfile(filename, namespace) 
 
  File "C:\Users\stack\AppData\Local\Continuum\anaconda3\anaconda3_32bit\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 110, in execfile 
    exec(compile(f.read(), filename, 'exec'), namespace) 
 
  File "C:/AppData/FinRecon/py_code/python3/DataJoin.py", line 474, in <module> 
    M2() 
 
  File "C:/AppData/FinRecon/py_code/python3/DataJoin.py", line 41, in M2 
    e0['MTM'] = e0['stack_over_flow'] 
 
  File "C:\Users\stack\AppData\Local\Continuum\anaconda3\anaconda3_32bit\lib\site-packages\pandas\core\frame.py", line 2927, in __getitem__ 
    indexer = self.columns.get_loc(key) 
 
  File "C:\Users\stack\AppData\Local\Continuum\anaconda3\anaconda3_32bit\lib\site-packages\pandas\core\indexes\base.py", line 2659, in get_loc 
    return self._engine.get_loc(self._maybe_cast_indexer(key)) 
 
  File "pandas/_libs/index.pyx", line 108, in pandas._libs.index.IndexEngine.get_loc 
 
  File "pandas/_libs/index.pyx", line 132, in pandas._libs.index.IndexEngine.get_loc 
 
  File "pandas/_libs/hashtable_class_helper.pxi", line 1601, in pandas._libs.hashtable.PyObjectHashTable.get_item 
 
  File "pandas/_libs/hashtable_class_helper.pxi", line 1608, in pandas._libs.hashtable.PyObjectHashTable.get_item 
 
KeyError: 'stack_over_flow' 

更新,我发现它是 b 和 '' 之前和之间 每个标题。为什么将其添加到我的 .txt 文件中?

请您参考如下方法:

我更改了您的数据,如下所示 假设 E0.txt 的数据如下所示。

stackoverflow,"some column name", test 
1, 2, 3 
 

使用下面的代码来检索任何列的内容。

e0 = pd.read_csv(working_dir+"E0.txt",sep=',') 
e0['MTM'] = e0['stack_over_flow'] 

-- 更新--

没有 b 我创建了一个测试样本,它适用于以下输入

Super_user,Personal_finance,stack_over_flow 
1, 2, 3