Python, Pandas : Return only those rows which have missing values

You can use any axis=1 to check for least one True per row, then filter with boolean indexing:

null_data = df[df.isnull().any(axis=1)]

python pandas missing-data

df.isnull().any(axis = 1).sum()

this gives you the total number of rows with at least one missing data

python pandas missing-data

If you want to see only the rows that contains the NaN values you could do:

data_frame[data_frame.iloc[:, insert column number here]=='NaN']

CodeHunter