Remove Missing Data in Pandas (Python 3, Pandas)

Question

This is frustrating me to no end --

I have a data frame called FINAL that looks like this

Match Type     Suffix     
0              NaN        
1              NaN        
2              NaN        
3              Exact                  
4              Exact

I want to get rid of all the NAN data using this:

final.dropna()

and this

final['Suffix'].dropna()

neither of them work! What am I missing!

Paul H · Accepted Answer · 2014-09-18 22:39:59Z

1

All of those operations return copies. You can either reassign the variable:

final = final.dropna()

Or pass inplace=True:

final.dropna(inplace=True)

answered Sep 18, 2014 at 22:39

Paul H

68.7k23 gold badges165 silver badges139 bronze badges

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

Collectives™ on Stack Overflow

Remove Missing Data in Pandas (Python 3, 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