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 vote117 views2 answers
Convert column to timestamp pandas
Python
4 votes91 views1 answer
How to input multiple integers in python
Python
1 vote146 views1 answer
Posted data to flask
Python Flask
0 vote115 views1 answer
Python Ordered dict to dict
Python
0 vote181 views1 answer
Python 3 define type in arguments with default value
Python
0 vote108 views1 answer
Python np get indices where value
Python
0 vote111 views1 answer
Installing yfinance using pip
Python
0 vote101 views1 answer
How to add 30 minutes in datetime column in pandas
Python
6 votes123 views3 answers
From sklearn.metrics import mean_square_error
Python
0 vote107 views1 answer
Selenium python has no attrirute getText
Python