擅长:python、mysql、java
<p>使用<code>where</code></p>
<pre><code>>>> df['total_position'] = (df.total_position+df1.total_position).where(df.desk.eq(df1.desk) & df.Type.eq('ES'), 0)
>>> df
desk Type total_position
0 desk1 ES 28.0
1 desk2 ES1 0.0
2 desk3 ES -29.0
3 desk4 ES1 0.0
4 desk5 ES 29.0
</code></pre>