有一个dataframe生成代码如下
import pandas as pd
import numpy as np
dates = [i for i in range(1,26)]
df = pd.DataFrame(np.arange(75).reshape(25,3),index=dates, columns=['A', 'B','C'])
df.loc[5,['A']] = 20
df.loc[6,['A']] = 20
df.loc[6,['B']] = 33
df.loc[16,['A']] = 64
df.loc[16,['B']] = 65
df.loc[17,['A']] = 64
df.loc[17,['B']] = 65
df.loc[8:14,'A'] = 20 # 连续重复
df.loc[1:25,'B'] = [ i for i in range(1,26)] # 连续重复
df.loc[9,'B'] = 10
df
A B C
1 0 1 2
2 3 2 5
3 6 3 8
4 9 4 11
5 20 5 14
6 20 6 17
7 18 7 20
8 20 8 23
9 20 9 26
10 20 10 29
11 20 11 32
12 20 12 35
13 20 13 38
14 20 14 41
15 42 15 44
16 64 16 47
17 64 17 50
18 51 18 53
19 54 19 56
20 57 20 59
21 60 21 62
22 63 22 65
23 66 23 68
24 69 24 71
25 72 25 74
其中B列为时间列,如何将其按A列进行分组获取 各组分组后C列值连续(连续2/3/4/5/6帧)大于分组后C列均值且B列时间列前后相差1秒的 次数