This video is a gem for beginners after scrolling so much on RUclips. 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 ruclips.net/video/CYQphiY1tCk/видео.html Or in order to achieve the same feature just like ms excel then we can use xlwings
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?
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.
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. ruclips.net/video/j4T6OwimfFY/видео.html In case do you have any question on it please post your comment.
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. ruclips.net/video/7yAw1nPareM/видео.html
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?
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 -> ruclips.net/video/ofEmmJDKEX0/видео.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 RUclips. Very well explained all concepts related to pivot table in one video itself. Amazing.
Thank you very much for sharing this content!!!
Cheers :)
Amazing 👍👍
Amazing tutorial
Thank you thank you thank you 😊😊😊😊
Thanks, excellent explanation
Спасибо, Абхишек!
🌞🌞🌞
Thanks for very informative video
this video is amazing
Thanks alot sir
Super
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
ruclips.net/video/CYQphiY1tCk/видео.html
Or in order to achieve the same feature just like ms excel then we can use xlwings
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?
i like to know can we store the pivot table and the data into spreadsheet and keep.
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.
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.
ruclips.net/video/j4T6OwimfFY/видео.html
In case do you have any question on it please post your comment.
@@ProgrammingIsFunn Thank you so much!!
how to put month in correct order . I see its alphabetical order of months i need to show correct order of months
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, how to format numbers i.e. values in the pivot table?
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.
ruclips.net/video/7yAw1nPareM/видео.html
How do I do the show details (the option which gives details of that value in a new spreadsheet) in python?
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.
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?
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 to show count of na data using panda pivot just like excel pivot
How can I get an index of all your Videos on Pandas, like 1, 2, 3, 4, etc.
Python Pandas - Data Science and Automation
ruclips.net/p/PLWuFHho1zKhUJpe9WfSyvrrQrzqDErbmv
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 -> ruclips.net/video/ofEmmJDKEX0/видео.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.