擅长:python、mysql、java
<p>你也可以试试这个方法:</p>
<pre><code># set indexes
data1 = data1.set_index('c')
data2 = data2.set_index('c')
# join data on indexes
datax = data1.join(data2.drop('d', axis=1), rsuffix='_rr').reset_index()
# fill missing value in column a
datax['a'] = datax['a'].fillna(datax['a_rr'])
# drop unwanted columns
datax.drop('a_rr', axis=1, inplace=True)
# fill missing values with blank spaces
datax.fillna('', inplace=True)
# output
a b c
0 a1 b1 c1
1 2a b2 c2
2 a3 c3
</code></pre>
<hr/>
^{pr2}$