python csv 的读取和存入

读取csv 文件:

import csv
with open('文件名.csv',"r") as f:
     read 是一个迭代器
    read=csv.reader(f)
     1.这个能够打印出所有的行(带标题),遍历后是列表类型
    for x in read:
        print(x)
     2.不要标题 ,打印,遍历是字典类型
    next(read)
    for x in read:
        print(x)
 3. 要一个字典类型,
with open('文件名.csv', "r") as f:
    read=csv.DictReader(f)
    for x in read:
        print(x)

存储csv

import csv
1.写入表头信息
headers=["name","age","height"]
2. 要存入的信息
data=[
    ("张三",18,195),("李四",5,153),("美女",20,170)
]
3.newline 是指的是 不让他换行,如果没有他会写一个换一行.
with open('文件名.csv',"w",encoding="utf-8",newline='') as f:
    writer=csv.writer(f)
    写入一行表头
    writer.writerow(headers) 
    写入多行数据
    writer.writerows(data)

字典方法存进csv:

import csv
写入表头信息
headers=["name","age","height"]
要存入的信息
data=[
    {"name":"A","age":"1","height":"4"},
    {"name":"B","age":"2","height":"5"},
    {"name":"C","age":"3","height":"6"}
]
newline 是指的是 不让他换行,如果没有他会写一个换一行.
with open('文件名.csv',"w",encoding="utf-8",newline='') as f:
    writer=csv.DictWriter(f,headers)
    这里注意要自己写入表头
    writer.writeheader()
    writer.writerows(data)