Jason Melancon
Jason Melancon
Programming language:Python
2021-02-01 00:50:01
0
Q:

grouping products for sales

Heidi Owsley
Heidi Owsley
Code: Python
2021-02-01 00:55:48 
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)
1

Tags

New to Communities?

Join the community