How do I compare two large matrices?

1 view (last 30 days)
Hi I'm new to matlab and was wondering how to compare two matrices
Basically I have one matrix that is 950x49 and one that is 950x1 I want to compare the two matrices to bring back the 10 closest values of each column of x that is compared with y, into a new matric 'new'. If anyone could please help, it would greatly be appreciated!
  2 Comments
José-Luis
José-Luis on 13 Sep 2014
Should the values be in the same line?
Premal
Premal on 13 Sep 2014
nope they just have to be the 10 closest values in each column!

Sign in to comment.

Accepted Answer

Rick Rosson
Rick Rosson on 13 Sep 2014
Edited: Rick Rosson on 13 Sep 2014
N = size(x,2);
u = ones(1,N);
d = abs(x - y*u);
v = sort(d);
z = v(1:10,:);
  1 Comment
Premal
Premal on 13 Sep 2014
thank you so much!!! Is there anyway to get the value of x that was closest into z rather than the difference?

Sign in to comment.

More Answers (1)

Roger Stafford
Roger Stafford on 13 Sep 2014
Just modify Rick's code a bit:
m = 10;
[~,p] = sort(abs(bsxfun(@minus,x,y)),2);
new = zeros(size(x,1),m);
for i = 1:N
new(i,:) = x(i,p(i,1:m));
end

Categories

Find more on Multidimensional 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!