擅长:python、mysql、java
<p>下面是我测试过的工作代码的简短说明,您不必显式复制</p>
<pre><code>result = df.loc[df['assetClass'].isin([2,3])].groupby(['clientID','date']).sum() #first select rows from 'assetClass' having values 2 and 3.
#Then groupby clientID and date and then sum
result['assetClass'] = 99 # equate assetClass to 99
df = df.append(result) # merge this to existing dataframe
</code></pre>