MATLAB Answers

0

How to identify entries for a time frame?

Asked by Faustino Quintanilla on 24 Apr 2019
Latest activity Answered by Peter Perkins
on 24 May 2019
I am trying to find the duplicate entries that occured within a 5 mintute duration. I have over 9,000 entries for over 1 year time frame. Here is a sample of the data:
Start Date Citrcuit Cause Location Bay
1) 2/6/2019 09:01:00 AC122 OOO AC 2
2) 12/26/2018 11:02:00 AC122 PPP AC 2
3) 9/29/2018 13:14:00 AC123 CCC AC 2
4) 9/29/2018 13:13:00 AC124 CCC AC 2
Result that i am looking for is that Maltab would identfiy the location of AC had 2 entries within a 5 minute window.

  0 Comments

Sign in to comment.

1 Answer

Answer by Peter Perkins
on 24 May 2019

The data in your example are VERY sparse, and it's hard to know if that's typical or not.
One very simple way to do what you want is to create a timetable, and retime it to a regular 5 minute time steps using @numel as the aggregation function. But there are 105120 5 minute intervals in one year, and if your data are typicalp, you'd be making a result that mostly had zeros in it.

  0 Comments

Sign in to comment.