擅长:python、mysql、java
<p>以下是我的建议:</p>
<pre><code>df_restrict['V1']=df_restrict.merge(df_ref, left_on=['ID', 'V1'], right_on=['ID', 'REF'])['VALUE']
df_restrict['V2']=df_restrict.merge(df_ref, left_on=['ID', 'V2'], right_on=['ID', 'REF'])['VALUE']
>>> print(df_restrict)
ID V1 V2
0 A 12 36
1 B 81 67
2 C 123 89
</code></pre>