How to plot frequency table with total row and column as heatmap?

[nimrod]

Hi,
I’m trying to plot pandas crosstab dataframe as heatmp without success. I want to keep the margins of the table (total row and column) but to exclude them from the color scale of the heatmap (fill them with predefined color, gray for example).
Can I achieve this behavior with heatmap?

Thanks

[AIMPED]

Hi @nimrod welcome to the community.

Could you add some more information? What do you mean by margins? Maybe this gives you some ideas:

Colors for discrete ranges in heatmaps

Hi @jayeetamukherjee, Your case needs the min&max of the subset of negative, respectively positive values: import plotly.graph_objects as go import numpy as np def three_colorscale(z, colors): if len(colors) !=3: raise ValueError("") neg=z[np.where(z<0)] pos=z[np.where(z>0)] a, c = neg.min(), neg.max() d, b = pos.min(), pos.max() bvals= [a, c/2, d/2, b] nvals = [(v-bvals[0])/(bvals[-1]-bvals[0]) for v in bvals] dcolorscale = [] for k in range…