Conditional Indexing Using Specific Numbers in A Column

2 vues (au cours des 30 derniers jours)
SRB
SRB le 17 Mai 2020
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 commentaires
Jyotsna Talluri
Jyotsna Talluri le 25 Mai 2020
Is first 5001 and last 6001 of 11th column to be considered ?
SRB
SRB le 25 Mai 2020
Yes.

Connectez-vous pour commenter.

Réponses (1)

Jyotsna Talluri
Jyotsna Talluri le 26 Mai 2020
load('MyData.mat');
a=find(MyData(:,11)==5001);
b=find(MyData(:,11)==6001);
matrixA=MyData(a(1):b(end),:);

Catégories

En savoir plus sur Elementary Math dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by