python 读取csv时出现特殊符号如何解决

利用python读取csv,

100104 ['145']
100127 ['203']
100162 ['61', '91']
100162 ['61', '213']
100162 ['61', '119']

img

with open('读取文件.csv',encoding='utf-8') as f:
    for line in f:
        line = line.strip().split(',')
        sendemail = int(line[0])
        receiveemail=line[1:]
        # print(type(sendemail))
        print(receiveemail)

得到结果如下,含有一些特殊符号:

img


我应该如何处理,使得receiveemail输出是list[int]呢?


with open('读取文件.csv',encoding='utf-8') as f:
    for line in f:
        sendemail = int(line[:line.index(',')])
        receiveemail=[int(val.replace('\'','')) for val in ((line[line.index(',')+1:].strip())[1:-1].split(','))]
        print(receiveemail)

你的csv文件内容是一个数字加一个列表主城,那么,直接用eval转换成列表后提取对应数据,再讲提取的列表转换int即可
望采纳

with open('2.csv', encoding='utf-8') as f:
    for line in f:
        num, lists = eval(line)
        print("数据原型:",num, lists)
        lists = list(map(lambda x: int(x), lists))
        print("数据转后:",num, lists)

img