一、以元组的方式写入
(1)writerow,一次写入一行,可以写入一个列表的所有数据
(2)writerows,一次写入多行,可以写入列表中,多个为元祖的元素
import csv
def writer_csv_demo1():
headers = ["name","age","height"]
values = [
("王五1",18,178),
("张三1",20,180),
("赵六1",17,166)
]
with open("test_write.csv","w",encoding="utf-8",newline="") as fp:
writer = csv.writer(fp)
writer.writerow(headers) #一次写入一行
writer.writerows(values) #一次写入多行
writer_csv_demo1()
二、以字典的形式写入(推荐使用)
import csv
def writer_csv_demo2():
headers = ["name", "age", "height"]
values = [
{"name":"王11","age":18,"height":178},
{"name":"王22","age":18,"height":178},
{"name":"王33","age":18,"height":178}
]
with open("test_write2.csv","w", encoding="utf-8",newline="") as fp: #newline=""去掉两行之间的空行
writer = csv.DictWriter(fp,headers) # 使用csv.DictWriter()方法,需传入两个个参数,第一个为对象,第二个为文件的title
writer.writeheader() # 使用此方法,写入表头
writer.writerows(values) #写入多行,每一行是一个字格式的数据
writer_csv_demo2()