Question

Python Program: Design the logic for and implement a program that merges the two files into one text file (.txt) containing a list of all students, maintaining ID number order. At the end of the text file provide descriptive data that lists a count of students in each major, the average GPA for each major, and a count and average GPA for the whole program. The data files are already sorted in student ID order. Your program should create a merged file called 'DeptStudentMerge.txt'. Use the default folder as the file location (do NOT list out a path on your own computer or request a path). Here's the program I have so far and the dataset in on the bottom.

CINSMajors

214, Davis, Kimberly, 3.4
315, Thompson, Hunter, 2.9
319, Harris, Michael, 2.3
320, Nichols, Matthew, 3.5
322, Pohler, Geoffrey, 4.0
412, Max, Manfreid, 3.2

PBISMajors

202, Kennedy, Lincoln, 2.4
306, Laslow, Bernard, 2.5
393, Nuance, Deborah, 2.6
395, Samson, Michelle, 3.1

#Declarations
CINSFile = ''
PIBSFile = ''
DeptStudentMergeFile = ''
CINSRecord = []
PIBSRecord = []
count = 0
END_NAME = 'ZZZZZ'
areBothAtEnd = 'N'

def ReadCINS(CINSFile):
global CINSRecord

CINSRecord = CINSfile.readline().rstrip('\n').split(',')

if CINSRecord[0] == '':
CINSRecord[0] = END_NAME

def ReadPIBS(PIBSFile):
global PIBSRecord

PIBSRecord = PIBSfile.readline().rstrip('\n').split(',')

if PIBSRecord[0] == '':
PIBSRecord[0] == END_NAME

def CheckEnd(CINSFile, PIBSFile):
global areBothAtEnd

if CINSRecord[0] == END_NAME:
if PIBSRecord[0] == END_NAME:
areBothAtEnd = 'Y'

def GetReady():
global CINSFile
global PIBSFile
global DeptStudentMergeFile
global areBothAtEnd

CINSFile = open('CINSData.txt', 'r')
PIBSFile = open('PIBSData.txt', 'r')
DeptStudentMergeFile = open('DeptStudentMerge.txt', 'w')

def FinishUp(CINSFile, PIBSFile, DeptStudentMergeFile):
CINSFile.close()
PIBSFile.close()
DeptStudentMergeFile.close()

def MergeRecords(CINSFile, PIBSFile, DeptStudentMergeFile):
global CINSRecord
global PIBSRecord

outputline = float()
CINSRecord = ReadCINS(CINSFile)
PIBSRecord = ReadPIBS(PIBSFile)
areBothAtEnd = CheckEnd(CINSFile, PIBSRecord)
  

if CINSRecord[0] < PIBSRecord[0]:
outputline = CINSRecord[0] + ',' float(CINSRecord[1] + '\n'
CINSFile = ReadCINS(CINSFile)
else:
outputline = PIBSRecord[0] + ',' + float(PIBSRecord[1]) + '\n'
PIBSFile = ReadPIBS(PIBSFile)

DeptStudentMergeFile.write(outputline)
areBothAtEnd = CheckEnd(CINSFile, PIBSFile)

def Main():
#Mainline logic

CINSFile, PIBSFile, DeptStudentMergeFile = GetReady()

while areBothAtEnd != 'Y':
MergeRecords()

FinishUp(CINSFile, PIBSFile, DeptStudentMergeFile)

if __name__== '__main__':
Main()

Answer 1

f1 = open("cins.txt", "r")
f2=open("pibs.txt","r")
f3=open("combine.txt","a")
dict={}
first=0
second=0
firstg=0
secondg=0
for line in f1:
    string = line.split(",")
    first=first+1
    dict[int(string[0])]=",".join(string[1:])
    line=line.replace(" ","").rstrip('\n').split(",")
    firstg=firstg+float(line[len(line)-1])

for line in f2:
    string = line.split(", ")
    second=second+1
    dict[int(string[0])]=",".join(string[1:])
    line=line.replace(" ","").rstrip('\n')
    secondg=secondg+float(line[len(line)-1])
  
for i in sorted(dict.keys()):
    f3.write(str(i))
    f3.write(dict[i])

f3.close()
f1.close()
f2.close()

print("Total number of students in the class are ",first+second)
print("Total number of students in CINS major are ",first)
print("Total number of students in PBIS major are ",second)
print("Average GPA of students in CINS major is ",round(firstg/first,2))
print("Average GPA of students in PBIS major is ",round(secondg/second,2))
print("Average GPA of whole cass is ",round((firstg+secondg)/(first+second),2))

COMMENT DOWN FOR ANY QUERY

PLEASE GIVE A THUMBS UP