if elseif else in Table

1 次查看（过去 30 天）
wesleynotwise
wesleynotwise 2017-7-18
评论： Padmamalini T H 2020-1-31
I have a column in my table containing numerical data, where I want to make them into 4 specific groups in a new column in the same table. I do not know how to write the code, but have attempted the following failed codes. Please correct me.
num_rows = size(Table1.Time,1) %count the number of rows in Table 1
for i=1:1:num_rows
if T1.Time < 5
T1.TimeNew = 5; % Group 1, return in a new column in Table 1
elseif T1.Time >= 5 & T1.Time <15
T1.TimeNew = 15; % Group 2
elseif T1.Time >= 15 & T1.Time <25
T1.TimeNew = 25; % Group 3
else T1.TimeNew = 30; % Group 4 (for any data >=25)
end
end

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-7-18
编辑：Andrei Bobrov 2017-7-18
ii = discretize(T.Time,[-inf,5,15,25,inf])
V = [5,15,25,30]';
T.TimeNew = V(ii);
  5 个评论
显示 3更早的评论
Jessica Blasco
Jessica Blasco 2018-5-14
thanks!! He also helped me with a similar problem!! :)
Padmamalini T H
Padmamalini T H 2020-1-31
thank you sir. it helped my problem too

请先登录，再进行评论。

更多回答（1 个）

lyda
lyda 2019-5-19
I have one table with many raws and columns.
I want to create a new table.
if a cell=111 return to me this raw
I don't know how to write this.
code=0;
for i=2:1143; %column 2 to raw 1143
if everything(i)==111; %"everything" is a table with all features
.......
end
end
thank you!

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by