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
