Find number of row in a table.

Question

fyza affandi 2018-12-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/437056-find-number-of-row-in-a-table

编辑： dpb 2018-12-25

I have the following table

tblB = 
    Symbol    Count
    ______    _____
      25   
       8   
       7   
       7   
       6   
       3   
       2   
       1   
       1   
       1   
       1   
       1   
       1   

which is based on the matrix E1 below

    E1 =
   1     4     5     1     1     3     1
   1     2     5     1     1     1     1
   4     1     3     5    10     5     4
   2     3     4     5     8     4     1
   2    12    16     1     1     3     3
   2    10    14     1     1     1     1
   1    10     8     2     5     3    15
   2     1     3     2    21     1    11

How can I find the number of row for the symbol of the matrix.?

For example for E1(1,1) is from row 1 of tblB and so on....

row = [1 1 5 4 1 1 2 1......]

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

Image Analyst 2018-12-24

编辑：Image Analyst 2018-12-24

在 MATLAB Online 中打开

E1(1,1) is 1. So you want to find every row of tblB that has equals E1(1,1)?

Like

rowsWith1 = tblB{:, 1} == E1(1,1) | tblB{:, 2} == E1(1,1);

Please clarify. How are you getting the columns (values) in your row vector called "row" from tblB and E1(1,1)?

请先登录，再进行评论。

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

Answer 1

dpb 2018-12-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/437056-find-number-of-row-in-a-table#answer_353715

在 MATLAB Online 中打开

Preliminaries...

E1 =[1     1     4     5     1     1     3     1
     1     1     2     5     1     1     1     1
     3     4     1     3     5    10     5     4
     4     2     3     4     5     8     4     1
     1     2    12    16     1     1     3     3
     1     2    10    14     1     1     1     1
     1     1    10     8     2     5     3    15
     5     2     1     3     2    21     1    11];
u=unique(E1);
n=histc(E1(:),u);
[n,ix]=sort(n,'descend');
t=table(u(ix),n,'VariableNames',{'Symbol','Count'});

Now the magic...

>> arrayfun(@(x) find(x==t.Symbol),E1)
ans =
   1     5     4     1     1     2     1
   1     3     4     1     1     1     1
   5     1     2     4     6     4     5
   3     2     5     4     7     5     1
   3     9    12     1     1     2     2
   3     6    10     1     1     1     1
   1     6     7     3     4     2    11
   3     1     2     3    13     1     8
>> 

2 个评论
显示无隐藏无

fyza affandi 2018-12-24

Thank you so much :)

dpb 2018-12-24

编辑：dpb 2018-12-25

No problem...glad to help. :)

BTW, be aware that the data of the table t is embedded in the anonymous function when the function is defined. Thus if the data in the table change, you must also redefine the function...that happens automagically as written but if you were to define a separate function handle first and then change the data, then the existing function handle wouldn't know anything about that new data...

请先登录，再进行评论。