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

3 votes109 views1 answer
Python not equal to
Python
4 votes145 views4 answers
Python find factors of a number
Python
0 vote111 views1 answer
Pinyin to pinyin numbers python
Python
0 vote120 views1 answer
Django changing boolean field from view
Python
2 votes111 views1 answer
Python tkinter clear textbox
Python
1 vote134 views1 answer
User matching query does not exist. django
Python Django
0 vote116 views1 answer
Append path to sys jupyter notebook
Python
0 vote114 views1 answer
Top gun: maverick
Python
0 vote109 views1 answer
Find the first occurrence of item in a list in python
Python
15 votes80 views2 answers
Numpy create zero array
Python