擅长:python、mysql、java
<p>使用<code>pandas.DataFrame.groupby</code>:</p>
<pre><code>grouped_item = df.groupby('Cust_num')['Item']
subsets = grouped_item.apply(lambda x: set(x)).tolist()
Count = [sum(s2.issubset(s1) for s1 in subsets) for s2 in subsets]
combo = grouped_item.apply(lambda x:','.join(x))
combo = combo.reset_index()
combo['Count']=Count
</code></pre>
<p>输出:</p>
^{pr2}$