/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

2 votes158 views2 answers
Payizone
Python
2 votes165 views1 answer
How to get the last value in a list python
Python
0 vote161 views1 answer
How to create pyw file
Python
1 vote182 views1 answer
On member leave event in discord.py
Python
0 vote152 views1 answer
What are the mouseX/mouseY variebles in pycharm
Python
-2 votes152 views2 answers
Diamond pattern in python
Python
0 vote167 views1 answer
Defaultdict python inport
Python
0 vote153 views1 answer
Making a txt file then write
Python
1 vote164 views1 answer
Python invert binary tree
Python
0 vote154 views1 answer
ModuleNotFoundError: No module named 'yaspin'
Python