/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

0 vote131 views1 answer
Waiting in python. time , sleep
Python
1 vote192 views1 answer
Updating many to many field in django using pk
Python Django
0 vote133 views1 answer
Wexpect in python
Python
0 vote179 views1 answer
Python Print Variable Using comma , character to separate the variables in a print statement
Python
0 vote125 views1 answer
How to get the positions where values of two columns match?
Python
0 vote126 views1 answer
Flask - store object directly in a session [duplicate]
Python
10 votes131 views4 answers
Discord.py events
Python
0 vote256 views1 answer
Selenium python get element by type
Python
7 votes146 views2 answers
Pandas read_csv ignore unnamed columns
Python
0 vote136 views1 answer
Supprimer fichier pythpn
Python