擅长:python、mysql、java
<p><strong><em>设置</em></strong></p>
<pre><code>df2 = pd.DataFrame([
['YYZ', 'SFO', 1],
['YYZ', 'YYD', 1]
], columns=['city1', 'city2', 'val'])
cols = ['city1', 'city2']
</code></pre>
<p><strong><em>选项1</em></strong><br/>
<code>numpy</code><code>broadcasting</code></p>
^{pr2}$
<p><strong><em>选项2</em></strong><br/>
<code>pandas</code><code>merge</code></p>
<pre><code>df2.merge(df1, on=cols)
city1 city2 val
0 YYZ SFO 1
</code></pre>
<p><strong><em>选项3</em></strong><br/>
不知道叫什么,不推荐。在</p>
<pre><code>idx = pd.MultiIndex.from_arrays(df1.values.T, names=df1.columns)
df2[df2[cols].apply(tuple, 1).isin(idx)]
city1 city2 val
0 YYZ SFO 1
</code></pre>