/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 vote186 views1 answer
How to get the end of a item in a python array
Python
0 vote206 views1 answer
Ist comperension python
Python
0 vote229 views1 answer
How to store in parquet format using pandas
Python
1 vote220 views1 answer
Permanent redirect django
Python
0 vote236 views1 answer
Include app in django project
Python Django
2 votes159 views1 answer
Close chrome selenium python
Python
2 votes216 views1 answer
Change image resolution pillow
Python
0 vote216 views1 answer
Remove 0 values from dataframe
Python
0 vote233 views1 answer
How to instal django cities
Python Django
0 vote256 views1 answer
Return the number of times that the string "hi" appears anywhere in the given string. python
Python