擅长:python、mysql、java
<p>IIUC用途:</p>
<pre><code>df['Sum']=df.groupby('Type').transform('sum')
df.loc[df[['Type','Sum']].duplicated(),['Type','Sum']]=''
print(df)
</code></pre>
<hr/>
<pre><code> Type Val Sum
0 A 1 3
1 2
2 B 3 12
3 4
4 5
5 C 6 6
</code></pre>
<p>备注:您也可以将此添加为索引:</p>
<pre><code>df=df.set_index(['Type','Sum']) #export to excel without index=False
</code></pre>
<hr/>
<p><a href="https://i.stack.imgur.com/nZOWw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nZOWw.png" alt="enter image description here"/></a></p>