Pandas写入DataFrame到MongoDB数据库

#-*- coding:utf-8 -*-
import sys
import pandas as pd
import json
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['wangdong']
        self.collection=self.db[self.collection]
    def closeDB(self):
        self.con.close()


if __name__ =='__main__':
    mongo=MongoBase('test')
    dicts = {'one': [1, 2, 3], 'two': [2, 3, 4], 'three': [3, 4, 5]}
    df = pd.DataFrame(dicts)
    mongo.collection.insert(json.loads(df.T.to_json()).values())
    mongo.closeDB()
    print json.loads(df.T.to_json()).values()