Question

PLEASE DO IT IN PYTHON, THANK YOU!

CSV file: This is a file containing plain text where each line in the file represents one record of information, and each piece of info in the record is separated by a single comma. Luckily the values won't ever contain commas themselves for this project. But they might start or end with non visible characters (e.g. space, tab). Thus, you must remove the leading and trailing spaces when you store the data in a dictionary in memory. The very first line is the header row, which names the columns but is not part of the data, and therefore should not be loaded into memory. Note: the filename extension you use has no effect on the contents; you can edit it and give it any extension you want without changing the ability of your program. In this project we'll be using two kinds of CSV files: votes.csv file: It contains records of votes in the following format: state, candidate, party, popular_votes, electoral_votes AL, Johnson, IND, 44467, 0 AL, Stein, IND, 9391,0 AK, Trump, REP, 163387, 9 VA, Clinton, DEM, 1981473, 13

Answer 1

If you have any doubts, please give me comment...

Code:

def read_votes(filename):

try:

f = open(filename)

votes_db = {}

f.readline()

for line in f.readlines():

fields = line.strip().split(",")

if fields[0] not in votes_db:

votes_db[fields[0]] = [(fields[1], fields[2], int(fields[3]), int(fields[4]))]

else:

i = 0

for state in votes_db[fields[0]]:

if fields[1] < state[0]:

break

i+=1

votes_db[fields[0]].insert(i, (fields[1], fields[2], int(fields[3]), int(fields[4])))

return votes_db

except:

return False

def write_votes(db, filename):

try:

if len(db)==0 or type(db) is not dict:

return False

f = open(filename, 'w')

for country in db:

for l in db[country]:

f.write(country)

for e in l:

f.write(","+str(e))

f.write("\n")

f.close()

return True

except:

return False