Create A summary Table using Python in Excel like a Pivot Table ( Pivot Table kind of Summary)

Creating a Pivot Table in Excel (without opening Excel File) using Python is quite easy. Its a 4 to 5 lines of code gives the output without any effort.
If you are good with you Data and you know what do you want, Python is a great tool to do your job.
I Expect to reach many Excel Users who might not have heard about Python should start using python. It helps!!
Please SUBSCRIBE

[rkytac]

Trust me.. I was looking for this code from 2 months, its 100% simpler and easier. no need to open any existing file and data is getting saved in just a minute even for the file which has almost 4 lakh 50 thousand rows. Thank you for the coding. I'm now your Subscriber. Vijay, can you take classes atleast an hour a day or 2 hours on weekends.

[erikasunflower]

I need to write an Excel type pivot table, do you know how to do that with Python?

[pierremoulin]

I don't get it, how is that a pivot table ? It's a classic chart, right ?

[martinbalage]

Misleading title. it says "Create Excel Pivot Table using Python". Well this is not an "Excel Pivot Table". but a pandas pivot table exported into Excel. Its a different object.