Django 统计每个年龄

Question

我有这个模型:

class User_Data(AbstractUser):
    date_of_birth = models.DateField(null=True,blank=True)
    city = models.CharField(max_length=255,default='',null=True,blank=True)
    address = models.TextField(default='',null=True,blank=True)
    gender = models.TextField(default='',null=True,blank=True)

我需要运行 django 查询来获取每个年龄的计数。像这样的事情:

Age || Count
10  ||  100
11  ||  50
and so on.....

Answer 1

这是我对 lambda 所做的事情:

usersAge = map(lambda x: calculate_age(x[0]), User_Data.objects.values_list('date_of_birth'))
    users_age_data_source = [[x, usersAge.count(x)] for x in set(usersAge)]
    users_age_data_source = sorted(users_age_data_source, key=itemgetter(0))