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

13 votes318 views1 answer
Install python2.7 ubuntu
Python
10 votes357 views2 answers
Python copy dir
Python
0 vote406 views1 answer
List the contents of a package python
Python
0 vote358 views1 answer
Keras conv2d batchnorm
Python
20 votes364 views4 answers
Button tkinter
Python
4 votes375 views1 answer
Print type of exception python
Python
0 vote329 views1 answer
Random string generate python of 2.7
Python
0 vote413 views1 answer
Import tsv as dataframe python
Python
5 votes444 views4 answers
Python print with 2 decimals
Python
1 vote328 views2 answers
Pygame window at center
Python