dropna rows pandas code example
Example 1: drop if nan in column pandas
df = df[df['EPS'].notna()]
Example 2: drop null rows pandas
df.dropna()
Example 3: drop na pandas
>>> df.dropna(subset=['name', 'born'])
name toy born
1 Batman Batmobile 1940-04-25
Example 4: dropna pandas
>>> df.dropna(axis='columns')
name
0 Alfred
1 Batman
2 Catwoman
Example 5: dropna pandas
>>> df.dropna(inplace=True)
>>> df
name toy born
1 Batman Batmobile 1940-04-25
Example 6: pandas dropna
df = pd.DataFrame({"name": ['Alfred', 'Batman', 'Catwoman'],
... "toy": [np.nan, 'Batmobile', 'Bullwhip'],
... "born": [pd.NaT, pd.Timestamp("1940-04-25"),
... pd.NaT]})
>>> df
name toy born
0 Alfred NaN NaT
1 Batman Batmobile 1940-04-25
2 Catwoman Bullwhip NaT
>>> df.dropna()
name toy born
1 Batman Batmobile 1940-04-25