How to store vector in a loop and print into excel file all at once?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I want to write all the R at once into a excel file. I have been trying different method below loop just write the last results. Any Idea what mistake I am doing?
L = length(y_train_corr(1,:));
R = corrcoef(y_train_corr(:,2),y_train_corr(:,3));
Es = cell(L-2,1);
for i = 1:L-2
R= corrcoef(y_train_corr(:,2),y_train_corr(:,2+i));
Es{i} = R;
end;
xlswrite('train_corr_coeff.xlsx',R);
0 commentaires
Réponse acceptée
KSSV
le 29 Juin 2020
Modifié(e) : KSSV
le 29 Juin 2020
You are wrtitng R in the xlswrite command. Replace R with Es.
L = length(y_train_corr(1,:));
R = corrcoef(y_train_corr(:,2),y_train_corr(:,3));
Es = cell(L-2,1);
for i = 1:L-2
R= corrcoef(y_train_corr(:,2),y_train_corr(:,2+i));
Es{i} = R;
end;
xlswrite('train_corr_coeff.xlsx',Es);
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB 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!