Property Sale Analysis — Mia Jiu

Return to Projects Page

Property Sale analysis

Dec.2017-Jan.2018

Preprocessed the sale dataset with 17,031 observations from Winnebago county IL, including converting addresses in original dataset into geographic coordinates with python and Google Maps Geocoding API key
Performed data filter function and visualization analysis with Tableau and implemented anomaly detection packages from R in Tableau calculation function Report Link
Conducted data visualization and property price prediction with Gradient Boosting Regression with python Report Link

House price.png

House price2.png

Sale trend(quarter).png

Sale trend(month).png

Clusters of house prices.png

House classes with price clusters.png

House classes with average sale price.png

Sale type with average sale price.png

Township with average sale price.png

Sale prices.png

House classes with sale type.png

House classes with time.png

Sale type with time .png

Winter sale.png

Screen Shot 2018-01-16 at 2.04.59 PM.png

Screen Shot 2018-01-16 at 2.05.11 PM.png

Screen Shot 2018-01-16 at 3.31.57 PM.png

Screen Shot 2018-01-17 at 4.32.26 PM.png

House price.png

House price2.png

Sale trend(quarter).png

Sale trend(month).png

Clusters of house prices.png

House classes with average sale price.png

Sale type with average sale price.png

Township with average sale price.png

Sale prices.png

Winter sale.png

Screen Shot 2018-01-16 at 2.04.59 PM.png

Screen Shot 2018-01-16 at 2.05.11 PM.png

Screen Shot 2018-01-16 at 3.31.57 PM.png

Screen Shot 2018-01-17 at 4.32.26 PM.png