Pandas DataFrame groupby() Method

Program 1

# Advance Data Analysis 
#Group by method
import pandas as pd
product=[('Limca',20,'Sanchi'),('Frooti',25,'Amul'),('Milk',20,'BK'),('Water',20,'BK'),
       ('Limca',25,'AK'),('Frooti',20,'SK'),('Milk',28,'BK'),('Water',30,'Sanchi'),
        ('Limca',27,'Sanchi'),('Frooti',29,'AK'),('Milk',25,'Amul'),('Water',45,'Sanchi'),
        ('Water',29,'Amul'),('Limca',40,'DK'),('Frooti',32,'Amul'),('Water',40,'Sanchi')
        ]
#print(product)
df=pd.DataFrame(product,columns=['Product Name','Price','Distributor'])

df1=df.groupby('Product Name')
print(df1.agg([max]))
#print(df1['Price'].agg([max,min]))
#print(df1['Product Name'].agg(['count']))
#print(df1['Price'].agg([sum]))
# print(df1.get_group('Limca').max())
# print(df1.get_group('Frooti').min())
# df1=df.groupby('Distributor')
# print(df1.get_group('Amul'))

#df1=df.groupby('Product Name')
#df1=df.groupby('Distributor')
#df1=df.groupby('Price')
# df1=df.groupby('Product Name')
# for name ,rows in df1:
#     print(name)
#     print(rows)

#print(type(df1))
#print(df)