在做读写csv练习时,发现找不到fieldnames,print出来,发现程序读取出来的表格内容里,多了一个\ufeff字符,研究一番,发现是encoding编码方式的问题。
with open(source_path,'r',encoding='utf-8',newline='') as source_file:
把encoding的编码方式修改为UTF-8-sig就可以完美解决,如下:
with open(source_path,'r',encoding='UTF-8-sig',newline='') as source_file:
如果读取后需要再写入文件,写入的编码方式要与读取的一致哦!
with open(file_path,'w',encoding='UTF-8-sig',newline='') as target_file: