/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 vote208 views1 answer
Isupper() in python
Python
0 vote169 views1 answer
Create line in canvas widget object
Python
3 votes179 views3 answers
Python get script path
Python
0 vote167 views1 answer
Multiple assessment in python
Python
0 vote165 views1 answer
What is {:02d}:{:02d} in python
Python
0 vote173 views1 answer
Take union of two dataframes pandas
Python
19 votes163 views4 answers
Import excel python
Python
3 votes181 views6 answers
Send embed discord.py
Python
4 votes183 views3 answers
Python get script name
Python
0 vote127 views1 answer
Python google docs api how to get doc index
Python