/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 vote264 views1 answer
Python make button do more than one command
Python
0 vote280 views1 answer
Counter in sort python
Python
13 votes278 views3 answers
Window in python
Python
0 vote387 views1 answer
How to pre populate field flask wtforms
Python Flask
2 votes246 views1 answer
Copy website python
Python
0 vote270 views1 answer
Concatenating datfra,esin pandas
Python
0 vote257 views2 answers
Torch tensor to pandas dataframe
Python
9 votes252 views2 answers
How copy and create same conda environment
Python
2 votes296 views2 answers
Python module for converting miles to km
Python
0 vote259 views1 answer
Python measure volum from audio file
Python