how to filter nan values in pandas code example

Example 1: drop if nan in column pandas

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

Example 2: pandas filter non nan

filtered_df = df[df['name'].notnull()]

Example 3: remove rows or columns with NaN value

df.dropna()     #drop all rows that have any NaN values
df.dropna(how='all')

Example 4: filter nulla values only pandas

#Python, pandas
#Obtain a dataframe df containing only the rows where "column1" is null (NaN)

df[df['column1'].isnull()]

Example 5: pandas where retuning NaN

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