/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

2 votes430 views4 answers
Min and max in python
Python
16 votes305 views1 answer
Python reload module without restarting
Python
1 vote376 views2 answers
Cannot import name 'imputer' from 'sklearn.preprocessing'
Python
0 vote393 views1 answer
Created by and updated by in django
Python Django
0 vote349 views1 answer
Python pyinstler not found
Python
10 votes327 views4 answers
Multiply each element in list python
Python
1 vote328 views1 answer
How to swap in list in python
Python
5 votes336 views4 answers
Execute command and get output python
Python
3 votes329 views1 answer
Rotate 2 dimensional list python
Python
0 vote410 views1 answer
: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend,
Python