pandas show large numbers with commas code example

Example: pandas show large numbers with commas

#make large numbers more readable by adding commas
pd.options.display.float_format = '{:,}'.format
# Example
123456789.12345 -> 123,456,789.12345

#this adds commas and limits decimals to 2 places
pd.options.display.float_format = '{:,.2f}'.format
# Example
123456789.12345 -> 123,456,789.12

#this adds the dollar sign to the front
pd.options.display.float_format = '${:,.2f}'.format
# Example
123456789.12345 -> $123,456,789.12

Tags:

Misc Example