I suspect the name is derived from the Excel version-in itself that name was newly invented to distinguish it from a cross table with pivotable indices. It's a great tool for people coming from Excel although also a bit confusing. The pandas pivot table is "just" a summarized dataframe where the Excel version represents all data and works in a totally different way.
WOW! In less 10 minutes you have cleared something that has confused me for YEARS!
Thank you thank you thank you! Amazing video!
@@lade_edal I'm delighted to hear it!
Hands down the best Python instructor on RUclips!
Thanks so much!
Very good video Reuven! It would be nice to have one about going back and forth between multi-index and single-index!
Absolutely -- that's on my list, too. 🙂
@@ReuvenLerner 😀
@@ReuvenLerner YES! And working with individual levels. Multi index is the next frontier of pain.
Wow, very good explanation from an excellent teacher. You make it so easy to understand these concepts. Thank you for that.
I'm delighted it helped; thanks!
Very helpful. Thank you for sharing
My pleasure!
I suspect the name is derived from the Excel version-in itself that name was newly invented to distinguish it from a cross table with pivotable indices. It's a great tool for people coming from Excel although also a bit confusing. The pandas pivot table is "just" a summarized dataframe where the Excel version represents all data and works in a totally different way.
Aha, that makes a lot of sense! I knew the name came from Excel, but didn't realize the ideas behind it, or that it's not exactly the same. Thanks!