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

gzj137070928

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

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