Creating an array of maximum values from differents tables

5 次查看（过去 30 天）
Luis
Luis 2025-3-19
评论： Star Strider 2025-3-19
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.

请先登录，再回答此问题。

采纳的回答

Star Strider
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 个评论
显示 1更早的评论
Star Strider
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2023b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by