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

2 Ansichten (letzte 30 Tage)
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!

Akzeptierte Antwort

Sean de Wolski
Sean de Wolski am 22 Mai 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 Kommentar
Robert am 23 Mai 2018
Thank you so much to both of you for your suggestions and links. Your solutions work great!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Walter Roberson
Walter Roberson am 22 Mai 2018


Mehr zu Characters and Strings finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by