Remove a row based on two empty columns in python pandas

Question

I want to be able to remove rows that are empty in column NymexPlus and NymexMinus right now the code I have is

df.dropna(subset=['NymexPlus'], inplace=True)

The thing about this code is that it will also delete rows in the column NymexMinus which I don't want to happen. Is there an If/AND statement that will work in terms of only getting rid of empty cells for both of the columns?

Corralien · Accepted Answer · 2022-02-16 20:12:44Z

2

Use a list as subset parameter and how='all':

df.dropna(subset=['NymexPlus', 'NymexMinus'], how='all', inplace=True)

answered Feb 16, 2022 at 20:12

Corralien

121k8 gold badges44 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Remove a row based on two empty columns in python pandas

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