{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Requirement already satisfied: qeds in /opt/conda/lib/python3.7/site-packages (0.6.2)\n", "Requirement already satisfied: fiona in /opt/conda/lib/python3.7/site-packages (1.8.9.post2)\n", "Requirement already satisfied: geopandas in /opt/conda/lib/python3.7/site-packages (0.7.0)\n", "Collecting xgboost\n", " Using cached xgboost-1.0.2-py3-none-manylinux1_x86_64.whl (109.7 MB)\n", "Collecting gensim\n", " Using cached gensim-3.8.1-cp37-cp37m-manylinux1_x86_64.whl (24.2 MB)\n", "Requirement already satisfied: folium in /opt/conda/lib/python3.7/site-packages (0.10.1)\n", "Processing /home/jupyter/.cache/pip/wheels/3b/fb/41/e32e5312da9f440d34c4eff0d2207b46dc9332a7b931ef1e89/pyLDAvis-2.1.2-py2.py3-none-any.whl\n", "Requirement already satisfied: descartes in /opt/conda/lib/python3.7/site-packages (1.1.0)\n", "Requirement already satisfied: pandas in /opt/conda/lib/python3.7/site-packages (from qeds) (1.0.1)\n", "Requirement already satisfied: openpyxl in /opt/conda/lib/python3.7/site-packages (from qeds) (3.0.3)\n", "Requirement already satisfied: pandas-datareader in /opt/conda/lib/python3.7/site-packages (from qeds) (0.8.1)\n", "Requirement already satisfied: pyarrow in /opt/conda/lib/python3.7/site-packages (from qeds) (0.16.0)\n", "Requirement already satisfied: numpy in /opt/conda/lib/python3.7/site-packages (from qeds) (1.18.1)\n", "Requirement already satisfied: plotly in /opt/conda/lib/python3.7/site-packages (from qeds) (4.5.3)\n", "Requirement already satisfied: quandl in /opt/conda/lib/python3.7/site-packages (from qeds) (3.5.0)\n", "Requirement already satisfied: statsmodels in /opt/conda/lib/python3.7/site-packages (from qeds) (0.11.0)\n", "Requirement already satisfied: scipy in /opt/conda/lib/python3.7/site-packages (from qeds) (1.4.1)\n", "Requirement already satisfied: seaborn in /opt/conda/lib/python3.7/site-packages (from qeds) (0.9.0)\n", "Requirement already satisfied: requests in /opt/conda/lib/python3.7/site-packages (from qeds) (2.23.0)\n", "Requirement already satisfied: scikit-learn in /opt/conda/lib/python3.7/site-packages (from qeds) (0.22.1)\n", "Requirement already satisfied: matplotlib in /opt/conda/lib/python3.7/site-packages (from qeds) (3.1.3)\n", "Requirement already satisfied: quantecon in /opt/conda/lib/python3.7/site-packages (from qeds) (0.4.6)\n", "Requirement already satisfied: attrs>=17 in /opt/conda/lib/python3.7/site-packages (from fiona) (19.3.0)\n", "Requirement already satisfied: click<8,>=4.0 in /opt/conda/lib/python3.7/site-packages (from fiona) (7.0)\n", "Requirement already satisfied: cligj>=0.5 in /opt/conda/lib/python3.7/site-packages (from fiona) (0.5.0)\n", "Requirement already satisfied: click-plugins>=1.0 in /opt/conda/lib/python3.7/site-packages (from fiona) (1.1.1)\n", "Requirement already satisfied: six>=1.7 in /opt/conda/lib/python3.7/site-packages (from fiona) (1.14.0)\n", "Requirement already satisfied: munch in /opt/conda/lib/python3.7/site-packages (from fiona) (2.5.0)\n", "Requirement already satisfied: pyproj>=2.2.0 in /opt/conda/lib/python3.7/site-packages (from geopandas) (2.3.1)\n", "Requirement already satisfied: shapely in /opt/conda/lib/python3.7/site-packages (from geopandas) (1.6.4.post2)\n", "Processing /home/jupyter/.cache/pip/wheels/1f/e5/fc/7412935a7184efc8ad377e948c81b1cc99b6a02eb8dc7c918c/smart_open-1.10.0-py3-none-any.whl\n", "Requirement already satisfied: branca>=0.3.0 in /opt/conda/lib/python3.7/site-packages (from folium) (0.4.0)\n", "Requirement already satisfied: jinja2>=2.9 in /opt/conda/lib/python3.7/site-packages (from folium) (2.11.1)\n", "Processing /home/jupyter/.cache/pip/wheels/56/b0/fe/4410d17b32f1f0c3cf54cdfb2bc04d7b4b8f4ae377e2229ba0/future-0.18.2-py3-none-any.whl\n", "Requirement already satisfied: joblib>=0.8.4 in /opt/conda/lib/python3.7/site-packages (from pyLDAvis) (0.14.1)\n", "Processing /home/jupyter/.cache/pip/wheels/3c/33/97/805b282e129f60bb4e87cea622338f30b65f21eaf65219971f/funcy-1.14-py2.py3-none-any.whl\n", "Requirement already satisfied: pytest in /opt/conda/lib/python3.7/site-packages (from pyLDAvis) (5.3.5)\n", "Requirement already satisfied: numexpr in /opt/conda/lib/python3.7/site-packages (from pyLDAvis) (2.7.1)\n", "Requirement already satisfied: wheel>=0.23.0 in /opt/conda/lib/python3.7/site-packages (from pyLDAvis) (0.34.2)\n", "Requirement already satisfied: python-dateutil>=2.6.1 in /opt/conda/lib/python3.7/site-packages (from pandas->qeds) (2.8.1)\n", "Requirement already satisfied: pytz>=2017.2 in /opt/conda/lib/python3.7/site-packages (from pandas->qeds) (2019.3)\n", "Requirement already satisfied: et-xmlfile in /opt/conda/lib/python3.7/site-packages (from openpyxl->qeds) (1.0.1)\n", "Requirement already satisfied: jdcal in /opt/conda/lib/python3.7/site-packages (from openpyxl->qeds) (1.4.1)\n", "Requirement already satisfied: lxml in /opt/conda/lib/python3.7/site-packages (from pandas-datareader->qeds) (4.5.0)\n", "Requirement already satisfied: retrying>=1.3.3 in /opt/conda/lib/python3.7/site-packages (from plotly->qeds) (1.3.3)\n", "Requirement already satisfied: inflection>=0.3.1 in /opt/conda/lib/python3.7/site-packages (from quandl->qeds) (0.3.1)\n", "Requirement already satisfied: more-itertools in /opt/conda/lib/python3.7/site-packages (from quandl->qeds) (8.2.0)\n", "Requirement already satisfied: patsy>=0.5 in /opt/conda/lib/python3.7/site-packages (from statsmodels->qeds) (0.5.1)\n", "Requirement already satisfied: chardet<4,>=3.0.2 in /opt/conda/lib/python3.7/site-packages (from requests->qeds) (3.0.4)\n", "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /opt/conda/lib/python3.7/site-packages (from requests->qeds) (1.25.7)\n", "Requirement already satisfied: idna<3,>=2.5 in /opt/conda/lib/python3.7/site-packages (from requests->qeds) (2.9)\n", "Requirement already satisfied: certifi>=2017.4.17 in /opt/conda/lib/python3.7/site-packages (from requests->qeds) (2019.11.28)\n", "Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in /opt/conda/lib/python3.7/site-packages (from matplotlib->qeds) (2.4.6)\n", "Requirement already satisfied: cycler>=0.10 in /opt/conda/lib/python3.7/site-packages (from matplotlib->qeds) (0.10.0)\n", "Requirement already satisfied: kiwisolver>=1.0.1 in /opt/conda/lib/python3.7/site-packages (from matplotlib->qeds) (1.1.0)\n", "Requirement already satisfied: sympy in /opt/conda/lib/python3.7/site-packages (from quantecon->qeds) (1.5.1)\n", "Requirement already satisfied: numba>=0.38 in /opt/conda/lib/python3.7/site-packages (from quantecon->qeds) (0.48.0)\n", "Collecting boto3\n", " Downloading boto3-1.12.29-py2.py3-none-any.whl (128 kB)\n", "\u001b[K |████████████████████████████████| 128 kB 6.4 MB/s eta 0:00:01\n", "\u001b[?25hCollecting google-cloud-storage\n", " Using cached google_cloud_storage-1.26.0-py2.py3-none-any.whl (75 kB)\n", "Requirement already satisfied: MarkupSafe>=0.23 in /opt/conda/lib/python3.7/site-packages (from jinja2>=2.9->folium) (1.1.1)\n", "Requirement already satisfied: py>=1.5.0 in /opt/conda/lib/python3.7/site-packages (from pytest->pyLDAvis) (1.8.1)\n", "Requirement already satisfied: packaging in /opt/conda/lib/python3.7/site-packages (from pytest->pyLDAvis) (20.1)\n", "Requirement already satisfied: pluggy<1.0,>=0.12 in /opt/conda/lib/python3.7/site-packages (from pytest->pyLDAvis) (0.13.0)\n", "Requirement already satisfied: wcwidth in /opt/conda/lib/python3.7/site-packages (from pytest->pyLDAvis) (0.1.8)\n", "Requirement already satisfied: importlib-metadata>=0.12 in /opt/conda/lib/python3.7/site-packages (from pytest->pyLDAvis) (1.5.0)\n", "Requirement already satisfied: setuptools in /opt/conda/lib/python3.7/site-packages (from kiwisolver>=1.0.1->matplotlib->qeds) (45.2.0.post20200209)\n", "Requirement already satisfied: mpmath>=0.19 in /opt/conda/lib/python3.7/site-packages (from sympy->quantecon->qeds) (1.1.0)\n", "Requirement already satisfied: llvmlite<0.32.0,>=0.31.0dev0 in /opt/conda/lib/python3.7/site-packages (from numba>=0.38->quantecon->qeds) (0.31.0)\n", "Collecting s3transfer<0.4.0,>=0.3.0\n", " Using cached s3transfer-0.3.3-py2.py3-none-any.whl (69 kB)\n", "Collecting botocore<1.16.0,>=1.15.29\n", " Downloading botocore-1.15.29-py2.py3-none-any.whl (6.0 MB)\n", "\u001b[K |████████████████████████████████| 6.0 MB 9.4 MB/s eta 0:00:01\n", "\u001b[?25hCollecting jmespath<1.0.0,>=0.7.1\n", " Using cached jmespath-0.9.5-py2.py3-none-any.whl (24 kB)\n", "Collecting google-resumable-media<0.6dev,>=0.5.0\n", " Using cached google_resumable_media-0.5.0-py2.py3-none-any.whl (38 kB)\n", "Collecting google-auth<2.0dev,>=1.11.0\n", " Using cached google_auth-1.11.3-py2.py3-none-any.whl (76 kB)\n", "Collecting google-cloud-core<2.0dev,>=1.2.0\n", " Using cached google_cloud_core-1.3.0-py2.py3-none-any.whl (26 kB)\n", "Requirement already satisfied: zipp>=0.5 in /opt/conda/lib/python3.7/site-packages (from importlib-metadata>=0.12->pytest->pyLDAvis) (2.2.1)\n", "Collecting docutils<0.16,>=0.10\n", " Using cached docutils-0.15.2-py3-none-any.whl (547 kB)\n", "Requirement already satisfied: cachetools<5.0,>=2.0.0 in /home/jupyter/.local/lib/python3.7/site-packages (from google-auth<2.0dev,>=1.11.0->google-cloud-storage->smart-open>=1.8.1->gensim) (4.0.0)\n", "Requirement already satisfied: pyasn1-modules>=0.2.1 in /opt/conda/lib/python3.7/site-packages (from google-auth<2.0dev,>=1.11.0->google-cloud-storage->smart-open>=1.8.1->gensim) (0.2.7)\n", "Collecting rsa<4.1,>=3.1.4\n", " Using cached rsa-4.0-py2.py3-none-any.whl (38 kB)\n", "Collecting google-api-core<2.0.0dev,>=1.16.0\n", " Using cached google_api_core-1.16.0-py2.py3-none-any.whl (70 kB)\n", "Requirement already satisfied: pyasn1<0.5.0,>=0.4.6 in /opt/conda/lib/python3.7/site-packages (from pyasn1-modules>=0.2.1->google-auth<2.0dev,>=1.11.0->google-cloud-storage->smart-open>=1.8.1->gensim) (0.4.8)\n", "Processing /home/jupyter/.cache/pip/wheels/4c/a1/71/5e427276ceeff277fd76878d1b19fbf4587a2845015d86864b/googleapis_common_protos-1.51.0-py3-none-any.whl\n", "Requirement already satisfied: protobuf>=3.4.0 in /opt/conda/lib/python3.7/site-packages (from google-api-core<2.0.0dev,>=1.16.0->google-cloud-core<2.0dev,>=1.2.0->google-cloud-storage->smart-open>=1.8.1->gensim) (3.11.4)\n", "Installing collected packages: xgboost, jmespath, docutils, botocore, s3transfer, boto3, google-resumable-media, rsa, google-auth, googleapis-common-protos, google-api-core, google-cloud-core, google-cloud-storage, smart-open, gensim, future, funcy, pyLDAvis\n", "Successfully installed boto3-1.12.29 botocore-1.15.29 docutils-0.15.2 funcy-1.14 future-0.18.2 gensim-3.8.1 google-api-core-1.16.0 google-auth-1.11.3 google-cloud-core-1.3.0 google-cloud-storage-1.26.0 google-resumable-media-0.5.0 googleapis-common-protos-1.51.0 jmespath-0.9.5 pyLDAvis-2.1.2 rsa-4.0 s3transfer-0.3.3 smart-open-1.10.0 xgboost-1.0.2\n" ] } ], "source": [ "! pip install qeds fiona geopandas xgboost gensim folium pyLDAvis descartes" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import geopandas as gpd\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import numpy as np\n", "from shapely.geometry import Point\n", "import plotly.express as px\n", "\n", "%matplotlib inline\n", "# activate plot theme\n", "import qeds\n", "qeds.themes.mpl_style();" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "I start by uploading my thesis data. For my thesis, I am interested in understanding how increasing the intensity of the measure of fatalities affects support for Duterte's party, PDP Laban, in the most recent mayoral elections. Since Duterte was elected in 2016, the Philippines has become a hotbed for extra judicial killings of drug suspects. There's a lot of literature in economics about the effect of conflict on political and economic outcomes. One really important paper for my thesis is done by Luisa Blanco in 2012, who finds that increased perceptions of insecurity(resulting from exposure to violent crime) leads to distrust in the government and also increased palatability of authoritarianism(partially because of its perceived efficiency in dealing with crime). The Philippines offers an interesting context: On the one hand, the majority of the extra-judicial killings have been comitted or encouraged by the state towards mostly low income Filipinos. This could lead to Filipinos feeling less safe and distrusting the government. On the other hand, the Philippines has a long history of dealing with inefficient courts, and so the drug war could be welcomed as an efficient way of dealing with the drug trade. The purpose of my thesis is to see which effect dominates in the Philippine setting." ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | province | \n", "muni | \n", "PDPpercent | \n", "region | \n", "region_code | \n", "province_code | \n", "municipality_city_code | \n", "longitude | \n", "latitude | \n", "location | \n", "... | \n", "lon_a_5 | \n", "lat_a_5 | \n", "d_a_5 | \n", "PDPran | \n", "FPDP | \n", "pi_g | \n", "fatalities_pc | \n", "fatalities_p_c | \n", "pi_a | \n", "Coordinates | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "ABRA | \n", "BANGUED | \n", "0.101855 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140101000 | \n", "120.600914 | \n", "17.611204 | \n", "POINT(120.600912102 17.6112035614) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "341.874815 | \n", "1.0 | \n", "6.0 | \n", "-0.386866 | \n", "0.000125 | \n", "1.245770 | \n", "0.126267 | \n", "POINT (120.6009140014648 17.61120414733887) | \n", "
1 | \n", "ABRA | \n", "BOLINEY | \n", "0.000000 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140102000 | \n", "120.864738 | \n", "17.378698 | \n", "POINT(120.864738788 17.3786990212) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "313.868504 | \n", "0.0 | \n", "0.0 | \n", "-0.627300 | \n", "0.000000 | \n", "0.000000 | \n", "0.451233 | \n", "POINT (120.8647384643555 17.37869834899902) | \n", "
2 | \n", "ABRA | \n", "BUCAY | \n", "0.053107 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140103000 | \n", "120.719849 | \n", "17.523537 | \n", "POINT(120.719846281 17.523537522) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "330.886511 | \n", "1.0 | \n", "1.0 | \n", "-0.562465 | \n", "0.000058 | \n", "0.584283 | \n", "0.298767 | \n", "POINT (120.7198486328125 17.52353668212891) | \n", "
3 | \n", "ABRA | \n", "BUCLOC | \n", "0.047902 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140104000 | \n", "120.848061 | \n", "17.436989 | \n", "POINT(120.848063524 17.4369884989) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "320.394546 | \n", "1.0 | \n", "0.0 | \n", "-0.727650 | \n", "0.000000 | \n", "0.000000 | \n", "0.467700 | \n", "POINT (120.8480606079102 17.43698883056641) | \n", "
4 | \n", "ABRA | \n", "DAGUIOMAN | \n", "0.007278 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140105000 | \n", "120.952278 | \n", "17.449829 | \n", "POINT(120.952276395 17.4498298787) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "321.473186 | \n", "1.0 | \n", "0.0 | \n", "-0.056885 | \n", "0.000000 | \n", "0.000000 | \n", "0.331700 | \n", "POINT (120.952278137207 17.4498291015625) | \n", "
5 rows × 63 columns
\n", "\n", " | province | \n", "muni | \n", "PDPpercent | \n", "region | \n", "region_code | \n", "province_code | \n", "municipality_city_code | \n", "longitude | \n", "latitude | \n", "location | \n", "... | \n", "lon_a_5 | \n", "lat_a_5 | \n", "d_a_5 | \n", "PDPran | \n", "FPDP | \n", "pi_g | \n", "fatalities_pc | \n", "fatalities_p_c | \n", "pi_a | \n", "Coordinates | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "ABRA | \n", "BANGUED | \n", "0.101855 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140101000 | \n", "120.600914 | \n", "17.611204 | \n", "POINT(120.600912102 17.6112035614) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "341.874815 | \n", "1.0 | \n", "6.0 | \n", "-0.386866 | \n", "0.000125 | \n", "1.245770 | \n", "0.126267 | \n", "POINT (120.60091 17.61120) | \n", "
1 | \n", "ABRA | \n", "BOLINEY | \n", "0.000000 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140102000 | \n", "120.864738 | \n", "17.378698 | \n", "POINT(120.864738788 17.3786990212) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "313.868504 | \n", "0.0 | \n", "0.0 | \n", "-0.627300 | \n", "0.000000 | \n", "0.000000 | \n", "0.451233 | \n", "POINT (120.86474 17.37870) | \n", "
2 | \n", "ABRA | \n", "BUCAY | \n", "0.053107 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140103000 | \n", "120.719849 | \n", "17.523537 | \n", "POINT(120.719846281 17.523537522) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "330.886511 | \n", "1.0 | \n", "1.0 | \n", "-0.562465 | \n", "0.000058 | \n", "0.584283 | \n", "0.298767 | \n", "POINT (120.71985 17.52354) | \n", "
3 | \n", "ABRA | \n", "BUCLOC | \n", "0.047902 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140104000 | \n", "120.848061 | \n", "17.436989 | \n", "POINT(120.848063524 17.4369884989) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "320.394546 | \n", "1.0 | \n", "0.0 | \n", "-0.727650 | \n", "0.000000 | \n", "0.000000 | \n", "0.467700 | \n", "POINT (120.84806 17.43699) | \n", "
4 | \n", "ABRA | \n", "DAGUIOMAN | \n", "0.007278 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140105000 | \n", "120.952278 | \n", "17.449829 | \n", "POINT(120.952276395 17.4498298787) | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "321.473186 | \n", "1.0 | \n", "0.0 | \n", "-0.056885 | \n", "0.000000 | \n", "0.000000 | \n", "0.331700 | \n", "POINT (120.95228 17.44983) | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1610 | \n", "ZAMBOANGA SIBUGAY | \n", "ROSELLER LIM | \n", "0.197443 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098312000 | \n", "122.430687 | \n", "7.702022 | \n", "POINT(122.430683899 7.7020220193) | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "242.523021 | \n", "1.0 | \n", "0.0 | \n", "-0.112825 | \n", "0.000000 | \n", "0.000000 | \n", "0.489067 | \n", "POINT (122.43069 7.70202) | \n", "
1611 | \n", "ZAMBOANGA SIBUGAY | \n", "SIAY | \n", "0.260228 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098313000 | \n", "122.876854 | \n", "7.734716 | \n", "POINT(122.876851077 7.73471573608) | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "196.818101 | \n", "1.0 | \n", "0.0 | \n", "-0.042893 | \n", "0.000000 | \n", "0.000000 | \n", "0.440700 | \n", "POINT (122.87685 7.73472) | \n", "
1612 | \n", "ZAMBOANGA SIBUGAY | \n", "TALUSAN | \n", "0.178658 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098314000 | \n", "122.884216 | \n", "7.334711 | \n", "POINT(122.884218322 7.3347104573) | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "220.979871 | \n", "1.0 | \n", "0.0 | \n", "-0.158900 | \n", "0.000000 | \n", "0.000000 | \n", "0.606933 | \n", "POINT (122.88422 7.33471) | \n", "
1613 | \n", "ZAMBOANGA SIBUGAY | \n", "TITAY | \n", "0.000000 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098315000 | \n", "122.517639 | \n", "7.845210 | \n", "POINT(122.517641 7.84521002867) | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "227.549967 | \n", "0.0 | \n", "0.0 | \n", "0.017960 | \n", "0.000000 | \n", "0.000000 | \n", "0.414100 | \n", "POINT (122.51764 7.84521) | \n", "
1614 | \n", "ZAMBOANGA SIBUGAY | \n", "TUNGAWAN | \n", "0.000000 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098316000 | \n", "122.370041 | \n", "7.568430 | \n", "POINT(122.370040541 7.56843016062) | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "254.889034 | \n", "0.0 | \n", "0.0 | \n", "-0.121783 | \n", "0.000048 | \n", "0.475851 | \n", "0.559233 | \n", "POINT (122.37004 7.56843) | \n", "
1615 rows × 63 columns
\n", "\n", " | index_left | \n", "province | \n", "muni | \n", "PDPpercent | \n", "region | \n", "region_code | \n", "province_code | \n", "municipality_city_code | \n", "longitude | \n", "latitude | \n", "... | \n", "lon_a_5 | \n", "lat_a_5 | \n", "d_a_5 | \n", "PDPran | \n", "FPDP | \n", "pi_g | \n", "fatalities_pc | \n", "fatalities_p_c | \n", "pi_a | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0.0 | \n", "ABRA | \n", "BANGUED | \n", "0.101855 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140101000 | \n", "120.600914 | \n", "17.611204 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "341.874815 | \n", "1.0 | \n", "6.0 | \n", "-0.386866 | \n", "0.000125 | \n", "1.245770 | \n", "0.126267 | \n", "POLYGON ((120.61553 17.62360, 120.61870 17.623... | \n", "
1 | \n", "1.0 | \n", "ABRA | \n", "BOLINEY | \n", "0.000000 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140102000 | \n", "120.864738 | \n", "17.378698 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "313.868504 | \n", "0.0 | \n", "0.0 | \n", "-0.627300 | \n", "0.000000 | \n", "0.000000 | \n", "0.451233 | \n", "POLYGON ((120.90749 17.41933, 120.92464 17.413... | \n", "
2 | \n", "2.0 | \n", "ABRA | \n", "BUCAY | \n", "0.053107 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140103000 | \n", "120.719849 | \n", "17.523537 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "330.886511 | \n", "1.0 | \n", "1.0 | \n", "-0.562465 | \n", "0.000058 | \n", "0.584283 | \n", "0.298767 | \n", "POLYGON ((120.74548 17.57671, 120.75101 17.575... | \n", "
3 | \n", "3.0 | \n", "ABRA | \n", "BUCLOC | \n", "0.047902 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140104000 | \n", "120.848061 | \n", "17.436989 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "320.394546 | \n", "1.0 | \n", "0.0 | \n", "-0.727650 | \n", "0.000000 | \n", "0.000000 | \n", "0.467700 | \n", "POLYGON ((120.82477 17.41721, 120.78956 17.416... | \n", "
4 | \n", "4.0 | \n", "ABRA | \n", "DAGUIOMAN | \n", "0.007278 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140105000 | \n", "120.952278 | \n", "17.449829 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "321.473186 | \n", "1.0 | \n", "0.0 | \n", "-0.056885 | \n", "0.000000 | \n", "0.000000 | \n", "0.331700 | \n", "POLYGON ((120.98141 17.50534, 120.98367 17.504... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1579 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "MULTIPOLYGON (((120.23167 14.85611, 120.23222 ... | \n", "
1595 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POLYGON ((123.39980 8.44444, 123.40269 8.44411... | \n", "
1614 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POLYGON ((123.54957 8.21537, 123.54903 8.20592... | \n", "
1617 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POLYGON ((123.18555 7.84652, 123.18510 7.84630... | \n", "
1638 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "POLYGON ((122.99306 7.82587, 123.00117 7.81298... | \n", "
1701 rows × 64 columns
\n", "\n", " | index_left | \n", "province | \n", "muni | \n", "PDPpercent | \n", "region | \n", "region_code | \n", "province_code | \n", "municipality_city_code | \n", "longitude | \n", "latitude | \n", "... | \n", "lon_a_5 | \n", "lat_a_5 | \n", "d_a_5 | \n", "PDPran | \n", "FPDP | \n", "pi_g | \n", "fatalities_pc | \n", "fatalities_p_c | \n", "pi_a | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0.0 | \n", "ABRA | \n", "BANGUED | \n", "0.101855 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140101000 | \n", "120.600914 | \n", "17.611204 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "341.874815 | \n", "1.0 | \n", "6.0 | \n", "-0.386866 | \n", "0.000125 | \n", "1.245770 | \n", "0.126267 | \n", "POLYGON ((120.61553 17.62360, 120.61870 17.623... | \n", "
1 | \n", "1.0 | \n", "ABRA | \n", "BOLINEY | \n", "0.000000 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140102000 | \n", "120.864738 | \n", "17.378698 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "313.868504 | \n", "0.0 | \n", "0.0 | \n", "-0.627300 | \n", "0.000000 | \n", "0.000000 | \n", "0.451233 | \n", "POLYGON ((120.90749 17.41933, 120.92464 17.413... | \n", "
2 | \n", "2.0 | \n", "ABRA | \n", "BUCAY | \n", "0.053107 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140103000 | \n", "120.719849 | \n", "17.523537 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "330.886511 | \n", "1.0 | \n", "1.0 | \n", "-0.562465 | \n", "0.000058 | \n", "0.584283 | \n", "0.298767 | \n", "POLYGON ((120.74548 17.57671, 120.75101 17.575... | \n", "
3 | \n", "3.0 | \n", "ABRA | \n", "BUCLOC | \n", "0.047902 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140104000 | \n", "120.848061 | \n", "17.436989 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "320.394546 | \n", "1.0 | \n", "0.0 | \n", "-0.727650 | \n", "0.000000 | \n", "0.000000 | \n", "0.467700 | \n", "POLYGON ((120.82477 17.41721, 120.78956 17.416... | \n", "
4 | \n", "4.0 | \n", "ABRA | \n", "DAGUIOMAN | \n", "0.007278 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140105000 | \n", "120.952278 | \n", "17.449829 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "321.473186 | \n", "1.0 | \n", "0.0 | \n", "-0.056885 | \n", "0.000000 | \n", "0.000000 | \n", "0.331700 | \n", "POLYGON ((120.98141 17.50534, 120.98367 17.504... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1647 | \n", "1610.0 | \n", "ZAMBOANGA SIBUGAY | \n", "ROSELLER LIM | \n", "0.197443 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098312000 | \n", "122.430687 | \n", "7.702022 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "242.523021 | \n", "1.0 | \n", "0.0 | \n", "-0.112825 | \n", "0.000000 | \n", "0.000000 | \n", "0.489067 | \n", "MULTIPOLYGON (((122.54519 7.68240, 122.54472 7... | \n", "
1648 | \n", "1611.0 | \n", "ZAMBOANGA SIBUGAY | \n", "SIAY | \n", "0.260228 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098313000 | \n", "122.876854 | \n", "7.734716 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "196.818101 | \n", "1.0 | \n", "0.0 | \n", "-0.042893 | \n", "0.000000 | \n", "0.000000 | \n", "0.440700 | \n", "MULTIPOLYGON (((122.80055 7.73917, 122.80083 7... | \n", "
1649 | \n", "1612.0 | \n", "ZAMBOANGA SIBUGAY | \n", "TALUSAN | \n", "0.178658 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098314000 | \n", "122.884216 | \n", "7.334711 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "220.979871 | \n", "1.0 | \n", "0.0 | \n", "-0.158900 | \n", "0.000000 | \n", "0.000000 | \n", "0.606933 | \n", "MULTIPOLYGON (((122.91917 7.34111, 122.91861 7... | \n", "
1650 | \n", "1613.0 | \n", "ZAMBOANGA SIBUGAY | \n", "TITAY | \n", "0.000000 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098315000 | \n", "122.517639 | \n", "7.845210 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "227.549967 | \n", "0.0 | \n", "0.0 | \n", "0.017960 | \n", "0.000000 | \n", "0.000000 | \n", "0.414100 | \n", "POLYGON ((122.68086 7.88831, 122.68091 7.88682... | \n", "
1651 | \n", "1614.0 | \n", "ZAMBOANGA SIBUGAY | \n", "TUNGAWAN | \n", "0.000000 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098316000 | \n", "122.370041 | \n", "7.568430 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "254.889034 | \n", "0.0 | \n", "0.0 | \n", "-0.121783 | \n", "0.000048 | \n", "0.475851 | \n", "0.559233 | \n", "MULTIPOLYGON (((122.41989 7.49679, 122.42042 7... | \n", "
1613 rows × 64 columns
\n", "\n", " | index_left | \n", "province | \n", "muni | \n", "PDPpercent | \n", "region | \n", "region_code | \n", "province_code | \n", "municipality_city_code | \n", "longitude | \n", "latitude | \n", "... | \n", "lon_a_5 | \n", "lat_a_5 | \n", "d_a_5 | \n", "PDPran | \n", "FPDP | \n", "pi_g | \n", "fatalities_pc | \n", "fatalities_p_c | \n", "pi_a | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0.0 | \n", "ABRA | \n", "BANGUED | \n", "0.101855 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140101000 | \n", "120.600914 | \n", "17.611204 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "341.874815 | \n", "1.0 | \n", "6.0 | \n", "-0.386866 | \n", "0.000125 | \n", "1.245770 | \n", "0.126267 | \n", "POLYGON ((120.61553 17.62360, 120.61870 17.623... | \n", "
1 | \n", "1.0 | \n", "ABRA | \n", "BOLINEY | \n", "0.000000 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140102000 | \n", "120.864738 | \n", "17.378698 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "313.868504 | \n", "0.0 | \n", "0.0 | \n", "-0.627300 | \n", "0.000000 | \n", "0.000000 | \n", "0.451233 | \n", "POLYGON ((120.90749 17.41933, 120.92464 17.413... | \n", "
2 | \n", "2.0 | \n", "ABRA | \n", "BUCAY | \n", "0.053107 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140103000 | \n", "120.719849 | \n", "17.523537 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "330.886511 | \n", "1.0 | \n", "1.0 | \n", "-0.562465 | \n", "0.000058 | \n", "0.584283 | \n", "0.298767 | \n", "POLYGON ((120.74548 17.57671, 120.75101 17.575... | \n", "
3 | \n", "3.0 | \n", "ABRA | \n", "BUCLOC | \n", "0.047902 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140104000 | \n", "120.848061 | \n", "17.436989 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "320.394546 | \n", "1.0 | \n", "0.0 | \n", "-0.727650 | \n", "0.000000 | \n", "0.000000 | \n", "0.467700 | \n", "POLYGON ((120.82477 17.41721, 120.78956 17.416... | \n", "
4 | \n", "4.0 | \n", "ABRA | \n", "DAGUIOMAN | \n", "0.007278 | \n", "Cordillera Administrative Region (CAR) | \n", "PH140000000 | \n", "PH140100000 | \n", "PH140105000 | \n", "120.952278 | \n", "17.449829 | \n", "... | \n", "120.991997 | \n", "14.545 | \n", "321.473186 | \n", "1.0 | \n", "0.0 | \n", "-0.056885 | \n", "0.000000 | \n", "0.000000 | \n", "0.331700 | \n", "POLYGON ((120.98141 17.50534, 120.98367 17.504... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1647 | \n", "1610.0 | \n", "ZAMBOANGA SIBUGAY | \n", "ROSELLER LIM | \n", "0.197443 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098312000 | \n", "122.430687 | \n", "7.702022 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "242.523021 | \n", "1.0 | \n", "0.0 | \n", "-0.112825 | \n", "0.000000 | \n", "0.000000 | \n", "0.489067 | \n", "MULTIPOLYGON (((122.54519 7.68240, 122.54472 7... | \n", "
1648 | \n", "1611.0 | \n", "ZAMBOANGA SIBUGAY | \n", "SIAY | \n", "0.260228 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098313000 | \n", "122.876854 | \n", "7.734716 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "196.818101 | \n", "1.0 | \n", "0.0 | \n", "-0.042893 | \n", "0.000000 | \n", "0.000000 | \n", "0.440700 | \n", "MULTIPOLYGON (((122.80055 7.73917, 122.80083 7... | \n", "
1649 | \n", "1612.0 | \n", "ZAMBOANGA SIBUGAY | \n", "TALUSAN | \n", "0.178658 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098314000 | \n", "122.884216 | \n", "7.334711 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "220.979871 | \n", "1.0 | \n", "0.0 | \n", "-0.158900 | \n", "0.000000 | \n", "0.000000 | \n", "0.606933 | \n", "MULTIPOLYGON (((122.91917 7.34111, 122.91861 7... | \n", "
1650 | \n", "1613.0 | \n", "ZAMBOANGA SIBUGAY | \n", "TITAY | \n", "0.000000 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098315000 | \n", "122.517639 | \n", "7.845210 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "227.549967 | \n", "0.0 | \n", "0.0 | \n", "0.017960 | \n", "0.000000 | \n", "0.000000 | \n", "0.414100 | \n", "POLYGON ((122.68086 7.88831, 122.68091 7.88682... | \n", "
1651 | \n", "1614.0 | \n", "ZAMBOANGA SIBUGAY | \n", "TUNGAWAN | \n", "0.000000 | \n", "Region IX (Zamboanga Peninsula) | \n", "PH090000000 | \n", "PH098300000 | \n", "PH098316000 | \n", "122.370041 | \n", "7.568430 | \n", "... | \n", "124.442001 | \n", "8.592 | \n", "254.889034 | \n", "0.0 | \n", "0.0 | \n", "-0.121783 | \n", "0.000048 | \n", "0.475851 | \n", "0.559233 | \n", "MULTIPOLYGON (((122.41989 7.49679, 122.42042 7... | \n", "
1613 rows × 64 columns
\n", "