Lab 12C: Student Scores with Files Overview
Create a program that reads from multiple input files.
Objectives
Gain familiarity with CSV files
Perform calculations with data from CSV files
Read from multiple files in the same program
Description
Prompt the user for a text file that contains a list of student names, one on each line. Also prompt the user for a CSV file that contains scores for the students in the following order: homework1, homework2, test 1, final test. Each line in the CSV has four scores, delimited by a comma. Each name in the text file has the corresponding scores in the CSV file.
You will need to calculate the weighted final grade for each student as follows:
5% homework1
5% homework2
40% test 1
50% final test
You need to create a program that will read the scores from the CSV file, calculate the weighted final grade, and display the resulting final grade, along with the student's name.
Sample input files are attached.
You can assume that the same number of lines will be in the input files, and that the order of the names and corresponding grades is the same in the two files.
Display the name and final grade for all students in the following format:
Bill Gates earned 81.5%
Mark Zuckerberg earned 99.6%
...
Note: You will lose points if you do not correctly work with the file and csv reader. If you decide to just use a print statement to display the output, without using file input and the csv reader, you will not pass all of the test cases. In short, do not try to cheat the system by simply displaying the data.
scores. csv:
Scores
9 8 85 78
10 10 99 100
4 2 55 61
10 8 90 90
8 6 76 75
names. txt:
Bill Gates
Mark Zuckerberg
Jeff Bezos
Jack Dorsey
Steve Wozniak
default template:
if __name__ == '__main__':
#Type your code here. Notice the indentation level of this line.