drop all null values pandas code example

Example 1: drop if nan in column pandas

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

Example 2: drop columns with nan pandas

>>> df.dropna(axis='columns')
       name
0    Alfred
1    Batman
2  Catwoman

Example 3: dropna threshold

#dropping columns having more than 50% missing values(1994/2==1000)
df=df.dropna(thresh=1000,axis=1)