How to find table column number by column name?

177 Ansichten (letzte 30 Tage)
Joyjit Chatterjee
Joyjit Chatterjee am 11 Dez. 2018
Kommentiert: Sean de Wolski am 11 Dez. 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!

Akzeptierte Antwort

Sean de Wolski
Sean de Wolski am 11 Dez. 2018
tidx = find(string(T.Properties.VariableNames) == "Temperature")
  2 Kommentare
Stephen23
Stephen23 am 11 Dez. 2018
Would
find(strcmp(T.Properties.VariableNames,'Temperature'))
also work?
Sean de Wolski
Sean de Wolski am 11 Dez. 2018
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.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

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

Kategorien

Mehr zu Structures finden Sie in Help Center und File Exchange

Produkte


Version

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by