remove rows that have none in given column df code example
Example 1: 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 2: drop row pandas column value not a number
In [215]:
df[df['entrytype'].apply(lambda x: str(x).isdigit())]
Out[215]:
entrytype
0 0
1 1
4 2