Django queryset group by count

 from django.db.models import Count

 result = Books.objects.values('author')
                       .order_by('author')
                       .annotate(count=Count('author'))

Source: stackoverflow.com

Similar codes

0 vote98 views1 answer
Import OpenEXR ModuleNotFoundError: No module named 'OpenEXR'
Python
9 votes98 views7 answers
Print python
Python
0 vote137 views1 answer
Queryset.raw() in django rest framework joining tables
Python Django
1 vote121 views1 answer
Python array extend
Python
0 vote99 views1 answer
Convert pandas group to dict
Python
0 vote102 views2 answers
Pandas groupby percentile
Python
0 vote104 views1 answer
Get key of min value
Python
33 votes140 views5 answers
How to filter out all NaN values in pandas df
Python
1 vote100 views1 answer
Find order of characters python
Python
10 votes151 views3 answers
How to insert sound in python
Python