/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

0 vote269 views1 answer
System to extract data from csv file in python
Python
0 vote245 views1 answer
Remove trailing white space python string
Python
2 votes258 views1 answer
Pip avticate venv
Python
0 vote388 views1 answer
Json indent options python
Python
2 votes270 views3 answers
Convert csv to dictionary in Python
Python
0 vote259 views1 answer
How to check if a cell is empty in openpyxl
Python
0 vote281 views2 answers
Create dictionary without removing duplicates from dataframe
Python
0 vote241 views1 answer
Django get child element
Python Django
-1 vote232 views1 answer
Usage code grepper
Python
0 vote265 views1 answer
Python get last cell value
Python