/Python/Pandas df trim columns if too much missing data

Pandas df trim columns if too much missing data

In [108]: df.columns[df.isnull().mean() < 0.8]
Out[108]: Index(['b', 'd', 'e'], dtype='object')

In [109]: df[df.columns[df.isnull().mean() < 0.8]]
Out[109]:
      b    d    e
0   2.0  NaN  NaN
1   NaN  NaN  2.0
2   2.0  NaN  NaN
3   NaN  NaN  2.0
4   2.0  NaN  NaN
5   NaN  NaN  NaN
6   2.0  NaN  NaN
7   2.0  NaN  NaN
8   2.0  NaN  NaN
9   NaN  NaN  NaN
10  2.0  NaN  2.0
11  NaN  2.0  NaN
12  NaN  2.0  NaN
13  NaN  2.0  NaN
14  NaN  2.0  2.0
15  NaN  NaN  NaN
16  2.0  NaN  NaN
17  NaN  NaN  2.0
18  NaN  2.0  NaN
19  2.0  2.0  NaN

Source: stackoverflow.com

Similar codes

0 vote319 views1 answer
Python uml
Python
-1 vote411 views3 answers
How to get the code of a website in python
Python
0 vote321 views1 answer
Ordenar lista decrescente python
Python
5 votes354 views2 answers
Which language written python
Python
8 votes332 views3 answers
Python subtract one list from another
Python
0 vote351 views1 answer
Fillna with index
Python
0 vote355 views1 answer
Chatbot in python github
Python
49 votes333 views6 answers
Python measure time
Python
0 vote340 views1 answer
Random ordered slice of an array
Python
0 vote362 views2 answers
Diagonal difference hackerrank solution in python
Python