Thanks to some love over at Code for San Jose, SJ Charts is now SJ Data Charts and fully open-sourced here! Plot.ly has been fun and the documentation, as well as the community forums, have been great to work with. Wish there was more in-grained analytics support via Google Analytics and Mixpanel, but that seems to be a work-in-progress. Here’s what it looks like now:
The charts now have time-based charts for Housing Prices, Unemployment rate, and Jobs by Sector for the City of San Jose. The idea behind this app is to show various analyses via a top-level tabbed navigation from the Code for San Jose community. Basically, to build out useful analyses for the open data available from the City of San Jose.
After dabbling with Pandas and asking around for better methods of building out interactivity, lo’ and behold: Plot.ly arrived. As a side project, I’ve been doing some data analysis on Open Data from the City of San Jose. Here’s the output: SJ Charts.
It’s a fun, interactive dashboard to view Job-by-Sector data between 2008-2015 for the City of San Jose found via the source here or in a translated form, here. The intention is to expand with other analyses on this dashboard app and apply some checkbox love, but that might change depending on feedback. Looking to give back to the city I grew up in.
To give feedback, you can reach me via all the normal social channels. Github repo coming soon!
So, I took a few weeks to get on-ramped with Pandas 0.23.0 and Python and am still learning the ropes. Though, I wanted to share some output. Namely, using the San Jose Open Data Portal, there were some good insights to be had from looking at economic data pushed out by the city for 2006-2016.
What did I do?
- Looked at unemployment rates across various housing prices (condos/townhomes & single-family homes) using ordinary-least-squares regression.
- Looked at, over time, labor force and housing price changes.
SJ Economic Changes, 2006-2016
Condo/Townhome prices vs. SJ Metro Unemployment
Single Family Homes prices vs. SJ Unemployment
What did I find? Namely, housing prices are increasing rapidly compared to labor change (i.e. job growth) in San Jose over the course of 2006-2016. Also, there’s a strong correlative relationship between something that we all take for granted and as obvious: increased housing prices in San Jose runs with lowered unemployment rates.
If you’d like to look at the data analysis done, here’s the GitHub repo. If you have any questions/comments/suggestions on more analysis, feel free to contact me via Twitter, GitHub, or LinkedIn.