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

Question

Deepa Maheshvare 2019-12-14

0
链接

此问题的直接链接

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

回答： Mohammad Sami 2019-12-17

I've the following tables

Tleft>

     EndNodes_1    EndNodes_2
    __________    __________

    {'1'     }    {'Node9' }
    {'2'     }    {'Node10'}
    {'2'     }    {'Node11'}
    {'3'     }    {'Node12'}
    {'3'     }    {'Node13'}
    {'4'     }    {'Node14'}
    {'4'     }    {'Node15'}
    {'5'     }    {'Node16'}
    {'6'     }    {'Node17'}
    {'7'     }    {'Node18'}
    {'Node9' }    {'2'     }
    {'Node10'}    {'3'     }
    {'Node11'}    {'4'     }
    {'Node12'}    {'5'     }
    {'Node13'}    {'5'     }
    {'Node14'}    {'6'     }
    {'Node15'}    {'6'     }
    {'Node16'}    {'7'     }
    {'Node17'}    {'7'     }
    {'Node18'}    {'8'     }

Tright =
  20×3 table
    EndNodes_1    EndNodes_2     value 
    __________    __________    _______
    {'1'     }    {'Node9' }    {[5.2]}
    {'Node9' }    {'2'     }    {[5.2]}
    {'2'     }    {'Node10'}    {[2.6]}
    {'Node10'}    {'3'     }    {[2.6]}
    {'2'     }    {'Node11'}    {[2.6]}
    {'Node11'}    {'4'     }    {[2.6]}
    {'3'     }    {'Node12'}    {[1.3]}
    {'Node12'}    {'5'     }    {[1.3]}
    {'3'     }    {'Node13'}    {[1.3]}
    {'Node13'}    {'5'     }    {[1.3]}
    {'4'     }    {'Node14'}    {[1.3]}
    {'Node14'}    {'6'     }    {[1.3]}
    {'4'     }    {'Node15'}    {[1.3]}
    {'Node15'}    {'6'     }    {[1.3]}
    {'5'     }    {'Node16'}    {[2.6]}
    {'Node16'}    {'7'     }    {[2.6]}
    {'6'     }    {'Node17'}    {[2.6]}
    {'Node17'}    {'7'     }    {[2.6]}
    {'7'     }    {'Node18'}    {[5.2]}
    {'Node18'}    {'8'     }    {[5.2]}

Result obtained after using

T = innerjoin(Tleft,Tright)

T =
  20×3 table

    EndNodes_1    EndNodes_2     value 
    __________    __________    _______
    {'1'     }    {'Node9' }    {[5.2]}
    {'2'     }    {'Node10'}    {[2.6]}
    {'2'     }    {'Node11'}    {[2.6]}
    {'3'     }    {'Node12'}    {[1.3]}
    {'3'     }    {'Node13'}    {[1.3]}
    {'4'     }    {'Node14'}    {[1.3]}
    {'4'     }    {'Node15'}    {[1.3]}
    {'5'     }    {'Node16'}    {[2.6]}
    {'6'     }    {'Node17'}    {[2.6]}
    {'7'     }    {'Node18'}    {[5.2]}
    {'Node10'}    {'3'     }    {[2.6]}
    {'Node11'}    {'4'     }    {[2.6]}
    {'Node12'}    {'5'     }    {[1.3]}
    {'Node13'}    {'5'     }    {[1.3]}
    {'Node14'}    {'6'     }    {[1.3]}
    {'Node15'}    {'6'     }    {[1.3]}
    {'Node16'}    {'7'     }    {[2.6]}
    {'Node17'}    {'7'     }    {[2.6]}
    {'Node18'}    {'8'     }    {[5.2]}
    {'Node9' }    {'2'     }    {[5.2]}

Expected result: Rows to be in the sam eorder of rows of Tleft in T

T =
  20×3 table

    EndNodes_1    EndNodes_2     value 
    __________    __________    _______
    {'1'     }    {'Node9' }    {[5.2]}
    {'2'     }    {'Node10'}    {[2.6]}
    {'2'     }    {'Node11'}    {[2.6]}
    {'3'     }    {'Node12'}    {[1.3]}
    {'3'     }    {'Node13'}    {[1.3]}
    {'4'     }    {'Node14'}    {[1.3]}
    {'4'     }    {'Node15'}    {[1.3]}
    {'5'     }    {'Node16'}    {[2.6]}
    {'6'     }    {'Node17'}    {[2.6]}
    {'7'     }    {'Node18'}    {[5.2]}
    {'Node9' }    {'2'     }    {[5.2]}
    {'Node10'}    {'3'     }    {[2.6]}
    {'Node11'}    {'4'     }    {[2.6]}
    {'Node12'}    {'5'     }    {[1.3]}
    {'Node13'}    {'5'     }    {[1.3]}
    {'Node14'}    {'6'     }    {[1.3]}
    {'Node15'}    {'6'     }    {[1.3]}
    {'Node16'}    {'7'     }    {[2.6]}
    {'Node17'}    {'7'     }    {[2.6]}
    {'Node18'}    {'8'     }    {[5.2]}

Note: The entries are strings and cell arrays since the table is created from a graph object

2 个评论
显示无隐藏无

dpb 2019-12-14

First column is sorted lexically and since there aren't two digits in the node number string, 'Node9' sorts behind 'NodeN' for N<9. You'll have the same problem if your numeric values pass single digits anywhere in the real data set.

There's a FEX submission, whether it'll be smart enough for this case or not, I don't know.

Probably the easiest workaround if you can't fix the data format to be consistent is the list starts in order is to augment with an index vector of 1:size(Tleft,1) and then resort the final result by it.

Alternatively, fix the naming to be consistent for desired sort order.

Oh...you might look to see if there's anything like an optional parameter in innerjoin like 'stable' to preserve existing order.

Deepa Maheshvare 2019-12-14

编辑：Deepa Maheshvare 2019-12-14

Could you please share the link to the FEX submission? Unfortunately, I couldn't find the optional parameter 'stable'.

请先登录，再进行评论。

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

Answer 1

Mohammad Sami 2019-12-17

0
链接

此回答的直接链接

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

inner join will return a second optional output, ileft

ileft = Index to Tleft, returned as a column vector. Each element of ileft identifies the row in Tleft that corresponds to that row in the output table or timetable, T.

You can potentially use this to resort the output in the order of tleft.

[T,ileft] = innerjoin(Tleft,Tright);
[~,iileft] = sort(ileft); % use the optional output of sort to get the correct sorting order
T = T(iileft,:);

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

请先登录，再进行评论。

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

2 个评论
显示无隐藏无

回答（1 个）

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

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

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

2 个评论 显示 无隐藏 无

回答（1 个）

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

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

WeChat

2 个评论
显示无隐藏无

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