Guest User

Untitled

a guest
Jan 22nd, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. Userid, Productid, Ordered_Qty
  2. user1 1 1
  3. user1 2 1
  4. user1 3 1
  5. user2 4 1
  6. user2 5 1
  7. user2 3 1
  8. user3 2 1
  9. user3 4 1
  10. user3 5 1
  11.  
  12. Productid, some_attribute
  13. 1 "xsff"
  14. 2 "xsff"
  15. 3 "xsff"
  16. 4 "xsff"
  17. 5 "xsff"
  18.  
  19. Row - Userid from df1
  20. columns - Productid from df2
  21.  
  22. 1 2 3 4 5
  23. user1 1 1 1 0 0
  24. user2 0 0 1 1 1
  25. user3 0 1 0 1 1
  26.  
  27. new_dataframe = pd.dataframe(0,index=df1.Userid.unique(),columns=df2.Productid.unique())
  28.  
  29. for index,row in df1.iterrows():
  30. userid = row['Userid']
  31. productid = row['Productid']
  32. ord_qty = row['Ordered_Qty']
  33. new_dataframe.loc[userid][productid] = ord_qty
Add Comment
Please, Sign In to add comment