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

1 vote155 views1 answer
X= [10] def List_ex(): x.append(20) def add_list(): x=[30,40] x.append(50) print (x) List_ex() print (x) add_list() print (x)
Python
2 votes157 views2 answers
Speech to text
Python
18 votes113 views2 answers
Python string append character
Python
0 vote157 views1 answer
From string to flaot python numpy
Python
0 vote193 views1 answer
Docker-compose.yml for flask celery rabbitmq
Python Flask
0 vote146 views1 answer
String index out of range python
Python
0 vote151 views1 answer
Django many to many post update method via rest
Python
0 vote180 views1 answer
Pandas lambda applu
Python
4 votes275 views2 answers
Tqdm auto
Python
1 vote147 views1 answer
Pip install qrcode python
Python