how to make a heatmap for a monthly time serie?
9 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a monthly time series from jan1971 to dec 1986.
I want to make a heatmap to show the value of each month in each region.
whaen I use the heatmap structure, I should write the name of x-values. but they are192 and I can not write all of them.
xvalues = {'Jan-1971', Feb1971',..., 'Dec 1986'};
yvalues = {'A','B','C','D''};
h = heatmap(xvalues1,yvalues1,cdata1);
could you please let me know the best way to show the xvalues?
could you make the heatmap with the attached data?
0 Kommentare
Akzeptierte Antwort
Kostas
am 3 Dez. 2019
Based on the heatmap documentation
tbl = readtable('heatmap.test.xlsx');
months = categorical(tbl.Var2);
years = categorical(tbl.Var1);
xlabels = categories(months);
ylabels = categories(years);
nummonths = numel(xlabels);
numyears = numel(ylabels);
x = double(months);
y = double(years);
A = tbl.A;
cdata = accumarray([y,x],A,[numyears,nummonths],@mean,NaN);
h = heatmap(xlabels,ylabels,cdata);
6 Kommentare
Kostas
am 3 Dez. 2019
Unfortunately i do not know how/if this can be done in heatmap. One solution could be to save the image in vector format and then change the labels you want using an image proseccing software.
Something else you could do so as to seem nicer, it would be to make a heatmap for each month seperately.
For example to get just for January you could change the "xDisplayData" as follow
xDisplay = h.xDisplayData;
Jan = xDisplayData(1:12:end);
h.xDisplayData = Jan;
And you can do the same for the rest of the months
% February
Feb = xDisplayData(2:12:end);
h.xDisplayData = Feb;
Weitere Antworten (1)
Sean de Wolski
am 3 Dez. 2019
Convert your x values to datetime. Then heatmap will just work:
dt = datetime('now'):hours(1):datetime('tomorrow');
v = rand(10,numel(dt));
heatmap(dt, 1:size(v,1), v)
5 Kommentare
Siehe auch
Kategorien
Mehr zu Data Distribution Plots finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!