MongoDB is one of the most popular non-relational (also known as NoSQL database) databases. Non-relational or NoSQL databases do not have a fixed table structure or schema to be followed which makes the database very flexible and scalable. The data in NoSQL databases are stored in JSON-like format known as RSON. MongoDB is very convenient to use while dealing with large and unstructured data and hence it is the most widely used database in data analysis. It offers high speed and availability. In this article, let us see how can we connect our python script to MongoDB and perform desired operations.<\/p>\n\n\n\n
PyMongo is the native driver for connecting MongoDB and python. PyMongo has all the libraries to perform database operations from python code. Since pymongo is a low-level driver, it is fast and intuitive and provides more control. To install PyMongo, open your command line and type in the following command<\/p>\n\n\n
\nC:\\Users\\Your Name\\AppData\\Local\\Programs\\Python\\Python36-32\\Scripts>python -m pip install pymongo\n<\/pre><\/div>\n\n\nThis command would install PyMongo. We could install PyMongo in our script and start accessing the MongoDB resources.<\/p>\n\n\n\n
MongoDB databases<\/h2>\n\n\n\n
Now let us create a database in MongoDB. We will use the MongoClient() class of PyMongo to create the database. We will pass the correct localhost IP address and post to create the database. And use the client to give a desired name to the database.<\/p>\n\n\n
\nfrom pymongo import MongoClient\n\n#Creating a pymongo client\nclient = MongoClient('localhost', 27017)\n\n#Getting the database instance\ndb = client['mongodb1']\nprint("Database created.")\n\n#Verify the database\nprint("List of existing databases")\nprint(client.list_database_names())\n<\/pre><\/div>\n\n\nOutput<\/h2>\n\n\n\nDatabase created.\nList of existing databases:\n['admin', 'config', 'local', 'mongodb1']<\/pre>\n\n\n\nCreating a Collection<\/h2>\n\n\n\n
Inside a database, we can create multiple collections Collections can be compared to tables of the conventional database and we can store multiple records in the collection. Now, let us see how to create a collection inside a database. Also, note that our collection gets created when at least one document is inserted into it.<\/p>\n\n\n
\n#create a collection named "students"\nmycol = mydb["students"]\n<\/pre><\/div>\n\n\nInsert into Collection<\/h2>\n\n\n\n
Records are called documents in MongoDB. To insert a document into the collection, we should use the insert_one() method. We can pass the created document as an argument in the insert_one method. Let us understand how to insert a document with an example.<\/p>\n\n\n
\n#create a document\ntest = { "name": "Ripun", "class": "Seventh" }\n\n#insert a document to the collection\nx = mycol.insert_one(test)\n<\/pre><\/div>\n\n\nInserting multiple records<\/h2>\n\n\n\n
To insert multiple records into a collection, we can use insert_many() method. To implement this, we will first create a list with multiple documents and pass them on to insert_many() method.<\/p>\n\n\n\n
mylist = [
{ “name”: “Amy”, “class”: “Seventh”},
{ “name”: “Hannah”, “class”: “Sixth”},
{ “name”: “Viola”, “class”: “Sixth”}] x= mycol.insert_many(mylist)<\/p>\n\n\n\n
We can also insert them with their ids.<\/p>\n\n\n
\nmylist = [ {\u00a0"_id":1,"name":\u00a0"Amy",\u00a0"class":\u00a0"Seventh"},\n\u00a0\u00a0{\u00a0"_id":2,"name":\u00a0"Hannah",\u00a0"class":\u00a0"Sixth"},\n\u00a0 {\u00a0"_id":3,"name":\u00a0"Viola",\u00a0"class":\u00a0"Sixth"}] \n\nx = mycol.insert_many(mylist)\n\nprint(x.inserted_ids)\n\n<\/pre><\/div>\n\n\nAccessing the documents from collection<\/h2>\n\n\n\n
Now once the collection is structured and loaded with data, we would want to access them based on our requirements. To access the data, we can use the find() method. <\/p>\n\n\n\n
find_one() method returns the first occurrence in the collection. <\/p>\n\n\n\n
find() method returns all the occurrences in the collection. find() method when used without any parameter behaves the same way as Select all in SQL.<\/p>\n\n\n\n
Output<\/h2>\n\n\n\nx = mycol.find_one()\n\n# This prints the first document\nprint(x)\n\nfor x in mycol.find():\n print(x)\n<\/pre><\/div>\n\n\nSometimes, we would want to retrieve only particular fields of the document. To include the field in the result the value of the parameter passed should be 1, if the value is 0 then it will be excluded from the result.<\/p>\n\n\n
\nfor x in mycol.find({},{ "_id": 0, "name": 1, "class": 1 }):\n print(x)\n<\/pre><\/div>\n\n\nThe above code will just return the name and the class field from our collection and excludes the id field.<\/p>\n\n\n\n
Querying the MongoDB Database <\/h2>\n\n\n\n
We can use find() to retrieve results in more refined way by using the query object. <\/p>\n\n\n\n
Operators<\/h3>\n\n\n\n
Following is the list of operators used in the queries in MongoDB.<\/p>\n\n\n\nOperation<\/th> Syntax<\/th> Example<\/th><\/tr> Equality<\/td> {“key” : “value”}<\/td> db.mycol.find({“by”:”tutorials point”})<\/td><\/tr> Less Than<\/td> {“key” :{$lt:”value”}}<\/td> db.mycol.find({“likes”:{$lt:50}})<\/td><\/tr> Less Than Equals<\/td> {“key” :{$lte:”value”}}<\/td> db.mycol.find({“likes”:{$lte:50}})<\/td><\/tr> Greater Than<\/td> {“key” :{$gt:”value”}}<\/td> db.mycol.find({“likes”:{$gt:50}})<\/td><\/tr> Greater Than Equals<\/td> {“key” {$gte:”value”}}<\/td> db.mycol.find({“likes”:{$gte:50}})<\/td><\/tr> Not Equals<\/td> {“key”:{$ne: “value”}}<\/td> db.mycol.find({“likes”:{$ne:50}})<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nExample Code:<\/strong><\/p>\n\n\n\nThe following code retrieves the document where the name field is Sathish.<\/p>\n\n\n
\nfrom pymongo import MongoClient\n\n#Creating a pymongo client\nclient = MongoClient('localhost', 27017)\n\n#Getting the database instance\ndb = client['sdsegf']\n\n#Creating a collection\ncoll = db['example']\n\n#Inserting document into a collection\ndata = [\n {"_id": "1001", "name": "Ram", "age": "26", "city": "Hyderabad"},\n {"_id": "1002", "name": "Mukesh", "age": "27", "city": "Bangalore"},\n {"_id": "1003", "name": "Vel", "age": "28", "city": "Mumbai"},\n {"_id": "1004", "name": "Sathish", "age": "25", "city": "Pune"},\n {"_id": "1005", "name": "Rashiga", "age": "23", "city": "Delhi"},\n {"_id": "1006", "name": "Priya", "age": "26", "city": "Chennai"}\n]\nres = coll.insert_many(data)\nprint("Data inserted ......")\n\n#Retrieving data\nprint("Documents in the collection: ")\n\nfor doc1 in coll.find({"name":"Sathish"}):\n print(doc1)\n<\/pre><\/div>\n\n\nOutput<\/strong><\/p>\n\n\n\nData inserted ......\nDocuments in the collection:\n{'_id': '1004', 'name': 'Sathish', 'age': '25', 'city': 'Pune'}\n<\/pre>\n\n\n\nNow let us retrieve the records with persons whose age is greater than 25. We will use the $gt operator to implement it.<\/p>\n\n\n\n
for doc in coll.find({\"age\":{\"$gt\":\"25\"}}):\n print(doc)<\/pre>\n\n\n\nOutput<\/strong><\/p>\n\n\n\n{“_id”: “1002”, “name”: “Mukesh”, “age”: “27”, “city”: “Bangalore”}
{“_id”: “1003”, “name”: “Vel”, “age”: “28”, “city”: “Mumbai”}<\/p>\n\n\n\n
In the similar fashion, we can use $lt to filter the records with the value lesser than our specified value. We can also use these operators on a string. For example when we use “name”:{“$gt”:”J”} to retrieve all the records with names starting with ‘J’ or with the alphabets after that.<\/p>\n\n\n\n
Delete Operation in Python MongoDB<\/h2>\n\n\n\n
We can use the delete_one() method to delete one document.<\/p>\n\n\n\n
The first parameter of the\u00a0delete_one()<\/code>\u00a0method is a query object which indicates the document to be deleted.<\/p>\n\n\n\nmyquery = {"name" : "Mukesh"}\n\ncoll.delete_one(myquery)\n<\/pre><\/div>\n\n\nTo delete multiple documents, we can use the delete_many() method.<\/p>\n\n\n
\nmyquery = { "name": {"$regex": "^S"} }\n\nx = coll.delete_many(myquery)\n\n<\/pre><\/div>\n\n\nThe above code will delete all the records where the person’s name starts with ‘S’ or the letters that are alphabetically placed after S.<\/p>\n\n\n\n
To delete all documents in a collection, we can pass an empty query object to the\u00a0delete_many()<\/code>\u00a0method. The below code will delete all the documents present in the collection.<\/p>\n\n\n\nx = coll.delete_many({})\n<\/pre><\/div>\n\n\nIf we would want to delete the whole collection itself, we can use the drop() method. <\/p>\n\n\n\n
coll.drop()<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
In this article, we have seen about connecting MongoDB to python and performing various required and essential operations on it. The readers are strongly encouraged to get some hands-on experience with MongoDB and make themselves familiar on the syntax and various queries.<\/p>\n\n\n\n
References<\/h2>\n\n\n\n
https:\/\/www.mongodb.com\/languages\/python<\/a><\/p>\n\n\n\n