remove Nan excel python 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
df = df[df['EPS'].notna()]
>>> df.dropna(axis='columns')
name
0 Alfred
1 Batman
2 Catwoman