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