/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 vote111 views1 answer
Python jupitor
Python
0 vote112 views1 answer
Python get host.docker.internal ip site:stackoverflow.com
Python
0 vote111 views1 answer
Pandas if value present in df index
Python
0 vote154 views1 answer
Pysolr - connect to solr via vpn
Python
0 vote116 views2 answers
Spyder 32 bit download
Python
-1 vote123 views3 answers
Open csv from url python
Python
0 vote154 views1 answer
Django today date in template
Python Django
1 vote111 views1 answer
Combining series to a dataframe
Python
0 vote119 views1 answer
Django optional path parameter
Python
0 vote109 views1 answer
Python greater than dunder
Python