解决Python中pandas读取*.csv文件出现编码问题
作者:倒影丶年华 时间:2023-10-15 11:48:42
1、问题
在使用Python中pandas读取csv文件时,由于文件编码格式出现以下问题:
Traceback (most recent call last):
File "pandas\_libs\parsers.pyx", line 1134, in pandas._libs.parsers.TextReader._convert_tokens
File "pandas\_libs\parsers.pyx", line 1240, in pandas._libs.parsers.TextReader._convert_with_dtype
File "pandas\_libs\parsers.pyx", line 1256, in pandas._libs.parsers.TextReader._string_convert
File "pandas\_libs\parsers.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.4\helpers\pydev\pydevd.py", line 1668, in <module>
main()
File "E:\PyCharm 2017.3.4\helpers\pydev\pydevd.py", line 1662, in main
globals = debugger.run(setup['file'], None, None, is_module)
File "E:\PyCharm 2017.3.4\helpers\pydev\pydevd.py", line 1072, in run
pydev_imports.execfile(file, globals, locals) # execute the script
File "E:\PyCharm 2017.3.4\helpers\pydev\_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 <module>
load_phenotypes_ABIDE2_RfMRIMaps()
File "F:/OneDrive - emails.bjut.edu.cn/Program/Python/DCAE\Data\load_data.py", line 109, in load_phenotypes_ABIDE2_RfMRIMaps
pheno = pd.read_csv(pheno_path)
File "E:\Python\Python35\lib\site-packages\pandas\io\parsers.py", line 678, in parser_f
return _read(filepath_or_buffer, kwds)
File "E:\Python\Python35\lib\site-packages\pandas\io\parsers.py", line 446, in _read
data = parser.read(nrows)
File "E:\Python\Python35\lib\site-packages\pandas\io\parsers.py", line 1036, in read
ret = self._engine.read(nrows)
File "E:\Python\Python35\lib\site-packages\pandas\io\parsers.py", line 1848, in read
data = self._reader.read(nrows)
File "pandas\_libs\parsers.pyx", line 876, in pandas._libs.parsers.TextReader.read
File "pandas\_libs\parsers.pyx", line 891, in pandas._libs.parsers.TextReader._read_low_memory
File "pandas\_libs\parsers.pyx", line 968, in pandas._libs.parsers.TextReader._read_rows
File "pandas\_libs\parsers.pyx", line 1094, in pandas._libs.parsers.TextReader._convert_column_data
File "pandas\_libs\parsers.pyx", line 1141, in pandas._libs.parsers.TextReader._convert_tokens
File "pandas\_libs\parsers.pyx", line 1240, in pandas._libs.parsers.TextReader._convert_with_dtype
File "pandas\_libs\parsers.pyx", line 1256, in pandas._libs.parsers.TextReader._string_convert
File "pandas\_libs\parsers.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文件出现编码问题 ,网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!
来源:https://blog.csdn.net/freeyy1314/article/details/82924523
标签:python,pandas,csv,编码
0
投稿
猜你喜欢
Python 注解方式实现缓存数据详解
2023-07-15 22:11:22
asp如何制作一个安全的页面?
2010-06-29 21:22:00
JS获取网页中HTML元素的几种方法分析
2007-10-12 13:08:00
python高阶函数functools模块的具体使用
2022-12-08 09:03:15
win10 64bit下python NLTK安装教程
2023-04-05 19:49:40
Python数值方法及数据可视化
2021-07-26 17:32:51
asp在sql server2000中新建帐号和给帐号权限代码
2008-01-29 13:46:00
python在协程中增加任务实例操作
2023-02-17 22:57:48
Oracle系统表外键的更名
2010-07-26 13:07:00
MySQL表设计优化与索引 (七)
2010-10-25 20:06:00
Python使用中文正则表达式匹配指定中文字符串的方法示例
2021-11-28 22:17:00
HTML+CSS 模仿Windows 7 桌面效果
2010-06-17 14:33:00
通过Python来使用七牛云存储的方法详解
2022-09-13 19:56:36
Python语法详解之decorator装饰器
2021-07-15 23:11:45
asp.net 上传下载输出二进制流实现代码
2023-06-28 16:06:05
网站设计输入了些什么?
2008-04-01 09:30:00
python基础教程之csv文件的写入与读取
2021-06-18 21:21:00
Mysql中limit的用法方法详解与注意事项
2023-11-16 09:20:05
PHP实现根据数组某个键值大小进行排序的方法
2023-11-15 00:35:55
倾斜的鼠标翻转导航制作上的烦恼
2007-06-20 16:39:00