Borrar filtros
Borrar filtros

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

3 visualizaciones (últimos 30 días)
Megan
Megan el 14 de Feb. de 2020
Editada: Megan el 19 de Feb. de 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?

Respuesta aceptada

JESUS DAVID ARIZA ROYETH
JESUS DAVID ARIZA ROYETH el 14 de Feb. de 2020
Editada: JESUS DAVID ARIZA ROYETH el 14 de Feb. de 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)
  1 comentario
Megan
Megan el 15 de Feb. de 2020
is there any possibility to do it with a for loop?

Iniciar sesión para comentar.

Más respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by