{
"cells": [
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"# Standard imports\n",
"import quandl\n",
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"%matplotlib inline\n",
"\n",
"# Plotly for better graphs\n",
"import plotly.offline as plotly\n",
"import plotly.graph_objs as go\n",
"\n",
"plotly.init_notebook_mode(connected=True)"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [],
"source": [
"# Read Data from Indicators CSV\n",
"indicators = pd.read_csv('indicators.csv', sep=\"|\")\n",
"indicators.set_index('CODE', inplace=True)"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [],
"source": [
"# Constants\n",
"# Set your Quandl API Key\n",
"quandl.ApiConfig.api_key = {YOUR API KEY}\n",
"zip_code = 94608\n",
"start_date = '2014-01-01'\n",
"end_date = '2018-07-01'\n",
"code_prefix = f'ZILLOW/Z{zip_code}_'\n",
"\n",
"# Enter in the cities you want to see data for\n",
"cities = ['Berkeley, CA','Oakland, CA', 'Emeryville, CA', 'Dublin, CA', 'San Ramon, CA', 'Fremont, CA']\n",
"\n",
"codes = dict(MSPAH=indicators.loc['MSPAH']['INDICATOR'],\n",
" MLPAH=indicators.loc['MLPAH']['INDICATOR'])"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {},
"outputs": [],
"source": [
"areas_city = pd.read_csv('areas_city.csv', sep='|')\n",
"areas_city.index = areas_city['AREA']\n",
"areas_city['CODE'] = 'C' + areas_city['CODE'].astype(str)\n",
"cities_dict = areas_city.loc[cities]['CODE']"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {},
"outputs": [],
"source": [
"# Translate DataFrame into Plotly Scatter Plot\n",
"def plot_df(dataframe, title): \n",
" data = [go.Scatter(x=dataframe.index,\n",
" y=dataframe[column],\n",
" name=column) for column in dataframe.columns]\n",
" layout = dict(title=title)\n",
" fig = dict(data=data, layout=layout)\n",
" return fig"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [],
"source": [
"# Get Multiple Indicators for One Location\n",
"def get_indicator_data(location, indicators):\n",
" df_array = []\n",
" for code, name in indicators.items():\n",
" data = quandl.get(f'ZILLOW/{location}_{code}', start_date=start_date, end_date=end_date)\n",
" data.rename(index=str, columns={'Value': name}, inplace=True)\n",
" data.index = pd.to_datetime(data.index, format='%Y/%m/%d')\n",
" df_array.append(data)\n",
" ret = pd.concat(df_array, axis=1)\n",
" return ret"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [],
"source": [
"# Get One Indicator for Multiple Cities\n",
"def get_city_data(cities, indicator):\n",
" df_array = []\n",
" for city, code in cities.items():\n",
" quandl_db_code = f'ZILLOW/{code}_{indicator}'\n",
" try:\n",
" data = quandl.get(quandl_db_code, start_date=start_date, end_date=end_date)\n",
" data.rename(index=str, columns={'Value': city}, inplace=True)\n",
" data.index = pd.to_datetime(data.index, format='%Y/%m/%d')\n",
" df_array.append(data)\n",
" except:\n",
" print('Could not fetch for:', city)\n",
" ret = pd.concat(df_array, axis=1)\n",
" return ret"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {},
"outputs": [],
"source": [
"dataset = get_city_data(cities_dict, 'MRP2B')"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"name": "Berkeley, CA",
"type": "scatter",
"uid": "fd0f0276-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
2750,
2800,
2800,
3025,
3000,
2975,
3397.5,
3450,
3290,
3250,
3239,
3250,
3100,
3091,
3100,
3195,
3200,
3300,
3400,
3300,
3800,
3500
]
},
{
"name": "Oakland, CA",
"type": "scatter",
"uid": "fd0f0528-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
2325,
2250,
2572.5,
2700,
2750,
2785,
2837,
2700,
2800,
2888,
2825,
2797.5,
3130,
2750,
2800,
2497.5,
2800,
2500,
2650,
2600,
2695,
2762.5,
2712.5,
2750,
2750,
2795,
2800,
2875,
2850,
2795,
2750,
2660,
2599.5,
2680,
2795,
2795
]
},
{
"name": "Emeryville, CA",
"type": "scatter",
"uid": "fd0f06e0-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
3295,
3569.5,
3529,
3550,
3540,
3574.5,
3682,
3590,
3618,
3520.5,
3372.5,
3350,
3392.5,
3325,
3427,
3493,
3500,
3491.5
]
},
{
"name": "Dublin, CA",
"type": "scatter",
"uid": "fd0f0852-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2350,
2351.5,
2325,
2346,
2452,
2462,
2583,
2603,
2560,
2500,
2530,
2486,
2464.5,
2452.5,
2470,
2600,
2646.5,
2652.5,
2645,
2790,
2783,
2597.5,
2666.5,
2700,
2641,
2688,
2700,
2650,
2795,
2840,
2700,
2800,
2790,
2712.5,
2600,
2650,
2697.5,
2800,
2781,
2800,
2822,
2850,
2998,
2995,
3008,
2924,
2918,
2918,
2918,
2930.5,
2988,
2978,
2925.5,
2950
]
},
{
"name": "San Ramon, CA",
"type": "scatter",
"uid": "fd0f09ba-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2010,
1947,
1947,
2051,
2200,
2250,
2296,
2353.5,
2357,
2300,
2298,
2180.5,
2350,
2357,
2357,
2357,
2375,
2447.5,
2357,
2357,
2357,
2357,
2515,
2548,
2504,
2531,
2519,
2443.5,
2467,
2625,
2441.5,
2488,
2495,
2426,
2400,
2353,
2555,
2499,
2500,
2600,
2600,
2704.5,
2506,
2500,
2455,
2450,
2455,
2455,
2540,
2525,
2500,
2510,
2503,
2645
]
},
{
"name": "Fremont, CA",
"type": "scatter",
"uid": "fd0f0b2c-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1997.5,
2012.5,
2025,
2100,
2221,
2200,
2295,
2195,
2200,
2128,
2235,
2200,
2145,
2265,
2300,
2491.5,
2515,
2585,
2553,
2685,
2660,
2500,
2660,
2661.5,
2600.5,
2613,
2617.5,
2637,
2628,
2644,
2634,
2537,
2575,
2558,
2454,
2500,
2500,
2455,
2500,
2615,
2639,
2629.5,
2600,
2611,
2600,
2600,
2600,
2606,
2579,
2554.5,
2633,
2700,
2695,
2738
]
}
],
"layout": {
"title": "Median Rental Price 2 Bedroom"
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"fig = plot_df(dataset, 'Median Rental Price 2 Bedroom')\n",
"plotly.iplot(fig)"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [],
"source": [
"# plotly.plot(fig, include_plotlyjs=False, output_type='div')"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"name": "Berkeley, CA",
"type": "scatter",
"uid": "fea367b2-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
3295,
3450,
3645,
3275,
3350,
3175,
3500,
3497.5,
3800,
3800,
3400,
3300,
3375,
3372.5,
3500,
3499.5,
3650,
3550,
null,
null
]
},
{
"name": "Oakland, CA",
"type": "scatter",
"uid": "fea36a8c-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
2300,
2385,
2300,
2272.5,
2297.5,
2400,
2400,
2499,
2550,
2450,
2600,
2625,
2897.5,
2995,
2750,
2800,
2800,
2800,
2850,
2850,
3000,
3000,
3197,
2850,
2972.5,
2695,
2800,
2925,
2850,
2900,
2850,
2850,
2900,
2950,
2950,
2900,
2999,
3000,
2999,
2949.5,
2900,
2800,
2800,
2900,
3092.5,
3150
]
},
{
"name": "Emeryville, CA",
"type": "scatter",
"uid": "fea36c58-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
2475,
2500,
2500,
2600,
2747.5,
3022.5,
2950,
2800,
2850,
2675,
2847.5,
3100,
2900,
2895,
2772.5,
2747.5,
2500,
2500
]
},
{
"name": "Dublin, CA",
"type": "scatter",
"uid": "fea36de8-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2500,
2500,
2587.5,
2600,
2880,
2750,
2757,
2850,
2897.5,
2755,
2997.5,
3075,
2950,
2800,
2897.5,
2800,
2872.5,
3200,
3125,
3100,
3000,
2800,
2900,
3100,
3200,
3197.5,
2995,
3100,
3050,
2995,
3200,
3245,
3199.5,
3095,
2985,
3100,
3200,
3000,
3000,
3100,
3200,
3300,
3200,
3250,
3200,
3197.5,
3200,
3300,
3295,
3272.5,
3400,
3400,
3400,
3325
]
},
{
"name": "San Ramon, CA",
"type": "scatter",
"uid": "fea36f6e-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
3000,
2975,
2950,
3000,
3000,
3000,
3200,
3295,
3200,
3000,
3050,
3000,
3000,
3150,
3200,
3100,
3400,
3450,
3500,
3390,
3250,
3300,
3200,
3150,
3100,
3200,
3495,
3400,
3500,
3550,
3500,
3500,
3200,
3100,
3300,
3450,
3250,
3200,
3200,
3450,
3600,
3750,
3550,
3495,
3500,
3400,
3395,
3400,
3225,
3125,
3397.5,
3495,
3600,
3650
]
},
{
"name": "Fremont, CA",
"type": "scatter",
"uid": "fea370ea-99e2-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2395,
2325,
2395,
2475,
2500,
2495,
2600,
2600,
2687.5,
2600,
2600,
2700,
2475,
2525,
2595,
2750,
2825,
2950,
2995,
3000,
3000,
2999.5,
3000,
2900,
2895,
2977.5,
2900,
2875,
2995,
3100,
3100,
2990,
3100,
2999.5,
2950,
2950,
2995,
3100,
3050,
3150,
3200,
3200,
3200,
3200,
3195,
3100,
3000,
3050,
3000,
3200,
3200,
3300,
3395,
3400
]
}
],
"layout": {
"title": "Median Rental Price All Homes"
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"dataset = get_city_data(cities_dict, 'MRPAH')\n",
"fig = plot_df(dataset, 'Median Rental Price All Homes')\n",
"plotly.iplot(fig)"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {},
"outputs": [],
"source": [
"# plotly.plot(fig, include_plotlyjs=False, output_type='div')"
]
},
{
"cell_type": "code",
"execution_count": 33,
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"name": "Berkeley, CA",
"type": "scatter",
"uid": "0053a0ea-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
2.8957528957529,
2.8707587621178,
2.9709966952986,
3.1265765765766,
3.1436857211194,
3.1158142269253,
3.1919223156853,
3.1531531531531,
3.1578947368421,
2.9535566298342,
3.0259577950602,
3.1428571428571,
3.1263982102908,
3.1638781638782,
3.3076923076923,
3.3333333333333,
3.1172069825436,
3.1183932346723
]
},
{
"name": "Oakland, CA",
"type": "scatter",
"uid": "0053a400-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1.6190476190476,
1.6365688487585,
1.6756212222968,
1.6806722689076,
1.7985611510791,
1.7910447761194,
1.976,
1.919619824428,
1.869124358914,
1.8844444444444,
1.9210810810811,
1.99875,
1.976,
1.8357810413885,
1.974691142726,
2.1038732394366,
2.1038732394366,
2.1062271062271,
2.0186630686758,
2.0283975659229,
2.1739130434783,
2.2377361275089,
2.264395221248,
2.1682147130891,
2.2857142857143,
2.2857142857143,
2.4713150926743,
2.3851102941176,
2.4538461538462,
2.4597258672823,
2.4752475247525,
2.4346793349169,
2.3403755868545,
2.2883228743694,
2.2691082802548,
2.3255813953488,
2.414398595259,
2.4423710208562,
2.4654121863799,
2.5409090909091,
2.6,
2.6301127931137,
2.5823686553874,
2.5828509943603,
2.6362038664323,
2.59952731695,
2.5541299117883,
2.5689075630252,
2.5711683756071,
2.5294512824204,
2.6072227191413,
2.626892252894,
2.656010381031,
2.6964560862866
]
},
{
"name": "Emeryville, CA",
"type": "scatter",
"uid": "0053a5fe-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
3.1975967957276,
3.1550307096351,
3.0716855285708,
3.1901041666667,
3.2985068457153,
3.2993182776004,
3.2552083333333,
3.2552083333333,
3.2359487157918,
3.1367924528302,
3.0735007709938,
2.8985507246377,
3.0534351145038,
3.3076041666667,
3.3143197453855,
3.28,
3.4305993690852,
3.4995451822599
]
},
{
"name": "Dublin, CA",
"type": "scatter",
"uid": "0053a7c0-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1.6431091644402,
1.6691539252776,
1.6585365853659,
1.6784710667684,
1.6282967878767,
1.7625514949007,
1.8311607697083,
1.7464102717559,
1.7490613266583,
1.7969195664575,
1.6550987720235,
1.6674962667994,
1.7486338797814,
1.75,
1.8480516871987,
1.9033232628399,
2.0039250691562,
1.9022509361867,
2.0425551927715,
1.9934956678849,
1.9105984138428,
1.9980932650395,
1.911877394636,
1.8587360594795,
1.9629804056722,
1.9308125502816,
2.0323619263073,
2.0094562647754,
1.9716919025675,
2.0714285714286,
1.9196526838779,
1.8163605110011,
1.9205249419229,
1.9420671494404,
1.8364759366657,
1.8991682902168,
1.9259051848783,
1.9469513157376,
1.9705095250099,
1.9710378117458,
1.9671269436368,
1.9618834080717,
2.0250998288648,
1.9863438857852,
2.0122872767341,
1.9703947368421,
1.9647887323944,
1.9692533194687,
1.9718309859155,
1.9738520408163,
1.9738520408163,
2.0146603311389,
2.0514883346742,
2.0768048316115
]
},
{
"name": "San Ramon, CA",
"type": "scatter",
"uid": "0053a96e-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1.5717475752365,
1.5837215842156,
1.6300847048214,
1.6419703644373,
1.6570855465161,
1.7179023508137,
1.7112945439903,
1.6990291262136,
1.7460317460318,
1.7384105960265,
1.766004415011,
1.8488308863513,
1.9154929577465,
1.860025220681,
1.8005312459082,
1.866295264624,
1.7929179740027,
1.8431001890359,
1.7929179740027,
1.8431001890359,
1.9461538461538,
1.8109328459373,
1.8068102849201,
1.8068102849201,
1.9494204425711,
1.9027484143763,
1.9187423438138,
1.8779811704116,
1.8431001890359,
1.9047619047619,
1.913730255164,
1.7403206883066,
1.8856806128462,
1.9335142469471,
1.7970401691332,
1.775,
1.890869800108,
1.9718309859155,
2.088772845953,
2.0013351134847,
1.9494204425711,
1.8687707641196,
1.8896788923225,
1.9494204425711,
1.913485596696,
1.9170984455958,
1.9301086908251,
1.9211065573771,
1.993769470405,
2.0833333333333,
1.993769470405,
1.9718309859155,
1.9714765100671,
1.9678295317522
]
},
{
"name": "Fremont, CA",
"type": "scatter",
"uid": "0053ab12-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1.7164179104478,
1.7183770883055,
1.7210144927536,
1.7472335468841,
1.9173426790514,
1.7892644135189,
1.7970360758837,
1.8686868686869,
1.8636363636364,
1.8888304579744,
1.8080635533793,
1.9157088122605,
1.8985157059027,
1.9701086956522,
1.9356665836328,
1.9137204022056,
2.0508826583593,
2.0820289651204,
2.0635786232116,
2.0740559245374,
2.0158387329014,
2.0746376811594,
2.0389921741951,
2.0833333333333,
2.1491858237548,
2.0666666666667,
2.1831484198301,
2.2082018927445,
2.1686872909699,
2.1309345644475,
2.1786595785077,
2.2307692307692,
2.0911236999553,
2.1019108280255,
2.0797720797721,
2.027027027027,
2.1332351098764,
2.1053541366041,
2.114131676553,
2.1277304010492,
2.2090878548061,
2.2297297297297,
2.2255574614065,
2.2927925314721,
2.2222222222222,
2.1929824561404,
2.1949177769822,
2.1879661859771,
2.2318214542837,
2.1825396825397,
2.2375,
2.2490221642764,
2.3067170584732,
2.3380093520374
]
}
],
"layout": {
"title": "Median Rental $/SqFt All Homes"
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"dataset = get_city_data(cities_dict, 'MRPFAH')\n",
"fig = plot_df(dataset, 'Median Rental $/SqFt All Homes')\n",
"plotly.iplot(fig)"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {},
"outputs": [],
"source": [
"# plotly.plot(fig, include_plotlyjs=False, output_type='div')"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"name": "Berkeley, CA",
"type": "scatter",
"uid": "01e9af80-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
3.5849056603774,
3.5625,
3.6467574659503,
3.5849056603774,
3.5282352941176,
3.6756126021004,
4.0772703818369,
4.1632653061225,
4.0764200417009,
4.0127688172043,
4.2162698412698,
4.167224062953,
3.9695945945946,
3.928601079286,
3.7599497392254,
3.7416666666667,
3.7753718535469,
4.0261177844511,
4.0816326530612,
4.2,
4.7126436781609,
4.4137931034483
]
},
{
"name": "Oakland, CA",
"type": "scatter",
"uid": "01e9b264-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1.6973125884017,
1.703125,
1.7716106965174,
1.8257575757576,
1.8418063695425,
1.8333333333333,
2.0714256800518,
1.9938438438438,
2.0980158730159,
2.0904761904762,
2.1196283391405,
2.4045066175239,
2.4415644689469,
2.466249028749,
2.4732142857143,
2.5762052086272,
2.5891364902507,
2.5791324736225,
2.3425925925926,
2.3109437171095,
2.5,
2.5225225225225,
2.7777777777778,
2.7272727272727,
2.8430160692213,
2.7038103677448,
2.8511087645195,
2.7423469387755,
2.7586206896552,
2.8449367088608,
3.0183220829315,
2.7516164994426,
2.9431000654022,
2.716049382716,
2.7004219409283,
2.7173906655854,
2.85,
2.8428651933953,
2.9215384615385,
2.8646653543307,
2.7996105489114,
2.8956422018349,
2.8939950980392,
2.8243601059135,
2.8451845184519,
2.8685612788632,
2.8409090909091,
2.9,
2.9135135135135,
2.9285714285714,
2.85,
2.9537853577371,
3,
2.9937444146559
]
},
{
"name": "Emeryville, CA",
"type": "scatter",
"uid": "01e9b43a-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
3.0253482625483,
3.0773704476175,
2.9980563654033,
3.0253807106599,
3.1126530612245,
3.2315227070347,
3.1738775510204,
3.1387702326715,
3.1952247191011,
3.1129476584022,
3.0972072001282,
2.9892823858341,
3.1113262342691,
3.0704633204633,
3.1058710298364,
3.1506309148265,
3.1699845750603,
3.3176470588235
]
},
{
"name": "Dublin, CA",
"type": "scatter",
"uid": "01e9b5d4-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2.0793950850662,
2.0443157058102,
2.0278189000654,
2.1169078304372,
2.2509144111192,
2.3246543941611,
2.3709835830968,
2.3452157598499,
2.2045028142589,
2.08,
2.2953226555246,
2.2424635193133,
2.1773485513608,
2.2475735289206,
2.2619047619048,
2.3642012328086,
2.3696682464455,
2.4540918163673,
2.420236451196,
2.3991992230085,
2.4457019538071,
2.4134889814252,
2.3884757691825,
2.4816176470588,
2.5086995925808,
2.4826216484608,
2.6007326007326,
2.5756227758007,
2.4126838235294,
2.534948542024,
2.3717029025494,
2.5818373812038,
2.3158128896679,
2.1046047493709,
2.2723537892307,
2.4535679374389,
2.4551985226224,
2.4390243902439,
2.4644517824651,
2.4864742177256,
2.5644222776392,
2.5281972997945,
2.751276499051,
2.7615732075566,
2.7320075757576,
2.7878787878788,
2.740157480315,
2.7746455654467,
2.7316100290095,
2.7317822079744,
2.7310726913621,
2.7648131267092,
2.7168234064786,
2.7327935222672
]
},
{
"name": "San Ramon, CA",
"type": "scatter",
"uid": "01e9b75a-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1.9940823646854,
1.9781144781145,
2.0466724286949,
2.09375,
2.0445134575569,
2.0977722772277,
2.1102941176471,
2.0976450038621,
2.1036121673004,
2.1036121673004,
2.0895390070922,
2.0797549262866,
2.1297071129707,
2.1226478300803,
2.2015655577299,
2.1663602941176,
2.2389794094053,
2.244076935523,
2.240494296578,
2.2601934235977,
2.218669061435,
2.2544830535657,
2.4096385542169,
2.4523569856986,
2.3450925370379,
2.4811111111111,
2.5289778714436,
2.5099408983452,
2.4342745861733,
2.4837079275743,
2.4571129707113,
2.4623430962343,
2.4791489361702,
2.2852631689702,
2.3394495412844,
2.4117647058824,
2.4309240622141,
2.5571820677036,
2.4945770065076,
2.5440313111546,
2.5526660787307,
2.5736350257542,
2.4864016736402,
2.4787133396405,
2.5052719200888,
2.4412915851272,
2.407926935266,
2.3950073184782,
2.4574669187146,
2.4815736914029,
2.4853801169591,
2.5643564356436,
2.4938956714761,
2.5704567541302
]
},
{
"name": "Fremont, CA",
"type": "scatter",
"uid": "01e9b9c6-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2.0236920039487,
2.1020579549649,
2.1259124087591,
2.1438721136767,
2.2240128928284,
2.2667829119442,
2.2771573604061,
2.1943268152946,
2.1740384182456,
2.1652046783626,
2.1735150771538,
2.2159548751007,
2.2768729641694,
2.3882352941177,
2.392552076973,
2.5178997680864,
2.6883932508868,
2.6208651399491,
2.7094736842105,
2.6975697569757,
2.6410460611279,
2.5854399611084,
2.6304138594803,
2.595626862751,
2.6058601134216,
2.7626373626374,
2.7266156462585,
2.6297084307648,
2.6029702970297,
2.6928205128205,
2.6548672566372,
2.5715125391849,
2.5806451612903,
2.5106571936057,
2.4237192459845,
2.4579935320585,
2.5484199796126,
2.5760135135135,
2.6105263157895,
2.6881720430107,
2.6775227891583,
2.7050465300465,
2.7147368421053,
2.7309644670051,
2.6759776536313,
2.6232804232804,
2.5492385786802,
2.5429429185186,
2.6069043786885,
2.6342675806042,
2.6612486248625,
2.7064732142857,
2.7256904701295,
2.7277777777778
]
}
],
"layout": {
"title": "Median Rental $/SqFt 2 Bedroom"
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"dataset = get_city_data(cities_dict, 'MRPF2B')\n",
"fig = plot_df(dataset, 'Median Rental $/SqFt 2 Bedroom')\n",
"plotly.iplot(fig)"
]
},
{
"cell_type": "code",
"execution_count": 36,
"metadata": {},
"outputs": [],
"source": [
"# plotly.plot(fig, include_plotlyjs=False, output_type='div')"
]
},
{
"cell_type": "code",
"execution_count": 37,
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"name": "Berkeley, CA",
"type": "scatter",
"uid": "03aea348-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
26.05,
25.83,
25.8,
25.71,
25.61,
25.42,
23.4,
22.41,
21.68,
21.04,
21.04,
21.16,
21.44,
21.81,
21.91,
21.76,
22.23,
21.97,
21.98,
22.01,
21.9,
21.83,
21.83,
21.51,
21.74,
21.98,
22.12,
21.76,
21.81,
21.55,
21.33,
21.43,
21.67,
21.95,
22.43,
23.04,
23.65,
24.17,
24.71,
24.81,
24.65,
24.74,
24.9,
24.98,
25.13,
25.28,
26.12,
26.73,
27.15,
27.47,
28.7,
28.92,
29.47,
29.1
]
},
{
"name": "Oakland, CA",
"type": "scatter",
"uid": "03aea6ae-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
18.06,
18.26,
18.45,
18.88,
19.15,
19.18,
18.54,
18.06,
17.62,
17.39,
17.17,
16.99,
16.93,
16.97,
17.25,
17.22,
17.31,
17.29,
17.35,
17.42,
17.5,
17.58,
17.61,
17.61,
17.68,
17.68,
17.67,
17.59,
17.86,
17.72,
17.62,
17.7,
17.85,
18,
18.17,
18.3,
18.43,
18.6,
18.75,
18.83,
19,
19.06,
19.06,
18.9,
19.01,
19.16,
19.42,
19.6,
19.78,
19.83,
20.58,
20.62,
21.15,
21
]
},
{
"name": "Emeryville, CA",
"type": "scatter",
"uid": "03aea924-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
16.03,
15.99,
16.07,
16.32,
16.11,
15.95,
15.35,
15.13,
15.12,
15.03,
14.94,
14.81,
14.58,
14.45,
14.25,
14.26,
14.33,
14.18,
14.08,
13.94,
13.98,
14.16,
14.3,
14.68,
14.72,
14.78,
14.99,
15.21,
15.69,
15.57,
15.26,
15.37,
15.61,
15.85,
16.05,
16.18,
16.16,
16.19,
16.09,
16.37,
16.57,
16.75,
16.68,
16.76,
16.98,
17.16,
17.32,
17.64,
17.66,
17.55,
18.39,
18.31,
18.86,
18.83
]
},
{
"name": "Dublin, CA",
"type": "scatter",
"uid": "03aeaaf0-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
20.25,
20.35,
20.34,
20.67,
20.91,
21.12,
20.83,
20.59,
20.41,
20.6,
20.66,
20.58,
20.34,
20.17,
20.17,
20.09,
20.01,
19.88,
19.79,
19.83,
19.93,
20.14,
20.32,
20.1,
20.21,
20.26,
20.18,
19.99,
20.14,
20.12,
20.14,
20.24,
20.45,
20.62,
20.9,
21.06,
21.15,
21.24,
21.39,
21.35,
21.3,
21.27,
21.3,
21.32,
21.39,
21.62,
21.94,
22.34,
22.55,
22.51,
23.23,
23.29,
23.94,
23.92
]
},
{
"name": "San Ramon, CA",
"type": "scatter",
"uid": "03aeac80-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
21.85,
21.79,
21.83,
21.85,
22.1,
22.03,
21.65,
21.2,
21.03,
20.86,
20.91,
21.05,
21.06,
20.91,
20.92,
20.78,
20.56,
20.36,
20.26,
20.39,
20.61,
20.88,
21.17,
21.14,
21.11,
21.15,
21.06,
21.01,
20.97,
20.78,
20.65,
20.72,
20.98,
21.25,
21.65,
21.99,
22.14,
22.27,
22.4,
22.4,
22.22,
21.93,
21.81,
21.78,
21.9,
22.14,
22.24,
22.31,
22.28,
22.64,
23,
23.37,
23.44,
23.72
]
},
{
"name": "Fremont, CA",
"type": "scatter",
"uid": "03aeae06-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
23.67,
23.46,
23.27,
23.52,
23.61,
23.73,
23.15,
22.97,
22.78,
22.82,
22.86,
22.73,
22.55,
22.53,
22.66,
22.7,
22.58,
22.29,
22.27,
22.5,
22.75,
23.01,
23.26,
23.03,
23.16,
23.25,
23.19,
22.99,
23.05,
22.87,
22.84,
23.04,
23.25,
23.44,
23.83,
24.2,
24.49,
24.73,
24.89,
24.93,
24.96,
24.97,
24.99,
25.02,
25.29,
25.51,
25.82,
26.24,
26.51,
26.62,
27.91,
28.12,
29.3,
29.44
]
}
],
"layout": {
"title": "Price to Rent Ratio All Homes"
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"dataset = get_city_data(cities_dict, 'PRRAH')\n",
"fig = plot_df(dataset, 'Price to Rent Ratio All Homes')\n",
"plotly.iplot(fig)"
]
},
{
"cell_type": "code",
"execution_count": 38,
"metadata": {},
"outputs": [],
"source": [
"# plotly.plot(fig, include_plotlyjs=False, output_type='div')"
]
},
{
"cell_type": "code",
"execution_count": 39,
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"name": "Berkeley, CA",
"type": "scatter",
"uid": "056ccef8-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2555,
2556,
2554,
2593,
2647,
2732,
2864,
3005,
3156,
3264,
3348,
3405,
3411,
3407,
3411,
3450,
3476,
3515,
3545,
3591,
3623,
3651,
3671,
3670,
3655,
3623,
3600,
3619,
3668,
3743,
3799,
3850,
3869,
3855,
3826,
3786,
3751,
3712,
3667,
3623,
3603,
3622,
3667,
3717,
3745,
3762,
3776,
3785,
3778,
3742,
3692,
3642,
3607,
3586
]
},
{
"name": "Oakland, CA",
"type": "scatter",
"uid": "056cd286-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2024,
2032,
2027,
2014,
2008,
2012,
2053,
2119,
2214,
2297,
2368,
2422,
2461,
2486,
2497,
2510,
2529,
2562,
2599,
2639,
2676,
2713,
2750,
2786,
2818,
2839,
2847,
2856,
2876,
2910,
2949,
2982,
2999,
3000,
2994,
2987,
2984,
2977,
2973,
2970,
2974,
2989,
3016,
3049,
3078,
3098,
3104,
3102,
3095,
3088,
3078,
3065,
3053,
3049
]
},
{
"name": "Emeryville, CA",
"type": "scatter",
"uid": "056cd470-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
1828,
1812,
1814,
1814,
1820,
1831,
1893,
1981,
2071,
2132,
2155,
2158,
2169,
2202,
2253,
2303,
2345,
2388,
2445,
2502,
2544,
2557,
2566,
2571,
2572,
2563,
2548,
2534,
2518,
2518,
2534,
2567,
2597,
2619,
2633,
2637,
2638,
2635,
2630,
2623,
2614,
2611,
2615,
2623,
2629,
2627,
2618,
2605,
2601,
2614,
2635,
2650,
2656,
2658
]
},
{
"name": "Dublin, CA",
"type": "scatter",
"uid": "056cd650-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2548,
2553,
2567,
2579,
2583,
2582,
2599,
2634,
2682,
2731,
2769,
2804,
2830,
2864,
2897,
2928,
2952,
2991,
3036,
3082,
3104,
3116,
3123,
3131,
3143,
3153,
3164,
3173,
3186,
3198,
3216,
3234,
3254,
3255,
3237,
3202,
3164,
3137,
3124,
3127,
3151,
3192,
3232,
3263,
3283,
3289,
3273,
3243,
3216,
3203,
3199,
3200,
3203,
3206
]
},
{
"name": "San Ramon, CA",
"type": "scatter",
"uid": "056cd8c6-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
3137,
3153,
3160,
3165,
3155,
3153,
3177,
3244,
3316,
3356,
3362,
3364,
3371,
3395,
3419,
3453,
3498,
3570,
3643,
3692,
3705,
3693,
3663,
3627,
3608,
3595,
3615,
3646,
3699,
3739,
3767,
3781,
3770,
3738,
3692,
3649,
3617,
3603,
3600,
3607,
3630,
3673,
3718,
3750,
3766,
3772,
3768,
3753,
3738,
3732,
3736,
3742,
3745,
3743
]
},
{
"name": "Fremont, CA",
"type": "scatter",
"uid": "056cdb46-99e3-11e8-8b76-0242ac130002",
"x": [
"2014-01-31",
"2014-02-28",
"2014-03-31",
"2014-04-30",
"2014-05-31",
"2014-06-30",
"2014-07-31",
"2014-08-31",
"2014-09-30",
"2014-10-31",
"2014-11-30",
"2014-12-31",
"2015-01-31",
"2015-02-28",
"2015-03-31",
"2015-04-30",
"2015-05-31",
"2015-06-30",
"2015-07-31",
"2015-08-31",
"2015-09-30",
"2015-10-31",
"2015-11-30",
"2015-12-31",
"2016-01-31",
"2016-02-29",
"2016-03-31",
"2016-04-30",
"2016-05-31",
"2016-06-30",
"2016-07-31",
"2016-08-31",
"2016-09-30",
"2016-10-31",
"2016-11-30",
"2016-12-31",
"2017-01-31",
"2017-02-28",
"2017-03-31",
"2017-04-30",
"2017-05-31",
"2017-06-30",
"2017-07-31",
"2017-08-31",
"2017-09-30",
"2017-10-31",
"2017-11-30",
"2017-12-31",
"2018-01-31",
"2018-02-28",
"2018-03-31",
"2018-04-30",
"2018-05-31",
"2018-06-30"
],
"y": [
2446,
2460,
2479,
2495,
2503,
2509,
2546,
2594,
2649,
2678,
2699,
2715,
2741,
2778,
2822,
2862,
2902,
2964,
3034,
3088,
3106,
3103,
3098,
3094,
3095,
3095,
3103,
3120,
3147,
3176,
3197,
3208,
3211,
3205,
3197,
3181,
3161,
3146,
3140,
3139,
3145,
3162,
3184,
3206,
3221,
3229,
3224,
3212,
3202,
3197,
3197,
3198,
3199,
3199
]
}
],
"layout": {
"title": "Zillow Rental Index All Homes"
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"dataset = get_city_data(cities_dict, 'ZRIAH')\n",
"fig = plot_df(dataset, 'Zillow Rental Index All Homes')\n",
"plotly.iplot(fig)"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {},
"outputs": [],
"source": [
"# plotly.plot(fig, include_plotlyjs=False, output_type='div')"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.5"
}
},
"nbformat": 4,
"nbformat_minor": 2
}