Info

此问题已关闭。 请重新打开它进行编辑或回答。

grouping measures by time

1 次查看（过去 30 天）
Valerio
Valerio 2014-1-30
关闭： MATLAB Answer Bot 2021-8-20
I have a problem to extract data from a cell array.
The array has 4 columns:
1 - date (ex. '27-May-2013') 2 - time (ex. '09:47:39') 3 - category (1-36) 4 - measures
I need to separate the 36 categories and sum the measures every 10 minutes.
The frequency acquisition is not constant (approximately one measure/10 seconds). I tried to make the sum of the measures every 10 minutes (00:10:00), but I am not able to obtain a constant grouping at perfectly 00:10:00.
It is not a problem if I will have different numbers of measures in each 10 minutes interval, but the interval need to be exactly 00:10:00.
Do you have any suggestions?
Thank you

此问题已关闭。

回答（1 个）

Amit
Amit 2014-1-30
Your cell column 1 and 2 represent date and time. you can use datenum to determine time difference. for example (assuming you cell array is named A):
formatIn = 'dd-mmm-yyyy HH:MM:SS'; % I am assuming the months are 3 letters only
time_in = datenum([A{1,1} ' ' A{1,2}],formatIn); % This will give you a numerical value
time_2 = datenum([A{i,1} ' ' A{i,2}],formatIn); % This will give you a numerical value
You have to loop through until
(time_2 - time_in)*24*60 <= 10
For more about datenum: http://www.mathworks.com/help/matlab/ref/datenum.html

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by