Hi, need this written in Python programming language.
Quiz 11 - Bonus
A data analysis is performed to measure and record different statistics using a dataset of a monthly benchmark test. This test includes answers of each question for each student.
The screenshot below shows a part of the dataset of the monthly benchmark test. This dataset includes 104 students with answers of each question. There are 29 number of questions.
The variables of this dataset are given with brief explanations below.
A column: De-identified names of students
B column: The sections (classes) that students come from.
C column: 6th grade students.
D-AF columns: Questions of the test.
Uppercase letter: Correct answer
Lowercase letter: incorrect answer
Empty or any other character: No answer (missing)
[100 pts] What is the success and failure rate of each student?
Submit your Python source codes and input/output screenshots in a single word or pdf document.
