How to create a loop and store the outputs from table?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have extracted the data from the perticular strata from the following code;
T = readtable('Dataset.xlsx');
n = length(T.Strata)
for i=1:n
if isnan(T.Strata(i))
T.Strata(i) = T.Strata(i-1);
end
end
data=T(T.Strata==3,1:end-1)
% Say: Strata 1 has one row of data, but strata 3 has two rows of data. So, if i recall the data from strata 3, it will read the whole data of strata 3 with the help of above code.
Now further, I have to calculate one more parameter whose formula is given below:
x= ∑ N1 * S1
Where N1 is the number of elements in respective strata and S is the stadard deviation of respective strata.
So, I have to create one loop, in which both the variables get its values respectively without assigning values manually. Or store the ouput according strata.
I have attached the "dataset" for reference.
1 commentaire
Stephen23
le 29 Avr 2023
None of Strata are NaN, so what is the loop actually supposed to achieve?
T = readtable('Dataset.xlsx');
any(isnan(T.Strata))
Rather than that loop, use:
with 'previous' option.
Réponses (0)
Voir également
Catégories
En savoir plus sur Data Type Conversion 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!