擅长:python、mysql、java
<p>对<a href="https://stackoverflow.com/a/47373609/6671176">answer you linked</a>的一些小修改可以满足您的需要:</p>
<pre><code>df1 = df[['col1', 'col2']].apply(sorted, 1, result_type = "expand").rename(columns = {0:'col1', 1:'col2'})
df.groupby([df1.col1, df1.col2]).sum().reset_index()
col1 col2 count
0 A B 15
1 A C 7
2 A D 9
3 B C 4
4 C D 8
5 D E 5
</code></pre>