擅长:python、mysql、java
<p>你可以<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html#pandas.DataFrame.merge" rel="nofollow noreferrer">merge</a>然后它们会倍增:</p>
<pre><code>merged = df1.merge(df2, on=['Name', 'Event'])
merged['ResultFactor'] = merged.Factor1 * merged.Factor2
result = merged.drop(['Factor1', 'Factor2'], axis=1)
print(result)
</code></pre>
<p><strong>输出</strong></p>
<pre><code> Name Event ResultFactor
0 John A 2.4
1 John B 1.5
2 Ken A 3.0
</code></pre>