/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 vote143 views1 answer
Python implode list
Python
5 votes134 views2 answers
Pip pandas
Python
0 vote148 views1 answer
Check substring frequency in a text python
Python
21 votes96 views1 answer
Raise en python
Python
0 vote140 views1 answer
Pandas print a single row
Python
8 votes132 views1 answer
Créer des variable dynamiques python
Python
1 vote162 views1 answer
Unresolved reference 'django'
Python Django
2 votes142 views2 answers
How to round to the nearest 25 python
Python
0 vote157 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python
3 votes168 views2 answers
Python print do not use scientific notation
Python