st.column_config.SelectboxColumn: Extend config with dict mapping to separate backend and user value representation.

[robingie]

Problem

The current implementation of a select box is a great start but not always the data from the backend for the category options is the like the one for GUI. I'm missing a format function/option like in other widgets.

import pandas as pd
import streamlit as st

data_df = pd.DataFrame(
    {
        "category": [
            "📊 Data Exploration",
            "📈 Data Visualization",
            "🤖 LLM",
            "📊 Data Exploration",
        ],
    }
)

st.data_editor(
    data_df,
    column_config={
        "category": st.column_config.SelectboxColumn(
            "App Category",
            help="The category of the app",
            width="medium",
            options=[
                "📊 Data Exploration",
                "📈 Data Visualization",
                "🤖 LLM",
            ],
        )
    },
    hide_index=True,
)

Usually, options like this won't come from the backend directly and need to be converted before displaying them in the front end. I would really like to use a built-in solution for that, instead of formatting the panda's data frame before referencing it in the data editor as well as afterward to convert the users' selection back to the backend representation of the values.

Solution

A solution for that could be extending the config with a dictionary mapping to the user representation. In a way that it's just for display purposes.

import pandas as pd
import streamlit as st

data_df = pd.DataFrame(
    {
        "category": [
            "1",
            "2",
            "3",
            "4",
        ],
    }
)

st.data_editor(
    data_df,
    column_config={
        "category": st.column_config.SelectboxColumn(
            "App Category",
            help="The category of the app",
            width="medium",
            options={
                1:  "📊 Data Exploration",
                2:  "📈 Data Visualization",
                3:  "🤖 LLM",
            },
        )
    },
    hide_index=True,
)

---

Community voting on feature requests enables the Streamlit team to understand which features are most important to our users.

If you'd like the Streamlit team to prioritize this feature request, please use the 👍 (thumbs up emoji) reaction in response to the initial post.

[CHerSun]

format_func maybe? the same as everywhere else

[Scoodood]

Great idea, please make the API more consistent with format_func

[zbjdonald]

Any updates?