dataset - add a new row and fill in data in a loop
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Megan
le 14 Fév 2020
Modifié(e) : Megan
le 19 Fév 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 commentaires
Réponse acceptée
JESUS DAVID ARIZA ROYETH
le 14 Fév 2020
Modifié(e) : JESUS DAVID ARIZA ROYETH
le 14 Fév 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)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!