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 votes306 views1 answer
Formatting time in python
Python
0 vote264 views2 answers
Mountain array leetcode
Python
11 votes273 views2 answers
Format python number with commas
Python
0 vote289 views4 answers
Write in multiple files python
Python
4 votes277 views2 answers
How do i turn a tensor into a numpy array
Python
7 votes290 views1 answer
Local image embed discord py
Python
3 votes303 views3 answers
Python zip()
Python
0 vote283 views1 answer
Pandas read tab separated file
Python
1 vote299 views1 answer
Get href scrapy xpath
Python
0 vote265 views1 answer
How to get input from pyqt line edit
Python