{"id":2928,"date":"2024-03-20T09:19:46","date_gmt":"2024-03-20T04:19:46","guid":{"rendered":"https:\/\/afzalbadshah.com\/?p=2928"},"modified":"2024-03-20T12:00:45","modified_gmt":"2024-03-20T07:00:45","slug":"printing-mongodb-collections-data-in-python","status":"publish","type":"post","link":"https:\/\/afzalbadshah.com\/index.php\/2024\/03\/20\/printing-mongodb-collections-data-in-python\/","title":{"rendered":"Printing MongoDB Collection&#8217;s Data in Python"},"content":{"rendered":"\n<p>In this tutorial, we&#8217;ll walk through the process of connecting to MongoDB Atlas, a cloud-based MongoDB service, from a Python environment. We&#8217;ll establish a connection to MongoDB Atlas, select a database and collection, retrieve data from the collection, and print it to the console using the <code>pymongo<\/code> library. This tutorial is suitable for beginners who are new to MongoDB and Python programming.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Printing Collection<\/h3>\n\n\n\n<p>Complete Program:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Import the Required Libraries\nimport pymongo\nfrom pymongo import MongoClient\n\n# Connect to MongoDB Atlas\nclient = pymongo.MongoClient(\"mongodb+srv:\/\/****:****@cluster0.ergtejf.mongodb.net\/?retryWrites=true&amp;w=majority&amp;appName=Cluster0\")\n\n# Select the Database and Collection\ndb = client.***\ncollection = db.***\n\n# Define a Function to Print Collection Data\ndef print_collection_data():\n    try:\n        # Retrieve data from MongoDB Atlas\n        cursor = collection.find()\n\n        # Print data\n        for document in cursor:\n            print(document)\n    except Exception as e:\n        print(\"An error occurred:\", e)\n\n# Call the Function to Print Collection Data\nprint_collection_data()<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Step 1: Import the Required Libraries<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import pymongo\nfrom pymongo import MongoClient<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We import the <code>pymongo<\/code> library, which allows us to interact with MongoDB from Python.<\/li>\n\n\n\n<li>We specifically import the <code>MongoClient<\/code> class from <code>pymongo<\/code> to establish a connection to the MongoDB server.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: Connect to MongoDB Atlas<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>client = pymongo.MongoClient(\"mongodb+srv:\/\/***:***@cluster0.ergtejf.mongodb.net\/?retryWrites=true&amp;w=majority&amp;appName=Cluster0\")<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We use the <code>MongoClient<\/code> class to establish a connection to the MongoDB Atlas cluster.<\/li>\n\n\n\n<li>The connection string <code>\"mongodb+srv:\/\/...\"<\/code> specifies the MongoDB Atlas URI, including the username, password, cluster address, and other parameters such as <code>retryWrites<\/code> and <code>w<\/code>.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 3: Select the Database and Collection<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>db = client.***\ncollection = db.***<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We select the database named *** using the <code>client.<\/code>*** syntax.<\/li>\n\n\n\n<li>Similarly, we select the collection named <code>*** <\/code> within the *** database using the <code>db.***<\/code> syntax.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 4: Define a Function to Print Collection Data<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>def print_collection_data():\n    try:\n        # Retrieve data from MongoDB Atlas\n        cursor = collection.find()\n\n        # Print data\n        for document in cursor:\n            print(document)\n    except Exception as e:\n        print(\"An error occurred:\", e)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We define a function named <code>print_collection_data()<\/code> to encapsulate the logic for printing collection data.<\/li>\n\n\n\n<li>Inside the function, we use a <code>try-except<\/code> block to handle exceptions that may occur during data retrieval.<\/li>\n\n\n\n<li>We use the <code>collection.find()<\/code> method to retrieve all documents from the specified collection.<\/li>\n\n\n\n<li>We iterate over the cursor returned by <code>find()<\/code> and print each document to the console.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 5: Call the Function to Print Collection Data<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>print_collection_data()<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We call the <code>print_collection_data()<\/code> function to execute the logic defined within it.<\/li>\n\n\n\n<li>This step triggers the connection to MongoDB Atlas, retrieval of data from the specified collection, and printing of the collection data to the console.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Printing Selected Columns Data<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>def print_names():\n    try:\n        # Retrieve data from MongoDB Atlas with projection for 'name' field\n        cursor = collection.find()\n\n        # Print names\n        for document in cursor:\n            print(document&#91;'name'])\n    except Exception as e:\n        print(\"An error occurred:\", e)\n\n# Call the Function to Print Names from Collection\nprint_names()<\/code><\/pre>\n\n\n\n<p>Explanation<\/p>\n\n\n\n<p>Here&#8217;s the explanation of each line of the above code:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Define a Function to Print Names from Collection\ndef print_names():<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We define a Python function named <code>print_names()<\/code> that will be responsible for retrieving and printing names from the MongoDB collection.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>    try:<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We begin a try block to handle potential exceptions that may occur during the execution of the code inside the block.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>        # Retrieve data from MongoDB Atlas with projection for 'name' field\n        cursor = collection.find()<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We use the <code>find()<\/code> method to retrieve data from the MongoDB collection named <code>collection<\/code>.<\/li>\n\n\n\n<li>We specify an empty filter <code>{}<\/code> as the first parameter to retrieve all documents in the collection.<\/li>\n\n\n\n<li>In the second parameter, we specify the projection to include only the &#8216;name&#8217; field and exclude the &#8216;_id&#8217; field. <code>{ \"_id\": 0, \"name\": 1 }<\/code>.<\/li>\n\n\n\n<li>The result of the <code>find()<\/code> method is assigned to the <code>cursor<\/code> variable, which contains the retrieved documents.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>        # Print names\n        for document in cursor:<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We iterate over each document in the <code>cursor<\/code> object using a for loop.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>            print(document&#91;'name'])<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Inside the loop, we print the value of the &#8216;name&#8217; field from each document using dictionary access (<code>document['name']<\/code>).<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>    except Exception as e:\n        print(\"An error occurred:\", e)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If any exceptions occur during the execution of the try block, they will be caught here.<\/li>\n\n\n\n<li>We print an error message along with the exception that occurred.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code># Call the Function to Print Names from Collection\nprint_names()<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We call the <code>print_names()<\/code> function to execute the code defined within it and print the names from the MongoDB collection.<\/li>\n<\/ul>\n\n\n\n<p>This code defines a function <code>print_names()<\/code> to retrieve and print names from a MongoDB collection and then calls this function to execute the retrieval and printing process.<\/p>\n\n\n\n<p><a href=\"https:\/\/afzalbadshah.com\/index.php\/category\/courses\/data-driven-applications-using-mongodb-python-and-google-colab\/\" target=\"_blank\" rel=\"noopener\" title=\"\">You can read a detailed tutorial related to MongoDB here. <\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we&#8217;ll walk through the process of connecting to MongoDB Atlas, a cloud-based MongoDB service, from a Python environment. We&#8217;ll establish a connection to MongoDB Atlas, select a database and collection, retrieve data from the collection, and print it to the console using the pymongo library. This tutorial is suitable for beginners who are new to MongoDB and Python programming. Printing Collection Complete Program: Step 1: Import the Required Libraries Step 2: Connect to MongoDB Atlas Step 3:&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/afzalbadshah.com\/index.php\/2024\/03\/20\/printing-mongodb-collections-data-in-python\/\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":2938,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[489],"tags":[522,537,502],"class_list":["post-2928","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-driven-applications-using-mongodb-python-and-google-colab","tag-mongodb","tag-printing","tag-python"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/afzalbadshah.com\/wp-content\/uploads\/2024\/03\/Slide1-6-jpg.webp?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pf3emP-Le","jetpack-related-posts":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/posts\/2928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/comments?post=2928"}],"version-history":[{"count":10,"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/posts\/2928\/revisions"}],"predecessor-version":[{"id":2959,"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/posts\/2928\/revisions\/2959"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/media\/2938"}],"wp:attachment":[{"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/media?parent=2928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/categories?post=2928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afzalbadshah.com\/index.php\/wp-json\/wp\/v2\/tags?post=2928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}