Mar 23 2022 02:57 AM - edited Mar 23 2022 04:30 AM
Hello everyone
Help required!
I have a task at hand, where the data is like below
i have column 1 (timestamp) from 00:00 (hour:min) till 24 hours and column 2 (binary) containing 0 or 1. There are about 100,000 rows. Example table below:
Timestamp | Binary |
0.00 | 0 |
0:01 | 0 |
0:02 | 1 |
0:03 | 0 |
0:04 | 1 |
what i want is:
I want to see if there is 1 (2nd column) for10 mins consecutively. if found, i would like to remove them from the entire table
How can i go about solving it