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

1 次查看（过去 30 天）
reddy
reddy 2015-6-3
评论： reddy 2015-6-16
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

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2015-6-3
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 个评论
显示 2更早的评论

请先登录，再进行评论。

更多回答（1 个）

Ingrid
Ingrid 2015-6-3
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

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by