/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 vote168 views1 answer
"backup-codes-username.txt
Python
0 vote166 views1 answer
Frequency unique pandas
Python
1 vote167 views2 answers
How to find the shortest word in a list python
Python
2 votes171 views2 answers
Add time to datetime python
Python
0 vote150 views1 answer
Input np.array
Python
1 vote170 views1 answer
Python enum
Python
0 vote159 views1 answer
Can the function inside a function be global if the function before it is global
Python
3 votes170 views4 answers
Replit
Python
0 vote194 views2 answers
Fetching data from multiple tables using related name in django
Python Django
69 votes167 views5 answers
Get text from txt file python
Python