擅长:python、mysql、java
<p>使用<code>groupby</code>和<code>agg</code>:</p>
<pre><code>df.groupby(['Chromosome', 'Position', 'Gene']).SAMPLE.agg([list, 'count'])
list count
Chromosome Position Gene
1 100 CHD1 [S1, S4] 2
220 BRCA2 [S2, S5] 2
300 TP53 [S3] 1
</code></pre>
<hr/>
<pre><code>(df.groupby(['Chromosome', 'Position', 'Gene']).SAMPLE
.agg([list, 'count'])
.reset_index())
Chromosome Position Gene list count
0 1 100 CHD1 [S1, S4] 2
1 1 220 BRCA2 [S2, S5] 2
2 1 300 TP53 [S3] 1
</code></pre>