If you're not familiar with brazilian carnaval, we have these huge parades where traditional samba schools compete for fun and fame. Each school has 1 hour at the Sambadrome to do their thing, and while doing so they're being ruthlessly judged by 5 judges, who later have to assign 9 scores about the parade. They score specific things such as costumes, theme, evolution, harmony, battery, etc.
Write a program that reads these scores from a csv file and prints out the winner school.
To determine the winner, for each school, and for each score category, you discard the lowest and largest score, and then sum the remaining 3 scores. For instance, if a school received scores [10, 9.8, 9.9, 10, 10] for score category "costumes", you discard the lowest score (9.8) and the largest score (10), and sum the rest [10, 10, 9.9], which results in 29.9.
Then you just sum the scores for all categories to compute the final score for a school. Take a look at this page for an actual example of this year's parade.
Your input is a csv file with the scores of 14 schools. Each column is a score category (9 categories), each row is a score (5 scores for each category). The scores for a school are preceded by the school name in a single row.
The winner school, and its final score.