We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
A solution for last week's challenge has been posted here!
The NY Philharmonic, as various ensembles, has been performing for audiences around the world for over 175 years! Wow! This week's Challenge asks you to parse the data for each of their programs (not for the past 175 years...that file was HUGE!) from 2011 - 2017. For each program, identify the concert information (Date, Location, Time, etc), as well as the pieces played during that program and the solo performers (if applicable). Note: the posted solution has removed records representing an intermission.
Here is my solution.
I'm actually getting more data than was provided in the given Output, but, from the spot checks I've performed, I think my additional records are valid.
Another good catch @joe_yang! I've updated the start file again. Also, I think I found a point of discrepancy: I opted to remove the records containing "Intermission" in the column "interval". That means I removed records that @mmongeon's solution includes (and that are included in the original xml file). I'm loving all the intense data investigation this Challenge requires (especially on under-caffeinated Mondays....)!