问题:
今天写了一段代码,给csv文件追加信息,运行完以后发现csv文件里面的中文是乱码的
解决办法:
#导致乱码的代码写法
with open('test.csv','a+',encoding='utf-8',newline='')as csvfile:
writor = csv.writer(csvfile)
new_list = list(x.items()) #把字典转为列表
for i in new_list:
writor.writerow(i)
#=============================
#将utf-8改为utf-8-sig即可
with open('test.csv','a',encoding='utf-8-sig',newline='')as csvfile:
writor = csv.writer(csvfile)
new_list = list(x.items()) #把字典转为列表
for i in new_list:
writor.writerow(i)