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

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.

https://stackoverflow.com/questions/12680754/split-explode-pandas-dataframe-string-entry-to-separate-rows — , Jan 08 '22 at 11:57

score 4 · Accepted Answer · answered Jan 08 '22 at 12:01

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 08 '22 at 12:01

Antoine

Perfect! Thank you. – user12345 Jan 08 '22 at 12:45
If this solves your issue could you please validate the answer – Antoine Jan 08 '22 at 14:40

1 Answers1