Transformation - Putting information that exists in two columns in one row

Question

I started learning python recently and I need your help. I have a dataframe with the following structure

I need to make a transformation, all values in column 2 (product id) that have the same order_id (column 1) must become a row and the values must be separated by commas.

Like this:

How can I make this transformation? Can somebody help me?

Thanks !

score 0 · Answer 1 · answered Aug 11 '19 at 18:45

0

You might want to refer to this question which is basically what you are asking for.

answered Aug 11 '19 at 18:45

Arafat Khan

777
1
10
24

score 0 · Accepted Answer · answered Aug 11 '19 at 19:21

0

You can get your desired result using the following code

df.groupby(['order_id'])['product_id'].apply(','.join).reset_index()

You can refer to the following answer for more applications: https://stackoverflow.com/a/27298308/6908282

answered Aug 11 '19 at 19:21

Gangula

5,193
4
30
59

I used the code that you put on your answer and it worked perfectly. Thanks for the help ! – Kirtash7 Aug 11 '19 at 21:02

Transformation - Putting information that exists in two columns in one row

2 Answers2