/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 vote156 views1 answer
Circular list python
Python
2 votes210 views1 answer
Convert int to byte python
Python
35 votes132 views5 answers
Sort by dataframe
Python
15 votes1.4K views4 answers
Web server python
Python
1 vote178 views1 answer
Run django app locally
Python Django
0 vote154 views1 answer
Check substring frequency in a text python
Python
0 vote161 views1 answer
Indentation error in python atom editor
Python
2 votes159 views1 answer
Ascii values in python of
Python
2 votes179 views2 answers
Check python version kali linux
Python
0 vote168 views1 answer
Python column = sum of list of columns
Python