擅长:python、mysql、java
<p>这可能有用</p>
<p><code>pd.concat([df1, df2]).sort_values('Item_ID').drop_duplicates(['Item_ID'], keep='last')</code></p>
<pre><code> Item_ID Location Name Order_ID Type
0 20 IL John 1.0 cable
0 21 IL John 1.0 NaN
1 22 LA Ron 2.0 cable
2 23 LA Ron 2.0 Box
2 24 LA Ron 2.0 NaN
3 25 LA Ron 3.0 NaN
3 26 LA Ron 3.0 cable
4 27 IL NaN NaN Box
5 29 IL John 5.0 Box
</code></pre>