擅长:python、mysql、java
<p>您可以使用比率<code>df['diff'] / df['pv']</code>并使用字典映射:</p>
<pre><code>ratio = df['diff'].div(df['pv']).clip(-1, 1)
# or ratio = np.minimum(1, np.maximum(-1, df['diff'] / df['pv']))
d = {-1: 'excess', 1: 'short'}
df['flag'] = ratio.map(d).fillna('pass')
print(df)
code diff pv flag
0 0 -344 100 excess
1 1 344 100 short
2 2 2 100 pass
3 3 -5 150 pass
4 4 -200 150 excess
5 5 200 150 short
</code></pre>