擅长:python、mysql、java
<p>使用<code>collections.Counter</code>+<code>itertools.chain</code>:</p>
<pre><code>from collections import Counter
from itertools import chain
c = Counter(chain.from_iterable(df['column_name'].str.split('|')))
res = pd.Series(c)
print(res)
book 3
campfire 1
fish 2
icecream 1
dtype: int64
</code></pre>