Answers for "delete rows with blank cells in a certain column"

if none in column remove row

import pandas as pd
df = df[pd.notnull(df['Gender'])]

how to delete blank rows in excel

Select the blank rows we want to delete. Hold Ctrl key and click on a row to select it.
When the rows we want to delete are selected then we can right click and choose Delete from the menu.