#My Code:
import pandas as pd
df= pd.read_csv(‘Jan-21.csv’)
df_product=df[df[‘BILLNO’].duplicated(keep=False)]
df_product[‘GROUPED’]=df_product.groupby(‘BILLNO’)[‘DEPARTMENT’].transform(lambda x: ‘,’.join(x))
df_product=df_product[[‘BILLNO’,‘GROUPED’]].drop_duplicates()
df_product.head()
#Result Set
| BILLNO | GROUPED | |
|---|---|---|
| 0 | CM06743-Jan21 | Kurti,Kurti,Chudi,Kurti |
| 4 | CM06744-Jan21 | Saree,Saree,Saree |
| 9 | CM06745-Jan21 | Kurti,Kurti,Kurti,Kurti |
| 14 | CM06747-Jan21 | Kurti,Kurti Suit,Kurti |
| 17 | CM06748-Jan21 | Chudi,Kurti,Chudi,Kurti,Kurti,Kurti,Chudi |