有效地检查一列中的值是否属于另外两列定义的阈值

import pandas as pd

# 创建示例DataFrame
data = {
    'value': [10, 20, 30, 40, 50],
    'lower_threshold': [15, 25, 35, 45, 55],
    'upper_threshold': [25, 35, 45, 55, 65]
}
df = pd.DataFrame(data)

# 检查'value'列中的值是否在'lower_threshold'和'upper_threshold'之间
df['within_threshold'] = df['value'].between(df['lower_threshold'], df['upper_threshold'])

print(df)

   value  lower_threshold  upper_threshold  within_threshold
0      10               15               25              False
1      20               25               35              False
2      30               35               45              False
3      40               45               55              False
4      50               55               65              False