之前文章,提供了10個(gè)學(xué)習(xí)小案例,今天再分享一些。
Case1 將溫度在某個(gè)區(qū)間置為1,不在區(qū)間為0
data = {'Day': [1,2,3,4],
'Temperature': [20,30,40,50]
}
Day Temperature
0 1 20
1 2 30
2 3 40
3 4 50
df['Temperature'] = np.where(df['Temperature'].between(25, 45), 1, 0)
Day Temperature
0 1 0
1 2 1
2 3 1
3 4 0
Case2 去除所有帶有特殊字符的列
X1 X2_nan x3 x4_nan
34 0 65.8 1
35 1 5432.1 1
87 1 443.1 0
65 0 213.3 0
df = df.loc[:, ~df.columns.astype(str).str.contains('nan')]
X1 x3
0 34 65.8
1 35 5432.1
2 87 443.1
3 65 213.3