Number 3

Consider the CSV file "HW3CustomerOrders.csv" posted on Canvas. The file contains information of customer orders received by a warehouse during one month (June/2017). The following is the description of the columns in the file: Customer ID: A unique identification number assigned to each customer SKU: The product identification number Value: Dollar value of the units requested . Date: The date when the customer order was placed . Units :Number of units requested Assignment 1. [30 points] Develop a Python script that reads the csv file and prints the following: a. b. c. The number of lines in the file excluding the headings line. The number of different customers in the file. The number of different SKUS in the file. 2. [30 points] Develop a Python script that reads the csv file and creates a dictionary. Use the SKU (i.e. the third column in the file) as the dictionary keys, and the total number of units requested as the values. As an example, if you name your dictionary TotalDemand, then the instruction TotalDemand[ 'PB0007069' should print the number 1204. [30 points] Develop a Python script that reads the csv file and creates a dictionary. Use the day of the month as the dictionary key, and the total dollar amount sold for the values. As an example, if you name your dictionary DailySales, then the instruction DailySales[1] should print the number 340,295.72. 3