Question

The file Senate113.txt contains the members of the 113th U.S. Senate— that is, the Senate prior to the November 2014 election. Each record of the file consists 3 ofthreefields—name,state,andpartyaffiliation. Somerecordsinthefileareasfollows:

Richard Shelby,Alabama,R

Bernard Sanders,Vermont,I

Kristen Gillibrand,New York,D

The file RetiredSen.txt contains the records from the file Senate113.txt for senators who left the Senate after the November 2014 election due to retirement, defeat, death, or resignation. Some records in the file are as follows:

John Rockefeller,West Virginia,D

Tom Coburn,Oklahoma,R

Carl Levin,Michigan,D

The file NewSen.txt contains records for the senators who were newly elected in November 2014 or who were appointed to fill the seats of senators who left after the November 2014 election. Some records in the file are as follows:

Shelly Capito,West Virginia,R

Steve Daines,Montana,R

Gary Peters,Michigan,D

(a) Write a python program that uses the three files above to create the file Senate114.txt that contains records (each consisting of three fields) for the members of the 114th Senate where the members are ordered by state. Use this file in parts (b), (c), and (d).

(b) Write a python program that determines the number of senators of each party affiliation. See Fig. 5.49.

(c) Write a python program that determines the number of states whose two senators have the same party affiliation.

(d) Write a python program that asks the user to input a state, and then displays the two sena- tors from that state. See Fig. 5.50.

Figure 5.49 Outcome of 4(b)

Party Affiliations:
  Republicans: 54
  Democrats: 44
  Independents: 2

Figure 5.50 Outcome of 4(d)

Enter the name of a state: Maryland

Benjamin Cardin Barbara Mikulski

Answer 1

The python program to perform the above operations is as follows

# creating new file from the existing file contents def createNewFile(): # save the filenames in a list fileNames = ['Senate113.txt', 'RetiredSen.txt', 'NewSen.txt'] # open the new file to which the contentsto be written with open('Senate114.txt','w') as f: for file in fileNames: # iterate through the files with open(file, 'r') as f1: # open the file for line in f1: f.write(line) # write the content to the new file f.write('\n') f1.close() f.close()    # find the senator count for each party affliation def findSenatorsCount(): fileName = 'Senate114.txt' # initialise the count of each party r_count = 0 d_count = 0 i_count = 0 with open(fileName, 'r') as f: # open the file for line in f: data = line.split(',') party = str(data[-1]).strip() # find the party affliation if party == 'I': # check for the party to increment the count i_count = i_count + 1 elif party == 'D': d_count += 1 else: r_count += 1 # print the count of senators under each party affliation print('''Party Affliations: Republicans : {r} Democrats : {d} Independants : {i}'''.format(r = r_count, i = i_count, d = d_count)) # find the number of states whose two senators have the same party affliation def findStatesCount(): fileName = 'Senate114.txt' stateAndParty = [] count = 0 # initialise count to 0 # iterate through the file content and create a list of state and party affliation with open(fileName, 'r') as f: # open the file data = f.readlines() for datum in data: content = datum.strip().split(',') stateAndParty.append(content[1] + content[2]) # create the state party pair # iterate through the list to find the match and increase the count of states for content_num,content in enumerate(stateAndParty): length = len(data) for i in range(content_num+1,length): if str(content) == str(stateAndParty[i]): count += 1 print(count)    def displayTwoSenators(): state = input("Enter the name of a state : ") # read the input state fileName = 'Senate114.txt' count = 0 # initialise the count with open(fileName, 'r') as f: # open the file data = f.readlines() for datum in data: content = datum.strip().split(',') if str(content[1]) == state: # check for the state print(content[0]) count += 1 if count == 2: break    # createNewFile() # findSenatorCount()    # findStatesCount() displayTwoSenators()

Files :

Senate113.txt

Richard Shelby,Alabama,R Bernard Sanders,Vermont,I Kristen Gillibrand,New York,D

RetiredSen.txt

John Rockefeller,West Virginia,D Tom Coburn,Oklahoma,R Carl Levin,Michigan,D

NewSen.txt

Shelly Capito,West Virginia,R Steve Daines,Montana,R Gary Peters,Michigan,D

Senate114,txt

Screenshots :

Source code:

Output :

output for part 4(d)