/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 vote292 views1 answer
Import "django.core.urlresolvers" could not be resolved
Python
204 votes423 views6 answers
How to read a file in python
Python
26 votes294 views1 answer
Execute command in python script
Python
12 votes287 views2 answers
Find python version in jupyter notebook
Python
0 vote275 views1 answer
Visualizzare csv in pycharm pandas read_csv
Python
0 vote284 views1 answer
ModuleNotFoundError: No module named 'timeago'
Python
0 vote319 views1 answer
Manage python environment in jupyterlab
Python
1 vote233 views1 answer
Python take input from terminal
Python
0 vote304 views1 answer
Empty argument as a parameter in python function using None
Python
14 votes287 views3 answers
Shutdown/restart windows with python
Python