MATLAB Answers

how to count daily events from a time series data

18 views (last 30 days)
i have a time series data contains year, month, day, hours, and earthquke . how will i count number of earthquake daily

  2 Comments

Andrei Bobrov
Andrei Bobrov on 4 Sep 2019
Attach here small part your data as 'mat' file.
Reformat your data in timetable and use function retime.

Sign in to comment.

Accepted Answer

Akira Agata
Akira Agata on 20 Sep 2019
How about the following?
% Read your text data file
T = readtable('test.txt');
% Create datetime vector
Time = datetime(T.year,T.month,T.day,T.hrs,T.mins,T.sec);
% Calculate daily counts
TT = timetable(Time,ones(size(Time)),'VariableNames',{'Count'});
TT = retime(TT,'daily','sum');

  0 Comments

Sign in to comment.

More Answers (1)

BATAKRUSHNA SENAPATI
BATAKRUSHNA SENAPATI on 20 Sep 2019
here i attach my txt file below

  0 Comments

Sign in to comment.

Sign in to answer this question.

Tags