擅长:python、mysql、java
<p>使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.add.html" rel="nofollow noreferrer">^{<cd1>}</a>,但首先根据<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.set_index.html" rel="nofollow noreferrer">^{<cd3>}</a>从<code>n</code>列创建索引:</p>
<pre><code>df = (df2.set_index('n')['column2']
.add(df1.set_index('n')['column1'], fill_value=0)
.reset_index(name='column1'))
print (df)
n column1
0 5.0 0.0
1 6.0 1.0
2 7.0 1.0
3 8.0 1.0
4 9.0 0.0
5 10.0 0.0
</code></pre>
<p>另一个带有<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html" rel="nofollow noreferrer">^{<cd4>}</a>和左连接的解决方案:</p>
^{pr2}$