这将完成工作：

ones = df.groupby('Count').groups[1].tolist()
# creates a list of the indices with a '1': [0, 2, 3, 6, 7, 8]
event_id = [0] * len(df.index)
# creates a list of length 10 for Event_ID with all '0'

# find consecutive numbers in the list of ones (yields [2,3] and [6,7,8]):
for k, g in itertools.groupby(enumerate(ones), lambda ix : ix[0] - ix[1]):
  sublist = list(map(operator.itemgetter(1), g))
  if len(sublist) > 1:
    for i in sublist:
      event_id[i] = len(sublist)-1    
# event_id is now [0, 0, 1, 1, 0, 0, 2, 2, 2, 0]   

df['Event_ID'] = event_id

for循环改编自this example（使用itertools，也可以使用其他方法）。

col1=(df1['Count'].diff().ne(0)&df1['Count'].ne(1)).cumsum().mul(df1.Count)
df1.assign(flag=col1)

输出：

Period  Count  flag
0       1      1   0.0
1       2      0   0.0
2       3      1   1.0
3       4      1   1.0
4       5      0   0.0
5       6      0   0.0
6       7      1   2.0
7       8      1   2.0
8       9      1   2.0
9      10      0   0.0