MATLAB Answers

0

How to find table column number by column name?

Asked by Joyjit Chatterjee on 11 Dec 2018
Latest activity Commented on by Sean de Wolski
on 11 Dec 2018
I have a Table in MATLAB, suppose the table is A of dimensions 21392x1970. There are 1970 columns in table A, as evident. There is a column named "Temperature" and I would like to find out the column number of that column eg. between 1-1970 which value in my table. How can I find the column number of a MATLAB table column by specifying the name of the column? Any help in this regard would be highly appreciated. Cheers and Thanks!

  0 Comments

Sign in to comment.

Products


Release

R2018a

2 Answers

Answer by Sean de Wolski
on 11 Dec 2018
 Accepted Answer

tidx = find(string(T.Properties.VariableNames) == "Temperature")

  2 Comments

Would
find(strcmp(T.Properties.VariableNames,'Temperature'))
also work?
Yeah, strcmp, and ismember would both work. I've been using the datatype string strings for pretty much everything so doing an equal (or ismember) is more natural.

Sign in to comment.


Answer by Walter Roberson
on 11 Dec 2018

varnames = A.Properties.VariableNames;
[tf, column_number] = ismember('Temperature', varnames);
if ~tf
error('Temperature is not one of the table variables')
end

  0 Comments

Sign in to comment.