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 #54: Data Prep Address Parsing

JackBurnham
8 - Asteroid

b

aravind_sk
8 - Asteroid

Solved!

ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-18 213437.png

millerbp
8 - Asteroid

Took the scenic route

Elias_Nordlinder
11 - Bolide

Interesting Regex Exercise, happy that I could do the parsing with one tool, but took some time 🙂

 

Spoiler
Elias_Nordlinder_0-1626792180458.png

 

Elias_Nordlinder_0-1626792061901.png

 

  

NicoleDuhamel
8 - Asteroid

solution attached

dfurlow
8 - Asteroid

Difficult to imagine finding a simple way to systematically do this cleansing/normalisation on <any> dataset, but for this set, at least, it can be done.  

VizChic
11 - Bolide

fg aa soln 54

euanwilson
8 - Asteroid
Spoiler
Workflow.PNGResults.PNG
BenFr
Alteryx
Alteryx

A very shaky solution if new road types/abbreviations were added to the data!

Spoiler
BenF2_0-1627570671376.png