Comparing data in a matrix/table

Question

Joaquin Lalusin 2021-1-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/706508-comparing-data-in-a-matrix-table

评论： Joaquin Lalusin 2021-1-1

In the table above, focus on the elements of columns 3 and 4. Column 3 is the object number and Column 4 is its "group." I want to count how many times an object was grouped in both 1 and 2. Store it in a variable "count." The value of "count" based on the table above should be 2 because only object numbers 11 and 17 were grouped in both 1 and 2.

EDIT: To make indexing easier, the name of the table above shall be called TableA

2 个评论
显示无隐藏无

Ive J 2021-1-1

This looks like a homework to me. What have you tried so far?

Joaquin Lalusin 2021-1-1

Its not homework per se, more of a personal project.I have already processed the data I'm working with to result in the table above. I'm currently trying to index my data to figure out how many "objects" each "group" share. I've been racking my brain around for hours but haven't had any luck. I've been thinking of making a nested for and if loop but I cant think of the best way how.

请先登录，再进行评论。

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

Answer 1

Ive J 2021-1-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/706508-comparing-data-in-a-matrix-table#answer_588753

编辑：Ive J 2021-1-1

在 MATLAB Online 中打开

One way would be to use groupsummary:

tab = 
       a1          a2       a3    a4
    ________    ________    __    __
84913    0.046171    10    1 
93399    0.097132    10    1 
67874     0.82346    11    1 
75774     0.69483    11    2 
74313      0.3171    12    1 
39223     0.95022    14    1 
65548    0.034446    14    1 
17119     0.43874    14    1 
70605     0.38156    14    1 
031833     0.76552    17    2 
27692      0.7952    17    1 
G = groupsummary(tab, {'a3','a4'})
    a3    a4    GroupCount
    __    __    __________
  1         2     
  1         1     
  2         1     
  1         1     
  1         4     
  1         1     
  2         1  
 

So, number of repeats in column a3 would the variable count:

[a3unique, ~, idx] = unique(G.a3, 'stable');
count = histcounts(idx, [1:numel(a3unique), inf]);
count
    1     2     1     1     2
    
 a3unique'
    10    11    12    14    17