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

0 vote201 views1 answer
Add zero in front of numbers lower than 10 python
Python
0 vote177 views1 answer
Tensorflow use growing memory
Python
3 votes210 views3 answers
ModuleNotFoundError: No module named 'MySQLdb' in windows
Python
0 vote197 views1 answer
Combine for and if python
Python
0 vote193 views1 answer
Function to sort a list of points based on their x and y-coordinates
Python
1 vote192 views1 answer
Python define an array with length
Python
13 votes193 views3 answers
Python program to calculate factorial of a number.
Python
16 votes249 views4 answers
Mean of a list python
Python
0 vote266 views1 answer
Install reportlab python
Python
0 vote200 views1 answer
Python cron job virtualenv
Python