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

2 votes210 views1 answer
Django register models
Python Django
0 vote216 views1 answer
Python convert to hmac sha256
Python
1 vote231 views1 answer
Django ModelChoiceField value not id
Python
0 vote206 views1 answer
Chromebook install pip
Python
4 votes224 views1 answer
Pandas dataframe replace inf
Python
5 votes235 views1 answer
Python test is nan
Python
0 vote218 views1 answer
How to import something in python
Python
2 votes210 views2 answers
ë python
Python
68 votes204 views6 answers
Python dict sort by value
Python
0 vote228 views1 answer
Separate array along axis
Python