/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 vote177 views1 answer
Sys.path[0]
Python
7 votes239 views4 answers
Modules in python
Python
0 vote245 views1 answer
Dict itterator python recursive
Python
0 vote231 views1 answer
How to install flask module in vscode
Python Flask
3 votes186 views3 answers
Python resize image keep aspect ratio
Python
1 vote175 views7 answers
Java to python
Python
27 votes274 views2 answers
Easy sending email python
Python
19 votes183 views1 answer
Python cut string to length
Python
0 vote180 views3 answers
Autoextract scrapy spider
Python
7 votes188 views1 answer
How to slicing dataframe using two conditions
Python