compare the column 2 of two matrix and forming the matrix with same entries in column 2 of Second Matrix.

Question

Anu Sharma 2022-3-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1675334-compare-the-column-2-of-two-matrix-and-forming-the-matrix-with-same-entries-in-column-2-of-second-ma

回答： Jan 2022-3-19

I have First Matrix A1 with 8 rows and 3 column, The 2 column of Matrix A1 and Matrix A2 have some same values. I want another matrix A3 which will have common Column 2 values and column 3 has same entries as in column 3 of matrix A1.

A1 =

[115.28 30 1

115.26 33 2

115.25 8 3

115.24 21 2

115.24 25 1

115.21 2 2

115.21 18 2

115.19 1 3]

2nd matrix

A2 =

[115.19 1 3

115.21 2 3

115.25 8 3

115.24 25 3

115.28 30 3

115.26 33 3]

I want output A3 as:

A3 =

[115.19 1 3

115.21 2 2

115.25 8 3

115.24 25 1

115.28 30 1

115.26 33 2]

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

请先登录，再进行评论。

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

Answer 1

Jan 2022-3-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1675334-compare-the-column-2-of-two-matrix-and-forming-the-matrix-with-same-entries-in-column-2-of-second-ma#answer_921619

在 MATLAB Online 中打开

A1 = [115.28	30	1; ...
26	33	2; ...
25	8	3; ...
24	21	2; ...
24	25	1; ...
21	2	2; ...
21	18	2; ...
19	1	3];
A2 = [115.19	1	3; ...
21	2	3; ...
25	8	3; ...
24	25	3; ...
28	30	3; ...
26	33	3];
[lA2, iA1] = ismember(A2(:, 1), A1(:, 1), 'legacy');
A3 = [A2(lA2, 1:2), A1(iA1, 3)]
A3 = 6×3
1900    1.0000    3.0000
2100    2.0000    2.0000
2500    8.0000    3.0000
2400   25.0000    1.0000
2800   30.0000    1.0000
2600   33.0000    2.0000

The 'legacy' flag is required, because A1 contains the numer 115.24 twice. In legacy mode, the last occurrence is chosen, in normal mode (in modern Matlab versions), it is the first one.