How to take hourly average from 15 minutes random data.

1 次查看（过去 30 天）
varunesh
varunesh 2016-9-7
评论： varunesh 2016-9-7
I have 15 minutes time interval data but data is not continuous some time he gives 3 values in a hour and some time 2 values in a hour. So this is difficult for me make a code to convert this in a hourly data. I am also attaching time matrix, which is indicate the time for observing the data. Please help me. Thank you in advance.
  2 个评论
Andrei Bobrov
Andrei Bobrov 2016-9-7
Sorry my Octave-4.0.3 don't open your file as so him made in MATLAB 5 - very old relise. Please attach your data in .xlsx or .txt file.

请先登录，再进行评论。

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

回答（1 个）

Andrei Bobrov
Andrei Bobrov 2016-9-7
d = xlsread('data1.xlsx',1,'A2:B1147');
d0 = datevec(d(:,1) + datenum([1900 1 -1]));
[a,b,c] = unique(d0(:,1:4),'rows','first');
hourly_data = [a, accumarray(c,d(:,2),[],@mean)];
  1 个评论
varunesh
varunesh 2016-9-7
when I am running last line of this code then i got this error.
Index exceeds matrix dimensions.
did you saw time variable or not??
I mean this
Time
7/6/2016 15:30
7/6/2016 15:45
7/6/2016 16:00
7/6/2016 16:15
7/6/2016 16:30
7/6/2016 16:45
7/6/2016 17:00
7/6/2016 17:15

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by