Python string with currency formatted

Question

I am attempting to retrieve a dollar amount from my database, concatenate it with other information and have it print with 2 decimal points. I have tried so many different configurations I have lost tract but continue to get only one decimal point (or an error). Can someone please show me where I am losing it.

 #get payments on the permits
 for i in range(len(IDS)):  
     paydate = date.today() - timedelta(30)
     query = '''select `AmountPaid_credit`, `PayComment`, `DateReceived`, `WPTSinvoiceNo`
                 from Payments 
                 where `NPDES_ID` = ? and `DateReceived` >= ?'''
     PayStrings.append("\tNo Payment Recieved")
     for row in cur.execute(query, (IDS[i],paydate)):
         WPTSInv.append(row[3])
         d= row[2].strftime('%m/%d/%Y')
         #create a payment string 
         PayStrings[i]="\t$"+str(row[0])+" - "+d+" - "+row[1]

returns this

$2000.0 - 02/09/2017 - 2017 APPLICATION FEE

but I need this

$2000.00 - 02/09/2017 - 2017 APPLICATION FEE

Possible duplicate of Currency formatting in Python

bejado
– bejado

2017-02-15 21:08:54 +00:00
Commented Feb 15, 2017 at 21:08 — bejado
– bejado, Commented Feb 15, 2017 at 21:08

Nick Chapman · Accepted Answer · 2017-07-06 10:22:34Z

2

As an alternative to Haifeng's answer, you could do the following

from decimal import Decimal

str(round(Decimal(row[0]), 2))

Edit: I would also like to add that there is a locale module and that it is probably a better solution, even if it is a little bit more work. You can see how to use it at this question here: Currency formatting in Python

edited Jul 6, 2017 at 10:22

answered Feb 15, 2017 at 21:10

Nick Chapman

4,6542 gold badges30 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Haifeng Zhang · Accepted Answer · 2017-02-15 21:09:33Z

2

In your case, you just converting decimal places:

   >>> value = "2000.0"
   >>> "{:.2f}".format(float(value))
   '2000.00'

answered Feb 15, 2017 at 21:09

Haifeng Zhang

32.1k22 gold badges95 silver badges133 bronze badges

Collectives™ on Stack Overflow

Python string with currency formatted

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related