Forum Discussion
fkhan59
Mar 23, 2022Copper Contributor
Timestamp data: deleting rows based on multiple conditions
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
No RepliesBe the first to reply