Pandas Styler

[TylerT]

I'm trying to pass conditional string formatting from a function back to style.format as shown here....

Ultimately, I'm looking for the same results as above EXCEPT {:.3f}m should be 3.000m in the output displayed dataframe.  Any ideas?

Thank you,

Tyler

Here's the code for testing:

df = pd.DataFrame([[np.nan, 1.0, 'A'], [2.0, np.nan, 3.0]])
df
func = lambda s: 'STRING' if isinstance(s, str) else '{:.3f}m'
df.style.format({0: '{:.3f}m', 2: func}, na_rep='MISS')

[dslamb2022 · Accepted solution]

I think you are missing the format function. 

'{:.3f}m'.format(s)

[TylerT]

@dslamb2022 et al,

In the same vein, do you have any notion of how to set conditional formatting based on another column?  Let's say we have...

and we want to produce this...

where: if value in col 0 == 'A' then format float as '{:.3f}f' and if col 0 == 'B' then format as '{:.3f}m', using df.style.format() or other formatting/styler methods.

Thank you,

Tyler

[TylerT]

Thank you!