jmquintana79
8/30/2016 - 7:48 AM

store Pandas dataframe content into MongoDb

Store Pandas dataframe content into MongoDb

from pymongo import MongoClient 
from odo import odo
import pandas as pd

# open connection
connection = MongoClient()

# pandas df creation
DF = pd.DataFrame({'A': [1,2,3,4,5,6,7], 'B':[10,20,30,40,50,60,70]})
# database connection
db = connection.<database>

# insert df into mongo <table> 
odo(DF, db.<table>)