Read the file.

   Import libraries.

   Use groupby() to group a variables

  Calculate count, average and sum.

#import libraries

import pandas as pd

#read the file

data=pd.read_excel(‘/home/soft27/soft27

/Sathish/Pythonfiles/Employee.xlsx’)

#create the data frame

df=pd.DataFrame(data)

#grouping the rows

test=df.groupby([‘dept’])

test1=df.groupby([‘salary’])

#calculate count,average and sum

t=test.describe()

t1=test1.describe()

#printing the output

print(t)

print(t1)