Drop columns tha thave a header but all rows are empty Python 3 & Pandas

Question

I just could not figure this one out:

df.dropna(axis = 1, how="all").dropna(axis= 0 ,how="all")

All headers have data. How can I exclude the headers form a df.dropna(how="all") command. I am afraid this is going to be trivial, but help me out guys.

Thanks, Levi

question from:https://stackoverflow.com/questions/65847730/drop-columns-tha-thave-a-header-but-all-rows-are-empty-python-3-pandas

Answer 1

Okay, as I understand what you want is as follows:

• drop any column where all rows contain NaN
• drop any row in which one or more NaN appear

So for example, given a dataframe df like:

    Id  Col1    Col2    Col3    Col4
0   1   25.0    A   NaN 6
1   2   15.0    B   NaN 7
2   3   23.0    C   NaN 8
3   4   5.0 D   NaN 9
4   5   NaN E   NaN 10

convert the dataframe by:

df.dropna(axis = 1, how="all", inplace= True)
df.dropna(axis = 0, how='all', inplace= True)

which yields:

    Id  Col1    Col2    Col4
0   1   25.0    A   6
1   2   15.0    B   7
2   3   23.0    C   8
3   4   5.0     D   9
4   5   NaN     E   10