编程题：Score Processing (Python Edition)
Write a program to process students score data.
The input of your program has lines of text, in one of the two formats:
1. Student's name and student id, as <student id>, <name>, and
2. Score for one student of one course, as <student id>, <course name>, <marks>.
Example of the two formats are:
3190101234, Zhang San
3190101111, Linear Algebra, 89.5
Comma is used as the seperator of each field, and will never be in any of the fields. Notice that there are more than one word for name of the person and name of the course. To make your code easier, the score can be treated as float.
The number of the students and the number of the courses are not known at the beginning. The number of lines are not known at the beginning either. The lines of different format appear in no order. One student may not get enrolled in every course.
To indicate the end of the input, the last line is:
END
Your program should read every line in and print out a table of summary in .csv format.
The first line of the output is the table head, consists fields like this:
student id, name, <course name 1>, <course name 2>, ..., average
where the course names are all the courses read, in alphabet order. There should be one space after each comma.
Then each line of the output is data for one student, in the ascended order of their student id, with score of each course, like:
3190101234, Zhang San, 85, , 89.5, , , 87.3
For the course that hasn't been enrolled, leave a blank before the comma, and should not get included in the average. The average has one decimal place. There should be one space after each comma.
And the last line of the output is a summary line for average score of every course, like:
, , 76.2, 87.4, , , 76.8
All the number output, including the averages have one decimal place. To be consistent with the standard output data, your number should be rounded and "stred" like:
print(str(round(average, 1)))
And do not round any numbers during the calculation.
### Input Format
As described in the text above.
### Output Format
As described in the text above.
### Sample Input
in
3180111435, Operating System, 34.5
3180111430, Linear Algebra, 80
3180111435, Jessie Zhao
3180111430, Zhiwen Yang
3180111430, Computer Architecture, 46.5
3180111434, Linear Algebra, 61.5
3180111434, Anna Teng
END
### Sample Output
out
student id, name, Computer Architecture, Linear Algebra, Operating System, average
3180111430, Zhiwen Yang, 46.5, 80.0, , 63.2
3180111434, Anna Teng, , 61.5, , 61.5
3180111435, Jessie Zhao, , , 34.5, 34.5
, , 46.5, 70.8, 34.5, 50.6
答案：若无答案欢迎评论
The input of your program has lines of text, in one of the two formats:
1. Student's name and student id, as <student id>, <name>, and
2. Score for one student of one course, as <student id>, <course name>, <marks>.
Example of the two formats are:
3190101234, Zhang San
3190101111, Linear Algebra, 89.5
Comma is used as the seperator of each field, and will never be in any of the fields. Notice that there are more than one word for name of the person and name of the course. To make your code easier, the score can be treated as float.
The number of the students and the number of the courses are not known at the beginning. The number of lines are not known at the beginning either. The lines of different format appear in no order. One student may not get enrolled in every course.
To indicate the end of the input, the last line is:
END
Your program should read every line in and print out a table of summary in .csv format.
The first line of the output is the table head, consists fields like this:
student id, name, <course name 1>, <course name 2>, ..., average
where the course names are all the courses read, in alphabet order. There should be one space after each comma.
Then each line of the output is data for one student, in the ascended order of their student id, with score of each course, like:
3190101234, Zhang San, 85, , 89.5, , , 87.3
For the course that hasn't been enrolled, leave a blank before the comma, and should not get included in the average. The average has one decimal place. There should be one space after each comma.
And the last line of the output is a summary line for average score of every course, like:
, , 76.2, 87.4, , , 76.8
All the number output, including the averages have one decimal place. To be consistent with the standard output data, your number should be rounded and "stred" like:
print(str(round(average, 1)))
And do not round any numbers during the calculation.
### Input Format
As described in the text above.
### Output Format
As described in the text above.
### Sample Input
in
3180111435, Operating System, 34.5
3180111430, Linear Algebra, 80
3180111435, Jessie Zhao
3180111430, Zhiwen Yang
3180111430, Computer Architecture, 46.5
3180111434, Linear Algebra, 61.5
3180111434, Anna Teng
END
### Sample Output
out
student id, name, Computer Architecture, Linear Algebra, Operating System, average
3180111430, Zhiwen Yang, 46.5, 80.0, , 63.2
3180111434, Anna Teng, , 61.5, , 61.5
3180111435, Jessie Zhao, , , 34.5, 34.5
, , 46.5, 70.8, 34.5, 50.6
答案：若无答案欢迎评论