python3 csv的读写

来源：互联网发布：我想做淘宝客编辑：程序博客网时间：2024/05/29 02:12

写入csv文件（注意需要有E:\pyProjects这个文件夹）空了一行

import csvitems = [['1','LawnMower','Small Hover mower','Fred','$150','Excellent','2012-01-05'],['2','LawnMower','Ride-on mower','Mike','$370','Fair','2012-04-01'],['3','Bike','BMX bike','Joe','$200','Good','2013-03-22'],['4','Drill','Heavy duty hammer','Rob','$100','Good','2013-10-28'],['5','Scarifier','Quality, stainless steel','Anne','$200','2013-09-14'],['6','Sprinkler','Cheap but effective','Fred','$80','2014-01-06']]with open('E:\pyProjects\csvTest-data2.csv','w',newline='') as data:    writer = csv.writer(data)    for item in items:        writer.writerow(item)

或者以默认方式逐行

import csvitems = [['1','LawnMower','Small Hover mower','Fred','$150','Excellent','2012-01-05'],['2','LawnMower','Ride-on mower','Mike','$370','Fair','2012-04-01'],['3','Bike','BMX bike','Joe','$200','Good','2013-03-22'],['4','Drill','Heavy duty hammer','Rob','$100','Good','2013-10-28'],['5','Scarifier','Quality, stainless steel','Anne','$200','2013-09-14'],['6','Sprinkler','Cheap but effective','Fred','$80','2014-01-06']]with open('E:\pyProjects\csvTest-data.csv','w') as data:    writer = csv.writer(data)    for item in items:        writer.writerow(item)

读取csv文件

import csvwith open('E:\pyProjects\csvTest-data.csv') as f:    datareader = csv.reader(f);    print (list(datareader))

import csvwith open('E:\pyProjects\csvTest-data.csv') as f:    datareader = csv.reader(f);    #print (list(datareader))    for line in datareader:        print (line)

0 0