# Function to extract float from different price patterns

I've got a project where I get product data and need to get the prices which come in, in different formats.

Some examples would be: US$17, USD17.00, 17,00€, 17€, GBP17, Only 17,-€, 17.000,00€, 17,000.00$ etc.

So at the beginning I started with one specific string to float function and kept on adding code for specific use cases. I'm sure the code looks horrible and I can see already ways to improve it, but I wanted to get your opinions in the first place.

def convertPriceIntoFloat ( myString ):
myString = myString.strip()

# 1.298,90 €
if "€" in myString and "." in myString and "," in myString:
myString = (myString.replace('€', '')).strip()
myString = (myString.replace('.', '')).strip()
float_price = float(myString.replace(',', '.'))
return(float_price)
if "€" in myString and "*" in myString and "ab" in myString:
myString = (myString.replace('€', '')).strip()
myString = (myString.replace('*', '')).strip()
myString = (myString.replace('ab', '')).strip()
float_price = float(myString.replace(',', '.'))
return(float_price)
if "€" in myString and "ab" in myString:
myString = (myString.replace('€', '')).strip()
myString = (myString.replace('ab', '')).strip()
if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None: # thousand EURO or more myString = (myString.replace('.', '')).strip() float_price = float(myString.replace(',', '.')) else: float_price = float(myString.replace(',', '.')) return(float_price) # 599,- € if ",-" in myString and "€" in myString: myString = (myString.replace('€', '')).strip() myString = (myString.replace(',-', '.00')).strip() if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None:
# thousand EURO or more
myString = (myString.replace('.', '')).strip()
float_price = float(myString.replace(',', '.'))
else:
float_price = float(myString.replace(',', '.'))
return(float_price)

# ↵179,89 €↵*↵
if "€" in myString and "*" in myString:
myString = (myString.replace('€', '')).strip()
myString = (myString.replace('*', '')).strip()
if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None: # thousand EURO or more myString = (myString.replace('.', '')).strip() float_price = float(myString.replace(',', '.')) else: float_price = float(myString.replace(',', '.')) return(float_price) # ab 223,90 EUR if "EUR" in myString and "ab" in myString: myString = (myString.replace('EUR', '')).strip() myString = (myString.replace('ab', '')).strip() if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None:
# thousand EURO or more
myString = (myString.replace('.', '')).strip()
float_price = float(myString.replace(',', '.'))
else:
float_price = float(myString.replace(',', '.'))
return(float_price)

if "EUR" in myString:
# GB Pound
myString = (myString.replace('EUR', '')).strip()
if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None: # thousand EURO or more myString = (myString.replace('.', '')).strip() float_price = float(myString.replace(',', '.')) else: float_price = float(myString.replace(',', '.')) return(float_price) if "CHF" in myString: # CHF Schweiz myString = (myString.replace('CHF', '')).strip() if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None:
# thousand Franks or more
myString = (myString.replace('.', '')).strip()
float_price = float(myString.replace(',', '.'))
else:
float_price = float(myString.replace(',', '.'))
return(float_price)

if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None: # thousand EURO or more, coming in as a float already myString = (myString.replace('.', '')).strip() float_price = float(myString.replace(',', '.')) return(float_price) # 122,60 £ if "£" in myString: # remove GB Pound sign myString = (myString.replace('£', '')).strip() if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None:
# thousand GB Pounds or more
myString = (myString.replace('.', '')).strip()
float_price = float(myString.replace(',', '.'))
# 122,60 £
if re.match('^\d{1,3}\,\d{2}$', myString) is not None: # myString = (myString.replace('.', '')).strip() float_price = float(myString.replace(',', '.')) return(float_price) if "$" in myString:
# GB Pound
myString = (myString.replace('$', '')).strip() float_price = float(myString.replace(',', '')) return(float_price) if ",-" in myString: float_price = float(myString.replace(',-', '.00')) return(float_price) if re.match('^\d{1,3}\,\d{2}$', myString) is not None:
float_price = float(myString.replace(',', '.'))
return(float_price)
if " " in myString and "&#8364" in myString:
return ( getPriceFromCommaString ( myString ) )
# UVP: 44,95 EURO
if "UVP:" in myString and "EURO" in myString:
myString = (myString.replace('UVP:', '')).strip()
myString = (myString.replace('EURO', '')).strip()
float_price = float(myString.replace(',', '.'))
return(float_price)
# 22,99 €
# € 1.199,99
if "€" in myString:
myString = (myString.replace('€', '')).strip()
if re.match('^\d{1,3}\.\d{3}\,\d{2}$', myString) is not None: # thousand EURO or more myString = (myString.replace('.', '')).strip() float_price = float(myString.replace(',', '.')) else: float_price = float(myString.replace(',', '.')) return(float_price) else: return(myString)  If anybody knows a Python library that does the same thing, I'd be happy to flip as well. • What does your program actually do? Jun 1, 2019 at 4:35 • It's a Function to extract float values from price strings. Those strings can have different formats. Jun 1, 2019 at 4:40 • So for 1.298,90 € should the output be 1298.9? Jun 1, 2019 at 4:47 • Exactly. And then there are different currencies, different ways of displaying prices etc. Jun 1, 2019 at 5:22 • I don't have experience with Python, but if I understood your problem correctly, isn't it the easiest way to just extract those characters that are a number and parse them as a float? Either with a simple regex or string functions. Jun 2, 2019 at 11:52 ## 3 Answers I agree that this is a little complicated. I'd recommend you write a set of tests, and let those guide the complexity of the code. The tests would be simple, like, assertEq convertPriceIntoFloat("1298,90"), 1298.9 assertEq convertPriceIntoFloat("1.298,90"), 1298.9 assertEq convertPriceIntoFloat("1.298,90 €"), 1298.9 ...  Then, start out with a simple float conversion in your code, and see if that works, then add test cases and only add code as you need it. If things do seem to be getting overly complicated, refactor... you'll have tests that let you do that easily. Good luck. • From my untrained eye it looks like a simple regex would help ease the problem. ^(.*?)([\d\.,]+)(.*)$


This is as it results in the following output:

>>> pprint([re.match('^(.*?)([\d\.,]+)(.*)$', i).groups() for i in ('US$17', 'USD17.00', '17,00€', '17€', 'GBP17', 'Only 17,-€', '17.000,00€', '17,000.00$')]) [('US$', '17', ''),
('USD', '17.00', ''),
('', '17,00', '€'),
('', '17', '€'),
('GBP', '17', ''),
('Only ', '17,', '-€'),
('', '17.000,00', '€'),
('', '17,000.00', '$')]  • Now that we have the money all that is left is to convert it to a float. Since you have thousands separators then you can't just use float. And so if you pass the 'thousand separator' and the 'decimal place' to the function and use str.translate then you can convert the code into the form you want. import re def _extract_price(value): match = re.match('^(.*?)([\d\.,]+)(.*)$', value)
if match is None:
raise ValueError("Can't extract price")
return match.groups()

def _parse_price(price, thousand, decimal):
trans = str.maketrans(decimal, '.', thousand)
return float(price.translate(trans))

def parse_price(value):
prefix, price, suffix = _extract_price(value)
if '€' in prefix + suffix:
thousand = '.'
decimal = ','
else:
thousand = ','
decimal = '.'
return _parse_price(price, thousand, decimal)

>>> [parse_price(i) for i in ('US$17', 'USD17.00', '17,00€', '17€', 'GBP17', 'Only 17,-€', '17.000,00€', '17,000.00$')]
[17.0, 17.0, 17.0, 17.0, 17.0, 17.0, 17000.0, 17000.0]

• I would favor this approach if we have a simple language to deal with. If the examples as presented by the OP represent the full sample space, go for the regex! The more complex the language, the sooner writing your own parser/compiler wins from a regex, no matter how smartly written. Jun 1, 2019 at 16:53
• @dfhwze Yes, regex isn't good with large complex grammar. For simple grammar like the this it's better than writing a parser. Jun 1, 2019 at 17:42

If anybody knows a Python library that does the same thing, I'd be happy to flip as well.

I suggest you use the "Price and currency parsing utility" -

Money Parser is a price and currency parsing utility.

It provides methods to extract price and currency information from the raw string.

There is a lot of different price and currency formats that present values with separators, spacing, etc.

Here are some examples of what it can do -

>>> price_str("1.298,90 €")
'1298.90'

>>> price_str("599,- €")
'599'

>>> price_str("↵179,89 €↵*↵")
'179.89'

>>> price_str("ab 223,90 EUR")
'223.90'

>>> price_str("122,60 £")
'122.60'

>>> price_str("UVP: 44,95 EURO")
'44.95'

>>> price_str("22,99 €")
'22.99'

>>> price_str(None, default='0')
'0'

>>> price_str("€ 1.199,99")
'1199.99'


NOTES -

Open Command Prompt and, if you have Python version >= 3.4, then install the Money Parser module using - pip install money-parser.

Open the Python IDLE and call the module - from money_parser import price_str

Try out an example from above and you'll know that you have achieved your desired results.

Hope this helps!