解決pandas read_csv 讀取中文列標題文件報錯的問題
更新時間:2018年06月15日 09:46:56 作者:wshzd
今天小編就為大家分享一篇解決pandas read_csv 讀取中文列標題文件報錯的問題,具有很好的參考價值,希望對大家有所幫助。一起跟隨小編過來看看吧
從windows操作系統(tǒng)本地讀取csv文件報錯
data = pd.read_csv(path)
Traceback (most recent call last): File "C:/Users/arron/PycharmProjects/ML/ML/test.py", line 45, in <module> data = pd.read_csv(path) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 655, in parser_f return _read(filepath_or_buffer, kwds) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 405, in _read parser = TextFileReader(filepath_or_buffer, **kwds) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 762, in __init__ self._make_engine(self.engine) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 966, in _make_engine self._engine = CParserWrapper(self.f, **self.options) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1582, in __init__ self._reader = parsers.TextReader(src, **kwds) File "pandas\_libs\parsers.pyx", line 394, in pandas._libs.parsers.TextReader.__cinit__ (pandas\_libs\parsers.c:4209) File "pandas\_libs\parsers.pyx", line 712, in pandas._libs.parsers.TextReader._setup_parser_source (pandas\_libs\parsers.c:8895) OSError: Initializing from file failed
上述報錯的解決方案是
pwd = os.getcwd() os.chdir(os.path.dirname(path)) data = pd.read_csv(os.path.basename(path)) os.chdir(pwd)
此時又報如下錯誤:
Traceback (most recent call last): File "C:/Users/arron/PycharmProjects/ML/ML/test.py", line 47, in <module> data = pd.read_csv(os.path.basename(path)) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 655, in parser_f return _read(filepath_or_buffer, kwds) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 405, in _read parser = TextFileReader(filepath_or_buffer, **kwds) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 762, in __init__ self._make_engine(self.engine) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 966, in _make_engine self._engine = CParserWrapper(self.f, **self.options) File "C:\Users\arron\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1582, in __init__ self._reader = parsers.TextReader(src, **kwds) File "pandas\_libs\parsers.pyx", line 562, in pandas._libs.parsers.TextReader.__cinit__ (pandas\_libs\parsers.c:6175) File "pandas\_libs\parsers.pyx", line 781, in pandas._libs.parsers.TextReader._get_header (pandas\_libs\parsers.c:9691) UnicodeDecodeError: 'utf-8' codec can't decode byte 0xd7 in position 0: invalid continuation byte
最終解決方案是:
pwd = os.getcwd() os.chdir(os.path.dirname(path)) data = pd.read_csv(os.path.basename(path),encoding='gbk') os.chdir(pwd)
以上這篇解決pandas read_csv 讀取中文列標題文件報錯的問題就是小編分享給大家的全部內容了,希望能給大家一個參考,也希望大家多多支持腳本之家。
相關文章
windows下添加Python環(huán)境變量的方法匯總
默認情況下,在windows下安裝python之后,系統(tǒng)并不會自動添加相應的環(huán)境變量。此時不能在命令行直接使用python命令。今天我們就來看下,如何簡單快捷的在windows下添加Python環(huán)境變量2018-05-05keras的load_model實現(xiàn)加載含有參數(shù)的自定義模型
這篇文章主要介紹了keras的load_model實現(xiàn)加載含有參數(shù)的自定義模型,具有很好的參考價值,希望對大家有所幫助。一起跟隨小編過來看看吧2020-06-06Python二進制數(shù)據(jù)結構Struct的具體使用
在C/C++語言中,struct被稱為結構體。而在Python中,struct是一個專門的庫,用于處理字節(jié)串與原生Python數(shù)據(jù)結構類型之間的轉換。本文就詳細介紹struct的使用方式2021-06-06