Creating an array of maximum values from differents tables
显示 更早的评论
I have 5 tables 2000x5 and want to create an array consisting of maximum values from the column 5 of all tables. This was my attempt:
for N_arq = [23 21 19 17];
s = readtable(strcat('r',num2str(N_arq),'.csv'),'Headerlines',1);
C5C = table2array(s(:,5));
AC = max(C5R(300:end))
end
But, this overwrite the last data on AC and don't create the desired array.
1 个评论
Walter Roberson
2025-3-19
C5C = table2array(s(:,5));
Easier is
C5C = s{:,5};
or
C5C = s.(5);
采纳的回答
Star Strider
2025-3-19
Your current code creates the variable ‘CSC’ and then takes the maximum of selected rows of ‘C5R’. I changed that, although nothing else.
I assume all the .csv files are already available in your default path.
Try this —
N_arqv = [23 21 19 17];
for k = 1:numel(N_arqv)
N_arq = N_arqqv(k)
s = readtable(strcat('r',num2str(N_arq),'.csv'),'Headerlines',1);
C5C = table2array(s(:,5));
AC(k,:) = max(C5C(300:end))
end
Result = table(AC, VariableNames=["Col 5 Maximum"])
Make appropriate changes to get the desired result.
.
3 个评论
Luis
2025-3-19
Star Strider
2025-3-19
As always, my pleasure!
Star Strider
2025-3-19
A tweak —
N_arqv = [23 21 19 17];
for k = 1:numel(N_arqv)
N_arq = N_arqqv(k)
rn{k} = sprintf('r%d',N_arq);
s = readtable(strcat('r',num2str(N_arq),'.csv'),'Headerlines',1);
C5C = table2array(s(:,5));
AC(k,:) = max(C5C(300:end))
end
Result = table(AC, VariableNames={'Col 5 Maximum'}, RowNames=rn)
This gives each file (without the .csv extensiion, although you can add that if you want) as its appropriate row name in the ‘Results’ table. I just now thought to include that.
.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
