利用python读取csv,
(
100104 ['145']
100127 ['203']
100162 ['61', '91']
100162 ['61', '213']
100162 ['61', '119']
)
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)
得到结果如下,含有一些特殊符号:
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)