Drop rows of pandas dataframe that don't have finite values in certain variable(s)

Question

I cannot see what the built-in function is for the following simple but seemingly common/useful task: Drop rows which have no value for any of my key columns.

def keepIfPopulated(adf,interestingVars):
        good=0
        for vv in interestingVars:
            good+=adf[vv].notnull()
        return(adf[good>0])

If there was just one column of interest, I could choose to keep it, but most pandas functions take one or more labels as arguments, so this question is about how to check on one or more columns at once.

user1827356 · Accepted Answer · 2013-03-25 22:57:02Z

3

adf = adf.dropna(subset=interestingVars, how='all')

answered Mar 25, 2013 at 22:57

user1827356

7,0322 gold badges26 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Drop rows of pandas dataframe that don't have finite values in certain variable(s)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related