# rite a Pandas program to create a Pivot table and find the maximum and minimum sale value of the items.  
 import pandas as pd
import numpy as np
df = pd.read_excel('E:\SaleData.xlsx')
table = pd.pivot_table(df, index='Item', values='Sale_amt', aggfunc=[np.max, np.min])
print(table)
