Find the best solutions to your questions at Westonci.ca, the premier Q&A platform with a community of knowledgeable experts. Experience the ease of finding reliable answers to your questions from a vast community of knowledgeable experts. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately.
Sagot :
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'.
Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Thank you for your visit. We're dedicated to helping you find the information you need, whenever you need it. Stay curious and keep coming back to Westonci.ca for answers to all your burning questions.