unpivot or melt a given data frame to the desired output

Asked Dec 18 '21 at 05:13

Active Dec 18 '21 at 05:32

Viewed 19 times

the data which I have look like

Name   Number
A1      12,13,14,15
A2       8,9,10
A3       5,6,7
A4       3,5,7

output should come in the format

Name     Number
A1        12
A1        13
A1        14
A1        15
A2         8
.          .
.
.          .

tried unpivot, tried stack() after splitting data. not able to get to desired output

edited Dec 18 '21 at 05:32

Quang Hoang

asked Dec 18 '21 at 05:13

athreya

`df.assign(Number=df['Number'].str.split(',')).explode('Number')`. – Quang Hoang Dec 18 '21 at 05:33
Thank you soo much. got the expected result – athreya Dec 18 '21 at 09:11

0 Answers0