Showing posts with label Python. Show all posts
Showing posts with label Python. Show all posts

Wednesday, June 16, 2021

Currency Format of Numeric Values in Pandas

Firstly, Convert column into float type 

data['Amount'] = data['Amount'].fillna(0).astype('float64') 

Format column as Currency format. eg : 12,345.00

data['Amount'] = data['Amount'].map('{:,.2f}'.format)