Heatmaps break locked columns

[ms32035]

In my dataframe of several columns I have 5 locked columns (3 text, and 2 numeric). When I switch to highlight to heatmap (by columns or overall) the locked text columns are hidden, and as a result I see 5 numeric columns as locked columns. I guess the correct way would be to not hide locked columns in the heatmap view

[aschonfeld]

So the reason for certain columns being hidden is that they can't correctly be used in the heatmap calculation. IF you want to display everything (anything that can't be calculation correctly just gets displayed in gray background) you can click this option:

I can certainly look into the scenario where you haven't clicked that option and you have columns locked that can't be included in the heatmap calculation. It appears that those column disappear and then it hides the next unlocked columns it's place.

[ms32035]

Thanks, the latter is exactly the scenario I am describing

[aschonfeld]

@ms32035 just release v3.5.0 to pypi (will be on conda-forge shortly), which includes this fix. Let me know if you have any issues

[ms32035]

The behaviour changed in that now only the numeric columns remain locked, so the number of locked columns goes down from 5 to 2. Not sure if that's a desired/correct behavior, but I guess that's up to you to decided. Either way, thanks for looking at it so quickly 🚀

[aschonfeld]

I don't really know of any other option for behavior. If you select the "Show All Heatmap Columns" option then all 5 locked columns will remain. So in this instance it was the "desired" behavior.