Pivot tables with Pandas

What are pivot tables? How do they work? And how can you create them using Pandas? In this video, I explain why they're such useful tools in data analytics, and how we can easily create them with Pandas.

[Maleficent_Method]

Just started learning python a few days ago, it's my first programming language as confusing so far...You have helped a lot even with a pretty short video. Thanks so much!

[YossiSoberano]

Thanks Reuven, for another informative and educational video 👍

[reygaji]

Omg, you are a godsend. Where have you been all this time when I was just starting to learn this stuff T_T Your videos are better than many python tutorials out there with millions of views damn

[Kaelthas_Sunstrider]

You’re an amazing teacher! I’m enjoying your book Python Workout :)

[naimahrehman]

I believe that we can also achieve the outcome of the pivot table through groupby function

[mosama]

Thank you so much for the beautiful videos, I just wish you had a direct link to the data please, so we can follow up with you.
Thanks again though for the beautiful videos 🙂

[thomasgyting]

I was having a difficult time understanding pivot tables and what exactly they are vs regular tables, and your example at the end that included multiple agg functions made the lightbulb go off! Love your content!

[kaiserkonok]

Thank you so much🖤. You are doing amazing for us. We would be more happy if you post videos on machine learning with python. 🙏

[samogo]

Great explained! .pivot() is amazing, it's exactly what I was looking for, it's like y axes in "xy coordinate table", fantastic!

[marioua]

Hey Reuven, great tutorial, thanks! I've also watched your pivot and **kwargs videos and they were awesome too

[rafaelsantana]

Hello, I would like to know how I can make it count in a column at the end all columns that have values. example:
count = ID1 + ID2+ ID3

[Darkev]

Great, thanks for explaining it so concisely. However, why would I use a pivot table when I can also group by multiple columns (group by year and team: `groupby(["Year", "Team"], observed=True)`)?

[jingchun]

Thank you so much! I am curious that can we just show a few columns we want? For example, for the sports, I just want to show baseball, badminton. Thanks.

[hieuthuan]

Thanks @Reuven. I wonder if it is possible to create pivot table with more than one index (row field), and more than 1 value, such as height and weight in average. Excel can do it easily :)

[inderjeetchandnani]

At time 3:59 if we have a date data, will it work?

[marvinlomo]

Thanks Reuven. Is this covered in the Book?

[AnjanBasumatary]

How to display the all the rows and column cobination even values are missing in those combination?

[KonradTamas]

One question, do I always need Categorical data to use pivot tables ? Thanks!

[real.samad_]

Hello Reuven, can I use smally portion of this video for an instagram reel I am working on?

[joshux]

In the pivot_table method, you don't specify you want to calculate the mean. It auto assumes that? Can I use other calculation such as median or max?