I have a 10000×2 dataset and I need to detect occurrences when the two values repeat at least 3 times in a row. For example:
200,1300,2400,1400,1400,1200,2300,1300,2300,2300,2300,2400,2
Should identify the two times that the values of both columns repeated at least 3 times (400,1 and 300,2). The values of each column don't matter, what I am looking for are situations when both columns in a row repeat over at least 3 times in a row. Very much appreciate any advice.
Best Answer