python转换编码:LookupError: unknown encoding: ansi

Question

因为我的cdv文件编码为utf-8，用Excel打开会出现乱码，再转成标准的ANSI编码时，我得到这个错误:

代码:

import chardet

def convertEncoding(from_encode,to_encode,old_filepath,target_file):
    f1=file(old_filepath)
    content2=[]
    while True:
        line=f1.readline()
        content2.append(line.decode(from_encode).encode(to_encode))
        if len(line) ==0:
            break

    f1.close()
    f2=file(target_file,'w')
    f2.writelines(content2)
    f2.close()



convertFile = open('4321.csv','r')
data = convertFile.read()
print chardet.detect(data)
if chardet.detect(data)['encoding']=='utf-8':
    convertFile.close()
    convertEncoding(chardet.detect(data)['encoding'], "ansi", "4321.csv", "4321_bak.csv")

错误:

{'confidence': 0.99, 'encoding': 'utf-8'}
Traceback (most recent call last):
  File "/Users/allenlee/Desktop/convert/convert.py", line 24, in <module>
    convertEncoding(chardet.detect(data)['encoding'], "ansi", "4321.csv", "4321_bak.csv")
  File "/Users/allenlee/Desktop/convert/convert.py", line 8, in convertEncoding
    content2.append(line.decode(from_encode).encode(to_encode))
LookupError: unknown encoding: ansi
[Finished in 0.1s with exit code 1]

感谢您的关心。

Answer 1

Python 中没有ansi 编码Standard Encodings .

从以下链接中选择适当的编码:Standard Encodings