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

29 votes363 views9 answers
Traduttore
Python
30 votes342 views6 answers
List comprehension if else
Python
97 votes341 views5 answers
How to make a python exe
Python
0 vote353 views1 answer
Python cv2 canny overlay on image
Python
0 vote366 views1 answer
Sqlalchemy filter between dates
Python
1 vote381 views1 answer
[Solved] TypeError: can’t multiply sequence by non-int of type str
Python
3 votes344 views4 answers
Pandas count
Python
0 vote375 views1 answer
Copy a df to another df
Python
45 votes359 views6 answers
How to replace nan values with 0 in pandas
Python
0 vote370 views1 answer
How to save python variables locally
Python