作者:祥荣华贵 | 来源:互联网 | 2023-09-05 17:32
I have a matrix called total_warnings
我有一个名为total_warnings的矩阵
row day Tx Hx Tn
36 36 5 32.5 37.78 16.3
41 41 10 33.3 41.46 20.5
42 42 11 31.7 41.57 21.2
43 43 12 31.3 39.03 22.2
45 45 14 29.1 37.34 19.0
55 55 24 33.7 41.77 16.4
56 56 25 29.3 38.07 15.9
58 58 27 35.0 41.07 15.3
59 59 28 34.3 40.37 18.5
61 61 30 33.5 40.34 14.9
65 65 4 31.0 37.24 11.4
72 72 11 32.6 40.00 16.2
73 73 12 33.8 40.25 16.8
74 74 13 34.7 41.04 18.6
76 76 15 31.4 39.47 18.4
77 77 16 27.7 37.30 18.4
78 78 17 27.9 38.36 22.3
79 79 18 32.9 42.07 20.1
82 82 21 32.0 38.62 19.3
93 93 1 28.6 37.55 18.1
94 94 2 30.3 39.71 15.3
95 95 3 32.7 39.46 17.5
101 101 9 33.0 39.00 17.4
104 104 12 27.5 37.10 16.7
135 135 12 32.6 38.45 17.7
What I'm attempting to do is indentify the contents of the row ONE AFTER three or more consecutive rows. For example 41, 42, 43 are three consecutive rows, I would like to call the contents of row 45!
我试图做的是在三个或更多连续行之后识别行ONE的内容。例如41,42,43是连续三行,我想调用第45行的内容!
45 14 29.1 37.34 19.0
So for this example rows 45, 82, 101 would be returned. If the row after the three or more consecutive rows is part of another set of TWO or more consecutive rows I DO NOT need to know the contents. For example 72, 73, 74 is a set but I do not want row 76 because it is part of another set 76, 77, 78, 79!
因此,对于该示例,将返回行45,82,101。如果三个或更多连续行之后的行是另一组两个或更多个连续行的一部分,则我不需要知道内容。例如72,73,74是一组,但我不想要第76行,因为它是另一组76,77,78,79的一部分!
Thanks for the help in advance! Nick
我在这里先向您的帮助表示感谢!缺口
1 个解决方案