In [1]:

```
# import
import pandas as pd
```

In [2]:

```
# reading the file
data = pd.read_csv("data/train.csv")
```

In [5]:

```
# Looking the data
data.head(6)
```

Out[5]:

In [8]:

```
# isnull or notnull
data.isnull().head(6)
```

Out[8]:

In [9]:

```
data.notnull().head(6)
```

Out[9]:

In [10]:

```
# use of any
data.isnull().values.any()
```

Out[10]:

In [11]:

```
# use of all
data.isnull().values.all()
```

Out[11]:

In [12]:

```
# taking the count of Null/NaN in each column of dataframe
data.isnull().sum()
```

Out[12]:

In [13]:

```
# if want to know the total
data.isnull().sum().sum()
```

Out[13]:

In [14]:

```
# if want to check in any particular column
data['Dependents'].isnull().sum()
```

Out[14]:

*Atul Singh*

Follow me -

http://www.datagenx.net

https://twitter.com/datagenx

https://www.facebook.com/datastage4you