Make a matrix with matching numbers per column from a bigger one

1 view (last 30 days)
Hello,
Suppose i have the following matrix;
A=[2011 1 2 1 101 0
2011 1 2 1 105 0
2011 1 5 5 108 13.8
2011 1 9 4 107 0.1
2011 1 18 5 101 0
2011 1 19 5 107 0.6
2011 1 21 5 101 0.9
2011 1 23 5 104 5.4
2011 1 24 5 102 4.1
2011 1 25 5 101 0
2011 1 33 5 104 0
2011 1 38 5 104 2.1
2012 1 40 4 101 0
2012 1 46 5 107 0.4
2012 1 47 5 104 5.9
2012 1 49 5 102 4.3
2012 1 60 3 107 0
2012 1 66 1 104 0
2012 1 66 1 104 0]
I want to extract a matrix with matching numbers on certain columns.
For example, the values from column 1 are 2011 and simultaneously, the values from column 5 are 101. I also want to keep the other columns.
Anything would help! Thanks in advance

Accepted Answer

Walter Roberson
Walter Roberson on 19 Oct 2020
mask = A(:,1) == 2011 & A(:,5) == 101;
B = A(mask,:);

More Answers (0)

Categories

Find more on Matrices and Arrays 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!