{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import os\n",
"import pandas as pd\n",
"import numpy as np\n",
"import seaborn as sns\n",
"import matplotlib.pyplot as plt\n",
"from IPython.core.display import display, HTML\n",
"%matplotlib inline"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
""
],
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"pd.options.display.max_columns = None\n",
"display(HTML(\"\"))\n",
"pd.set_option('display.float_format',lambda x: '%.4f' % x)\n",
"plt.rcParams['figure.figsize'] = 10,10"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"import folium\n",
"from folium import plugins\n",
"from folium.plugins import MarkerCluster\n",
"from folium.plugins import FastMarkerCluster"
]
},
{
"cell_type": "code",
"execution_count": 48,
"metadata": {},
"outputs": [],
"source": [
"import json\n",
"import requests, zipfile, io\n",
"import shapefile\n",
"from json import dumps"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"https://fred.stlouisfed.org/series/USNUM\n",
"\n",
"https://www.stlouisfed.org/publications/regional-economist/second-quarter-2017/banking-deserts-become-a-concern-as-branches-dry-up\n",
"\n",
"**Banking Deserts**\n",
"http://libertystreeteconomics.newyorkfed.org/2016/03/banking-deserts-branch-closings-and-soft-information.html"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"CSV_PATH = os.path.join('data', 'econ', 'US_num_of_banks.csv')\n",
"banks = pd.read_csv(CSV_PATH, index_col='DATE', parse_dates=['DATE'])"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" USNUM | \n",
"
\n",
" \n",
" | DATE | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" | 1984-01-01 | \n",
" 14400 | \n",
"
\n",
" \n",
" | 1984-04-01 | \n",
" 14383 | \n",
"
\n",
" \n",
" | 1984-07-01 | \n",
" 14389 | \n",
"
\n",
" \n",
" | 1984-10-01 | \n",
" 14391 | \n",
"
\n",
" \n",
" | 1985-01-01 | \n",
" 14381 | \n",
"
\n",
" \n",
"
\n",
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Year | \n",
" geoid2000 | \n",
" tract_latitude | \n",
" tract_longitude | \n",
" banking_desert | \n",
"
\n",
" \n",
" \n",
" \n",
" | 0 | \n",
" 2014 | \n",
" 1001020900 | \n",
" 32.6444 | \n",
" -86.5012 | \n",
" 1 | \n",
"
\n",
" \n",
" | 1 | \n",
" 2014 | \n",
" 1001021000 | \n",
" 32.6313 | \n",
" -86.7568 | \n",
" 1 | \n",
"
\n",
" \n",
" | 2 | \n",
" 2014 | \n",
" 1001021100 | \n",
" 32.4502 | \n",
" -86.7156 | \n",
" 1 | \n",
"
\n",
" \n",
" | 3 | \n",
" 2014 | \n",
" 1003010100 | \n",
" 31.1225 | \n",
" -87.7664 | \n",
" 1 | \n",
"
\n",
" \n",
" | 4 | \n",
" 2014 | \n",
" 1003010400 | \n",
" 30.7260 | \n",
" -87.6184 | \n",
" 1 | \n",
"
\n",
" \n",
"
\n",
"