/Python/How to count post by category django

How to count post by category django

#views.py
from django.db.models import Count
# You should change post in Count function based on your model.
categories = Category.objects.all().annotate(posts_count=Count('post'))

#Then you will have access to number of posts for each category:
for category in categories:
    print(category.posts_count)

#in your template
{% for category in categories %}
      <p>Number of posts: {{category.posts_count}}</p>
{% endfor %}

Source: stackoverflow.com

Similar codes

13 votes187 views4 answers
Pandas list to df
Python
1 vote254 views1 answer
How to open local html file in python
Python
6 votes226 views5 answers
Os run shell command python
Python
-2 votes199 views4 answers
Python find if string contains space
Python
0 vote195 views1 answer
How to code discord bot 8ball python
Python
0 vote202 views1 answer
Graphics.py how to make a button
Python
-1 vote190 views3 answers
Install python3 in dockerfile
Python
1 vote219 views1 answer
Python append n numbers to list
Python
1 vote175 views1 answer
Kmeans sklearn
Python
1 vote162 views1 answer
Python add word to list
Python