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 vote168 views1 answer
How to view the whole dataset in jupyternotebook
Python
0 vote148 views1 answer
Onetoone vs foreign key django
Python
4 votes143 views1 answer
Read value from entry tkinter
Python
2 votes144 views1 answer
Matplotlib plot remove margins
Python
0 vote139 views1 answer
Pd.to_datetime(df 'date' errors='coerce')
Python
1 vote135 views1 answer
Python tkinter go to another window on button click
Python
2 votes143 views2 answers
Count consecutive values in python
Python
1 vote145 views2 answers
Print hexadecimal in python
Python
0 vote167 views1 answer
Pandas group by concat
Python
0 vote156 views1 answer
Get array from h5py dataset
Python