如何在熊猫中读取具有完整路径的csv文件

Question

我在 Python 中得到了这段代码：import pandas as pdfrom pathlib import Pathpath_1 = Path('C:/Users/wotesi/Documents/Cloud/Documents/Python/Programmas/panda/')print(path_1)full_path = path_1.joinpath('failu_nosaukumi.csv')print(full_path)我得到了实际结果（文件的完整路径和文件名），但是当我尝试读取该文件时：faili = pd.read_csv(full_path, header=None, index_col=0).reset_index()我收到错误：Traceback (most recent call last):  File "C:\Users\wotesi\AppData\Local\Temp\atom_script_tempfiles\d35090b0-aa8b-11ea-bb80-793ba6a5bb7c", line 19, in <module>    faili = pd.read_csv(full_path, header=None, index_col=0).reset_index()  File "C:\Users\wotesi\AppData\Local\Programs\Python\Python38-32\lib\site-packages\pandas\io\parsers.py", line 676, in parser_f    return _read(filepath_or_buffer, kwds)  File "C:\Users\wotesi\AppData\Local\Programs\Python\Python38-32\lib\site-packages\pandas\io\parsers.py", line 448, in _read    parser = TextFileReader(fp_or_buf, **kwds)  File "C:\Users\wotesi\AppData\Local\Programs\Python\Python38-32\lib\site-packages\pandas\io\parsers.py", line 880, in __init__    self._make_engine(self.engine)  File "C:\Users\wotesi\AppData\Local\Programs\Python\Python38-32\lib\site-packages\pandas\io\parsers.py", line 1114, in _make_engine    self._engine = CParserWrapper(self.f, **self.options)  File "C:\Users\wotesi\AppData\Local\Programs\Python\Python38-32\lib\site-packages\pandas\io\parsers.py", line 1891, in __init__    self._reader = parsers.TextReader(src, **kwds)  File "pandas\_libs\parsers.pyx", line 374, in pandas._libs.parsers.TextReader.__cinit__  File "pandas\_libs\parsers.pyx", line 674, in pandas._libs.parsers.TextReader._setup_parser_source此外 - 当我使用 Anaconda/Spyder 运行相同的代码（没有完整路径，只是所有文件都在同一目录中）时，我没有收到任何错误。此错误在 Atom 中生成。如何修改代码使其在 Atom 中也能运行？此外，当我将该代码编译为 exe 模块并尝试从其他 Windows 机器运行时，它也会给出相同的错误消息 - 找不到文件。任何解决方案都适合我。谢谢！

Answer 1

你可以尝试这样的事情：

from pathlib import Path

path_1 = Path(r'C:\Users\wotesi\Documents\Cloud\Documents\Python\Programmas\panda')

faili = pd.read_csv(path_1.joinpath('failu_nosaukumi.csv'), header=None, index_col=0).reset_index()