*****
student_name='Enter your name here'
paws_id='A123'#enter our paws id
sum_cty=0
n=0
sum_hwy=0
sum_ford_hwy=0
n_ford_hwy=0
sum_suv_city=0
n_suv_city=0
firstLine=True
with open('MPG.csv','r') as f:
for line in f:
if firstLine:
firstLine=False
else:
data=line.split(',')
sum_cty+=float(data[8])
sum_hwy+=float(data[9])
n=n+1
if data[1].lower()=='ford':
sum_ford_hwy+=float(data[9])
n_ford_hwy+=1
if data[-1].strip().lower()=='suv':
sum_suv_city+=float(data[8])
n_suv_city+=1
avg_city=sum_cty/n
avg_hwy=sum_hwy/n
ford_hwy=sum_ford_hwy/n_ford_hwy
suv_city=sum_suv_city/n_suv_city
f=open(paws_id+'_assignment4.txt','w')
f.write('Average city mileage for all vehicles:
{:.4f}\n'.format(avg_city))
f.write('Average highway mileage for all vehicles:
{:.4f}\n'.format(avg_hwy))
f.write('Average highway mileage of all Ford vehicles:
{:.4f}\n'.format(ford_hwy))
f.write('Average city mileage of all SUV vehicles:
{:.4f}\n'.format(suv_city))
f.close()
