Django Query to get count of all distinct values for particular column

Piyush S. Wanare picture Piyush S. Wanare · Apr 30, 2016 · Viewed 9.2k times · Source

I am trying to fetch count of all distinct values in particular column for example I have following table in model name MyModel :

Id  City     vendor

1   Mumbai      2
2   Pune        3
3   Mumbai      1
4   Yavatmal    2
5   Pune        5

I am looking for output something like this:

[{'Mumbai':2},{'Pune':2},{'Yavatmal':1}]

Answer

trantu picture trantu · Apr 30, 2016

Like the comment of solarissmoke above. In that post you can see the solution:

from django.db.models import Count
MyModel.objects.values('city').annotate(the_count=Count('city'))