This repository processes and visualizes housing market metrics for Illinois Metropolitan Statistical Areas (MSAs), comparing current conditions to 2019 baseline data.
Download the following CSV files from Zillow Research Data:
-
For-Sale Inventory (Smoothed, Seasonally Adjusted)
- Download "inventory_smooth_sa.csv"
- Rename to
for_sale_inventory.csv
-
Median Days to Pending
- Download "median_days_pending.csv"
- Rename to
median_days_to_pending.csv
-
Median List Price
- Download "median_list_price.csv"
- Rename to
median_list_price.csv
- Visit Zillow Research Data
- Navigate to the "Housing Inventory" section
- Download each required file
- Rename files as specified above
- Place all files in the
data/inputdirectory of this repository
The repository contains two main R scripts:
data_processing.R: Processes raw Zillow data and generates comparison metricshousing_inventory.R: Creates visualizations of the processed data
library(tidyverse)
library(lubridate)
library(scales)- Ensure all required CSV files are in the
data/inputdirectory - Run the visualization script (which also runs the processing script):
source("housing_inventory.R")The scripts generate several output files in the data/output directory:
illinois_housing_metric_comparison.csv: Combined metrics comparing current values to 2019 baselineprocessed_inventory.csv: Processed inventory datainventory_comparison.csv: Inventory comparisons across time periods
- Active Listings: For-sale inventory trends across Illinois MSAs
- Median Days to Pending Sale: Time on market trends for Illinois properties
housing_inventory.png: Bar chart showing inventory changes across Illinois MSAs- Additional PNG files with trends and comparisons generated in the output directory
The analysis includes the following Illinois Metropolitan Statistical Areas:
- Chicago-Naperville-Elgin
- Peoria
- Rockford
- Champaign-Urbana
- Springfield
- Bloomington
- Ottawa-Peru
- Carbondale-Marion
- Kankakee
- Decatur
- Danville
- Mount Vernon
- Quincy
- Sterling-Rock Falls
- Davenport-Moline-Rock Island (IL-IA)
- The analysis automatically uses the most recent complete month of data available
- Comparisons are made against the same month in 2019 as the baseline year
- All metrics are seasonally adjusted where applicable