擅长:python、mysql、java
<p>您可以计算一个inset并将其粘贴到原始数据帧中。笨拙,但与众不同。你知道吗</p>
<pre><code>rows = FamilyVsWWTotal['Customer'] == 'Google'
inset = FamilyVsWWTotal[rows].groupby(['date', 'Country'])['Revenues'].sum()
FamilyVsWWTotal.set_index(['date', 'Country'], inplace=True)
rows = FamilyVsWWTotal['Customer'] == 'Google'
FamilyVsWWTotal.loc[rows,'total1'] = inset
FamilyVsWWTotal.reset_index(inplace = True)
# date Country Customer Revenues total1
#0 2011-4-3 USA Exxon 1200 NaN
#1 2011-3-5 CAN Google 1800 1800.0
#2 2011-4-3 USA Google 1000 1000.0
#3 2011-5-7 MEX Microsoft 800 NaN
</code></pre>