Input:
| memberid | serial |
|---|---|
| 1 | A,B,C |
| 2 | D,E |
Python, pandas expected Output:
| memberid | serial | serial_no |
|---|---|---|
| 1 | A,B,C | A |
| 1 | A,B,C | B |
| 1 | A,B,C | C |
| 2 | D,E | D |
| 2 | D,E | E |
Asked
Active
Viewed 7 times
0
Priti Jorvekar
- 13
- 2
-
`df.assign(serial_no=df['serial'].str.split(',')).explode('serial_no')` – mozway Mar 01 '23 at 08:15