用Python3读取CSV类型文件时出现无效字节延续的问题

最新推荐文章于 2022-12-11 12:30:54 发布

gwprock

最新推荐文章于 2022-12-11 12:30:54 发布

阅读量1.3k

点赞数

分类专栏：深度学习笔记文章标签： python

本文链接：https://blog.csdn.net/gwpjiayou/article/details/78008616

版权

深度学习笔记专栏收录该内容

14 篇文章 5 订阅

订阅专栏

用python代码读取CSV类型文件的数据时出现以下问题解决的办法：

Traceback (most recent call last):
  File "C:/Users/gwp/PycharmProjects/LSTM/LSTM.py", line 9, in <module>
    series=read_csv('shampoo-sales.csv',encoding='utf-8',header=0,parse_dates=[0],index_col=0,squeeze=True)
  File "C:\Users\gwp\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 562, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "C:\Users\gwp\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 325, in _read
    return parser.read()
  File "C:\Users\gwp\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 815, in read
    ret = self._engine.read(nrows)
  File "C:\Users\gwp\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1314, in read
    data = self._reader.read(nrows)
  File "pandas\parser.pyx", line 805, in pandas.parser.TextReader.read (pandas\parser.c:8748)
  File "pandas\parser.pyx", line 827, in pandas.parser.TextReader._read_low_memory (pandas\parser.c:9003)
  File "pandas\parser.pyx", line 904, in pandas.parser.TextReader._read_rows (pandas\parser.c:10022)
  File "pandas\parser.pyx", line 1011, in pandas.parser.TextReader._convert_column_data (pandas\parser.c:11397)
  File "pandas\parser.pyx", line 1066, in pandas.parser.TextReader._convert_tokens (pandas\parser.c:12230)
  File "pandas\parser.pyx", line 1170, in pandas.parser.TextReader._string_convert (pandas\parser.c:13918)
  File "pandas\parser.pyx", line 1402, in pandas.parser._string_box_utf8 (pandas\parser.c:19298)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xd4 in position 1: invalid continuation byte

出现该问题的原因是：在window系统是用GBK编码，所以只需要将读取文件中的编码类型改为‘gbk’即可：
详细代码：series=read_csv('shampoo-sales.csv',encoding='gbk',header=0,parse_dates=[0],index_col=0,squeeze=True)