Answers for "pandas drop rows with nan in certain column"

drop if nan in column pandas

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

dropping nan in pandas dataframe

df.dropna(subset=['name', 'born'])

drop column with nan values

fish_frame = fish_frame.dropna(axis = 1, how = 'all')

drop columns with nan pandas

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

remove a rows in which three column has nan

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