擅长:python、mysql、java
<p>IIUIC,你需要</p>
<pre><code>In [715]: df['Sum'] = df.groupby('Type')['No'].transform(lambda x: x.unique().sum())
In [716]: df
Out[716]:
Title Product No Type Sum
0 A Mo 3 Sky 5
1 A Mo 3 Sky 5
2 A Mo 3 Sky 5
3 A Md 2 Sky 5
4 A Md 2 Sky 5
5 A Md 2 Sky 5
6 A Md 6 Land 11
7 A Md 6 Land 11
8 A Md 6 Land 11
9 A Mo 5 Land 11
10 A Mo 5 Land 11
</code></pre>