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

5 votes303 views1 answer
Flask boiler plate
Python
5 votes306 views4 answers
Data normalization python
Python
3 votes295 views3 answers
Pandas sum group by
Python
3 votes306 views2 answers
Postgres Database Django
Python Django
0 vote304 views1 answer
How to resize windows in python
Python
9 votes288 views2 answers
How to make a resizable python tkinter window have a limit
Python
3 votes308 views3 answers
Get every nth element in list python
Python
0 vote303 views1 answer
Pyqt5 date-edity
Python
1 vote293 views1 answer
Python locks
Python
0 vote390 views1 answer
Python linked list insert
Python