test.csv数据如下:
old other
0 50 51
1 39 40
2 40 41
3 24 25
4 50 51
5 40 41
6 35 36
7 50 51
8 50 51
9 50 51
**************************************************
import pandas as pd
import random
df=pd.read_csv("test.CSV")
print(df)
print("*"*50)
df["new1"]=df[df.old<40].apply(lambda x: random.randint(45,50),axis=1)
df["new2"]=df[df.old>=40].old
print(df)
print("+"*50)
df=df.fillna(0)
df["new"]=df["new1"]+df["new2"]
print(df)
print("-"*50)
**************************************************
输出结果如下:
old other
0 50 51
1 39 40
2 40 41
3 24 25
4 50 51
5 40 41
6 35 36
7 50 51
8 50 51
9 50 51
**************************************************
old other new1 new2
0 50 51 NaN 50.0
1 39 40 47.0 NaN
2 40 41 NaN 40.0
3 24 25 50.0 NaN
4 50 51 NaN 50.0
5 40 41 NaN 40.0
6 35 36 50.0 NaN
7 50 51 NaN 50.0
8 50 51 NaN 50.0
9 50 51 NaN 50.0
++++++++++++++++++++++++++++++++++++++++++++++++++
old other new1 new2 new
0 50 51 0.0 50.0 50.0
1 39 40 47.0 0.0 47.0
2 40 41 0.0 40.0 40.0
3 24 25 50.0 0.0 50.0
4 50 51 0.0 50.0 50.0
5 40 41 0.0 40.0 40.0
6 35 36 50.0 0.0 50.0
7 50 51 0.0 50.0 50.0
8 50 51 0.0 50.0 50.0
9 50 51 0.0 50.0 50.0
--------------------------------------------------


雷达卡



京公网安备 11010802022788号







