Mastering pandas - Second Edition

Deletion

This will delete the entire row or column that contains the missing value.

Deletion leads to data loss and is not recommended unless there is no other way out.

Deletion can be performed as follows:

• Dropping all the rows where all the cells have missing values:

data.dropna(axis=0,how='all')# axis=0 means along rows

• Dropping all the rows where any of the cells have missing values:

data.dropna(axis=0,how='any')