擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.merge.html" rel="nofollow noreferrer">merge</a></p>
<pre><code>print (pd.merge(df1, df2, on=['SubNo','Trails'], how='left'))
</code></pre>
<hr/>
<pre><code>SubNo Trails Score Height
1 1 4 100
1 2 4 200
7 1 9 300
</code></pre>