Project Outline:
To create a visualised data on real estate properties in the City of Perth. This includes suburbs - Crawley, East Perth, Nedlands, Northbridge, Perth, and West Perth. We also want to assist future buyers and investors to be able to predict the future property price.
Questions:
This project sets out to answer the following :
- What are the price range of each suburb?
- What are the property type that people are interested in buying?
- Which age range does the sold properties mostly fall under?
- Does the number of car park affect property price?
- What are the key factors that are impacting the property price?
- Are some properties better to rent or buy?
- How much is the return of investment?
- Have Covid-19 impacted the Real Estate market?
ETL Process:
Dataset scraped from http://house.speakingsame.com/ site and filled some missing data manually using another two realestate websites to ensure data integrity. Cleaned the data by removing N/A and converted data types, combined all the data of the suburbs into a single data frame. Load data onto SQLite and retrieve SQL data in Flask file to create the API.
Scope:
Properties meaning residential properties which includes Unit, Apartments, Townhouses, Houses. This project will only look at landed properties - House, Townhouse & Villa. Rent column implies that the property has been advertised and has been rented out in at the time of the Rent Date. Rent with 0 dollars value have not been advertised for Rental and will have Rent Date of 01/01/1900.
Perth City Properties
|
|__Archive/ # conitains archived files since project started
|
|__ML_Model/ # contians saved mashine learning models
|
|__ Notebooks/ # contains ETL and ML notebooks
| |__ Add location.ipynb # add Geospatial data to csv files
| |__ ETL.ipynb # data extract, transform, load to SQL
| |__ ML notebooks
| |__ scrape.ipynb
|
|__SQL
|
|__static/
| |__ css # css files for webpage
| |__ data # Directory for the data files
| |__ images # images used in project
| |__ js # js files for webpage
|
|__Tableau # tableau files
|
|__templates # conitan index.html
|
|__ .gitignore
|__ app.py # flask file
|__ LICENSE
|__ Procfile # related Heroku
|__ Project3_proposal.docx
|__ README.md # read me file
|__ requirement.txt # contains project dependencies
- Crawley and Nedlands have properties with more land size and a higher average price compared with the other 4 suburbs.
- Perth, East Perth, West Perth and Northbridge have similar average price whereas Crawley and Nedlands are almost more than double.
- More apartments and units around Perth and it's surrounding suburbs. Moving away, there are more properties with land in the outer suburbs.
- There are properties dated all the way back to 1910s and despite the age of the property, their price are well above average.
- Perth have newer properties, exploring further identified that most of them are apartments.
- The average price of a property increases the same as number of car spaces with the height at 4 car spaces at over 2.2 Million dollars.
- Buyer and sellers can use the guide to identify the average price that they would be paying for in a suburb according to the property criteria that they want.
- Can also use the Best Agent chart to identify the best real estate agent when deciding to buy or sell a property.
- In some suburbs, it is much better to rent than buy due to the # of a property.
- Most properties have a good Return of Investment (ROI) of 4 to 7%
- Do note that the weekly loan payments is calculated with using the sold price of the property and a fixed annual rate of 3%, not including home loan deposits.
- We can see a decline in purchase when the lockdown was announced in March 2020, however as soon as the Federal Government announced the grant in June 2020, numbers of properties sold increases.
http://house.speakingsame.com/
https://www.onthehouse.com.au/
https://www.propertyvalue.com.au/
