search

nicolaskruchten / jupyter_pivottablejs

Drag’n’drop Pivot Tables and Charts for Jupyter/IPython Notebook, care of PivotTable.js
http://nicolas.kruchten.com/content/2015/09/jupyter_pivottablejs/
Other
687 stars 88 forks source link

Several Issues with impementation in Jupyter Notebook #51

Open FuriousAngelok opened 5 years ago

FuriousAngelok commented 5 years ago

Hello Thank you for solution, really magic! We have several issues

  1. Doesn't work showUI=False, maybe special syntax?
  2. Would you please be so kind to make example in readme for Filter function. Thank you
  3. I catch 400 exeption when i try to open notebook in nbviewer whit code like this

import pandas from pivottablejs import pivot_ui df=pandas.read_csv('/datasets/data.csv',delimiter=';') df.head pivot_ui(df)

which perfectly works in jupiter notebook interface

I find workaround for nbviewer https://nbviewer.jupyter.org/gist/psychemedia/9c54721e853403b43d21/pivotTable_demo.ipynb but it doesn'render pivot in jupiter notebook (in editing mode)

maybe i'll be possible to include method like plotly.offline.init_notebook_mode() ?

nicolaskruchten commented 5 years ago

Glad you like this little tool!

  1. We just need to bump the version of pivottable.js that this tool loads to the latest one. Should be a short PR if you're so motivated :)
  2. This doesn't work from Python: you should filter the data frame up front via df.query() or something like that.
  3. This tool is known not to be compatible with nbviewer as it writes a separate file to disk.
kejid commented 4 years ago

Hello there, Same issue with showui in jupyter. Simply doesn't work, any plans on updating this one? Name: pivottablejs Version: 0.9.0

nscedetas commented 4 years ago

This is really a useful tool. Thank you nicolaskruchten for all of your efforts. However, it would really be great if we could get the showUI=False working .... Name: pivottablejs Version: 0.9.0