Pivot Table in Pandas Python | Pandas Pivot Table | Summarization using Pivot Table in Pandas Python

[@danielechavezs7502]

This video have all the information i was looking for. 10/10 explanation. Thank you for your video🙏🏿🙏🏿

[@JuniorEwaneEtah]

Very easy to understand now. Thanks very much.

[@learnerea]

Glad it helped!

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

[@learnerea]

Unfortunately not, not that I know

[@Lovely_Pihu]

Great video

[@learnerea]

Glad you enjoyed it

[@rishisolanki554]

Such a valueable content 👍

[@learnerea]

I'm pleased to hear that

[@priyankapralhadraodeulkar6325]

Thank you so much

[@learnerea]

Any time

[@soumikdas2009]

good video, how about the filter ? how can we implement that and write to a file ?

[@MostafaMohamed-qq2bx]

Thank you 🙏 it was great and very simple and easy

[@learnerea]

Glad it helped

[@triptabhattacharjee7004]

Great video! Thank you!

[@learnerea]

Glad you liked it!

[@azamiqbal8792]

Super video

[@learnerea]

Glad it helped you

[@redherring777r]

Very helpful. One question What can we use to sort the output table? For example if i want to sort professions by income in ascending

[@learnerea]

You may like to checkout this one - kzbin.info/www/bejne/gH_PdqNmnb1kZ80si=noqbEQumfVX8J2XF

[@kailashpatro5768]

Thank you ❤️❤️❤️

[@learnerea]

Glad you liked it

[@praveenk8841]

Hi bro, it's easy to understand. Where to download the sample loan dataset? Can you share the link to download ?

[@learnerea]

Hi Praveen, Yes, we have uploaded this on GitHub which you an download using - File Name - loan_sample.xlsx URL - github.com/LEARNEREA/Excel_Files

[@praveenk8841]

@@learnerea thank you for your support

[@lohitkattimani7668]

Good job

[@learnerea]

thank you very much

[@bevg1]

Excellent video! question, is there a way we can use the filter cuadrant as in excel?

[@learnerea]

if I understood your question correctly then you can try something like below - filtered_df = df[df['X'] > 0 & df['Y'] > 0] else elaborate your question more with example, I'll be able to help you

[@bevg1]

@@learnerea your video covers, columns and rows... is there an example of on how to use the filter section of a pivot table?

[@bevg1]

@@learnerea I will try it...

[@ravindrareddy5478]

is there any way to merge empty cells in a pivot table using python

[@learnerea]

Not sure if there is one to achieve exactly what you are looking for, however.. you can try using - reset_index() if that helps e.g. pivotted_df is your dataframe after making the pivot.. you can do - pivotted_df.reset_index()

[@SAURABHPANDEY-m8d]

how to find the subtotal??

[@learnerea]

There isn't a direct method for that, but can be achieved by creating separate pivot for each of the group and concatenating them at the end. We will try to make a video on that. Thanks