dataset - add a new row and fill in data in a loop
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
JESUS DAVID ARIZA ROYETH
on 14 Feb 2020
Edited: JESUS DAVID ARIZA ROYETH
on 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)
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!