Only remove entirely empty rows in pandas

Question

If I have this data frame:

d = {'col1': [1, np.nan, np.nan], 'col2': [1, np.nan, 1]}
df = pd.DataFrame(data=d)

    col1    col2
0   1.0     1.0
1   NaN     NaN
2   NaN     1.0

and want to drop only rows that are empty to produce the following:

d = {'col1': [1, np.nan], 'col2': [1, 1]}
df = pd.DataFrame(data=d)

    col1    col2
0   1.0     1
1   NaN     1

What is the best way to do this?

note that `df.dropna(how='all')` will not convert `col2` to int. You may have to explicitly do it. — Joe Ferndz, Nov 25 '20 at 05:18

score 27 · Accepted Answer · answered Nov 25 '20 at 05:15

27

Check the docs page

df.dropna(how='all')

answered Nov 25 '20 at 05:15

Hasnat

1 Answers1