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 vote72 views1 answer
Jupyter clear output
Python
0 vote110 views1 answer
Gridlayout pyqt5 python using a for loop
Python
1 vote107 views1 answer
Python create n*n matrix
Python
1 vote110 views1 answer
Python new line character in string
Python
61 votes106 views6 answers
Get date and time python
Python
21 votes110 views2 answers
Correct code to read csv file in python
Python
0 vote97 views2 answers
Scroll to bottom in selenium python
Python
0 vote104 views4 answers
Dfs and bfs in python
Python
0 vote102 views1 answer
How to multiply integer value with float values in python
Python
0 vote101 views1 answer
Wordcount pyspark
Python