问如果数据中的前两个值小于数据中的第三个值，如何过滤数据框中返回值的条件？

EN

# get a list of all quarters, will make things easier later
quarters = df['quarter'].values.tolist()

# define windowing function
# True = last quarter in a 4 quarter window that matches your criteria
# False = all others
def check_quarter(quarter):
    q_index = quarters.index(quarter)
    window = quarters[q_index-3: q_index+1]
    sales = df[df['quarter'].isin(window)]['sales'].values.tolist()
    if len(sales) == 4 and sales[1] < sales[0] and sales[3] > sales[2]:
        return True
    return False

# assign bools to new column
df['check'] = df['quarter'].apply(check_quarter)

# select quarters
df[df['check'] == True]['quarter']