Heatmap plot using the XYZ values

22 次查看（过去 30 天）

Rahul Gulia 2022-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1809475-heatmap-plot-using-the-xyz-values

评论： Rahul Gulia 2022-9-26

I have a Dataset of size 575718x3.

First column contains the x-location, second column contains the y-location, and the 3rd column contains the signal strength that a given x,y-location.

I tried using the heatmap() function and the satter function. But they give me an error for duplicate values.

My dataset is huge, and it looks something like this,

x y SINR

1 1.0 23

1 1.1 25

1 1.2 27

2 2.0 25

2 2.1 29

2 2.2 30

i.e., each x-location has a huge granularity on its simultaneous y=position.

Kindly suggest if I can generate a heatmap from this matrix.

My Solution: I have transformed this matrix to size 4758 x 121, with each point showing the SINR strength. i.e., 4758*121=575718.

And the imagesc() function ca give me the required heatmap, that looks like this. But this is a complex process.

I would really appreciate it if someone can guide me to get this kind of heatmap from the XYZ value matrix described above.

7 个评论
显示 5更早的评论隐藏 5更早的评论

J. Alex Lee 2022-9-24

在 MATLAB Online 中打开

I hadn't heard of "heatmap" function before, but it doesn't seem that it does what you both are seeming to describe you want...heatmap is more like histogram...

So I think Rahul, what you did may be exactly the right thing...the fact that you report it being a complex process makes me wonder if it is as simple as not being aware of the "reshape" function? E.g., if your data is in the table format as Adam models

x = 1:5

x = 1×5

1 2 3 4 5

y = 1:0.1:1.2

y = 1×3

1.0000 1.1000 1.2000

XYZ = [repelem(x,1,numel(y))', ...

repmat(y,1,numel(x))', ...

randi(10,numel(x)*numel(y),1)+10];

tbl = array2table(XYZ,'VariableNames',{'X','Y','SINR'})

tbl = 15×3 table

X Y SINR _ ___ ____ 1 1 11 1 1.1 19 1 1.2 16 2 1 19 2 1.1 16 2 1.2 17 3 1 17 3 1.1 20 3 1.2 15 4 1 16 4 1.1 19 4 1.2 19 5 1 17 5 1.1 11 5 1.2 16

Z = reshape(tbl.SINR,3,5)

Z = 3×5

11 19 17 16 17 19 16 20 19 11 16 17 15 19 16

imagesc(x,y,Z)

J. Alex Lee 2022-9-26

在 MATLAB Online 中打开

Oh I see...it's more of the "CData" syntax...well just to be clear, in the above examples

heatmap(tbl,"X","Y")

means something different then and will do something different, so we may need clarification on what Rahul actualyl did before understanding the issue.

Rahul Gulia 2022-9-26