/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

95 votes200 views6 answers
Check if string contains python
Python
0 vote185 views4 answers
Python draw circle matplotlib
Python
0 vote194 views1 answer
Remove all occurences
Python
0 vote218 views1 answer
Return the biggest even fro a list python
Python
1 vote199 views1 answer
.annotate unique distinct
Python
0 vote187 views1 answer
Compile and train cnn models
Python
4 votes146 views1 answer
Python words in string
Python
0 vote195 views1 answer
Pandas df count values less than 0
Python
1 vote219 views1 answer
How to get last values or data in django orm
Python Django
2 votes200 views2 answers
Choice random word in python from a text file
Python