drop a column due to nan values code example

Example 1: drop if nan in column pandas

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

Example 2: remove a rows in which three column has nan

df.dropna(subset=['col1', 'col2', 'col3', 'col4', 'col5', 'col6'], how='all', inplace=True)