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.
Here's my solution. My record count is slightly different than the provided solution but I'm ok with the differences.
@patrick_digan Any idea where the difference emerged? I'll re-visit my solution, too.
My solution!
Cheers!
NJ
The only spoilers I want to see are for this challenge. Seeing Avengers Endgame tonight!
My Solution
@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.
My record count is also slightly off the solution (guessing it has to do with choices in cleaning up the titles)
About 100 records out...
My solution:
Of course the real question is...what happened to Millie the Model and the Two-Gun Kid
Dan
This week, I've learned the names of numerous comic characters I'd never heard before ... Beside that, my record count is not exactly identical to the solution, difference seems to be caused by handling of issues like "12.1" or "0.5".
My salutation
Back to challenges!
Decided to challenge myself and do it all in only 1 regex parse. Had it match perfectly.
My solution attached.
I also had the record count discrepancy due to the '0.5' and '12.1' issues.
Looks like you can get a different list depending on which field you parse. I made it match the expected output.
Thanks for a great challenge, it was almost just like
Snap
and i kept more than 50% 😁
Still Climbing/Verakso
Hi! Here my solution (my record count is also slightly different, checked it 100 times but I don't see what happens)
My solution. I was able to match the record count in the solution @ChristineB. It was a bit challenging to get the exact match, but finally figured it out.
Here is my solution...
Here is my solution.
My solution.. We use Alteryx.. We are all super heros!! :-)
Here You Go. Just started the weekly challenge. #WhateverItTakes
Here Below My Solution
Christine,
My submission is attached.
-I also figured out why the record count was slightly different for most.
-The solution truncates some of the issue numbers, as #13 versus 13, 13.3, and 13.4 as in the case of Red Hulk.
-So, if you want to be particular about it, the solution does ask for every issue that the Character appeared in and 13 is different from 13.3 and 13.4 as these were slightly different updates or reprints (attached are all three covers)
-In total there were about 58 count of discrepancies.
-I used the summarize tool to count by number of issues by Character.
-Please let me know what everyone thinks and if my methodology or rationality is off.
-Cheers!
Matt
Fun challenge, @ChristineB I couldn't bring myself to add the # sign to the issue and foul up the clean data. Here is my solution:
I came up with a slight difference in count as well. I noted there were issues with Variant in the title, which were essentially duplicates and accounted for around 3000 issues. But I still didn't get precisely the challenge results, either. There were comics with no issue or year and highly similar names like these, which were also problematic (I didn't try to solve for these):
Thanks for the exercise!
Here's my solution, was good opportunity to dabble into some regex
Here's my solution, was a good opportunity to dabble into some regex
My solution, I had troubles with getting the perfect match, but finally did it
I did it! My records are off but I feel comfortable with the solution. I thought variants should remain as well so I left them in!
My first time posting a Challenge solution
Like most people, I ended up with a different number of records, but as a beginner user I this a really good workout
Took a bit to get the record count to align, but got there in the end
Fun challenge, thanks to @LukeM I learned some new skills with RegEx!
(.+)\s\(([0-9]{4})\)\s(.+)​
My 30th solution in the last 15 days! Outputs seem to be different according to user so I've matched the official solution file even though it's different from the reference output.
