爬虫学习（16）：CSV文件存储

写入：

import csv
with open('data.csv','w',encoding='gbk') as f:  #如果是csv一定要用gbk编译方式，utf-8乱码
    writer=csv.writer(f)#writer方法初始化写入对象
    writer.writerow(['id','name','age'])#writerow写入每一行数据
    writer.writerow(['1','川川','20'])
    writer.writerow(['3','笨笨','21'])
    writer.writerow(['4','憨憨','21'])

去掉逗号：

import csv
with open('bb.csv','w',encoding='gbk') as f:
    writer=csv.writer(f,delimiter=' ')#writer方法初始化写入对象
    writer.writerow(['id','name','age'])#writerow写入每一行数据
    writer.writerow(['1','川川','20'])
    writer.writerow(['3','笨笨','21'])
    writer.writerow(['4','憨憨','21'])

多行写入：

  writer.writerow(['id','name','age'])
    writer.writerow([['1','川川','20'],['3','笨笨','21'],['4','憨憨','21']])

字典传入CSV:

 with open('bb.csv','w',encoding='gbk') as f:
 filename=['id','age','interest']
    writer=csv.DictWriter(f,fieldnames=filename)#初始化字典
    writer.writeheader()#写入头信息
    writer.writerow({'id':'1001','age':'15','interest':'play'})
    writer.writerow({'id':'1002','age':'25','interest':'ll'})

如果还要追加信息，把w改成a就好了

读取csv文件：

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

主要通过遍历打印出来

或者用简单的方法pandas的read_csv

import pandas as pd
d=pd.read_csv('bb.csv')
print(d)