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)