python自带CSV包,支持读写CSV文件,API很简单
1、open函数创建文件句柄fd
2、通过csv.writer(fd)构建写对象writer, csv.reader(fd)构建读对象reader
3、writer.writerow()写单行,writer.writerrows()写多行
4、reader可以使用next(),或者in做读写
with open('test.csv', 'w') as f:
#在windows平台要加上lineterminator='\n', 不然每行之后都会有一个空行
#在linux平台不需要
writer = csv.writer(f, lineterminator='\n')
writer.writerow(['Name', 'Sex', 'Age'])
writer.writerows([['xiaoming', 'Male', '7'], ['xiaohua', 'Female', '6'], ['laowang', 'Male', 60]])
with open('test.csv', 'r') as f:
reader = csv.reader(f,delimiter=',')
#reader是一个迭代器,使用next()可以读取一行
header = next(f)
for line in reader:
print 'Name:', line[0]
print 'Sex:',line[1]
print 'Age:', line[2]