Pandas读取MongoDB数据库到DataFrame

最新推荐文章于 2025-04-18 08:30:03 发布

data_scientist

最新推荐文章于 2025-04-18 08:30:03 发布

阅读量3.9k

点赞数 1

分类专栏： Pandas MongoDB 文章标签：数据库 mongodb Python pandas 读数据

本文链接：https://blog.youkuaiyun.com/data_scientist/article/details/54728967

版权

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