Grouping products for sales

data = Item[Item['Bill No'].duplicated(keep=False)]

# Referenced: https://stackoverflow.com/questions/27298178/concatenate-strings-from-several-rows-using-pandas-groupby
data['Grouped'] = data.groupby('Bill No')['Item Name'].transform(lambda x: ','.join(x))
data2 = data[['Ending GST Bill No', 'Grouped']].drop_duplicates()
data2.head(10)

Similar codes

2 votes130 views1 answer
How to find geometric mean in python
Python
0 vote126 views2 answers
Python create adictionary randomly assigning clors to categorical vairables
Python
0 vote133 views1 answer
Use gpu for python code in vscode
Python
1 vote186 views1 answer
Elif in django template
Python Django
0 vote126 views1 answer
Print all objects in list python
Python
-1 vote145 views1 answer
Simple sum in python
Python
1 vote123 views1 answer
How to find second maximum element of an array python
Python
-1 vote136 views2 answers
Insert into string python more than one
Python
157 votes209 views3 answers
Command to update pip
Python
0 vote137 views1 answer
Python check is admin
Python