Question: 1. 30 points] Develop a Python script that reads the csv file and prints the following: The number of lines in the file excluding the
1. 30 points] Develop a Python script that reads the csv file and prints the following: 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. a. b. c. 2. 130 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 Tota!Demand [ . PB 0 0 0 7 0 6 9 . ] 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. [10 points] Develop a Python script that reads the csv file and creates a histogram with the values in the third column of the file (i.e. the number of units requested) 4. The deliverables for this homework are: A single zip file containing four Python scripts, one for each question. Assume that the CSV file is in the same directory where the scripts importing it are, so that no path needs to be specified in the scripts
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
