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 vote326 views1 answer
Remove initial space python
Python
1 vote294 views1 answer
Print specific part in bold or colours and end.
Python
0 vote264 views1 answer
Python 3.9 docker install
Python
0 vote325 views1 answer
Python turtle pencolor rgb
Python
2 votes332 views1 answer
How to move a button lower on a gui tkinter
Python
1 vote305 views1 answer
How to change web browser in python
Python
0 vote332 views1 answer
Np choose explain
Python
2 votes320 views1 answer
Tkinter execute function on enter
Python
18 votes307 views1 answer
How to get directory path in python
Python
0 vote311 views1 answer
Use loc for change values pandas
Python