Challenge #162: Mondays....they're Marvel-ous!

[ChristineB]

A solution to last week's challenge can be found HERE!

Use the provided datasets to determine the name, year and issue of each comic in which Marvel characters make an appearance.  

[patrick_digan]

Here's my solution. My record count is slightly different than the provided solution but I'm ok with the differences.

Spoiler

[ChristineB]

@patrick_digan Any idea where the difference emerged?  I'll re-visit my solution, too. 

[NicoleJohnson]

My solution! 

Spoiler

I feel like the logic used for parsing out years & issue numbers could have been tackled a few different ways, but I eventually figured out the right combo to get me to the same answer.

Cheers!

NJ 

[T_Willins]

The only spoilers I want to see are for this challenge.  Seeing Avengers Endgame tonight!

Spoiler

[dimark]

My Solution :)

[kelsey_kincaid]

Spoiler

[T_Willins]

@patrick_digan  - I ran into the same issue with record count on my first pass at completing this challenge.  More info in the spoiler in case someone else wants to solve this on their own.

Spoiler

If you look at your results (for example rows 456 - 458) there are Published Years results that are incorrect.  This is due to the title having multiple hits on (\d{4}), which results in incorrect data summation.  To match the results I had to find \d{4} inside of parentheses:  \((\d{4})\).  To parse the title correctly without a trailing space it was (.*)\s\((\d{4})\)

[estherb47]

My record count is also slightly off the solution (guessing it has to do with choices in cleaning up the titles)

Spoiler

[PhilipMannering]

About 100 records out... :/

Spoiler