Aggregation in MongoDB using Python Last Updated : 03 Oct, 2022 Comments Improve Suggest changes Like Article Like Report See More MongoDB is free, open-source,cross-platform and document-oriented database management system(dbms). It is a NoSQL type of database. It store the data in BSON format on hard disk. BSON is binary form for representing simple data structure, associative array and various data types in MongoDB. NoSQL is most recently used database which provide mechanism for storage and retrieval of data. Instead of using tables and rows as in relational databases, mongodb architecture is made up of collections and documents. Aggregation in MongoDB Aggregation operation groups the values from multiple documents(rows in case of SQL) together to perform a variety of operations on the grouped data and is going to return a single result for each grouped data after aggregation. Syntax: db.collection_name.aggregate(aggregate operations) Sample Database used in all the below examples: Example 1: Python3 from pymongo import MongoClient my_client = MongoClient('localhost', 27017) db = my_client["GFG"] coll = db["Student"] # Aggregation cursor = coll.aggregate([{"$group": {"_id":"$Branch", "similar_branches":{"$sum":1} } }]) for document in cursor: print(document) Output: Here, we use "$group" command for grouping then by "_id":"branches" we are grouping ids according to the branches. "similar_branches" is the keyword used for the total number of similar branches,we can use any keyword here. "$sum:1" is used as a counter of total number of each branches. The sum is incrementing by 1. Example 2: We can also use the aggregation query for counting the number of document in the database. Python3 from pymongo import MongoClient my_client = MongoClient('localhost', 27017) db = my_client["GFG"] coll = db["Student"] # Aggregation cursor = coll.aggregate([{"$group": {"_id":"$None", "total collections":{"$sum": 1} } }]) for document in cursor: print(document) Output: {'_id': None, 'total collections': 8} Create Quiz Comment A adibakouser2018 Follow 0 Improve A adibakouser2018 Follow 0 Improve Article Tags : Python Python-mongoDB Explore Python FundamentalsPython Introduction 2 min read Input and Output in Python 4 min read Python Variables 4 min read Python Operators 4 min read Python Keywords 2 min read Python Data Types 8 min read Conditional Statements in Python 3 min read Loops in Python - For, While and Nested Loops 5 min read Python Functions 5 min read Recursion in Python 4 min read Python Lambda Functions 5 min read Python Data StructuresPython String 5 min read Python Lists 4 min read Python Tuples 4 min read Python Dictionary 3 min read Python Sets 6 min read Python Arrays 7 min read List Comprehension in Python 4 min read Advanced PythonPython OOP Concepts 11 min read Python Exception Handling 5 min read File Handling in Python 4 min read Python Database Tutorial 4 min read Python MongoDB Tutorial 3 min read Python MySQL 9 min read Python Packages 10 min read Python Modules 3 min read Python DSA Libraries 15 min read List of Python GUI Library and Packages 3 min read Data Science with PythonNumPy Tutorial - Python Library 3 min read Pandas Tutorial 4 min read Matplotlib Tutorial 5 min read Python Seaborn Tutorial 3 min read StatsModel Library - Tutorial 3 min read Learning Model Building in Scikit-learn 6 min read TensorFlow Tutorial 2 min read PyTorch Tutorial 6 min read Web Development with PythonFlask Tutorial 8 min read Django Tutorial | Learn Django Framework 7 min read Django ORM - Inserting, Updating & Deleting Data 4 min read Templating With Jinja2 in Flask 6 min read Django Templates 5 min read Build a REST API using Flask - Python 3 min read Building a Simple API with Django REST Framework 3 min read Python PracticePython Quiz 1 min read Python Coding Practice 1 min read Python Interview Questions and Answers 15+ min read Like