MATLAB: How to find table column number by column name

big datadatadata analyticsMATLABtable

I have a Table in MATLAB, suppose the table is A of dimensions 21392×1970. 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!

Best Answer

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

Related Solutions

MATLAB: Hi! I have 2 tables and I would like to extract the rows in table A if the 2nd column of table A contains any of the values in table B. They are both formatted as tables. Any help would be great! Thank you very much!

 result_T = T_A(ismember(T_A.Var2,T_B.Var1),:)

MATLAB: How to make a variable that is equal to the position of a row in a table by using the name of that row

fieldnames is specically documented for struct or Java or COM objects at least thru R2019b; I wasn't aware it would return the column names from a table object. There's no parallel for the row identifiers like rownames however.

fieldnames seems to return the table variable names first and is followed by the elements {'Properties','Row','Variables'} irrespective of the values of those additional property values. Hence, it's not particularly useful for that purpose.

But, it's simple enough, just use the table .Row property...

find(ismember(T.Row, 'Name of Row'))

There is also the T.Properties.RowNames property that returns the row names cellstr array.

I tend to write using newer string class functions like contains or beginsWith instead of ismember although the row names internally are and are returned as a cellstr array.

Best Answer

Related Solutions

MATLAB: Hi! I have 2 tables and I would like to extract the rows in table A if the 2nd column of table A contains any of the values in table B. They are both formatted as tables. Any help would be great! Thank you very much!

MATLAB: How to make a variable that is equal to the position of a row in a table by using the name of that row

Related Question