提问人:JetskiS 提问时间:11/2/2023 更新时间:11/2/2023 访问量:53
加载CSV文件时pandas read_csv错误[已关闭]
pandas read_csv error when loading CSV file [closed]
问:
我想使用 python 打开一个简单的 csv 文件(记事本文件),名为“123123”
hello,hallo,hoihoi
123,123,123
34,34,46
我想使用以下代码运行它;
将 pandas 导入为 PD
data = pd.read_csv(r'\C:\Users\Jette\Documents\pythonProject\123123.csv', engine="python", sep=',', encoding='latin-1')
但是,我不断收到以下错误。
C:\Users\Jette\Documents\pythonProject\venv\Scripts\python.exe C:\Users\Jette\Documents\pythonProject\main.py
Traceback (most recent call last):
File "C:\Users\Jette\Documents\pythonProject\main.py", line 11, in <module>
data = pd.read_csv(r'\C:\Users\Jette\Documents\pythonProject\123123.csv', engine="python", sep=',', encoding='latin-1')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python312\Lib\pandas\io\parsers\readers.py", line 948, in read_csv
return _read(filepath_or_buffer, kwds)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python312\Lib\pandas\io\parsers\readers.py", line 611, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python312\Lib\pandas\io\parsers\readers.py", line 1448, in __init__
self._engine = self._make_engine(f, self.engine)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python312\Lib\pandas\io\parsers\readers.py", line 1705, in _make_engine
self.handles = get_handle(
^^^^^^^^^^^
File "C:\Program Files\Python312\Lib\pandas\io\common.py", line 863, in get_handle
handle = open(
^^^^^
OSError: [Errno 22] Invalid argument: '\\C:\\Users\\Jette\\Documents\\pythonProject\\123123.csv'
Process finished with exit code 1
我可以在网上找到类似的问题和答案,但它们对我不起作用。 有人可以帮我吗? 先谢谢你。
答:
1赞
krisstinkou
11/2/2023
#1
看起来您的路径无效。尝试按如下方式操作:
data = pd.read_csv(r'C:\Users\Jette\Documents\pythonProject\123123.csv', engine="python", sep=',', encoding='latin-1')
上一个:Python CSV 数据收集
评论
r'\C:\Users\Jette\Documents\pythonProject\123123.csv'
应该是r'C:\Users\Jette\Documents\pythonProject\123123.csv'