/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

6 votes351 views5 answers
Os run shell command python
Python
7 votes315 views3 answers
Rmse in python
Python
2 votes328 views1 answer
Replace space with _ in pandas
Python
0 vote334 views2 answers
Django ajax body to json
Python
5 votes336 views2 answers
Value count a list python
Python
0 vote391 views1 answer
Unable to import flask pylint
Python Flask
0 vote377 views1 answer
Check django channels with redis setup
Python Django
8 votes309 views2 answers
How to clear the list in python
Python
0 vote340 views1 answer
Linking bootstrap in flask
Python
0 vote322 views1 answer
Hms bagle
Python