Menu Close

How to do count and group by with Python Django?

Sometimes, we want to do count and group by with Python Django.

In this article, we’ll look at how to do count and group by with Python Django.

How to do count and group by with Python Django?

To do count and group by with Python Django, we can use values to do group by and Count to add the count.

For instance, we write

from django.db.models import Count
theanswer = Item.objects.values('category').annotate(Count('category'))

to call values to do a group by with the category field.

And then we have Count('category') to count all the grouped items in all the groups.

Conclusion

To do count and group by with Python Django, we can use values to do group by and Count to add the count.

Posted in Python, Python Answers