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

0 vote245 views1 answer
Django admin readonly models
Python
5 votes225 views2 answers
Forgot django admin password
Python Django
0 vote173 views1 answer
Length of number without using len function
Python
0 vote154 views1 answer
Fetch python
Python
2 votes177 views1 answer
How to get all index of a char of a string in python
Python
2 votes199 views1 answer
Python count character occurrences
Python
1 vote155 views1 answer
Make lists for each 2 items in a list
Python
4 votes208 views2 answers
Random matrix python
Python
75 votes208 views6 answers
Python reverse string
Python
81 votes190 views6 answers
Python check if string
Python