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 vote184 views1 answer
Pytho ntoday as string
Python
3 votes226 views1 answer
Np.array average row
Python
0 vote225 views1 answer
Os.startfile on raspberry
Python
0 vote225 views1 answer
Inverted trapezium pattern in python
Python
0 vote191 views1 answer
How travel a list invertida in python
Python
10 votes176 views5 answers
Pandas number of columns
Python
0 vote220 views1 answer
Filter list dict
Python
1 vote201 views1 answer
Python converting phred quality score to number
Python
0 vote190 views1 answer
P = pascal(3, 'upper', exact=False)
Python
0 vote232 views1 answer
Create numpy array with ones
Python