/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

1 vote279 views1 answer
Import CSV Files into R Using fread() method
Python
0 vote259 views1 answer
Audio streaming python
Python
1 vote272 views1 answer
Django change value and save model object
Python Django
8 votes260 views2 answers
Import Image
Python
0 vote276 views1 answer
R - scale data from 0 to 1
Python
18 votes295 views4 answers
Reset index python
Python
0 vote285 views1 answer
Get users except superuser django
Python
0 vote255 views1 answer
Can only concatenate str (not "numpy.uint8") to str
Python
231 votes450 views4 answers
Urban dictionary
Python
145 votes297 views5 answers
How to generate a random number python
Python