how to change data from 10 minutes to hour?

Question

Jan Risn 2019-5-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/460858-how-to-change-data-from-10-minutes-to-hour

评论： Jan Risn 2019-7-8

采纳的回答： Andrei Bobrov

I have data

x =

01/02/2015 02:20 4

02/02/2015 2:30 2

01/02/2015 02:50 0

01/02/2015 08:50 8

01/02/2015 03:00 7

01/02/2015 03:10 9

02/02/2015 3:30 4

02/02/2015 3:40 6

02/02/2015 03:50 8

...

the first step I want to normalize starts from the initial hour (2:00)

and generate data per 10 minutes with empty data filled with Nan

the second step I want to change it to average data per hour ... so that i get hourly data on each date ...

I have tried many times but this doesn't work ..

I thank all those who gave advice and were kind enough to help me.

2 个评论
显示无隐藏无

Jan Risn 2019-5-8

01/02/2015 02:20 4

02/02/2015 2:30 2

01/02/2015 02:50 0

01/02/2015 08:50 8

01/02/2015 03:00 7

01/02/2015 03:10 9

02/02/2015 3:30 4

02/02/2015 3:40 6

02/02/2015 03:50 8

KSSV 2019-5-8

Read about interp1.

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2019-5-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/460858-how-to-change-data-from-10-minutes-to-hour#answer_374068

编辑：Andrei Bobrov 2019-5-8

data.txt

In R2016b:

T = readtable('data.txt','ReadVariableNames',false,'Format','%q %q %f');
TT = sortrows(timetable(T.Var3,'RowTimes',...
    datetime(strcat(T.Var1,'_',T.Var2),'I','dd/MM/uuuu_HH:mm')));
dt = dateshift(TT.Time(1),'start','hour'):...
    minutes(10):dateshift(TT.Time(end),'end','hour');
TT1 = retime(TT,dt);% data per 10 minutes
TT2 = retime(TT,'hourly','mean');% average data per hour

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan Risn 2019-7-8

在 MATLAB Online 中打开

thank you for the advice given. but I use matlab 2014a so there is no retime function.

can you help me improve the program script that I have created. I feel difficulties with the accumulation function.

 times = record;
    dn = datenum(times);
    min_time = min(dn);
    min_time_dv = datevec(min_time);
    min_time_dv(5) = floor(min_time_dv(5) / 10) * 10;  
    first_slot_dn = datenum(min_time_dv);
    max_time = max(dn);
    max_time_dv = datevec(max_time);
   max_time_dv(5) = floor(max_time_dv(5) / 10) * 10;  
    last_slot_dn = datenum(max_time_dv);
    ten_mins_as_days = 1 / (24 * 60/10);
    
    %%%%% get time per 10 minutes
    slot_dns = first_slot_dn : ten_mins_as_days : last_slot_dn;
    slot_ds = datestr(slot_dns);
    times_minutes = [cellstr(slot_ds(1:end,:))];
    slot_ds = datestr(slot_dns);
    [~, slot_idx] = histc(dn, slot_dns);
    
    %%% mean RR
    mean_RR = accumarray(slot_idx, RR(:), [length(slot_dns)-1,1], @mean, nan);
    output = [cellstr(slot_ds(1:end-1,:)), num2cell(mean_RR)];