Remove \xa0 from string using in Python

Question

I have a list of prices from which I want to remove all space such that the prices[0] = '2673.00'

prices = ['2 673.00', '53.55', '1 478.00', ... ]
prices = [float(x) for x in prices]

I have tried various options but none has worked for me.

x = str(prices[0]).replace(' ', '') # Got error --> ValueError: could not convert string to float: '2\xa0673.00'

import unicodedata
my_str = unicodedata.normalize("NFD", str(prices[0])) # tried  ‘NFC’, ‘NFKC’, ‘NFD’, and ‘NFKD’ as different forms but got same error as above

x = str(prices[0]).replace(u'\xa0', u'')  # Got error --> ValueError: could not convert string to float: '2\xa0673.00'

Please suggest a possible way. Thanks.

You may remove any whitespace with a regex like re.compile(r'\s+', re.U). — Wiktor Stribiżew
– Wiktor Stribiżew, Commented May 16, 2017 at 13:34

Liran Funaro · Accepted Answer · 2023-11-09 08:46:56Z

3

If the input is given, this will surely work:

import re
regexp = re.compile(r'\s+', re.UNICODE)
prices_norm = [regexp.sub('', p) for p in prices]

But if you have control over the production of the prices, a better solution will be not to print the floats with spaces. Just change the locale before you print them:

import locale
locale.setlocale(locale.LC_ALL, 'en_US')

edited Nov 9, 2023 at 8:46

answered May 16, 2017 at 13:32

Liran Funaro

2,8882 gold badges24 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Remove \xa0 from string using in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related