[Answered ]-Django: Get average rating per user

by

1👍

✅

It makes more sense to .annotate(…) [Django-doc] the User objects, so:

from django.db.models import Avg

friends.friend.filter(
    checkin__beer_id=1
).annotate(
    rating=Avg('checkin__rating')
)

Where checkin__ is the related_query_name=… [Django-doc] for the user from Checkin to the User model. If you did not specify a related_query_name=…, then it will use the value for the related_name=… [Django-doc], and if that one is not specified either, it will use the name of the source model in lowercase, so checkin.

The User objects that arise from this queryset will have an extra attribute .rating that contains the average rating over the Checkins for that beer_id.

You can determine the average of these averages with an .aggregate(…) call [Django-doc]:

from django.db.models import Avg

friends.friend.filter(
    checkin__beer_id=1
).annotate(
    rating=Avg('checkin__rating')
).aggregate(
    all_users_avg_rating=Avg('rating'),
    number_of_users=Count('pk')
)

This will return a dictionary with two elements: all_users_avg_rating will map to the average of these averages, and number_of_users will return the number of distinct users.

Note: It is normally better to make use of the settings.AUTH_USER_MODEL [Django-doc] to refer to the user model, than to use the User model [Django-doc] directly. For more information you can see the referencing the User model section of the documentation.

👤willeM_ Van Onsem

Leave a comment