Code Editor for app.py

from st_aggrid import AgGrid, GridOptionsBuilder, JsCode
import pandas as pd

# Create a simple cell renderer for formatting currency
currency_renderer = JsCode("""
function(params) {
    return '$' + params.value.toLocaleString('en-US', {
        minimumFractionDigits: 2,
        maximumFractionDigits: 2
    });
}
""")

# Sample data
df = pd.DataFrame({
    'product': ['Widget A', 'Widget B', 'Widget C'],
    'price': [1234.56, 2345.67, 3456.78]
})

# Configure grid options
gb = GridOptionsBuilder.from_dataframe(df)
gb.configure_column('price', cellRenderer=currency_renderer)
grid_options = gb.build()

# Display the grid
grid_return = AgGrid(
    df,
    gridOptions=grid_options,
    allow_unsafe_jscode=True
)