/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

22 votes229 views3 answers
Python sort list in reverse order
Python
1 vote243 views1 answer
How to say hello world
Python
0 vote487 views1 answer
ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators > 1 char and different from '\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.
Python
2 votes216 views2 answers
How to find a word in a string python
Python
0 vote227 views1 answer
Ipywidget datepicker
Python
0 vote233 views1 answer
Chat bot in python
Python
0 vote224 views1 answer
Even numbers from 1 to 100 in python
Python
10 votes242 views2 answers
Max columns in python
Python
0 vote232 views1 answer
Windows error message python
Python
6 votes219 views2 answers
Read data from yaml file in python
Python