Converting scientific notation in Series to commas and thousands separator

Question

I have a Series with Name as the index and a number in scientific notation such as 3.176154e+08. How can I convert this number to 317,615,384.61538464 with a thousands separator? I tried:

format(s, ',')

But it returns TypeError: non-empty format string passed to object.format There are no NaNs in the data.

Thanks for your help!

@raninjan Thank you for the help! That works perfectly. I saw that other thread but didn't realize I needed to apply the lambda. — lori_lane, Jan 31 '17 at 21:18

score 7 · Accepted Answer · edited May 23 '17 at 11:53

7

You can use '{:,}'.format(s) as described in response to another similar question on stackoverflow. Using your example:

s = pd.Series([3.176154e+08,3.176154e+08],name='Name') 
s.apply(lambda x: '{:,}'.format(x))

edited May 23 '17 at 11:53

Community

1
1

answered Jan 31 '17 at 07:06

raninjan

186
7

score 0 · Answer 2 · answered Jul 25 '20 at 15:31

0

You can also use

SeriesName.map('{:,}'.format)

answered Jul 25 '20 at 15:31

Ana

11
6

Converting scientific notation in Series to commas and thousands separator

2 Answers2