Sort rows of a table based on vector

Question

Erik J 2020-12-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/691300-sort-rows-of-a-table-based-on-vector

回答： Stephen23 2020-12-12

I have a table, Table_A, with 500 elements.

I have a vector, x, with number 1:500 in a random order.

I want to rearrange the table based on the values of x. For example, if the first three elements of x are 383, 24, 191, then the 393rd row of Table_A will be moved to row 1, the 24th row will be moved to row 2, the 191st row will be moved to row 3 and so on.

Any help is appreciated.

Thank you.

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

请先登录，再进行评论。

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

Answer 1

Erik J 2020-12-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/691300-sort-rows-of-a-table-based-on-vector#answer_572995

在 MATLAB Online 中打开

I was able to figure this out.

new_table = zeros(500,8);
new_table = array2table(new_table);
a = randperm(500);
for ii=1:500
    
    row = stim_sheet(a(ii),:);
    new_table(ii,:) = row;
end