rows extraction in matrix depending on a column value
2 views (last 30 days)
Show older comments
I have a 50x50 matrix and n that the last row has 0,1,2 at different locations ie., 0 n 10 rows,1 n 20 rows ad 2 in 20 rows, so depending on the column value how can i extract all rows containing 0 at 50th column and save them in to a single variable
2 Comments
Sean de Wolski
on 28 Jun 2013
A small example of your matrix and expected results would make this much easier to grasp.
Accepted Answer
Image Analyst
on 28 Jun 2013
Try this:
% Generate sample data
A=[...
1 2 3 0;
1 2 5 0;
5 8 6 1;
6 8 7 0;
5 4 7 2;
6 5 8 0]
% Get last column
lastColumn = A(:, end);
% Get zeros
A0 = A(lastColumn == 0, :)
% Get zeros
A1 = A(lastColumn == 1, :)
% Get zeros
A2 = A(lastColumn == 2, :)
In the command window:
A =
1 2 3 0
1 2 5 0
5 8 6 1
6 8 7 0
5 4 7 2
6 5 8 0
A0 =
1 2 3 0
1 2 5 0
6 8 7 0
6 5 8 0
A1 =
5 8 6 1
A2 =
5 4 7 2
More Answers (0)
See Also
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!