Visualizing Price Growth of Top 20 SFH Markets Via Python

Previously working at a real estate investment marketplace, I’ve been lucky enough to get exposure to industry trends and data. Living in the Bay Area, I’ve also been lucky enough to get exposure to local real estate news.

Over the last 5–7 years, a major factor in the real estate market has been rapid home price appreciation. Historically low interest rates and low unemployment coupled with a recovery from the 2008 crash has driven home prices up every year. In the single family rental world, because of this rapid appreciation and lagging rent growth, there’s been yield compression in many markets.

To better visualize this appreciation, I looked at home value data from the top 20 markets in the US from Zillow (ZHVI Single Family Homes Time Series by Metro & US). I used Python packages pandas and matplotlib to create the following graphic tracking home prices in markets since 2007 up until April 2019:

Image for post
Image for post

If you would like to replicate or make modifications, here is the code:

I had to scrub the raw CSV file downloaded from Zillow data due to one of the region names containing a symbol that was fidgeting with my import.

The above code produced a bar chart image for each time series contained in the identified range. I then combined the images using a gif maker I found via Google.

Writing about technology, business, and work culture. Subscribe to my casual daily newsletter at https://bryology.substack.com/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store