csv小结

读取csv方式

方式1

import csv
f = open('')
reader = csv.reader(r)
data_list = list(reader)

方式2,与方式一其实是一样的，推荐使用方式2.

import csv
with open('', 'r') as f:
    reader = csv.reader(f)
    data_list = list(reader)
    

写入csv方式

import csv
#输入文件名
file = ‘’
dates = [['name', 'age'],
         ['A', 11],
         ['B', 12],
         ['C', 13]]
with open(file, 'w',newline='') as f:
    writer = csv.writer(f)
    for row in datas:
        writer.writerow(row)

使用Dict方式进行读取和写入

读取

import csv

file = ‘’
with open(file) as f:
    reader = csv.DictReader(f)
    for row in reader:
        print(row)

写入

import csv

file = '1.csv'
headers = ['name', 'age']
dates = [{'name': 'A', 'age': 11},
         {'name': 'B', 'age': 12},
         {'name': 'C', 'age': 13},
         {'name': 'C', 'age': 13},
         ]
for line in dates:
    print(type(line))
    print(line['name'])
with open(file, 'w', newline='') as f:
    writer = csv.DictWriter(f, headers)
    writer.writeheader()
    writer.writerows(dates)