How to split a row into two or more based on a string in a column in pandas python?

Question

There is one column in my pandas dataframe with more information. I need to split this to different rows based on a punctuation in the values in the column. Could anyone please help me solve this.

What I have:

ProductId   Icecream                  State    Country
1           Vanilla;Strawberry        TN       IN
2           Blueberry;Vanilla;Mango   KL       IN

Expected Output:

ProductId   Icecream                  State    Country
1           Vanilla                   TN       IN
1           Strawberry                TN       IN
2           Blueberry                 KL       IN
2           Vanilla                   KL       IN
2           Mango                     KL       IN

score 3 · Answer 1 · answered Feb 04 '22 at 14:11

3

Use str.split and explode:

>>> df1.assign(Icecream=df1['Icecream'].str.split(';')).explode('Icecream')

   ProductId    Icecream State Country
0          1     Vanilla    TN      IN
0          1  Strawberry    TN      IN
1          2   Blueberry    KL      IN
1          2     Vanilla    KL      IN
1          2       Mango    KL      IN

answered Feb 04 '22 at 14:11

Corralien

70,617
7
16
36

https://meta.stackoverflow.com/questions/413387/why-is-there-such-a-large-quantity-of-beginner-python-questions-that-concern-pan#comment881785_413387 – jezrael Feb 04 '22 at 14:18
Do you think this question is not a dupe? https://stackoverflow.com/q/70986687/15239951 – Corralien Feb 04 '22 at 14:18
If yes, please close it. – jezrael Feb 04 '22 at 14:19

How to split a row into two or more based on a string in a column in pandas python?

1 Answers1