Dash DataTable - Thousands Separator

Dash Python
1

How can I have thousand’s comma separator in DataTable? Usually, I’d go with plotly layout, but as far as I can see I cannot embed this into a figure as data.

Also some custom data formatting for rows (For example using python’s format f"{x:,.3f}$" for example or something like that

2 Likes
2

@nmiculinic - For now, you’ll need to convert your data to strings (in whatever format you want) and supply that formatted data as the rows property. There aren’t any built-in formatters in the dash DataTable to do this for you.

3

I see. The thing is, numbers are ordable (>, <, …) operators work as expected for filtering, but for strings they’re not working. Thus I’d be more than happy to have only thousand’s separator for number without custom formating for now.

1 Like
4

true…I think we need to add this feature

5

Hi, I have a similar usecase to have a thousands comma separator in the Datatable. Has there been any update on this, or is t still the old way to convert everything to string?

6

Thanks to a customer that sponsored this feature, there are now built in formatters :tada:

see Typing and User Input Processing | Dash for Python Documentation | Plotly

7

I’m still confused. Looked through the documentation, couldn’t find the simple thousands comma separator. Could someone help? thanks

2 Likes
8

Sweet this is a monumental improvement.
Is it possible to specify a python f-style formatting string for the ‘format’ argument? rather than use the Format() object?

Thanks

9

It’s not, as we’re actually doing the formatting in the front end (in JavaScript) rather than in Python. However, we designed the Format object to be similar to the Python format string syntax.

10

I got this working by setting the columns field on my datatable as follows:

import dash_table
from dash_table.Format import Format

dash_table.DataTable(
    id='my-table',
    columns=[
        {'name': 'name', 'id': 'name'},
        {'name': 'number-column', 'id': 'number-column', 'type': 'numeric', 'format': Format(group=',')},
    ],
    data=[],
)

I agree it would be nice to have some more examples in the documentation.

7 Likes
11

Thanks for the update! :+1:
Could we also do it in the conditional format? I tried it, it doesn’t seem work.

style_data_conditional=[{
‘if’: {‘column_id’: ‘ColumnName’},
‘column_type’: ‘numeric’,
‘format’: Format(group=‘,’),
}],

But the example provided by @tcoleman works for me. :+1: