python判断某列有值,检查一列中的值是否在Python中另一列的间隔值中

I have the following dataframe:

import pandas as pd

import numpy as np

data = {

"index": [1, 2, 3, 4, 5],

"v1": [1100, 1776, 1228, 1640, np.NaN],

"v2": [1000, 1805, 1231, 1425, 1800],

"result": ['Y', 'Y', 'Y', 'N', 'N']

}

df = pd.DataFrame.from_dict(data)

print(df)

I would like to check if column v1 is in interval of column v2 ± 100 (or [v2*0.95, v2*1.05]). How can i do it in Python? thanks for your help. Here is my final result example:

index v1 v2 result

0 1 1100.0 1000 Y

1 2 1776.0 1805 Y

2 3 1228.0 1231 Y

3 4 1640.0 1425 N

4 5 NaN 1800 N

解决方案

For v1 in [v2*0.95, v2*1.05] use:

df['res'] = ''

for idx, val in enum