Last Updated : 03 Oct, 2022
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 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:
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}
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4