use string format() to format a number

Question

I need to format a series of float to show comma delimitation every 3 digits:

1234567.89123

should become

1,234,567.89123

without using:

locale.setlocale(locale.LC_ALL, 'en_US.utf8')

I could convert the float to string and insert commas every three digits starting from left of the decimal dot... Is there a nicer way?

Possible duplicate of How to print number with commas as thousands separators? — Farini
– Farini, Commented Apr 1, 2017 at 15:10

piRSquared · Accepted Answer · 2017-04-01 14:51:47Z

2

Refer to this for more information on how to format

s = pd.Series([12345678.9876] * 3)

s.apply('{:,}'.format)

0    12,345,678.9876
1    12,345,678.9876
2    12,345,678.9876
dtype: object

pandas also allows you to set options temporarily with pd.option_context

with pd.option_context('display.float_format', '{:,}'.format):
    print(s)

0   12,345,678.9876
1   12,345,678.9876
2   12,345,678.9876
dtype: float64

edited Apr 1, 2017 at 14:51

answered Apr 1, 2017 at 14:44

piRSquared

296k68 gold badges509 silver badges654 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

use string format() to format a number

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related