dataset - add a new row and fill in data in a loop
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Megan
am 14 Feb. 2020
Bearbeitet: Megan
am 19 Feb. 2020
Hi guys I want to add a new row into my dataset and want to fill it in with data
Could someone help me?
0 Kommentare
Akzeptierte Antwort
JESUS DAVID ARIZA ROYETH
am 14 Feb. 2020
Bearbeitet: JESUS DAVID ARIZA ROYETH
am 14 Feb. 2020
"The dataset data type is not recommended. To work with heterogeneous data, use the MATLAB® table data type instead"
data=readtable('datasetT.xlsx');
data=[data table(zeros(size(data,1),1),'VariableNames',"orderOfDay")];
data{and(data{:,1}>=1,data{:,1}<=7),end}=1;
data{and(data{:,1}>=8,data{:,1}<=14),end}=2;
data{and(data{:,1}>=15,data{:,1}<=21),end}=3
with dataset (not recommended) :
data = dataset("xlsfile", "datasetT.xlsx");
data=[data dataset(zeros(size(data,1),1),'VarNames',"orderOfDay")];
data(and(double(data(:,1))>=1,double(data(:,1))<=7),end)=dataset(1);
data(and(double(data(:,1))>=8,double(data(:,1))<=14),end)=dataset(2);
data(and(double(data(:,1))>=15,double(data(:,1))<=21),end)=dataset(3)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!