convert decimal mark

python locale decimal-point
Till B picture Till B · Aug 18, 2011 · Viewed 75.2k times · Source

I have a CSV file with data reading that I want to read into Python. I get lists that contain strings like "2,5". Now doing float("2,5") does not work, because it has the wrong decimal mark.

How do I read this into Python as 2.5?

Answer

Lauritz V. Thaulow picture Lauritz V. Thaulow · Aug 18, 2011

You may do it the locale-aware way:

import locale

# Set to users preferred locale:
locale.setlocale(locale.LC_ALL, '')
# Or a specific locale:
locale.setlocale(locale.LC_NUMERIC, "en_DK.UTF-8")

print locale.atof("3,14")

Read this section before using this method.

Related questions

Python locale error: unsupported locale setting

Why do I get the following error when doing this in python: >>> import locale >>> print str( locale.getlocale() ) (None, None) >>> locale.setlocale(locale.LC_ALL, 'de_DE') Traceback (most recent call …

Read More
Locale date formatting in Python

How do I get datetime.datetime.now() printed out in the native language? >>> session.deathDate.strftime("%a, %d %b %Y") 'Fri, 12 Jun 2009' I'd like to get the same result but in local language.

Read More
Add 'decimal-mark' thousands separators to a number

How do I format 1000000 to 1.000.000 in Python? where the '.' is the decimal-mark thousands separator.

Read More