Merging several mat files in a row order

Question

Ahmet Hakan UYANIK 2021-7-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/876258-merging-several-mat-files-in-a-row-order

评论： Jan 2021-7-15

Hi everyone,

I have 65 mat files with different names and each mat file is 1x1 struct, contains information as longitude, latitude, year(335x1), month(335x1) etc.

So how can i combine them as a single mat file which should have first row as a information of first mat file, second row as a information of second mat file, until 65 rows of each mat file?

I would be very pleased if you have any idea about how to do it?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2021-7-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/876258-merging-several-mat-files-in-a-row-order#answer_744348

在 MATLAB Online 中打开

You did not explain, how a list of the files names can be obtained. I guess, that they can be found in the same folder:

Folder = 'C:\your\folder';
Files  = dir(fullfile(Folder, '*.mat'));
DataC  = cell(1, numel(Files));
for iFile = 1:numel(Files)
   aFile = fullfile(Folder, Files(iFile).name);
   DataC{iFile} = load(aFile);
end
Data = cat(2, DataC{:});

4 个评论
显示 2更早的评论隐藏 2更早的评论

Ahmet Hakan UYANIK 2021-7-11

编辑：Ahmet Hakan UYANIK 2021-7-11

Thank you Jan, seems like it merges the structs into structs again with mat files name. which looks like this;

DataC{1,3}.astoria and this contains DataC{1,3}.astoria.longitude like this and it continues as the name of mat files like DataC{1,4}.betio and to reach it's data, i also need to do DataC{1,4}.betio.longitude

That's why it give error at concatenation as names of fields in structure arrays being concatenated do not match. Concatenation of structure arrays requires that these arrays have the same set of fields.

Is it possible to merge each of them by rows like being

longitude latitude datetime observation

103.650000000000 1.23333300000000 334x1 datetime 334x1 double

103.750000000000 1.16666700000000 335x1 datetime 335x1 double

. . . .

or names of the mat files can be at first column?

I hope the way i am trying to head is clear.

Ahmet Hakan UYANIK 2021-7-14

files contains structs with a field name and with subfields of longitutde latitude datetime and observation as well. Expected output is having one mat file that each file with its subfields in a row, so that i can just call with the row order.

Has it become more clear?