/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 vote136 views1 answer
Python for print
Python
0 vote127 views2 answers
Remove nans and infs python
Python
1 vote163 views2 answers
Python alphabetical order
Python
3 votes142 views2 answers
Count how many vowels in a string python
Python
0 vote147 views1 answer
How to create pyw file
Python
0 vote197 views2 answers
Get the creating date of files ftp python
Python
0 vote147 views4 answers
Boxplot python
Python
11 votes133 views1 answer
Python discord
Python
0 vote138 views1 answer
Matplotlib remove ticks and lines
Python
0 vote146 views1 answer
Two legend left and right x asix matplotlib
Python