Skip to content

Instantly share code, notes, and snippets.

@adrianrocamora

adrianrocamora/pandas_to_mongodb.py

Forked from jmquintana79/pandas_to_mongodb.py
Created September 30, 2020 17:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save adrianrocamora/44d666bba8e211a3320a9286a3e18232 to your computer and use it in GitHub Desktop.
Save adrianrocamora/44d666bba8e211a3320a9286a3e18232 to your computer and use it in GitHub Desktop.
Download ZIP
Store Pandas dataframe content into MongoDb
Raw
pandas_to_mongodb.py
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>)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment