Format a number as currency! I can't find any help on this simpleproblem.

[Richard Kessler]

I am relatively new to Python. Love it, but I find things that I can do
easily in .NET and cannot find a way to do in Python. I need to format a
number as currency, for example 12343.56 to $12,343.56.

In C# all I need to do is decimal x = 12343.56 then x.ToString("$###,###.00");

I cannot find a way to do this in Python. I must be missing something very
simple here. I have tried the locale module but it will not put in the commas.
I hope I do not have to write my own formatting routine...surely one is out
there and I just can't find it.

Running on XP Pro. Python 2.4.3.

Thanks much in advance,

Richard

[Bernard]

>>import locale

>>locale.setlocale(locale.LC_ALL, 'English_United States.1252')

'English_United States.1252'

>>conv = locale.localeconv()
x = 1234567.8
locale.format("%d", x, grouping=True)

'1,234,567'

>>locale.format("%s%.*f", (conv['currency_symbol'], conv['int_frac_digits'], x), grouping=True)

'$1,234,567.80'

Hi Richards,

This works for me. I agree it's a bit complicated compared to C# but it
works. I'd put it in a function if I had to use it.
Richard Kessler wrote:

I am relatively new to Python. Love it, but I find things that I can do
easily in .NET and cannot find a way to do in Python. I need to format a
number as currency, for example 12343.56 to $12,343.56.

In C# all I need to do is decimal x = 12343.56 then x.ToString("$###,###.00");

I cannot find a way to do this in Python. I must be missing something very
simple here. I have tried the locale module but it will not put in the commas.
I hope I do not have to write my own formatting routine...surely one is out
there and I just can't find it.

Running on XP Pro. Python 2.4.3.

Thanks much in advance,

Richard

[jr]

Hi, Bernard.
Just tried the first 2 commands on win XP, Python 2.5 under Idle.
An Error is raised: "unsupported locale setting" (lib/locale.py in
setlocale, line 476).
Actually I get the error also under Python 2.4.3
Any idea what I'm missing?
Thanks in advance.
Jürgen
Bernard wrote:

>import locale
locale.setlocale(locale.LC_ALL, 'English_United States.1252')

'English_United States.1252'

>conv = locale.localeconv()
x = 1234567.8
locale.format("%d", x, grouping=True)

'1,234,567'

>locale.format("%s%.*f", (conv['currency_symbol'], conv['int_frac_digits'], x), grouping=True)

'$1,234,567.80'

Hi Richards,

This works for me. I agree it's a bit complicated compared to C# but it
works. I'd put it in a function if I had to use it.
Richard Kessler wrote:

I am relatively new to Python. Love it, but I find things that I can do
easily in .NET and cannot find a way to do in Python. I need to format a
number as currency, for example 12343.56 to $12,343.56.

In C# all I need to do is decimal x = 12343.56 then x.ToString("$###,###.00");

I cannot find a way to do this in Python. I must be missing something very
simple here. I have tried the locale module but it will not put in the commas.
I hope I do not have to write my own formatting routine...surely one isout
there and I just can't find it.

Running on XP Pro. Python 2.4.3.

Thanks much in advance,

Richard

[Jerry]

Replace the conv function call with locale.localeconv.

--
Jerry

[Peter Otten]

jr wrote:

>>import locale
locale.setlocale(locale.LC_ALL, 'English_United States.1252')

'English_United States.1252'

Just tried the first 2 commands on win XP, Python 2.5 under Idle.
An Error is raised: "unsupported locale setting" (lib/locale.py in
setlocale, line 476).
Actually I get the error also under Python 2.4.3
Any idea what I'm missing?

Let your machine decide

>>locale.setlocale(locale.LC_ALL, "")

'de_DE.UTF-8'

or try something less specific:

>>locale.setlocale(locale.LC_ALL, "en_US")

'en_US'

Peter