擅长:python、mysql、java
<p>您可以使用<code>concat</code>和<code>groupby</code>:</p>
<pre><code>(pd.concat([df1,df2], sort=False)
.groupby('Country', sort=False,as_index=False)
.agg('first')
)
</code></pre>
<p>输出:</p>
<pre><code> Country 2014 2015 2016 2017 2018 2019
0 USA 319.0 321.0 323.0 325.0 328.0 330.0
1 UK 58.0 60.0 NaN 63.0 65.0 68.0
2 India 780.0 810.0 800.0 NaN 1100.0 1300.0
3 China NaN NaN 1100.0 1200.0 1300.0 NaN
4 Nigeria 90.0 100.0 105.0 NaN NaN 110.0
</code></pre>