How drop rows with NaN

Question

I have two rows like that:

How can I drop it?

I try:

to_excl = df.loc[df['tabela_segproposta.RENOVAR'].isnull()]
df = df[df['tabela_segproposta.RENOVAR'].isin(to_excl).index]
df

but nothings happen

See [.dropna](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.dropna.html) method. You can use: `df.dropna(subset=['tabela_segproposta.RENOVAR'])`. — Cainã Max Couto-Silva, Nov 27 '20 at 15:36
Does this answer your question? [How to drop rows of Pandas DataFrame whose value in a certain column is NaN](https://stackoverflow.com/questions/13413590/how-to-drop-rows-of-pandas-dataframe-whose-value-in-a-certain-column-is-nan) — Mayank Porwal, Nov 27 '20 at 16:17

score 0 · Accepted Answer · answered Nov 27 '20 at 15:24

0

you can use:

new_df = df[~df['tabela_segproposta.RENOVAR'].isnull()]

answered Nov 27 '20 at 15:24

sophocles

worked perfectly! Thank you! But why did you use ~ ? – LpCoutinho Nov 27 '20 at 16:01
Simply put, you can think of '~' meaning NOT (source: https://www.w3schools.com/python/python_operators.asp) – sophocles Nov 27 '20 at 16:11
Can i remove columns too? Tried but did'nt work – LpCoutinho Nov 27 '20 at 16:34
It doesn't work with columns. To drop columns you can do ```df.drop(['col1','col2',...'colN'],axis=1,inplace=True``` – sophocles Nov 27 '20 at 17:00

1 Answers1