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()