擅长:python、mysql、java
<p>尝试:</p>
<pre><code>df.merge(pd.get_dummies(df.set_index('customer_id')
.explode('department'),
prefix='',
prefix_sep='').sum(level=0),
left_on='customer_id', right_index=True)
</code></pre>
<p>输出:</p>
<pre><code> customer_id department fragrance men_fragrance men_skincare nail skincare
0 11 [nail, men_skincare] 0 0 1 1 0
1 23 [nail, fragrance] 1 0 0 1 0
2 25 [] 0 0 0 0 0
3 45 [skincare, men_fragrance] 0 1 0 0 1
</code></pre>