/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

1 vote141 views1 answer
Remove all files in a directory mac
Python
9 votes197 views6 answers
Python sort list
Python
0 vote154 views1 answer
Dtype cannot be bool python
Python
5 votes151 views1 answer
Append item to array python
Python
0 vote151 views1 answer
How to import and use keyboard with pygame
Python
10 votes147 views2 answers
TypeError: can only concatenate str (not “int”) to str
Python
0 vote205 views1 answer
Django serializer,
Python Django
0 vote149 views1 answer
Form list of filename get the filename with highest num pythn
Python
0 vote145 views1 answer
Pandas dataframe display cell size
Python
2 votes138 views2 answers
Get rid of unnamed column pandas
Python