How to calculate the hourly data points?

Hi everyone,

May someone help me here ..

I have a long data in time-date formate i.e. six columns YYYY MM DD HH MM SS. Each time values indicate an observation. I want to calcualte the number of observations per hours. It is importanmt to mentioned that frequency of observations is uneven i.e. 10 or 100 obsservation per hour and no observation for a couple of days. So the output must account the missing time as well wehre there is no observation recorded.

Thank You!

[KSSV]

Let the given date be t1.

Geenerate the dates required from start to end of the data with hourly difference. Let this be t2.

Then get the indices you want from t1 using ismember.

[aa]

Thank you let me try this ... might be it will works but still i am not sure how this give me the event per data .. Ismember is something different from counts/hour ... I think so ,,, not sure ..

Answer 1

[Ameer Hamza]

Try retime():

T = readtable('data.xlsx');

t = datetime(T.YYYY, T.MM, T.DD, T.HH, T.MM_1, T.SS);
TT = timetable(t, ones(size(t)));
newTT = retime(tt, 'hourly', 'sum');

newT = table(newTT.t, newTT.Var1, 'VariableNames', {'Time', 'count'});

[aa]

I try this but there is an error

Attempt to reference field of non-structure array.

Error in Untitled (line 2)

t = datetime(T.YYYY, T.MM, T.DD, T.HH, T.MM, T.SS);

[Ameer Hamza]

.Can you show your code exactly? Which MATLAB release are you using?

[aa]

2013a..

T = xlsread('data.xlsx');

t = datetime(T.YYYY, T.MM, T.DD, T.HH, T.MM, T.SS);

TT = timetable(t, ones(size(t)));

newTT = retime(tt, 'hourly', 'sum');

newT = table(newTT.t, newTT.Var1, 'VariableNames', {'Time', 'count'});

[Ameer Hamza]

The functions used in my code are not available in R2013a. Solution for R2013a will be more difficult.

[aa]

Thank you for guidence .. let me update my Matlab

[Peter Perkins]

Ameer solution is the right one, but actually, there's not really any need to turn newTT back into a table. You can leave it as a timetable.