擅长:python、mysql、java
<p>可以使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.merge.html" rel="nofollow">^{<cd1>}</a>在<code>ISIN</code>上自动执行内部联接。下面这一行代码应该可以让您继续:</p>
<pre><code>df3 = pd.merge(df1, df2)[['Security', 'Value']]
</code></pre>
<p>结果是<code>df3</code>:</p>
<pre><code> Security Value
0 DEF 100
1 JHK 200
2 OPQ 300
</code></pre>
<p>完全可复制的代码示例如下:</p>
<pre><code>import pandas as pd
df1 = pd.DataFrame({
'Security': ['ABC', 'DEF', 'JHK', 'LMN', 'OPQ'],
'ISIN' : ['I1', 'I2', 'I3', 'I4', 'I5']
})
df2 = pd.DataFrame({
'Value': [100, 200, 300],
'ISIN' : ['I2', 'I3', 'I5']
})
df3 = pd.merge(df1, df2)[['Security', 'Value']]
print(df3)
</code></pre>