Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #207: Parsing Video Game Data

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.GIPHYGIPHY

 

Video games have become a ubiquitous part of culture over the past few decades. What started as giant consoles became miniaturized for use at home. As popularity increased and technology advanced, more titles were offered by various companies. Whether you wanted to be a frog hopping across the street, stack odd shapes falling from the sky, or defeat the dreaded space invaders, there was a game for you. 

 

Over time, many companies innovated with different categories of games which expanded or create new genres. These games were made available for a variety of platforms - the hardware running the games. 

 

This week's challenge is to parse the provided video game dataset into columns.

PhilipMannering
16 - Nebula
16 - Nebula

Regex to the rescue....again. Solution attached.

 

Spoiler
WorkflowWorkflow

 

And with three tools

Spoiler
Annotation 2020-03-16 152550.jpg
Where the regex used is,
(\d+)(.*) (\w+) \((\d+)\) CAT:(.*) PUB:(.*) \$(\S+)million, \$(\S+)million, \$(\S+)million, \$(\S+)million, \$(\S+)million
Blake
12 - Quasar

I'm not going to pretend that this is pretty... or efficient... but it works! 

 

 

Spoiler
207.png

I don't play video games like I used to but this has made me nostalgic for some Mario Kart 64! 

 

 

 

johnemery
11 - Bolide

Some tricky regex in here. These challenges are excellent practice for regular expressions.

 

I posted a video of my solution here: https://youtu.be/I80eCfDph2Y

 

Spoiler
Capture.PNG

 

206] I Can Alteryx That: Hotel Reservations In this edition of I Can Alteryx That, we walk you through a solution to Alteryx weekly challenge #9. View the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-207-Parsing-Video-Game-Data/td-p/541880 Follow us on Twitter: ...
RolandSchubert
16 - Nebula
16 - Nebula

Managed to solve without RegEx ...

 

Spoiler
207.png
Aaron_Harter
11 - Bolide

Great RegEx practice for this challenge:

Spoiler
207.PNG

 (edit 3/16 12:20 CDT) Video of solution overview:

Spoiler
degalabh
5 - Atom

Used Regex and tried to use minimal number of components

Greg_Murray
12 - Quasar

Solution attached.

JoeRoskowski
Alteryx
Alteryx

Solution attached.

 

Attempted to use only 1 RegEx tool to parse a significant amount of the data.

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1584380325746.png