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 votes161 views1 answer
Mean python code
Python
7 votes252 views1 answer
Age in days to age in years
Python
0 vote216 views1 answer
Check date on template django
Python Django
3 votes119 views1 answer
Centos v8.11.1 npm gyp err! stack error: can't find python executable "python", you can set the python env variable.
Python
0 vote228 views1 answer
Django raise 404
Python
-1 vote153 views1 answer
Python input().strip()
Python
4 votes168 views1 answer
What should you call a decimal value in python
Python
0 vote179 views1 answer
How to resize image with pillow in django
Python
20 votes170 views3 answers
String to float python
Python
1 vote187 views1 answer
Droping Duplicates
Python