擅长:python、mysql、java
<p>您可以简单地<strong><a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html" rel="nofollow noreferrer">concat</a></strong><code>df1</code>,<code>df2</code>,然后用<code>df0</code>执行<strong><a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html" rel="nofollow noreferrer">merge</a></strong></p>
<pre><code>df0.merge(pd.concat([df1,df2]), on='ClientName')
</code></pre>
<p>输出:</p>
<pre><code>ClientName City State ClientNumber
JohnSmith Dallas TX 100
JaneDoe Dallas TX 101
LucasAult Dallas TX 102
CarsonSeibert Dallas TX 103
</code></pre>