python pandas 数据查找_Python Pandas：在数据帧中查找模式

我假设您的输出需要一个具有起始值和结束值的序列列表。你在照片中识别的第二个序列的距离小于40，所以我也假设这是一个错误。在import pandas as pd

from collections import namedtuple

df_test_2 = pd.DataFrame({"A":["end","beginn","end","end","beginn","beginn","end","end","end","beginn","end"],"B":[1,10,50,60,70,80,90,100,110,111,112]})

sequence_list = []

Sequence = namedtuple('Sequence', ['beginn', 'end'])

beginn_flag = False

beginn_value = 0

for i, row in df_test_2.iterrows():

state = row['A']

value = row['B']

if not beginn_flag and state == 'beginn':

beginn_flag = True

beginn_value = value

elif beginn_flag and state == 'end':

if value >= beginn_value + 40:

new_seq = Sequence(beginn_value, value)

sequence_list.append(new_seq)

beginn_flag = False

print(sequence_list)

此代码输出以下内容：

^{pr2}$

两个序列，一个从10开始到50结束，另一个从70开始到110结束。在