使用Pandas在python中读取csv文件时出错 [英] Error while reading a csv file in python using pandas
问题描述
products = pd.read_csv('C:\amazon_baby.csv')
回溯(最近通话最近一次):
Traceback (most recent call last):
文件",第1行,在 产品= pd.read_csv('C:\ amazon_baby.csv')
File "", line 1, in products = pd.read_csv('C:\amazon_baby.csv')
文件 "C:\ Users \ kvsn \ Anaconda3 \ lib \ site-packages \ pandas \ io \ parsers.py",行 562,在parser_f中 返回_read(filepath_or_buffer,kwds)
File "C:\Users\kvsn\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 562, in parser_f return _read(filepath_or_buffer, kwds)
文件 "C:\ Users \ kvsn \ Anaconda3 \ lib \ site-packages \ pandas \ io \ parsers.py",行 315,以_read 解析器= TextFileReader(filepath_or_buffer,** kwds)
File "C:\Users\kvsn\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 315, in _read parser = TextFileReader(filepath_or_buffer, **kwds)
文件 "C:\ Users \ kvsn \ Anaconda3 \ lib \ site-packages \ pandas \ io \ parsers.py",行 645,初始化 self._make_engine(self.engine)
File "C:\Users\kvsn\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 645, in init self._make_engine(self.engine)
文件 "C:\ Users \ kvsn \ Anaconda3 \ lib \ site-packages \ pandas \ io \ parsers.py",行 799,在_make_engine中 self._engine = CParserWrapper(self.f,** self.options)
File "C:\Users\kvsn\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 799, in _make_engine self._engine = CParserWrapper(self.f, **self.options)
文件 "C:\ Users \ kvsn \ Anaconda3 \ lib \ site-packages \ pandas \ io \ parsers.py",行 1213,在 init 中 self._reader = _parser.TextReader(src,** kwds)
File "C:\Users\kvsn\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1213, in init self._reader = _parser.TextReader(src, **kwds)
文件"pandas \ parser.pyx",第358行,位于 pandas.parser.TextReader.初始化(pandas \ parser.c:3427)
File "pandas\parser.pyx", line 358, in pandas.parser.TextReader.cinit (pandas\parser.c:3427)
文件"pandas \ parser.pyx",行628,在 pandas.parser.TextReader._setup_parser_source(pandas \ parser.c:6861)
File "pandas\parser.pyx", line 628, in pandas.parser.TextReader._setup_parser_source (pandas\parser.c:6861)
OSError:文件b'C:\ x07mazon_baby.csv'不存在
OSError: File b'C:\x07mazon_baby.csv' does not exist
推荐答案
正如@Grr所说,您不应使用单个反斜杠,因为这是一个特殊字符.试试:
As @Grr said, You should not use a single backslash because is a special character. Try:
products = pd.read_csv('C:/amazon_baby.csv')
这适用于Windows和类似Unix的操作系统.另外,您可以使用os模块:
This works for Windows, and Unix-like OS. Also, you can use the os module:
os.path.join('C:/', 'amazon_baby.csv')
这篇关于使用Pandas在python中读取csv文件时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!