Convert number string to number using python 3.6+

Question

I have got the value from database 350,000,000.00 now I need to convert it to 350000000. Please provide a solution on this using Python 3.6+ version

Thanks

Possible duplicate of [Python parse comma-separated number into int](https://stackoverflow.com/questions/2953746/python-parse-comma-separated-number-into-int) — doctorlove, Jun 20 '17 at 09:54
Possible duplicate of [How do I use Python to convert a string to a number if it has commas in it as thousands separators?](https://stackoverflow.com/questions/1779288/how-do-i-use-python-to-convert-a-string-to-a-number-if-it-has-commas-in-it-as-th) — Tezra, Jun 20 '17 at 12:30
This is not duplicate. I am getting number with comma separated, then I need to add "", then remove comma and dot(.). — Kuladip, Jun 21 '17 at 07:49

score 4 · Answer 1 · answered Jun 20 '17 at 10:10

4

Let the input be in a variable, say

a="350,000,000.00"

Since, the digits are comma , separated, that needs to be removed.

a.replace(",","")
>>> 350000000.00

The resultant string is a float. When we directly convert the string to integer, it will result in an error.

int(a.replace(",",""))
>>>Traceback (most recent call last):
  File "python", line 2, in <module>
ValueError: invalid literal for int() with base 10: '350000000.00'

So, convert the number to float and then to int.

int(float(a.replace(",","")))
>>>350000000

answered Jun 20 '17 at 10:10

voidpro

1,652
13
27

Please note that I am getting 350,000,000.00 not "350,000,000.00" . How I will convert 350,000,000.00 to "350,000,000.00" . please let me know – Kuladip Jun 20 '17 at 11:03
@Kuladip Just read, it is sourced from DB. The values will be string by default. Try using the string function on the field. – voidpro Jun 20 '17 at 11:09

score 1 · Answer 2 · answered Jun 20 '17 at 09:52

1

Store the value in a variable and then parse it with int(variable_name)

eg. If you store the value in variable a, just write int(float(a))

answered Jun 20 '17 at 09:52

Shubham Jain

11
2

score 1 · Answer 3 · answered Jun 20 '17 at 09:59

1

def convert(a):
    r = 0
    s = a.split(".")[0]
    for c in s.split(","):
        r = r * 1000 + int(c)
    return r

s = convert("350,000,000.00")

answered Jun 20 '17 at 09:59

alkaya

145
6

Please note that I am getting 350,000,000.00 not "350,000,000.00" . How I will convert 350,000,000.00 to "350,000,000.00" . please let me know – Kuladip Jun 20 '17 at 11:03

Convert number string to number using python 3.6+

3 Answers3