Hiya Nicolas,

I'm finding that jupyter launches pivots on my laptop just fine, but am having issues at work. [On the latter, I'm behind a firewall and also running on a vmware instance in stand-alone/non-bridged mode. The proxy settings seem to be fine otherwise, and I even set HTTP_PROXY and HTTPS_PROXY environment vars for anaconda to pickup automatically as well as setting ssl_verify to False.] The pandas dataframes load just fine, but I'm not seeing anything in the cell where I try to display a pivot_ui using even the simple examples that you've provided.

I've even started jupyter with --debug and looked at the logs, but don't see what's going on yet. Any suggestions for how to debug this?

Much obliged for your indulgence on this, and all your fine efforts. Rick

p.s. Saw your note elsewhere on the output path issues. When I set the output file path to an absolute location (e.g. "/blah/bleh/test.html") I did get a 404, but when I just specified a relative path ("test.html") it failed silently again (but wrote "test.html"). Also, I do not see the "pop out" text within the output cell.... it's perfectly blank....

p.p.s. I'm also trying to get Chrome installed on Redhat to use the Javascipt debugging extensions to better isolate the issue, but haven't been successful there either yet.

Great tool for data exploration, I think this should be a core utility of Jupyter!

I got the error message: UnicodeEncodeError: 'ascii' codec can't encode characters in position 8-11: ordinal not in range(128)

I think it is because of of the pd.to_csv method, adding some encoding handling capability could fix this.

But not really sure how...

thank you for the great js magic!

I'm not sure how this would work, but I wonder if as well as using the pivot table to explore and interact with data from a pandas dataframe, it might be useful to provide a mechanism for passing the data back from the pivottable to a pandas dataframe using an IPyWidget mechanic? (Some related ideas in the context of dashboards here.)

For teaching purposes, it might also be handy to provide a view of pandas code that mimics any operations performed in the pivottable? (If there was no return path of data from the widget back to pandas, at least the user could copy the generated code and apply it to the original dataframe using pandas?

Love this idea...but can't quite get it to work. I am relatively new to python, so I am assuming I am missing a setting, version conflict, or maybe a firewall issue (or something similar). I keep getting an error: 404 : Not Found You are requesting a page that does not exist!

in my ipython notebook. I don't see anything on github to explain this, but have a feeling it is something simple. Any help would be greatly appreciated! Thanks.

I believe I'm using pivottable.js (in a Jupyter notebook) correctly, but please let me know if that's not the case.

In this example, I'm creating almost the simplest pandas dataframe possible:

test_data = DataFrame([['a', 'b'], ['b', 'a']], columns=['var1', 'var2'])

test_data

Dataframe:

 	var1 var2
0 	  a 	b
1 	  b 	a

When I display this in pivottable.js

pivot_ui(test_data)

The table shows that var1 and var2 both have 3 NULL values, and a total count of 5 records.

https://i.stack.imgur.com/M9y4Q.jpg

Is this expected behavior for my usage shown above? More than happy to be told I'm an idiot and I'm using pivottable.js incorrectly. :)

If this is unexpected behavior, I can provide further information about my system configuration.

Thanks!

Hi, I am trying to use sorters with pivot_ui. I get the following error in the browser "An error occurred rendering the PivotTable UI."

Code as below: import pandas as pd import numpy as np import pivottablejs as pj

linDir = "F:\Operations\MIS\DailyLockedIn\" linFile = "LockedInDataSheet.xlsx" outHtml = linDir+"LI.html"

ld = pd.read_excel(linDir+linFile) pj.pivot_ui(ld, outfile_path=outHtml, rows=["IPG"], cols=["LOAD_DATE","Parameter"], aggregatorName="Integer Sum", vals=["AP"], exclusions={"IPG":["NO IPG","PES-IND"], "Parameter":["ELAPSED","@ RISK EBD"]}, sorters={"Parameter":["BHC","ERD","EBD","ELAPSED","@ RISK EBD"]} sort_keys = True )

Any help is highly appreciated.

Is there any way to apply the 'filter' from PivotTableJs directly on Python, eg, have a bunch of data but by default apply a filter to it, so that all data is available but only some is on display by default?

Hi. I read through your examples: onRefresh example and save_restore example

but I am unable to figure out how to create that javascript code through the pivot_ui() function call in Jupyter notebook. I realize that pivot_ui(data, onRefresh="something") can be used but in javascript onRefresh should be assigned a callback function and as far as I could experiment, the "something" always gets passed in as string.

Hi

https://github.com/nicolaskruchten/pivottable/wiki/Frequently-Asked-Questions#totals

I'd like to be able to hide the totals column/row using this python module and as answered in the link above. How would one go about doing this?

User cannot choose the type of graphs that needs to be generated. Say, only bar graphs and tree map is needed, the user cannot choose and still has to display all other options even though not used.

Can you please provide a visual installation of pivottable? I am not very familiar with the coding. I would like to install it on Easyphp server on my computer. I went through your documentation, and made some internet search but I couldn't find visual installation guides. Thanks.

fantastic tool.

I use it from a python Jupiter lab notebook. I have run into a couple of problems

if I construct the table interactively it creates a nice table. however the entire table is not displayed. I have to scroll. This prevents me from using screen capture.

Also is there a way to extract whatever argument (row, cols, ...) I would need if I wanted to recreate the table programmatically. It seems like I am constantly re-doing my plot

Kind regards

Andy

'import streamlit as st import streamlit.components.v1 as components from pivottablejs import pivot_ui import pandas as pd

iris = pd.read_csv( "https://raw.githubusercontent.com/mwaskom/seaborn-data/master/iris.csv" )

t = pivot_ui(iris)

with open(t.src) as t: components.html(t.read(), width=900, height=1000, scrolling=True)`

When trying this example I get this error : ImportError: cannot import name 'pivot_ui' from partially initialized module 'pivottablejs' (most likely due to a circular import) I tested it without streamlit and resulted in the save error : I tested in .py file and jupyter notebook Thanks for an answer

Hi, Thanks a lot for this amazing tool with python support.

So far this is the only one that can generate offline HTML with dataframe tables and plot.

This interactive offline html versionjs table looks like this with the columns values in the far left horizontal box and the plot dropdown on top of that. This needs dragging of each column to the second horizontal box to visualize the column contents or the plots.

Just wondering if it is possible to align them like the one in the regular pivotblejs. This one very convinient.

Someone else posted this before but in a hijacking attempt of another issue, so let me repeat it here:

pivot_ui(df) does not display anything for some users (including me).

See from the other issue as well as yet another issue, which I think describes the same problem but isn't very specific about it.

I'm using pivottables.js in a Jupyter Notebook, and would like to know if it is possible to use the Plotly renderer the same way it is used in the JavaScript implementation? It would be very useful, especially the ability to save charts generated to a file.

If there is no support for Plotly, is there any other way I could save the charts to files on my computer?

Thanks!