Introduction

Housing is the most significant investment an average-income family will ever make over entire lifetime - whether it is buying a house or living in rental houses for a better part of life.

Previously I worked with housing data, but in a smaller scale. I was mostly interested in how and to what extent metro stations affect apartment rents. This one, on the other hand, is a large and interesting time series dataset with some really cool features. However, to begin with I am interested in the big picture questions in terms of rentals and property prices. Specifically: (1) the evolution of (trend) house rental and sales price, and (2) how rental and sales prices vary across states. This analysis provides some interesting insights as we willsee shortly below.

Rental price by state

Who’s surprised that NY, DC, MA HI and CA are top 5 states with the highest house rents? Pooling all the data from 2010 shows that NY has by far the highest house rents - more than 4 USD/ft2. That’s a lot! This means, for a 900 ft2 2-bedroom apatment New Yorkers pay $3,500. I’m pretty familiar with DC area house rents. $2.5/ft2 - or $2200 for a 2-bedroom apartment is typical in this area. But in contrast consider the other side of the spectrum - think about how much can be saved by living in states such as AL, AK, GA.

House sales price by region

In terms of house price, the distribution is similar as in rental price. 5 tops are usuals suspects - DC, HI, CA, MA NJ. The states where you can buy cheapest houses are in WV, OK, AK, AL, GA.

About
https://twitter.com/DataEnthus