主页 / user-269291

impregis's questions

Martin Hope
impregis
Asked: 2020-10-11 02:21:20 +0000 UTC
  • 1

你好。

请，请指教。列不显示。

在 command 上df['Адрес покупателя']引发错误。

存档在笔记本电脑和 csv 文件本身： http ://dropmefiles.com/1M9qB

代码本身：

import pandas as pd
from pandas import Series, DataFrame
df = pd.read_excel(r'C:\2\1.xlsx')
df[['Адрес покупателя']]

错误文字：

KeyError                                  Traceback (most recent call last)
<ipython-input-7-0994cd2849d3> in <module>()
----> 1 df[['Адрес покупателя']]

C:\Users\1\Anaconda2\lib\site-packages\pandas\core\frame.pyc in __getitem__(self, key)
   2054         if isinstance(key, (Series, np.ndarray, Index, list)):
   2055             # either boolean or fancy integer index
-> 2056             return self._getitem_array(key)
   2057         elif isinstance(key, DataFrame):
   2058             return self._getitem_frame(key)

C:\Users\1\Anaconda2\lib\site-packages\pandas\core\frame.pyc in _getitem_array(self, key)
   2098             return self.take(indexer, axis=0, convert=False)
   2099         else:
-> 2100             indexer = self.loc._convert_to_indexer(key, axis=1)
   2101             return self.take(indexer, axis=1, convert=True)
   2102 

C:\Users\1\Anaconda2\lib\site-packages\pandas\core\indexing.pyc in _convert_to_indexer(self, obj, axis, is_setter)
   1229                 mask = check == -1
   1230                 if mask.any():
-> 1231                     raise KeyError('%s not in index' % objarr[mask])
   1232 
   1233                 return _values_from_object(indexer)

KeyError: "[ '\\xd0\\x90\\xd0\\xb4\\xd1\\x80\\xd0\\xb5\\xd1\\x81 \\xd0\\xbf\\xd0\\xbe\\xd0\\xba\\xd1\\x83\\xd0\\xbf\\xd0\\xb0\\xd1\\x82\\xd0\\xb5\\xd0\\xbb\\xd1\\x8f'] not in index"
pandas