csv文件读写处理

csv文件读写处理

 

1.读取

第一种：

import csv
with open("route.csv","r") as f:
    #reader是一个迭代器
    reader=csv.reader(f)
    next(reader)  #输出结果会去掉行头标题
    for row in reader:
        name=row[0]
        dates=row[-1]
        print({"name":name,"date":dates})

第二种：字典方式读取

import csv
with open("route.csv","r") as f:
    #使用DictReader创建的reader是一个迭代器，遍历迭代器返回的数据是一个字典(有序字典)
    #返回的结果不包含行首的标题
    reader=csv.DictReader(f)
    for row in reader:
        # print(row) #遍历迭代器返回的数据是一个字典(有序字典)
        print(row["昵称"],row["院系信息"])

 2.写入

第一种：

import csv
headers=["username","age","addr"]
values={
    ("张三",23,"满城"),
    ("李四",24,"保定"),
    ("王五",25,"衡水"),
    ("赵六",26,"邯郸")
}
with open("name.csv","w",encoding="utf-8",newline="") as f: #newline换行符为空，默认为\n
    writer=csv.writer(f)
    writer.writerow(headers) #写入行首标题
    writer.writerows(values) #写入多行

第二种：

import csv
headers=["username","age","addr"]
values=[
    {"username":"张三","age":23,"addr":"保定"},
    {"username":"李四","age":23,"addr":"邯郸"},
    {"username":"王五","age":23,"addr":"石家庄"},
    {"username":"赵六","age":23,"addr":"衡水"},
]

with open("name2.csv","w",encoding="utf-8",newline="") as f:
    writer=csv.DictWriter(f,headers)
    #写入表头的时候需要写入writerheader方法
    writer.writeheader()
    writer.writerows(values)