Answer:
import pandas as pd
# loads the text file as a pandas dataframe
student_file = pd.read_fwf("std_info.txt")
# opens a new text file if the student_avg does not exist
# the file closes automatically at the end of the with statement
with open('student_avg.txt', 'w+') as file:
for row in student_file.iterrows():
file.write(row)
ee = student_file[student_file['major'=='EE']]
cpe = student_file[student_file['major'=='CPE']]
file.write(f'EE average = {ee['EE'].mean()}')
file.write(f'CPE average = {ee['CPE'].mean()}')
file.write(f'Total average = {student_file['EE'].mean()}')
Explanation:
The python program gets the text file as a fixed-width file and loads the file as a pandas dataframe. The dataframe is used to get the total average GPA the student GPA and the average GPA of students in various departments. The results are saved in a new file called 'student_avg.txt'.
