pd set output to currency
#make large numbers more readable by adding commas
pd.options.display.float_format = '{:,}'.format
# Example
123456789.12345 -> 123,456,789.12345
#this adds commas and limits decimals to 2 places
pd.options.display.float_format = '{:,.2f}'.format
# Example
123456789.12345 -> 123,456,789.12
#this adds the dollar sign to the front
pd.options.display.float_format = '${:,.2f}'.format
# Example
123456789.12345 -> $123,456,789.12pandas currency to numbe
df[df.columns[1:]] = df[df.columns[1:]].replace('[$,]', '', regex=True).astype(float)pandas make currency with commas
'${:,.2f}'.formatCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
