Characters H, R, W and L can change with any numbers as well. For example, instead of H = 100, R = 101, W = 102, L = 103.
How to split a matrix?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello everyone,
I have the matrix A as follow:
A = [25,240,15,H;25,255,10,R;25,265,20,H;63,240,10,W;63,250,35,L];
The first column in matrix A is the ID that indicates that which row is belongs to what ID (e.g. the first,second and tird row are belongs to ID = 25 , and, forth and fifth row are belong to ID = 63.)
So, I want matrix B like to follow:
B = [ID 240 245 250 255 260 265 270 275 280
25 H H H R R H H H H
63 W W L L L L L L L];
Each DU is divided by 3 (e.g. 15/3 = 5) and then by each of these 5 is added to the ST (e.g. 240, 245 (=240+5), 250 (=245+5).
Akzeptierte Antwort
Andrei Bobrov
am 19 Feb. 2016
Bearbeitet: Andrei Bobrov
am 21 Feb. 2016
n = xlsread('try1.xlsx',1,'A2:D6');
[a1,~,c1] = unique(n(:,1));
c3 = (n(:,3)-240)/5+1;
c4 = n(:,end)/5;
n2 = n(:,2);
z = accumarray(c1,c4);
b = cumsum(accumarray([c3,c1],1,[z(1),max(c1)]));
out1 = n2(bsxfun(@plus,b,cumsum([0,b(end,1:end-1)])))';
out = [nan,240+(0:z(1)-1)*5;[a1,out1]]
5 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Matrix Indexing 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!