How can I select multiple columns in a table using variable names and wildcards?
조회 수: 336 (최근 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}.
Zzz
2021년 5월 6일
The correct syntax is T(:, {'col_name_1', 'col_name_2'}) to get the data like a table.
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.
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Type Identification에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!