/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 vote108 views1 answer
Matplotlib show percentage y axis
Python
6 votes122 views4 answers
Google Translate English to Spanish
Python
4 votes117 views2 answers
Add y axis label matplotlib
Python
0 vote116 views1 answer
Reopen closed file python
Python
0 vote124 views1 answer
Split the string using the separator
Python
0 vote112 views1 answer
Pop up window flutter
Python
0 vote108 views1 answer
Value = int(line.rsplit(':', 1)[1].strip()) ValueError : invalid literal for int() with base 10: '' grass gis
Python
0 vote124 views1 answer
Python[17586:513448] ApplePersistenceIgnoreState: Existing state will not be touched. New state will be written to
Python
25 votes130 views4 answers
How to write if statement in one line python
Python
0 vote112 views1 answer
Evaluate value of polynomial in python code
Python