Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Django get count of each age

Tags:

orm

django

I have this model:

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)

And I need to run a django query to get the count of each age. Something like this:

Age || Count
10  ||  100
11  ||  50
and so on.....
like image 919
Ahmedn1 Avatar asked Oct 19 '25 06:10

Ahmedn1


1 Answers

Here is what I did with 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))
like image 195
Ahmedn1 Avatar answered Oct 21 '25 20:10

Ahmedn1



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!