Question

--------__--------__Python--------__--------__

You will be reading in the data from the file SalesJan2009.csv. When you do, you need to save all the items from the PRICE field into a list called amtCollected. After you get them all in that list, you will need to create a variable called total that holds the sum of all the numbers in the list. Then create a variable called avg that holds the average of the numbers in the list. Now, print the following strings: "Total is $(total)" and "Average price is $(avg)"Be sure to replace the (total) and (avg) with the value in the variables. Be sure to do casting where necessary. You may use DictReader to read the data from the csv file and then put that dictionary data into the intended list.

______________________

I'm terribly confused on how to start on this... but this is how I started it

import csv

amtCollected = []
with open("SalesJan2009.csv", "r+") as csv_file:
csv_reader = csv.reader(csv_file, delimiter= ',')
for line in csv_reader:
print(line[2])

------------------------------------

here is the link to the file

https://docs.google.com/spreadsheets/d/1345krckT94BLrBC363nVZCKAh5xoLK_JCCXnMJ_vHEU/edit?usp=sharing

Answer 1

>>>>>>>>>>>>>>>>>>>>>>>>>>>python code>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

import csv

amtCollected = []

#opening file
csv_file=open("SalesJan2009.csv", "r+")
#read every line and save it to list
csv_file=csv_file.readlines()
csv_file=csv_file[1:]

#spliting every line on delimeter , and taking amount input
for line in csv_file:
   amount=list(line.strip().split(","))[2]
   amtCollected.append(int(amount))

#calculating O/p and printing result
total=sum(amtCollected)
avg=total/len(amtCollected)

print("Total is ${}".format(total))
print("Average price is ${:.2f}".format(avg))

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>sample O/P>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

dilupalludilupalli. Lileyy anupambanupam:~/HomeworkLib$ python3 amount.py Total is $1630500 Average price is $1633.77 Open F anupambanupam:-/HomeworkLib$ 1 import csv amount.py m/HomeworkLib Say 3 amt collected = [] 5 #opening file 6 csv_file=open("Sales Jan2009.csv", "r+") 7 #read every line and save it to list 8 csv file=csv_file. readlines() 9 csv_file=csv_file[1:] 10 11 #spliting every line on delimeter, and taking amount input 12 for line in csv file: 13 amount=list(line.strip().split(",")) [2] 14 amtcollected.append(int(amount)) 16 #calculating 0/p and printing result 17 total=sum(amt Collected) 18 avg=total/len(amt Collected) 19 20 print("Total is ${}", format(total)) 21 print("Average price is ${: .2f}".format(avg))