Convert python string into integer without commas in them

Question

I am using beautifulsoup4 to extract prices tag from a website. The code i m using is this

 #price
        try:
            price = soup.find('span',{'id':'actualprice'})
            price_result= str(price.get_text())
            print "Price: ",price_result
        except StandardError as e:
            price_result="Error was {0}".format(e)
            print price_result

The output i m getting is a string with a format with commas in it. e.g. 82,000,00

What i want:

Change the format from string price to integer price without commas in it so that i can use them as values intead of strings in excel

What do you mean by "without commas"? You want to remove commas from your number, or simple change it into dot? — Laszlowaty, Jun 03 '16 at 07:54
All i want is to use it as a number when i extract it so i can do my computation. — Panetta, Jun 03 '16 at 07:55
It's a weird notation. Normally it would be 82,000.00 or 82.000,00. Are the "numbers" always like this format? — totoro, Jun 03 '16 at 07:57

score 7 · Accepted Answer · answered Jun 03 '16 at 07:58

7

You can do this :

>>> string = '82,000,00'
>>> int(price_result.replace(',', ''))
8200000

answered Jun 03 '16 at 07:58

3kt

2,543
1
17
29

Wouldn't that make it 100 times bigger? – totoro Jun 03 '16 at 07:59
It depends whether the second comma separates the fractional part or not. The question is not clear about this... – 3kt Jun 03 '16 at 08:04
there is no point. this solves – Panetta Jun 03 '16 at 10:24
If I use the method above, I am getting this ```invalid literal for int() with base 10: ''``` – Mohamed Imran Aug 08 '20 at 05:19

score 1 · Answer 2 · answered Jun 03 '16 at 08:02

Checkout https://docs.python.org/2/library/string.html or https://docs.python.org/3/library/string.html depending on the Python version you are using and use the "replace()" function:

int_price = int(price_result.replace(',',''))

This replaces all commas within the string and then casts it to an INT:

>>> price = "1,000,000"
>>> type(price)
<type 'str'>
>>> int_price = int(price.replace(',',''))
>>> type(int_price)
<type 'int'>
>>>

score 1 · Answer 3 · answered Jun 03 '16 at 08:09

1

If the last part is a fractional part, you could do something like this:

import re
r = re.compile(r'((?:\d{1,3},?)+)(,\d{2})')
m = r.match('82,000,00')
v = m.group(1).replace(',', '') + m.group(2).replace(',', '.')
print(float(v))

Output:

82000.0

answered Jun 03 '16 at 08:09

totoro

2,469
2
19
23

SuperNova · Answer 4 · 2016-06-03T08:18:58.387

1

import re

''.join(re.findall(r'\d+', '82,000,00'))

or another method will be,

int(filter(str.isdigit, '82,000,00'))

edited Jun 03 '16 at 08:18

answered Jun 03 '16 at 08:11

SuperNova

25,512
7
93
64

Convert python string into integer without commas in them

4 Answers4