This video is a gem for beginners after scrolling so much on UA-cam. Very well explained all concepts related to pivot table in one video itself. Amazing.
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 ??
You can watch video if possible: Excel Pivot Table and Aggregations using OpenPxl and Pandas-Part-5 ua-cam.com/video/CYQphiY1tCk/v-deo.html Or in order to achieve the same feature just like ms excel then we can use xlwings
Yes we can, plotly is one of the power full package for interactive data visualisation. And sharing a video where I have used plotly throughly. ua-cam.com/video/7yAw1nPareM/v-deo.html
great video! one question... when I sort_values, my "ALL" row gets in the middle of the table as there are values greater and lower than the total (all).... how can I sort values but the code needs to understand that "ALL" is the total and should go in the bottom of the df. THANKS!!!!
Thanks Ricardo. See, by default ALL row will be at bottom of the DF. For your case, might your data in object/string format that why you are getting ALL row in mid or wrong place. Try to run your code on the same data which I have used in the video.
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?
How to format numbers i.e. values in the pivot table? and rounding options. How to sort months by month number in plotting graph, as in the video they aren't in the correct order? How to show the values in millions, thousands in pivot table?
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?
Hi Akilesh, Thanks for your comment. We can add as many filter as you want on a single DataFrame. I am sharing a one video where you can learn many different ways to apply the filter on multiple columns with multiple conditions. ua-cam.com/video/j4T6OwimfFY/v-deo.html In case do you have any question on it please post your comment.
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.
Thank you for the video. New learner and new subscriber for you. In minute 3.20 -> ua-cam.com/video/ofEmmJDKEX0/v-deo.html 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.
Hi, Thanks for your comment. You can reset the index of Pivot table, for you information Pivot Table is also just like a DataFrame. So you can reset the index for repeating the 'Consumer', follow the below line. pd.pivot_table(sample, index = ['Segment','State']).reset_index()
@@ProgrammingIsFunn Thank you for responding. I'm afraid I've failed to do it, this is my code for the pivot table in case you can help. Anyway it's no big deal, I can do it after exporting the file in excel. pivot=pd.pivot_table(df,index=["COMPTE","DEVISE D'ORIGINE"],columns= "TYPE EVENEMENT",values='FINAL MONTANT',aggfunc= ["sum"],margins=True,margins_name="Total") pivot.fillna(0,inplace=True) Thank you again, I'll keep watching your videos, I need to learn a lot haha.
Amazing break down and no gate keeping finally, as well straight to the point. Thank You!
This video is a gem for beginners after scrolling so much on UA-cam. Very well explained all concepts related to pivot table in one video itself. Amazing.
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 ??
You can watch video if possible:
Excel Pivot Table and Aggregations using OpenPxl and Pandas-Part-5
ua-cam.com/video/CYQphiY1tCk/v-deo.html
Or in order to achieve the same feature just like ms excel then we can use xlwings
Thank you very much for sharing this content!!!
Cheers :)
Thank you thank you thank you 😊😊😊😊
Спасибо, Абхишек!
🌞🌞🌞
Amazing 👍👍
Thank you for the video. Is it possible to plot the same data using Plotly?
Yes we can, plotly is one of the power full package for interactive data visualisation.
And sharing a video where I have used plotly throughly.
ua-cam.com/video/7yAw1nPareM/v-deo.html
i like to know can we store the pivot table and the data into spreadsheet and keep.
Amazing tutorial
Thanks for very informative video
Thanks, excellent explanation
this video is amazing
great video! one question... when I sort_values, my "ALL" row gets in the middle of the table as there are values greater and lower than the total (all).... how can I sort values but the code needs to understand that "ALL" is the total and should go in the bottom of the df. THANKS!!!!
Thanks Ricardo.
See, by default ALL row will be at bottom of the DF. For your case, might your data in object/string format that why you are getting ALL row in mid or wrong place.
Try to run your code on the same data which I have used in the video.
Hello bro !! Can we create the links in the pivot table in pandas while exporting the data to the excel sheet
What is the name of the dataset in kaggle ?
Or is it created by you personally?
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?
Using matplotlib we can plot the chart in month's order. But in pivot table by default index will be sort in ascending or alphabetical order.
How to format numbers i.e. values in the pivot table? and rounding options.
How to sort months by month number in plotting graph, as in the video they aren't in the correct order?
How to show the values in millions, thousands in pivot table?
Hi, how to format numbers i.e. values in the pivot table?
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?
Hi Akilesh, Thanks for your comment. We can add as many filter as you want on a single DataFrame. I am sharing a one video where you can learn many different ways to apply the filter on multiple columns with multiple conditions.
ua-cam.com/video/j4T6OwimfFY/v-deo.html
In case do you have any question on it please post your comment.
@@ProgrammingIsFunn Thank you so much!!
Super
Thanks alot sir
Can we create a pivot table in excel itself without using pandas using python?
Yes we can using python library xlwings or win32.
@@ProgrammingIsFunn Is there any reference for the same?
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 ?
How can I get an index of all your Videos on Pandas, like 1, 2, 3, 4, etc.
Python Pandas - Data Science and Automation
ua-cam.com/play/PLWuFHho1zKhUJpe9WfSyvrrQrzqDErbmv.html
How to show count of na data using panda pivot just like excel pivot
How do I do the show details (the option which gives details of that value in a new spreadsheet) in python?
how to put month in correct order . I see its alphabetical order of months i need to show correct order of months
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.
Guys Guys Guys Guys Guys GuysGuys Guys, need more and more GuysGuysGuysGuysGuysGuysGuysGuysGuysGuysGuys
Yes 🙌
Thank you for the video. New learner and new subscriber for you.
In minute 3.20 -> ua-cam.com/video/ofEmmJDKEX0/v-deo.html
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.
Hi, Thanks for your comment.
You can reset the index of Pivot table, for you information Pivot Table is also just like a DataFrame. So you can reset the index for repeating the 'Consumer', follow the below line.
pd.pivot_table(sample, index = ['Segment','State']).reset_index()
@@ProgrammingIsFunn Thank you for responding. I'm afraid I've failed to do it, this is my code for the pivot table in case you can help. Anyway it's no big deal, I can do it after exporting the file in excel.
pivot=pd.pivot_table(df,index=["COMPTE","DEVISE D'ORIGINE"],columns= "TYPE EVENEMENT",values='FINAL MONTANT',aggfunc= ["sum"],margins=True,margins_name="Total")
pivot.fillna(0,inplace=True)
Thank you again, I'll keep watching your videos, I need to learn a lot haha.