How to find compare unequal size matrices and create new matrix by combining them??

1 次查看(过去 30 天)
Hi, I have the following matrices:
X = [1001 1011 1001 10 130 0.8 0.2;
1001 1012 1001 11 150 0.2 0.8;
1001 1012 1001 11 131 0.5 0.5;
1001 1012 1002 11 140 0.6 0.4];
Y = [1001 1011 1001 10 112 1 122 214;
1001 1011 1001 11 221 1 134 113; % extra row
1001 1012 1001 11 98 1 58 82;
1001 1012 1001 11 68 1 59 67;
1001 1012 1002 11 32 1 56 98;
1004 1012 1005 12 67 1 89 132]; % extra row
and I want to get this :
M = [1001 1011 1001 10 130 0.8 0.2;
1001 1011 1001 11 NaN NaN NaN; % or sth equivalent to NaN
1001 1012 1001 11 150 0.2 0.8;
1001 1012 1001 11 131 0.5 0.5;
1001 1012 1002 11 140 0.6 0.4;
1004 1012 1005 12 NaN NaN NaN];
I have difficulty in finding/comparing 4 elements together of every row (M(:,1:4)), and also when the size of the matrices in not equal...
Any suggestions on which could be the right function to solve it??
Thanks,
Iro
  3 个评论
Sean de Wolski
Sean de Wolski 2013-5-7
I'm not clear on how you derived M. Can you be very specific, where does each row in M come from?
Iro
Iro 2013-5-7
M is the result I want to get with some function, derived from X an Y. More specifically, the four first columns come from Y's first 4 columsn while the rest 3 columns come from X's last three columns, in the case where the combinations of the first 4 column of Y are the same with combinations of X's first 4 columns... e.g: if M(i,1:4) is the same to any of X(j,1:4), then assign elements of X(j,5:7) to the M(i,5:end) by discarding the existing ones..
Let me know if it makes more sense now...Thanks!! :)

请先登录,再进行评论。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2013-5-7
ii = ismember(Y(:,1:4),X(:,1:4),'rows');
M = [Y(:,1:4),nan(size(Y,1),3)];
M(ii,5:end) = X(:,5:end);
  6 个评论
Iro
Iro 2013-5-9
编辑:Iro 2013-5-9
Well I tried it with:
M(tf,5:end) = X(loc(tf),5:end);
instead, and it seems to work. However I don't really understand what is the difference between loc and loc(tf) in relation to the error above (real positive integer or logical)... any hints?

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Matrices and Arrays 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by