My dataset is similar to this dataset:
| Order ID | Customer id | Item purchased | Color |
|---|---|---|---|
| 1234 | 1010 | Apple | red |
| 1234 | 1010 | Cherry | red |
| 1234 | 1010 | Orange | orange |
| 1234 | 1010 | Banana | yellow |
| 5678 | 1010 | Apple | green |
| 5678 | 1010 | Orange | orange |
How can I map the order id and customer id in the dataframe to make my dataframe look like this:
| Order ID | Customer id | Apple | Cherry | Orange | Banana |
|---|---|---|---|---|---|
| 1234 | 1010 | red | red | orange | yellow |
| 5678 | 1010 | green | Nan | orange | Nan |
I did try join and group by customerID and orderID but it didn’t give me the expected dataframe
