if elseif else in Table
显示 更早的评论
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
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 个评论
wesleynotwise
2017-7-18
编辑：wesleynotwise
2017-7-18
Andrei Bobrov
2017-7-18
编辑：Andrei Bobrov
2017-7-18
with block if..elseif..else..end
for ii=1:size(T1.Time,1)%count the number of rows in T1
if T1.Time(ii) < 5
T1.TimeNew(ii) = 5; % Group 1, return in a new column in Table 1
elseif T1.Time(ii) >= 5 && T1.Time(ii) <15
T1.TimeNew(ii) = 15; % Group 2
elseif T1.Time(ii) >= 15 && T1.Time(ii) <25
T1.TimeNew(ii) = 25; % Group 3
else
T1.TimeNew(ii) = 30; % Group 4 (for any data >=25)
end
end
other "exotic" variant:
t = [T1.Time < 5,T1.Time >= 5 & T1.Time <15,T1.Time >= 15 & T1.Time <25];
T1.TimeNew = [t,~any(t,2)]*[5;15;25;30];
wesleynotwise
2017-7-18
Jessica Blasco
2018-5-14
thanks!! He also helped me with a similar problem!! :)
Padmamalini T H
2020-1-31
thank you sir. it helped my problem too
更多回答（1 个）
lyda
2019-5-19
0 个投票
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!
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
