Logical comparison between two tables

Question

Khairul Nur 2021-8-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/893382-logical-comparison-between-two-tables

编辑： Khairul Nur 2021-8-6

hi, i have two tables (value_a_per_cluster and calc_distance_min) which need to do logical comparison.

value_a_per_cluster =
   1     1     2
   0     2     1
   2     0     1
   1     1     0
     
calc_distance_min =
0000    1.4142    1.4142    1.7321
0000         0    1.4142    1.0000
7321    2.0000    1.4142    1.7321
7321    1.4142    1.4142    1.0000
    
    

each value in both tables need to do comparison as below:

if value_a_per_cluster <= calc_distance_min returns 2 else 3, thus the result should be:

Is it possible to do it without looping each rows and columns? Please suggest any function n code without doing the loops. TQIA

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

请先登录，再进行评论。

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

Answer 1

Dave B 2021-8-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/893382-logical-comparison-between-two-tables#answer_762067

编辑：Dave B 2021-8-6

在 MATLAB Online 中打开

As a quick answer, yes, you just use <= to compare the two matrices

You can take the 1s and 0s that result from doing the comparison and subtract them from 3 for an easy version that gives your answer:

value_a_per_cluster =[
     0     1     1     2
     1     0     2     1
     1     2     0     1
     2     1     1     0
     ];
 
calc_distance_min =[
    1.0000    1.4142    1.4142    1.7321
    1.0000         0    1.4142    1.0000
    1.7321    2.0000    1.4142    1.7321
    1.7321    1.4142    1.4142    1.0000
    ];
3-(value_a_per_cluster <= calc_distance_min)
ans = 4×4
     2     2     2     3
     2     2     3     2
     2     2     2     2
     3     2     2     2

A slightly more elegant final bit, that would extend more easily to other values, might be:

isIt = value_a_per_cluster <= calc_distance_min;
result = nan(size(isIt));
result(isIt) = 2;
result(~isIt) = 3;
result
result = 4×4
     2     2     2     3
     2     2     3     2
     2     2     2     2
     3     2     2     2