ukri-excalibur / excalibur-tests

Performance benchmarks and regression tests for the ExCALIBUR project
https://ukri-excalibur.github.io/excalibur-tests/
Apache License 2.0
18 stars 15 forks source link

Investigate pivottable as a possibility for visualisation #257

Closed ilectra closed 7 months ago

ilectra commented 8 months ago

The python API of this library could be used as an interactive way to plot benchmark results. But, in order to be reproducible, it will need to be able to produce a script that creates the final product (table or plot). See https://github.com/ukri-excalibur/excalibur-tests/pull/226#issuecomment-1842577084 for how it looks.

ilectra commented 7 months ago

Maybe this is of interest, to save the state of the data/plot https://github.com/nicolaskruchten/pivottable/wiki/Frequently-Asked-Questions#accessingsaving-pivottable-state

ilectra commented 7 months ago

Apparently, the above method for saving a json of the pivottable attributes has not been implemented in the python API of the js package - see discussion on SO, that includes a (terrible) hacky solution. There doesn't seem to be any interest by the developers of the python package to include the functionality either... :frowning_face:

ilectra commented 7 months ago

I also cannot find any obvious way to display several plots and/or tables in the same page or in different tabs, unless the solution is via the extra renderers. However, I suspect those will have the above problem, as they are not simple variables passed to the pivot_ui() function, but complex (js) function objects.

ilectra commented 7 months ago

We're not going to use pivottable.js.