熊猫中有以下数据帧:
code diff pv
0 -34 100
1 34 100
2 16 100
3 -50 150
我想要的数据帧是:
code diff pv flag
0 -344 100 excess
1 344 100 short
2 2 100 pass
3 -5 150 pass
4 -200 150 excess
5 200 150 short
flag
列的逻辑
short = diff is positive > pv
excess = diff is negative < -pv (pv is taken to be negative)
pass = if the diff is within range of +- PV
我怎样才能在熊猫身上做到这一点
以下是最佳使用^{} :
您可以使用比率
df['diff'] / df['pv']
并使用字典映射:我会这样做的
我将
func
应用于df
的每一行相关问题 更多 >
编程相关推荐