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) |
