Timestamp data: deleting rows based on multiple conditions

Copper Contributor

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:

TimestampBinary

0.00

0
0:010
0:021
0:030
0:041

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

0 Replies