show columns with without null values pandas code example

Example 1: pandas replace null values with values from another column

#Python
#Col 1 = where you want the values replaced
#Col 2 = where you want to take the values from
df.["Col 1"].fillna(df.["Col 2"], inplace=True)

Example 2: 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 3: number of columns with no missing values

null_cols = df.columns[df.isnull().all()]
df.drop(null_cols, axis = 1, inplace = True)

Example 4: pandas select only columns with na

null_cols = df.columns[df.isnull().any()]