Adding a new column to a table

20 次查看（过去 30 天）

Daniela Valdez 2021-2-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/755489-adding-a-new-column-to-a-table

评论： Star Strider 2021-2-25

I have the following database (Male_Data), its a 3101x16 table.

I want to add a new column in which I get values between 1 and 3 depending on the value I have on the QTCorrected column.

1 if the value is between 330 - 360

2 if the value is between 361 - 390

3 if the value is between 391 - 470.

% This is all I can think of
% The name of the column I want to add is QTSyndrome
Male_Data.QTSyndrome = Male_Data.QTCorrected () %I'm thinking about adding some kind of if statement inside the 
                                                % parenthesis but my attempts haven't been succesful so far

Any help is appreciated

Thanks

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

请先登录，再进行评论。

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

回答（1 个）

Star Strider 2021-2-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/755489-adding-a-new-column-to-a-table#answer_632604

在 MATLAB Online 中打开

One approach:

T1 = table(randi([330 470],10,1), 'VariableNames',{'QTcorrected'});                 % Create Data
QTc = @(x) 1*((x>=330)&(x<=360)) + 2*((x>=361)&(x<=390)) + 3*((x>=391)&(x<470));    % Classify
T1.NewColumn = QTc(T1.QTcorrected);                                                 % Add Variable