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

preview_player
Показать описание
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!!!

Рекомендации по теме
Комментарии
Автор

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.

ramprakashtripathi
Автор

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

dineshmadav
Автор

Thank you very much for sharing this content!!!

Cheers :)

vitorribeirosa
Автор

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

cheonglily
Автор

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

automatewithamit
Автор

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

tawandamukarati
Автор

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

arpeshmistry
Автор

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

shivamgaur
Автор

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?

akileshreddy
Автор

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

praveenkumar-ubni
Автор

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

BlueSkyGoldSun
Автор

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

saurabhkunal
Автор

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 ?

K-mkpc
Автор

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?

igorrettally
Автор

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

prathyusharobbi
Автор

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

victor_yahoo
Автор

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.

shashi_kamal_chakraborty
Автор

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.

JssRider
welcome to shbcf.ru