0

I have a dataframe that looks like this:

     mAID  MAID  PIDs
0    A     D     [YY, ZZ]
1    B     E     [XY]
2    A     E     [YY, XX]
3    A     F     [YY, XX, ZZ]

I want to convert it to such:

 mAID  MAID  PIDs
 A     D     YY
 A     D     ZZ
 B     E     XY
 A     E     YY
 A     E     XX 
 A     F     YY
 A     F     XX
 A     F     ZZ

Thank you.

eyllanesc
  • 221,139
  • 17
  • 121
  • 189
BKS
  • 1,977
  • 3
  • 24
  • 48
  • There are multiple method , you can pick and choice – BENY Jun 29 '19 at 02:42
  • try `pd.DataFrame(df.PIDs.str.replace('\[|\]', '').str.split(',').tolist(), index=[df.mAID, df.MAID]).stack().reset_index()` – steven Jun 29 '19 at 03:16

0 Answers0