Launch, grow, and unlock your career in data

July 1, 2021

#WOW2021 Week 22 - Can You Structure the Unstructured?

No comments
Week 22 was quite the tricky challenge. The idea itself is quite simple, but you had to (1) use REGEX to get the number of bedrooms (thanks to Sylvie Imbert at The Data School for her help!) and (2) know how to create bins without using the BIN function. 

Unless you've done it before, you likely will get quite stuck figuring out how to create the bins because it requires a hidden function...SYS_NUMBIN. I won't go into detail here; you can read more on Jeffrey Shaffer's blog here.

Check out how we did it by clicking on the image below.

No comments

Post a Comment