擅长:python、mysql、java
<p>我想你需要康卡特</p>
<pre><code>result = pd.concat([df1.set_index('id'), df2.set_index('id')],axis = 1).reset_index()
</code></pre>
<p>你得到了吗</p>
<pre><code> id item_no description
0 A123 1 Mary had a...
1 A123 2 ...little lamb
2 B456 1 ...Its fleece...
</code></pre>