查找值在起始值和结束值之间的位置，并添加列python

import pandas as pd

# 创建一个示例数据集
data = {'Value': [10, 20, 30, 40, 50]}
df = pd.DataFrame(data)

# 设置起始值和结束值
start_value = 20
end_value = 40

# 查找起始值和结束值之间的位置
start_index = df[df['Value'] == start_value].index[0]
end_index = df[df['Value'] == end_value].index[0]

# 添加列
df['New Column'] = pd.Series(range(start_index, end_index + 1))

# 打印结果
print(df)