问题:

今天写了一段代码,给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)