how to apply a function to each row in pandas code example
Example 1: pandas apply function to each row lambda
def EOQ(D,p,ck,ch):
Q = math.sqrt((2*D*ck)/(ch*p))
return Q
ch=0.2
ck=5
df['Q'] = df.apply(lambda row: EOQ(row['D'], row['p'], ck, ch), axis=1)
df
Example 2: pandas apply function to every row
# Get rid of $ and , in the SAL-RATE, then convert it to a float
def money_to_float(money_str):
return float(money_str.replace("$","").replace(",",""))
df['SAL-RATE'].apply(money_to_float)