Color to st.data_editor

[dataprofessor]

Hi @valeriofiorentini

There’s a related forum post here that describes a similar issue:

Using st.data_editor on dataframes that have styled columns

Summary iam using st.data_editor to create a interactive dataframe, but in my dataframe cells in “Status” column has background color (green or red) based on the value of that cell. so when u try to update any other columns of my dataframe using st.data_editor the updated value is not visible in the dataframe, i even tried disabling edit option on the “Status” column Steps to reproduce Code snippet: styled = filtered_df.style.applymap(highlight_status, subset=pd.IndexSlice[:, ['Status']]) …

Particularly, this reply in the post notes that st.data_editor is partly compatible with Pandas styler:

Using st.data_editor on dataframes that have styled columns

The current version of st.data_editor should be partly compatible with Pandas styler as input, but there are restrictions: Only works for non-editable / disabled columns. Currently, it returns the edited data as a dataframe and not as Pandas Styler. So you have to apply the styling logic again on the edited df if you want to show that. But your issue sounds like something that also might be a bug. Maybe what could help is a video that showcases the editing issue.

And that styling should also be applied on edited dataframes.

Hope this helps!