if elseif else in Table
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
wesleynotwise
il 18 Lug 2017
Commentato: Padmamalini T H
il 31 Gen 2020
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
0 Commenti
Risposta accettata
Andrei Bobrov
il 18 Lug 2017
Modificato: Andrei Bobrov
il 18 Lug 2017
ii = discretize(T.Time,[-inf,5,15,25,inf])
V = [5,15,25,30]';
T.TimeNew = V(ii);
5 Commenti
Più risposte (1)
lyda
il 19 Mag 2019
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!
0 Commenti
Vedere anche
Categorie
Scopri di più su Logical in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!