/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 votes140 views1 answer
How to save a model and reuse fast ai
Python
0 vote112 views1 answer
Hackerrank solutions python 3
Python
-1 vote156 views1 answer
Tkinter triangle
Python
0 vote120 views1 answer
Datetime decreasing date python
Python
8 votes152 views6 answers
How to convert categorical data to numerical data in python
Python
160 votes115 views2 answers
Alphabet
Python
18 votes161 views3 answers
Django-admin startproject
Python
3 votes154 views1 answer
How to remove coma in python
Python
24 votes158 views3 answers
Get last n characters of string python
Python
0 vote155 views2 answers
Packet tracer 10.6.12
Python