df = df[df['EPS'].notna()]
filtered_df = df[df['name'].notnull()]
#return a subset of the dataframe where the column name value != NaN df.loc[df['column name'].isnull() == False]
df[~df.isin([np.nan, np.inf, -np.inf]).any(1)]