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 vote189 views1 answer
How to populate an image to template in django from views
Python Django
3 votes138 views1 answer
Python3 return a list of indexes of a specific character in a string
Python
3 votes150 views4 answers
Create a new dataframe from existing dataframe pandas
Python
1 vote165 views1 answer
Prevent list index out of range python
Python
0 vote128 views1 answer
Python invalid syntax for no reason
Python
24 votes134 views3 answers
Selenium python
Python
0 vote169 views1 answer
Unable to locate package python-certbot-nginx
Python
0 vote176 views7 answers
Collections.Counter(string).most_common
Python
2 votes142 views1 answer
Reduced fraction python
Python
0 vote175 views1 answer
Python check disk space
Python