dropping rows with missing values code example

Example 1: remove rows or columns with NaN value

df.dropna()     #drop all rows that have any NaN values
df.dropna(how='all')

Example 2: drop na pandas

>>> df.dropna(subset=['name', 'born'])
       name        toy       born
1    Batman  Batmobile 1940-04-25

Example 3: drop row pandas column value not a number

In [215]:

df[df['entrytype'].apply(lambda x: str(x).isdigit())]
Out[215]:
  entrytype
0         0
1         1
4         2