擅长:python、mysql、java
<p>下面是我要做的:
首先,列出第一个数据帧中的用户</p>
<pre><code>user_list = first_df.UserId.unique().tolist()
</code></pre>
<p>然后遍历此列表和第二个数据库,如下所示:</p>
<pre><code>revenue_total = 0
for i in range(len(user_list)):
for x in range(len(second_df):
if second_df['userid'][x] == user_list[i] and second_df['Date'][x] <= first_df['WeekAfterRegDate'][i]:
revenue_total = revenue_total + second_df['Revenue'][x]
</code></pre>
<p>然后,只需将总收入除以总用户数即可</p>
<pre><code> total_revenue /len(user_list)
</code></pre>