Operations on every row in pandas DataFrame

Question

I want to iterate through every row in a pandas DataFrame, and do something with the elements in each row.

Right now I have

for row in df.iterrows(): 
    if row['col'] > 1.5:
        doSomething

but it tells me that the 'tuple indices must be integers, not str' . How do I access the column that I want in a certain row?

Answer 1

Probably the simplest solution is to use the APPLYMAP or APPLY fucntions which applies the function to every data value in the entire data set.

You can execute this in a few ways:

df.applymap(someFunction)

or

df[["YourColumns"]].apply(someFunction)

The Links are below:

ApplyMap Docs

Apply Docs

Answer 2

You can use apply function with option axis=1. For example:

def my_function(row):
    if row['col'] > 1.5:
        doSomething()
    else:
        doSomethingElse()

my_df.apply(my_function, axis=1)

source