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
  • 235,170
  • 19
  • 170
  • 241
BKS
  • 2,227
  • 4
  • 32
  • 53
  • 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