/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 vote300 views1 answer
Strftime python multiple formats
Python
0 vote331 views1 answer
Python selenium set attribute of element
Python
1 vote298 views1 answer
Pandas nan values in column
Python
0 vote288 views1 answer
Python how to change a point in a multidimensional list
Python
0 vote312 views1 answer
How to import flask restful using pip
Python
1 vote369 views1 answer
Flask clear session
Python Flask
0 vote364 views1 answer
Django data from many to many field in template
Python Django
20 votes294 views6 answers
Python interpreter
Python
73 votes293 views6 answers
Matplotlib
Python
3 votes295 views2 answers
Python dataframe column string to integer python
Python