django 获取单列字段中所有不重复值

1 2 3 4 5 6 7

Id  City     vendor 1   Mumbai      2 2   Pune        3 3   Mumbai      1 4   Yavatmal    2 5   Pune        5

1

[{‘Mumbai’:2},{‘Pune’:2},{‘Yavatmal’:1}]

1 2

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