How can I select multiple columns in a table using variable names and wildcards?
436 次查看(过去 30 天)
显示 更早的评论
Hi all,
I am trying to index and extract a series of variables from a table i've created based on the VariableNames. I would rather index using the VariableNames as opposed to numerical or logical index due to the fact that there might be different numbers of trials for the variables.
Using the below code I can call one variable at a time. The '_1' represents the trial number which could go up to '_20'.
C1vC2Trials = C1MPVNormVariables(:,'C1MPVNorm_1');
However when trying to use the * wildcard to call all trials for that variable I get an error.
Error: Unrecognized variable name 'C1MPVNorm_*'.
Is this possible to do with tables or is there a easy work around to find the number of VariableNames in the table which correspond to the ones I wish to extract?
Thanks in advance!
0 个评论
采纳的回答
Cedric
2017-10-4
编辑:Cedric
2017-10-4
I am not using tables, so you should probably wait for a better answer, but here is one way that I could see. Say we have the table:
T =
5×4 table
Age Height Weight BloodPressure
___ ______ ______ _____________
Smith 38 71 176 124 93
Johnson 43 69 163 109 77
Williams 38 64 131 125 83
Jones 40 67 133 117 75
Brown 49 64 119 122 80
and we want all variables that contain the string 'ei' (pattern):
>> hasMatch = ~cellfun('isempty', regexp(T.Properties.VariableNames, 'ei', 'once')) ;
>> T(:, T.Properties.VariableNames(hasMatch))
ans =
5×2 table
Height Weight
______ ______
Smith 71 176
Johnson 69 163
Williams 64 131
Jones 67 133
Brown 64 119
Here we are using regular expressions, so you must use regexp types of "wildcards".
4 个评论
BenRaanan
2018-2-14
I believe the preferred syntax is:
>> T(:, contains(T.Properties.VariableNames, 'ei'))
Peter Perkins
2018-2-15
Yes, in recent versions of MATLAB you should be able to avoid using regexp in most cases, by using things like contains and startsWith instead. In older versions, you can often use strfind, depending on how complicated the pattern is.
Even with regexp, I think you can skip using cellfun and just make a vectorized call to regexp.
更多回答(2 个)
Roman Romanovski
2019-5-6
T(:,ismember(T.Properties.VariableNames, {""list of variables""}))
This will get you there for the variable names part. Above already answered wild card.
> T(:, contains(T.Properties.VariableNames, 'C1MPVNorm_'))
5 个评论
Peter Perkins
2019-5-14
Tables have variables, not columns. "Variables", because the things in a table can themselves have multiple columns. So yes, dot subscripting extracts exactly one variable.
The syntax to extract multiple variables is T{:,ListOfVars}.
Chenye Shen
2021-10-22
You can refer to this。
2 个评论
Peter Perkins
2023-9-21
To expand on the link that Chenye has provided: new features are added all the time. In particular, tables have supported patters for variable names since ... I actualy don't recall exactly when. The doc in that link show an example, but for the record:
t = table([1;2;3],[4;5;6],[7;8;9],VariableNames=["x1" "x2" "y"])
t(:,"x"+digitsPattern)
Also, of course, use "strings", not 'cell arrays of char vectors'!
Steven Lord
2023-9-21
The ability to use pattern objects to index into table rows, variables, and properties was introduced in release R2022a.
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!