Storing data in Table inside for loop
Mostrar comentarios más antiguos
I wish to create a table where one row will be added in each for loop iteration. The caclulation is correct, but I cannot store them in a table. Can I get any suggestions?
clc
clear
raw=readtable('Small.xlsx');
model=readtable('Models.xlsx');
problem=readtable('Problems.xlsx');
raw_model=raw.Models;
raw_problem=raw.Problems;
M=height(model);
P=height(problem);
for j=1:1:M
reference1=model{j,1};
A = raw(strcmp(raw_model,reference1),2);
for i=1:1:P
reference2=problem{i,1};
B = A(strcmp(A{:,1},reference2),1);
quantity=height(B);
C = [reference1,reference2,quantity]
T(i,:)=table(C)
%above line is re-written in each iteration. I wish to store data C for all iteration
end
end
Respuesta aceptada
Más respuestas (0)
Categorías
Más información sobre Multidimensional Arrays en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!