csv文件读写处理

桃扇骨 2021-10-01 04:14 334阅读 0赞

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)

转载于:https://www.cnblogs.com/hbxZJ/p/9498067.html