Sort table with a specific order

Question

Iugo 2021-6-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/854850-sort-table-with-a-specific-order

评论： Iugo 2021-6-13

Hello everyone!

I have a table with two columns, the first is called ScanID , which contains the id's of some patients, and the second is called Site, which contains the site where the patients belong, going from 1 to 8. What I want is to order the rows of that table based on that Site column values, with the following order: 3,4,5,6,7,1,8.

How can I achieve this?

Thank you so much!

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-6-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/854850-sort-table-with-a-specific-order#answer_723550

在 MATLAB Online 中打开

[found, idx] = ismember(T.Site, [3,4,5,6,7,1,8]);
if any(~found)
   error('Site not on approved list, first at row %d', find(~found,1));
end
[~, sortorder] = sort(idx);
newT = T(sortorder,:);