/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

3 votes234 views1 answer
How to connect templates in django
Python
0 vote238 views1 answer
How is pythons glob.glob ordered list
Python
0 vote233 views1 answer
Python run things at certain datetimes
Python
0 vote251 views1 answer
Wexpect in python
Python
1 vote217 views1 answer
Complete the function digits(n) that returns how many digits the number has.
Python
2 votes236 views1 answer
Python can't subtract offset-naive and offset-aware datetimes
Python
0 vote222 views1 answer
Python dataframe add rank column
Python
27 votes246 views4 answers
Python text color
Python
0 vote230 views2 answers
Python builtwith
Python
6 votes242 views5 answers
Python while True
Python