Dash DataTable - Formatter string

Hi,
is there a way to define a formatter string for displaying numbers in the DataTable component?

1 Like

you can format data in pandas dataframe and DataTable will display them that way as they are. i use:
table_df['col_name']=table_df['col_name'].map('{:,.2f}%'.format)
to display percent value. and
table_df['col_name']=table_df['col_name'].map("{:,.0f}".format)
to display float type without decimal part.

2 Likes

Thanks @roman, this is useful. However, when I format numbers this way, the Dash data table no longer sorts correctly. Here’s an example:
image

The comma is regarded as a character used in the sorting, so 98,087,500 falls between 990,000,000 and 977,000,000

Do you have any ideas how to solve this? I tried also changing the display format of the underlying dataframe, but this formatting was not reflected in the Dash data table.

pd.options.display.float_format = '{:,.0f}'.format

1 Like

HI! Same problem. I just switch off sorting for the table whith formatting =( As i can understand problem starts after .map or .format float type becouse it converts float to string and we get unexpected result of sorting. To solve this, i think we can create some component mb dcc.dropdown with column names and sort pandas dataframe and format it and after display at table in callback of that dropdown.

Also tracking in https://github.com/plotly/dash-table-experiments/issues/17

I don’t believe that there is a workaround for this issue yet besides doing server-side sorting/filtering with callbacks as mentioned here:

Was this ever solved in the DataTable component? Thanks!

Yes, scroll down to Examples in here: https://dash.plot.ly/datatable/typing