Mongodb group by having

#It's the equivalent of the following SQL instruction:
# SELECT COUNT(*) FROM Table
# GROUP BY your_field
# HAVING COUNT(*) > N
query = db.collection.aggregate([

    { 
      "$group": { "_id": "$your_field", #GROUP BY your_field
    			"count": {"$sum":1} }   #COUNT(*)
    },
    
    { "$match": { "count": { "$gt": N } } } #HAVING COUNT(*) > N
])

Similar codes

1 vote173 views1 answer
How to create text file with python and store a dictionary
Python
20 votes199 views3 answers
Convert a number column into datetime pandas
Python
1 vote172 views3 answers
Python extract zip file without directory structure
Python
0 vote220 views1 answer
How to create decorator function in django
Python Django
5 votes163 views3 answers
How to calculate mean in python
Python
1 vote178 views1 answer
Python returen Thread
Python
1 vote185 views1 answer
Upload_file boto3 headers
Python
0 vote178 views1 answer
Python - join two columns and transform it as index
Python
0 vote188 views1 answer
Discord py check if user has permission return message if not
Python
1 vote180 views2 answers
Unpack list python
Python