Project Title: Financing Used Cars 🚗🚙🚐

Project Description/ Outline:

Create an educational dashboard to guide potential buyers in making the right decision when it comes to buying a car with finance. Analyse between comparison loans provided by car dealer and financial institution.

Contributors:

Helen Amin	FangXuan Foo
Contributions:
Data scraping, Creation of Database to store scraped data, ETL on data and presenting the report in word doc

Transformations performed:

Data Scraping

Data Joining:

• Combine comparison rate scraped from used car site and the financial institution listed from Finder.com.au

Data Cleaning:

• Removed financial institutions that provides "New" car loan
• Removed unnecessary symbols from the financial institution names to enable usage as columns in SQL

Data Aggregation:

• Get total price of Used Car and calculate it against each comparison rate provided by the financial institutions
• Created equation for Monthly repayments and input in the combined dataFrame

SQL Table Schema:

Export to SQL:

Query in SQL:

Data obtained from:

• https://www.westsideauto.com.au/vehicles/list?q=condition:used
• https://www.finder.com.au/car-loans

To read the report on the project, please use the following link.