Python Interactive Pivot Tables with Pandas DataFrames using pivottablejs

In this python tutorial, we will go over how to create interactive drag and drop pivot tables using pandas dataframes in Jupyter notebooks using pivottablejs and ipypivot.

Notes:
* pivottablejs and ipypivot are similar with slight differences
* install instructions - visit the Python Package Index (PyPI) and search for pivottablejs and ipypivot
* If the numbers don't look right, remember to remove filters for correct sums and totals, etc.
* the pivot tables are a great way to do exploratory data analysis but I am still searching for a way to save pivot tables after closing - persistent storage of the pivot table set-up and views

[johanvanmarsch]

Wow ! Only 366 vues, this is pure Gold. Thank you Ryan

[yifengyuan]

I also tried to call pivot_ui() method in multiple instances in the notebook, not working. It seems that it can only be plotted once. The next time it is called, the content/data in my pivot table/chart is not updated, still adhering to the previous data set. Not sure if you saw this issue.

[Knud]

Thanks a lot! I have a question, I realise its a long shot. I'm looking for a package that can make an interactive table where the user can drill down on different dimensions in a data set, but the user decides which dimension to drill down on for each row. E.g. the user drills down on organisational level two times, then drills down on currency under one of those two organisations. Finally, the user drills down on product under one of currencies. If that makes sense :) I'm looking for how to do it, just if its possible in some python package.

[yifengyuan]

how to make the output cell larger, especially its height?

[ComputerScienceSimplified]

Awesome video, keep up the incredible work! :)