How can I compare row by row to get rid if reciprocols and get corresponding indices

Question

Lei 2012-10-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/52204-how-can-i-compare-row-by-row-to-get-rid-if-reciprocols-and-get-corresponding-indices

hello, I have a data matrix looks like below.

A=[4  5  0  0  0  10  0  15  0  0.19218
5  0  0  0  15  0  20  0  0.06548
5  0  0  0  20  0  25  0  0.02662
5  0  0  0  25  0  30  0  0.01446
5  0  0  0  30  0  35  0  0.00708
5  0  0  0  35  0  40  0  0.00487
15  0  10  0  20  0  25  0  0.31673
15  0  10  0  25  0  30  0  0.09447
15  0  10  0  30  0  35  0  0.03430
15  0  10  0  35  0  40  0  0.02008
15  0  10  0  40  0  45  0  0.01002
15  0  10  0  45  0  50  0  0.00502
15  0  10  0  50  0  5  0  0.33494
10  0  15  0  5  0  0  0  0.19150
20  0  15  0  25  0  30  0  0.43342
20  0  15  0  30  0  35  0  0.10293
20  0  15  0  35  0  40  0  0.04998
20  0  15  0  40  0  45  0  0.02261
20  0  15  0  45  0  50  0  0.01038
20  0  15  0  50  0  55  0  0.00523
20  0  15  0  55  0  10  0  0.54030
15  0  20  0  10  0  5  0  0.37795
15  0  20  0  5  0  0  0  0.06513
];

Basically,I want compare row by row based on column [ 2 4 6 8]. for example,first row column 2,4, 6,8 is 5,0,10,15. and the 14th row column 2,4,6,8 is 10,15,5,0. In this case, I need the index of the two rows since I only want one row. For a second example,please compare 2nd and 15th row,2nd row has 5,0,15,20 and 15th row has 15,20,5,0. This is just part of my data, I have many reciprocol measurements which is roughly the same as I showed above.If anyone knows how can I solve this problem,please let me know. I do not want change the order of my data. Thanks

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

请先登录，再进行评论。

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

Answer 1

Sean de Wolski 2012-10-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/52204-how-can-i-compare-row-by-row-to-get-rid-if-reciprocols-and-get-corresponding-indices#answer_63640

在 MATLAB Online 中打开

Look at using the various outputs from unique().

doc unique

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

Sean de Wolski 2012-10-29

So use the 'rows' flag on the subset that you need. I.e. extract the columns you want to count and then look at unique rows of this. If you could make your example smaller with the expected results we might be able to help more. The matrix you show us is huge and we don't know what you expect.

Show us an example with a 5x4 matric and the results from it.

Lei 2012-10-29

编辑：Lei 2012-10-29

在 MATLAB Online 中打开

Hello Sean, Basically, I want compare this:

 A=[ 5 0 10 15 0.021
0 15 20 0.011
15 5 0 0.022
20 5 0 0.009]

I need to compare first two columns of each row with the 3rd and 4th columns of all of the other rows.If the answer is true, I want the index of the two rows. So for this matrix, the comparison of row 1 and row 3 is true, same as row 2 and row 4,of coure, I need the index for both rows. But the other combinations, the comparisons are wrong.

请先登录，再进行评论。