Currency formatting in Python

Question

I am looking to format a number like 188518982 18 to   188 518 982 18 using Python   How can I do this

User · Answer

Simple python code   def format us currency value       value str value      if value count       0          b n v    1 value         value value  value rfind               for i in value   -1               b     i b if n  3 else i b             n 1 if n  3 else n 1         b b 1   if b 0       else b         value b v v rfind            return      value rstrip  0   rstrip      if     in value else value

User · Answer

Oh  that s an interesting beast   I ve spent considerable time of getting that right  there are three main issues that differs from locale to locale   - currency symbol and direction  - thousand separator  - decimal point  I ve written my own rather extensive implementation of this which is part of the kiwi python framework  check out the LGPL ed source here   http   svn async com br cgi-bin viewvc cgi kiwi trunk kiwi currency py view markup  The code is slightly Linux Glibc specific  but shouldn t be too difficult to adopt to windows or other unixes   Once you have that installed you can do the following    gt  gt  gt  from kiwi datatypes import currency  gt  gt  gt  v   currency  10 5   format     Which will then give you     10 50    or   10 50 kr    Depending on the currently selected locale   The main point this post has over the other is that it will work with older versions of python  locale currency was introduced in python 2 5

User · Answer

See the locale module   This does currency  and date  formatting    gt  gt  gt  import locale  gt  gt  gt  locale setlocale  locale LC ALL        English United States 1252   gt  gt  gt  locale currency  188518982 18     188518982 18   gt  gt  gt  locale currency  188518982 18  grouping True     188 518 982 18

User · Answer

Inspired by the code above  D def money format value       value   str value  split          money          count   1      for digit in value 0    -1           if count    3              money    digit             count    1         else              money    f  digit                count   1      if len value     1          money          money   -1   replace   -   -        else          money          money   -1          value 1   replace   -   -         return money

User · Answer

Not quite sure why it s not mentioned more online  or on this thread   but the Babel package  and Django utilities  from the Edgewall guys is awesome for currency formatting  and lots of other i18n tasks    It s nice because it doesn t suffer from the need to do everything globally like the core Python locale module   The example the OP gave would simply be    gt  gt  gt  import babel numbers  gt  gt  gt  import decimal  gt  gt  gt  babel numbers format currency  decimal Decimal   188518982 18      GBP      188 518 982 18

User · Answer

A lambda for calculating it inside a function  with help from  Nate s answer  converter   lambda amount  currency    s s s          -  if amount  lt  0 else          currency            d  2f    len str amount   3   format abs amount   lstrip      and then    gt  gt  gt  converter 123132132 13         123 132 132 13    gt  gt  gt  converter -123132132 13        - 123 132 132 13

User · Answer

Oh  that s an interesting beast   I ve spent considerable time of getting that right  there are three main issues that differs from locale to locale   - currency symbol and direction  - thousand separator  - decimal point  I ve written my own rather extensive implementation of this which is part of the kiwi python framework  check out the LGPL ed source here   http   svn async com br cgi-bin viewvc cgi kiwi trunk kiwi currency py view markup  The code is slightly Linux Glibc specific  but shouldn t be too difficult to adopt to windows or other unixes   Once you have that installed you can do the following    gt  gt  gt  from kiwi datatypes import currency  gt  gt  gt  v   currency  10 5   format     Which will then give you     10 50    or   10 50 kr    Depending on the currently selected locale   The main point this post has over the other is that it will work with older versions of python  locale currency was introduced in python 2 5

User · Answer

This is an ancient post  but I just implemented the following solution which    Doesn t require external modules Doesn t require creating a new function Can be done in-line  Handles multiple variables Handles negative dollar amounts   Code   num1   4153 53 num2   -23159 398598  print  This     0  0f  and this     0  2f   format num1  num2  replace   -   -      Output   This   4 154 and this  - 23 159 40   And for the original poster  obviously  just switch   for

User · Answer

New in 2 7   gt  gt  gt     20  2f   format 18446744073709551616 0   18 446 744 073 709 551 616 00    http   docs python org dev whatsnew 2 7 html pep-0378

User · Answer

See the locale module   This does currency  and date  formatting    gt  gt  gt  import locale  gt  gt  gt  locale setlocale  locale LC ALL        English United States 1252   gt  gt  gt  locale currency  188518982 18     188518982 18   gt  gt  gt  locale currency  188518982 18  grouping True     188 518 982 18

User · Answer

I ve come to look at the same thing and found python-money not really used it yet but maybe a mix of the two would be good

User · Answer

Inspired by the code above  D def money format value       value   str value  split          money          count   1      for digit in value 0    -1           if count    3              money    digit             count    1         else              money    f  digit                count   1      if len value     1          money          money   -1   replace   -   -        else          money          money   -1          value 1   replace   -   -         return money

User · Answer

Oh  that s an interesting beast   I ve spent considerable time of getting that right  there are three main issues that differs from locale to locale   - currency symbol and direction  - thousand separator  - decimal point  I ve written my own rather extensive implementation of this which is part of the kiwi python framework  check out the LGPL ed source here   http   svn async com br cgi-bin viewvc cgi kiwi trunk kiwi currency py view markup  The code is slightly Linux Glibc specific  but shouldn t be too difficult to adopt to windows or other unixes   Once you have that installed you can do the following    gt  gt  gt  from kiwi datatypes import currency  gt  gt  gt  v   currency  10 5   format     Which will then give you     10 50    or   10 50 kr    Depending on the currently selected locale   The main point this post has over the other is that it will work with older versions of python  locale currency was introduced in python 2 5

User · Answer

See the locale module   This does currency  and date  formatting    gt  gt  gt  import locale  gt  gt  gt  locale setlocale  locale LC ALL        English United States 1252   gt  gt  gt  locale currency  188518982 18     188518982 18   gt  gt  gt  locale currency  188518982 18  grouping True     188 518 982 18

User · Answer

If you are using OSX and have yet to set your locale module setting this first answer will not work you will receive the following error   Traceback  most recent call last  File   lt stdin gt    line 1  in  lt module gt  File   System Library Frameworks Python framework Versions 2 6 lib python2 6 locale py   line 221  in currency raise ValueError  Currency formatting is not possible using  ValueError  Currency formatting is not possible using the  C  locale    To remedy this you will have to do use the following   locale setlocale locale LC ALL   en US

User · Answer

Simple python code   def format us currency value       value str value      if value count       0          b n v    1 value         value value  value rfind               for i in value   -1               b     i b if n  3 else i b             n 1 if n  3 else n 1         b b 1   if b 0       else b         value b v v rfind            return      value rstrip  0   rstrip      if     in value else value

User · Answer

0  2f   format float your numeric value   in Python 3 does the job  it gives out something like one of the following lines   10 938 29 10 899 00 10 898 99 2 328 99

User · Answer

Not quite sure why it s not mentioned more online  or on this thread   but the Babel package  and Django utilities  from the Edgewall guys is awesome for currency formatting  and lots of other i18n tasks    It s nice because it doesn t suffer from the need to do everything globally like the core Python locale module   The example the OP gave would simply be    gt  gt  gt  import babel numbers  gt  gt  gt  import decimal  gt  gt  gt  babel numbers format currency  decimal Decimal   188518982 18      GBP      188 518 982 18

User · Answer

My locale settings seemed incomplete  so I had too look beyond this SO answer and found    http   docs python org library decimal html recipes  OS-independent  Just wanted to share here

User · Answer

If I were you  I would use BABEL  http   babel pocoo org en latest index html  from babel numbers import format decimal   format decimal 188518982 18  locale  en US

User · Answer

This is an ancient post  but I just implemented the following solution which    Doesn t require external modules Doesn t require creating a new function Can be done in-line  Handles multiple variables Handles negative dollar amounts   Code   num1   4153 53 num2   -23159 398598  print  This     0  0f  and this     0  2f   format num1  num2  replace   -   -      Output   This   4 154 and this  - 23 159 40   And for the original poster  obviously  just switch   for

User · Answer

If you are using OSX and have yet to set your locale module setting this first answer will not work you will receive the following error   Traceback  most recent call last  File   lt stdin gt    line 1  in  lt module gt  File   System Library Frameworks Python framework Versions 2 6 lib python2 6 locale py   line 221  in currency raise ValueError  Currency formatting is not possible using  ValueError  Currency formatting is not possible using the  C  locale    To remedy this you will have to do use the following   locale setlocale locale LC ALL   en US

User · Answer

0  2f   format float your numeric value   in Python 3 does the job  it gives out something like one of the following lines   10 938 29 10 899 00 10 898 99 2 328 99

User · Answer

See the locale module   This does currency  and date  formatting    gt  gt  gt  import locale  gt  gt  gt  locale setlocale  locale LC ALL        English United States 1252   gt  gt  gt  locale currency  188518982 18     188518982 18   gt  gt  gt  locale currency  188518982 18  grouping True     188 518 982 18

User · Answer

printing  the variable  Total   in a format that looks like this  9 348 237   print   Total         7  3f   format zum1     where the    7  3f   es the number of spaces for formatting the number in this case is a million with 3 decimal points  Then you add the   format zum1    The zum1 is tha variable that has the big number for the sum of all number in my particular program   Variable can be anything that you decide to use

User · Answer

I ve come to look at the same thing and found python-money not really used it yet but maybe a mix of the two would be good

User · Answer

New in 2 7   gt  gt  gt     20  2f   format 18446744073709551616 0   18 446 744 073 709 551 616 00    http   docs python org dev whatsnew 2 7 html pep-0378

User · Answer

Oh  that s an interesting beast   I ve spent considerable time of getting that right  there are three main issues that differs from locale to locale   - currency symbol and direction  - thousand separator  - decimal point  I ve written my own rather extensive implementation of this which is part of the kiwi python framework  check out the LGPL ed source here   http   svn async com br cgi-bin viewvc cgi kiwi trunk kiwi currency py view markup  The code is slightly Linux Glibc specific  but shouldn t be too difficult to adopt to windows or other unixes   Once you have that installed you can do the following    gt  gt  gt  from kiwi datatypes import currency  gt  gt  gt  v   currency  10 5   format     Which will then give you     10 50    or   10 50 kr    Depending on the currently selected locale   The main point this post has over the other is that it will work with older versions of python  locale currency was introduced in python 2 5

User · Answer

printing  the variable  Total   in a format that looks like this  9 348 237   print   Total         7  3f   format zum1     where the    7  3f   es the number of spaces for formatting the number in this case is a million with 3 decimal points  Then you add the   format zum1    The zum1 is tha variable that has the big number for the sum of all number in my particular program   Variable can be anything that you decide to use

User · Answer

If I were you  I would use BABEL  http   babel pocoo org en latest index html  from babel numbers import format decimal   format decimal 188518982 18  locale  en US

User · Answer

My locale settings seemed incomplete  so I had too look beyond this SO answer and found    http   docs python org library decimal html recipes  OS-independent  Just wanted to share here

User · Answer

A lambda for calculating it inside a function  with help from  Nate s answer  converter   lambda amount  currency    s s s          -  if amount  lt  0 else          currency            d  2f    len str amount   3   format abs amount   lstrip      and then    gt  gt  gt  converter 123132132 13         123 132 132 13    gt  gt  gt  converter -123132132 13        - 123 132 132 13

[python] Currency formatting in Python

Examples related to python

Examples related to formatting

Examples related to currency