How to combine multiple tables from diffrent folders and save as on table?

Question

Tomaszzz 2022-3-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1667954-how-to-combine-multiple-tables-from-diffrent-folders-and-save-as-on-table

回答： Voss 2022-3-11

采纳的回答： Voss

在 MATLAB Online 中打开

Hi all,

I have 20 folders with mutiple mat files which are 1 x 1 structures with a 1 x 54 table.

I managed to list all folders and all files. I can also load each mat files in a loop as below.

for k = 1:numel(file_list)
    if isempty(file_list{k})
        continue
    end
    disp(file_list{k}.name)
    A  = fullfile(topLevelFolder,subFolders(k).name,file_list{k}.name);
    data = load(A);
end

Now, I want to consecutively save each table with an end result a single 20x54 table (mat or csv) . For example:

End table:

Row 1: row 1 from table 1

Row 2: row 1 from table 2

Row 3: row 1 table 3

and so on

Can you help please?

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

请先登录，再进行评论。

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

Answer 1

Voss 2022-3-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1667954-how-to-combine-multiple-tables-from-diffrent-folders-and-save-as-on-table#answer_914934

在 MATLAB Online 中打开

t = {};
for k = 1:numel(file_list)
    if isempty(file_list{k})
        continue
    end
    disp(file_list{k}.name)
    A  = fullfile(topLevelFolder,subFolders(k).name,file_list{k}.name);
    data = load(A);
    t{end+1} = data.your_table_in_A;
end
t = vertcat(t{:});