filter nan pandas code example

Example 1: pandas filter non nan

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

Example 2: how to filter out all NaN values in pandas df

#return a subset of the dataframe where the column name value != NaN 
df.loc[df['column name'].isnull() == False]

Example 3: pandas where retuning NaN

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

Example 4: python select columns with no na

df = df[df.columns[~df.isnull().all()]]