Filter löschen
Filter löschen

How can I create a heatmap?

21 Ansichten (letzte 30 Tage)
Sanley Guerrier
Sanley Guerrier am 28 Jul. 2023
Kommentiert: Sanley Guerrier am 31 Jul. 2023
Can someone help with to create a heatmap for this data?
I tried with these commands but it didn't work. Thank you!
xvar = T.Xft;
yvar = T.Yft;
Temp = T(:,4:end);
gridres = 100 ;
xs = linspace(min(xvar),max(xvar),gridres) ;
ys = linspace(min(yvar),max(yvar),gridres) ;
[xq,yq]=meshgrid(xs,ys) ;
InterpolatedTemp = griddata(xvar,yvar,Temp,xq,yq) ;
hmap_above = pcolor(xq,yq,InterpolatedTemp);
hmap_above.EdgeColor = [.5 .5 .5] ;
colorbar
colormap jet
title('heatmap')
shading interp
  5 Kommentare
Jon
Jon am 28 Jul. 2023
Please provide a description of the data in T.xlsx, and what you really want plotted in your "heat map".
Looking at the data, I see that your data X (ft), and Y (ft), do not provide a grid, or even a scattered sampling of the x,y plane. Instead the x and y points all fall along a line. There are multiple columns of T data. If so, the heat map could only plot the data for one of those columns.
At the moment even if you just chose one of those columns, you still couldn't provide a map of temperatures across the x-y plane as you only have data for points along one line in this plane.
Sanley Guerrier
Sanley Guerrier am 28 Jul. 2023
Each point (X, Y) coordinate has a series of thermal values from T0 to T6. T0 to T6 are measured a long a straight line which is the width of a road and the column "distance" is the length of the road.
I would like to visualize the data to see the change in temperature a long the road.
Thank you!

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Cris LaPierre
Cris LaPierre am 28 Jul. 2023
Bearbeitet: Cris LaPierre am 28 Jul. 2023
Do you need to preserve the shape of the road in your heatmap? If not, the easiest approach is to just create a heatmap using the T0-T6 columns.
T = readtable("T.xlsx","VariableNamingRule","preserve");
heatmap(T{:,["T" + (0:6)]})
Another way to do this might be the following
newT = stack(T,["T" + (0:6)],"NewDataVariableName","Value");
heatmap(newT,"Value_Indicator","Distance from CR29 (ft)","ColorVariable","Value")
  9 Kommentare
Cris LaPierre
Cris LaPierre am 31 Jul. 2023
The problem is that you have a 4D data set (X,Y,T,v), or 29x29x7x1. For each (x,y) pair, you have 7 values. A surface plot expects one value per point.
If the heatmap approach worked for you, then I'd do something similar using surf.
T = readtable("T.xlsx","VariableNamingRule","preserve");
surf(categorical(["T"+(0:6)]),T.("Distance from CR29 (ft)"),T{:,["T"+(0:6)]})
colorbar
When you have more than 3 dimensions, you need to get creative, using marker style, color, size, linestyle, etc to convey the higher dimensions.
newT = stack(T,["T" + (0:6)],"NewDataVariableName","Value");
grps = unique(newT.Value_Indicator);
for g = 1:length(grps)
ind = ismember(newT.Value_Indicator,grps(g));
scatter3(newT{ind,"X (ft)"},newT{ind,"Y (ft)"},newT.Value(ind),'filled')
hold on
end
hold off
legend(grps)
Sanley Guerrier
Sanley Guerrier am 31 Jul. 2023
Appriciate it Cris!
I think I got now. Thanks for the precision.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Data Distribution Plots finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by