/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 vote283 views3 answers
Count string python
Python
0 vote275 views1 answer
Pairwise function python
Python
28 votes300 views6 answers
Convert list to string python
Python
0 vote262 views1 answer
Print a string with spaces between characters python
Python
2 votes260 views1 answer
Average out all rows pandas
Python
31 votes254 views5 answers
Python day from date
Python
0 vote262 views1 answer
Replace \u00a0
Python
5 votes288 views2 answers
My django template doesnt want to load the static file
Python
2 votes259 views1 answer
Open image in numpy
Python
0 vote219 views1 answer
Triangle quest
Python