Creating a Master Property List for London

Problem Statement

At Mappa, we're redefining the experience of finding a new home. From finding a new neighbourhood, to property viewings, negotiations and dealing with admin (e.g. mortgage and legal), your decision-making potential will be maximised to allow you secure the best value for your money. Our mission is to hand back knowledge and control to the house hunter using the power of data and technology. Our goal with this project is create is to create a master list of listed properties starting with London. Your task is the extract and blend property datasets across the Greater London area (United Kingdom) in one dataset. **Key Deliverables:** - Code base - Documentation - Architecture diagram of flow **Review and Selection:** Contestants will be evaluated on - End-to-end process - Code base quality - Extracted dataset (output) quality - Delivery and Reporting Allowed programming language is Python Design thinking is important. Contestants can go to any length to provide an end to end solution that is fully automated, tested and data could be pulled from a database.

Project Description

At Mappa, we're redefining the experience of finding a new home. From finding a new neighbourhood, to property viewings, negotiations and dealing with admin (e.g. mortgage and legal), your decision-making potential will be maximised to allow you secure the best value for your money. Our mission is to hand back knowledge and control to the house hunter using the power of data and technology. Our goal with this project is create is to create a master list of listed properties starting with London. Your task is the extract and blend property datasets across the Greater London area (United Kingdom) in one dataset. **Key Deliverables:** - Code base - Documentation - Architecture diagram of flow **Review and Selection:** Contestants will be evaluated on - End-to-end process - Code base quality - Extracted dataset (output) quality - Delivery and Reporting Allowed programming language is Python Design thinking is important. Contestants can go to any length to provide an end to end solution that is fully automated, tested and data could be pulled from a database.

Deliverables

• Property sites
• - Rightmove
• - Zoopla
• - On The Market (OTM)
• Required fields
• - Transaction type (i.e. sale vs. rent - string)
• - Bedrooms (integer)
• - Bathrooms (integer)
• - Description (free text string)
• - Property type e.g. flat, detached house, terraced house
• - Price e.g. 500,000 (typically integer)
• - Location
• - Key location data here is Postcode district and/or Postcode
• - See link for explanation of what these are
• - Agent (advertising the property)
• - Listing source
• - Listing URL
• - Other nice-to-have metadata
• - If a rental property is furnished or not
• - Anything else you deem interesting
• Geographical remit
• - Greater London
• - See following files for guidance
• - List of postcode districts
• - Map of districts

Skills Required