python 读取 *.csv文件遇到的问题

# 代码块如下
import csv

file=open("list.csv","r+")
ls=csv.reader(file,dialect='excel')
ls=list(ls)
print(ls)
file.close()

1. 问题一：

   # 执行代码后报错，'gbk'编码问题
   Traceback (most recent call last):
     File "F:/test/python_test/demo/selenium_tset/day03_test.py", line 5, in <module>
       ls=list(ls)
   UnicodeDecodeError: 'gbk' codec can't decode byte 0xbf in position 2: illegal multibyte sequence
   

   解决方法：以 utf-8 编码格式读取数据

   file=open("list.csv","r+",encoding='utf-8')
   

2. 问题二：

   # 执行后，出现非法字符 \ufeff
   [['\ufeff1', '2', '3', '4', '5'], ['6', '7', '8', '9', '10']]
   

   解决方法：以 utf-8-sig 编码格式读取数据

   file=open("list.csv","r+",encoding='utf-8-sig')