擅长:python、mysql、java
<p>按列<code>AREA</code>创建索引,以便在与<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.select_dtypes.html" rel="nofollow noreferrer">^{<cd2>}</a>求和之前对齐:</p>
<pre><code>dfTotal = ((df1.set_index('AREA').select_dtypes(np.number) +
df2.set_index('AREA').select_dtypes(np.number))
.reset_index())
print (dfTotal)
AREA NUM1 NUM2
0 london 15 15
</code></pre>
<p>一般解决方案:</p>
<pre><code>dfs = [df1, df2]
L = [x.set_index('AREA').select_dtypes(np.number) for x in dfs]
dfTotal = pd.concat(L).sum(level=0).reset_index()
print (dfTotal)
AREA NUM1 NUM2
0 london 15 15
</code></pre>