擅长:python、mysql、java
<p>我会选择<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html" rel="nofollow noreferrer">merge</a>:</p>
<pre><code>import pandas as pd
y = pd.DataFrame({'A': [1, 1, 3],
'B': list('aac'),
'C': list('ddf'),
'D': [4, 5, 6]})
x = pd.DataFrame([[1, 'a', 'd']],
columns=list('ABC'))
match = x.merge(y, on=x.columns.tolist())
match
# A B C D
#0 1 a d 4
#1 1 a d 5
</code></pre>