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 vote327 views5 answers
Medium seaaborn mathplot diesign styles
Python
0 vote317 views1 answer
How ti maek a prinyt comnad i pyuthon
Python
0 vote322 views1 answer
Django get group users
Python
18 votes310 views5 answers
Continue statement python
Python
13 votes301 views2 answers
Sys get current pythonpath
Python
3 votes305 views1 answer
Py change background
Python
0 vote346 views2 answers
Django models get all
Python
0 vote304 views1 answer
List Get a Element
Python
0 vote299 views1 answer
Flask mongoengine getting started
Python
33 votes322 views6 answers
Bs4 python
Python