Reorder table columns names
47 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
I have two tables
The order of the columns in the 1st table is:
Date, temp, humidity, pressure, precip, depth
The order of the columns in the 2nd table is:
Date, pressure, temp, humdity, precip, depth
How can I change the order of the 2nd table column names to match the order of the 1st table column names?
Thank you.
0 commentaires
Réponse acceptée
Adam Danz
le 15 Déc 2019
Modifié(e) : Adam Danz
le 15 Déc 2019
Hint:
[~, newOrder] = ismember(T1.Properties.VariableNames,T2.Properties.VariableNames);
2 commentaires
Adam Danz
le 15 Déc 2019
Looks like you got the hint! :)
In case future visitors are interested, here's the full demo:
% Create two tables
T1 = array2table(rand(10,6),'VariableNames',{'Date', 'temp', 'humidity', 'pressure', 'precip', 'depth'});
T2 = array2table(rand(10,6),'VariableNames',{'Date', 'pressure', 'temp', 'humidity', 'precip', 'depth'});
% Determine new column order of table 2
[~, newOrder] = ismember(T1.Properties.VariableNames,T2.Properties.VariableNames);
% Reorder columns of table 2
T2New = T2(:,newOrder)
Steven Lord
le 15 Déc 2019
Once you check (or if you can assume) that T2 has all the variables T1 does, you could skip ismember.
T3 = T2(:, T1.Properties.VariableNames);
Plus de réponses (1)
Image Analyst
le 15 Déc 2019
Try using table():
% Make random values for Date, temp, humidity, pressure, precip, depth
Date = randi(100, [5, 1]);
temp = randi(100, [5, 1]);
humidity = randi(100, [5, 1]);
pressure = randi(100, [5, 1]);
precip = randi(100, [5, 1]);
depth = randi(100, [5, 1]);
% Create tables, T1 and T2, as containers for the workspace variables.
T1 = table(Date, temp, humidity, pressure, precip, depth)
T2 = table(Date, pressure, temp, humidity, precip, depth ) % A different order
% Reorder T2's columns to have variables in the same order as T1.
% This assumes that all variable names exist in both tables and no extra or missing ones.
T2Sorted = table(T2.Date, T2.temp, T2.humidity, T2.pressure, T2.precip, T2.depth, ...
'VariableNames', {'Date', 'temp', 'humidity', 'pressure', 'precip', 'depth'})
0 commentaires
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!