Use timetable as x axis in heatmap

10 visualizaciones (últimos 30 días)
Amir Hosein Shokouhy
Amir Hosein Shokouhy el 10 de Mzo. de 2022
Respondida: Benjamin Kraus el 12 de Mzo. de 2022
Hello,
I have this time table (t_avg) and I want to use it as the x axis for a heatmap of my load data (load_avg).
I am currently using this code but the x axis is not the correct time:
figure (4)
h=heatmap(load_avg');
XLabels = 1:size(load_avg,1);
CustomXLabels = string(XLabels);
CustomXLabels(mod(XLabels,10) ~= 0) = " ";
h.XDisplayLabels = CustomXLabels;
caxis([0 max(max(load_avg))])
colormap jet
xlabel('Time');
ylabel('Unit');
I tried using this code but it didn't work:
heatmap(t_avg,'XVariable','Time',load_avg');
I'd appreciate it if any one can help.
Thanks,
Amir

Respuesta aceptada

Peter Perkins
Peter Perkins el 11 de Mzo. de 2022
Amir, according to your screenshots, you do NOT have a timetable. You have a table containg one datetime variable, and a separate double matrix. You need to make a timetable. One possibility might be
tt = timetable(t_avg.Time,load_avg)
another might be
tt = array2table(load_avg,'RowTimes',t_avg.Time)
but I have no idea what you are doing, so I can't really say how to make the timetable.
  4 comentarios
Amir Hosein Shokouhy
Amir Hosein Shokouhy el 11 de Mzo. de 2022
Thanks Peter, it's working now. Just one thing, how can I only display the hour and minute and not the second?
Peter Perkins
Peter Perkins el 11 de Mzo. de 2022
help datetime/string

Iniciar sesión para comentar.

Más respuestas (1)

Benjamin Kraus
Benjamin Kraus el 12 de Mzo. de 2022
In this case, you may be better off with something like imagesc or surf instead of heatmap. heatmap is designed for cases in which your x and y dimensions are categorical in nature. In your case, your x-axis is time, which is continuous (even if your data has been discretized). This will let you work with the datetime data more natively, rather than resorting to manually generating your tick labels.
I recommend something like this:
y = 1:size(load_avg,2);
surf(t_avg.Time, y, load_avg');
view(2)
axis tight
caxis([0 max(max(load_avg))])
colorbar
colormap turbo % turbo is more percetually uniform than jet, but otherwise very similar
xlabel('Time');
ylabel('Unit');
xtickformat('hh:mm')

Categorías

Más información sobre Data Distribution Plots en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by