/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 vote302 views1 answer
Increase contrast cv2
Python
4 votes302 views1 answer
How To Exit Console On Python
Python
0 vote318 views1 answer
RuntimeError: cuda runtime error (711) : peer mapping resources exhausted at /pytorch/aten/src/THC/THCGeneral.cpp:139
Python
0 vote304 views1 answer
Jhoom.In
Python
16 votes292 views6 answers
Turtle
Python
0 vote322 views1 answer
Torch.nn.Linear(in_features, out_features, bias=True) discription
Python
71 votes254 views10 answers
Sus sus sus
Python
8 votes294 views1 answer
X = df.iloc[:, 1:]
Python
0 vote281 views1 answer
Numpy logical _and
Python
1 vote299 views1 answer
Install chromedriver ubuntu python
Python