Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Highlighted
12 - Quasar
12 - Quasar

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.

Spoiler
I had struggled with some of the titles that have an #8203 in the title looking like some sort of symbol change that I had to adjust.

Challenge 162.PNG

 

Highlighted
8 - Asteroid

Here is my solution...

Highlighted
7 - Meteor

Here is my solution.

Highlighted
8 - Asteroid

My solution..  We use Alteryx.. We are all super heros!!  🙂

Spoiler
Challenge_162_PD_Spoiler.JPG
Highlighted
Alteryx Partner

Here You Go. 
Just started the weekly challenge. #WhateverItTakes

Highlighted
8 - Asteroid

Here Below My Solution

 

Highlighted
8 - Asteroid

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

Red Hulk Combo.png

Highlighted
8 - Asteroid

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:

 

 

Spoiler
162-MP.png

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): 

 

 

162-dups.png

 

Thanks for the exercise!

Highlighted
5 - Atom

Here's my solution, was good opportunity to dabble into some regex 🙂

 

 

Highlighted
5 - Atom

Here's my solution, was a good opportunity to dabble into some regex 🙂