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 vote311 views1 answer
How to remove arrays in python from a specific place
Python
0 vote261 views1 answer
If a list has a string remove
Python
3 votes285 views2 answers
How to plotting bar on matplotlib
Python
0 vote315 views1 answer
Applies a function to all elements of this RDD.
Python
0 vote276 views1 answer
Python3 array
Python
9 votes278 views1 answer
Load csv file using pandas
Python
1 vote318 views1 answer
Counter in django template
Python Django
0 vote276 views1 answer
Pyton count senteses in a text file
Python
17 votes263 views3 answers
Making log files in python
Python
0 vote279 views1 answer
231a codeforces solution in python
Python