Sortable Column with Pandas Dataframe

[BlackF0rest]

Question

Hi,
I am generating my ui.table with ui.table.from_pandas(dataframe) and need to make a column sortable. Is there any way to do that? In the doc i didnt find anything showing anything similar.

[falkoschindler]

Hi @BlackF0rest,

You can manipulate the column definitions after instantiating the AG Grid element like this:

df = pd.DataFrame(data={'col1': [1, 2], 'col2': [3, 4]})
aggrid = ui.aggrid.from_pandas(df)
aggrid.options['columnDefs'][0]['sortable'] = True

[BlackF0rest]

So there is no way to do it with a table Element? I find it much nicer and have allready build an Website around it.

[falkoschindler]

Oh, I confused ui.table with ui.aggrid. Here you go:

df = pd.DataFrame(data={'col1': [1, 2], 'col2': [3, 4]})
table = ui.table.from_pandas(df)
table.columns[0]['sortable'] = True