/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 vote364 views2 answers
Convert decimal to float in python
Python
0 vote332 views1 answer
Python bug
Python
0 vote348 views1 answer
Django user refistration
Python
0 vote332 views1 answer
Python serial readline
Python
1 vote426 views1 answer
Python sleep random
Python
0 vote373 views1 answer
Load a Dictionary from File in Python Using the Load Function of the pickle Module
Python
6 votes358 views4 answers
Install python3 in ubuntu
Python
2 votes339 views1 answer
How to clear an array python
Python
1 vote397 views1 answer
Pthon - progressbar
Python
0 vote333 views2 answers
Extra error
Python