栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Python

解决Python中pandas读取*.csv文件出现编码问题

Python 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

解决Python中pandas读取*.csv文件出现编码问题

1、问题

在使用Python中pandas读取csv文件时,由于文件编码格式出现以下问题:

Traceback (most recent call last):
 File "pandas_libsparsers.pyx", line 1134, in pandas._libs.parsers.TextReader._convert_tokens
 File "pandas_libsparsers.pyx", line 1240, in pandas._libs.parsers.TextReader._convert_with_dtype
 File "pandas_libsparsers.pyx", line 1256, in pandas._libs.parsers.TextReader._string_convert
 File "pandas_libsparsers.pyx", line 1494, in pandas._libs.parsers._string_box_utf8
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xa0 in position 19: invalid start byte
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
 File "E:PyCharm 2017.3.4helperspydevpydevd.py", line 1668, in 
  main()
 File "E:PyCharm 2017.3.4helperspydevpydevd.py", line 1662, in main
  globals = debugger.run(setup['file'], None, None, is_module)
 File "E:PyCharm 2017.3.4helperspydevpydevd.py", line 1072, in run
  pydev_imports.execfile(file, globals, locals) # execute the script
 File "E:PyCharm 2017.3.4helperspydev_pydev_imps_pydev_execfile.py", line 18, in execfile
  exec(compile(contents+"n", file, 'exec'), glob, loc)
 File "F:/oneDrive - emails.bjut.edu.cn/Program/Python/DCAE/test.py", line 18, in 
  load_phenotypes_ABIDE2_RfMRIMaps()
 File "F:/oneDrive - emails.bjut.edu.cn/Program/Python/DCAEDataload_data.py", line 109, in load_phenotypes_ABIDE2_RfMRIMaps
  pheno = pd.read_csv(pheno_path)
 File "E:PythonPython35libsite-packagespandasioparsers.py", line 678, in parser_f
  return _read(filepath_or_buffer, kwds)
 File "E:PythonPython35libsite-packagespandasioparsers.py", line 446, in _read
  data = parser.read(nrows)
 File "E:PythonPython35libsite-packagespandasioparsers.py", line 1036, in read
  ret = self._engine.read(nrows)
 File "E:PythonPython35libsite-packagespandasioparsers.py", line 1848, in read
  data = self._reader.read(nrows)
 File "pandas_libsparsers.pyx", line 876, in pandas._libs.parsers.TextReader.read
 File "pandas_libsparsers.pyx", line 891, in pandas._libs.parsers.TextReader._read_low_memory
 File "pandas_libsparsers.pyx", line 968, in pandas._libs.parsers.TextReader._read_rows
 File "pandas_libsparsers.pyx", line 1094, in pandas._libs.parsers.TextReader._convert_column_data
 File "pandas_libsparsers.pyx", line 1141, in pandas._libs.parsers.TextReader._convert_tokens
 File "pandas_libsparsers.pyx", line 1240, in pandas._libs.parsers.TextReader._convert_with_dtype
 File "pandas_libsparsers.pyx", line 1256, in pandas._libs.parsers.TextReader._string_convert
 File "pandas_libsparsers.pyx", line 1494, in pandas._libs.parsers._string_box_utf8
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xa0 in position 19: invalid start byte

我认为该问题是由于文件编码格式不是'utf-8'所导致的,因此,尝试将文件格式进行转换,转换方式如下:

首先使用txt文本打开文件,然后另存为,在右下角将编码改为‘UTF-8',点击保存即可

总结

以上所述是小编给大家介绍的解决Python中pandas读取*.csv文件出现编码问题 ,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对考高分网网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/25314.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号