Please answer question 6 (it is one question only but answer it in full please) preferably using pycharm

6. Write a Python program that reads a text file called student.txt. The input text file contains student_ID, student_name, Quiz_grade as well as Test_grade for each student. Your program should read each student details from the file Then calculate the average of Quizzes and Tests marks Display the students' details: Total number of students, total average, the total highest and lowest marks. The program should output the report into a file called output.txt. A sample of output text file is given below. . student.txt: Name Test (60%) Quiz (40%) 65 97 50 90 ID 20181867 20197541 20183245 20199876 20185432 20179807 Alia Shamma Zainab Noora Hamda 79 84 66 30 75 55 Fatma 78 82 output.txt: Class Report There are total of 6 students The average of total marks is 71.267 Shamma (20197541) scored the highest marks as 45 Hamda (20185432) scored the lowest marks as 92.8