Validate Python Pandas Dataframe Column with Row Reference

Question

I'm planning to validate columns in my dataframe as follows...

def validateCol1(val):
    #validate
    #write invalid entries to my error tracking list with row reference

df['col1'].apply(validateCol1)

But although that passes the column value to my function, I want to be able to access the row where the error occured. Does anyone know how I could do that?

Anja S · Accepted Answer · 2021-02-07 15:35:39Z

2

You can apply the lambda function to the row instead of only on a single column:

df.apply(lambda x: validateCol(x), axis=1)

Thus in the validateCol function you can access value in column 1 using x['col1'] and also access other columns in the row.

answered Feb 7, 2021 at 15:35

Anja S

912 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Validate Python Pandas Dataframe Column with Row Reference

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related