Skip to content

Instantly share code, notes, and snippets.

@dewdsp

dewdsp/import_csv_to_mongo

Forked from mprajwala/import_csv_to_mongo
Created January 26, 2020 11:53
Show Gist options
  • Save dewdsp/10b30410b4a2244928488c36530a565b to your computer and use it in GitHub Desktop.
Save dewdsp/10b30410b4a2244928488c36530a565b to your computer and use it in GitHub Desktop.
Download ZIP
Store CSV data into mongodb using python pandas
Raw
import_csv_to_mongo
#!/usr/bin/env python
import sys
import pandas as pd
import pymongo
import json
def import_content(filepath):
mng_client = pymongo.MongoClient('localhost', 27017)
mng_db = mng_client['mongodb_name'] // Replace mongo db name
collection_name = 'collection_name' // Replace mongo db collection name
db_cm = mng_db[collection_name]
cdir = os.path.dirname(__file__)
file_res = os.path.join(cdir, filepath)
data = pd.read_csv(file_res)
data_json = json.loads(data.to_json(orient='records'))
db_cm.remove()
db_cm.insert(data_json)
if __name__ == "__main__":
filepath = '/path/to/csv/path' // pass csv file path
import_content(filepath)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment