Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI struggled with the XML parsing for while. Eventually, I got my solution to match the one provided.
Here is my submission.
Getting more rows as well, probably due to multiple days of some programs. Spot check on a few program id matched the results, so parsing seems to be right.
Downloaded the data and used a handful of XML parsing tools to pull out the specific "child" values and their outer xmls to break out all the appropriate data per program ID and the Orchestra. Used a union tool to piece it all back together and create the layout of info for unique data for all seasons up to and including the 2017-2018 season.