【查询mongodb 结果后写入csv】教程文章相关的互联网学习教程文章

查询mongodb 结果后写入csv【代码】

import pymongoimport codecsimport csvclient = pymongo.MongoClient(‘ip‘,port)db=client.admindb.authenticate("user", "password", mechanism=‘SCRAM-SHA-1‘)database = "databasename"db = client[database]collection = "collection_name"db_coll = db[collection]with codecs.open(‘d:\data18.csv‘,‘w‘,‘utf-8‘) as csvfile: writer = csv.writer(csvfile) #写入csv的字段,需要的继续后面添加 writer.writ...

查询mongodb 结果后写入csv【代码】

import pymongoimport codecsimport csvclient = pymongo.MongoClient(ip,port)db=client.admindb.authenticate("user", "password", mechanism=SCRAM-SHA-1)database = "databasename"db = client[database]collection = "collection_name"db_coll = db[collection]with codecs.open(d:\data18.csv,w,utf-8) as csvfile: writer = csv.writer(csvfile) #写入csv的字段,需要的继续后面添加 writer.writerow([user_id,work_u...