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 vote169 views2 answers
Python plus
Python
31 votes156 views3 answers
How to add one to the index of a list
Python
0 vote165 views2 answers
How to print aligned dictionary python
Python
0 vote179 views1 answer
Applying multiple functions at once pandas
Python
9 votes170 views1 answer
Install matplotlib conda
Python
2 votes156 views1 answer
Python pandas replace nan with null
Python
2 votes151 views2 answers
Defaultdict python dict inside dict
Python
3 votes144 views1 answer
Python find all elements of substring in string
Python
2 votes159 views3 answers
Get binary string python
Python
7 votes157 views3 answers
How to install library in python
Python