csv模块的使用

1.csv模块

• 是python的内置模块，跨多种形式导入导出数据，excel进行打开
• 格式可以是.csv .json .html .txt

2.写入csv文件

• 1.通过创建writer对象用到了writerow是写入一行，用writerows是写入多行的

import csv

headers = ('name','age','sex')

persons = [
    ('张三',16,'男'),
    ('李四',15,'男'),
    ('王麻子',13,'女')
]

with open('img.csv','w',encoding='utf-8',newline='') as f:
    writer = csv.writer(f)
    writer.writerow(headers)
    writer.writerows(persons)
    #for i in persons:
    #  writer.writerow(i)

以下这个点击可以对比代码

• 2.用Dictwriter可以使用字典的方式把数据写入进去

headers = ('name','age','sex')

persons = [
    {'name':'张三','age':16,'sex':'男'},
    {'name':'李四','age':15,'sex':'男'},
    {'name':'王麻子','age':13,'sex':'女'}
]

with open('img.csv','w',encoding='utf-8',newline='') as f:
    writer = csv.DictWriter(f,headers)
    writer.writeheader()
    writer.writerows(persons)
    # for i in persons:
    #     writer.writerow(i)

3.读取csv文件

• 1.通过reader（）读取到的每一条数据是列表，可以通过下标的方式获取每一个值

with open('img.csv','r',encoding='utf-8',newline='') as f:
   reader = csv.reader(f)
   for i in reader:
       print(i)

• 2.通过Dictreader（）读取到的是一个字典，通过key值方式获取数据

with open('img.csv','r',encoding='utf-8',newline='') as f:
    Dreader = csv.DictReader(f)
    for i in Dreader:
        print(i)
        print(i['name'])

• 直接print（i）得到的是一个字典我们需要查找他的key值来查找数据