将 pandas df写入csv时出现Unicode编码错误 [英] Unicode Encode Error when writing pandas df to csv
问题描述
我清理了400个excel文件,并使用熊猫将它们读入python,并将所有原始数据附加到一个大df中.
I cleaned 400 excel files and read them into python using pandas and appended all the raw data into one big df.
然后,当我尝试将其导出到csv时:
Then when I try to export it to a csv:
df.to_csv("path",header=True,index=False)
我收到此错误:
UnicodeEncodeError: 'ascii' codec can't encode character u'\xc7' in position 20: ordinal not in range(128)
有人可以建议解决此问题的方法吗?
Can someone suggest a way to fix this and what it means?
谢谢
推荐答案
您的DataFrame中有unicode
个值.文件存储字节,这意味着所有unicode
必须先编码为字节,然后才能存储在文件中.您必须指定一种编码,例如utf-8
.例如
You have unicode
values in your DataFrame. Files store bytes, which means all unicode
have to be encoded into bytes before they can be stored in a file. You have to specify an encoding, such as utf-8
. For example,
df.to_csv('path', header=True, index=False, encoding='utf-8')
如果未指定编码,则df.to_csv
使用的编码在Python2中默认为ascii
,在Python3中默认为utf-8
.
If you don't specify an encoding, then the encoding used by df.to_csv
defaults to ascii
in Python2, or utf-8
in Python3.
这篇关于将 pandas df写入csv时出现Unicode编码错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!