how to substitute, in a table, variable names with the values of a vector

Question

Francesco Grechi 2021-4-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/790709-how-to-substitute-in-a-table-variable-names-with-the-values-of-a-vector

评论： Steven Lord 2021-4-2

i have a table of 6 colums U and each colums have its title (Nation, valueA, valueB, valueC, valueD, valueE). I want to substitute the last 5 colums names with the numbers contained in the vector X.

X = [1 2 3 4 5 ]

U is 20x6

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sajid Afaque 2021-4-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/790709-how-to-substitute-in-a-table-variable-names-with-the-values-of-a-vector#answer_664979

在 MATLAB Online 中打开

for num = 2:5
    table_name.Properties.VariableNames(num) = {'New substitute name here in this case X(num-1)'};
end

2 个评论
显示无隐藏无

Francesco Grechi 2021-4-2

i think that could be a good idea however if i put:

table_name.Properties.VariableNames(num) = {'X(num-1)'};

i got the following error (because matlab doesn't accept the ''):-->

'X(num-1)' is not a valid table variable name. See the documentation for isvarname or matlab.lang.makeValidName for more information.

Steven Lord 2021-4-2

在 MATLAB Online 中打开

The ability to specify table variable names that are not valid MATLAB identifiers was introduced in release R2019b. Prior to that all table variable names had to be valid MATLAB identifiers (as per the isvarname function.)

T = array2table(magic(4))
T = 4×4 table
    Var1    Var2    Var3    Var4
    ____    ____    ____    ____

     16       2       3      13 
      5      11      10       8 
      9       7       6      12 
      4      14      15       1 
newVariableNames = {'aardvark', 'baboon', 'camel', 'dog'};
T.Properties.VariableNames = newVariableNames
T = 4×4 table
    aardvark    baboon    camel    dog
    ________    ______    _____    ___

       16          2        3      13 
        5         11       10       8 
        9          7        6      12 
        4         14       15       1 