How to split a matrix?

Moe
2016 2 18
1 个回答
回答已采纳
更新时间：2016 2 22
6 次查看（30 天）

0 个投票

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).

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Moe
Moe 2016-2-18
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.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2016-2-19
编辑：Andrei Bobrov 2016-2-21

0 个投票

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 个评论
显示 3更早的评论 隐藏 3更早的评论

Moe
Moe 2016-2-19
Thanks Andrei, but the code is not working!
Andrei Bobrov
Andrei Bobrov 2016-2-19
Typo :), corrected.
Moe
Moe 2016-2-21
编辑：Moe 2016-2-21
Thanks Andrei,
I tried your code with a larger database, but results aren't correct! I've attached an input file (try2). For example, after running code, look into ID 271, and ST 410. According to excel file the Code should be 103 until ST 1135, but in Matlab output code is 101 still.
Also, I used "ceil" function to get positive integer subscripts for c3 and c4.
Can you please have a look to the code with new data? Thanks in advance!
n = xlsread('try2.xlsx',1);
[a1,~,c1] = unique(n(:,1));
c3 = ceil((n(:,3)-240)/5+1);
c4 = ceil(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,[0,b(end,1:end-1)]))';
out = [nan,240+(0:z(1)-1)*5;[a1,out1]]
Andrei Bobrov
Andrei Bobrov 2016-2-21
I corrected answer and corrected your data (see try2_1.xlsx)
Moe
Moe 2016-2-22
Grear Andrei, Thanks!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by