/Python/Pandas apply function to every row

Pandas apply function to every row

Pandas loop through rows

for index, row in df.iterrows():
    print(row['c1'], row['c2'])

Output: 
   10 100
   11 110
   12 120

Source: stackoverflow.com

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)

Source: jonathansoma.com

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

Source: stackoverflow.com

Similar codes

27 votes184 views3 answers
Python date and time to datetime
Python
0 vote171 views1 answer
Dataframe python unique values rows
Python
3 votes190 views1 answer
No module named 'django.core.urlresolvers'
Python Django
1 vote189 views1 answer
How to right click in pyautogui
Python
0 vote178 views1 answer
Python logging comma to dot
Python
3 votes168 views1 answer
Multiply column of dataframe by number
Python
5 votes200 views4 answers
Create python list
Python
57 votes170 views6 answers
Python get list of files in directory
Python
1 vote159 views1 answer
Python list comprehension index, value
Python
0 vote175 views1 answer
Sqlalchemy_database_uri
Python