Compare two matrices of different dimensions

28 次查看（过去 30 天）

显示更早的评论

Jonathan 2019-4-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/456984-compare-two-matrices-of-different-dimensions

评论： Walter Roberson 2021-6-30

采纳的回答： Jonathan

在 MATLAB Online 中打开

I have two matrices A=500000*4 and B=4300000*4.

Matrix A = id, plus 3 columns of NaN.

Matrix B = id, lat, lon, elev.

I would like to find the id values in A = B, and based on those same id values, fill matrix A with the missing lat,lon,elev.

The code I have is:

for i=1:length(A)
    ind = B(:,1)==A(i,1);
    A(i,2:4) = B(ind,2:4);
    clear ind
end

This works but is extremely slow. How can I do this more efficiently?

Thanks

Jon

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Jonathan 2019-4-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/456984-compare-two-matrices-of-different-dimensions#answer_371081

在 MATLAB Online 中打开

I fiddled around with this further and addressed the loop, which was re-doing the "find" and settled on this...

C=A(:,1);
D=B(:,1);
idx=find(ismember(C,D));
A(:,2)=B(idx,2);
A(:,3)=B(idx,3);
A(:,4)=B(idx,4);

seems to work.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Leonardo Monteiro de Carvalho 2021-6-30

If I wanted to compare C and D to check, for example, if C is in between 2 values (in 2 different columns) of array D, how would I do that?

Walter Roberson 2021-6-30

Two fixed columns? Or any two columns? If it is any two columns, then is D guaranteed to be non-decreasing along the rows? What is the desired output?

And to confirm, C and D are 2D and C and D have the same number of rows but not necessarily the same number of columns?

Or is C a column vector with the same number of entries that D has rows and the task is to find out which column the value is in relative to the content of that row of D?

Is there some pattern to the way D is arranged?

请先登录，再进行评论。