CSV文件储存

#csv

import csv

写入 默认逗号分隔

 with open('date.csv','w')as f:
     writer = csv.writer(f)
     writer.writerow(['id','name','age'])
     writer.writerow(['10001','Mike',20])
     writer.writerow(['10002','Bob',22])
     writer.writerow(['10003','Jordan',21])

写入 列与列间分隔符 delimiter()

 with open('date.csv','w')as f:
     writer = csv.writer(f,delimiter=' ')
     writer.writerow(['id','name','age'])
     writer.writerow(['10001','Mike',20])
     writer.writerow(['10002','Bob',22])
     writer.writerow(['10003','Jordan',21])

写入 同时写入多行writerows()

 with open('date.csv','w')as f:
     writer = csv.writer(f,delimiter=',')
     writer.writerow(['id','name','age'])
     writer.writerows([['10001','Mike',20],['10002','Bob',22],['10003','Jordan',21]])

写入 字典方式写入

 with open('date.csv','w')as f:
     fieldnames = ['id','name','age']
     writer = csv.DictWriter(f,fieldnames=fieldnames)
     writer.writeheader()
     writer.writerow({'id': '10001','name':'Mike','age':20})
     writer.writerow({'id': '10002', 'name': 'Bob', 'age': 22})
     writer.writerow({'id': '10003', 'name': 'Jordan', 'age': 21})

写入 追加

 with open('date.csv','a',encoding='utf-8')as f:
     fieldnames = ['id','name','age']
     writer = csv.DictWriter(f,fieldnames=fieldnames)
     # writer.writeheader()
     writer.writerow({'id': '10001','name':'王磊','age':20})

读取

 with open('date.csv','r',encoding='utf-8')as f:
     reader = csv.reader(f)
     print(type(reader))
     for row in reader:
         print(row)

读取 也可以用pandas读取

import pandas as pd
df = pd.read_csv('date.csv')
print(df)