pandas dataFrame to_excel 报错[ UnicodeDecodeError: 'ascii' codec can't decode byte 0xe7 in position 7
来源:互联网 发布:mac怎么设置独立显卡 编辑:程序博客网 时间:2024/06/17 23:56
问题提出
python code
import pandas as pddf = pd.read_csv("text.csv", sep="\t")df.to_excel("test.xlsx")
error info
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe7 in position 7: ordinal not in range(128)
解决办法
直接上 code
import syssys.setdefaultencoding('utf-8')import pandas as pddef csv2excel(fp): df = pd.read_csv(fp, sep="\t") cols = df.columns ## 转换每一列的编码 for e in cols: df[e] = df[e].map(lambda x: str(x).decode("utf8").encode("raw_unicode_escape").decode("raw_unicode_escape")) # 这里的 utf8 为 python 运行环境默认编码, 即 sys.getdefaultencoding() print e df.to_excel(fp.replace(".csv", ".xlsx")) print fpif __name__ == "__main__": fp = "test.csv" csv2excel(fp)
参考资料
- Codec registry and base classes
- python encode\decode
- How to fix: “UnicodeDecodeError: ‘ascii’ codec can’t decode byte”
- PYTHON-进阶-编码处理小结
阅读全文
0 0
- pandas dataFrame to_excel 报错[ UnicodeDecodeError: 'ascii' codec can't decode byte 0xe7 in position 7
- [报错] UnicodeDecodeError: 'ascii' codec can't decode byte 0xe6 in position 2
- pip报错UnicodeDecodeError: 'ascii' codec can't decode byte 0xb1 in position 7: ordinal not in range(12
- 【python】pip安装报错UnicodeDecodeError: 'ascii' codec can't decode byte 0xce in position 7: ordinal not i
- UnicodeDecodeError: 'ascii' codec can't decode byte 0xe7 in position 0: ordinal not in range(128)错误解
- Python报错UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xe0 in position 0: ordinal not in range
- xlutils写入中文报错:UnicodeDecodeError: 'ascii' codec can't decode byte 0xb8 in position 0: ordinal not in
- python报错UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position 4: ordinal not in range
- python报错UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position 4: ordinal not in range
- 安装DBUtils报错UnicodeDecodeError: 'ascii' codec can't decode byte 0xb0 in position 1: ordinal not in ra
- pandas的read_sql报错UnicodeDecodeError: 'utf-8' codec can't decode byte 0xd3 in position 0: invalid con
- pip 安装pandas报UnicodeDecodeError: 'ascii' codec can't decode byte 0xd5错
- 创建Scrapy项目报错 UnicodeDecodeError: 'ascii' codec can't decode byte 0xa3 in position 19
- UnicodeDecodeError: 'ascii' codec can't decode byte 0xef in position 7
- UnicodeDecodeError: 'utf8' codec can't decode byte 0xc4 in position 0: i报错问题
- UnicodeDecodeError: 'ascii' codec can't decode byte 0xe8 in position 11: ordinal not in range
- pandas读取出错:UnicodeDecodeError: 'utf-8' codec can't decode byte 0xd6 in position 0
- [Python]解决UnicodeDecodeError: 'ascii' codec can't decode byte 0xe6 in position 0
- 11月16日云栖精选夜读:阿里云 oss JavaScript客户端签名文件上传 vue2.0
- 1基于opencv的图像读_写_显示_初级混合
- docker和虚拟机的对比图
- static用法
- Android异步线程OkHttp Post请求Json数据并解析
- pandas dataFrame to_excel 报错[ UnicodeDecodeError: 'ascii' codec can't decode byte 0xe7 in position 7
- 秒杀系统架构分析与实战
- django cannot be applied to a naive datetime
- java并发-原子性和可见性(7)
- 【笔记】etc/profile和~/.bashrc的区别
- 开通博客学习驱动
- OpenCV + Python 实现人脸识别
- 20个常用的正则表达式
- 机器学习初学者——常见算法篇