How to select and loop variables in a filename

Question

Sammy 2022-8-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1772490-how-to-select-and-loop-variables-in-a-filename

评论： Sammy 2023-6-18

I have monthly files with 2 variables: sst (jan_sst03) and time(jan_dt03) per file, how do I loop all my files such that it will take the mean of the sst variable only?

2 个评论
显示无隐藏无

Walter Roberson 2022-8-2

编辑：Walter Roberson 2022-8-2

Are those mat files? xlsx?

Does the name of the variable change in each file? So the substring "sst" needs to be checked for?

Sammy 2023-6-15

编辑：Sammy 2023-6-18

I figured this one out already. By making a timeseries of the files (jan2003-dec2022) (the names of the variable does not change). Then, using the time variable to find the duration or period to average the sst variable by, e.g. idx=find(mo==1), I can now average all the january months, making my january monthly climatology. (:

请先登录，再进行评论。

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

Answer 1

Shree Harsha Kodi 2023-6-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1772490-how-to-select-and-loop-variables-in-a-filename#answer_1257894

在 MATLAB Online 中打开

Folder = 'path_to_folder'; % Specify the folder containing your files
files = dir(fullfile(folder, '*.mat')); % Get a list of all .mat files in the folder
means = [];
for i = 1:numel(files)
    data = load(fullfile(folder, files(i).name)); % Load the data from the file
    sst = data.sst; % Extract the "sst" variable from the loaded data
    
    mean_sst = mean(sst); % Calculate the mean of the "sst" variable
    
    means = [means mean_sst]; % Store the mean value in the array
end
% Display the mean values
disp(means);