Django queryset group by

Django group by

# If you mean to do aggregation you can use the aggregation features of the ORM:
from django.db.models import Count
Members.objects.values('designation').annotate(dcount=Count('designation'))

# This results in a query similar to:
SELECT designation, COUNT(designation) AS dcount
FROM members GROUP BY designation

#and the output would be of the form
[{'designation': 'Salesman', 'dcount': 2}, 
 {'designation': 'Manager', 'dcount': 2}]

Source: stackoverflow.com

Django queryset group by

from django.db.models import Avg
teams = Analysts.objects.values('class').annotate(avgcap=Avg('gpa'))
# Assuming Analysts model has class and gpa field..
# This will group by class field and give the avg of gpa field values

Similar codes

0 vote140 views1 answer
Python fibonacci series (Recursion)
Python
26 votes115 views6 answers
Python push to list
Python
1 vote113 views2 answers
Get the torch version
Python
-1 vote110 views1 answer
Flask run on ip and port
Python
61 votes110 views3 answers
How to make python remove the duplicates in list
Python
34 votes113 views5 answers
Remove substring python
Python
2 votes105 views2 answers
Discord.py cog
Python
1 vote118 views1 answer
Pandas nan values in column
Python
0 vote121 views1 answer
Celery periodic tasks
Python
2 votes132 views2 answers
Generate random integer matrix python
Python