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 vote165 views1 answer
How to keep old content when using write in python
Python
0 vote165 views1 answer
AttributeError: 'Engine' object has no attribute 'runandwait' python
Python
0 vote159 views1 answer
If loop in python syntax
Python
-1 vote163 views2 answers
Pandas print groupby
Python
24 votes166 views3 answers
Warning ignore python
Python
0 vote161 views1 answer
Dense rank in pandas
Python
7 votes165 views1 answer
Python download form web
Python
-1 vote160 views1 answer
Significant figures on axes plot matplotlib
Python
0 vote157 views2 answers
How to read mysql table in python
Python
-2 votes155 views2 answers
Float() argument must be a string or a number, not 'dict_values'
Python