/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

13 votes225 views3 answers
Python upload video to youtube
Python
1 vote215 views1 answer
__delattr__ python
Python
1 vote200 views1 answer
Django populate choice field from database
Python
36 votes202 views6 answers
Remove letter from string python
Python
0 vote199 views1 answer
Write a python program which accepts the user
Python
5 votes210 views2 answers
How to say that an input needs to be a number python
Python
0 vote209 views2 answers
Error: Could not locate a Flask application. You did not provide the "FLASK_APP" environment variable, and a "wsgi.py" or "app.py" module was not found in the current directory.
Python
0 vote213 views1 answer
How to have requirement file in python for libs
Python
0 vote208 views1 answer
Python time function duration and memory usage
Python
0 vote209 views1 answer
Input date args python datetime
Python