擅长:python、mysql、java
<p>您可以使用<code>get_dummies</code>和<code>explode</code>获取值计数,然后使用<code>sum</code>创建总数</p>
<pre><code>(
pd.get_dummies(df.explode('values'), columns=['values'], prefix='', prefix_sep='')
.groupby('keys').sum()
.pipe(lambda x: x.assign(total= x.sum(axis=1)))
.reset_index()
)
keys eats leaves shoots total
0 panda1 1 0 1 2
1 panda2 0 1 1 2
2 panda3 1 1 0 2
</code></pre>