Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I print a float with thousands separators?

How can I format a decimal number so that 32757121.33 will display as 32.757.121,33?

like image 403
yital9 Avatar asked Oct 26 '12 07:10

yital9


2 Answers

If you can't or don't want to use locale for some reason, you can also do it with a regular expression:

import re
def sep(s, thou=",", dec="."):
    integer, decimal = s.split(".")
    integer = re.sub(r"\B(?=(?:\d{3})+$)", thou, integer)
    return integer + dec + decimal

sep() takes the string representation of a standard Python float and returns it with custom thousands and decimal separators.

>>> s = "%.2f" % 32757121.33
>>> sep(s)
'32,757,121.33'
>>> sep(s, thou=".", dec=",")
'32.757.121,33'

Explanation:

\B      # Assert that we're not at the start of the number
(?=     # Match at a position where it's possible to match...
 (?:    #  the following regex:
  \d{3} #   3 digits
 )+     #  repeated at least once
 $      #  until the end of the string
)       # (thereby ensuring a number of digits divisible by 3
like image 146
Tim Pietzcker Avatar answered Nov 07 '22 00:11

Tim Pietzcker


I have found another solution:

'{:,.2f}'.format(num).replace(".","%").replace(",",".").replace("%",",")
like image 32
yital9 Avatar answered Nov 06 '22 23:11

yital9