Challenge #78: Find the Best Housing Markets

[johnemery]

That was a tough one! Web scraping/text parsing can be very tricky, so this was a good practice. It's also quite illuminating to see how others tackled this problem.

Spoiler

[ponraj]

Here is my solution 

Spoiler

[maheensayeed]

Took me a while to figure out the need for multi-row formulas but got there in the end

[mikeprice17]

Really struggling to learn regex but got through it..

[JennyMartin]

Spoiler

Fun data cleaning challenge

[Nicholas_Bignell]

https://youtu.be/X6i6AlyPzyA

[nataliamiteva]

My solution below. 

Spoiler

[dashakir1]

Thanks JoeM.

[andyjohnstone2]

Could have dynamically renamed columns and not sure a regex + multi row is the best way to deal with the split lines but it worked in the end.