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 votes341 views1 answer
How to set index pandas
Python
119 votes352 views6 answers
Read json file python
Python
6 votes313 views6 answers
Python ide
Python
4 votes334 views1 answer
Plt add axis name
Python
0 vote323 views1 answer
Idiomatic python
Python
0 vote308 views1 answer
Como escribir letras griegas en python
Python
0 vote304 views1 answer
System commands in python windwos
Python
0 vote342 views1 answer
Docker python heelo world doesnt print anything
Python
2 votes325 views1 answer
Python half of string
Python
0 vote279 views1 answer
List.fold_left
Python