rf_ridge_lasso.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#importing libraries\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "attack = pd.read_csv('globalterrorismdb.csv',encoding='ISO-8859-1', low_memory=False)\n",
    "attack.rename(columns={'iyear':'Year','imonth':'Month','iday':'Day','country_txt':'Country','region_txt':'Region','attacktype1_txt':'AttackType','target1':'Target','nkill':'Killed','nwound':'Wounded','summary':'Summary','gname':'Group','targtype1_txt':'Target_type','weaptype1_txt':'Weapon_type','motive':'Motive'},inplace=True)\n",
    "attack = attack[['Year','Month','Day','Country','Region','city','latitude','longitude','AttackType','Killed','Wounded','Target','Summary','Group','Target_type','Weapon_type','Motive']]\n",
    "attack['casualities'] = attack['Killed'] + attack['Wounded']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Year             0\n",
       "Month            0\n",
       "Day              0\n",
       "Country          0\n",
       "Region           0\n",
       "city           403\n",
       "latitude         0\n",
       "longitude        0\n",
       "AttackType       0\n",
       "Killed           0\n",
       "Wounded          0\n",
       "Target         287\n",
       "Group            0\n",
       "Target_type      0\n",
       "Weapon_type      0\n",
       "casualities      0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Selecting top 15 countries\n",
    "attack_most_freq = attack[(attack.Country == 'Iraq') | (attack.Country == 'Pakistan') | (attack.Country == 'Afghanistan') | (attack.Country == 'India') | (attack.Country == 'Colombia') | (attack.Country == 'Philippines') | (attack.Country == 'Peru') | (attack.Country == 'El Salvador') | (attack.Country == 'United Kingdom') | (attack.Country == 'Turkey') | (attack.Country == 'Somalia') | (attack.Country == 'Nigeria') | (attack.Country == 'Thailand') | (attack.Country == 'Yemen') | (attack.Country == 'Spain')]\n",
    "attack_most_freq = attack_most_freq.drop([\"Summary\",\"Motive\"],axis = 1)\n",
    "#attack_most_freq.mean()\n",
    "attack_most_freq = attack_most_freq.fillna(attack_most_freq.mean())\n",
    "#attack_most_freq = attack_most_freq.dropna()\n",
    "attack_most_freq.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Year           0\n",
       "Month          0\n",
       "Day            0\n",
       "Country        0\n",
       "Region         0\n",
       "city           0\n",
       "latitude       0\n",
       "longitude      0\n",
       "AttackType     0\n",
       "Killed         0\n",
       "Wounded        0\n",
       "Target         0\n",
       "Group          0\n",
       "Target_type    0\n",
       "Weapon_type    0\n",
       "casualities    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "attack_most_freq = attack_most_freq.dropna()\n",
    "attack_most_freq.isnull().sum()\n",
    "#attack_most_freq.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Day</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>city</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>AttackType</th>\n",
       "      <th>Killed</th>\n",
       "      <th>Wounded</th>\n",
       "      <th>Target</th>\n",
       "      <th>Group</th>\n",
       "      <th>Target_type</th>\n",
       "      <th>Weapon_type</th>\n",
       "      <th>casualities</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>15.478598</td>\n",
       "      <td>120.599741</td>\n",
       "      <td>Assassination</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Employee</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Journalists &amp; Media</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Quezon City</td>\n",
       "      <td>14.674280</td>\n",
       "      <td>121.057495</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>JUSMAG HQ</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Government (Diplomatic)</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Bamban</td>\n",
       "      <td>15.675051</td>\n",
       "      <td>120.331618</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Seaman</td>\n",
       "      <td>New People's Army (NPA)</td>\n",
       "      <td>Military</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1970</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Manila</td>\n",
       "      <td>14.596051</td>\n",
       "      <td>120.978666</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>U.S. Embassy</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Government (Diplomatic)</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>1970</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>24.269852</td>\n",
       "      <td>35.529608</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Garrigues, permanent spanish delegaet to Unesco</td>\n",
       "      <td>1st of May Group</td>\n",
       "      <td>Government (General)</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>1970</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Angeles</td>\n",
       "      <td>15.153002</td>\n",
       "      <td>120.591942</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>officer</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Military</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>1970</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Mabalacat City</td>\n",
       "      <td>15.185916</td>\n",
       "      <td>120.541870</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Airmen</td>\n",
       "      <td>New People's Army (NPA)</td>\n",
       "      <td>Military</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>1970</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Cauayan</td>\n",
       "      <td>24.269852</td>\n",
       "      <td>35.529608</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Philippines Airlines Aircraft</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Airports &amp; Aircraft</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>36.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>1970</td>\n",
       "      <td>4</td>\n",
       "      <td>25</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Istanbul</td>\n",
       "      <td>41.106178</td>\n",
       "      <td>28.689863</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>EL AL Office</td>\n",
       "      <td>Palestinians</td>\n",
       "      <td>Airports &amp; Aircraft</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Roxas</td>\n",
       "      <td>11.586558</td>\n",
       "      <td>122.753716</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>Philipines Airliner Flight</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Airports &amp; Aircraft</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>13.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Quezon City</td>\n",
       "      <td>14.674280</td>\n",
       "      <td>121.057495</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>USIA Cultural Center</td>\n",
       "      <td>Kabataang Makabayan (KM)</td>\n",
       "      <td>Government (Diplomatic)</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>26</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Londonderry</td>\n",
       "      <td>55.011562</td>\n",
       "      <td>-7.312045</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>3 IRA members, 2 civilians</td>\n",
       "      <td>Irish Republican Army (IRA)</td>\n",
       "      <td>Terrorists/Non-State Militia</td>\n",
       "      <td>Incendiary</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Londonderry</td>\n",
       "      <td>55.011562</td>\n",
       "      <td>-7.312045</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>William Kincaid, 28, Daniel Loughins, 32 and A...</td>\n",
       "      <td>Irish Republican Army (IRA)</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Robert Neill, 38, protestant</td>\n",
       "      <td>Irish Republican Army (IRA)</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>James McCurrie, 34, Protestant</td>\n",
       "      <td>Irish Republican Army (IRA)</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>St. Matthew</td>\n",
       "      <td>Ulster Volunteer Force (UVF)</td>\n",
       "      <td>Religious Figures/Institutions</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>1970</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>South America</td>\n",
       "      <td>Manizales</td>\n",
       "      <td>5.059097</td>\n",
       "      <td>-75.505960</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Fernand Londono, former cabinet minister</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Government (General)</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>1970</td>\n",
       "      <td>7</td>\n",
       "      <td>28</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Pamplona</td>\n",
       "      <td>42.815372</td>\n",
       "      <td>-1.653616</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Publication EL Pansamiento Navarro</td>\n",
       "      <td>GAC</td>\n",
       "      <td>Journalists &amp; Media</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>1970</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Crossmaglen</td>\n",
       "      <td>54.077313</td>\n",
       "      <td>-6.608787</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Samuel Donaldson, 23 and Robert Millar, 26, Pr...</td>\n",
       "      <td>Irish Republican Army (IRA)</td>\n",
       "      <td>Police</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>1970</td>\n",
       "      <td>8</td>\n",
       "      <td>31</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Ankara</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>TUSLOG Detachment 30, USAF</td>\n",
       "      <td>Turkish People's Liberation Army</td>\n",
       "      <td>Military</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>1970</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Michael Kane, 35, Catholic, IRA member</td>\n",
       "      <td>Irish Republican Army (IRA)</td>\n",
       "      <td>Terrorists/Non-State Militia</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>1970</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>London</td>\n",
       "      <td>51.504387</td>\n",
       "      <td>-0.140041</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>employees, Egyptian emb london</td>\n",
       "      <td>Jewish Defense League (JDL)</td>\n",
       "      <td>Government (Diplomatic)</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>1970</td>\n",
       "      <td>9</td>\n",
       "      <td>30</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>David Murray, 49, Protestant</td>\n",
       "      <td>Protestant extremists</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Izmir</td>\n",
       "      <td>38.395649</td>\n",
       "      <td>27.135641</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>U.S. Air Force Commissary</td>\n",
       "      <td>Turkish People's Liberation Front (TPLF)(THKP-C)</td>\n",
       "      <td>Military</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Ankara</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>USIS Office</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Government (Diplomatic)</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Ankara</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>building, U.S. Element Cento</td>\n",
       "      <td>Turkish People's Liberation Army</td>\n",
       "      <td>Business</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Ankara</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>vehicle, USAF member</td>\n",
       "      <td>Turkish People's Liberation Army</td>\n",
       "      <td>Military</td>\n",
       "      <td>Incendiary</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>27</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Ankara</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>U.S. Military Annex Exchange</td>\n",
       "      <td>Turkish People's Liberation Army</td>\n",
       "      <td>Military</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>576</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>London</td>\n",
       "      <td>51.504387</td>\n",
       "      <td>-0.140041</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Heathrow Airport</td>\n",
       "      <td>1st of May Group</td>\n",
       "      <td>Airports &amp; Aircraft</td>\n",
       "      <td>Incendiary</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>1970</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Karachi</td>\n",
       "      <td>24.891115</td>\n",
       "      <td>67.143311</td>\n",
       "      <td>Assassination</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>Deputy Foreign Minister: Zygfryd Wolniak</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Government (Diplomatic)</td>\n",
       "      <td>Vehicle (not to include vehicle-borne explosiv...</td>\n",
       "      <td>24.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181654</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>Mafa</td>\n",
       "      <td>11.923636</td>\n",
       "      <td>13.599695</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Internally Displaced Persons (IDPs)</td>\n",
       "      <td>Boko Haram</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181655</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>Kanamma</td>\n",
       "      <td>13.099690</td>\n",
       "      <td>12.107900</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Base</td>\n",
       "      <td>Boko Haram</td>\n",
       "      <td>Military</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181656</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>Maiwa</td>\n",
       "      <td>11.883003</td>\n",
       "      <td>13.455697</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Loggers</td>\n",
       "      <td>Boko Haram</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181661</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Talacheru</td>\n",
       "      <td>17.001086</td>\n",
       "      <td>81.807490</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Masjid</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Religious Figures/Institutions</td>\n",
       "      <td>Incendiary</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181662</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Tarragona</td>\n",
       "      <td>7.042777</td>\n",
       "      <td>126.449221</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>Soldiers</td>\n",
       "      <td>New People's Army (NPA)</td>\n",
       "      <td>Military</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181663</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Koothuparamba</td>\n",
       "      <td>11.831902</td>\n",
       "      <td>75.565432</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Koothuparamba Police Station</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Police</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181664</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>Belfast</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>Civilians</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181665</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Toylanka</td>\n",
       "      <td>18.802725</td>\n",
       "      <td>81.497666</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Road Construction Site</td>\n",
       "      <td>Communist Party of India - Maoist (CPI-Maoist)</td>\n",
       "      <td>Business</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181666</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>Konduga district</td>\n",
       "      <td>11.492144</td>\n",
       "      <td>12.969724</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>Convoy</td>\n",
       "      <td>Boko Haram</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>5.292694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181668</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Shurjah</td>\n",
       "      <td>35.560376</td>\n",
       "      <td>44.524705</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Patrol</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Military</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181669</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Kirkuk</td>\n",
       "      <td>35.452110</td>\n",
       "      <td>44.375465</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>Cafe</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Business</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181670</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Hawd al-Waqf</td>\n",
       "      <td>33.816111</td>\n",
       "      <td>44.783524</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Station</td>\n",
       "      <td>Islamic State of Iraq and the Levant (ISIL)</td>\n",
       "      <td>Police</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181671</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Farhatiyah</td>\n",
       "      <td>34.031331</td>\n",
       "      <td>44.070106</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>Civilians</td>\n",
       "      <td>Islamic State of Iraq and the Levant (ISIL)</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>13.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181672</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Lethapora</td>\n",
       "      <td>33.966527</td>\n",
       "      <td>74.964225</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>Camp</td>\n",
       "      <td>Jaish-e-Mohammad (JeM)</td>\n",
       "      <td>Police</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>11.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181673</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Jalalabad</td>\n",
       "      <td>34.417122</td>\n",
       "      <td>70.449593</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>Funeral Procession of Former District Governor</td>\n",
       "      <td>Khorasan Chapter of the Islamic State</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>32.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181674</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Baaj</td>\n",
       "      <td>36.045059</td>\n",
       "      <td>41.716717</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Troops</td>\n",
       "      <td>Islamic State of Iraq and the Levant (ISIL)</td>\n",
       "      <td>Military</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181675</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>Mogadishu</td>\n",
       "      <td>2.059819</td>\n",
       "      <td>45.326115</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>Burundian Convoy</td>\n",
       "      <td>Al-Shabaab</td>\n",
       "      <td>Military</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181676</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Mohammad Agha district</td>\n",
       "      <td>34.217806</td>\n",
       "      <td>69.109316</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Vehicle</td>\n",
       "      <td>Taliban</td>\n",
       "      <td>Police</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181677</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Limpogo</td>\n",
       "      <td>6.983953</td>\n",
       "      <td>124.420664</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Town</td>\n",
       "      <td>Bangsamoro Islamic Freedom Movement (BIFM)</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181678</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Pikit district</td>\n",
       "      <td>7.053143</td>\n",
       "      <td>124.619270</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Store</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Business</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181679</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>Muqdadiyah</td>\n",
       "      <td>33.953167</td>\n",
       "      <td>44.921906</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Post</td>\n",
       "      <td>Islamic State of Iraq and the Levant (ISIL)</td>\n",
       "      <td>Military</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>13.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181680</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>Wajid</td>\n",
       "      <td>3.810951</td>\n",
       "      <td>43.246506</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Ethiopian Base</td>\n",
       "      <td>Al-Shabaab</td>\n",
       "      <td>Military</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181681</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Shariff Aguak</td>\n",
       "      <td>6.862806</td>\n",
       "      <td>124.443649</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>Patrol</td>\n",
       "      <td>Bangsamoro Islamic Freedom Movement (BIFM)</td>\n",
       "      <td>Police</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181683</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Kohistan district</td>\n",
       "      <td>35.315467</td>\n",
       "      <td>64.815508</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>House of Member</td>\n",
       "      <td>Taliban</td>\n",
       "      <td>Terrorists/Non-State Militia</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181684</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Hungrum</td>\n",
       "      <td>25.180162</td>\n",
       "      <td>93.015788</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Personal Security Officer of Council Member Ih...</td>\n",
       "      <td>Zeliangrong United Front</td>\n",
       "      <td>Government (General)</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181685</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Maymana</td>\n",
       "      <td>35.921051</td>\n",
       "      <td>64.774544</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>Jewelry Shop</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Business</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181686</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>Ceelka Geelow</td>\n",
       "      <td>2.359673</td>\n",
       "      <td>45.385034</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>Checkpoint</td>\n",
       "      <td>Al-Shabaab</td>\n",
       "      <td>Military</td>\n",
       "      <td>Firearms</td>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181688</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Kubentog</td>\n",
       "      <td>6.900742</td>\n",
       "      <td>124.437908</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Houses</td>\n",
       "      <td>Bangsamoro Islamic Freedom Movement (BIFM)</td>\n",
       "      <td>Private Citizens &amp; Property</td>\n",
       "      <td>Incendiary</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181689</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>Imphal</td>\n",
       "      <td>24.798346</td>\n",
       "      <td>93.940430</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Office</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Government (General)</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181690</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>Cotabato City</td>\n",
       "      <td>7.209594</td>\n",
       "      <td>124.241966</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Explosives</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>117659 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Month  Day         Country                      Region  \\\n",
       "2       1970      1    0     Philippines              Southeast Asia   \n",
       "26      1970      1   21     Philippines              Southeast Asia   \n",
       "39      1970      1   31     Philippines              Southeast Asia   \n",
       "96      1970      3    0     Philippines              Southeast Asia   \n",
       "103     1970      3    3           Spain              Western Europe   \n",
       "150     1970      3   24     Philippines              Southeast Asia   \n",
       "169     1970      4    2     Philippines              Southeast Asia   \n",
       "210     1970      4   21     Philippines              Southeast Asia   \n",
       "226     1970      4   25          Turkey  Middle East & North Africa   \n",
       "317     1970      6    2     Philippines              Southeast Asia   \n",
       "323     1970      6    6     Philippines              Southeast Asia   \n",
       "364     1970      6   26  United Kingdom              Western Europe   \n",
       "365     1970      6   27  United Kingdom              Western Europe   \n",
       "366     1970      6   27  United Kingdom              Western Europe   \n",
       "367     1970      6   27  United Kingdom              Western Europe   \n",
       "368     1970      6   27  United Kingdom              Western Europe   \n",
       "405     1970      7   10        Colombia               South America   \n",
       "437     1970      7   28           Spain              Western Europe   \n",
       "458     1970      8   11  United Kingdom              Western Europe   \n",
       "486     1970      8   31          Turkey  Middle East & North Africa   \n",
       "497     1970      9    4  United Kingdom              Western Europe   \n",
       "514     1970      9   12  United Kingdom              Western Europe   \n",
       "528     1970      9   30  United Kingdom              Western Europe   \n",
       "531     1970     10    2          Turkey  Middle East & North Africa   \n",
       "534     1970     10    3          Turkey  Middle East & North Africa   \n",
       "535     1970     10    3          Turkey  Middle East & North Africa   \n",
       "539     1970     10    6          Turkey  Middle East & North Africa   \n",
       "575     1970     10   27          Turkey  Middle East & North Africa   \n",
       "576     1970     10   27  United Kingdom              Western Europe   \n",
       "585     1970     11    1        Pakistan                  South Asia   \n",
       "...      ...    ...  ...             ...                         ...   \n",
       "181654  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181655  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181656  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181661  2017     12   28           India                  South Asia   \n",
       "181662  2017     12   30     Philippines              Southeast Asia   \n",
       "181663  2017     12   30           India                  South Asia   \n",
       "181664  2017     12   30  United Kingdom              Western Europe   \n",
       "181665  2017     12   30           India                  South Asia   \n",
       "181666  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181668  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181669  2017     12   30            Iraq  Middle East & North Africa   \n",
       "181670  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181671  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181672  2017     12   31           India                  South Asia   \n",
       "181673  2017     12   31     Afghanistan                  South Asia   \n",
       "181674  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181675  2017     12   31         Somalia          Sub-Saharan Africa   \n",
       "181676  2017     12   31     Afghanistan                  South Asia   \n",
       "181677  2017     12   31     Philippines              Southeast Asia   \n",
       "181678  2017     12   30     Philippines              Southeast Asia   \n",
       "181679  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181680  2017     12   31         Somalia          Sub-Saharan Africa   \n",
       "181681  2017     12   31     Philippines              Southeast Asia   \n",
       "181683  2017     12   31     Afghanistan                  South Asia   \n",
       "181684  2017     12   31           India                  South Asia   \n",
       "181685  2017     12   31     Afghanistan                  South Asia   \n",
       "181686  2017     12   31         Somalia          Sub-Saharan Africa   \n",
       "181688  2017     12   31     Philippines              Southeast Asia   \n",
       "181689  2017     12   31           India                  South Asia   \n",
       "181690  2017     12   31     Philippines              Southeast Asia   \n",
       "\n",
       "                          city   latitude   longitude  \\\n",
       "2                      Unknown  15.478598  120.599741   \n",
       "26                 Quezon City  14.674280  121.057495   \n",
       "39                      Bamban  15.675051  120.331618   \n",
       "96                      Manila  14.596051  120.978666   \n",
       "103                    Unknown  24.269852   35.529608   \n",
       "150                    Angeles  15.153002  120.591942   \n",
       "169             Mabalacat City  15.185916  120.541870   \n",
       "210                    Cauayan  24.269852   35.529608   \n",
       "226                   Istanbul  41.106178   28.689863   \n",
       "317                      Roxas  11.586558  122.753716   \n",
       "323                Quezon City  14.674280  121.057495   \n",
       "364                Londonderry  55.011562   -7.312045   \n",
       "365                Londonderry  55.011562   -7.312045   \n",
       "366                    Belfast  54.607712   -5.956210   \n",
       "367                    Belfast  54.607712   -5.956210   \n",
       "368                    Belfast  54.607712   -5.956210   \n",
       "405                  Manizales   5.059097  -75.505960   \n",
       "437                   Pamplona  42.815372   -1.653616   \n",
       "458                Crossmaglen  54.077313   -6.608787   \n",
       "486                     Ankara  39.930771   32.767540   \n",
       "497                    Belfast  54.607712   -5.956210   \n",
       "514                     London  51.504387   -0.140041   \n",
       "528                    Belfast  54.607712   -5.956210   \n",
       "531                      Izmir  38.395649   27.135641   \n",
       "534                     Ankara  39.930771   32.767540   \n",
       "535                     Ankara  39.930771   32.767540   \n",
       "539                     Ankara  39.930771   32.767540   \n",
       "575                     Ankara  39.930771   32.767540   \n",
       "576                     London  51.504387   -0.140041   \n",
       "585                    Karachi  24.891115   67.143311   \n",
       "...                        ...        ...         ...   \n",
       "181654                    Mafa  11.923636   13.599695   \n",
       "181655                 Kanamma  13.099690   12.107900   \n",
       "181656                   Maiwa  11.883003   13.455697   \n",
       "181661               Talacheru  17.001086   81.807490   \n",
       "181662               Tarragona   7.042777  126.449221   \n",
       "181663           Koothuparamba  11.831902   75.565432   \n",
       "181664                 Belfast  54.607712   -5.956210   \n",
       "181665                Toylanka  18.802725   81.497666   \n",
       "181666        Konduga district  11.492144   12.969724   \n",
       "181668                 Shurjah  35.560376   44.524705   \n",
       "181669                  Kirkuk  35.452110   44.375465   \n",
       "181670            Hawd al-Waqf  33.816111   44.783524   \n",
       "181671              Farhatiyah  34.031331   44.070106   \n",
       "181672               Lethapora  33.966527   74.964225   \n",
       "181673               Jalalabad  34.417122   70.449593   \n",
       "181674                    Baaj  36.045059   41.716717   \n",
       "181675               Mogadishu   2.059819   45.326115   \n",
       "181676  Mohammad Agha district  34.217806   69.109316   \n",
       "181677                 Limpogo   6.983953  124.420664   \n",
       "181678          Pikit district   7.053143  124.619270   \n",
       "181679              Muqdadiyah  33.953167   44.921906   \n",
       "181680                   Wajid   3.810951   43.246506   \n",
       "181681           Shariff Aguak   6.862806  124.443649   \n",
       "181683       Kohistan district  35.315467   64.815508   \n",
       "181684                 Hungrum  25.180162   93.015788   \n",
       "181685                 Maymana  35.921051   64.774544   \n",
       "181686           Ceelka Geelow   2.359673   45.385034   \n",
       "181688                Kubentog   6.900742  124.437908   \n",
       "181689                  Imphal  24.798346   93.940430   \n",
       "181690           Cotabato City   7.209594  124.241966   \n",
       "\n",
       "                            AttackType     Killed    Wounded  \\\n",
       "2                        Assassination   1.000000   0.000000   \n",
       "26                   Bombing/Explosion   0.000000   0.000000   \n",
       "39                             Unknown   0.000000   1.000000   \n",
       "96                   Bombing/Explosion   0.000000   0.000000   \n",
       "103        Hostage Taking (Kidnapping)   0.000000   0.000000   \n",
       "150                            Unknown   1.000000   0.000000   \n",
       "169                            Unknown   2.000000   0.000000   \n",
       "210                  Bombing/Explosion  36.000000   0.000000   \n",
       "226                  Bombing/Explosion   0.000000   0.000000   \n",
       "317                  Bombing/Explosion   1.000000  12.000000   \n",
       "323                  Bombing/Explosion   0.000000   0.000000   \n",
       "364                      Armed Assault   5.000000   3.153911   \n",
       "365                      Armed Assault   3.000000   3.153911   \n",
       "366                      Armed Assault   1.000000   3.153911   \n",
       "367                      Armed Assault   1.000000   3.153911   \n",
       "368                      Armed Assault   3.000000   1.000000   \n",
       "405        Hostage Taking (Kidnapping)   2.372507   3.153911   \n",
       "437                  Bombing/Explosion   2.372507   3.153911   \n",
       "458                  Bombing/Explosion   2.000000   3.153911   \n",
       "486                  Bombing/Explosion   0.000000   0.000000   \n",
       "497                  Bombing/Explosion   1.000000   3.153911   \n",
       "514        Hostage Taking (Kidnapping)   0.000000   0.000000   \n",
       "528                      Armed Assault   1.000000   3.153911   \n",
       "531                  Bombing/Explosion   0.000000   0.000000   \n",
       "534                  Bombing/Explosion   2.372507   3.153911   \n",
       "535                  Bombing/Explosion   0.000000   0.000000   \n",
       "539                      Armed Assault   0.000000   0.000000   \n",
       "575                  Bombing/Explosion   0.000000   0.000000   \n",
       "576     Facility/Infrastructure Attack   0.000000   0.000000   \n",
       "585                      Assassination   4.000000  20.000000   \n",
       "...                                ...        ...        ...   \n",
       "181654                         Unknown  50.000000   3.153911   \n",
       "181655                   Armed Assault   5.000000   3.153911   \n",
       "181656                   Armed Assault  25.000000   3.153911   \n",
       "181661  Facility/Infrastructure Attack   1.000000   0.000000   \n",
       "181662               Bombing/Explosion   2.372507   2.000000   \n",
       "181663               Bombing/Explosion   0.000000   0.000000   \n",
       "181664                   Armed Assault   0.000000   2.000000   \n",
       "181665  Facility/Infrastructure Attack   0.000000   0.000000   \n",
       "181666  Facility/Infrastructure Attack   2.372507   3.153911   \n",
       "181668               Bombing/Explosion   0.000000   0.000000   \n",
       "181669               Bombing/Explosion   0.000000   5.000000   \n",
       "181670                         Unknown   1.000000   0.000000   \n",
       "181671               Bombing/Explosion   4.000000   9.000000   \n",
       "181672                   Armed Assault   8.000000   3.000000   \n",
       "181673               Bombing/Explosion  18.000000  14.000000   \n",
       "181674                         Unknown   5.000000   0.000000   \n",
       "181675               Bombing/Explosion   2.000000   3.000000   \n",
       "181676               Bombing/Explosion   5.000000   0.000000   \n",
       "181677  Facility/Infrastructure Attack   0.000000   0.000000   \n",
       "181678               Bombing/Explosion   1.000000   1.000000   \n",
       "181679                   Armed Assault  13.000000   0.000000   \n",
       "181680               Bombing/Explosion   0.000000   0.000000   \n",
       "181681               Bombing/Explosion   1.000000   5.000000   \n",
       "181683                   Armed Assault   6.000000   0.000000   \n",
       "181684     Hostage Taking (Kidnapping)   0.000000   0.000000   \n",
       "181685               Bombing/Explosion   0.000000   4.000000   \n",
       "181686                   Armed Assault   1.000000   2.000000   \n",
       "181688  Facility/Infrastructure Attack   0.000000   0.000000   \n",
       "181689               Bombing/Explosion   0.000000   0.000000   \n",
       "181690               Bombing/Explosion   0.000000   0.000000   \n",
       "\n",
       "                                                   Target  \\\n",
       "2                                                Employee   \n",
       "26                                              JUSMAG HQ   \n",
       "39                                                 Seaman   \n",
       "96                                           U.S. Embassy   \n",
       "103       Garrigues, permanent spanish delegaet to Unesco   \n",
       "150                                               officer   \n",
       "169                                                Airmen   \n",
       "210                         Philippines Airlines Aircraft   \n",
       "226                                          EL AL Office   \n",
       "317                            Philipines Airliner Flight   \n",
       "323                                  USIA Cultural Center   \n",
       "364                            3 IRA members, 2 civilians   \n",
       "365     William Kincaid, 28, Daniel Loughins, 32 and A...   \n",
       "366                          Robert Neill, 38, protestant   \n",
       "367                        James McCurrie, 34, Protestant   \n",
       "368                                           St. Matthew   \n",
       "405              Fernand Londono, former cabinet minister   \n",
       "437                    Publication EL Pansamiento Navarro   \n",
       "458     Samuel Donaldson, 23 and Robert Millar, 26, Pr...   \n",
       "486                            TUSLOG Detachment 30, USAF   \n",
       "497                Michael Kane, 35, Catholic, IRA member   \n",
       "514                        employees, Egyptian emb london   \n",
       "528                          David Murray, 49, Protestant   \n",
       "531                             U.S. Air Force Commissary   \n",
       "534                                           USIS Office   \n",
       "535                          building, U.S. Element Cento   \n",
       "539                                  vehicle, USAF member   \n",
       "575                          U.S. Military Annex Exchange   \n",
       "576                                      Heathrow Airport   \n",
       "585              Deputy Foreign Minister: Zygfryd Wolniak   \n",
       "...                                                   ...   \n",
       "181654                Internally Displaced Persons (IDPs)   \n",
       "181655                                               Base   \n",
       "181656                                            Loggers   \n",
       "181661                                             Masjid   \n",
       "181662                                           Soldiers   \n",
       "181663                       Koothuparamba Police Station   \n",
       "181664                                          Civilians   \n",
       "181665                             Road Construction Site   \n",
       "181666                                             Convoy   \n",
       "181668                                             Patrol   \n",
       "181669                                               Cafe   \n",
       "181670                                            Station   \n",
       "181671                                          Civilians   \n",
       "181672                                               Camp   \n",
       "181673     Funeral Procession of Former District Governor   \n",
       "181674                                             Troops   \n",
       "181675                                   Burundian Convoy   \n",
       "181676                                            Vehicle   \n",
       "181677                                               Town   \n",
       "181678                                              Store   \n",
       "181679                                               Post   \n",
       "181680                                     Ethiopian Base   \n",
       "181681                                             Patrol   \n",
       "181683                                    House of Member   \n",
       "181684  Personal Security Officer of Council Member Ih...   \n",
       "181685                                       Jewelry Shop   \n",
       "181686                                         Checkpoint   \n",
       "181688                                             Houses   \n",
       "181689                                             Office   \n",
       "181690                                            Unknown   \n",
       "\n",
       "                                                   Group  \\\n",
       "2                                                Unknown   \n",
       "26                                               Unknown   \n",
       "39                               New People's Army (NPA)   \n",
       "96                                               Unknown   \n",
       "103                                     1st of May Group   \n",
       "150                                              Unknown   \n",
       "169                              New People's Army (NPA)   \n",
       "210                                              Unknown   \n",
       "226                                         Palestinians   \n",
       "317                                              Unknown   \n",
       "323                             Kabataang Makabayan (KM)   \n",
       "364                          Irish Republican Army (IRA)   \n",
       "365                          Irish Republican Army (IRA)   \n",
       "366                          Irish Republican Army (IRA)   \n",
       "367                          Irish Republican Army (IRA)   \n",
       "368                         Ulster Volunteer Force (UVF)   \n",
       "405                                              Unknown   \n",
       "437                                                  GAC   \n",
       "458                          Irish Republican Army (IRA)   \n",
       "486                     Turkish People's Liberation Army   \n",
       "497                          Irish Republican Army (IRA)   \n",
       "514                          Jewish Defense League (JDL)   \n",
       "528                                Protestant extremists   \n",
       "531     Turkish People's Liberation Front (TPLF)(THKP-C)   \n",
       "534                                              Unknown   \n",
       "535                     Turkish People's Liberation Army   \n",
       "539                     Turkish People's Liberation Army   \n",
       "575                     Turkish People's Liberation Army   \n",
       "576                                     1st of May Group   \n",
       "585                                              Unknown   \n",
       "...                                                  ...   \n",
       "181654                                        Boko Haram   \n",
       "181655                                        Boko Haram   \n",
       "181656                                        Boko Haram   \n",
       "181661                                           Unknown   \n",
       "181662                           New People's Army (NPA)   \n",
       "181663                                           Unknown   \n",
       "181664                                           Unknown   \n",
       "181665    Communist Party of India - Maoist (CPI-Maoist)   \n",
       "181666                                        Boko Haram   \n",
       "181668                                           Unknown   \n",
       "181669                                           Unknown   \n",
       "181670       Islamic State of Iraq and the Levant (ISIL)   \n",
       "181671       Islamic State of Iraq and the Levant (ISIL)   \n",
       "181672                            Jaish-e-Mohammad (JeM)   \n",
       "181673             Khorasan Chapter of the Islamic State   \n",
       "181674       Islamic State of Iraq and the Levant (ISIL)   \n",
       "181675                                        Al-Shabaab   \n",
       "181676                                           Taliban   \n",
       "181677        Bangsamoro Islamic Freedom Movement (BIFM)   \n",
       "181678                                           Unknown   \n",
       "181679       Islamic State of Iraq and the Levant (ISIL)   \n",
       "181680                                        Al-Shabaab   \n",
       "181681        Bangsamoro Islamic Freedom Movement (BIFM)   \n",
       "181683                                           Taliban   \n",
       "181684                          Zeliangrong United Front   \n",
       "181685                                           Unknown   \n",
       "181686                                        Al-Shabaab   \n",
       "181688        Bangsamoro Islamic Freedom Movement (BIFM)   \n",
       "181689                                           Unknown   \n",
       "181690                                           Unknown   \n",
       "\n",
       "                           Target_type  \\\n",
       "2                  Journalists & Media   \n",
       "26             Government (Diplomatic)   \n",
       "39                            Military   \n",
       "96             Government (Diplomatic)   \n",
       "103               Government (General)   \n",
       "150                           Military   \n",
       "169                           Military   \n",
       "210                Airports & Aircraft   \n",
       "226                Airports & Aircraft   \n",
       "317                Airports & Aircraft   \n",
       "323            Government (Diplomatic)   \n",
       "364       Terrorists/Non-State Militia   \n",
       "365        Private Citizens & Property   \n",
       "366        Private Citizens & Property   \n",
       "367        Private Citizens & Property   \n",
       "368     Religious Figures/Institutions   \n",
       "405               Government (General)   \n",
       "437                Journalists & Media   \n",
       "458                             Police   \n",
       "486                           Military   \n",
       "497       Terrorists/Non-State Militia   \n",
       "514            Government (Diplomatic)   \n",
       "528        Private Citizens & Property   \n",
       "531                           Military   \n",
       "534            Government (Diplomatic)   \n",
       "535                           Business   \n",
       "539                           Military   \n",
       "575                           Military   \n",
       "576                Airports & Aircraft   \n",
       "585            Government (Diplomatic)   \n",
       "...                                ...   \n",
       "181654     Private Citizens & Property   \n",
       "181655                        Military   \n",
       "181656     Private Citizens & Property   \n",
       "181661  Religious Figures/Institutions   \n",
       "181662                        Military   \n",
       "181663                          Police   \n",
       "181664     Private Citizens & Property   \n",
       "181665                        Business   \n",
       "181666     Private Citizens & Property   \n",
       "181668                        Military   \n",
       "181669                        Business   \n",
       "181670                          Police   \n",
       "181671     Private Citizens & Property   \n",
       "181672                          Police   \n",
       "181673     Private Citizens & Property   \n",
       "181674                        Military   \n",
       "181675                        Military   \n",
       "181676                          Police   \n",
       "181677     Private Citizens & Property   \n",
       "181678                        Business   \n",
       "181679                        Military   \n",
       "181680                        Military   \n",
       "181681                          Police   \n",
       "181683    Terrorists/Non-State Militia   \n",
       "181684            Government (General)   \n",
       "181685                        Business   \n",
       "181686                        Military   \n",
       "181688     Private Citizens & Property   \n",
       "181689            Government (General)   \n",
       "181690                         Unknown   \n",
       "\n",
       "                                              Weapon_type  casualities  \n",
       "2                                                 Unknown     1.000000  \n",
       "26                                             Explosives     0.000000  \n",
       "39                                                Unknown     1.000000  \n",
       "96                                             Explosives     0.000000  \n",
       "103                                               Unknown     0.000000  \n",
       "150                                               Unknown     1.000000  \n",
       "169                                               Unknown     2.000000  \n",
       "210                                            Explosives    36.000000  \n",
       "226                                            Explosives     0.000000  \n",
       "317                                            Explosives    13.000000  \n",
       "323                                            Explosives     0.000000  \n",
       "364                                            Incendiary     5.292694  \n",
       "365                                              Firearms     5.292694  \n",
       "366                                              Firearms     5.292694  \n",
       "367                                              Firearms     5.292694  \n",
       "368                                              Firearms     4.000000  \n",
       "405                                               Unknown     5.292694  \n",
       "437                                            Explosives     5.292694  \n",
       "458                                            Explosives     5.292694  \n",
       "486                                            Explosives     0.000000  \n",
       "497                                            Explosives     5.292694  \n",
       "514                                               Unknown     0.000000  \n",
       "528                                              Firearms     5.292694  \n",
       "531                                            Explosives     0.000000  \n",
       "534                                            Explosives     5.292694  \n",
       "535                                            Explosives     0.000000  \n",
       "539                                            Incendiary     0.000000  \n",
       "575                                            Explosives     0.000000  \n",
       "576                                            Incendiary     0.000000  \n",
       "585     Vehicle (not to include vehicle-borne explosiv...    24.000000  \n",
       "...                                                   ...          ...  \n",
       "181654                                            Unknown     5.292694  \n",
       "181655                                           Firearms     5.292694  \n",
       "181656                                           Firearms     5.292694  \n",
       "181661                                         Incendiary     1.000000  \n",
       "181662                                         Explosives     5.292694  \n",
       "181663                                         Explosives     0.000000  \n",
       "181664                                           Firearms     2.000000  \n",
       "181665                                           Firearms     0.000000  \n",
       "181666                                            Unknown     5.292694  \n",
       "181668                                         Explosives     0.000000  \n",
       "181669                                         Explosives     5.000000  \n",
       "181670                                            Unknown     1.000000  \n",
       "181671                                         Explosives    13.000000  \n",
       "181672                                         Explosives    11.000000  \n",
       "181673                                         Explosives    32.000000  \n",
       "181674                                            Unknown     5.000000  \n",
       "181675                                         Explosives     5.000000  \n",
       "181676                                         Explosives     5.000000  \n",
       "181677                                           Firearms     0.000000  \n",
       "181678                                         Explosives     2.000000  \n",
       "181679                                           Firearms    13.000000  \n",
       "181680                                         Explosives     0.000000  \n",
       "181681                                         Explosives     6.000000  \n",
       "181683                                           Firearms     6.000000  \n",
       "181684                                           Firearms     0.000000  \n",
       "181685                                         Explosives     4.000000  \n",
       "181686                                           Firearms     3.000000  \n",
       "181688                                         Incendiary     0.000000  \n",
       "181689                                         Explosives     0.000000  \n",
       "181690                                         Explosives     0.000000  \n",
       "\n",
       "[117659 rows x 16 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "attack_most_freq"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(117659, 42)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "attack_most_freq_country = pd.get_dummies(attack_most_freq['Country'])\n",
    "df_new_1 = pd.concat([attack_most_freq, attack_most_freq_country], axis=1)\n",
    "# Create a set of dummy variables from the attack_type variable\n",
    "attack_most_freq_attackType = pd.get_dummies(attack_most_freq['AttackType'])\n",
    "#df_new_2 = pd.concat([attack_most_freq_country, attack_most_freq_attackType], axis=1)\n",
    "df_new_2 = df_new_1.join(attack_most_freq_attackType)\n",
    "attack_most_freq_Region = pd.get_dummies(attack_most_freq['Region'])\n",
    "df_new_3 = df_new_2.join(attack_most_freq_Region)\n",
    "df_new_3 = df_new_3.drop([\"city\",\"Target\",\"Group\"],axis = 1)\n",
    "df_new_4 = df_new_3.drop([\"Target_type\",\"Weapon_type\"],axis = 1)\n",
    "df_new_4.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Day</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>AttackType</th>\n",
       "      <th>Killed</th>\n",
       "      <th>Wounded</th>\n",
       "      <th>...</th>\n",
       "      <th>Hostage Taking (Kidnapping)</th>\n",
       "      <th>Unarmed Assault</th>\n",
       "      <th>Unknown</th>\n",
       "      <th>Central America &amp; Caribbean</th>\n",
       "      <th>Middle East &amp; North Africa</th>\n",
       "      <th>South America</th>\n",
       "      <th>South Asia</th>\n",
       "      <th>Southeast Asia</th>\n",
       "      <th>Sub-Saharan Africa</th>\n",
       "      <th>Western Europe</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>15.478598</td>\n",
       "      <td>120.599741</td>\n",
       "      <td>Assassination</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>14.674280</td>\n",
       "      <td>121.057495</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>15.675051</td>\n",
       "      <td>120.331618</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1970</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>14.596051</td>\n",
       "      <td>120.978666</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>1970</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>24.269852</td>\n",
       "      <td>35.529608</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>1970</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>15.153002</td>\n",
       "      <td>120.591942</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>1970</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>15.185916</td>\n",
       "      <td>120.541870</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>1970</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>24.269852</td>\n",
       "      <td>35.529608</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>1970</td>\n",
       "      <td>4</td>\n",
       "      <td>25</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>41.106178</td>\n",
       "      <td>28.689863</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>11.586558</td>\n",
       "      <td>122.753716</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>14.674280</td>\n",
       "      <td>121.057495</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>26</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>55.011562</td>\n",
       "      <td>-7.312045</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>55.011562</td>\n",
       "      <td>-7.312045</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>1970</td>\n",
       "      <td>6</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>1970</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>South America</td>\n",
       "      <td>5.059097</td>\n",
       "      <td>-75.505960</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>1970</td>\n",
       "      <td>7</td>\n",
       "      <td>28</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>42.815372</td>\n",
       "      <td>-1.653616</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>1970</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>54.077313</td>\n",
       "      <td>-6.608787</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>1970</td>\n",
       "      <td>8</td>\n",
       "      <td>31</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>1970</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>1970</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>51.504387</td>\n",
       "      <td>-0.140041</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>1970</td>\n",
       "      <td>9</td>\n",
       "      <td>30</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>38.395649</td>\n",
       "      <td>27.135641</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>27</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>39.930771</td>\n",
       "      <td>32.767540</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>576</th>\n",
       "      <td>1970</td>\n",
       "      <td>10</td>\n",
       "      <td>27</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>51.504387</td>\n",
       "      <td>-0.140041</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>1970</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>24.891115</td>\n",
       "      <td>67.143311</td>\n",
       "      <td>Assassination</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181654</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>11.923636</td>\n",
       "      <td>13.599695</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181655</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>13.099690</td>\n",
       "      <td>12.107900</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181656</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>11.883003</td>\n",
       "      <td>13.455697</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181661</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>17.001086</td>\n",
       "      <td>81.807490</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181662</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>7.042777</td>\n",
       "      <td>126.449221</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181663</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>11.831902</td>\n",
       "      <td>75.565432</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181664</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Western Europe</td>\n",
       "      <td>54.607712</td>\n",
       "      <td>-5.956210</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181665</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>18.802725</td>\n",
       "      <td>81.497666</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181666</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>11.492144</td>\n",
       "      <td>12.969724</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>2.372507</td>\n",
       "      <td>3.153911</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181668</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>35.560376</td>\n",
       "      <td>44.524705</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181669</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>35.452110</td>\n",
       "      <td>44.375465</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181670</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>33.816111</td>\n",
       "      <td>44.783524</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181671</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>34.031331</td>\n",
       "      <td>44.070106</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181672</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>33.966527</td>\n",
       "      <td>74.964225</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181673</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>34.417122</td>\n",
       "      <td>70.449593</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181674</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>36.045059</td>\n",
       "      <td>41.716717</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181675</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>2.059819</td>\n",
       "      <td>45.326115</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181676</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>34.217806</td>\n",
       "      <td>69.109316</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181677</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>6.983953</td>\n",
       "      <td>124.420664</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181678</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>7.053143</td>\n",
       "      <td>124.619270</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181679</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Iraq</td>\n",
       "      <td>Middle East &amp; North Africa</td>\n",
       "      <td>33.953167</td>\n",
       "      <td>44.921906</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181680</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>3.810951</td>\n",
       "      <td>43.246506</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181681</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>6.862806</td>\n",
       "      <td>124.443649</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181683</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>35.315467</td>\n",
       "      <td>64.815508</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181684</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>25.180162</td>\n",
       "      <td>93.015788</td>\n",
       "      <td>Hostage Taking (Kidnapping)</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181685</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>35.921051</td>\n",
       "      <td>64.774544</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181686</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>Sub-Saharan Africa</td>\n",
       "      <td>2.359673</td>\n",
       "      <td>45.385034</td>\n",
       "      <td>Armed Assault</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181688</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>6.900742</td>\n",
       "      <td>124.437908</td>\n",
       "      <td>Facility/Infrastructure Attack</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181689</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>India</td>\n",
       "      <td>South Asia</td>\n",
       "      <td>24.798346</td>\n",
       "      <td>93.940430</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181690</th>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>31</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>7.209594</td>\n",
       "      <td>124.241966</td>\n",
       "      <td>Bombing/Explosion</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>117659 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Year  Month  Day         Country                      Region  \\\n",
       "2       1970      1    0     Philippines              Southeast Asia   \n",
       "26      1970      1   21     Philippines              Southeast Asia   \n",
       "39      1970      1   31     Philippines              Southeast Asia   \n",
       "96      1970      3    0     Philippines              Southeast Asia   \n",
       "103     1970      3    3           Spain              Western Europe   \n",
       "150     1970      3   24     Philippines              Southeast Asia   \n",
       "169     1970      4    2     Philippines              Southeast Asia   \n",
       "210     1970      4   21     Philippines              Southeast Asia   \n",
       "226     1970      4   25          Turkey  Middle East & North Africa   \n",
       "317     1970      6    2     Philippines              Southeast Asia   \n",
       "323     1970      6    6     Philippines              Southeast Asia   \n",
       "364     1970      6   26  United Kingdom              Western Europe   \n",
       "365     1970      6   27  United Kingdom              Western Europe   \n",
       "366     1970      6   27  United Kingdom              Western Europe   \n",
       "367     1970      6   27  United Kingdom              Western Europe   \n",
       "368     1970      6   27  United Kingdom              Western Europe   \n",
       "405     1970      7   10        Colombia               South America   \n",
       "437     1970      7   28           Spain              Western Europe   \n",
       "458     1970      8   11  United Kingdom              Western Europe   \n",
       "486     1970      8   31          Turkey  Middle East & North Africa   \n",
       "497     1970      9    4  United Kingdom              Western Europe   \n",
       "514     1970      9   12  United Kingdom              Western Europe   \n",
       "528     1970      9   30  United Kingdom              Western Europe   \n",
       "531     1970     10    2          Turkey  Middle East & North Africa   \n",
       "534     1970     10    3          Turkey  Middle East & North Africa   \n",
       "535     1970     10    3          Turkey  Middle East & North Africa   \n",
       "539     1970     10    6          Turkey  Middle East & North Africa   \n",
       "575     1970     10   27          Turkey  Middle East & North Africa   \n",
       "576     1970     10   27  United Kingdom              Western Europe   \n",
       "585     1970     11    1        Pakistan                  South Asia   \n",
       "...      ...    ...  ...             ...                         ...   \n",
       "181654  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181655  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181656  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181661  2017     12   28           India                  South Asia   \n",
       "181662  2017     12   30     Philippines              Southeast Asia   \n",
       "181663  2017     12   30           India                  South Asia   \n",
       "181664  2017     12   30  United Kingdom              Western Europe   \n",
       "181665  2017     12   30           India                  South Asia   \n",
       "181666  2017     12   30         Nigeria          Sub-Saharan Africa   \n",
       "181668  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181669  2017     12   30            Iraq  Middle East & North Africa   \n",
       "181670  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181671  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181672  2017     12   31           India                  South Asia   \n",
       "181673  2017     12   31     Afghanistan                  South Asia   \n",
       "181674  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181675  2017     12   31         Somalia          Sub-Saharan Africa   \n",
       "181676  2017     12   31     Afghanistan                  South Asia   \n",
       "181677  2017     12   31     Philippines              Southeast Asia   \n",
       "181678  2017     12   30     Philippines              Southeast Asia   \n",
       "181679  2017     12   31            Iraq  Middle East & North Africa   \n",
       "181680  2017     12   31         Somalia          Sub-Saharan Africa   \n",
       "181681  2017     12   31     Philippines              Southeast Asia   \n",
       "181683  2017     12   31     Afghanistan                  South Asia   \n",
       "181684  2017     12   31           India                  South Asia   \n",
       "181685  2017     12   31     Afghanistan                  South Asia   \n",
       "181686  2017     12   31         Somalia          Sub-Saharan Africa   \n",
       "181688  2017     12   31     Philippines              Southeast Asia   \n",
       "181689  2017     12   31           India                  South Asia   \n",
       "181690  2017     12   31     Philippines              Southeast Asia   \n",
       "\n",
       "         latitude   longitude                      AttackType     Killed  \\\n",
       "2       15.478598  120.599741                   Assassination   1.000000   \n",
       "26      14.674280  121.057495               Bombing/Explosion   0.000000   \n",
       "39      15.675051  120.331618                         Unknown   0.000000   \n",
       "96      14.596051  120.978666               Bombing/Explosion   0.000000   \n",
       "103     24.269852   35.529608     Hostage Taking (Kidnapping)   0.000000   \n",
       "150     15.153002  120.591942                         Unknown   1.000000   \n",
       "169     15.185916  120.541870                         Unknown   2.000000   \n",
       "210     24.269852   35.529608               Bombing/Explosion  36.000000   \n",
       "226     41.106178   28.689863               Bombing/Explosion   0.000000   \n",
       "317     11.586558  122.753716               Bombing/Explosion   1.000000   \n",
       "323     14.674280  121.057495               Bombing/Explosion   0.000000   \n",
       "364     55.011562   -7.312045                   Armed Assault   5.000000   \n",
       "365     55.011562   -7.312045                   Armed Assault   3.000000   \n",
       "366     54.607712   -5.956210                   Armed Assault   1.000000   \n",
       "367     54.607712   -5.956210                   Armed Assault   1.000000   \n",
       "368     54.607712   -5.956210                   Armed Assault   3.000000   \n",
       "405      5.059097  -75.505960     Hostage Taking (Kidnapping)   2.372507   \n",
       "437     42.815372   -1.653616               Bombing/Explosion   2.372507   \n",
       "458     54.077313   -6.608787               Bombing/Explosion   2.000000   \n",
       "486     39.930771   32.767540               Bombing/Explosion   0.000000   \n",
       "497     54.607712   -5.956210               Bombing/Explosion   1.000000   \n",
       "514     51.504387   -0.140041     Hostage Taking (Kidnapping)   0.000000   \n",
       "528     54.607712   -5.956210                   Armed Assault   1.000000   \n",
       "531     38.395649   27.135641               Bombing/Explosion   0.000000   \n",
       "534     39.930771   32.767540               Bombing/Explosion   2.372507   \n",
       "535     39.930771   32.767540               Bombing/Explosion   0.000000   \n",
       "539     39.930771   32.767540                   Armed Assault   0.000000   \n",
       "575     39.930771   32.767540               Bombing/Explosion   0.000000   \n",
       "576     51.504387   -0.140041  Facility/Infrastructure Attack   0.000000   \n",
       "585     24.891115   67.143311                   Assassination   4.000000   \n",
       "...           ...         ...                             ...        ...   \n",
       "181654  11.923636   13.599695                         Unknown  50.000000   \n",
       "181655  13.099690   12.107900                   Armed Assault   5.000000   \n",
       "181656  11.883003   13.455697                   Armed Assault  25.000000   \n",
       "181661  17.001086   81.807490  Facility/Infrastructure Attack   1.000000   \n",
       "181662   7.042777  126.449221               Bombing/Explosion   2.372507   \n",
       "181663  11.831902   75.565432               Bombing/Explosion   0.000000   \n",
       "181664  54.607712   -5.956210                   Armed Assault   0.000000   \n",
       "181665  18.802725   81.497666  Facility/Infrastructure Attack   0.000000   \n",
       "181666  11.492144   12.969724  Facility/Infrastructure Attack   2.372507   \n",
       "181668  35.560376   44.524705               Bombing/Explosion   0.000000   \n",
       "181669  35.452110   44.375465               Bombing/Explosion   0.000000   \n",
       "181670  33.816111   44.783524                         Unknown   1.000000   \n",
       "181671  34.031331   44.070106               Bombing/Explosion   4.000000   \n",
       "181672  33.966527   74.964225                   Armed Assault   8.000000   \n",
       "181673  34.417122   70.449593               Bombing/Explosion  18.000000   \n",
       "181674  36.045059   41.716717                         Unknown   5.000000   \n",
       "181675   2.059819   45.326115               Bombing/Explosion   2.000000   \n",
       "181676  34.217806   69.109316               Bombing/Explosion   5.000000   \n",
       "181677   6.983953  124.420664  Facility/Infrastructure Attack   0.000000   \n",
       "181678   7.053143  124.619270               Bombing/Explosion   1.000000   \n",
       "181679  33.953167   44.921906                   Armed Assault  13.000000   \n",
       "181680   3.810951   43.246506               Bombing/Explosion   0.000000   \n",
       "181681   6.862806  124.443649               Bombing/Explosion   1.000000   \n",
       "181683  35.315467   64.815508                   Armed Assault   6.000000   \n",
       "181684  25.180162   93.015788     Hostage Taking (Kidnapping)   0.000000   \n",
       "181685  35.921051   64.774544               Bombing/Explosion   0.000000   \n",
       "181686   2.359673   45.385034                   Armed Assault   1.000000   \n",
       "181688   6.900742  124.437908  Facility/Infrastructure Attack   0.000000   \n",
       "181689  24.798346   93.940430               Bombing/Explosion   0.000000   \n",
       "181690   7.209594  124.241966               Bombing/Explosion   0.000000   \n",
       "\n",
       "          Wounded  ...  Hostage Taking (Kidnapping)  Unarmed Assault  Unknown  \\\n",
       "2        0.000000  ...                            0                0        0   \n",
       "26       0.000000  ...                            0                0        0   \n",
       "39       1.000000  ...                            0                0        1   \n",
       "96       0.000000  ...                            0                0        0   \n",
       "103      0.000000  ...                            1                0        0   \n",
       "150      0.000000  ...                            0                0        1   \n",
       "169      0.000000  ...                            0                0        1   \n",
       "210      0.000000  ...                            0                0        0   \n",
       "226      0.000000  ...                            0                0        0   \n",
       "317     12.000000  ...                            0                0        0   \n",
       "323      0.000000  ...                            0                0        0   \n",
       "364      3.153911  ...                            0                0        0   \n",
       "365      3.153911  ...                            0                0        0   \n",
       "366      3.153911  ...                            0                0        0   \n",
       "367      3.153911  ...                            0                0        0   \n",
       "368      1.000000  ...                            0                0        0   \n",
       "405      3.153911  ...                            1                0        0   \n",
       "437      3.153911  ...                            0                0        0   \n",
       "458      3.153911  ...                            0                0        0   \n",
       "486      0.000000  ...                            0                0        0   \n",
       "497      3.153911  ...                            0                0        0   \n",
       "514      0.000000  ...                            1                0        0   \n",
       "528      3.153911  ...                            0                0        0   \n",
       "531      0.000000  ...                            0                0        0   \n",
       "534      3.153911  ...                            0                0        0   \n",
       "535      0.000000  ...                            0                0        0   \n",
       "539      0.000000  ...                            0                0        0   \n",
       "575      0.000000  ...                            0                0        0   \n",
       "576      0.000000  ...                            0                0        0   \n",
       "585     20.000000  ...                            0                0        0   \n",
       "...           ...  ...                          ...              ...      ...   \n",
       "181654   3.153911  ...                            0                0        1   \n",
       "181655   3.153911  ...                            0                0        0   \n",
       "181656   3.153911  ...                            0                0        0   \n",
       "181661   0.000000  ...                            0                0        0   \n",
       "181662   2.000000  ...                            0                0        0   \n",
       "181663   0.000000  ...                            0                0        0   \n",
       "181664   2.000000  ...                            0                0        0   \n",
       "181665   0.000000  ...                            0                0        0   \n",
       "181666   3.153911  ...                            0                0        0   \n",
       "181668   0.000000  ...                            0                0        0   \n",
       "181669   5.000000  ...                            0                0        0   \n",
       "181670   0.000000  ...                            0                0        1   \n",
       "181671   9.000000  ...                            0                0        0   \n",
       "181672   3.000000  ...                            0                0        0   \n",
       "181673  14.000000  ...                            0                0        0   \n",
       "181674   0.000000  ...                            0                0        1   \n",
       "181675   3.000000  ...                            0                0        0   \n",
       "181676   0.000000  ...                            0                0        0   \n",
       "181677   0.000000  ...                            0                0        0   \n",
       "181678   1.000000  ...                            0                0        0   \n",
       "181679   0.000000  ...                            0                0        0   \n",
       "181680   0.000000  ...                            0                0        0   \n",
       "181681   5.000000  ...                            0                0        0   \n",
       "181683   0.000000  ...                            0                0        0   \n",
       "181684   0.000000  ...                            1                0        0   \n",
       "181685   4.000000  ...                            0                0        0   \n",
       "181686   2.000000  ...                            0                0        0   \n",
       "181688   0.000000  ...                            0                0        0   \n",
       "181689   0.000000  ...                            0                0        0   \n",
       "181690   0.000000  ...                            0                0        0   \n",
       "\n",
       "        Central America & Caribbean  Middle East & North Africa  \\\n",
       "2                                 0                           0   \n",
       "26                                0                           0   \n",
       "39                                0                           0   \n",
       "96                                0                           0   \n",
       "103                               0                           0   \n",
       "150                               0                           0   \n",
       "169                               0                           0   \n",
       "210                               0                           0   \n",
       "226                               0                           1   \n",
       "317                               0                           0   \n",
       "323                               0                           0   \n",
       "364                               0                           0   \n",
       "365                               0                           0   \n",
       "366                               0                           0   \n",
       "367                               0                           0   \n",
       "368                               0                           0   \n",
       "405                               0                           0   \n",
       "437                               0                           0   \n",
       "458                               0                           0   \n",
       "486                               0                           1   \n",
       "497                               0                           0   \n",
       "514                               0                           0   \n",
       "528                               0                           0   \n",
       "531                               0                           1   \n",
       "534                               0                           1   \n",
       "535                               0                           1   \n",
       "539                               0                           1   \n",
       "575                               0                           1   \n",
       "576                               0                           0   \n",
       "585                               0                           0   \n",
       "...                             ...                         ...   \n",
       "181654                            0                           0   \n",
       "181655                            0                           0   \n",
       "181656                            0                           0   \n",
       "181661                            0                           0   \n",
       "181662                            0                           0   \n",
       "181663                            0                           0   \n",
       "181664                            0                           0   \n",
       "181665                            0                           0   \n",
       "181666                            0                           0   \n",
       "181668                            0                           1   \n",
       "181669                            0                           1   \n",
       "181670                            0                           1   \n",
       "181671                            0                           1   \n",
       "181672                            0                           0   \n",
       "181673                            0                           0   \n",
       "181674                            0                           1   \n",
       "181675                            0                           0   \n",
       "181676                            0                           0   \n",
       "181677                            0                           0   \n",
       "181678                            0                           0   \n",
       "181679                            0                           1   \n",
       "181680                            0                           0   \n",
       "181681                            0                           0   \n",
       "181683                            0                           0   \n",
       "181684                            0                           0   \n",
       "181685                            0                           0   \n",
       "181686                            0                           0   \n",
       "181688                            0                           0   \n",
       "181689                            0                           0   \n",
       "181690                            0                           0   \n",
       "\n",
       "        South America  South Asia  Southeast Asia  Sub-Saharan Africa  \\\n",
       "2                   0           0               1                   0   \n",
       "26                  0           0               1                   0   \n",
       "39                  0           0               1                   0   \n",
       "96                  0           0               1                   0   \n",
       "103                 0           0               0                   0   \n",
       "150                 0           0               1                   0   \n",
       "169                 0           0               1                   0   \n",
       "210                 0           0               1                   0   \n",
       "226                 0           0               0                   0   \n",
       "317                 0           0               1                   0   \n",
       "323                 0           0               1                   0   \n",
       "364                 0           0               0                   0   \n",
       "365                 0           0               0                   0   \n",
       "366                 0           0               0                   0   \n",
       "367                 0           0               0                   0   \n",
       "368                 0           0               0                   0   \n",
       "405                 1           0               0                   0   \n",
       "437                 0           0               0                   0   \n",
       "458                 0           0               0                   0   \n",
       "486                 0           0               0                   0   \n",
       "497                 0           0               0                   0   \n",
       "514                 0           0               0                   0   \n",
       "528                 0           0               0                   0   \n",
       "531                 0           0               0                   0   \n",
       "534                 0           0               0                   0   \n",
       "535                 0           0               0                   0   \n",
       "539                 0           0               0                   0   \n",
       "575                 0           0               0                   0   \n",
       "576                 0           0               0                   0   \n",
       "585                 0           1               0                   0   \n",
       "...               ...         ...             ...                 ...   \n",
       "181654              0           0               0                   1   \n",
       "181655              0           0               0                   1   \n",
       "181656              0           0               0                   1   \n",
       "181661              0           1               0                   0   \n",
       "181662              0           0               1                   0   \n",
       "181663              0           1               0                   0   \n",
       "181664              0           0               0                   0   \n",
       "181665              0           1               0                   0   \n",
       "181666              0           0               0                   1   \n",
       "181668              0           0               0                   0   \n",
       "181669              0           0               0                   0   \n",
       "181670              0           0               0                   0   \n",
       "181671              0           0               0                   0   \n",
       "181672              0           1               0                   0   \n",
       "181673              0           1               0                   0   \n",
       "181674              0           0               0                   0   \n",
       "181675              0           0               0                   1   \n",
       "181676              0           1               0                   0   \n",
       "181677              0           0               1                   0   \n",
       "181678              0           0               1                   0   \n",
       "181679              0           0               0                   0   \n",
       "181680              0           0               0                   1   \n",
       "181681              0           0               1                   0   \n",
       "181683              0           1               0                   0   \n",
       "181684              0           1               0                   0   \n",
       "181685              0           1               0                   0   \n",
       "181686              0           0               0                   1   \n",
       "181688              0           0               1                   0   \n",
       "181689              0           1               0                   0   \n",
       "181690              0           0               1                   0   \n",
       "\n",
       "        Western Europe  \n",
       "2                    0  \n",
       "26                   0  \n",
       "39                   0  \n",
       "96                   0  \n",
       "103                  1  \n",
       "150                  0  \n",
       "169                  0  \n",
       "210                  0  \n",
       "226                  0  \n",
       "317                  0  \n",
       "323                  0  \n",
       "364                  1  \n",
       "365                  1  \n",
       "366                  1  \n",
       "367                  1  \n",
       "368                  1  \n",
       "405                  0  \n",
       "437                  1  \n",
       "458                  1  \n",
       "486                  0  \n",
       "497                  1  \n",
       "514                  1  \n",
       "528                  1  \n",
       "531                  0  \n",
       "534                  0  \n",
       "535                  0  \n",
       "539                  0  \n",
       "575                  0  \n",
       "576                  1  \n",
       "585                  0  \n",
       "...                ...  \n",
       "181654               0  \n",
       "181655               0  \n",
       "181656               0  \n",
       "181661               0  \n",
       "181662               0  \n",
       "181663               0  \n",
       "181664               1  \n",
       "181665               0  \n",
       "181666               0  \n",
       "181668               0  \n",
       "181669               0  \n",
       "181670               0  \n",
       "181671               0  \n",
       "181672               0  \n",
       "181673               0  \n",
       "181674               0  \n",
       "181675               0  \n",
       "181676               0  \n",
       "181677               0  \n",
       "181678               0  \n",
       "181679               0  \n",
       "181680               0  \n",
       "181681               0  \n",
       "181683               0  \n",
       "181684               0  \n",
       "181685               0  \n",
       "181686               0  \n",
       "181688               0  \n",
       "181689               0  \n",
       "181690               0  \n",
       "\n",
       "[117659 rows x 42 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new_4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "y = df_new_4['casualities']\n",
    "df_new_5 = df_new_4.drop('casualities',axis=1)\n",
    "#X = df_new_5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new_6 = df_new_5.drop([\"Country\",\"AttackType\",\"Region\"],axis = 1)\n",
    "X = df_new_6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Feature Scaling\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "sc = StandardScaler()\n",
    "X = X.astype('float64')\n",
    "X = sc.fit_transform(X)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size = 0.3, random_state = 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.ensemble import RandomForestRegressor\n",
    "from sklearn.metrics import mean_squared_error\n",
    "\n",
    "mse_rf = {}\n",
    "\n",
    "for n in range(45, 51):\n",
    "    rfr = RandomForestRegressor(n_estimators=n)\n",
    "    rfr.fit(X_train, y_train)\n",
    "    y_pred = rfr.predict(X_test)\n",
    "    mse_rf[n] = mean_squared_error(y_test, y_pred)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{45: 16.427902030241132,\n",
       " 46: 14.516698287864665,\n",
       " 47: 15.192704400306779,\n",
       " 48: 16.49450668293242,\n",
       " 49: 17.21758661792637,\n",
       " 50: 15.991782385952748}"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mse_rf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0.5, 1.0, 'Random Forest')"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYwAAAEaCAYAAAACBmAUAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzt3XucVmW99/HP14EED4HBiCDiKBliCsgewNICbG8PaJjhATLFqDyUmZbtToZiT+16tu5q6y6jRJRH8ZCH2J6CXaJlyRY5KJ7NRp0wQJSDCCbwe/5Ya6abm3tmFsPch5n5vl+v+zVrXetaa/0Ww8xv1nWtdV2KCMzMzFqyS7kDMDOz9sEJw8zMMnHCMDOzTJwwzMwsEycMMzPLxAnDzMwyccIwa4akMZLqyx2HWSVwwrB2R1KdpI2S3pL0N0kzJe1R7rh2lqSQtCG9rrckrSnx+Z0crVlOGNZefTwi9gCGAYcD3yxzPG1laETskX567ujOkroUIygzcMKwdi4i/gb8hiRxACDpBEmLJa2T9Kqky3O21aR/yU+W9Iqk1yV9O2d79/SO5U1JTwMjcs8nabCk+ZLWSHpK0vicbTMl/VTS/ekdwiOS9pH04/R4z0o6vDXXKenzkl6U9IakOZL65WwLSV+U9ALwQlp2sKR5af3nJJ2WU3+cpKclrZf0V0mXSNoduB/ol3OH02+7QKxTc8Kwdk1Sf+B44MWc4g3AWUBP4ATgfEmfyNv1KGAQ8DFgqqTBafllwMD0cywwOedcXYH/BuYCewNfAm6SNCjnuKcBlwK9gXeAPwGL0vVfAf/Rims8Gvi39Nh9gZeBW/KqfQIYBRyS/vKfB9ycxjkJ+KmkD6Z1rwPOjYg9gUOB30XEBpJ/x+U5dzjLdzRW69icMKy9ulvSeuBVYCXJL3oAImJ+RDwZEVsj4glgNjA6b/9pEbExIpYCS4GhaflpwPci4o2IeBX4z5x9jgD2AH4QEX+PiN8B95D8Qm5wV0Q8HhGbgLuATRFxY0RsAW4laT5rzqL07mWNpIZznwHMiIhFEfEOSfPbhyTV5Oz3b2nMG4ETgbqIuD4iNkfEIuAO4JS07rskieW9EfFmut2sRU4Y1l59Iv0LeQxwMMlf8ABIGiXpQUmrJK0FzsvdnvpbzvLbJIkAoB9JEmrwcs5yP+DViNiat33fnPUVOcsbC6y31Dk/PCJ6pp8Lc87bGEdEvAWszjtvbsz7A6NyEs8akqSzT7p9AjAOeFnSQ5I+1EJMZoAThrVzEfEQMBO4Mqf4ZmAOsF9E9ACuBZTxkK8B++WsD8hZXg7sJ2mXvO1/3cGwd9RykiQAQNrk1CvvvLnDTr8KPJSTeHqmTUznA0TEYxFxEklz1d3AbQWOYbYdJwzrCH4M/Iukho7vPYE3ImKTpJHAp3bgWLcB35S0V9o/8qWcbQtI+kf+VVJXSWOAj7N9f0Jbuxn4jKRhknYFvg8siIi6JurfA3xA0plpnF0ljUg77N8j6QxJPSLiXWAdsCXdbwXQS1KPIl+PtVNOGNbuRcQq4EbgO2nRF4Ar0j6OqfzjL+gsppE0//yFpHN7Vs55/g6MJ+kcfh34KXBWRDy7s9fQnIj4Lcm13UFyBzQQmNhM/fXAMWmd5STNbz8Edk2rnAnUSVpH0lz36XS/Z0n6e15Km7L8lJRtQ55AyczMsvAdhpmZZeKEYWZmmThhmJlZJk4YZmaWiROGmZll0qFGtuzdu3fU1NSUOwwzs3bj8ccffz0iqrPU7VAJo6amhoULF5Y7DDOzdkPSyy3XSrhJyszMMinaHYakGSSjZq6MiEPTsltJhpSGZOjpNRExrMC+dcB6kiELNkdEbbHiNDOzbIrZJDUTuIZkyAYAIuL0hmVJVwFrm9l/bES8XrTozMxshxQtYUTEw3nj9TeSJJJ5B44u1vkbvPvuu9TX17Np06Zin8oqULdu3ejfvz9du3Ytdyhm7V65Or0/AqyIiBea2B7AXEkB/Dwiprf2RPX19ey5557U1NSQ5CnrLCKC1atXU19fzwEHHFDucMzavXJ1ek8iGRWzKUdGxHCSUUG/KOmjTVWUdI6khZIWrlq1arvtmzZtolevXk4WnZAkevXq5btLszZS8oQhqQvwSZLpKgtqmEs4IlaSTHM5spm60yOiNiJqq6sLP0rsZNF5+Xtv1nbKcYfxz8CzEVFfaKOk3SXt2bBMMq7/shLG1+YkceaZZzaub968merqak488cSinvfRRx9l1KhRDBs2jMGDB3P55ZcX9XxZ1dXV0b17d4YNG9b4ufHGG1ve0czKqpiP1c4mmW+5t6R64LKIuI5kUpfZeXX7Ab+MiHFAH+Cu9C/DLsDNEfFAW8VV84172+pQANT94IQW6+y+++4sW7aMjRs30r17d+bNm8e+++7b4n47a/Lkydx2220MHTqULVu28NxzzxX1fJs3b6ZLl2z/pQYOHMiSJUuarbNlyxaqqqqaXG+LOKy82vrnsSVZfl6taUW7w4iISRHRNyK6RkT/NFkQEWdHxLV5dZenyYKIeCkihqafD0bE94oVYykdf/zx3Htv8sMxe/ZsJk2a1Lhtw4YNTJkyhREjRnD44Yfz61//Gkj+Ev/IRz7C8OHDGT58OH/84x8BmD9/PmPGjOGUU07h4IMP5owzzqDQRFgrV66kb9++AFRVVXHIIYcAsHr1ao455hgOP/xwzj33XPbff39ef/116urqOPTQQxv3v/LKKxvvSn7xi18wYsQIhg4dyoQJE3j77bcBOPvss/nKV77C2LFj+frXv97ktWS1xx57MHXqVEaNGsWf/vQnampquOKKKzjqqKO4/fbbWbJkCUcccQRDhgzh5JNP5s033wRgzJgxfOtb32L06NH85Cc/2aFzmlk2ftO7RCZOnMgtt9zCpk2beOKJJxg1alTjtu9973scffTRPPbYYzz44IN87WtfY8OGDey9997MmzePRYsWceutt3LhhRc27rN48WJ+/OMf8/TTT/PSSy/xyCOPbHfOiy++mEGDBnHyySfz85//vLHzd9q0aRx11FEsXryY8ePH88orr7QY/yc/+Ukee+wxli5dyuDBg7nuuusatz3//PP8z//8D1dddVWT15Lvz3/+8zZNUr///e+BJHkeeuihLFiwgKOOOgpIHo39wx/+wMSJEznrrLP44Q9/yBNPPMFhhx3GtGnTGo+5Zs0aHnroIb761a+2eD1mtuN8314iQ4YMoa6ujtmzZzNu3Lhtts2dO5c5c+Zw5ZVXAsmTXa+88gr9+vXjggsuYMmSJVRVVfH888837jNy5Ej69+8PwLBhw6irq2v8Bdtg6tSpnHHGGcydO5ebb76Z2bNnM3/+fB5++GHuvPNOAE444QT22muvFuNftmwZl156KWvWrOGtt97i2GOPbdx26qmnNjYVNXUtgwcP3uZ4TTVJVVVVMWHChG3KTj89ed9z7dq1rFmzhtGjRwNJk9upp566XT0zKw4njBIaP348l1xyCfPnz2f16tWN5RHBHXfcwaBBg7apf/nll9OnTx+WLl3K1q1b6datW+O2XXfdtXG5qqqKzZs3FzznwIEDOf/88/n85z9PdXV143kLPT3UpUsXtm7d2rie+zjq2Wefzd13383QoUOZOXMm8+fPb9y2++67t3gtWXXr1m27forc4zcnaz0zax03SZXQlClTmDp1Kocddtg25cceeyxXX311Yz/E4sWLgeQv6r59+7LLLrswa9YstmzZskPnu/feexuP+cILL1BVVUXPnj356Ec/yk033QTA/fff39gP0KdPH1auXMnq1at55513uOeeexqPtX79evr27cu7777buG8hTV1LW+jRowd77bVXY/PVrFmzGu82zKz4fIdRQv379+fLX/7yduXf+c53uOiiixgyZAgRQU1NDffccw9f+MIXmDBhArfffjtjx47d4b+gZ82axcUXX8xuu+1Gly5duOmmm6iqquKyyy5j0qRJDB8+nNGjRzNgwAAAunbt2tjhfMABB3DwwQc3Huu73/0uo0aNYv/99+ewww5j/fr1Bc/Z1LXka+jDaDBlypRt+miacsMNN3Deeefx9ttvc+CBB3L99dfv0L+JmbWeCj1d017V1tZG/nwYzzzzzHbt57athnlEevfuXe5QisL/ByqXH6stP0mPZx0R3E1SZmaWiZukjLq6unKHYE3wX+BWSZwwgCfq15TsXEP69yzZuczM2lKnaJLqSP00tmP8vTdrOx0+YXTr1o3Vq1f7F0cn1DAfRu77K2bWeh2+Sap///7U19dTaK6MBive3FiyeJ5Z371k57J/zLhnZjuvwyeMrl27tjjb2vEl7Fh0p6KZtVcdPmGYmZVLKZ9yK8Ufox2+D8PMzNqGE4aZmWXihGFmZpk4YZiZWSZOGGZmlokThpmZZeKEYWZmmRQtYUiaIWmlpGU5ZZdL+qukJelnXBP7HifpOUkvSvpGsWI0M7PsinmHMRM4rkD5jyJiWPq5L3+jpCrgv4DjgUOASZIOKWKcZmaWQdHe9I6IhyXVtGLXkcCLEfESgKRbgJOAp9suOusoPF+EWemUow/jAklPpE1WexXYvi/was56fVpmZmZlVOqE8TNgIDAMeA24qkAdFShrcmxySedIWihpYXMj0pqZ2c4pacKIiBURsSUitgK/IGl+ylcP7Jez3h9Y3swxp0dEbUTUVldXt23AZmbWqKQJQ1LfnNWTgWUFqj0GHCTpAEnvASYCc0oRn5mZNa1ond6SZgNjgN6S6oHLgDGShpE0MdUB56Z1+wG/jIhxEbFZ0gXAb4AqYEZEPFWsOM3MLJtiPiU1qUDxdU3UXQ6My1m/D9jukVszMysfv+ltZmaZeMa9Ds7vKZhZW/EdhpmZZeKEYWZmmThhmJlZJk4YZmaWiROGmZll4oRhZmaZOGGYmVkmThhmZpaJE4aZmWXihGFmZpk4YZiZWSZOGGZmlokThpmZZeKEYWZmmThhmJlZJk4YZmaWiROGmZll4oRhZmaZOGGYmVkmzSYMSVWSLm7NgSXNkLRS0rKcsn+X9KykJyTdJalnE/vWSXpS0hJJC1tzfjMza1vNJoyI2AKc1MpjzwSOyyubBxwaEUOA54FvNrP/2IgYFhG1rTy/mZm1oS4Z6jwi6RrgVmBDQ2FELGpup4h4WFJNXtncnNVHgVMyR2pmZmWVJWF8OP16RU5ZAEfv5LmnkCShQgKYKymAn0fE9J08l5mZ7aQWE0ZEjG3rk0r6NrAZuKmJKkdGxHJJewPzJD0bEQ83caxzgHMABgwY0NahmplZqsWnpCT1kPQfkhamn6sk9WjtCSVNBk4EzoiIKFQnIpanX1cCdwEjmzpeREyPiNqIqK2urm5tWGZm1oIsj9XOANYDp6WfdcD1rTmZpOOArwPjI+LtJursLmnPhmXgGGBZobpmZlY6WfowBkbEhJz1aZKWtLSTpNnAGKC3pHrgMpKnonYlaWYCeDQizpPUD/hlRIwD+gB3pdu7ADdHxAM7cE1mZlYEWRLGRklHRcQfACQdCWxsaaeImFSg+Lom6i4HxqXLLwFDM8RlZmYllCVhnAfcmNNv8SYwuXghmZlZJWo2YUjaBRgUEUMlvRcgItaVJDIzM6soLb3pvRW4IF1e52RhZtZ5ZXlKap6kSyTtJ+l9DZ+iR2ZmZhUlSx/GlPTrF3PKAjiw7cMxM7NKlaUP49MR8UiJ4jEzswqVpQ/jyhLFYmZmFSxLH8ZcSROUvklnZmadU5Y+jK8AuwObJW0CBEREvLeokZmZWUXJMlrtnqUIxMzMKluTTVKSPp2zfGTetguKGZSZmVWe5vowvpKzfHXetimYmVmn0lzCUBPLhdbNzKyDay5hRBPLhdbNzKyDa67T+2BJT5DcTQxMl0nX/Za3mVkn01zCGFyyKMzMrOI1mTAi4uVSBmJmZpUty5veZmZmThhmZpZNpoQhqbukQcUOxszMKleLCUPSx4ElwAPp+jBJc4odmJmZVZYsdxiXAyOBNQARsQSoyXJwSTMkrZS0LKfsfZLmSXoh/bpXE/tOTuu8IGlylvOZmVnxZEkYmyNibSuPPxM4Lq/sG8BvI+Ig4Lfp+jbSKWAvA0aRJKvLmkosZmZWGlkSxjJJnwKqJB0k6Wrgj1kOHhEPA2/kFZ8E3JAu3wB8osCuxwLzIuKNiHgTmMf2icfMzEooS8L4EvBB4B3gZmAtcNFOnLNPRLwGkH7du0CdfYFXc9br0zIzMyuTlub0rgKmRcTXgG+XJqTk1AXKCo5fJekc4ByAAQMGFDMmM7NOraU5vbcA/9TG51whqS9A+nVlgTr1wH456/2B5U3EOD0iaiOitrq6uo1DNTOzBlmapBZLmiPpTEmfbPjsxDnnAA1PPU0Gfl2gzm+AYyTtlXZ2H5OWmZlZmWSZ0/t9wGrg6JyyAO5saUdJs4ExQG9J9SRPPv0AuE3SZ4FXgFPTurXAeRHxuYh4Q9J3gcfSQ10REfmd52ZmVkJZ5vT+TGsPHhGTmtj0sQJ1FwKfy1mfAcxo7bnNzKxttZgwJHUDPkvypFS3hvKI8DStZmadSJY+jFnAPiTvRjxE0gG9vphBmZlZ5cmSMN4fEd8BNkTEDcAJwGHFDcvMzCpNloTxbvp1jaRDgR5kHEvKzMw6jixPSU1PH239DskjsXsAU4salZmZVZwsT0n9Ml18CDiwuOGYmVmlyvKUVMG7iYi4ou3DMTOzSpWlSWpDznI34ETgmeKEY2ZmlSpLk9RVueuSriTpyzAzs04k05zeeXbDfRlmZp1Olj6MJ/nH0OJVQDXg/gszs04mSx/GiTnLm4EVEbG5SPGYmVmFypIw8ocBea/0j/mNPIqsmVnnkCVhLCKZzOhNkpnwepIMSw5JU5X7M8zMOoEsnd4PAB+PiN4R0YukierOiDggIpwszMw6iSwJY0RE3NewEhH3A6OLF5KZmVWiLE1Sr0u6FPh/JE1QnyaZgc/MzDqRLHcYk0gepb0LuBvYOy0zM7NOJMub3m8AXwZIR61dExHR/F5mZtbRNHmHIWmqpIPT5V0l/Q54EVgh6Z9LFaCZmVWG5pqkTgeeS5cnp3X3Junw/n6R4zIzswrTXML4e07T07HA7IjYEhHPkK2zvCBJgyQtyfmsk3RRXp0xktbm1PGETWZmZdbcL/530ilZVwBjgUtytu3W2hNGxHPAMABJVcBfSTrU8/0+Ik4sUG5mZmXQXML4MvArkiekfhQRfwGQNA5Y3Ebn/xjw54h4uY2OZ2ZmRdJkwoiIBcDBBcrvA+7bfo9WmQjMbmLbhyQtBZYDl0TEU210TjMza4XWzIfRJiS9BxgP3F5g8yJg/4gYClxN8v5HU8c5R9JCSQtXrVpVnGDNzKx8CQM4HlgUESvyN0TEuoh4K12+D+gqqXehg0TE9IiojYja6urq4kZsZtaJlTNhTKKJ5ihJ+ygdQ13SSJI4PRyJmVkZZXo8VtKHgZrc+hFxY2tPKmk34F+Ac3PKzkuPey1wCnC+pM3ARmCi3y43MyuvLFO0zgIGAkuALWlxAK1OGBHxNtArr+zanOVrgGtae3wzM2t7We4waoFD/Be+mVnnlqUPYxmwT7EDMTOzypblDqM38LSk/wXeaSiMiPFFi8rMzCpOloRxebGDMDOzypdlPoyHShGImZlVthb7MCQdIekxSW9J+rukLZLWlSI4MzOrHFk6va8hecnuBaA78Dn8yKuZWaeT6cW9iHhRUlVEbAGul/THIsdlZmYVJkvCeDsdKHCJpP8LvAbsXtywzMys0mRpkjozrXcBsAHYD5hQzKDMzKzyZHlK6mVJ3YG+ETGtBDGZmVkFyvKU1MdJxpF6IF0fJmlOsQMzM7PKkqVJ6nJgJLAGICKWkIxca2ZmnUiWhLE5ItYWPRIzM6toWZ6SWibpU0CVpIOACwE/Vmtm1slkucP4EvBBkoEHZwPrgIuKGZSZmVWeLE9JvQ18O/2YmVkn1WTCaOlJKA9vbmbWuTR3h/Eh4FWSZqgFgEoSkZmZVaTmEsY+wL+QDDz4KeBeYHZEPFWKwMzMrLI02ekdEVsi4oGImAwcAbwIzJf0pZJFZ2ZmFaPZTm9JuwInkNxl1AD/CdxZ/LDMzKzSNNfpfQNwKHA/MC0ilrXliSXVAeuBLSQvB9bmbRfwE2Ac8DZwdkQsassYzMwsu+buMM4kGZ32A8CFye9vIOn8joh4bxucf2xEvN7EtuOBg9LPKOBn6VczMyuDJhNGRGR5qa+YTgJujIgAHpXUU1LfiHitzHGZmXVK5UwKAcyV9Likcwps35fksd4G9WnZNiSdI2mhpIWrVq0qUqhmZlbOhHFkRAwnaXr6oqSP5m0v9N5HbFcQMT0iaiOitrq6uhhxmpkZZUwYEbE8/boSuItkCPVc9SSz+zXoDywvTXRmZpavLAlD0u6S9mxYBo4B8p/CmgOcpcQRwFr3X5iZlU+W4c2LoQ9wV/rkVRfg5oh4QNJ5ABFxLXAfySO1L5I8VvuZMsVqZmaUKWFExEvA0ALl1+YsB/DFUsZlZmZNK/ejs2Zm1k44YZiZWSZOGGZmlokThpmZZeKEYWZmmThhmJlZJk4YZmaWiROGmZll4oRhZmaZOGGYmVkmThhmZpaJE4aZmWXihGFmZpk4YZiZWSZOGGZmlokThpmZZeKEYWZmmThhmJlZJk4YZmaWiROGmZll4oRhZmaZlDxhSNpP0oOSnpH0lKQvF6gzRtJaSUvSz9RSx2lmZtvqUoZzbga+GhGLJO0JPC5pXkQ8nVfv9xFxYhniMzOzAkp+hxERr0XEonR5PfAMsG+p4zAzsx1T1j4MSTXA4cCCAps/JGmppPslfbCZY5wjaaGkhatWrSpSpGZmVraEIWkP4A7goohYl7d5EbB/RAwFrgbubuo4ETE9Imojora6urp4AZuZdXJlSRiSupIki5si4s787RGxLiLeSpfvA7pK6l3iMM3MLEc5npIScB3wTET8RxN19knrIWkkSZyrSxelmZnlK8dTUkcCZwJPSlqSln0LGAAQEdcCpwDnS9oMbAQmRkSUIVYzM0uVPGFExB8AtVDnGuCa0kRkZmZZ+E1vMzPLxAnDzMwyccIwM7NMnDDMzCwTJwwzM8vECcPMzDJxwjAzs0ycMMzMLBMnDDMzy8QJw8zMMnHCMDOzTJwwzMwsEycMMzPLxAnDzMwyccIwM7NMnDDMzCwTJwwzM8vECcPMzDJxwjAzs0ycMMzMLBMnDDMzy6QsCUPScZKek/SipG8U2L6rpFvT7Qsk1ZQ+SjMzy1XyhCGpCvgv4HjgEGCSpEPyqn0WeDMi3g/8CPhhaaM0M7N85bjDGAm8GBEvRcTfgVuAk/LqnATckC7/CviYJJUwRjMzy6OIKO0JpVOA4yLic+n6mcCoiLggp86ytE59uv7ntM7rBY53DnBOujoIeK7Il9CgN7BdPB2Ir6998/W1X6W+tv0jojpLxS7FjqSAQncK+VkrS52kMGI6MH1ng9pRkhZGRG2pz1sqvr72zdfXflXytZWjSaoe2C9nvT+wvKk6kroAPYA3ShKdmZkVVI6E8RhwkKQDJL0HmAjMyaszB5icLp8C/C5K3XZmZmbbKHmTVERslnQB8BugCpgREU9JugJYGBFzgOuAWZJeJLmzmFjqODMoeTNYifn62jdfX/tVsddW8k5vMzNrn/ymt5mZZeKEYWZmmThhmJlZJk4YZmaWiRNGBpKG5Cx3lXSppDmSvi9pt3LG1hYkXSCpd7r8fkkPS1qTDvx4WLnj21mS7pT0aUl7lDuWtibpQEkzJP0fSXtI+oWkZZJu7wiDdkraRdIUSfdKWirpcUm3SBpT7tjagqQekn4g6VlJq9PPM2lZz3LHl88JI5uZOcs/AN4PXAV0B64tR0Bt7PycYVd+AvwoInoCX6djXN8o4BPAK5Juk3Ry+g5QRzCT5N2mt4BHgWdJBvZ8AJhRvrDazHXAAODfgAeBe9OySyV9qZyBtZHbgDeBMRHRKyJ6AWPTstvLGlkBfqw2A0mLI+LwdHkJMCIi3k0HRFwaEUOaP0Jlk/RcRAxKlx+LiBE5257oANe3OCIOl7QnSeKYBIwA7gFmR8Tcsga4E/L+b74SEQMKbWuv8v//SXo0Io6QtCuwJCIGlzG8nZb7s7cj28rFdxjZ9Ej/Kp0A7BoR7wKkb593hIz7K0kzJR0I3CXpIkkDJH0GeKXcwbWBAIiI9RExKyLGkQxUuQDYbj6WdmarpA9IGgHsJqkWkqZFkhdj27t3JQ0EkDQc+DtARLxDx/jZe1nSv0rq01AgqY+krwOvljGugsox+GB79DAwPl1+VFKfiFghaR86wIiZEfHtNDnMBgYCu5KMAHw3cEY5Y2sjb+UXRMQbJM1t7b3J7V+B/wa2ktw9fTPtc+vBP0Zxbs++Bjwo6R2S31eTACRVk9whtnenk/zR8lCaNAJYQTI80mnlDKwQN0m1kqQbI+KscsdRLJJmRcSZ5Y6jWDry90/SPcD4iNha7ljaQtr026uhn62Df+8+QjJn0JOV2FTqO4wMJOUPjghwdMNTDBExvsD2dqOZ65sDHfL6BIztCN+/Jr53Y4C7JbXra4Ntry9nDrWO9LP3vxExMl3+HPBFkjv7yyQNj4gflDXAPE4Y2ewHPAX8kuSWUSSdpleVM6g21B94mo57fYW+f7V0jOvr6P83O/r1dc1ZPhc4JiJWSbqS5Km3ikoY7vTO5p+Ax4FvA2sjYj6wMSIeioiHyhpZ26ilY19fR/7+deRrg45/fbtI2ktSL5IuglUAEbEB2Fze0LbnPowdIKk/8COSTqnxuY8wdgS+vvarI18bdNzrk1RH8sCCSO6gPhwRf0tfMv1DRAwrZ3z53CS1A9I5xk+VdAKwrtzxtDVfX/vVka8NOu71RURNE5u2AieXMJRMfIdhZmaZuA/DzMwyccIwM7NMnDDMzCwTJwyzNiJpmKRxOevjJbXJWFXp+F7tfih9a9/c6W3WRiSdDdRGxAVFOHZdeuzMY5dJqoqILW0di3VevsOwTkdSTTpJzS8kPSVprqTuTdQdKOmBdOKe30s6OC0/NZ2oaKmSCafeA1wBnC5piaTTJZ0t6Zq0/kxJP5P0oKSXJI1WMvGvDaSeAAACC0lEQVTRM5Jm5pzvZ5IWpnFNS8suBPqRDML3YFo2SdKTaQw/zNn/LUlXSFoAfKg4/4LWaUWEP/50qg9QQ/IW7bB0/Tbg003U/S1wULo8CvhduvwksG+63DP9ejZwTc6+jeskEx3dQvKC1kkk7xIcRvJH2+M5sbwv/VoFzAeGpOt1QO90uR/JsPPVJO9S/Q74RLotgNPK/W/sT8f8+A7DOqu/RMSSdPlxkiSyjfRt2w8DtyuZOOvnQN908yPATEmfJ/u8E/8dEUGSbFZExJORjCj7VM75T5O0CFgMfBA4pMBxRgDzI2JVRGwGbgI+mm7bAtyRMR6zHeI3va2zeidneQvJdLv5dgHWRIHhGSLiPEmjgBOAJZKyDOHQcM6teeffCnSRdABwCcmMjm+mTVXdChxHBcoabAr3W1iR+A7DrAkRsQ74i6RTIZmXQdLQdHlgRCyIiKkkk2jtB6wH9tyJU74X2ACsTSfTOT5nW+6xFwCjJfWWVEUyqVBHGIjPKpwThlnzzgA+K2kpSdPRSWn5vzd0OpPMyLgUeBA4pKHTe0dPFBFLSZqingJmkDR7NZgO3C/pwYh4Dfhmer6lwKKI+HXrLs8sOz9Wa2ZmmfgOw8zMMnGntxkg6b+AI/OKfxIR15cjHrNK5CYpMzPLxE1SZmaWiROGmZll4oRhZmaZOGGYmVkmThhmZpbJ/weEvmPDv5VKoAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "col={'Mean Square Error': mse_rf}\n",
    "df = pd.DataFrame(data=col, index=mse_rf)\n",
    "df.plot(kind='bar')\n",
    "plt.xlabel('n_estimator')\n",
    "plt.ylabel('Mean Square Error')\n",
    "plt.title('Random Forest')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{45: 4.053134839879021,\n",
       " 46: 3.8100785146588074,\n",
       " 47: 3.8977819847070436,\n",
       " 48: 4.061342965440424,\n",
       " 49: 4.149407984029333,\n",
       " 50: 3.9989726663172815}"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rmse_rf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import Ridge\n",
    "from sklearn.metrics import mean_squared_error\n",
    "\n",
    "mse_ridge = {}\n",
    "\n",
    "for n in [1e-2, 1, 2, 3]:\n",
    "    ridge = Ridge(alpha=n)\n",
    "    ridge.fit(X_train, y_train)\n",
    "    y_pred = ridge.predict(X_test)\n",
    "    mse_ridge[n] = mean_squared_error(y_test, y_pred)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0.01: 58.38350258512882,\n",
       " 1: 58.3827584466613,\n",
       " 2: 58.38200685195814,\n",
       " 3: 58.38125531787054}"
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mse_ridge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import Lasso\n",
    "from sklearn.metrics import mean_squared_error\n",
    "\n",
    "mse_lasso = {}\n",
    "\n",
    "for n in [1e-2, 1, 2, 3]:\n",
    "    lasso = Lasso(alpha=n)\n",
    "    lasso.fit(X_train, y_train)\n",
    "    y_pred = lasso.predict(X_test)\n",
    "    mse_lasso[n] = mean_squared_error(y_test, y_pred)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0.01: 58.27752006232824,\n",
       " 1: 44.66772387337986,\n",
       " 2: 38.974452422986005,\n",
       " 3: 41.60872784311572}"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mse_lasso"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEWCAYAAABrDZDcAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzt3Xm8VXW9//HXWyTBRFBBQ1Ahp0TAQyLiVQnnKZM0fxroJSeqhyBFg/y028XqlhmVqaRxtUJT0MwcKi1zQk1NxBOSWE5oCCGiCCrI9Ll/rO/B7fEM+xz2wDnr/Xw89mOv9V3TZ699zvrs9f2u9V2KCMzMLL82q3YAZmZWXU4EZmY550RgZpZzTgRmZjnnRGBmlnNOBGZmOedEYFUnaZSkP1U7jjqSOku6Q9Kbkn7diuUPlvSPJqb/UtJ3Ni7K8pMUknardhxWfk4E7YikkZJmSXpL0iJJd0o6qNpxNSciro+II6sdR4HPADsA20XEyfUnSpokaU3az8sk/UXSAXXTI+LBiNizkgFXmqT7JZ1d7TisNJwI2glJE4BLge+SHcR2Bn4KnFDNuJojafNqx9CAXYB/RsTaJua5MSK2AroD9wEtPnMw21Q4EbQDkroC3wLOjYhbIuLtiFgTEXdExNfSPFtIulTSwvS6VNIWadpwSQskfV3Sq+lsYoSkYyX9U9Lrki4o2N4kSTdLulHSCkmzJe1TMH2ipOfTtKclfbpg2uckPSzpx5JeByalsofSdKVpr6aqmTmS+td9TknXSloi6SVJ35C0WcF6H5I0WdIbkl6UdEwT+2yv9Kt2maS/S/pUKr8I+CZwSvrFf1ZT+z4li+uBXpJ6FO7Pgm0NSvtohaQbgU71Yvl62ucLJZ1dWCWTvrfJkl6WtFjSVZI6N/KZdpV0r6Slkl6TdL2kbgXT50v6atqnb6bvr1PB9K8VxHFmU5+7KZJ+LenfaRszJe1dMO3Y9DexQtIrkr6ayrtL+l36Pl6X9GDBd9vgd2UlFBF+tfEXcDSwFti8iXm+BTwKbA/0AP4CfDtNG56W/ybQETgHWALcAHQB9gZWAR9N808C1pBVoXQEvgq8CHRM008GdiT7oXEK8DbQM037XNrWOGBzoHMqeyhNPwp4AugGCNirYNlrgdtSTH2AfwJnFax3TYq9A/BFYCGgBvZFR+A54ALgQ8ChwApgz4LP96sm9uWG6Wn5i4HX6vZ/2p8LCqa/BHw5bfczKc7vFHx3/077eEvgOiCA3dL0S4HbgW3T574D+F4jce0GHAFskb7jmcClBdPnA39N3822wDzgCwVxLAb6Ax9O3/2GOBrY1v3A2Y1MOzPFukWKv7Zg2iLg4DS8DfDxNPw94Kq0jzoCB6fvv8nvyq8SHUOqHYBfJfgSYRTw72bmeR44tmD8KGB+Gh4OrAQ6pPEu6SCwf8H8TwAj0vAk4NGCaZsV/oM3sO1a4IQ0/Dng5XrTP8d7ieBQsgP8UGCzgnk6AO8C/QrKPg/cX7CO5wqmbZk+w0caiOfgdPAtXP90YFLB52suEawGlgHrgKXA8ILpw3kvEQyjXkIiS8J1ieDnFBzYyQ7mkd5FlkR3LZh+APBikX8XI4AnC8bnA6cVjF8CXFUQx8UF0/aglYmg3nzd0nq6pvGX0/e2db35vkWW5HerV97kd+VXaV6uGmoflgLdm6lv35Hsl2mdl1LZhnVExLo0vDK9Ly6YvhLYqmD8X3UDEbEeWFC3Pkn/Kak2ncovI/uV2b2hZeuLiHuBK4ApwGJJUyVtnZav+3Vd+Bl6FYz/u2A976TBwpjr7Aj8K8Xd2Lqac1NEdCNrj5kL7NvIfDsCr0Q6ghVs632xFIwXDvcgS2hPFOzLu1L5B0jaXtKMVOWyHPgV79/vULCPgHd4b//Uj6MwxqJJ6iDp4lQ1uJws+VAQx0nAscBLkh7Qe43sPyD75f8nSS9ImlgY10Z+V9YMJ4L24RGyqpsRTcyzkKwRtM7Oqay1dqobSHW5vYGFknYB/hcYS3bVTTeyA6UKlm2yy9uIuCwi9iWrLtkD+BpZ1cuaBj7DK62IfSGwU10d9MasKyJeI/uFO0lSzwZmWUTWflD4+XeuN713wfhOBcOvkSXgvSOiW3p1jayRuiHfI9u3AyNia+A03r/fm7Ko3rZ3bmzGZowku0DhcKArWRUedXFExOMRcQJZFeWtwE2pfEVEfCUiPgocD0yQdBgl/K6scU4E7UBEvElWvz9FWSPvlpI6SjpG0iVptunANyT1kNQ9zf+rjdjsvpJOTGchXyKrtnmUrH45yNoYkHQG2RlBUSTtJ2l/SR3JqkVWAevS2cpNwP9I6pISzoRWfobH0rq/nvbTcLKDz4xWrIuIeAb4I/D1BiY/QtYmcp6kzSWdCAwpmH4TcEZqEN2S7HupW+96sqT6Y0nbA0jqJemoRkLpArwFLJPUiyyBFusm4HOS+qU4/ruIZTaX1Kng1THF8C7ZWeqWZFexkWL/kLJ7RrpGxBpgOVnVGpI+KWm3lDDrytdR4u/KGuZE0E5ExI/IDozfIDsI/4vsV/mtaZbvALOAOcBTwOxU1lq3kTUEvwGcDpwY2ZVKTwM/JDsALgYGAA+3YL1bkx383iCrAlgKTE7TxpEdFF4AHiJr0Px5SwOPiNXAp4BjyH51/xT4z3RAb60fAGPqDtj1tnUiWRvGG2T77JaC6XcCl5Fdgvoc2X6D7GAKcH4qfzRVtfwZaOwehYuAjwNvAr8v3E5zUhyXAvem7d1bxGJXkp2x1L1+Qdag/xLZL/anyX4cFDodmJ8+yxfIzloAdif7bG+R7YOfRsT9ZfqurB69v+rSrHmSJpE16p3W3LzWMpL2IqtK2yKavo/BrGR8RmBWZZI+napNtgG+D9zhJGCV5ERgVn2fJ6vOe56sXvyL1Q3H8sZVQ2ZmOeczAjOznNsUO/z6gO7du0efPn2qHYaZWZvyxBNPvBYRDd6AWKhNJII+ffowa9asaodhZtamSCrqDvGyVg1J6qasl8pnJM2TdICkbSXdLenZ9L5NOWMwM7OmlbuN4CfAXRHxMWAfst4OJwL3RMTuwD1p3MzMqqRsiSB1FDYMuAayOywjYhlZPyTT0mzTaLp/HDMzK7NythF8lOza6F8oe2jJE8B4YIeIWAQQEYvq35JfR9IYYAzAzju3tv8rM8uDNWvWsGDBAlatWlXtUKqiU6dO9O7dm44dO7Zq+XImgs3J+j0ZFxGPSfoJLagGioipwFSAwYMH+2YHM2vUggUL6NKlC3369OH9Hb22fxHB0qVLWbBgAX379m3VOsrZRrCA7OEcj6Xxm8kSw+K67nrT+6tljMHMcmDVqlVst912uUsCAJLYbrvtNupsqGyJICL+DfxLUl1PiYeR9UZ4OzA6lY0m68XSzGyj5DEJ1NnYz17u+wjGAddL+hBZ18FnkCWfm5Q9FPxlsufbmplZlZQ1EURELTC4gUmHlXO7ZpZvfSb+vqTrm3/xcc3O06FDBwYMGMDatWvp27cv1113Hd26dWPhwoWcd9553HzzzR9YZvjw4UyePJnBgxs6TFZOm7izeGOU+g+iGPM7jaz4Npn0ZllXX5X9WMQ/X1tU6X2Zh/34v5/qyZoFy8q2rTlp3QN7d2t0ns6dO1NbWwvA6NGjmTJlChdeeCE77rhjg0lgU+JO58zMSuyAAw7glVeyxyrPnz+f/v2zp7WuXLmSU089lYEDB3LKKaewcuXKDctcc8017LHHHgwfPpxzzjmHsWPHArBkyRJOOukk9ttvP/bbbz8efrglD/wrTrs/IzAzq6R169Zxzz33cNZZZ31g2pVXXsmWW27JnDlzmDNnDh//+McBWLhwId/+9reZPXs2Xbp04dBDD2WfffYBYPz48Xz5y1/moIMO4uWXX+aoo45i3rx5JY3ZicDMrARWrlxJTU0N8+fPZ9999+WII474wDwzZ87kvPPOA2DgwIEMHDgQgL/+9a984hOfYNtttwXg5JNP5p///CcAf/7zn3n66ac3rGP58uWsWLGCLl26lCx2Vw2ZmZVAXRvBSy+9xOrVq5kyZUqD8zV0qWdTDwhbv349jzzyCLW1tdTW1vLKK6+UNAmAE4GZWUl17dqVyy67jMmTJ7NmzZr3TRs2bBjXX389AHPnzmXOnDkADBkyhAceeIA33niDtWvX8pvf/GbDMkceeSRXXHHFhvG6BulSctWQmbU7t489sKrbHzRoEPvssw8zZszg4IMP3lD+xS9+kTPOOIOBAwdSU1PDkCFDAOjVqxcXXHAB+++/PzvuuCP9+vWja9euAFx22WWce+65DBw4kLVr1zJs2DCuuuqqksbrRGBmVgJvvfXW+8bvuOOODcNz584FsuqjGTNmNLj8yJEjGTNmDGvXruXTn/40Rx55JADdu3fnxhtvLFPUGVcNmZltAiZNmkRNTQ39+/enb9++jBhRuR76fUZgZrYJmDx5ctW27TMCM7OccyIwM8s5JwIzs5xzIjAzyzk3FptZuzPw6l1Kur45Z7/U7DxbbbXVBy4hbSt8RmBmlnNOBGZmZXLHHXew//77M2jQIA4//HAWL14MwAMPPEBNTQ01NTUMGjSIFStWsGjRIoYNG7bhXoIHH3wQgOnTpzNgwAD69+/P+eefX5Y4nQjMzMrkoIMO4tFHH+XJJ5/k1FNP5ZJLLgGyewamTJlCbW0tDz74IJ07d+aGG27gqKOOora2lr/97W/U1NSwcOFCzj//fO69915qa2t5/PHHufXWW0sep9sIzMzKZMGCBZxyyiksWrSI1atX07dvXwAOPPBAJkyYwKhRozjxxBPp3bs3++23H2eeeSZr1qxhxIgR1NTUcO+99zJ8+HB69OgBwKhRo5g5c2bJ7zr2GYGZWZmMGzeOsWPH8tRTT/Gzn/2MVatWATBx4kSuvvpqVq5cydChQ3nmmWcYNmwYM2fOpFevXpx++ulce+21TXZPXUo+IzAzK5M333yTXr16ATBt2rQN5c8//zwDBgxgwIABPPLIIzzzzDN07tyZXr16cc455/D2228ze/Zszj//fMaPH89rr73GNttsw/Tp0xk3blzJ43QiMLN2p5jLPUvtnXfeoXfv3hvGJ0yYwKRJkzj55JPp1asXQ4cO5cUXXwTg0ksv5b777qNDhw7069ePY445hhkzZvCDH/yAjh07stVWW3HttdfSs2dPvve973HIIYcQERx77LGccMIJJY/dicDMrATWr1/fYHlDB+7LL7/8A2WjR49m9OjRHygfOXIkI0eO3PgAm+A2AjOznHMiMDPLOScCM2vzgqjYFTaboo397GVNBJLmS3pKUq2kWalsW0l3S3o2vW9TzhjMrP17adka1r6zPJfJICJYunQpnTp1avU6KtFYfEhEvFYwPhG4JyIuljQxjZfnvmkzy4XLH3uDccAu3V5DqGzbmbeic9nWvTE6der0viuWWqoaVw2dAAxPw9OA+3EiMLONsPzd9fzPzKVl3878i48r+zaqodxtBAH8SdITksaksh0iYhFAet++oQUljZE0S9KsJUuWlDlMM7P8KvcZwYERsVDS9sDdkp4pdsGImApMBRg8eHD+Kv7MzCqkrGcEEbEwvb8K/BYYAiyW1BMgvb9azhjMzKxpZUsEkj4sqUvdMHAkMBe4Hai7fW40cFu5YjAzs+aVs2poB+C3kuq2c0NE3CXpceAmSWcBLwMnlzEGMzNrRtkSQUS8AOzTQPlS4LBybdfMzFrGdxabmeWcE4GZWc45EZiZ5ZwTgZlZzjkRmJnlnBOBmVnOORGYmeWcE4GZWc45EZiZ5ZwTgZlZzjkRmJnlnBOBmVnOORGYmeVcNZ5ZbFacSV2rsM03K79NsyrzGYGZWc45EZiZ5ZwTgZlZzjkRmJnlXJOJQFIHSV+uVDBmZlZ5TSaCiFgHnFChWMzMrAqKuXz0YUlXADcCb9cVRsTsskVlZmYVU0wi+I/0/q2CsgAOLX04ZmZWac0mgog4pBKBmJlZdTR71ZCkrpJ+JGlWev1QUhVu+TQzs3Iopmro58Bc4P+l8dOBXwAnlisoM7NNUqW7PalQlyfFJIJdI+KkgvGLJNWWKyAzM6usYm4oWynpoLoRSQcCK8sXkpmZVVIxZwRfAK4taBd4Axhd7AYkdQBmAa9ExCcl9QVmANsCs4HTI2J1y8I2M7NSae7O4s2APSNiH2AgMDAiBkXEnBZsYzwwr2D8+8CPI2J3sqRyVgtjNjOzEmruzuL1wNg0vDwilrdk5ZJ6A8cBV6dxkd1/cHOaZRowooUxm5lZCRXTRnC3pK9K2knStnWvItd/KfB1YH0a3w5YFhFr0/gCoFdDC0oaU3fJ6pIlS4rcnJmZtVQxbQRnpvdzC8oC+GhTC0n6JPBqRDwhaXhdcQOzRkPLR8RUYCrA4MGDG5zHzMw2XpOJILURnBYRD7di3QcCn5J0LNAJ2JrsDKGbpM3TWUFvYGEr1m1mZiVSTBvB5NasOCL+f0T0jog+wKnAvRExCrgP+EyabTRwW2vWb2ZmpVFM1dCfJJ0E3BIRpaiiOR+YIek7wJPANSVYp5k1ptJ3w0LF7oi10igmEUwAPgyslbSKrJ4/ImLrYjcSEfcD96fhF4AhLY7UzMzKopjeR7tUIhAzM6uORtsIJJ1WMHxgvWljyxmUmZlVTlONxRMKhi+vN+1MzMysXWgqEaiR4YbGzcysjWoqEUQjww2Nm5lZG9VUY/HHJM0h+/W/axomjTd5V7GZmbUdTSWCvSoWhZmZVU2jiSAiXqpkIGZmVh3F9D5qZmbtmBOBmVnOFZUIJHWWtGe5gzEzs8prNhFIOh6oBe5K4zWSbi93YGZmVhnFnBFMIuskbhlARNQCfcoXkpmZVVIxiWBtRLhPWTOzdqqYbqjnShoJdJC0O3Ae8JfyhmVmZpVSzBnBOGBv4F3gBuBN4EvlDMrMzCqnuWcWdwAuioivARdWJiQzM6uk5p5ZvA7Yt0KxmJlZFRTTRvBkulz018DbdYURcUvZojIzs4opJhFsCywFDi0oC8CJwMysHSjmmcVnVCIQMzOrjmYTgaROwFlkVw51qiuPCD+u0sysHSjm8tHrgI8ARwEPAL2BFeUMyszMKqeYRLBbRPwX8HZETAOOAwaUNywzM6uUYhLBmvS+TFJ/oCvua8jMrN0o5qqhqZK2Af4LuB3YCvhmWaMyM7OKKeaqoavT4AO04KH1qZF5JrBF2s7NEfHfkvoCM8guS50NnB4Rq1sauJmZlUYxVw01+Os/Ir7VzKLvAodGxFuSOgIPSboTmAD8OCJmSLqK7IqkK1sYt5mZlUgxbQRvF7zWAcdQRBtBZN5Kox3TK8huTLs5lU8DRrQsZDMzK6ViqoZ+WDguaTJZW0GzUqd1TwC7AVOA54FlEbE2zbIA6NXIsmOAMQA777xzMZszM7NWaM3D67ekyLaCiFgXETVk9x4MAfZqaLZGlp0aEYMjYnCPHj1aEaaZmRWjmDaCp3jvYN0B6AE01z7wPhGxTNL9wFCgm6TN01lBb2BhiyI2M7OSKuby0U8WDK8FFhdU7TRKUg9gTUoCnYHDge8D9wGfIbtyaDRwW4ujNjOzkikmEdTvTmJrSRtGIuL1RpbrCUxL7QSbATdFxO8kPQ3MkPQd4EngmpaHbWZmpVJMIpgN7AS8AQjoBrycpgWNtBdExBxgUAPlL5C1F5iZ2SagmMbiu4DjI6J7RGxHVlV0S0T0jYiibzAzM7NNUzGJYL+I+EPdSETcCXyifCGZmVklFVM19JqkbwC/IqsKOo3siWVmZtYOFHNG8FmyS0Z/C9wKbJ/KzMysHSjmzuLXgfEAqRfSZRHR4E1gZmbW9jR6RiDpm5I+loa3kHQv8BywWNLhlQrQzMzKq6mqoVOAf6Th0Wne7ckair9b5rjMzKxCmkoEqwuqgI4Cpqe+g+ZRXCOzmZm1AU0lgncl9U9dRRwC/Klg2pblDcvMzCqlqV/248meG9CD7EEyLwJIOpasawgzM2sHGk0EEfEY8LEGyv8A/OGDS5iZWVvUmucRmJlZO+JEYGaWc04EZmY5V9RloJL+g+yB9Rvmj4hryxSTmZlVUDGPqrwO2BWoBdal4gCcCMzM2oFizggGA/3cv5CZWftUTBvBXOAj5Q7EzMyqo5gzgu7A05L+CrxbVxgRnypbVGZmVjHFJIJJ5Q7CzMyqp5jnETxQiUDMzKw6mm0jkDRU0uOS3pK0WtI6ScsrEZyZmZVfMY3FV5A9mvJZoDNwdiozM7N2oKgbyiLiOUkdImId8AtJfylzXGZmViHFJIJ3JH0IqJV0CbAI+HB5wzIzs0oppmro9DTfWOBtYCfgpHIGZWZmlVPMVUMvSeoM9IyIiyoQk5mZVVAxVw0dT9bP0F1pvEbS7UUst5Ok+yTNk/R3SeNT+baS7pb0bHrfZmM/hJmZtV4xVUOTgCHAMoCIqCXribQ5a4GvRMRewFDgXEn9gInAPRGxO3BPGjczsyopJhGsjYg3W7riiFgUEbPT8ApgHtALOAGYlmabBoxo6brNzKx0iup0TtJIoIOk3SVdDrTo8lFJfYBBwGPADhGxCLJkAWzfyDJjJM2SNGvJkiUt2ZyZmbVAMYlgHLA3WYdz04HlwJeK3YCkrYDfAF+KiKLvSI6IqRExOCIG9+jRo9jFzMyshYq5augd4ML0ahFJHcmSwPURcUsqXiypZ0QsktQTeLWl6zUzs9JpNBE0d2VQc91QSxJwDTAvIn5UMOl2YDRwcXq/rehozcys5Jo6IzgA+BdZddBjgFq47gPJbkZ7SlJtKruALAHcJOks4GXg5Bau18zMSqipRPAR4AiyDudGAr8HpkfE34tZcUQ8ROPJ47CWBGlmZuXTaGNxRKyLiLsiYjTZfQDPAfdLGlex6MzMrOyabCyWtAVwHNlZQR/gMuCWppYxM7O2panG4mlAf+BO4KKImFuxqMzMrGKaOiM4nay30T2A87KLgICs3j8iYusyx2ZmZhXQaCKIiGJuNjMzszbOB3szs5xzIjAzyzknAjOznHMiMDPLOScCM7OccyIwM8s5JwIzs5xzIjAzyzknAjOznHMiMDPLOScCM7OccyIwM8s5JwIzs5xzIjAzyzknAjOznHMiMDPLOScCM7OccyIwM8s5JwIzs5xzIjAzyzknAjOznCtbIpD0c0mvSppbULatpLslPZvetynX9s3MrDjlPCP4JXB0vbKJwD0RsTtwTxo3M7MqKlsiiIiZwOv1ik8ApqXhacCIcm3fzMyKU+k2gh0iYhFAet++sRkljZE0S9KsJUuWVCxAM7O82WQbiyNiakQMjojBPXr0qHY4ZmbtVqUTwWJJPQHS+6sV3r6ZmdVT6URwOzA6DY8Gbqvw9s3MrJ5yXj46HXgE2FPSAklnARcDR0h6FjgijZuZWRVtXq4VR8RnG5l0WLm2aWZmLbfJNhabmVllOBGYmeWcE4GZWc45EZiZ5ZwTgZlZzjkRmJnlnBOBmVnOORGYmeWcE4GZWc45EZiZ5ZwTgZlZzjkRmJnlnBOBmVnOORGYmeWcE4GZWc45EZiZ5ZwTgZlZzjkRmJnlnBOBmVnOORGYmeWcE4GZWc45EZiZ5ZwTgZlZzjkRmJnlnBOBmVnOORGYmeWcE4GZWc5VJRFIOlrSPyQ9J2liNWIwM7NMxROBpA7AFOAYoB/wWUn9Kh2HmZllqnFGMAR4LiJeiIjVwAzghCrEYWZmgCKishuUPgMcHRFnp/HTgf0jYmy9+cYAY9LonsA/KhroxukOvFbtINoB78fS8H4snba2L3eJiB7NzbR5JSKpRw2UfSAbRcRUYGr5wyk9SbMiYnC142jrvB9Lw/uxdNrrvqxG1dACYKeC8d7AwirEYWZmVCcRPA7sLqmvpA8BpwK3VyEOMzOjClVDEbFW0ljgj0AH4OcR8fdKx1FmbbJKaxPk/Vga3o+l0y73ZcUbi83MbNPiO4vNzHLOicDMLOecCFpA0s8lvSppbguX21LS7yU9I+nvki4uV4ztQWv3s72fpJ0k3SdpXvq7G1/tmNoiSZ0k/VXS39J+vKjaMZWaE0HL/BI4upXLTo6IjwGDgAMlHVOyqNqfX9L6/WzvWQt8JSL2AoYC57o7l1Z5Fzg0IvYBaoCjJQ2tckwl5UTQAhExE3i9sEzSrpLukvSEpAclfayB5d6JiPvS8GpgNtn9E9aAhvaztVxELIqI2Wl4BTAP6FXdqNqeyLyVRjumV7u6ysaJYONNBcZFxL7AV4GfNjWzpG7A8cA9FYjNDABJfcjORh+rbiRtk6QOkmqBV4G7I6Jd7cdqdDHRbkjaCvgP4NfShp4ztmhi/s2B6cBlEfFC+SM02/B3+hvgSxGxvNrxtEURsQ6oST/kfiupf0S0mzYsJ4KNsxmwLCJqCgtTV9tPpNHbI+KbaXgq8GxEXFrBGC3HJHUkSwLXR8Qt1Y6nrYuIZZLuJ2vDajeJwFVDGyH9unpR0skAyuwTEesioia9vpmmfQfoCnypiiFbjig7Tb0GmBcRP6p2PG2VpB7pTABJnYHDgWeqG1VpORG0gKTpwCPAnpIWSDoLGAWcJelvwN9p4NkKknoDF5I9iGe2pFpJZ1cw9Dalkf1sLXcgcDpwaPqbq5V0bLWDaoN6AvdJmkPWV9rdEfG7KsdUUu5iwsws53xGYGaWc04EZmY550RgZpZzTgRmZjnnRGBmlnNOBJY7kt5qfq4Wr3O+pO7V2LbZxnIiMDPLOXcxYQZIOh74BvAhYCkwKiIWS5oE9CW7qWgPYAJZl87HAK8Ax0fEmrSar0k6JA2PjIjnJPUFbiD7X7urYHtbAbcB25D1ZvmNiLitvJ/SrGE+IzDLPAQMjYhBwAzg6wXTdgWOI7tr/FfAfRExAFiZyussj4ghwBVAXX9SPwGujIj9gH8XzLsK+HREfBw4BPihCnouNKskJwKzTG/gj5KeAr4G7F0w7c70q/8poAPv/bJ/CuhTMN/0gvcD0vCBBeXXFcwr4Lup24I/kz0nYIeSfBKzFnIiMMtcDlyRful/HuhUMO1dgIhYD6yJ9/plWc/7q1ejiOE6o4AewL6p99rF9bZpVjFOBGaZrmR1/gCjW7mOUwreH0nDDwOnpuFR9bb3akSsSe0Ku7TWAwrnAAAAcUlEQVRym2YbzY3FlkdbSlpQMP4jYBLZA4ZeAR4layBuqS0kPUb2A+uzqWw8cEN6cPxvCua9HrhD0iyglnbWrbG1Le591Mws51w1ZGaWc04EZmY550RgZpZzTgRmZjnnRGBmlnNOBGZmOedEYGaWc/8H/PpuQsDVFXEAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "<Figure size 1080x1080 with 0 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "index = np.arange(4)\n",
    "bar_width = 0.35\n",
    "\n",
    "fig, ax = plt.subplots()\n",
    "ridge = ax.bar(index, mse_ridge.values(), bar_width, label=\"Ridge\")\n",
    "lasso = ax.bar(index+bar_width, mse_lasso.values(), bar_width, label=\"Lasso\")\n",
    "\n",
    "ax.set_xlabel('Lambda')\n",
    "ax.set_ylabel('Mean Square Error')\n",
    "ax.set_title('Comparison of Ridge and Lasso')\n",
    "ax.set_xticks(index + bar_width / 2)\n",
    "ax.set_xticklabels([\"1e-2\", \"1\", \"2\", \"3\"])\n",
    "ax.legend()\n",
    "\n",
    "plt.figure(figsize=(15,15))\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}