Challenge #116: A Symphony of Parsing Tools!

[Laurap1228]

I struggled with the XML parsing for while. Eventually, I got my solution to match the one provided.

Spoiler

[JasonHu]

Spoiler

Here is my submission.

[Qiu]

Spoiler

[Watermark]

Spoiler

 

[LiuZhang]

Spoiler

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.

[TimothyH]

Spoiler

[scoles0617]

My solution:

[ARussell34]

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.

[TonyAndriani]

Reposting under my new user ID.

[binuacs]

solution attached