[FIXED] iterating over each row in pandas to evaluate condition

Issue

I have the following code

import pandas as pd
from pandas_datareader import data as web
import numpy as np
import math

data = web.DataReader('goog', 'yahoo')
df['lifetime'] = data['High'].asfreq('D').rolling(window=999999, min_periods=1).max() #To check if it is a lifetime high

How can i compare it so that i get a boolean (in 1 and 0 preferably) if df['High'] is close to its df['lifetime'] for each row in pandas:

data['isclose'] = math.isclose(data['High'], data['lifetime'], rel_tol = 0.003)

Any help would be appreciated.

Solution

You can use np.where()

import numpy as np
import math

data['isclose'] = np.where(math.isclose(data['High'], data['lifetime'], rel_tol = 0.003), 1, 0)

Answered By - yudhiesh