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.

[Walter Roberson]

    C5C = table2array(s(:,5));

Easier is

    C5C = s{:,5};

or

    C5C = s.(5);

Answer 1

[Star Strider]

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.

.

[Luis]

Yes, I have all the .csv in default path.

Thanks for the help.

[Star Strider]

As always, my pleasure!

[Star Strider]

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.

.