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

mmontgomery
11 - Bolide

Challenge #54

brianfia
8 - Asteroid
Spoiler
challenge_54_solution_brianfia.PNG
GavinRoffe
7 - Meteor

Solution

hannahcrabtree
8 - Asteroid

Solution uploaded! I feel like I took an approach that worked well for this amount of data but would be hard to extend for a larger dataset. Basically, created a list of end of address names (road, street, avenue, etc). You could add to the dictionary as you have more addresses to parse but there are only so many different address ends. 

 

Spoiler
hannahcrabtree_0-1655150052284.png

 

kriangsaksumthong
8 - Asteroid

try

danettedavis
8 - Asteroid

solved

NhungLe
8 - Asteroid

#54

ChrisMelck
8 - Asteroid

Regex getting a little better

DataKilroy
8 - Asteroid
Spoiler
DataKilroy_0-1656519821531.png

 

bold3d
8 - Asteroid

My solution for Challenge #54: