Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual Basic6 Database Programming

Authors: John W. Fronckowiak, David J. Helda

1st Edition

ISBN: 0764532545, 978-0764532542

More Books

Students also viewed these Databases questions