/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

184 votes283 views6 answers
Upgrade pip
Python
0 vote197 views1 answer
Python how to get current line number
Python
32 votes175 views3 answers
Python move files
Python
0 vote184 views1 answer
Python int to scientific string
Python
7 votes228 views3 answers
Python split string by specific word
Python
7 votes181 views6 answers
Python function
Python
0 vote197 views3 answers
Python count
Python
0 vote186 views1 answer
How to get rid of an instance variable python
Python
2 votes187 views1 answer
How to return PIL image from opencv
Python
0 vote180 views1 answer
Is python good for competitive programming
Python