java中的接口是类吗
273
2022-08-30
爬虫学习(16):CSV文件存储(爬虫数据写入csv)
写入:
import csvwith 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 csvwith 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 csvwith 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 pdd=pd.read_csv('bb.csv')print(d)
版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。
发表评论
暂时没有评论,来抢沙发吧~