/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

70 votes180 views6 answers
What is python virtual environment
Python
0 vote260 views2 answers
Eval(
Python
0 vote198 views1 answer
At=error code=h10 desc= app crashed python flask
Python
-2 votes160 views1 answer
Nodejs print
Python
3 votes195 views2 answers
How to make python code faster
Python
0 vote169 views1 answer
Squre value of a column pandas
Python
1 vote177 views1 answer
Python while false loop
Python
0 vote154 views2 answers
How to get the index of the first integer in a string python
Python
0 vote220 views1 answer
How to create a python script to automate software installation?
Python
4 votes176 views2 answers
Plot distribution seaborn
Python