Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATook me a bit of looking at the file and the output to see what rows were needed.
I spent 90% of my time trying to make sense of the data in the file. I was thrown because the data appears twice in the file. I spent a bunch of time banging my head against the first appearance before realizing the data appears in a much cleaner form further down in the file. Here's my final solution.