#150EasyFiles & Modules· The csv Module

CSV Grade Report

A teacher exports grades as CSV. Names are written `Surname, Given name`, so they contain commas and are quoted, which breaks a naive `split(",")`. Write `grade_report(csv_text)`. `csv_text` is the content of the file: a header line `name,score` followed by one line per student. Use the `csv` module to read it (wrap the text in `io.StringIO` so it behaves like an open file). Return a dictionary with these keys, in order: - `"students"`: the number of students, - `"average"`: the mean score as a string with one decimal place, - `"top"`: the name with the highest score (the first one on a tie), - `"failed"`: the names with a score below 50, in file order.

Input format

`csv_text`: CSV content with a `name,score` header and at least one student. Scores are whole numbers from 0 to 100.

Output format

A dictionary with keys `students`, `average`, `top` and `failed`.

Examples

Input: csv_text = "name,score\n\"Lovelace, Ada\",91\n\"Hopper, Grace\",88\n\"Babbage, Charles\",42\n"

Output: {"students":3,"average":"73.7","top":"Lovelace, Ada","failed":["Babbage, Charles"]}

The average is 221 / 3 = 73.666..., shown as 73.7. Only Babbage scored below 50.

Input: csv_text = "name,score\nSolo,50"

Output: {"students":1,"average":"50.0","top":"Solo","failed":[]}

50 is not below 50, and the file does not need to end with a newline.

Constraints

1 <= students <= 10^4

Study first

Files and Modules in Python

#python
#csv
#files
#standard-library