写入csv文件 (注意需要有E:\pyProjects这个文件夹) 空了一行
import csv
items = [['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 csv
items = [['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 csv
with open('E:\pyProjects\csvTest-data.csv') as f:
datareader = csv.reader(f);
print (list(datareader))
import csv
with open('E:\pyProjects\csvTest-data.csv') as f:
datareader = csv.reader(f);
#print (list(datareader))
for line in datareader:
print (line)