how to convert data from minute to hourly average

5 次查看（过去 30 天）
SD
SD 2018-3-16
评论： SD 2018-3-17
this is the extension of my file which needs to be converted.this is the sample data.there are individual files for each day consisting of 1440 rows and 4 columns.this file is to be read in matlab and processed for 4 years. i need to average the time and data i.e, first two columns of the given table.there are some missing data in which the data is missing but the time is recorded.any program can solve my data.thanks in advance
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2018-3-16
dir1 = 'path_to_folder_with_your_txt_files';
f = dir(fullfile(dir1,'iisc*.txt'));
nm = {f.name}';
dt = datetime(regexp(nm,'\d{4}-\d{2}-\d{2}','match','once'));
TT = [];
for ii = 1:numel(dt)
T = readtable(fullfile(dir1,nm{ii}),'Format','%f%f%f%f','TreatAsEmpty','-');
Time1 = dt(ii) + hours(T.Var1);
TT = [TT;timetable(Time1,T.Var2,'v',{'data'})];
end
TTout = retime(TT,'hourly','mean');
TTout = TTout(~isnan(TTout.data),:);
  7 个评论
显示 5更早的评论
SD
SD 2018-3-17
sir,can you tell me how to save the output into a seperate folder for which you have given the previous answer.
SD
SD 2018-3-17
how to do monthly average for the each hour of the seperate day. eg: monthly average of (01/01/2012 0.00 hr,01/02/2012 0.00hr,02/01/2012 0.00hr ............31/01/2012) and also daily average for day time of the universaltime average and night time also

请先登录，再进行评论。

更多回答（1 个）

KSSV
KSSV 2018-3-16
YOu can load the text file using load or importdata. To egt hourly mean check the below example code.
t = 1:24*60 ; % time in minutes
A = rand(1,numel(t)); % some random data for 1440 minutes
% Arrange indices into hours
idx = reshape(1:24*60,60,[])' ;
% Arrange data into hours
A_hours = A(idx) ;
% GEt mean
A_hourly_mean = mean(A_hours,2) ;
  2 个评论
SD
SD 2018-3-16
sir, i tried your suggested program. but i am getting the random values in the range of 0 & 1.but i need the mean of the data.
KSSV
KSSV 2018-3-16
A is random data I have taken to demonstrate. You have to used your data.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by