Import CSV file data into MongoDB using Python

Research_Project · February 11, 2021, 6:50pm

Hello, I am saving eye-coordinates into a csv file using Python. Once the application ends, the csv file is saved to my local computer. At the same time I want to export the data (in a csv file) to mongoDB.

I am only new to this and I can’t seem to figure it out. Any help would be very appreciated and if you have any questions, ask away.

Thanks.

DK2021 · February 11, 2021, 11:32pm

or

gist.github.com

https://gist.github.com/jxub/f722e0856ed461bf711684b0960c8458

pandas_labeled_csv_import_to_mongo.py

import pandas as pd
from pymongo import MongoClient
import json

def mongoimport(csv_path, db_name, coll_name, db_url='localhost', db_port=27000)
    """ Imports a csv file at path csv_name to a mongo colection
    returns: count of the documants in the new collection
    """
    client = MongoClient(db_url, db_port)
    db = client[db_name]

This file has been truncated. show original

By the way, its importing into the database.

Research_Project · February 12, 2021, 1:19am

Thank you very much for your help. I will try this tomorrow and I will let you know how I got on. Thanks again.