Python: How to expand column with list of values to multiple rows? [duplicate]

Question

Have got a df which looks like this:

Item    Match
a       bb,cc
b       dd,ee

want to expland the column 'Match' as below:

Item    Match
a       bb
a       cc
b       dd
b       ee

tried df.explode('Match') but didn't worked for me. Kindly share your ideas.

Antoine · Accepted Answer · 2022-01-08 12:01:42Z

4

I think this will solve your issue:

import pandas as pd
df = pd.DataFrame({"Item": ["a", "b"], "Match": ["bb,cc", "dd,ee"]})
df["Match"] = df["Match"].str.split(",")
df.explode("Match")

answered Jan 8, 2022 at 12:01

Antoine

5774 silver badges19 bronze badges

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

2 Comments

Perfect! Thank you.

If this solves your issue could you please validate the answer