/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

16 votes306 views5 answers
Fibonacci series
Python
25 votes358 views6 answers
Find max value in list python
Python
1 vote315 views1 answer
Matplotlib latex non italic indices
Python
11 votes304 views6 answers
Linear regression python code
Python
17 votes313 views5 answers
Python input integer
Python
0 vote347 views1 answer
How to convert csv columns to text python
Python
0 vote339 views1 answer
Merging df vertically
Python
0 vote313 views1 answer
Df index start from 1
Python
0 vote309 views1 answer
Squre value of a column pandas
Python
0 vote312 views1 answer
Sort eigenvalues and eigenvectors python
Python