pandas delete rows nan code example

Example 1: drop columns with nan pandas

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

Example 2: dropna threshold

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