I have the dataframe
| ID | filter1 | filter2 |
|---|---|---|
| 0 | False | False |
| 1 | False | True |
| 2 | False | False |
| 3 | True | False |
| 4 | False | False |
| 5 | False | True |
| 6 | True | True |
| 7 | True | False |
| 8 | True | False |
| 9 | False | False |
| 10 | False | False |
| 11 | False | False |
| 12 | False | True |
I want to find each sequence with filter1=True and the successive filter2=True
The expected output is:
| ID | filter1 | filter2 | EXPECTED_RESULT | description |
|---|---|---|---|---|
| 0 | False | False | False | |
| 1 | False | True | False | There is no True before in filter1 |
| 2 | False | False | False | |
| 3 | True | False | False | The start condition |
| 4 | False | False | False | |
| 5 | False | True | True | Close condition from ID=3 |
| 6 | True | True | True | In same row |
| 7 | True | False | False | Here is the start condition |
| 8 | True | False | False | Here is the start condition – we start again |
| 9 | False | False | False | |
| 10 | False | False | False | |
| 11 | False | False | False | |
| 12 | False | True | True | Close condition from ID=8 |