How to covert rownames to the first variable in the table?

Question

monkeyquant 2023-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900610-how-to-covert-rownames-to-the-first-variable-in-the-table

回答： Star Strider 2023-1-25

I have a table with rownames (nuemric value) and want to convert it to a table with a newly added variable from the rownames.

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2023-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900610-how-to-covert-rownames-to-the-first-variable-in-the-table#answer_1156245

在 MATLAB Online 中打开

Try something like this —

T1 = array2table(randi(9, 5, 5));
T1.Properties.RowNames = {'1','2','3','4','5'}                      % Create Table With Row Names
T1 = 5×5 table
         Var1    Var2    Var3    Var4    Var5
         ____    ____    ____    ____    ____

    1     2       8       8       8       3  
    2     1       3       8       8       7  
    3     5       8       5       5       7  
    4     9       3       1       2       1  
    5     2       5       1       7       2  
RN = T1.Properties.RowNames                                         % Get Row Names
RN = 5×1 cell array
    {'1'}
    {'2'}
    {'3'}
    {'4'}
    {'5'}
T1 = addvars(T1, cell2mat(RN), 'Before','Var1')                     % Convert Row Names To First Variable
T1 = 5×6 table
         Var1_1    Var1    Var2    Var3    Var4    Var5
         ______    ____    ____    ____    ____    ____

    1      1        2       8       8       8       3  
    2      2        1       3       8       8       7  
    3      3        5       8       5       5       7  
    4      4        9       3       1       2       1  
    5      5        2       5       1       7       2  
T1.Properties.RowNames = {}                                         % Delete Original Row Names
T1 = 5×6 table
    Var1_1    Var1    Var2    Var3    Var4    Var5
    ______    ____    ____    ____    ____    ____

      1        2       8       8       8       3  
      2        1       3       8       8       7  
      3        5       8       5       5       7  
      4        9       3       1       2       1  
      5        2       5       1       7       2  