python中open文件首行多了\ufeff

问题描述

在用python打开csv文件时，文件返回的时候多了个 \ufeff

import csv

filename = 'tb_dic_region.csv'
with open(filename, encoding='UTF-8') as f:
    reader = csv.reader(f)
    header_row = next(reader)
    print(header_row)

返回的数据

['\ufeff"REDION_ID"', 'REGION_NAME']

解决办法

只需要在open的时候编码写成UTF-8-sig

filename = 'tb_dic_region.csv'
with open(filename, encoding='UTF-8-sig') as f:
    reader = csv.reader(f)
    header_row = next(reader)
    print(header_row)

这样返回的数据就是我们想要的了

['REDION_ID', 'REGION_NAME']