How to create a loop and store the outputs from table?

3 次查看（过去 30 天）

显示更早的评论

Rahul Verma 2023-4-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1955029-how-to-create-a-loop-and-store-the-outputs-from-table

评论： Stephen23 2023-4-29

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

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2023-4-29

在 MATLAB Online 中打开

Dataset.xlsx

None of Strata are NaN, so what is the loop actually supposed to achieve?

T = readtable('Dataset.xlsx');
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
any(isnan(T.Strata))
ans = logical
   0