remove rows where column is nan pandas code example
Example 1: drop if nan in column pandas
df = df[df['EPS'].notna()]
Example 2: remove all rows where one ccolumns egale to nan
#remove in dataframe but no in the file
df = df[df['column'].notna()]
#remove in dataframe and in the file
df.dropna(subset=['EPS'], how='all', inplace=True)
Example 3: drop na in pandas
>>> df.dropna(subset=['name', 'born'])
name toy born
1 Batman Batmobile 1940-04-25