Guest User

Untitled

a guest
Jun 25th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. df
  2. id list_of_tuples
  3. 0 abc-123 [('cat',100,'xyz-123'),('cat',96,'uvw-456')]
  4. 1 def-456 [('dog',98,'rst-789'),('dog',97,'opq-123'),('dog',95,'lmn-123')]
  5. 2 ghi-789 [('tree',100,'ijk-123')]
  6.  
  7. df_new
  8. id val_1 val_2 val_3
  9. 0 abc-123 cat 100 xyz-123
  10. 1 abc-123 cat 96 uvw-456
  11. 2 def-456 dog 98 rst-789
  12. 3 def-456 dog 97 opq-123
  13. 4 def-456 dog 95 lmn-123
  14. 5 ghi-789 tree 100 ijk-123
  15.  
  16. df_new = pd.DataFrame(list(chain.from_iterable(df.matches)),columns=['val_1','val_2','val_3']).reset_index(drop=True)
  17. df_new['id'] = np.repeat(df.id.values, df['list_of_tuples'].str.len())
Add Comment
Please, Sign In to add comment