如何避免DataFrame中的标签错误访问行？

Question

我很难在DataFrame中访问行。我的代码和结果如下。有什么问题吗？请帮帮我。

df = pd.read_excel('./eeg_samples/chanlocs67.xlsx',usecols= 
      [0,3,4,5],index_col='labels')
df.index.names = [None] 
print(df.head())
print(df.loc['Fp1'])

结果如下。

             X        Y       Z
'Fp1'  83.9171  29.4367  -6.990
'Fz'   58.5120  -0.3122  66.462
'F3'   53.1112  50.2438  42.192
'F7'   42.4743  70.2629 -11.420
'FT9'  14.5673  84.0759 -50.429

Traceback (most recent call last):
File "C:\ProgramData\mne-python\1.2.1_0\lib\site- 
  packages\pandas\core\indexes\base.py", line 3803, in get_loc
    return self._engine.get_loc(casted_key)
File "pandas\_libs\index.pyx", line 138, in 
  pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\index.pyx", line 165, in 
  pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\hashtable_class_helper.pxi", line 5745, in 
  pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas\_libs\hashtable_class_helper.pxi", line 5753, in 
  pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'Fp1'

Answer 1

您的索引值与周围的引号一起出现。因此，您需要这样做，或者修复excel文件中的数据：

print(df.loc["'Fp1'"])