/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 vote134 views2 answers
Input spaces seperated integers in python
Python
1 vote126 views1 answer
Check if queryset is empty django template
Python
1 vote118 views1 answer
Sns title
Python
93 votes130 views4 answers
How to install python pyautogui
Python
31 votes123 views6 answers
Pandas join two dataframes
Python
24 votes131 views6 answers
How to save a pickle file
Python
1 vote122 views1 answer
Pandas join series
Python
0 vote138 views1 answer
Numpy compute mad
Python
10 votes135 views4 answers
How to know if python is 64 or 32 bit
Python
0 vote116 views1 answer
Week of the year pandas
Python