Pivot Table in Pandas Python | Pandas Pivot Table | Summarization using Pivot Table in Pandas Python

In this video we have tried to explain Pivot Table in the simplest form by running the same thing in excel in parallel and showing you how to achieve the same in pandas, which makes it really simple and clear to understand and keeps it to the point. After watching this you will be very much confident to not only explain or do Pivots in Python Pandas but you can also provide a comparative view with Excel.

In this video, we have covered -
00:00 - Introduction
00:20 - Excel VS Pandas a comparison
02:22 - A look in the data and importing the same in Python
03:33 - Creating a basic Pivot in Excel Vs Pandas
06:28 - Two-Dimensional Pivot in Excel Vs Pandas
07:17 - Fill Empty cells in the Pivot in Excel Vs Pandas
08:03 - Using Multiple Columns in Row or Column Label in the Pivot in Excel Vs Pandas
09:30 - Repeated items in the Pivot using reset_index()
10:28 - Using multiple aggregation function using "aggfunc" parameter
11:37 - Adding Grand Total by rows and columns in Pivot table in Pandas
12:48 - Grouping by Year, Month or Day using Pd.Grouper in the Pivot in Pandas

You might also like to watch -

Download the excel file used in this video -

Tags -
Pivot Tables,
Pivot Table in Pandas,
Pivot Table Excel VS Pandas

#DateTime #DateTimeInPandas #Python #PthonProgramming #Pandas #Learnerea

[soumikdas]

good video, how about the filter ? how can we implement that and write to a file ?

[jgmqcbj]

Very easy to understand now. Thanks very much.

[MostafaMohamed-qqbx]

Thank you 🙏 it was great and very simple and easy

[automatewithamit]

Thanks for your Video !
Can you please let me know if we can put those collapse and expand functionality in actually generated pivot table in excel using python ??

[redherringr]

Very helpful. One question What can we use to sort the output table? For example if i want to sort professions by income in ascending

[bevg]

Excellent video! question, is there a way we can use the filter cuadrant as in excel?

[praveenk]

Hi bro, it's easy to understand. Where to download the sample loan dataset? Can you share the link to download ?

[ravindrareddy]

is there any way to merge empty cells in a pivot table using python