CSV文件简单操作

简单读取csv文件

# coding: utf-8
import csv
csvfile = file('csv_test.csv', 'rb')
reader = csv.reader(csvfile)
for line in reader:
    print line
csvfile.close() 

csv.reaer 比用f.open().readlines()快很多。

简单写入csv文件

import csv
csvfile = file('csvtest.csv', 'wb')
writer = csv.writer(csvfile)
writer.writerow(['school', 'name', 'sex'])
data = [
  ('scut', 'wy', 'man'),
  ('hbsf', 'zt', 'woman')
 
]
writer.writerows(data)
csvfile.close()

with open('t.csv','wb') as myFile:      
    myWriter=csv.writer(myFile)  
    myWriter.writerow([7,'g'])  
    myWriter.writerow([8,'h'])  
    myList=[[1,2,3],[4,5,6]]  
    myWriter.writerows(myList)