使用pandas读取CSV文件时持续遭遇UnicodeDecodeError编码错误的求助
使用pandas读取CSV文件时持续遭遇UnicodeDecodeError编码错误的求助
我正在尝试用pandas打开一个CSV文件:
import pandas as pd df = pd.read_csv('/file/planned.csv')
这个文件里有从全球各地收集来的约2000条记录,但打开时直接报了编码错误:
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xec in position 34: invalid continuation byte
之后我查了一些资料,试着换了几种编码格式来读取,但每种都遇到了对应的错误,还是没法成功:
utf-8
df_planned = pd.read_csv('/content/sample_data/planned.csv', encoding='utf-8')
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xec in position 34: invalid continuation byte
utf-16
df_planned = pd.read_csv('/content/sample_data/planned.csv', encoding='utf-16')
UnicodeDecodeError: 'utf-16-le' codec can't decode bytes in position 234-235: illegal encoding
euc-kr
df_planned = pd.read_csv('/content/sample_data/planned.csv', encoding='euc-kr')
UnicodeDecodeError: 'euc_kr' codec can't decode byte 0x84 in position 37: illegal multibyte sequence
cp949
df_planned = pd.read_csv('/content/sample_data/planned.csv', encoding='cp949')
UnicodeDecodeError: 'cp949' codec can't decode byte 0xe8 in position 43: illegal multibyte sequence
现在我还是没法把这个文件读取成pandas的DataFrame,有没有大佬能给我出出主意?非常感谢!
备注:内容来源于stack exchange,提问作者headfat
相关产品推荐
相关产品推荐

