csv应用

什么是csv？

CSV (Comma Separated Values)，即逗号分隔值（也称字符分隔值，因为分 隔符可以不是逗号），是⼀种常⽤的⽂本格式，⽤以存储表格数据，包括数字 或者字符。很多程序在处理数据时都会碰到csv这种格式的⽂件。python⾃带了 csv模块，专⻔⽤于处理csv⽂件的读取 csv模块的使⽤

写入csv

1 通过创建writer对象，主要⽤到2个⽅法。⼀个是writerow，写⼊⼀⾏。另 ⼀个是writerows写⼊多⾏
2使⽤DictWriter 可以使⽤字典的⽅式把数据写⼊进去

读取csv

1 通过reader()读取到的每⼀条数据是⼀个列表。可以通过下标的⽅式获取具 体某⼀个值 2 通过DictReader()读取到的数据是⼀个字典。可以通过Key值(列名)的⽅式获取数据

import csv
#第一种 一行写入
title=('name',"age",'height')
persons=[('面条个','30','181'),('天罡','20','171'),('个念','18','178')]
"""
with open("persons.csv","w",encoding="utf-8",newline="") as file_obj:
    writer=csv.writer(file_obj)
    writer.writerow(title)
    for data in persons:
        writer.writerow(data)
"""
"""
#写入多行
with open("persons.csv","w",encoding='gbk',newline="") as file_obj:
    writer=csv.writer(file_obj)
    writer.writerow(title)
    writer.writerows(persons)
   """
#第二种
"""
person=[{"name":'面涛哥','age':30,"height":178},{"name":'喜羊羊','age':0,"height":78},{"name":'灰太狼','age':23,"height":188}]

with open('persons.csv','w',encoding="gbk",newline="") as file_obj:
    writer=csv.DictWriter(file_obj,title)
    writer.writeheader()
    writer.writerows(person)
"""
#读取数据
"""

with open('persons.csv','r',encoding="gbk") as file_obj:
    reader=csv.reader(file_obj)
    for x in reader:
        print(x)
"""

with open("persons.csv",'r',encoding="gbk") as file_obj:
    reader=csv.DictReader(file_obj)
    for x in reader:
        print(x['name'])#键值要一致