extracting values and respective rows from a colummn
1 view (last 30 days)
Show older comments
Hallo,
this is my problem:
I have a column B and a matrix A A contains in its first column the values of the B But A has a lot more values which I do not need. I want to create a code that extracts from the matrix A the rows corresponding to the values that are in the B column.
Hope that somebody can help,
Thanks in advance.
Sami
0 Comments
Accepted Answer
Matt Fig
on 6 Jun 2011
I assume your A and B look something like this:
% Create some data to work with...
B = [3 5 7 9].';
A = round(rand(10)*100)/100;
A([2 10 4 7],1) = B % Put B in first column of A
To get the rows of A which have the values of B in the first column:
A_new = A(ismember(A(:,1),B),:)
2 Comments
Jan
on 6 Jun 2011
+1: I *must* vote your answer: it is too obvious that it is the best answer in my opinion. :-)
More Answers (0)
See Also
Categories
Find more on Get Started with MATLAB 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!