擅长:python、mysql、java
<p>我会{<cd1>}然后{<cd2>}:</p>
<pre><code>df1['total_position'] = (df1['total_position'].add(
df1['desk'].map(df2.set_index('desk')['total_position']))
print(df1)
</code></pre>
<hr/>
<pre><code> 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>
<p>编辑类型:</p>
<pre><code>m = (df1['desk'].map(df2.set_index('desk')['total_position'])
.where(df1['Type'].eq('ES')).fillna(0))
df1['total_position'] = df1['total_position'].add(m)
print(df1)
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>