Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Userid, Productid, Ordered_Qty
- user1 1 1
- user1 2 1
- user1 3 1
- user2 4 1
- user2 5 1
- user2 3 1
- user3 2 1
- user3 4 1
- user3 5 1
- Productid, some_attribute
- 1 "xsff"
- 2 "xsff"
- 3 "xsff"
- 4 "xsff"
- 5 "xsff"
- Row - Userid from df1
- columns - Productid from df2
- 1 2 3 4 5
- user1 1 1 1 0 0
- user2 0 0 1 1 1
- user3 0 1 0 1 1
- new_dataframe = pd.dataframe(0,index=df1.Userid.unique(),columns=df2.Productid.unique())
- for index,row in df1.iterrows():
- userid = row['Userid']
- productid = row['Productid']
- ord_qty = row['Ordered_Qty']
- new_dataframe.loc[userid][productid] = ord_qty
Add Comment
Please, Sign In to add comment