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 -
Pandas Complete Playlist - • Python Pandas Tutorial...
Creating Fake Data - • Creating Dummy Data in...
Pandas All in One - • Python Pandas Complete...
Seaborn All in One - • Seaborn|Visualization ...
Python All in One - • Python for Beginners |...
Data Science Playlist - • Data Science
Download the excel file used in this video -
File Name - loan_sample.xlsx
URL - github.com/LEARNEREA/Excel_Files
Tags -
Pivot Tables,
Pivot Table in Pandas,
Pivot Table Excel VS Pandas
#DateTime #DateTimeInPandas #Python #PthonProgramming #Pandas #Learnerea
3 июл 2024