Practical Implementation of Pandas Groupby Function

Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!

Program 1

import pandas as pd
product=[('Limca',25,'BK'),('Limca',40,'NM'),('Frooti',20,'AK'),
          ('BMilk',20,'Amul'),('Milk',20,'Amul'),('BMilk',18,'Sanchi'),
          ('Limca',15,'AK'),('Frooti',17,'BK'),('BMilk',23,'Sanchi'),
          ('Milk',27,'NK'),('Frooti',23,'BK'),('BMilk',23,'Sanchi'),
         ]
df=pd.DataFrame(product,columns=['Product_Name','Proudct_Price','Distributor'])
df1=df.groupby('Product_Name')
# for name,rows in df1:
#     print(name)
#     print(rows)
#print(df1.get_group('BMilk').min())
# print(df1.count())
print(df1.agg())

 

Did you like this article? If Yes, please give DataFlair 5 Stars on Google

courses
Image

TechVidvan Team

TechVidvan Team provides high-quality content & courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.

Leave a Reply

Your email address will not be published. Required fields are marked *