Conditional Indexing Using Specific Numbers in A Column
Show older comments
I have the following 2156 x 11 matrix (A). I have attached the matrix. I want to use column 11 to get all rows between 5001's and 6001's and put them in another matrix (B). I also want to get all the rows between 5001's and 1001's and put them in another matrix (C).
Below is a truncated version of column 11:
1001
0
0
0
0
0
0
5001
1001
0
0
0
0
0
5001
1001
0
0
0
0
5001
0
1001
0
0
0
0
5001
1001
0
0
0
0
5001
6001
.
.
.
2 Comments
Jyotsna Talluri
on 25 May 2020
Is first 5001 and last 6001 of 11th column to be considered ?
SRB
on 25 May 2020
Answers (1)
Jyotsna Talluri
on 26 May 2020
load('MyData.mat');
a=find(MyData(:,11)==5001);
b=find(MyData(:,11)==6001);
matrixA=MyData(a(1):b(end),:);
Categories
Find more on Creating and Concatenating Matrices in Help Center and File Exchange
on 26 May 2020
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
