how to count daily events from a time series data

i have a time series data contains year, month, day, hours, and earthquke . how will i count number of earthquake daily

[Andrei Bobrov]

Attach here small part your data as 'mat' file.

Reformat your data in timetable and use function retime.

[BATAKRUSHNA SENAPATI]

here i attach format of my data below

Answer 1

[Akira Agata]

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');

Answer 2

[BATAKRUSHNA SENAPATI]

here i attach my txt file below