How to reorder a matlab table based on a portion of variables name

Question

Robert 2018-5-22

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402053-how-to-reorder-a-matlab-table-based-on-a-portion-of-variables-name

评论： Robert 2018-5-23

Hi,

Wondering if anyone knows how to reorder a Matlab table based on a portion of variables name (numerical ID within the variables name) when having a table with hundreds of columns (variables)

Example of table variables name:

America_1010 America_1008 America_1001 America_1808 ...

After reorder:

America_1001 America_1008 America_1010 America_1808 ...

Thank you in advance!

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

请先登录，再进行评论。

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

Answer 1

Sean de Wolski 2018-5-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402053-how-to-reorder-a-matlab-table-based-on-a-portion-of-variables-name#answer_321479

Doing it manually,

T = array2table(1:4,'VariableNames', {'America_1010', 'America_1008', 'America_1001', 'America_1808'}) % example table
numeric_string = regexp(string(T.Properties.VariableNames), '(\d*)', 'tokens'); % grab numeric part
numeric_value = cellfun(@(x)double(x{1}), numeric_string); % convert to double
[~, idx] = sort(numeric_value); % sort
T2 = T(:,idx) % reorder