/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 vote103 views1 answer
Actual python iterators
Python
4 votes101 views1 answer
How to make a custom icon for pygame
Python
1 vote109 views1 answer
Django template tags capitalize
Python
42 votes104 views6 answers
Python round 1 decimal place
Python
3 votes104 views3 answers
Download playlist from youtube python
Python
5 votes147 views3 answers
Flask port
Python Flask
1 vote113 views1 answer
Barplot syntax in python
Python
9 votes115 views3 answers
Get first line of file python
Python
1 vote108 views1 answer
Url decode python
Python
0 vote107 views1 answer
Sending whatsapp message from python notebook
Python