python dataframe filter nan code example

Example 1: drop if nan in column pandas

df = df[df['EPS'].notna()]

Example 2: pandas where retuning NaN

# Try using a loc instead of a where:
df_sub = df.loc[df.yourcolumn == 'yourvalue']