Pandas读取MongoDB数据库到DataFrame

原创于 2017-01-25 11:35:18 发布 · 3.9k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #mongodb #Python #pandas #读数据

Pandas 同时被 2 个专栏收录

5 篇文章

订阅专栏

MongoDB

4 篇文章

订阅专栏

#-*- coding:utf-8 -*-
import sys
import pandas as pd
from pymongo import MongoClient
reload(sys)
sys.setdefaultencoding('utf-8')

class MongoBase:
    def __init__(self,collection):
        self.collection=collection
        self.OpenDB()
    def OpenDB(self):
        user='******'
        passwd='******'
        host='******'
        port='******'
        auth_db='******'
        uri = "mongodb://"+user+":"+passwd+"@"+host+":"+port+"/"+auth_db+"?authMechanism=SCRAM-SHA-1"
        self.con = MongoClient(uri, connect=False)
        self.db=self.con['qq']
        self.collection=self.db[self.collection]
    def closeDB(self):
        self.con.close()


if __name__ =='__main__':
    query={'time':{'$regex':'2017-01-19'}}
    mongo=MongoBase('******')
    cursor = mongo.collection.find(query)
    df = pd.DataFrame(list(cursor))
    mongo.closeDB()
    del df['_id']
    print df