Sparsify MultiIndex in Styler

[reedjosh]

Merge Duplicate Cells for Easier Reading as a Styler Option

At work we generate reports in Bi4 and via Python. In the Python reports we write, we use the new Styler object to generate conditionally formatted HTML.

The generated HTML would be much more readable if there was a way to conditionally merge cells as in the Bi4 report shown above. I really hate Bi4, but the reports do look nicer.

If this already exists, I apologize, and please kindly point me to the documentation. If not, then thank you for considering this enhancement request.

Best,

- Joshua

[TomAugspurger]

Hmm, I think this is done actually? #13775

Can you set the levels you want sparsified into a MultiIndex and render that?

[TomAugspurger]

Let us know if that isn't what you had in mind.

[reedjosh]

Hey, it is basically what I have in mind, but it appears to be not usable with a Styler object.

Am I doing something wrong? Is this something that's not implemented?

Thanks Again!

[TomAugspurger]

Correct, it’s not implemented for non unique indexes

…

________________________________ From: Joshua Reed <[email protected]> Sent: Thursday, May 24, 2018 6:26:46 PM To: pandas-dev/pandas Cc: Tom Augspurger; State change Subject: Re: [pandas-dev/pandas] Sparsify MultiIndex in Styler (#21155) Hey, it is basically what I have in mind, but it appears to be not usable with a Styler object. [image]<https://user-images.githubusercontent.com/9508385/40518315-cd13b0fc-5f6e-11e8-940f-eba48cc43267.png> [image]<https://user-images.githubusercontent.com/9508385/40518380-3199408c-5f6f-11e8-9fe9-08dea2303da7.png> Am I doing something wrong? Is this something that's not implemented? Thanks Again! — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub<#21155 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ABQHIgTdoDGYx-XULgzuj_ZBDrWa4gUkks5t10G2gaJpZM4UHYIm>.