How can I use Django filtering and aggregates in my project?

How can I use Django filtering and aggregates in my project?

You can use Django's ORM to filter and aggregate data easily. What specific use case do you have in mind?

I want to filter a list of products by category and get the average price.

You can use the filter() method to filter by category and then use aggregate() to calculate the average price. Here's an example: Product.objects.filter(category='Electronics').aggregate(Avg('price')).

That sounds great! Can I also count the number of products in each category?

Yes, you can use the annotate() method along with Count(). For example: Product.objects.values('category').annotate(count=Count('id')) will give you the count of products per category.

Thanks! This is really helpful.