Format numbers output from the pandas df.describe() method. For instance, instead of outputting scientific notation, we can have numbers with thousands separators and a desired number of decimals.
For reference, see:
When using describe for a data frame, use .apply and a lambda function to apply the formatting to every number.
- To change the number of decimals, change the number before the f
- To remove the thousands separator remove the comma
df.describe().apply(lambda s: s.apply('{:,.0f}'.format))
When using describe with a single column or a series, use the .map method instead:
df['Column'].describe().map('{:,.0f}'.format)