Creating new table from another table

Question

Colin Leonelli 2021-9-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1455744-creating-new-table-from-another-table

回答： Star Strider 2021-9-18

I have a 4 column table with ages, FEV values, Heights and the last has 1s or 0s. 1 means they smoke, 0 means they don't.

I need to make a new table with ages 11 and up, who smoke, and include their FEV values

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2021-9-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1455744-creating-new-table-from-another-table#answer_790099

在 MATLAB Online 中打开

There are several ways to do this, including using the findgroups function.

A relatively efficient way is just to do the comparisons to create a logical vector (‘Lv’ here), and go with that —

T0 = table(randi([5 90],20,1), 100*rand(20,1),randi([100 200],20,1),randi([0 1],20,1), 'VariableNames',{'Age','FEV_1','Height','Smokes'})
T0 = 20×4 table
AgeFEV_1HeightSmokes______________________

    55.903     160        1   
   0.77497     112        1   
    10.859     132        1   
    82.203     173        1   
    58.998     103        0   
    92.198     162        1   
    22.737     183        0   
    39.319     176        0   
    23.808     113        1   
    29.428     145        0   
    54.328     116        1   
    31.662     121        0   
    33.127     123        1   
    77.932     138        0   
    32.548     145        0   
    35.402     200        1   
Lv = T0{:,1}>=11 & T0{:,4}==1;
T1 = T0(Lv,:)
T1 = 11×4 table
    Age     FEV_1     Height    Smokes
    ___    _______    ______    ______

    55.903     160        1   
   0.77497     112        1   
    10.859     132        1   
    82.203     173        1   
    92.198     162        1   
    23.808     113        1   
    54.328     116        1   
    35.402     200        1   
    19.997     133        1   
    78.177     113        1   
    66.497     185        1   