回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个关于某个csv列的问题。
当试图阅读以下列时:</p>
<pre><code>import pandas as pd
data = pd.read_csv('master.csv')
print(data['gdp_for_year ($)'])
</code></pre>
<p>它给出以下错误:</p>
<pre><code>Traceback (most recent call last):
File "C:\Users\work\venv\Suicide rate prediction based on GDB\lib\site-packages\pandas\core\indexes\base.py", line 2897, in get_loc
return self._engine.get_loc(key)
File "pandas/_libs/index.pyx", line 107, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/index.pyx", line 131, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/hashtable_class_helper.pxi", line 1607, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas/_libs/hashtable_class_helper.pxi", line 1614, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'gdp_for_year ($)'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:/Users/work/PycharmProjects/Suicide rate prediction based on GDB/project.py", line 4, in <module>
print(data['gdp_for_year ($)'])
File "C:\Users\work\venv\Suicide rate prediction based on GDB\lib\site-packages\pandas\core\frame.py", line 2995, in __getitem__
indexer = self.columns.get_loc(key)
File "C:\Users\work\venv\Suicide rate prediction based on GDB\lib\site-packages\pandas\core\indexes\base.py", line 2899, in get_loc
return self._engine.get_loc(self._maybe_cast_indexer(key))
File "pandas/_libs/index.pyx", line 107, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/index.pyx", line 131, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/hashtable_class_helper.pxi", line 1607, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas/_libs/hashtable_class_helper.pxi", line 1614, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'gdp_for_year ($)'
Process finished with exit code 1
</code></pre>
<p>有人能看出哪里不对劲吗?
提前感谢:)</p>