Sorting treats thousand separator-formatted numbers as strings

[granger2023]

I've noticed if I format a column as '{:,.0f}', it treats the rendered column as strings instead of numbers, and sorting becomes a problem. For example "90,123" will be bigger than "100,999".

[granger2023]

This is solved if I force conversion into float before rendering: df = df.astype('float64') (or selected columns only).