How to order variables in a table

20 次查看(过去 30 天)
Hello,
I find myself with a curious problem: I need to order the variables of a table without knowing in advance if all the variables will be present. I mean, I know what all the possible variables might be (possible_vars), and I know in what order I want them (desired_order). But I dont know if all the variables will be present (at least some of them will be but I dont know which ones). And if a variable is missing then it is missing, thats fine. The desired order should be kept just without that variable.
So how could I order table t below based on the desired order but without knowing in advance what all the variables will be ?
posible_vars = {'x', 'p', 'o', 'v', 's', 'a'}
desired_order = {'a', 'v', 'o', 'v', 's', 'x'}
% data
x = [1:3]';
a = {'A';'B';'C'};
o = {'A';'B';'C'};
t = table(x, a, o)

采纳的回答

Adam Danz
Adam Danz 2019-10-25
编辑:Adam Danz 2019-10-26
The solution to sorting table columns according to a desired order is below. However, your current method requires that the variable has a certain name and this is not recommended. A variable name should never be used in code. Variable names are merely a way for humans to organize their data and quickly understand what a variable is. The code should never rely on the name of a variable. I've therefore changed the way you are forming the table so that your variable names are not used by the code.
p = [1:3]';
q = {'A';'B';'C'};
r = {'A';'B';'C'};
t = table(p,q,r,'VariableNames',{'x', 'a', 'o'});
% Name your columns here--------^^^^^^^^^^^^^^^
% even if your variable names match the "VariableNames".
desired_order = {'a', 'v', 'o', 'v', 's', 'x'};
[~, varOrder] = ismember(t.Properties.VariableNames, desired_order);
[~, resortOrder] = sort(varOrder);
t = t(:,resortOrder)
% head(t)
% ans =
% 3×3 table
% a o x
% _____ _____ _
% {'A'} {'A'} 1
% {'B'} {'B'} 2
% {'C'} {'C'} 3
[addendum]
In the above solution, case matters. If a column header is named 'X' (upper case) it will not be sorted based on the index of 'x' (lower case). If you'd like to ignore case, you can use lower() to make sure the matching is all done in lower case no matter what case your headers are in.
Example:
[~, varOrder] = ismember(lower(t.Properties.VariableNames), desired_order);
% ^^^^^

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by