Finding time difference that meet criteria
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hi guys
I need to compare two columns of data with each other. They are all in time format 00:00:00. I need to group them groups of two which are 20 seconds apart from each other and put the ones meeting the criteria in separate column. it could be 20 seconds before or after each other.
As an example, these consider two columns A and B columns. for example, the first row meets the criteria because it has 2 seconds difference in time which is less than 20.
I would appreciate any help. Thanks in advance!
A B
05:49:13 05:49:15
05:52:41 05:52:42
08:39:43 09:20:44
09:35:52 09:35:52
09:58:14 09:58:27
10:00:11 10:00:02
10:16:48 10:16:41
12:20:08 12:20:08
12:37:41 12:37:53
12:41:09 12:40:54
12:46:20 12:46:32
12:48:18 12:48:19
2 Commenti
jonas
il 8 Lug 2020
identifying those pairs is trivial, but what exactly do you mean by putting them in separate columns? Could you just delete those which do not meet the criterion?
Risposte (1)
jonas
il 8 Lug 2020
First make sure your data is in duration format.
%making up some data
t1 = (hours(10):hours(2):hours(24))';
t2 = t1 + rand(numel(t1),1).*seconds(40);
t = [t1,t2];
t.Format = 'hh:mm:ss';
%find time difference less than 20 s
id = abs(t1-t2)<seconds(20);
% remove pairs not meeting criterion
t(~id,:) = []
3 Commenti
jonas
il 9 Lug 2020
Okay, better provide some real data then. Can there for example be multiple matches in B to one element in A?
Vedere anche
Categorie
Scopri di più su Loops and Conditional Statements in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!