Output of the row of a vector which has the same entry as a second vector

1 view (last 30 days)
Matt
Matt on 1 Dec 2012
Hello,
Problem: Two vectors a and b. Id like to know in which row of the vector a, the entries of a and b are the same. Output vector r. if a entry in b occurs twice/triple/... the output of the row should also be twice/triple/...
I tried it like this:
a=[1 3 5 8 9 10 13 16]';
b=[2 5 1 1 8 8 8]';
r=find(ismember(a,b))
Solution: r =[1;3;4]
desired solution: r =[1;1;3;4;4;4]
Thanks in advance for your help!

Accepted Answer

Matt Fig
Matt Fig on 1 Dec 2012
Edited: Matt Fig on 1 Dec 2012
You were close, but you want to switch the order of the arguments to ISMEMBER and use the two output call.
% Original data
a=[1 3 5 8 9 10 13 16]';
b=[2 5 1 1 8 8 8]';
% Get R
[H,R] = ismember(b,a);
R = sort(R(H)) % Do you really need it sorted??

More Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 1 Dec 2012
Edited: Azzi Abdelmalek on 1 Dec 2012
a=[1 3 5 8 9 10 13 16]';
b=[2 5 1 1 8 8 8]';
un=ones(numel(b),1)
out=cell2mat(arrayfun(@(x) un(b==a(x))*x,(1:numel(a))','un',0))

Community Treasure Hunt

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

Start Hunting!

Translated by