/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 vote184 views1 answer
How to print list without newline
Python
-1 vote238 views1 answer
Django filter on related field
Python Django
0 vote189 views1 answer
Getting the Current Working Directory in Python
Python
0 vote205 views1 answer
Create python package ros 2
Python
49 votes216 views6 answers
How to create dataframe in python
Python
0 vote189 views1 answer
Assert vs validate in python
Python
8 votes215 views2 answers
Show image jupyter notebook
Python
0 vote190 views1 answer
Networkx max degree node
Python
2 votes358 views3 answers
No such table django
Python Django
15 votes207 views6 answers
Infinity python
Python