PYTHON

select items from dataframe where value is null

df[df['column name'].isna()]

get columns that contain null values pandas

In [74]: df.columns[df.isna().any()].tolist()
Out[74]: ['a', 'b']

How many columns have null values present in them? in pandas

import pandas as pd
df = pd.DataFrame({'a':[1,2,np.nan], 'b':[np.nan,1,np.nan],'c':[np.nan,2,np.nan], 'd':[np.nan,np.nan,np.nan]})
print(pd.isnull(df).sum())

find null values pandas

#Retreieve boolean values of whether or not the given cells of a dataframe are 
#null
df.isnull()