Writer函数：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
import csv headers = ["username","age","country"] values = [("张三",18,"china"), ("李四",19,"china") ] with open("test.csv","w",encoding="utf-8",newline="") as fp: writer = csv.writer(fp) writer.writerow(headers) #吸入一行数据，写入表头数据 writer.writerows(values) #在写入的时候要注意两个问题，一个编码问题，一个是newline参数问题 #如果不给定newline参数，默认是给一个\n，会导致csv文件中每行数据之间有空行，#只需要给一个空字符即可解决 |
DictWriter函数：
|
1 2 3 4 5 6 7 8 9 10 11 12 |
import csv headers = ["name","age","country"] values = [{"name":"张三","age":18,"country":"china"}, {"name":"李四","age":18,"country":"china"}, {"name":"王五","age":18,"country":"china"} ] with open("test.csv","w",encoding="utf-8",newline="") as fp: writer = csv.DictWriter(fp,headers) writer.writeheader() #只有使用writeheader()后才会写入表头数据，光是建立writer不会吸入 writer.writerows(values) |
