/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

111 votes256 views6 answers
Do while in python
Python
0 vote254 views1 answer
Python find matching string regardless of case
Python
0 vote257 views1 answer
How to count to 1billion in python
Python
0 vote241 views1 answer
Python program to read a random line from a file.
Python
0 vote278 views1 answer
One small letter three big bodyguard
Python
1 vote274 views1 answer
Iterate over dictionary django
Python Django
1 vote302 views1 answer
Unresolved reference 'django'
Python
5 votes246 views2 answers
Matplotlib python background color
Python
-1 vote247 views1 answer
Python graph
Python
0 vote320 views1 answer
Shutdown flask server with request
Python Flask