擅长:python、mysql、java
<p>您可以<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html" rel="nofollow noreferrer">^{<cd1>}</a>,<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.groupby.html" rel="nofollow noreferrer">^{<cd2>}</a><code>IDCol1</code>并与<code>sum</code>聚合:</p>
<pre><code>(DataframeA.merge(DataframeB, left_on='IDCol2', right_on='ColA')
.groupby('IDCol1')
.IDCol3.sum()
.reset_index())
IDCol1 IDCol3
0 ABC 8
1 CDE 9
</code></pre>