/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

-1 vote441 views4 answers
Flask documentation
Python Flask
0 vote314 views1 answer
How to check if object is of file type in python3
Python
0 vote328 views1 answer
Save variable to use in other jupyter notebook
Python
1 vote288 views2 answers
Correlation between two columns pandas
Python
80 votes336 views4 answers
Python append to file
Python
0 vote339 views1 answer
Meter to cm in python
Python
0 vote306 views1 answer
From decimal to binary python without using any libraries
Python
2 votes349 views2 answers
How to make a clock in python 3
Python
1 vote328 views1 answer
Import different module based on python version
Python
0 vote322 views1 answer
Pyton get minimum value of array
Python