Embedded Files
Apartment Rental Costs in the Vancouver Area
Apartment Rental Costs in the Vancouver Area
Description. Housing affordability in Vancouver is currently an major issue. In this project I use Python (Beautiful Soup, Selenium) to perform webscraping and collect data from craigslist for 2-bedroom apartments. That data is cleaned and saved to as an csv file. SQL with SQLAlchemy was used to filter the data to Burnaby, Coquitlam, Surrey, and Vancouver locations as well as gather statistical information, and MatPlotLib was used to visualize the data.
Findings. Vancouver priced apartments at an average of $3860 (+/- $388) per month, Burnaby at $2974 (+/-$145) per month, Coquitlam at $2368 (+/- $153) per month, and Surrey at $2186 (+/-$150) per month.
Data Visualization Project
Data Visualization Project
Purpose. The purpose of this project is to explore the sample data provided by Microsoft 'Adventure Works' using Microsoft Power BI. First the data was cleaned and a data model was produced (See below). Next, several aspects of the data was explored using measured columns and simple DAX commands.
Adventure Works Report.pdfPage updated
Google Sites
Report abuse