1

2

3

4

5

6

7

8

9

10

import csv

data = [

    (1,"cat",18),

    (2,"dog",17),

    (3,"tigger",16),

]

f = open('test.csv','a',encoding='utf8',newline='')

writer = csv.writer(f)  # csv.writer()中可以传一个文件对象

for line in data: # 该data既可以是列表嵌套列表的数据类型也可以是列表嵌套元组的数据类型

    writer.writerow(line)

1

2

3

4

5

6

7

8

9

10

11

import csv

data = [

    {'id':1,'name':'dog',"age":18},

    {'id':2,'name':'cat',"age":19},

    {'id':3,'name':'dog',"age":20},

]

f = open('test1.csv','a',encoding='utf8',newline='')  # 指定newline=‘'参数

writer = csv.DictWriter(f,fieldnames=['id','name','age'])

writer.writeheader() # 将字段写入csv格式文件首行

for line in data:

    writer.writerow(line)