Replace Excel Pivot Table with Python Pandas

In this tutorial, we will replace Excel pivot tables with Python and Pandas using the pivot() and pivot_table() methods. First we'll see the core concepts behind these 2 methods. Then we'll write Python code to read 2 Excel files and make pivot tables.



--------------------
Content:
0:00 Intro
0:44 pivot() vs pivot_table() concepts
5:21 pivot() method with code
11:29 pivot_table() method with code

[Klisania_A]

Hi. Nice video. Question for you: How to format the numbers with thousand separator format inside the pivot summary?
Thanks

[suyashexpriment]

Hi. Nice to watch informational videos...
My question is .i have one master Excel with 2 pivot tables in different sheets . Raw data not available in table or list format.it's not accessible... I have to use these pivot tables as source data and do manipulation on that.and make it combine multiple reports useing pivot tables as source is it possible in python

[zakyvids]

Hi there

Thanks a lot Frank for this video.

I’m in the process of learning python and after a lot of searching I think I have come across the ideal channel.


Since I’m new to programming I’m starting with python as the first programming language


I wanted to know is this video applicable to people who are currently learning python basics and do not wish to mov to topics like data science?

In other words is this video just specific to using data science concepts in python or it is for people who have just started learning python as a first language




I have watched a video a little bit and it seems to me that it basically covers everything in python so whether we want to go into do or Ai it covers everything


If that’s the case I will continue with it, except While loop I think all is covered

But please do let know if it’s just for individuals who are learning data science or for everyone

Other than that Thanks a lot and I have subscribed to your channel

[eliassahyouni]

hi there, i like this video but i cand enderstand how i can print out pivot table to world document from python becouse my pivot table get only 5 rows and print like and after print last after 5 rows so can you help me pls? thank you for all

[collinspo]

the pivot() method is similar to One Hot Encoding, isn't it?