/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 vote172 views2 answers
1d array to one hot
Python
5 votes160 views1 answer
Translate english to japanese
Python
9 votes162 views3 answers
How to get image in jupyter notebook
Python
0 vote166 views2 answers
Reset repo
Python
0 vote166 views1 answer
Seaborn heatmap text labels
Python
0 vote149 views2 answers
Python-wordpress-xmlrpc custom fields
Python
0 vote164 views1 answer
Try: if '1' != 1: raise "someError" else: print("someError has not occurred") except "someError": print ("someError has occurred")
Python
9 votes158 views3 answers
Python if elif
Python
0 vote174 views1 answer
How to extract integers from string python
Python
0 vote167 views1 answer
Random night stars with python turtle
Python