CODEWITHSUNDEEP
pythonfloating-pointformatf-string
seaver
seaver

Reputation: 381

How to format a float with a comma as decimal separator in an f-string?

For some machine control in python, I write the results to a text-file, that someone else can copy into Excel (this is the most convenient way in this situation). However, in the Netherlands, Excel has a comma as decimal separator and thus I want to have the result "position" in the text-file as 123,456, but when I use the f-string method like this:

    resultfile.write(f"Position\t{position:.5}")

This will obviously result in a dot decimal separator.

How can I change this to a comma without iterating through the whole file int the end and replace the dots with commas?

Upvotes: 21

Views: 50477

Answers (6)

Nuno G
Nuno G

Reputation: 1

How about this:


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

def fmt(a, dec=2):
    x = int(a)
    return f".{len(str(x))+dec}n"

def main():
    # usage example
    a = 110.12345
    print(f'{a:{fmt(a)}}')
    print(f'{a:{fmt(a,3)}}')

    # here it is
    print(f"{fmt(a) = }")

if __name__ == '__main__':
    main()

gets you this:

110,12
110,123
fmt(a) = '.5n'

Process finished with exit code 0

Upvotes: 0

mmj
mmj

Reputation: 5780

If you prefer to avoid dependencies, the following simple function might fit your needs:

def comma_num(n,f=''):
    return ('{'+f+'}').format(n).replace('.',',')

n = 1.23

f'Whatever {comma_num(n)}'
'Whatever {}'.format(comma_num(n))
>>>'Whatever 1,23'

f'Whatever {comma_num(n,":6.4f")}'
'Whatever {}'.format(comma_num(n,':6.4f'))
>>>'Whatever 1,2300'

Upvotes: 3

Baumann
Baumann

Reputation: 1159

As @michel-de-ruiter mentioned, the f format does not work with locale. On the other hand, you can't set the precision using n format. For example, if you want 4 digits after decimal separator:

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

position = 123.45678999
print(f'{position:.4n}')  # output: 123,4 (not quite what we wanted!)

However, you can round the number with the desired precision before formatting it:

print(f'{round(position, 4):n}')  # output: 123,4567 (that's it!)

Upvotes: 4

Michel de Ruiter
Michel de Ruiter

Reputation: 7954

If the g format is good enough for you, use n instead:

resultfile.write(f"Position\t{position:.7n}")

While n works (uses the current locale setting when used) instead of both d and g, there is no such thing for the f format unfortunately...

Upvotes: 2

kadee
kadee

Reputation: 8854

If you want to format floats with a comma within the f-string, you can either use replace after casting the float to a string:

position = 123.456
f"Position\t{str(position).replace('.',',')}"

A second option is to use the Python standard library module locale (but it is not thread-safe):

import locale
locale.setlocale(locale.LC_ALL, 'nl_NL')
f"Position\t{locale.format('%.3f', position)}"

A third option is to use the library babel (preferred in case of library routines):

from babel.numbers import format_decimal
f"Position\t{format_decimal(position, locale='nl_NL')}"

All three options return the same result for the given example:

'Position\t123,456'

Upvotes: 15

user11616715
user11616715

Reputation: 43

A simpler solution might be: 

f"Position\t{position:,.5f}"

Upvotes: -3

Related Questions