/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 vote223 views1 answer
Can't convert np.ndarray of type numpy.object_.
Python
0 vote195 views1 answer
Django admin manytomanyfield filter
Python Django
2 votes246 views2 answers
Np logical not
Python
0 vote224 views1 answer
Socket python how to check if server alive
Python
1 vote252 views1 answer
Select realted for foreign key table in django
Python Django
2 votes231 views1 answer
Check corently installed epython version
Python
0 vote218 views8 answers
Empaquetado y manejo dependencias en python
Python
0 vote230 views1 answer
How to create a cubic function in python 3
Python
0 vote254 views1 answer
Remove cog in discord.py
Python
5 votes243 views2 answers
Python string replace by index
Python