Python: extract number from String

Question

I'm new to Python and I was trying to get a "price tag String" to get converted into a float, so I can easily compare the result with other prices. I searched for 2 hours for a answer for this "simple problem", but none of them fitted my needs.

So basically, I have a price like this:

1.222.333,44 EUR

(comma and period swapped because I live in Germany, which is also pretty annoying)

And I want to get this for easy comparing:

1222333.44

The main idea is to compare prices, which is my school project.
I used to do everything with php, which worked, but was way too slow.

If you have a more elegant or simple way, please let me know.

More elegant than what? You didn't post a solution.

wwii
– wwii

2017-06-11 18:59:31 +00:00
Commented Jun 11, 2017 at 18:59 — wwii
– wwii, Commented Jun 11, 2017 at 18:59
Possible duplicate of convert decimal mark

wwii
– wwii

2017-06-11 19:04:18 +00:00
Commented Jun 11, 2017 at 19:04 — wwii
– wwii, Commented Jun 11, 2017 at 19:04

Y. Luo · Accepted Answer · 2017-06-11 19:21:43Z

8

This work for the specific case you provided:

float(s.replace('.', '').replace(',', '.').split(' ')[0])

It requires:

Periods in price are only separators;
Only one comma in price and is just a decimal mark;
The price comes first and is separated from other strings by a whitespace.

Just to mention in case people need more generalized solution, hiro protagonist's answer using locale is very helpful when you need a simple way to switch between numeral systems during coding or when maintaining your codes.

edited Jun 11, 2017 at 19:21

answered Jun 11, 2017 at 18:49

Y. Luo

5,7521 gold badge22 silver badges27 bronze badges

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

Comments

hiro protagonist · Accepted Answer · 2017-06-11 19:04:40Z

8

you can use your (or any) locale to convert a string to a float:

import locale
locale.setlocale(locale.LC_ALL, 'de_DE.UTF-8')
print(locale.atof('1.222.333,44'))  # -> 1222333.44

depending on your default locale you may not even have to specify the locale.

in your case you may need to split the currency (EUR) part away:

price = '1.222.333,44 EUR'
price_float = locale.atof(price.split()[0])
print(price_float) # -> 1222333.44

note: it may be enough not to setLC_ALL but just LC_NUMERIC to what you need.

edited Jun 11, 2017 at 19:04

answered Jun 11, 2017 at 18:51

hiro protagonist

47.3k17 gold badges93 silver badges119 bronze badges

Comments

PythonProgrammi · Accepted Answer · 2017-06-12 16:54:15Z

0

If your string is "1.222.333,44 EUR"

prince = "1.222.333,44 EUR"
price = price[:-4]
price = price.replace(".","").replace(",",".")
floatprice = float(price)

If it is just like this "1.222.333,44"

floatprice = float("1.222.333,44".replace(".","").replace(",","."))

answered Jun 12, 2017 at 16:54

PythonProgrammi

23.6k3 gold badges44 silver badges35 bronze badges

Collectives™ on Stack Overflow

Python: extract number from String

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related