dataset - add a new row and fill in data in a loop

조회 수: 2 (최근 30일)
Megan
Megan 2020년 2월 14일
편집: Megan 2020년 2월 19일
Hi guys I want to add a new row into my dataset and want to fill it in with data
Could someone help me?

채택된 답변

JESUS DAVID ARIZA ROYETH
JESUS DAVID ARIZA ROYETH 2020년 2월 14일
편집: JESUS DAVID ARIZA ROYETH 2020년 2월 14일
"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)
  댓글 수: 1
Megan
Megan 2020년 2월 15일
is there any possibility to do it with a for loop?

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

태그

Community Treasure Hunt

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

Start Hunting!

Translated by