topic Re: Pandas Styler in Python Questions

Pandas Styler

TylerT — Wed, 17 Aug 2022 16:21:20 GMT

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')

Re: Pandas Styler

dslamb2022 — Wed, 17 Aug 2022 16:58:13 GMT

I think you are missing the format function.

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

Re: Pandas Styler

TylerT — Wed, 17 Aug 2022 17:14:15 GMT

Thank you!

Re: Pandas Styler

TylerT — Wed, 17 Aug 2022 19:00:12 GMT

@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