/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

0 vote146 views3 answers
Groupby fillna
Python
0 vote154 views2 answers
How to open youtube from google chrome browser instead of internet explorerwhen coding in python
Python
0 vote153 views1 answer
Python int in list
Python
0 vote158 views1 answer
How to store a return value in a variable in python
Python
1 vote144 views1 answer
Convert pandas dataframe to django queryset
Python
0 vote151 views1 answer
Installing required libraries in conda environment
Python
0 vote159 views1 answer
Django model get field verbose name
Python
3 votes142 views2 answers
COLLECTIONS.DEFAULTDICT(set)
Python
0 vote151 views1 answer
Truthy falsy python
Python
-1 vote192 views1 answer
Install grepper for edge
Python