Converting string to float with "," as thousands separator.. "123,000.12" to 123,000.12

Question

I can't perform any math operations on these values that I had exported. I'm using xlwt library to do this. Any way to convert these values in the format so that I can be able to perform math operations on it.

enter image description here

score 3 · Answer 1 · edited Nov 22 '20 at 16:50

3

float('3629,473.237'.replace(',', ''))

edited Nov 22 '20 at 16:50

Wasif

14,755
3
14
34

answered Nov 22 '20 at 06:45

MaxTechniche

141
5

2

Please don't use curly quotes use straight ones – Wasif Nov 22 '20 at 06:46
@WasifHasan I’m on iPhone, I don’t know how. – MaxTechniche Nov 22 '20 at 16:49
I have edited the answer for you. – Wasif Nov 22 '20 at 16:51

Wasif · Answer 2 · 2020-11-22T06:51:51.983

1

You can replace the commas, they make no sense except readablity

n = float("3629,473.237".replace(",",""))

To re-add commas as string, you can use format strings:

print("{:,}".format(n))

There are f-strings in python 3.6+

print(f"{n:,}")

edited Nov 22 '20 at 06:51

answered Nov 22 '20 at 06:46

Wasif

14,755
3
14
34

I need this commas as well. It is an requirement from our client. Any other solution? – Marcus Nov 22 '20 at 06:49
See the edit pls – Wasif Nov 22 '20 at 06:51

score 0 · Answer 3 · edited Nov 22 '20 at 16:51

0

No; you'll have to remove the comma manually.

float("123,000.12".replace(',',''))

If you have consistent data, you might as well remove all the commas and convert the result.

edited Nov 22 '20 at 16:51

Wasif

14,755
3
14
34

answered Nov 22 '20 at 06:58

sultan ayubi

1
1

Converting string to float with "," as thousands separator.. "123,000.12" to 123,000.12

3 Answers3