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

1 vote327 views1 answer
Den pfad der python datei rausfinden
Python
0 vote345 views2 answers
Detect if usb is plugged in python
Python
1 vote306 views1 answer
Python import ndjson data
Python
2 votes309 views1 answer
Column standardization pandas
Python
0 vote335 views1 answer
Step out pdb python
Python
4 votes362 views1 answer
What is cleaned data in django
Python Django
2 votes307 views1 answer
How to check if all characters in string are same python
Python
2 votes355 views1 answer
Average within group by pandas
Python
0 vote338 views1 answer
Export an excel table to image with python
Python
0 vote342 views2 answers
How to update sklearn
Python