MongoDB is a document-oriented NoSQL database that is a non-relational DB. MongoDB is a schema-free database that is based on Binary JSON format. It is organized with a group of documents (rows in RDBMS) called collection (table in RDBMS). The collections in MongoDB are schema-less. PyMongo is one of the MongoDB drivers or client libraries. Using the PyMongo module we can send requests and receive responses from
Count the number of Documents using Python
Method 1: Using count() The total number of documents present in the collection can be retrieved by using count() method. Deprecated in version 3.7.
Syntax :
db.collection.count()
Example : Count the number of documents (my_data) in the collection using count(). Sample Database:
from pymongo import MongoClient
Client = MongoClient()
myclient = MongoClient( 'localhost' , 27017 )
my_database = myclient[& quot
GFG & quot
]
my_collection = my_database[& quot
Student & quot
]
# number of documents in the collection mydoc = my_collection.find().count()
print (& quot
The number of documents in collection : & quot
, mydoc)
|
Output :
The number of documents in collection : 8
Method 2: count_documents() Alternatively, you can also use count_documents() function in pymongo to count the number of documents present in the collection.
Syntax :
db.collection.count_documents({query, option})
Example: Retrieves the documents present in the collection and the count of the documents using count_documents().
from pymongo import MongoClient
Client = MongoClient()
myclient = MongoClient( 'localhost' , 27017 )
my_database = myclient[& quot
GFG & quot
]
my_collection = my_database[& quot
Student & quot
]
# number of documents in the collection total_count = my_collection.count_documents({})
print (& quot
Total number of documents : & quot
, total_count)
|
Output:
Total number of documents : 8