Challenge #207: Parsing Video Game Data

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

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.

challenge_207_start_file.yxmd

challenge_207_solution.yxmd

Developer

Parse

Join

Preparation

Advanced

Data Analysis

Intermediate

Accepted answers

All comments

philipmannering

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

Spoiler

Workflow

And with three tools

Spoiler

Where the regex used is,

(\d+)(.*) (\w+) \((\d+)\) CAT:(.*) PUB:(.*) \$(\S+)million, \$(\S+)million, \$(\S+)million, \$(\S+)million, \$(\S+)million

Challenge 207 - Parsing Video Game Data.yxmd

Blake

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

Spoiler

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

challenge_207_start_file_BH.yxmd

johnemery

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

Challenge 207 Solution.yxmd

RolandSchubert

Managed to solve without RegEx ...

Spoiler

challenge_207_solution_rsc.yxmd

Aaron_Harter

Great RegEx practice for this challenge:

Spoiler

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

Spoiler

challenge_207_solution_AB Data Consulting_Aaron.yxmd

degalabh

Used Regex and tried to use minimal number of components

challenge_207_sol_file.yxmd

Greg_Murray

Solution attached.

challenge_207_solution GM.yxmd

JoeRoskowski

Solution attached.

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

challenge_207_Solution.yxmd

patrick_digan

Spoiler

challenge_207_start_file.yxmd

sonyakasenkramer

I have a serious love/hate relationship with regex.

challenge_207_SKK.yxmd

aanandkumar

challenge_207_Anandkumar.yxmd

T_Willins

Really old school game. Used to play it on the Atari 2600

Spoiler

challenge_207_solution.yxmd

TonyA

Here's my solution

Spoiler

REGEX expression:
(\d{7})(.*)\s(\w+)\s$(\d{4})$\sCAT:([^\s]+)\sPUB:([^$]+)\$([\d\.]+)million, \$([\d\.]+)million, \$([\d\.]+)million, \$([\d\.]+)million, \$([\d\.]+)million.*

challenge_207_TonyA.yxmd

AkimasaKajitani

My solution.

Spoiler

It's a nice exercise of RegEx tool.

challenge_207_start_file_kajitani.yxmd

NeoInfiniTech

Solution is attached.

challenge_207_solution.yxmd

AndrewS

#207

Spoiler

challenge_207_start_file_complete.yxmd

Jonathan-Sherman

Challenge 207 has been served up two ways...

Firstly with the fewest tools I could (3 tools):

Spoiler

challenge 207 JMS solution FewestTools.PNG

Secondly with the fewest tools I could whilst keeping the workflow fully dynamic (6 tools):

Spoiler

challenge 207 JMS solution MoreDynamic.PNG

Thanks for the RegEx challenge @AYXAcademy!

challenge_207_JMS_solution_FewestTools.yxmd

challenge_207_JMS_solution_MoreDynamic.yxmd

rmassambane

challenge_207.yxmd

JamesCameron

Here's my solution to this week's problem

Spoiler

challenge_207_solution.yxmd

Kenda

Spoiler

Could've done it in two tools but had to add a stinkin' Select to get rid of the original field.
Annotation 2020-03-17 134211.png

challenge_207_start_file.yxmd

duartepimentel

Interesting RegEx manipulation

challenge_207_start_file.yxmd

Ladarthure

my solution loved building the Regex 🙂

challenge_207_start_file.yxmd

hbraunius

My solution attached.

challenge_207_solution_hb.yxmd

JORGE4900

I love parsing Regular Expressions; however, it is very useful to use a website like https://regex101.com/ to help you identify groups and characters matched. This approach makes it easy to see if you should use a single digit--(\d) in a group or use zero or more digits--(\d*).

https://regex101.com/ Here

Spoiler

Workflow Here

Spoiler

challenge_207_Jorge4900.yxmd

dpencheva

Here is my solution. The task was really interesting!

challenge_207_solution_file.yxmd

ggruccio

Currently playing Marvel Superhero Alliance 3 - and just like I've had to finish a few battles - Use BRUTE FORCE! (And of course REGEX)

challenge_207_gg_finish.yxmd

OllieClarke

I do love me some parsing 🙂

Spoiler

challenge_207_OC_solution.yxmd

OllieClarke

@PhilipMannering now you're just showing off 🙂

dkoenawan004

Regex change my life, it is such a wonderful thing.

I tried to challenge myself and just use one Regex tool on this one.

Spoiler

Challenge_207_dkk_solutions.yxmd

Strohy

Nice one. Solution attached.

Spoiler

Cheers

challenge_207_my_soln.yxmd

hayley9

Here is my solution.

Ch207Solution_hr.yxmd

GBO95

My Solution:

challenge_207_GB.yxmd

Paradox

Spoiler

Parsed the headers into rows for the dynamic replace. Split the doubles first, then used Regex in the formula tool to create the other fields. Multi-column formula with ignore errors instead of replace().

challenge_207_start_file.yxmd

CharlotteGuy

Great exercise to increase mastery of the REGEX tool.

Spoiler

challenge_207_start_file Solution.yxmd