using python help me solve these exercises: Note the output for exercise 1,2 and 3 is provided i need the code that gives those outputs

GBI.xlsl this is the data file

EAR	MONTH	DAY	Customer	CustomerDescr	City	Salesorg	Country	OrderNumber	OrderItem	Product	ProductDescr	Product Category	Division	SalesQuantity	UnitOfMeasure	Revenue	Currency	Discount	CostOfGoodsManufactured	Revenue USD	Discount USD	Cogm USD
2007	1	1	5000	Beantown Bikes	Boston	UE00	US	100001	10	DXTR2000	Deluxe Touring Bike (silver)	TOU	BI	2	ST	6000	USD	300	2800	6000	300	2800
2007	1	1	5000	Beantown Bikes	Boston	UE00	US	100001	20	PRTR2000	Professional Touring Bike (silver)	TOU	BI	5	ST	16000	USD	800	7500	16000	800	7500
2007	1	1	5000	Beantown Bikes	Boston	UE00	US	100001	30	ORMN1000	Men's Off Road Bike Fully	ORB	BI	1	ST	2400	USD	120	1200	2400	120	1200

# Now let's work with the GBI Excel sheet -- if you have done the Io Lab, the # Otherwise, please go to canvas and find the file under the IO Lab, download # GBI 1 # Question 6: What is the average REVENUE for each Product Category? [HINT: Y HINT: You need to group by Product Category] Out[31]: Product Category ACC 108.261038 EBI 8610.636888 ORB 7796.678130 ROB 8313.303493 TOU 8299.358516 TRE 1481.536454 Name: Revenue, dtype: float64 2 # Question 7: How many transations have the lowest revenue? Out[41]: 3 DNOO 1 4 YEAR MONTH DAY Customer CustomerDescr City Salesorg Country Order 107 2007 1 24000 Velodrom Magdeburg DE 125 2007 15000 Bavaria Bikes Mnchen DSOO DE 132 2007 4 23000 Red Light Bikes Hamburg DNDO DE 226 2007 1 6 24000 Velodrom Magdeburg DNOO DE 350 2007 1 15 18000 Drahtesel Leipzig DNOO DE 78 rows x 23 columns 1 3 # Question 8: What is the average revenue for each year? Out[44]: YEAR 2007 4999.140553 2008 5129.561252 2009 4830.588585 2010 4983.660594 2011 5183.147895 Name: Revenue. dtvpe: float64 4 # Question 9: How many unique product names are there? # HINT: 1. ProductDecr has all product names # 2. unique() returns an ARRAY # 3. numpy has a size function that returns the size of an array. Check the web and learn how to use