I am looking for solution that can make the new dataframe if on the location of dataframe has presence of list object. If it is a list than add only those elements in diffrent rows without affecting other data.
# Sample dataframe
No. Name Skill Exp
0 ABC [a,b,c] [0,2,3]
1 XYZ [e,f] [3,4]
2 EFG h 2
3 PQR g 3
but I want to convert the dataframe as follows:
# Output Dataframe
No. Name Skill Exp
0 ABC a 0
b 2
c 3
1 XYZ e 3
f 4
2 EFG h 2
3 PQR g 3