<p>我有两个类似这样的CSV文件,希望通过匹配两个数据帧中的列(test,cond),在df2(LL,UL)的基础上更新df1列(LL,UL)<br/>
<strong>df1:</strong></p>
<pre><code>test Cond day mode LL UL
a T1 Tue 7
b T2 mon 7
c T2 sun 6
d T3 fri 3
c T2 sat 6
d T3 wed 3
</code></pre>
<p><strong>df2:-</strong></p>
<pre><code>test Cond LL UL
a T1 15 23
b T2 -3 -3.5
c T2 -19 -11
d T3 6.5 14.5
</code></pre>
<p>我的预期产出应该是:-</p>
<p><a href="https://i.stack.imgur.com/c4Loq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c4Loq.png" alt="enter image description here"/></a></p>
<pre><code>def SpecsLL(cond1,test1):
if ((cond1==spec['Cond'] ) & (test1==spec['test'])):
return df2['LL']
df1['LL'] = df1.apply(lambda x: SpecsLL(x['Cond'],x['test']),axis=1)
</code></pre>
<p>我尝试了上述代码,但没有成功。<br/>
有什么办法吗</p>