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

5 views (last 30 days)
Robert
Robert on 22 May 2018
Commented: Robert on 23 May 2018
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!

Accepted Answer

Sean de Wolski
Sean de Wolski on 22 May 2018
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
But I'd recommend Stephen's natural sorting utilities as a way to skip sorting yourself:
  1 Comment
Robert
Robert on 23 May 2018
Thank you so much to both of you for your suggestions and links. Your solutions work great!

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!