Sort the rows of a table based on row entries in two columns of another table

Question

Deepa Maheshvare 2020-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506938-sort-the-rows-of-a-table-based-on-row-entries-in-two-columns-of-another-table

回答： Samatha Aleti 2020-2-25

I am trying to sort the rows in one table (Tright) based on the order in which the rows are present in another table (Tleft)

Tright ->

   EndNodes_1        EndNodes_2      var1
    __________    __________    _____________    
      {'1' }       {'5' }                   4       
      {'10'}       {'3' }                   1
      {'2' }       {'11'}                   6         
      {'2' }       {'8' }                   2        
      {'3' }       {'14'}                   9 

Tleft ->

   EndNodes_1           EndNodes_2      
    __________          __________    
      {'1' }                {'5' }                         
      {'2' }                {'8'}                           
      {'2' }                {'11' }                      
      {'3' }                {'14'}   
       {'10'}               {'3' }

Expected output:

   T = 
   EndNodes_1            EndNodes_2      var1
    __________           __________    _____________    
      {'1' }                {'5' }                4       
      {'2' }                {'8' }                2        
      {'2' }                {'11'}                6         
      {'3' }                {'14'}                9 
      {'10'}                {'3' }                1

I tried the following,

T = innerjoin(Tleft,Tright)
[~, index] = sort_nat(T.EndNodes_1);
T = T(index,:)

Obtained result:

T ->

   EndNodes_1             EndNodes_2      var1
    __________            __________    _____________    
      {'1' }                {'5' }                   4       
      {'2' }                {'11'}                   6         
      {'2' }                {'8' }                   2        
      {'3' }                {'14'}                   9 
      {'10'}                {'3' }                   1

Any suggestions on how to obtain the expected output will be really helpful.

Code:

ar = {'1' '10' '2' '2' '3'};
br = {'5' '3'  '11' '8' '14'};
cr = [4 1 6 2 9];
Tright = table(ar',br',cr','VariableNames',{'EndNodes_1','EndNodes_2','var1'})
al = {'1' '2' '2' '3' '10'};
bl = {'5' '8'  '11' '14' '3'};
Tleft = table(al',bl','VariableNames',{'EndNodes_1','EndNodes_2'})
T = innerjoin(Tleft,Tright);
[~, index] = sort_nat(T.EndNodes_1);
T = T(index,:)

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

请先登录，再进行评论。

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

Answer 1

Samatha Aleti 2020-2-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/506938-sort-the-rows-of-a-table-based-on-row-entries-in-two-columns-of-another-table#answer_417220

在 MATLAB Online 中打开

Hi,

According to my understanding you are trying to arrange the table “Tright” columns in the order of table ‘”Tleft”.

You can use “ismember” to do this as follows:

EndNodes_1 = {'1';'10';'2';'2';'3'};  
EndNodes_2 = {'5';'3';'11';'8';'14'};  
var1 = [4; 1; 6; 2; 9];  
Tright = table(EndNodes_1, EndNodes_2, var1)  
t1= table(EndNodes_1, EndNodes_2);  
EndNodes_1 = {'1';'2';'2';'3';'10'};  
EndNodes_2 = {'5';'8';'11'; '14';'3'};  
Tleft = table(EndNodes_1, EndNodes_2)  
t2 = Tleft;  
[Lt2,Loct1] = ismember(t2, t1, 'rows');  
Tright = Tright(Loct1,:) 