I have a raw data like this and I want to create a new transaction data frame group by customer_id like this
How should I do in python? Pleaseeeee~
Asked
Active
Viewed 300 times
-2
nisawaras
- 15
- 3
1 Answers
0
nisawaras, welcome to community (in the future the questions should be more precise)
data = {'customer_id': [1,1,2 ], 'menu_id': ['Cake','Water','Candy']}
df = pd.DataFrame(data)
grouped = df.groupby(['customer_id'])['menu_id'].apply(', '.join).reset_index()
grouped
output:
Piotr Żak
- 2,046
- 5
- 18
- 30
-
Thank you for your answer❤️ but i want to create a new column as cake for column 0 and water for column 1 and candy for column 0 in new row – nisawaras Sep 04 '21 at 13:33
-
https://stackoverflow.com/questions/14745022/how-to-split-a-dataframe-string-column-into-two-columns – Piotr Żak Sep 04 '21 at 15:15
-
It should help - The case to transform list of string into new columns – Piotr Żak Sep 04 '21 at 15:16