Question Details

(Solved) MS Excel can read and write CSV files, so they are handy for exchanging data between a program and MS-Excel. (50 points + 25 bonus points)...


  • The file explains what the code should do (ignore #1 and #2 on the instructions)


  • Python is the Language

Programming Assignment #7 – Files and Exceptions For this assignment, you will write a menu driven console program that loads, parses and analyzes a comma-­‐separated values (CSV) file of real estate data. MS Excel can read and write CSV files, so they are handy for exchanging data between a program and MS-­‐Excel. (50 points + 25 bonus points) Requirements 1. Use the python_template_advanced_with_unit_tests.py for your code. They can be found in D2L > Content > Resources > Templates as the basis for your program. 2. Download the data file for this assignment from Dropbox for this assignment and put it in the same directory as your program, or create a function that creates a absolute path to the file, so that the function that read the data can find it – where ever it is – on disk. 3. Write your code using functions and include: a. A top-­‐level function called main() that implements your program by using other functions to perform specific tasks as needed. b. A function called print_header() that prints the name of the program once it starts running. c. A function called menu() that interacts with the user by presenting a list of choices. Provides a limited set of choices to the user. Your menu should allow the user to repeatedly make choices until they select [q]uit and should include: i. Here is the string to present to the user:
‘[L]oad, [P] find hi/lo priced, [A]verage all properties,
[C]ondo averages: ‘ ii. iii. iv. v. vi. L for load (see e below) P to find the highest and lowest priced properties (see f below) A finds average prices for all properties (see g below C find the condominium averages (see h below) Q to quit the program Additionally, vii. The choice made by the user should be returned to main. viii. In main, each choice the user makes should result in a function being called to perform the required work and display the results, or to exit the program if the users selects [q]uit). d. Formatting matters of your output matters, for example, prices should have a $ symbol followed by a floating-­‐point value. Floating point numbers should be limited to two decimal places e. A function called read_data() that reads the data file and loads the data into a list of dictionaries by using the DictReader class the Python’s Standard Libraries csv
package. Make sure you close the data file after it has been read. f. A function called find_high_and_low() finds the highest priced and lowest priced properties and returns them as a tuple of integers. g. A function called find_average() that finds the average price of all properties and returns the value as an integer. h. A function called find_condo_average() that finds the average price, number of bedrooms, and numbers of baths for condominiums. Return these values as a tuple. 4. Use the following naming convention for your program: csc119_<first name>_assignment#_<short description>.py csc119_katlin_11_process_csv.py for example. 5. Submit your program to D2L > Dropbox > Programming 6 – Files & Exceptions by the Tuesday July 26 at 11:30 PM deadline and make sure it runs, even if it is not complete. 6. Add unit test(s) for each of your functions that test its important functionality. (25 bonus points)

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $18

Solution~000200195352.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now