Multiple datasets to single table

Question

Joost de Witte 2019-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494781-multiple-datasets-to-single-table

回答： Jakob B. Nielsen 2019-12-4

Hello all,

I've got a large number of datasets.mat. I've writen a script that calculates averages of a single dataset which results in one single value for the loaded data set. The datasets are identical and when I change the loaded file name from data1 to data2 for example it still works as desired.

I now want to gather all these averages into one table, but have to clue on how to approach this problem (matlab novice). Any help will be appreciated, thanks!

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

请先登录，再进行评论。

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

Answer 1

Jakob B. Nielsen 2019-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494781-multiple-datasets-to-single-table#answer_404681

在 MATLAB Online 中打开

You can try using something like this.

[Names,Paths]=uigetfile('*.mat','MultiSelect','on'); 
entirefile =fullfile(Paths,Names); %entirefile is now a cell array containing the path of all your files
average=zeros(numel(entirefile),1); %initialise an array of 0's
for i=1:numel(entirefile)   %automatically repeats the sequence a number of times equal to the number of files you picked
    tempdata=load(entirefile{i});  %use curly brackets when indexing cells :) 
    average(i)=callyourfunction(tempdata); 
end
Overview=table(Names',average);   %Names is a row vector, so add the ' to turn it into a column. 
%Now you should have a table showing you the data file name and its corresponding average value. 