Sorters does not work

[kishmus]

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.

[nicolaskruchten]

Based on your usage of Python code I'm assuming you're using the Jupyter binding... It's not possible to use sorters with the Jupyter binding unfortunately: only JSON-serializable parameters can be used.

[nicolaskruchten]

(i've just updated the ReadMe here https://github.com/nicolaskruchten/jupyter_pivottablejs to make that clearer, sorry for any confusion!)

[kishmus]

Thanks Nicolas.
Yes. I am using Jupyter binding.

[AlexXQJ]

Based on your usage of Python code I'm assuming you're using the Jupyter binding... It's not possible to use sorters with the Jupyter binding unfortunately: JSON-serializable parameters can be used.

Hi Nicolas, could you show me an example on this?
i try:

sort_list='{"col_A": ["B","D","A","C"] }'
j = json.loads((sort_list))
pivot_ui(df,sorters=j)

but it comes out an error:
An error occurred rendering the PivotTable UI.

emmm, any ideas? some examples would be better.

[nicolaskruchten]

Sorry, I've edited my reply to add the missing word "only": only JSON-serializable parameters can be used. Meaning functions simply cannot be passed through as they are not JSON-serializable.

[AlexXQJ]

Hi Nicols, thanks for your reply.