How can I combine multiple matfile containing row vector in one table

2 次查看（过去 30 天）

Yared Daniel 2021-6-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865400-how-can-i-combine-multiple-matfile-containing-row-vector-in-one-table

评论： Nikhil Sapre 2021-6-26

I have several dot matfile containing row vector and I want them to put in one table sequentially (according to alphabetic order of the file name).

I tried the following script which I found in Math works, it combines all the files in one table, however when I use it for more number files it do not work sequentially and I faced difficulty to identify which row corresponds to which file.

clear

FileList = dir('As*.mat');

DataC = cell(1, numel(FileList));

for iFile = 1:numel(FileList)

FileData = load(FileList(iFile).name);

DataC{iFile} = FileData.X;

end

DataM = cat(1, DataC{:});

I have attached sample dot mat files

Thank You for response

7 个评论
显示 5更早的评论隐藏 5更早的评论

Stephen23 2021-6-26

编辑：Stephen23 2021-6-26

在 MATLAB Online 中打开

A more robust solution that does not assume that the files were created/modified in the filename order:

https://www.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort

For example:

P = 'absolute or relative path to where the files are saved';
S = dir(fullfile(P,'As*.mat'));
S = natsortfiles(S);
for k = 1:numel(S)
    F = fullfile(P,S(k).name);
    D = load(F);
    S(k).X = D.X;
end
DataM = cat(1, S.X); 

Nikhil Sapre 2021-6-26

Thanks. This is a better solution. I didn't know of the natsortfile function.

请先登录，再进行评论。

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

采纳的回答

Nikhil Sapre 2021-6-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865400-how-can-i-combine-multiple-matfile-containing-row-vector-in-one-table#answer_733835

编辑：Nikhil Sapre 2021-6-25

在 MATLAB Online 中打开

Hi Yared,

Can you check if the order is correct in the variable FileList. My guess is the problem happens because the sorted order would be As(1), As(10), As(2) etc .. when using the dir function

A workaround would be to sort it based on date created. This code should fix it, assuming your files were created in the order they are named. .

FileList = dir('As*.mat');
DataC    = cell(1, numel(FileList));
[~,idx] = sort([FileList.datenum]);
for iFile = 1:numel(idx)
  FileData     = load(FileList(idx(iFile)).name);
  DataC{iFile} = FileData.X;
end
DataM = cat(1, DataC{:}); 