CSV,python相关

#csv:纯文本,记录(每一行一条记录),每条记录被分隔符分割为字段,每条记录都有同样的字段序列(表)
import csv



#读取csv读取:
    #列表形式
with open("example.csv",'r') as fp:
    reader=csv.reader(fp)#reader是迭代器
    #next()函数就是对迭代器的下一个
    next(reader)
    for data in reader:
        print(data)

    #字典形式
with open("example.csv",'r') as fp:
    reader=csv.DictReader(fp)
    #reader是迭代器,返回的数据自然不包含第一行
    for data in reader:
        print(data)


#写入cav文件:
    #列表/元组转csv
with open("example.csv",'w',encoding="utf-8",newline="") as fp:
    #注意要调整编码和新行的参数

    writer=csv.writer(fp)
#两个具体的写入方法,只写入一行和写入多行
    writer.writerow(["姓名","年龄"])
    writer.writerows([["张三",25],["李四","27"]])

    #字典转csv:
with open("example.csv",'w',encoding="utf-8",newline="") as fp:
    #注意要调整编码和新行的参数

    writer=csv.DictWriter(fp,["姓名","年龄"])
    writer.writeheader()#要写入头部,所以麻烦一点
    writer.writerows([{"姓名":"张三","年龄":25},{"姓名":"李四","年龄":255}])