问题:使用Python在Pandas中读取CSV文件时出现UnicodeDecodeError
我正在运行一个程序,正在处理30,000个类似文件。他们中有随机数正在停止并产生此错误…
File "C:\Importer\src\dfman\importer.py", line 26, in import_chr
data = pd.read_csv(filepath, names=fields)
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 400, in parser_f
return _read(filepath_or_buffer, kwds)
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 205, in _read
return parser.read()
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 608, in read
ret = self._engine.read(nrows)
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 1028, in read
data = self._reader.read(nrows)
File "parser.pyx", line 706, in pandas.parser.TextReader.read (pandas\parser.c:6745)
File "parser.pyx", line 728, in pandas.parser.TextReader._read_low_memory (pandas\parser.c:6964)
File "parser.pyx", line 804, in pandas.parser.TextReader._read_rows (pandas\parser.c:7780)
File "parser.pyx", line 890, in pandas.parser.TextReader._convert_column_data (pandas\parser.c:8793)
File "parser.pyx", line 950, in pandas.parser.TextReader._convert_tokens (pandas\parser.c:9484)
File "parser.pyx", line 1026, in pandas.parser.TextReader._convert_with_dtype (pandas\parser.c:10642)
File "parser.pyx", line 1046, in pandas.parser.TextReader._string_convert (pandas\parser.c:10853)
File "parser.pyx", line 1278, in pandas.parser._string_box_utf8 (pandas\parser.c:15657)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xda in position 6: invalid continuation byte
这些文件的源/创建都来自同一位置。纠正此错误以继续导入的最佳方法是什么?
I’m running a program which is processing 30,000 similar files. A random number of them are stopping and producing this error…
File "C:\Importer\src\dfman\importer.py", line 26, in import_chr
data = pd.read_csv(filepath, names=fields)
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 400, in parser_f
return _read(filepath_or_buffer, kwds)
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 205, in _read
return parser.read()
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 608, in read
ret = self._engine.read(nrows)
File "C:\Python33\lib\site-packages\pandas\io\parsers.py", line 1028, in read
data = self._reader.read(nrows)
File "parser.pyx", line 706, in pandas.parser.TextReader.read (pandas\parser.c:6745)
File "parser.pyx", line 728, in pandas.parser.TextReader._read_low_memory (pandas\parser.c:6964)
File "parser.pyx", line 804, in pandas.parser.TextReader._read_rows (pandas\parser.c:7780)
File "parser.pyx", line 890, in pandas.parser.TextReader._convert_column_data (pandas\parser.c:8793)
File "parser.pyx", line 950, in pandas.parser.TextReader._convert_tokens (pandas\parser.c:9484)
File "parser.pyx", line 1026, in pandas.parser.TextReader._convert_with_dtype (pandas\parser.c:10642)
File "parser.pyx", line 1046, in pandas.parser.TextReader._string_convert (pandas\parser.c:10853)
File "parser.pyx", line 1278, in pandas.parser._string_box_utf8 (pandas\parser.c:15657)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xda in position 6: invalid continuation byte
The source/creation of these files all come from the same place. What’s the best way to correct this to proceed with the import?
回答 0
read_csv
可以encoding
选择处理不同格式的文件。我主要使用read_csv('file', encoding = "ISO-8859-1")
,或者替代地encoding = "utf-8"
阅读,并且通常utf-8
用于to_csv
。
您还可以使用而不是的多个alias
选项'latin'
之一'ISO-8859-1'
(请参阅python docs,还可能会遇到许多其他编码)。
请参阅相关的Pandas文档,
有关csv文件的python文档示例以及有关SO的大量相关问题。一个好的背景资源是每个开发人员应了解的unicode和字符集。
要检测编码(假设文件包含非ASCII字符),可以使用enca
(请参见手册页)或file -i
(linux)或file -I
(osx)(请参见手册页)。
回答 1
所有解决方案中最简单的:
import pandas as pd
df = pd.read_csv('file_name.csv', engine='python')
替代解决方案:
- 在Sublime文本编辑器中打开csv文件。
- 以utf-8格式保存文件。
崇高地,单击文件->使用编码保存-> UTF-8
然后,您可以照常读取文件:
import pandas as pd
data = pd.read_csv('file_name.csv', encoding='utf-8')
其他不同的编码类型是:
encoding = "cp1252"
encoding = "ISO-8859-1"
Simplest of all Solutions:
import pandas as pd
df = pd.read_csv('file_name.csv', engine='python')
Alternate Solution:
- Open the csv file in Sublime text editor.
- Save the file in utf-8 format.
In sublime, Click File -> Save with encoding -> UTF-8
Then, you can read your file as usual:
import pandas as pd
data = pd.read_csv('file_name.csv', encoding='utf-8')
and the other different encoding types are:
encoding = "cp1252"
encoding = "ISO-8859-1"
回答 2
熊猫允许指定编码,但不允许忽略错误以免自动替换有问题的字节。因此,没有一种适合所有方法的大小,而是取决于实际用例的不同方法。
您知道编码,并且文件中没有编码错误。太好了:您只需要指定编码即可:
file_encoding = 'cp1252' # set file_encoding to the file encoding (utf8, latin1, etc.)
pd.read_csv(input_file_and_path, ..., encoding=file_encoding)
您不希望被编码问题困扰,无论某些文本字段是否包含垃圾内容,都只希望加载该死的文件。好的,您只需要使用Latin1
编码,因为它接受任何可能的字节作为输入(并将其转换为相同代码的unicode字符):
pd.read_csv(input_file_and_path, ..., encoding='latin1')
您知道大多数文件都是用特定的编码编写的,但是它也包含编码错误。一个真实的示例是一个UTF8文件,该文件已使用非utf8编辑器进行了编辑,并且其中包含一些使用不同编码的行。Pandas没有提供特殊的错误处理的准备,但是Python open
函数具有(假设Python3),并且read_csv
接受像object这样的文件。在这里使用的典型错误参数是'ignore'
仅抑制有问题的字节,或者(IMHO更好)'backslashreplace'
用其Python的反斜杠转义序列替换有问题的字节:
file_encoding = 'utf8' # set file_encoding to the file encoding (utf8, latin1, etc.)
input_fd = open(input_file_and_path, encoding=file_encoding, errors = 'backslashreplace')
pd.read_csv(input_fd, ...)
Pandas allows to specify encoding, but does not allow to ignore errors not to automatically replace the offending bytes. So there is no one size fits all method but different ways depending on the actual use case.
You know the encoding, and there is no encoding error in the file.
Great: you have just to specify the encoding:
file_encoding = 'cp1252' # set file_encoding to the file encoding (utf8, latin1, etc.)
pd.read_csv(input_file_and_path, ..., encoding=file_encoding)
You do not want to be bothered with encoding questions, and only want that damn file to load, no matter if some text fields contain garbage. Ok, you only have to use Latin1
encoding because it accept any possible byte as input (and convert it to the unicode character of same code):
pd.read_csv(input_file_and_path, ..., encoding='latin1')
You know that most of the file is written with a specific encoding, but it also contains encoding errors. A real world example is an UTF8 file that has been edited with a non utf8 editor and which contains some lines with a different encoding. Pandas has no provision for a special error processing, but Python open
function has (assuming Python3), and read_csv
accepts a file like object. Typical errors parameter to use here are 'ignore'
which just suppresses the offending bytes or (IMHO better) 'backslashreplace'
which replaces the offending bytes by their Python’s backslashed escape sequence:
file_encoding = 'utf8' # set file_encoding to the file encoding (utf8, latin1, etc.)
input_fd = open(input_file_and_path, encoding=file_encoding, errors = 'backslashreplace')
pd.read_csv(input_fd, ...)
回答 3
with open('filename.csv') as f:
print(f)
执行此代码后,您将找到“ filename.csv”的编码,然后执行以下代码
data=pd.read_csv('filename.csv', encoding="encoding as you found earlier"
你去
with open('filename.csv') as f:
print(f)
after executing this code you will find encoding of ‘filename.csv’ then execute code as following
data=pd.read_csv('filename.csv', encoding="encoding as you found earlier"
there you go
回答 4
就我而言,USC-2 LE BOM
根据Notepad ++ ,文件具有编码。它encoding="utf_16_le"
用于python。
希望这有助于更快找到某人的答案。
In my case, a file has USC-2 LE BOM
encoding, according to Notepad++.
It is encoding="utf_16_le"
for python.
Hope, it helps to find an answer a bit faster for someone.
回答 5
就我而言,这适用于python 2.7:
data = read_csv(filename, encoding = "ISO-8859-1", dtype={'name_of_colum': unicode}, low_memory=False)
而对于python 3,仅:
data = read_csv(filename, encoding = "ISO-8859-1", low_memory=False)
In my case this worked for python 2.7:
data = read_csv(filename, encoding = "ISO-8859-1", dtype={'name_of_colum': unicode}, low_memory=False)
And for python 3, only:
data = read_csv(filename, encoding = "ISO-8859-1", low_memory=False)
回答 6
尝试指定engine =’python’。它对我有用,但我仍在尝试找出原因。
df = pd.read_csv(input_file_path,...engine='python')
Try specifying the engine=’python’.
It worked for me but I’m still trying to figure out why.
df = pd.read_csv(input_file_path,...engine='python')
回答 7
我正在发布答案,以提供有关为什么会出现此问题的更新解决方案和解释。假设您正在从数据库或Excel工作簿中获取此数据。如果您有特殊字符,例如La Cañada Flintridge city
,除非您使用UTF-8
编码导出数据,否则将引入错误。La Cañada Flintridge city
将成为La Ca\xf1ada Flintridge city
。如果您pandas.read_csv
对默认参数没有任何调整,则会遇到以下错误
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf1 in position 5: invalid continuation byte
幸运的是,有一些解决方案。
选项1,修复出口。确保使用UTF-8
编码。
选项2,如果您无法解决出口问题,而需要使用pandas.read_csv
,请确保包括以下参数engine='python'
。缺省情况下,pandas使用engine='C'
此选项非常适合读取大型干净文件,但如果出现意外情况,它将崩溃。根据我的经验,设置encoding='utf-8'
从未解决过这个问题UnicodeDecodeError
。另外,您不需要使用errors_bad_lines
,但是,如果您确实需要它,那仍然是一个选择。
pd.read_csv(<your file>, engine='python')
选项3:解决方案是我个人首选的解决方案。使用香草Python读取文件。
import pandas as pd
data = []
with open(<your file>, "rb") as myfile:
# read the header seperately
# decode it as 'utf-8', remove any special characters, and split it on the comma (or deliminator)
header = myfile.readline().decode('utf-8').replace('\r\n', '').split(',')
# read the rest of the data
for line in myfile:
row = line.decode('utf-8', errors='ignore').replace('\r\n', '').split(',')
data.append(row)
# save the data as a dataframe
df = pd.DataFrame(data=data, columns = header)
希望这可以帮助人们第一次遇到这个问题。
I am posting an answer to provide an updated solution and explanation as to why this problem can occur. Say you are getting this data from a database or Excel workbook. If you have special characters like La Cañada Flintridge city
, well unless you are exporting the data using UTF-8
encoding, you’re going to introduce errors. La Cañada Flintridge city
will become La Ca\xf1ada Flintridge city
. If you are using pandas.read_csv
without any adjustments to the default parameters, you’ll hit the following error
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf1 in position 5: invalid continuation byte
Fortunately, there are a few solutions.
Option 1, fix the exporting. Be sure to use UTF-8
encoding.
Option 2, if fixing the exporting problem is not available to you, and you need to use pandas.read_csv
, be sure to include the following paramters, engine='python'
. By default, pandas uses engine='C'
which is great for reading large clean files, but will crash if anything unexpected comes up. In my experience, setting encoding='utf-8'
has never fixed this UnicodeDecodeError
. Also, you do not need to use errors_bad_lines
, however, that is still an option if you REALLY need it.
pd.read_csv(<your file>, engine='python')
Option 3: solution is my preferred solution personally. Read the file using vanilla Python.
import pandas as pd
data = []
with open(<your file>, "rb") as myfile:
# read the header seperately
# decode it as 'utf-8', remove any special characters, and split it on the comma (or deliminator)
header = myfile.readline().decode('utf-8').replace('\r\n', '').split(',')
# read the rest of the data
for line in myfile:
row = line.decode('utf-8', errors='ignore').replace('\r\n', '').split(',')
data.append(row)
# save the data as a dataframe
df = pd.DataFrame(data=data, columns = header)
Hope this helps people encountering this issue for the first time.
回答 8
挣扎了一段时间,以为我会在这个问题上发布,因为它是第一个搜索结果。将encoding="iso-8859-1"
标签添加到熊猫read_csv
没有用,也没有任何其他编码,但始终给出UnicodeDecodeError。
如果您要传递文件句柄,则pd.read_csv(),
需要将encoding
属性放在文件上,而不是中read_csv
。事后看来很明显,但是要跟踪却有一个微妙的错误。
Struggled with this a while and thought I’d post on this question as it’s the first search result. Adding the encoding="iso-8859-1"
tag to pandas read_csv
didn’t work, nor did any other encoding, kept giving a UnicodeDecodeError.
If you’re passing a file handle to pd.read_csv(),
you need to put the encoding
attribute on the file open, not in read_csv
. Obvious in hindsight, but a subtle error to track down.
回答 9
这个答案似乎可以解决CSV编码问题。如果标题出现奇怪的编码问题,如下所示:
>>> f = open(filename,"r")
>>> reader = DictReader(f)
>>> next(reader)
OrderedDict([('\ufeffid', '1'), ... ])
然后,您在CSV文件的开头就有一个字节顺序标记(BOM)字符。这个答案解决了这个问题:
Python读取csv-BOM嵌入第一个密钥
解决方案是使用加载CSV encoding="utf-8-sig"
:
>>> f = open(filename,"r", encoding="utf-8-sig")
>>> reader = DictReader(f)
>>> next(reader)
OrderedDict([('id', '1'), ... ])
希望这对某人有帮助。
This answer seems to be the catch-all for CSV encoding issues. If you are getting a strange encoding problem with your header like this:
>>> f = open(filename,"r")
>>> reader = DictReader(f)
>>> next(reader)
OrderedDict([('\ufeffid', '1'), ... ])
Then you have a byte order mark (BOM) character at the beginning of your CSV file. This answer addresses the issue:
Python read csv – BOM embedded into the first key
The solution is to load the CSV with encoding="utf-8-sig"
:
>>> f = open(filename,"r", encoding="utf-8-sig")
>>> reader = DictReader(f)
>>> next(reader)
OrderedDict([('id', '1'), ... ])
Hopefully this helps someone.
回答 10
我正在发布此旧线程的更新。我找到了一个可行的解决方案,但需要打开每个文件。我在LibreOffice中打开了csv文件,选择另存为>编辑过滤器设置。在下拉菜单中,我选择了UTF8编码。然后我添加encoding="utf-8-sig"
到data = pd.read_csv(r'C:\fullpathtofile\filename.csv', sep = ',', encoding="utf-8-sig")
。
希望这对某人有帮助。
I am posting an update to this old thread. I found one solution that worked, but requires opening each file. I opened my csv file in LibreOffice, chose Save As > edit filter settings. In the drop-down menu I chose UTF8 encoding. Then I added encoding="utf-8-sig"
to the data = pd.read_csv(r'C:\fullpathtofile\filename.csv', sep = ',', encoding="utf-8-sig")
.
Hope this helps someone.
回答 11
我无法打开从网上银行下载的简体中文CSV文件,我尝试过latin1
,尝试过iso-8859-1
,cp1252
,但都无济于事。
但是pd.read_csv("",encoding ='gbk')
工作就完成了。
I have trouble opening a CSV file in simplified Chinese downloaded from an online bank,
I have tried latin1
, I have tried iso-8859-1
, I have tried cp1252
, all to no avail.
But pd.read_csv("",encoding ='gbk')
simply does the work.
回答 12
请尝试添加
encoding='unicode_escape'
这会有所帮助。为我工作。另外,请确保使用正确的定界符和列名。
您可以从仅加载1000行开始,以快速加载文件。
Please try to add
encoding='unicode_escape'
This will help. Worked for me. Also, make sure you’re using the correct delimiter and column names.
You can start with loading just 1000 rows to load the file quickly.
回答 13
我正在使用Jupyter笔记本。以我为例,它以错误的格式显示文件。“编码”选项无效。因此,我将CSV保存为utf-8格式,并且可以正常工作。
I am using Jupyter-notebook. And in my case, it was showing the file in the wrong format. The ‘encoding’ option was not working.
So I save the csv in utf-8 format, and it works.
回答 14
尝试这个:
import pandas as pd
with open('filename.csv') as f:
data = pd.read_csv(f)
看起来它会处理编码,而无需通过参数明确表示
Try this:
import pandas as pd
with open('filename.csv') as f:
data = pd.read_csv(f)
Looks like it will take care of the encoding without explicitly expressing it through argument
回答 15
在传递给熊猫之前,请检查编码。它会使您减速,但是…
with open(path, 'r') as f:
encoding = f.encoding
df = pd.read_csv(path,sep=sep, encoding=encoding)
在python 3.7中
Check the encoding before you pass to pandas. It will slow you down, but…
with open(path, 'r') as f:
encoding = f.encoding
df = pd.read_csv(path,sep=sep, encoding=encoding)
In python 3.7
回答 16
我遇到的另一个导致相同错误的重要问题是:
_values = pd.read_csv("C:\Users\Mujeeb\Desktop\file.xlxs")
^此行导致相同的错误,因为我正在使用read_csv()
方法读取Excel文件。使用read_excel()
阅读.xlxs
Another important issue that I faced which resulted in the same error was:
_values = pd.read_csv("C:\Users\Mujeeb\Desktop\file.xlxs")
^This line resulted in the same error because I am reading an excel file using read_csv()
method. Use read_excel()
for reading .xlxs