How to select and loop variables in a filename

1 次查看（过去 30 天）
Sammy
Sammy 2022-8-2
评论： 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
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
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. (:

请先登录，再进行评论。

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

回答（1 个）

Shree Harsha Kodi
Shree Harsha Kodi 2023-6-17
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);
  1 个评论
Sammy
Sammy 2023-6-18
Hi Shree! I figured this one out a year ago when I made monthly climatological means. But thanks!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Weather and Atmospheric Science 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by