当在用Python的Pandas库进行读取csv文件,出现了以下错误时:
Traceback (most recent call last):
File "D:/Pycharm/PythonSpider/HelloWorld.py", line 18, in <module>
shangHai = pd.read_csv('链家上海租房信息.csv')
File "C:\Users\DELL\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\io\parsers.py", line 678, in parser_f
return _read(filepath_or_buffer, kwds)
File "C:\Users\DELL\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\io\parsers.py", line 440, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File "C:\Users\DELL\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\io\parsers.py", line 787, in __init__
self._make_engine(self.engine)
File "C:\Users\DELL\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\io\parsers.py", line 1014, in _make_engine
self._engine = CParserWrapper(self.f, **self.options)
File "C:\Users\DELL\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\io\parsers.py", line 1708, in __init__
self._reader = parsers.TextReader(src, **kwds)
File "pandas\_libs\parsers.pyx", line 384, in pandas._libs.parsers.TextReader.__cinit__
File "pandas\_libs\parsers.pyx", line 697, in pandas._libs.parsers.TextReader._setup_parser_source
OSError: Initializing from file failed
应该就是因为你的文件名是中文而导致没有办法解析:
比如:
f = pd.read_csv('要打开的文件.csv')
只需要这样改就可以了:
f = open('要打开的文件.csv','r', encoding='UTF-8') file = pd.read_csv(f) print(file)