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

12 votes193 views6 answers
Remove empty strings from list python
Python
0 vote199 views1 answer
How to unpivot dataframe pandas
Python
2 votes207 views2 answers
Get element pandas
Python
19 votes181 views2 answers
Pyinstaller single file
Python
0 vote191 views1 answer
Python setter getter deleter
Python
3 votes202 views3 answers
Python resize image keep aspect ratio
Python
0 vote258 views2 answers
Graph data structure in python
Python
1 vote205 views1 answer
Print even numbers in python
Python
0 vote196 views1 answer
How to redirect in django rest framework
Python
0 vote200 views1 answer
Django file field from base64
Python Django