Elegant way to check if pandas dataframe contains any null items

Asked Mar 31 '15 at 15:26

Active Mar 31 '15 at 15:26

Viewed 32 times

To check if a dataframe like below contains any NaN's, I use the following code:

df.isnull().any().any()

mukey   hzdept_r    hzdepb_r    sandtotal_r silttotal_r
425897      0         61        
425897      61        152          5.3         44.7
425911      0         30           30.1        54.9
425911      30        74           17.7        49.8
425911      74        84

Is there a more elegant way to do the same?

asked Mar 31 '15 at 15:26

user308827

21,227
87
254
417

1

I think that is a good way – joris Mar 31 '15 at 15:31
How could anything possibly be more elegant? – camdenl Mar 31 '15 at 15:48
I was thinking something like df.anynull()? Not complaining though, I love pandas! – user308827 Mar 31 '15 at 15:50
Another way would be `df.dropna().shape == df.shape` or `df.dropna().equals(df)` but really there isn't much difference in terms of code length and readability – EdChum Mar 31 '15 at 16:37
1

Just found this: http://stackoverflow.com/questions/24318598/more-idiomatic-version-of-df-isnull-any-any-w-a-pandas-dataframe?rq=1 – user308827 Mar 31 '15 at 17:15

Elegant way to check if pandas dataframe contains any null items

0 Answers0