decimal comma

[DPaul]

Hi , I need to convert "5,8" to a float = 5.8
Reading on this subject proposes 3 solutions
- Adapt the locale
- Do a replace (',','.') (if no 1000 separators)
- Regex...
I wonder if in the latest python releases something better has been proposed,
or what would be the preferred solution?
thx,
Paul

[Larz60+]

try:

>>> x = "5,8" >>> print(float(x.replace(',', '.'))) 5.8

[DPaul]

OK Larz, that is the on I chose as well.
The only replace caveat is when there are also 1000 "." separators in the number. (like "100.000,55")
Then you have to do a merry-go-round execise in 2 or 3 steps.
thx,
Paul

[Gribouillis]

You could use str.translate()

>>> s = "100.123.654,90" >>> s.translate({ord('.'): ',', ord(','): '.'}) '100,123,654.90'

or

>>> table = {ord('.'): '', ord(','): '.'} >>> s = "100.123.654,90" >>> s.translate(table) '100123654.90'

[DPaul]

Translate function: nice!
If I wanted to keep a 1000 separator:

s1 = "100.123,90" trad = {44:46,46:95} x = s1.translate(trad) print(x)

Output:
100_123.90

But now I'm in trouble, because python will do

print(int('100_000') + int('100_000'))

but it won't do:

print(int(x) + int('100_000'))

=> ValueError: invalid literal for int() with base 10: '100_123.90'
Any obvious rea

[DPaul]

Translate function: nice!
If I wanted to keep a 1000 separator:

s1 = "100.123,90" trad = {44:46,46:95} x = s1.translate(trad) print(x)

Output:
100_123.90

But now I'm in trouble, because python will do

print(int('100_000') + int('100_000'))

but it won't do:

print(int(x) + int('100_000'))

=> ValueError: invalid literal for int() with base 10: '100_123.90'
any obvious reason why?
Paul

[bowlofred]

int is for integers only. No decimals. Perhaps you meant float()

>>> float('100_000.2') 100000.2

[Gribouillis]

You can also use the higher level function maketrans() to build the table.

>>> table = str.maketrans(',', '.', '.') >>> s = "100.123.654,90" >>> s.translate(table) '100123654.90' >>> x = float(s.translate(table)) # compose with float ! >>> x 100123654.9

[DPaul]

OK, understood.
Allowed : int(100.55)
Allowed : int('100')
Not allowed : int('100.55')
Allowed: float('100.55')
thx,
Paul

[DeaD_EyE]

It looks like i18n/l10n stuff. You can use locale to delocalize language-specific strings.

import locale # get current systems locale # and set it for the current running interpreter locale.setlocale(locale.LC_ALL, locale.getlocale()) # input str from somewhere value_str = "1.200.500,33" # delocalize the value # converting the resulting str into a float value_float = float(locale.delocalize(value)) # format a float to a str with the current currency value_currency = locale.currency(value_float)

The package babel has additional helper functions: https://babel.pocoo.org/en/latest/numbers.html