Load data from mat files to a matrix

Hello! I have 50 .mat files and each of them has 4 structures inside. I want to take from .mat file the structure named ' Data'.

In this 'Data' structure, there are 4 columns. i need the last column from each data file, from each .mat file and load it in an empty matrix

for ex: 1.mat ->Numbers, Files, Names and Data -> Data = [1 2 3

4 5 6

7 8 9] -> i need the column 3 6 9 to load into a matrix in matlab as a row of it. And fill the matrix with the last columns of each data file.

Matrix=[Data1.1 Data1.2 Data1.3 ; Data2.1 Data2.2 Data2.3 ; .... ; Data50.1 Data50.2 Data50.3]

Do you know if i can do that?

Answer 1

[JESUS DAVID ARIZA ROYETH]

if your data is called 1.mat, 2.mat, 3.mat and so on, and in addition each of these data contains a structure called "Data" and in this same structure there is a field called "Data" and in this field There is a matrix of which you want the last column, so the solution is as follows:

matrix=[];
for k=1:50
    dd=load(num2str(k,'%i.mat'));
    matrix=[matrix dd.Data.Data(:,end)];
end
disp(matrix)

Espero te sea de ayuda y sea la solución de tu requerimiento

Answer 2

[Stephen23]

N = 50;
C = cell(1,N);
for k = 1:N
    F = sprintf('%d.mat',k);
    S = load(F);
    C{k} = S.Data(:,3);
end
M = [C{:}]

See also:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html