/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 vote243 views1 answer
Pythongalaxy.com
Python
3 votes253 views2 answers
Scapy python import
Python
5 votes236 views1 answer
Check if special character in string python
Python
0 vote289 views1 answer
Import sys execute cmd
Python
0 vote242 views1 answer
Rolling call on one column and groupby second pandas
Python
0 vote255 views1 answer
X not defined python
Python
0 vote254 views2 answers
Attributeerror module 'datetime' has no attribute 'now' python
Python
1 vote261 views1 answer
Counter in django template
Python Django
3 votes244 views4 answers
Pair Plot Seaborn
Python
3 votes228 views1 answer
Discord python webhook
Python