Assignment: This problem uses fuel economy data in miles per gallon (mpg) taken

Question

Assignment:
This problem uses fuel economy data in miles per gallon (mpg) taken from the following US Department of Energy website:

http://www.fueleconomy.gov/feg/download.shtml

The data files you have been provided with have been adapted from the CSV file on the website, and contain vehicle testing data for all models tested between 1984 and 2014 (last updated Sept 30, 2014). The first data file, carModelData_city, contains all the test results for city mpg and the second, carModelData_hwy, contains all the test results for highway mpg. Each file contains the same number of values, as the values in the same position in each list refer to the same vehicle. You will likely want to use the float() function to cast the string values to floats.
a. Write a function readData(filename) that will read in all the data from a text file that consists of float data formatted such that each value is on a new line.

b. Write a function averageMPG(dataList) that calculates the average mpg for all vehicles tested given a list of the mpg values.

c. Write a function countGasGuzzlers(list1, list2) that calculates the number of gas guzzlers among the vehicle models tested – for this program, define a “gas guzzler” as a car that gets EITHER less than 22 mpg city OR less than 27 mpg highway.

d. Write a function output() to print the following output (you will determine what parameters this function needs to have passed in to it): i. The total number of vehicles tested ii. The average for the city mpg for all the vehicles tested iii. The average for the highway mpg for all the vehicles tested iv. The number of gas guzzlers among the vehicle models tested

e. Write a program fuelEconomy.py that contains a main() function that calls all the functions you made in parts a-d

#you can download the file through these links:
http://www.mediafire.com/download/6h5ntcdcc77kpx1/carModelData_city%282%29
http://www.mediafire.com/download/awns657l1vc4942/carModelData_hwy%282%29

Or from

https://canvas.southseattle.edu/courses/1163334/files/56027185/download?wrap=1 https://canvas.southseattle.edu/courses/1163334/files/56027191/download?wrap=1

#Please this problem needed to be used by python 3.5

Explanation / Answer

(A)def readData(filename):
import csv
with open(filename, 'rb') as f:
reader = csv.reader(f, delimiter=';')
for row in reader:
       for num in row
           print row[num]
           if row[num] in float:
               print row[num]

(B)

def readData(filename):
import csv
citympg = 0
hwympg = 0
cmbmpg = 0
count = 0
with open(filename, 'rb') as f:
reader = csv.reader(f, delimiter=';')
for row in reader:
       citympg += row[12]
       hwympg += row[13]
       cmbmpg += row[14]
       count = count +1

print citympg/count;
print hwympg/count;
print cmbmpg/count;

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.