擅长:python、mysql、java
<p>只需获取突出显示的值<code>1.75</code></p>
<pre><code>df2.loc[df2['Country']=='B', 3]
</code></pre>
<p>因此,概括上述内容并使用来自<code>df1</code>的国家权重密钥对:</p>
<pre><code>cost = []
for i in range(df1.shape[0]):
country = df1.loc[i, 'Country']
weight = df1.loc[i, 'Weight']
cost.append(df2.loc[df2['Country']==country, weight]
df1['Cost'] = cost
</code></pre>
<p>或者更好:</p>
<pre><code>df1['Cost'] = df1.apply(lambda x: df2.loc[df2['Country']==x['Country'], x['Weight'], axis=1)
</code></pre>