Python Pandas Tutorial: Data Analysis & Visualization With Pivot Table in Pandas#14

Hi Guys, In this video I have talked about how you can create pivot tables with visualization in Python. Pivot table is an very essential concept for data analysis, data wrangling and data pre-processing purpose. With pivot table we can easily summarize our data really fast from any dataset.

Most people likely have experience with pivot tables in MS Excel. Python provides also a same flavor using Pandas. Really using pandas pivot table you can look at your data from a different alignment and pivot extensively used in analyzing or summarizing the data.

This video covers as follows in greater details:

Pandas Pivot Table introduction
Why use Pivot Tables?
Pandas Pivot Table function syntax and parameters.
How to pick specific column in Pivot Table?
How to use aggregate function in Pivot Table?
How to apply multiple aggregate function on a single column in Pivot Table?
How to handle null values in Pivot Table?
How to set the total in each row and column using margins parameter?
How to apply filter in Pivot Table?
How to sort the data in Pivot Table?
How to create pivot table on specific portion of the data?
Use query method and its benefit with Pivot Table?
Create "bar" chart using Pivot Table.
Create "line" chart using Pivot Table.
How to plot sales month wise (extract month name from date column) and visualize it?
*More!!!

Always looking for your valuable suggestion on what kind of videos you want in future, leave me a comment with your suggestion. Keep watching!!!

[ramprakashtripathi]

This video is a gem for beginners after scrolling so much on YouTube. Very well explained all concepts related to pivot table in one video itself. Amazing.

[dineshmadav]

Awesome.. to the point... Thanks a ton!

[vitorribeirosa]

Thank you very much for sharing this content!!!

Cheers :)

[cheonglily]

i like to know can we store the pivot table and the data into spreadsheet and keep.

[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 ??

[tawandamukarati]

Thank you for the video. Is it possible to plot the same data using Plotly?

[arpeshmistry]

Hello bro !! Can we create the links in the pivot table in pandas while exporting the data to the excel sheet

[shivamgaur]

How to show count of na data using panda pivot just like excel pivot

[akileshreddy]

How can you add multiple filter? Like in the video we gave region as east and I want to give one more filter like date as 11/08/2016. Basically I wanted to know how do we give multiple filter?

[praveenkumar-ubni]

How do I do the show details (the option which gives details of that value in a new spreadsheet) in python?

[BlueSkyGoldSun]

What is the name of the dataset in kaggle ?
Or is it created by you personally?

[saurabhkunal]

how to put month in correct order . I see its alphabetical order of months i need to show correct order of months

[K-mkpc]

Hi i am doing the same for the data frame having 26L rows and 115 variables. It is taking huge time to compute. Any ideas ?

[igorrettally]

Excellent video, very detailed and clear, I just have one question, how can I order the months in the chart in chronological order instead of alphabetical?

[prathyusharobbi]

Can we create a pivot table in excel itself without using pandas using python?

[victor_yahoo]

How can I get an index of all your Videos on Pandas, like 1, 2, 3, 4, etc.

[shashi_kamal_chakraborty]

Hello Sir, I tried to use the data set, by the github link you have provided. But, I think there's something wrong with it. When I tried to read it, the raw link, I got this error... "UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf6 in position 42492: invalid start byte". Please, help me with your kind suggestions about how to get rid of this.

[JssRider]

Thank you for the video. New learner and new subscriber for you.


How would you do to see "Consumer" in all rows and not only in the first one? Like excel "Repeat all labels"


Thank you in advanced.