Django Aggregation

In this django tutorial we take our first look at aggregation using a single table. This tutorial will give us the underpinning knowledge of using aggregation, performing calculation of QuerySets. In this tutorial we focus on single tables. This tutorial will lead us into annotate and then allow us to move deeper into advance aggregation topics.

Code repository:

Django ORM Playlist:

🐱‍🏍Would you like to SUPPORT US FURTHER so that we can make even more great content - Please consider joining our members community.

👍SUBSCRIBE to get more free tutorials, courses and code snippets!

[webCraftPro]

I found this video helpfull, i was strugling found how to use the aggration and how to access them through the template, but now i found it, it was about 5 days strugling to this as a biginner. Thanks you so much, sir.

[julienboudreau]

Love your tutorials. Been learning Django for 6 months now using them and find that I'm getting a lot more in depth understanding compared to initial courses I was taking.

[onyeibo]

Amazing resource as usual. You mentioned "annotate" and I was looking forward to that. Suddenly, the next episode had nothing about "annotate". Where has it gone?

[MeskosPaslauga]

Hello, great explanation. Thanks.
At the end of the video you mentioned annotate, but I can't find this vid. Maybe it's uploaded elsewhere or is not released yet? Also advanced topics interest me :)

[justacasualdeveloper]

This channel never seems to stop to amaze me 😁.

Keep up the great work. It's absolutely perfect 👌.

[abcxyz]

Your videos are very containful
Thanks for ur gr8 service

[robertng]

Thanks for the awesome tutorial. could you please let me know which extension VSCode extension you used to open the db.sqlite3 database?

[potatoesama]

Hello sir, thank you so much for your video's, i learned and loved django from you and did my graduation project with django.. It was a web app that explains programming languages and has a question section almost like a simplified version of stackoverflow and w3school together. I got the best project of the semester award thanks to your very educational tutorials. I have a question now, i feel like I'm lost again after i finished my project, what should i do, should i learn some front end stuff like react or just continue to learn django in a deeper way? In the same time i will be looking for a job with django.

[NeilRenaud]

Thanks for the tutorials they are really helpful. Any chance of showing the ManyToManyField in particular with a "through" table. I'm struggling working with them. My example is a Product, ProductSize and a Stock. So for example Product are BlueShirt, YellowShirt, Size is Small, Medium Large and then there is a through table for Stock which would have BlueShirt, Small - 5 in stock, BlueShirt, Medium - 2 in stock, Yellow Shirt, Small - 1 in stock. Unless this isn't the correct way to represent this model? In htat case given a Product I should be able to list out all the sizes with their stock level but it isn't obvious how to do that.

[jpongthep]

thank you. How to find aggregation with group by ?

[wiki-infodevelopment]

pretty nice, and what if the field is ForeingKey like

class contrat_items(models.Model):
Item_name =
Price = models.DecimalField(max_digits=15, decimal_places=2, null=True)
class
Item_price = models.ForeignKey(contrat_items, on_delete=models.CASCADE)
Unites = models.DecimalField(max_digits=15, decimal_places=2, null=True)

how do I call this item?

[adhaniataintan]

what if annotate? example is a=Pelanggaran.objects.values('jenis').annotate(Count('jenis')), and then what about in html? how to create table with values and the count of values? thanks