/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 vote148 views1 answer
Django app directory
Python Django
0 vote121 views1 answer
Numpy array divide each row by its sum
Python
6 votes82 views2 answers
Pandas exclude columns
Python
0 vote121 views1 answer
MASS algorithm python
Python
23 votes166 views3 answers
Install django rest framework
Python Django
0 vote163 views1 answer
Pandas convert numbers in parentheses to negative
Python
33 votes126 views4 answers
Python random password generator
Python
0 vote131 views1 answer
Python r squared
Python
-1 vote120 views4 answers
How to say hello world in c++
Python
0 vote114 views6 answers
ORing two cv mat objects
Python