/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 vote158 views1 answer
Get list of users django
Python Django
0 vote172 views1 answer
Edit models in django admin
Python Django
0 vote160 views9 answers
How to form a list from a file in python
Python
0 vote179 views3 answers
User serializer in django rest framework
Python Django
0 vote146 views1 answer
Newick string python
Python
0 vote141 views1 answer
Serializer phonenumber field json
Python
1 vote148 views1 answer
Create period pandas
Python
9 votes144 views2 answers
How to run linux command in python
Python
0 vote152 views2 answers
Isinstance in python
Python
5 votes184 views3 answers
Pandas drop rows with value in list
Python