/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 vote147 views1 answer
Flask run app reset on change
Python
2 votes269 views2 answers
Install wxPython
Python
0 vote204 views3 answers
How to create a User and User profile in django rest framework
Python
0 vote154 views2 answers
Tensorflow conv2d operation
Python
0 vote154 views1 answer
Pandas row printed horizontally
Python
0 vote145 views1 answer
Python - caéculate the average based on the level of a second column in a df
Python
0 vote154 views1 answer
How to upload to PyPi with same name
Python
1 vote157 views1 answer
Add help text in Django model forms
Python
0 vote145 views1 answer
Mad python
Python
8 votes162 views3 answers
Join dataframe pandas by column
Python