python ansi编码,python转换编码：LookupError：未知编码：ansi

Because of my encode of cdv file is "utf-8",so when I open it with excel it will cause distortion,and when I convert it to then standard encode "ANSI",I get the error:

code:

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")

error:

{'confidence': 0.99, 'encoding': 'utf-8'}

Traceback (most recent call last):

File "/Users/allenlee/Desktop/convert/convert.py", line 24, in

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]

Thanks for your concern.

解决方案

There's no ansi encoding in Python Standard Encodings.

Choose appropriate encodings from following link: Standard Encodings