Assign one name to three variables in table

Question

Ali Tawfik 2020-5-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/523033-assign-one-name-to-three-variables-in-table

编辑： Cris LaPierre 2020-5-5

clear all;
t=[33;69;12;13;14;15]
u={'High';'M';'LOW'}
num=2
y=repmat(u,num,1)
i=[0;45]
ii=repelem(i,3)
yy = table(ii,y,t)

I would like the yy table to be only one name for each [high;M;LOW].

So, I would like to have the name 0 for the three elements in u. Is that possible?? Can anyone help?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2020-5-5

编辑：Image Analyst 2020-5-5

I don't understand. There is only one name (High, M, or LOW) for each row:

yy =

6×3 table

ii y t

__ ________ __

0 {'High'} 33

0 {'M' } 69

0 {'LOW' } 12

45 {'High'} 13

45 {'M' } 14

45 {'LOW' } 15

so what's the problem? The "three variables in table" in the table are ii, y, and t -- these are often also called fieldnames or columns - just depends on how people call them.

And what is "the name 0"? Do you mean the values of 0 in rows 1 through 3? Again, each row has only one cell with one word in it for the "y" field of the table.

What do you want your table to look like? Do you want only 2 rows in the table, with values in the "ii" field of 0 and 45? If so, what value would the y column take on? I have no idea so please spell out what you want your table to look like.

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2020-5-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/523033-assign-one-name-to-three-variables-in-table#answer_430326

编辑：Cris LaPierre 2020-5-5

在 MATLAB Online 中打开

It sounds like you want table variable y to be a categorical. If you don't want duplicates, you can set those rows equal to missing.

If I understand what you are asking, I might do the following

t=[33;69;12;13;14;15];
u={'High';'M';'LOW'};
i=[0;45];
ii=repelem(i,3);
yy = table('Size',[6 3],'VariableTypes',["double","categorical","double"]);
yy.Properties.VariableNames = ["ii","y","t"];
yy.ii = ii;
yy.y(1:3)=u;
yy.t = t
    ii         y         t 
    __    ___________    __
     0    High           33
     0    M              69
     0    LOW            12
    45    <undefined>    13
    45    <undefined>    14
    45    <undefined>    15