/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

2 votes316 views2 answers
Python url join
Python
0 vote333 views1 answer
How to colour letters in python
Python
0 vote343 views1 answer
Append a line to a text file using the write() function
Python
61 votes362 views6 answers
Python pause
Python
75 votes313 views3 answers
How to get a random element from an array in python
Python
4 votes360 views1 answer
Django pandas queryset
Python Django
0 vote366 views1 answer
Flask print request headers
Python
0 vote341 views1 answer
Configuring tailwindcss, vue and laravel
Python
0 vote367 views1 answer
Best fit line python log log scale
Python
0 vote324 views1 answer
Pytest suppress errors
Python