擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.set_index.html" rel="nofollow noreferrer">^{<cd1>}</a>将<code>df1</code>和<code>df2</code>的索引设置为<code>Item_id</code>,然后使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.combine_first.html" rel="nofollow noreferrer">^{<cd5>}</a>:</p>
<pre><code>df = df2.set_index('Item_id')\
.combine_first(df1.set_index('Item_id')).reset_index()
</code></pre>
<p>结果:</p>
<pre><code>print(df)
Item_id Country Compay
0 1 Germany sitz.co
1 2 Russia likrds.co
2 3 Denmark Axitr.co
3 4 Italy ghrx.co
4 11 Argentina sitz.co
5 13 Denmark Axitr.co
</code></pre>