Filtering doesn't work if column name has space [Sponsored: Due March 1]

[martinbaste]

Filtering on columns that contain a space in their name results in the filter string being considered as invalid.

After looking at the docs, it most likely is that the filter parser is being confused when turning the filter string into <column name> <operator> <value>

Temporary fix is, of course, removing spaces from column names.

[Marc-Andre-Rivet]

Thanks for reporting.

[martinbaste]

Symbols (including periods and parentheses) seem to cause trouble as well.

[yanpanlau]

Yes I am seeing the same problem too.

[chriddyp]

When this is fixed, let's report back to this community thread: https://community.plot.ly/t/dash-table-filtering-not-working-with-spaces-in-header/18036

[philspbr]

This is still broken for me on Dash 3.6.0
I am looping through the columns for conditional formatting like this

styles = [{
    if': {
        'column_id': str(x),
        'filter': '{} < num(0.5)'.format(x)
    },
    'color': 'red',
} for x in df]

If I apply this styline in the layout with style_data_conditional=styles the table is not rendered if a column name contains a space.

[Marc-Andre-Rivet]

Reviewing this in Dash v1.0.1 (dash-table==4.0.1), this seems to be working fine.

The syntax has changed a bit with the v1.0 migration. This syntax should now work:

            style_data_conditional: [{
                if: { column_id: 'my rows', filter_query: '{my rows} is odd' },
                backgroundColor: 'red'
            }, {
                if: { filter_query: '{c*c()c+-&} is even' },
                backgroundColor: 'blue'
            }]

Also reviewing in Dash v0.43 (dash-table==3.7.0), this also seems to be working fine, albeit with the old syntax.

            style_data_conditional: [{
                if: { column_id: 'my rows', filter: '{my rows} is odd' },
                backgroundColor: 'red'
            }, {
                if: { filter: '{c*c()c+-&} is even' },
                backgroundColor: 'blue'
            }]

Note: I just realized I wrote this using the JS interface of the table, which does not impact functionality but will need a slight adjustments for Python usage.

[Marc-Andre-Rivet]

@philspbr Closing this as fixed but do not hesitate to open a new issue with a minimum reproducible example if you encounter this problem again.