csv文件存储

import csv

with open('data.csv', 'w') as csvfile:

    writer = csv.writer(csvfile)

    writer.writerow(['id', 'name', 'age'])

同时可以写多行的内容

writer.writerow([['1010', 'tom', '28'], ['1023', 'jane', '23'], ['1022', 'wu', '27']])

csv同时也支持字典的写入方式

import csv

with open('data.csv', 'w') as csvfile:

    fieldnames = ['id', 'name', 'age']

    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)

    writer.writeheader()

    writer.writerow({'id':'20130001', 'name':'kris', 'age':'27'})

读取

import csv 

with open('data.csv', 'r', encoding='utf-8') as csvfile:

    reader = csv.reader(csvfile)

    for row in reader:

        print(row)