Hi,
I’m trying to apply formatting to my dataframe to make it look nice on the display and I’ve encountered several issues, but for now I’ll just stick to the decimals formatting.
- general decimal formatting works well for any given column, but in my case I need to format a column to various decimal places based on value (eg: value greater than 1000, no decimals, value between 1 and 1000, 2 decimal places, and value less than 1, 5 decimal places). ‘Price’ is the name of my column in this example:
st.dataframe(table.style.format({‘Price’: lambda x: ‘{:,.0f}’ if x >= 1000 else ‘{:,.2f}’ if 1 <= x < 1000 else ‘{:,.5f}’})
On the streamlit app I get on this column only the corresponding formatting, but not the values: {:,.2f}, {:,.0f} etc…
Does anyone know why?