尝试用pycharm读取csv文件
import csv
ls = []
with open('./score.csv','r',newline='') as f:
#得到reader对象
csvreader = csv.reader(f)
for line in csvreader:
ls.append(line)
print(ls)
但首先出现了
'gbk' codec can't decode byte 0xad in position 4: illegal multibyte sequence
的错误,在网上找了资料后发现是编码问题
在open()函数里面encoding值修改为utf-8
输出不报错了,但是结果数据仍有问题
输出数据前面有\ufeff
于是继续修改
with open('./score.csv','r',newline='',encoding='utf-8-sig') as f:
附图,问题解决