How to get float numbers formatted with dot and comma

Question

I need all numbers in my pandas dataframes converted to german number notation. It means there should be thousands decimal dot and a comma for fractions.

example.:

52.634,99

I can do it easily the other way around, first comma, then dot:

pd.options.display.float_format = '{:,.2f}'.format

Why is it not possible to use it this way?

pd.options.display.float_format = '{:.,2f}'.format

error:

ValueError: Format specifier missing precision

A hacky way would be to use the method that works, then replace commas by dots and viceversa using `string.replace()` — Sembei Norimaki, Nov 29 '21 at 14:32
Your attempt doesn't work because the order of things in the field format is strictly defined; it's not just a set of characters. — chepner, Nov 29 '21 at 14:33
See also https://stackoverflow.com/questions/6633523/how-can-i-convert-a-string-with-dot-and-comma-into-a-float-in-python . — Karl Knechtel, Nov 29 '21 at 14:42

score 1 · Answer 1 · answered Nov 29 '21 at 14:41

1

converted to german number notation

This is task for locale built-in module, you can use it following way:

import locale
import pandas as pd
locale.setlocale(locale.LC_NUMERIC, 'de_DE')
pd.options.display.float_format = lambda x:locale.format_string('%.2f',x,True)
df = pd.DataFrame({'x':[5663499e-2]})
print(df)

output

          x
0 56.634,99

Explanation: use german (de_DE) numeric convention, '%.2f' is 2 digits after ,, x is value itself, True is use thousands sep. For futher discussion see locale.format_string in docs.

answered Nov 29 '21 at 14:41

Daweo

21,690
3
9
19

I tried your code but without `df = pd.DataFrame({'x':[5663499e-2]})`it doesn't effect my dataframes. – stanvooz Nov 30 '21 at 09:44
@stanvooz are your dataframes holding `float`s or just `str`s with some representation of float? – Daweo Nov 30 '21 at 10:27
they are holding floats – stanvooz Dec 02 '21 at 08:26
@Stanvooz this is surprising for me, what version of `pandas` are you using? – Daweo Dec 02 '21 at 08:40
I have version 1.1.3 installed – stanvooz Dec 02 '21 at 09:16
@stanvooz what happens if you run my code exactly as-is? – Daweo Dec 02 '21 at 09:35
It prints: `56634,99` – stanvooz Dec 02 '21 at 14:02
@stanvooz then I do not know what might be reason for your `pandas.DataFrame` not working as intended – Daweo Dec 02 '21 at 14:24

How to get float numbers formatted with dot and comma

1 Answers1