Split rows in Pandas into multiple rows based on a semicolon, but the change appears only in one column and not in others

Asked Feb 13 '23 at 09:09

Active Feb 13 '23 at 09:18

Viewed 18 times

I have a dataframe of the form:

Sl No. | description1 | description2

1              dog;lion;tiger         sentence1
2              cat;pet;elephant       sentence2

I want the output like this:

Sl No. | description1 | description2

1              dog             sentence1
               lion
               tiger

2              cat             sentence2
               pet
               elephant

I tried the explode function but it did not give me the desired result.

edited Feb 13 '23 at 09:18

asked Feb 13 '23 at 09:09

Animesh panda

def jsonify(x): list1 = list(x.split(";")) #a = x.split(";", 1)[0] return list1 df['descrip']=df['description1'].apply(jsonify) – Tornike Kharitonishvili Feb 13 '23 at 09:37
df = df.explode('descrip') – Tornike Kharitonishvili Feb 13 '23 at 09:37

Split rows in Pandas into multiple rows based on a semicolon, but the change appears only in one column and not in others

Sl No. | description1 | description2

Sl No. | description1 | description2

0 Answers0