Import CSV file data into MongoDB using Python

In this tutorial, we will share with you how to import CSV file data into MongoDB using Python. While developing an application using Python, sometimes we need to insert CSV data into the MongoDB database. Inserting CSV data to MongoDB is very easy in Python. We just need t read the CSV file and then connect to MongoDB to insert data. We will use CSV built-in module to read CSV files. We will use module pymongo to connect with the MongoDB client and insert data.

Also Read : Import/Export Data to CSV file with CodeIgniter and MySQL

So let’s start firstly Install PyMongo Module :

Install PyMongo Module

As we need to connect with the MongoDB client, so we need to install pymongo module using below command.

pip install pymongo

1	pip install pymongo

Connect to MongoDB

We will import module pymongo to connect with MongoDB to insert records.

from pymongo import MongoClient

1	from pymongo import MongoClient

We will configure MongoDB connection details and connection to the database and collection to insert records.

mongoClient = MongoClient() 
db = mongoClient.october_mug_talk
db.segment.drop()

mongoClient = MongoClient()

db = mongoClient.october_mug_talk

db.segment.drop()

Reading CSV File

As we will insert CSV file data to the MongoDB. So we will import the CSV module at the top of the file to read the CSV file.

import csv

1	import csv

We will CSV file employee using DictReader() method. The DictReader() function returns a csv reader object.

csvfile = open('current.csv', 'r')
reader = csv.DictReader( csvfile )

1 2	csvfile = open('current.csv', 'r') reader = csv.DictReader( csvfile )

We will iterate over CSV reader object and create JSON data to insert multiple records into MongoDB.

for each in reader:
    row={}
    for field in header:
        row[field]=each[field]

for each in reader:

row={}

for field in header:

row[field]=each[field]

Insert data into MongoDB

We will insert json row data into MongoDB.

db.segment.insert(row)

1	db.segment.insert(row)

Final code to insert CSV data into MongoDB

Now you can insert the JSON in your MongoDB database.

import csv
import json
import pandas as pd
import sys, getopt, pprint
from pymongo import MongoClient
#Conversion CSV to JSON 
csvfile = open('current.csv', 'r')
reader = csv.DictReader( csvfile )
mongo_client=MongoClient() 
db=mongo_client.october_mug_talk
db.segment.drop()
header= [ "First Name", "Last Name", "Email", "Mobile", "Address", "Date"]

for each in reader:
    row={}
    for field in header:
        row[field]=each[field]

    db.segment.insert(row)

import csv

import json

import pandas as pd

import sys, getopt, pprint

from pymongo import MongoClient

#Conversion CSV to JSON

csvfile = open('current.csv', 'r')

reader = csv.DictReader( csvfile )

mongo_client=MongoClient()

db=mongo_client.october_mug_talk

db.segment.drop()

header= [ "First Name", "Last Name", "Email", "Mobile", "Address", "Date"]

for each in reader:

row={}

for field in header:

row[field]=each[field]

db.segment.insert(row)

Also Read : Import/Upload Excel file into MySQL using Codeigniter