How to iterate over string objects in pandas DataFrame

Question

I'm trying to start the Riiid Answer Correctness Prediction, and I got stuck in a very early phrase.

I would need to iterate over 'tags' column and count occurrences of each tag.

How do I extract, explode or change 'tags' values so that I could use value_counts() or apply(eval)?

gold_cy · Accepted Answer · 2021-04-08 14:08:05Z

1

You can actually achieve this with one line using pd.Series.str and pd.Series.explode.

df.tags.str.split().explode().value_counts()

131    5
162    4
38     2
36     1
29     1
81     1
149    1
5      1
51     1
92     1
101    1

answered Apr 8, 2021 at 14:08

gold_cy

14.2k4 gold badges27 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1