擅长:python、mysql、java
<pre><code>FamilyVsWWTotal.assign(total1=FamilyVsWWTotal[FamilyVsWWTotal.Customer.eq('Google')].groupby(['date', 'Country']).Revenues.transform('sum'))
Country Customer Revenues date total1
0 USA Exxon 1200 2011-4-3 NaN
1 CAN Google 1800 2011-3-5 1800.0
2 USA Google 1000 2011-4-3 1000.0
3 MEX Microsoft 800 2011-5-7 NaN
</code></pre>
<hr/>
<p>同样的事情,但打破了秩序</p>
<pre><code>FamilyVsWWTotal.assign(
total1=FamilyVsWWTotal[FamilyVsWWTotal.Customer.eq('Google')].groupby(
['date', 'Country']
).Revenues.transform('sum')
)
Country Customer Revenues date total1
0 USA Exxon 1200 2011-4-3 NaN
1 CAN Google 1800 2011-3-5 1800.0
2 USA Google 1000 2011-4-3 1000.0
3 MEX Microsoft 800 2011-5-7 NaN
</code></pre>