PyMongo aggregation no result

Question

I am trying to query the average "clicks" from a MongoDB database using PyMongo.

query_result = list(my_collection.aggregate([{'$group' : {'_id' : None, 'avg_clicks': {'$avg' : "$clicks"}}}]))

Query result:

ok
result

Do you know what could be the problem?

+3

barnabas markus 11 jan. 15 at 14:34

1 answer

vaultah · Accepted Answer · 2015-01-11T14:36:27+0000

Collection.aggregate

returns a dictionary like

{'ok': 1 or 0, 'result': the_actual_result}

Thus,

list(my_collection.aggregate(...))

iterates over the dictionary, getting a list of keys ['ok', 'result']

.