/Python/Drop rows where specific column has null values

Drop rows where specific column has null values

In [30]: df.dropna(subset=[1])   #Drop only if NaN in specific column (as asked in the question)
Out[30]:
          0         1         2
1  2.677677 -1.466923 -0.750366
2       NaN  0.798002 -0.906038
3  0.672201  0.964789       NaN
5 -1.250970  0.030561 -2.678622
6       NaN  1.036043       NaN
7  0.049896 -0.308003  0.823295
9 -0.310130  0.078891       NaN

Source: stackoverflow.com

Drop rows where specific column has null values

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

Source: stackoverflow.com

Similar codes

5 votes125 views2 answers
Insert function in list
Python
0 vote168 views1 answer
How to create a custom function in python
Python
0 vote178 views1 answer
Python trim zero off end of list
Python
0 vote149 views1 answer
Geopandas españa map
Python
14 votes145 views3 answers
Python remove first and last character from string
Python
8 votes174 views3 answers
Python subtract one list from another
Python
5 votes143 views3 answers
Iterating with index in for loops python
Python
0 vote132 views1 answer
How to use rmse as loss function in keras
Python
0 vote143 views1 answer
How to make a instagram report bot python
Python
0 vote129 views1 answer
Asp blocking sedular python stackoverflow
Python