Adding a new column to a table

2021 2 25
1 个回答
更新时间：2021 2 25
7 次查看（30 天）

0 个投票

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

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

回答（1 个）

Star Strider
Star Strider 2021-2-25

1 个投票

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
.

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Daniela Valdez
Daniela Valdez 2021-2-25
This is exactly what I was looking for! I appreciate it
Daniela Valdez
Daniela Valdez 2021-2-25
Hey! If I wanted to add the FileName column and have it match the row with the other data, how would you do it, here's what I'm doing
Male_Data_QTC = table(randi([330 470],3101,1), 'VariableNames',{'QTCorrected', 'FileName'}); % Create Data
QTc = @(x) 1*((x>=330)&(x<=360)) + 2*((x>=361)&(x<=390)) + 3*((x>=391)&(x<470)); % Classify
FileName = addvars(Male_Data.FileName)
Male_Data_QTC.QTSyndrome = QTc(Male_Data_QTC.QTCorrected) + FileName(Male_Data_QTC.FileName); % Add Variable
Star Strider
Star Strider 2021-2-25
As always, my pleasure!
I’m not certain about the ‘Fliename’ column, or that you’d need to add it separately, since if you use readtable to import the file in the image, it should already exist. There shouldn’t be any reason to add it again.
I’d have to have your data to experiment with to be certain, however simple horizontal concatenation would likely be easiest, if ‘Filename’ was already a table object.
See Build Table by Assigning Variables Individually for details on how best to add variables to existing table objects.
Daniela Valdez
Daniela Valdez 2021-2-25
Thnks! Appreciate it
Star Strider
Star Strider 2021-2-25
As always, my pleasure!

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

版本

R2015b

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by