pandas的数据清洗——删除NaN数据2

gzj137070928

pandas的数据清洗——删除NaN数据2
如果想保留含有若干非空值的行或者列可以使用thresh参数。

1. import pandas as pd
   
2. import numpy as np
   
3. val = np.arange(10, 38).reshape(7, 4)
   
4. col = list("abcd")
   
5. idx = "cake make fake sake wake lake take".split()
   
6. df = pd.DataFrame(val, columns = col, index = idx)
   
7. df["e"] = np.nan
   
8. df.at["make", "e"] = 100
   
9. df["f"] = np.nan
   
10. df.loc["gake"] = np.nan
    
11. print (df)
    
12. df.dropna(axis = 1, thresh = 2,inplace=True)  # 至少有两个非NaN的列留下
    
13. print('至少有两个非NaN的列留下',df)

复制代码