{"id":3008,"date":"2024-03-27T11:23:27","date_gmt":"2024-03-27T06:23:27","guid":{"rendered":"https:\/\/afzalbadshah.com\/?p=3008"},"modified":"2024-03-27T11:23:31","modified_gmt":"2024-03-27T06:23:31","slug":"visualizing-data-from-mongodb-collection-using-python","status":"publish","type":"post","link":"https:\/\/afzalbadshah.com\/index.php\/2024\/03\/27\/visualizing-data-from-mongodb-collection-using-python\/","title":{"rendered":"Visualizing Data from MongoDB Collection using Python"},"content":{"rendered":"\n

Data visualization is a crucial aspect of data analysis, allowing us to gain insights and make informed decisions. MongoDB, a popular NoSQL database, offers flexibility in storing and retrieving data, making it a preferred choice for many applications. In this tutorial, we will explore how to visualize data retrieved from a MongoDB collection using Python. You can visit the detailed tutorial on MongoDB and Data Science here. <\/a><\/p>\n\n\n\n

Code Overview<\/strong><\/h3>\n\n\n\n

Below is the Python code to connect to a MongoDB Atlas cluster, retrieve data from a specified collection, and visualize it using matplotlib;<\/p>\n\n\n\n

# Import Required Libraries\nimport pymongo\nimport matplotlib.pyplot as plt\n\n# Connect to MongoDB Atlas\nclient = pymongo.MongoClient(\"mongodb+srv:\/\/user:password@cluster0.ergtejf.mongodb.net\/?retryWrites=true&w=majority&appName=Cluster0\")\n\n# Select the Database and Collection\ndb = client.database\ncollection = db.collection\n\n# Define a Function to Plot Data\ndef plot_data():\n    try:\n        # Retrieve data from MongoDB Atlas\n        cursor = collection.find()\n\n        # Initialize lists to store ids\n        ages = []\n\n        # Extract ids from documents\n        for document in cursor:\n            ages.append(document['age'])\n\n        # Plotting\n        plt.figure(figsize=(10, 6))\n        plt.plot(ages)\n        plt.title('ID Data from MongoDB Collection')\n        plt.xlabel('Index')\n        plt.ylabel('ID')\n        plt.grid(True)\n        plt.show()\n\n    except Exception as e:\n        print(\"An error occurred:\", e)\n\n# Call the Function to Plot Data\nplot_data()<\/code><\/pre>\n\n\n\n
Explanation of Code<\/strong><\/h3>\n\n\n\n
Import Required Libraries<\/strong><\/p>\n\n\n\n
# Import Required Libraries\nimport pymongo  # Importing pymongo library for MongoDB interaction\nimport matplotlib.pyplot as plt  # Importing matplotlib.pyplot for plotting<\/code><\/pre>\n\n\n\n
This line imports necessary libraries for our program, including pymongo<\/code> for MongoDB interaction and matplotlib.pyplot<\/code> for plotting.<\/p>\n\n\n\n
Connect to MongoDB Atlas<\/strong><\/p>\n\n\n\n
# Connect to MongoDB Atlas\nclient = pymongo.MongoClient(\"mongodb+srv:\/\/user:password@cluster0.ergtejf.mongodb.net\/?retryWrites=true&w=majority&appName=Cluster0\")  # Establishing connection to MongoDB Atlas<\/code><\/pre>\n\n\n\n
This section establishes a connection to MongoDB Atlas by providing the connection string generated from the MongoDB dashboard. Use your database connection string with correct username and password.<\/p>\n\n\n\n
Select the Database and Collection<\/strong><\/p>\n\n\n\n
# Select the Database and Collection\ndb = client.database# Selecting the \"afzal\" database\ncollection = db.collection  # Selecting the \"afzal\" collection within the database<\/code><\/pre>\n\n\n\n
Here, we specify the database and collection within MongoDB that we want to retrieve data from. In this case, it’s the “database” database and “collection” collection.<\/p>\n\n\n\n
Define a Function to Plot Data<\/strong><\/p>\n\n\n\n
# Define a Function to Plot Data\ndef plot_data():\n    try:\n        # Retrieve data from MongoDB Atlas\n        cursor = collection.find()  # Retrieving data from the specified collection\n\n        # Initialize lists to store ids\n        ages = []  # Initializing an empty list to store ids from documents\n\n        # Extract ids from documents\n        for document in cursor:\n            ages.append(document['age'])  # Appending each 'id' to the ids list\n\n        # Plotting\n        plt.figure(figsize=(10, 6))  # Setting figure size\n        plt.plot(ages)  # Plotting the ids data\n        plt.title('ID Data from MongoDB Collection')  # Setting title for the plot\n        plt.xlabel('Index')  # Setting label for x-axis\n        plt.ylabel('ID')  # Setting label for y-axis\n        plt.grid(True)  # Enabling grid lines\n        plt.show()  # Displaying the plot\n\n    except Exception as e:\n        print(\"An error occurred:\", e)  # Handling exceptions if any error occurs during the process<\/code><\/pre>\n\n\n\n
This section defines a function named plot_data()<\/code> to encapsulate the process of retrieving data from MongoDB and plotting it.<\/p>\n\n\n\n
Retrieve Data from MongoDB Atlas:<\/strong><\/p>\n\n\n\n
# Retrieve Data from MongoDB Atlas\ncursor = collection.find()  # Retrieving data from the specified collection<\/code><\/pre>\n\n\n\n
We use the find()<\/code> method to retrieve data from the specified MongoDB collection. The results are stored in a cursor.<\/p>\n\n\n\n
Initialize Lists and Extract IDs:<\/strong><\/p>\n\n\n\n
# Initialize Lists and Extract IDs\nids = []  # Initializing an empty list to store ids from documents\nfor document in cursor:\n    ids.append(document['id'])  # Appending each 'id' to the ids list<\/code><\/pre>\n\n\n\n
We initialize an empty list named ids<\/code> to store the ‘id’ field from each document retrieved from MongoDB. Then, we iterate through the cursor and append each ‘id’ to the ids<\/code> list.<\/p>\n\n\n\n
Plotting:<\/strong><\/p>\n\n\n\n
# Plotting\nplt.figure(figsize=(10, 6))  # Setting figure size\nplt.plot(ids)  # Plotting the ids data\nplt.title('ID Data from MongoDB Collection')  # Setting title for the plot\nplt.xlabel('Index')  # Setting label for x-axis\nplt.ylabel('ID')  # Setting label for y-axis\nplt.grid(True)  # Enabling grid lines\nplt.show()  # Displaying the plot<\/code><\/pre>\n\n\n\n
Using matplotlib<\/code>, we plot the data stored in the ids<\/code> list. We set labels for the axes, title for the plot, and enable grid lines for better visualization.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Exception Handling:<\/strong><\/p>\n\n\n\n
except Exception as e:\n    print(\"An error occurred:\", e)  # Handling exceptions if any error occurs during the process<\/code><\/pre>\n\n\n\n
We include exception handling to catch any errors that might occur during the process of data retrieval or plotting.<\/p>\n\n\n\n
Call the Function to Plot Data:<\/strong><\/p>\n\n\n\n
# Call the Function to Plot Data\nplot_data()  # Calling the function to execute the code and visualize the data<\/code><\/pre>\n\n\n\n
Finally, we call the plot_data()<\/code> function to execute the code and visualize the data from the MongoDB collection.<\/p>\n","protected":false},"excerpt":{"rendered":"
Data visualization is a crucial aspect of data analysis, allowing us to gain insights and make informed decisions. MongoDB, a popular NoSQL database, offers flexibility in storing and retrieving data, making it a preferred choice for many applications. In this tutorial, we will explore how to visualize data retrieved from a MongoDB collection using Python. You can visit the detailed tutorial on MongoDB and Data Science here. Code Overview Below is the Python code to connect to a MongoDB Atlas…<\/p>\n
 Read More  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":3014,"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":[549,522,502],"class_list":["post-3008","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-driven-applications-using-mongodb-python-and-google-colab","tag-data-visulization","tag-mongodb","tag-python"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t