/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 vote200 views1 answer
Find and replace subword in word python regex
Python
0 vote213 views2 answers
Get last file in directory python
Python
1 vote203 views1 answer
Random forrest plotting feature importance function
Python
0 vote189 views1 answer
Matplotlib plot two graphs side by side
Python
0 vote209 views1 answer
Python sns save plot lable axes
Python
0 vote212 views1 answer
Extract a jar py
Python
24 votes205 views6 answers
Create a timestamp python
Python
0 vote220 views1 answer
Meter to cm in python
Python
0 vote183 views1 answer
Discord.py - change the default help command
Python
4 votes219 views4 answers
Flash messages django
Python