how to average the minutes data to hourly data if the data is missing for some minutes(samples) in between

5 views (last 30 days)
hi everyone,
I am having data every two minutes time interval with the format
9/10/2013 4:00 721.19141 4.999999523 0 35.29541 -300 -0.011333227
9/10/2013 4:02 721.67969 4.999999523 0 35.43457 -300 0.561000109 ....
Now i would like to average the data to each hour and save.
Now the problem is there are some data missing. how to overcome this problem??
date and time are in same column, the remaining data are in different columns.
please see attached file

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 3 Jun 2015
n = xlsread('Book1.xlsx');
n(:,1) = n(:,1) + datenum('30.12.1899','dd.mm.yyyy');
[Y,M,D,H] = datevec (n(:,1));
[c0,~,c1] = unique([Y,M,D,H],'rows');
[ii,jj] = ndgrid(c1,1:size(n,2)-1);
mm = accumarray([ii(:),jj(:)],reshape(n(:,2:end),[],1),[],@mean);
out = [c0, mm];
  4 Comments

Sign in to comment.

More Answers (1)

Ingrid
Ingrid on 3 Jun 2015
first read in the excel data in matlab then use datenum on the first column to get the date in matlab use histc and accumarray to get the average data per hour

Community Treasure Hunt

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

Start Hunting!