Django equivalent for count and group by

by

Here, as I just discovered, is how to do this with the Django 1.1 aggregation API:

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

More Related Contents:

  1. Django -> queryset[index] Index out of range
  2. Check if a dictionary contain data true of false, then send a response back
  3. django.core.exceptions.ImproperlyConfigured: Requested setting INSTALLED_APPS, but settings are not configured. plz help me out plz
  4. How to set environment variables in PyCharm?
  5. How do I access the request object or any other variable in a form’s clean() method?
  6. MySQL “incorrect string value” error when save unicode string in Django
  7. Should I be adding the Django migration files in the .gitignore file?
  8. Loading initial data with Django 1.7 and data migrations
  9. Django: “projects” vs “apps”
  10. Django : Table doesn’t exist
  11. Error loading MySQLdb Module ‘Did you install mysqlclient or MySQL-python?’
  12. django – convert a list back to a queryset [duplicate]
  13. How to set up custom middleware in Django
  14. How to write setup.py to include a Git repository as a dependency
  15. How do I separate my models out in django?
  16. How can I check if a Python unicode string contains non-Western letters?
  17. When should I use escape and safe in Django’s template system?
  18. How to execute arithmetic operations between Model fields in django
  19. gunicorn autoreload on source change
  20. Order of Serializer Validation in Django REST Framework
  21. django apache configuration with WSGIDaemonProcess not working
  22. How to perform OR condition in django queryset?
  23. Override a form in Django admin
  24. Django equivalent of PHP’s form value array/associative array
  25. How to get python-dev for windows?
  26. Resize fields in Django Admin
  27. Rendering JSON objects using a Django template after an Ajax call
  28. “gettext()” vs “gettext_lazy()” in Django
  29. How to properly use the “choices” field option in Django
  30. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip

Leave a Comment