Pandas Styler format justify prefix left value right (e.g. $ accounting format)

TylerT — Sun, 19 Nov 2023 15:35:46 GMT

Hello,

I am using the Pandas Styler style.format() method to deal with a currency column. Sample code and format is :

import pandas as pd df = pd.DataFrame({'quantity':[2, 45, 322], 'unit_cost': [1005.00, 1.92, 0.50]}) df['cost'] = df['quantity'].multiply(df['unit_cost']) formats = ( { 'quantity': "{:,.0f}".format, 'unit_cost': "$ {:,.2f}".format, 'cost': "$ {:,.2f}".format, } ) dfs = df.style.format(formats)

And the resulting styled dataframe is:

However, I'm looking for more of an accounting look where the $ (dollar sign) is justified and aligned left such as this:

Any suggestions on how to write the format to achieve this would be appreciated. Thank you.

Tyler

Re: Pandas Styler format justify prefix left value right (e.g. $ accounting format)

DanPatterson — Sun, 19 Nov 2023 17:47:22 GMT

python - Accounting formatting in Pandas df - Stack Overflow should do it

topic Pandas Styler format justify prefix left value right (e.g. $ accounting format) in Python Questions

Pandas Styler format justify prefix left value right (e.g. $ accounting format)

Re: Pandas Styler format justify prefix left value right (e.g. $ accounting format)