MATLAB: Question regarding a find function(search for data)

findsearch

Hi, I have the following matrix:

data=[10 1 2 3; 11 4 5 6; 12 7 8 9; 17 4 5 6]

I want to do a query with the following matirx:

built a matrix base on the element value 10 and 17

lookfor=[10;17]

And I'm looking for the following result(values associate with 10 and 17 in this case)

anwser=[10 1 2 3; 17 4 5 6]

I'm looking for a dynamic anwser, data matrix and lookfor matrix will vary and be much more bigger.

thank you in advance for your precious anwsers.

Best Answer

out=[data(any(data==17,2),:);data(any(data==10,2),:)]

%or

out=data(any(ismember(data,lookfor),2),:)

Related Solutions

MATLAB: How to do the following in a simpler and smarter way

C=repmat(1:21,12,1)
C=C(:)'

%or

C=1:21;
C=reshape(C(ones(12,1),:),1,[])

MATLAB: How to do a group by in matlab

data=[10 1 2 3; 11 4 5 6;10 0 20 30; 11 4 5 6; 12 7 8 9; 17 40 50 60]
lookfor=[10;11];
a=arrayfun(@(x) data(find(data(:,1)==x),:),lookfor,'un',0);
b=cell2mat(cellfun(@(x) [x(1) sum(x(:,2:end),1)],a,'un',0))

%or

data=[10 1 2 3; 11 4 5 6;10 0 20 30; 11 4 5 6; 12 7 8 9; 17 40 50 60]
lookfor=[10;11]
for k=1:numel(lookfor)
  ii=data(ismember(data(:,1),lookfor(k)),:);
  res(k,:)=[ii(1,1) sum(ii(:,2:end))];
end
res

Best Answer

Related Solutions

MATLAB: How to do the following in a simpler and smarter way

MATLAB: How to do a group by in matlab

Related Question