Drag’n’drop Pivot Tables and Charts for Jupyter/IPython Notebook, care of PivotTable.js
pivottablejs
: the Python moduleDrag’n’drop Pivot Tables and Charts for Jupyter/IPython Notebook
,
care of PivotTable.js
.. image:: https://mybinder.org/badge_logo.svg :target: https://mybinder.org/v2/gh/nicolaskruchten/jupyter_pivottablejs/master?filepath=example%2Fjupyter_pivottablejs_example.ipynb
pip install pivottablejs
or conda install pivottablejs
Note in the past, the conda
command above installed pivottablejs-airgap
_ instead of this library; apologies for any confusion this change may cause.
.. code:: python
import pandas as pd
df = pd.read_csv("some_input.csv")
from pivottablejs import pivot_ui
pivot_ui(df)
Include any JSON-serializable option to PivotTable.js's pivotUI() function
_ as a keyword argument.
.. code:: python
pivot_ui(df, rows=['row_name'], cols=['col_name'])
Independently control the output file path and the URL used to access it from Jupyter, in case the default relative-URL behaviour is incompatible with Jupyter's settings.
.. code:: python
pivot_ui(df, outfile_path="/x/y.html", url="http://localhost/a/b/x.html")
.. _Jupyter/IPython Notebook: http://jupyter.org/ .. _PivotTable.js: https://github.com/nicolaskruchten/pivottable .. _pivottablejs-airgap: https://github.com/ContinuumIO/pivottablejs-airgap .. _JSON-serializable option to PivotTable.js's pivotUI() function: https://github.com/nicolaskruchten/pivottable/wiki/Parameters#options-object-for-pivotui