/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 vote91 views1 answer
Add text to axis
Python
2 votes53 views1 answer
How to change pygame window icon
Python
29 votes94 views4 answers
Plot matplotlib size
Python
0 vote123 views1 answer
How to run loops 3 times in python
Python
0 vote105 views1 answer
How to select all but last columns in python
Python
0 vote98 views2 answers
How to fix def multiply(a ,b): a*b
Python
0 vote99 views2 answers
Prevent division by zero numpy
Python
0 vote96 views1 answer
Webdriver.chrome() python not working
Python
0 vote54 views1 answer
5+2 in python
Python
0 vote92 views1 answer
Minio python make an object
Python