Terrorist_Attack_Network_Proj.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "ae = pd.read_csv('AE_Nodes_Public_Version2.csv')\n",
    "bali1 = pd.read_csv('Bali1_Nodes_Public_Version2.csv')\n",
    "bali2 = pd.read_csv('Bali2_Nodes_Public_Version2.csv')\n",
    "ce = pd.read_csv('CE_Nodes_Public_Version2.csv')\n",
    "ham = pd.read_csv('Hamburg_Nodes_Public_Version2.csv')\n",
    "mad = pd.read_csv('Madrid_Nodes_Public_Version2.csv')\n",
    "par = pd.read_csv('PAR_Nodes_Public_Version2.csv')\n",
    "sea = pd.read_csv('SEA_Nodes_Public_Version2.csv')\n",
    "viv = pd.read_csv('Vivace_Nodes_Public_Version2.csv')\n",
    "a1 = pd.read_csv('AE_Relations_Public_Version2.csv')\n",
    "b1 = pd.read_csv('Bali1_Relations_Public_Version2.csv')\n",
    "c1 = pd.read_csv('Bali2_Relations_Public_Version2.csv')\n",
    "d1 = pd.read_csv('CE_Relations_Public_Version2.csv')\n",
    "f1 = pd.read_csv('Hamburg_Relations_Public_Version2.csv')\n",
    "h1 = pd.read_csv('Madrid_Relations_Public_Version2.csv')\n",
    "i1 = pd.read_csv('PAR_Relations_Public_Version2.csv')\n",
    "j1 = pd.read_csv('SEA_Relations_Public_Version2.csv')\n",
    "k1 = pd.read_csv('Vivace_Relations_Public_Version2.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/9/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>598</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>1/?/2006</td>\n",
       "      <td>4/?/2008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/29/06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>802</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/5/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1506</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1507</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>9/16/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1509</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1530</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/5/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1534</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>9/?/2004</td>\n",
       "      <td>?/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1541</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>10/?/2004</td>\n",
       "      <td>12/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1553</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/13/04</td>\n",
       "      <td>12/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/30/04</td>\n",
       "      <td>?/?/2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1556</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/27/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1558</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/5/04</td>\n",
       "      <td>?/?/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1561</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/?/2004</td>\n",
       "      <td>3/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1562</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/?/2005</td>\n",
       "      <td>?/?/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/30/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>8/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1574</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/9/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/29/06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1582</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/2/05</td>\n",
       "      <td>?/?/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1590</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/5/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1595</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/26/04</td>\n",
       "      <td>3/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0    177    NaN   red         NaN          NaN        NaN          2   \n",
       "1    577    NaN   red         NaN          NaN     9/9/04          2   \n",
       "2    598    NaN   red    1/?/2006     4/?/2008        NaN          2   \n",
       "3    800    NaN   red         NaN          NaN    4/29/06          2   \n",
       "4    801    NaN   red         NaN          NaN        NaN          2   \n",
       "5    802    NaN   red         NaN          NaN        NaN          2   \n",
       "6   1504    NaN   red     11/5/04          NaN        NaN          2   \n",
       "7   1506    NaN   red    6/?/2005          NaN        NaN          2   \n",
       "8   1507    NaN   red     9/16/04          NaN        NaN          2   \n",
       "9   1509    NaN   red    7/?/2005          NaN        NaN          2   \n",
       "10  1530    NaN   red     11/5/04          NaN        NaN          2   \n",
       "11  1534    NaN   red    9/?/2004     ?/?/2007        NaN          2   \n",
       "12  1541    NaN   red   10/?/2004    12/?/2006        NaN          2   \n",
       "13  1553    NaN   red     7/13/04    12/?/2006        NaN          2   \n",
       "14  1555    NaN   red     6/30/04     ?/?/2011        NaN          2   \n",
       "15  1556    NaN   red     7/27/04          NaN        NaN          2   \n",
       "16  1558    NaN   red     11/5/04     ?/?/2014        NaN          2   \n",
       "17  1561    NaN   red    7/?/2004     3/?/2007        NaN          2   \n",
       "18  1562    NaN   red    6/?/2005     ?/?/2012        NaN          2   \n",
       "19  1563    NaN   red     6/30/04          NaN        NaN          2   \n",
       "20  1570    NaN   red    8/?/2004          NaN        NaN          2   \n",
       "21  1574    NaN   red         NaN          NaN        NaN          2   \n",
       "22  1579    NaN   red         NaN          NaN    11/9/05          2   \n",
       "23  1580    NaN   red         NaN          NaN    4/29/06          2   \n",
       "24  1582    NaN   red      7/2/05     ?/?/2012        NaN          2   \n",
       "25  1590    NaN   red     11/5/04          NaN        NaN          2   \n",
       "26  1595    NaN   red     7/26/04     3/?/2007        NaN          2   \n",
       "\n",
       "    1990_1994  Dataset Number                                     Dataset  \\\n",
       "0           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "1           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "2           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "3           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "4           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "5           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "6           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "7           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "8           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "9           2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "10          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "11          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "12          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "13          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "14          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "15          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "16          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "17          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "18          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "19          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "20          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "21          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "22          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "23          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "24          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "25          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "26          2               1  Australian Embassy Bombing 2004, Indonesia   \n",
       "\n",
       "   Label    Country  City  \n",
       "0     AE  Indonesia   NaN  \n",
       "1     AE  Indonesia   NaN  \n",
       "2     AE  Indonesia   NaN  \n",
       "3     AE  Indonesia   NaN  \n",
       "4     AE  Indonesia   NaN  \n",
       "5     AE  Indonesia   NaN  \n",
       "6     AE  Indonesia   NaN  \n",
       "7     AE  Indonesia   NaN  \n",
       "8     AE  Indonesia   NaN  \n",
       "9     AE  Indonesia   NaN  \n",
       "10    AE  Indonesia   NaN  \n",
       "11    AE  Indonesia   NaN  \n",
       "12    AE  Indonesia   NaN  \n",
       "13    AE  Indonesia   NaN  \n",
       "14    AE  Indonesia   NaN  \n",
       "15    AE  Indonesia   NaN  \n",
       "16    AE  Indonesia   NaN  \n",
       "17    AE  Indonesia   NaN  \n",
       "18    AE  Indonesia   NaN  \n",
       "19    AE  Indonesia   NaN  \n",
       "20    AE  Indonesia   NaN  \n",
       "21    AE  Indonesia   NaN  \n",
       "22    AE  Indonesia   NaN  \n",
       "23    AE  Indonesia   NaN  \n",
       "24    AE  Indonesia   NaN  \n",
       "25    AE  Indonesia   NaN  \n",
       "26    AE  Indonesia   NaN  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ae[\"Dataset Number\"] = 1\n",
    "ae[\"Dataset\"] = \"Australian Embassy Bombing 2004, Indonesia\"\n",
    "ae[\"Label\"] = \"AE\"\n",
    "ae[\"Country\"] = \"Indonesia\"\n",
    "ae[\"City\"] = np.nan\n",
    "ae"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>10/?/2002</td>\n",
       "      <td>6/14/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>?/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>160</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/21/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/6/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>163</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>175</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>176</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>4/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>180</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>9/27/02</td>\n",
       "      <td>3/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>524</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/12/02</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>588</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>590</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/3/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>650</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1503</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/19/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1512</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/26/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1513</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/29/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1529</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>5/7/03</td>\n",
       "      <td>?/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1532</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/4/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3/2/06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1549</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>4/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1576</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/9/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1594</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/21/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1597</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>6/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Bali bombings 2002, Indonesia</td>\n",
       "      <td>Bali 2002</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0    151    NaN   Red   10/?/2002      6/14/06        NaN          2   \n",
       "1    153    NaN   Red    ?/?/2003          NaN        NaN          2   \n",
       "2    155    NaN   Red   12/?/2002          NaN    11/8/08          2   \n",
       "3    160    NaN   Red    11/21/02          NaN    11/8/08          2   \n",
       "4    162    NaN   Red     11/6/02          NaN    11/8/08          2   \n",
       "5    163    NaN   Red     1/13/03          NaN        NaN          2   \n",
       "6    175    NaN   Red         NaN          NaN        NaN          2   \n",
       "7    176    NaN   Red     4/22/03          NaN        NaN          2   \n",
       "8    177    NaN   Red         NaN          NaN        NaN          2   \n",
       "9    180    NaN   Red     9/27/02     3/?/2005        NaN          2   \n",
       "10   183    NaN   Red         NaN          NaN        NaN          2   \n",
       "11   189    NaN   Red         NaN          NaN        NaN          2   \n",
       "12   524    NaN   Red         NaN          NaN   10/12/02          2   \n",
       "13   588    NaN   Red         NaN          NaN        NaN          2   \n",
       "14   590    NaN   Red     12/3/02          NaN        NaN          2   \n",
       "15   650    NaN   Red         NaN          NaN        NaN          2   \n",
       "16  1503    NaN   Red    11/19/02          NaN        NaN          2   \n",
       "17  1512    NaN   Red    11/26/02          NaN        NaN          2   \n",
       "18  1513    NaN   Red    11/29/02          NaN        NaN          2   \n",
       "19  1529    NaN   Red      5/7/03     ?/?/2006        NaN          2   \n",
       "20  1532    NaN   Red     12/4/02          NaN     3/2/06          2   \n",
       "21  1549    NaN   Red     4/22/03          NaN        NaN          2   \n",
       "22  1564    NaN   Red     1/13/03          NaN        NaN          2   \n",
       "23  1576    NaN   Red         NaN          NaN        NaN          2   \n",
       "24  1579    NaN   Red         NaN          NaN    11/9/05          2   \n",
       "25  1594    NaN   Red    11/21/02          NaN        NaN          2   \n",
       "26  1597    NaN   Red    6/?/2003          NaN        NaN          2   \n",
       "\n",
       "    1990_1994  Dataset Number                        Dataset      Label  \\\n",
       "0           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "1           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "2           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "3           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "4           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "5           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "6           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "7           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "8           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "9           2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "10          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "11          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "12          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "13          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "14          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "15          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "16          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "17          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "18          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "19          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "20          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "21          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "22          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "23          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "24          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "25          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "26          2               2  Bali bombings 2002, Indonesia  Bali 2002   \n",
       "\n",
       "      Country  City  \n",
       "0   Indonesia  Bali  \n",
       "1   Indonesia  Bali  \n",
       "2   Indonesia  Bali  \n",
       "3   Indonesia  Bali  \n",
       "4   Indonesia  Bali  \n",
       "5   Indonesia  Bali  \n",
       "6   Indonesia  Bali  \n",
       "7   Indonesia  Bali  \n",
       "8   Indonesia  Bali  \n",
       "9   Indonesia  Bali  \n",
       "10  Indonesia  Bali  \n",
       "11  Indonesia  Bali  \n",
       "12  Indonesia  Bali  \n",
       "13  Indonesia  Bali  \n",
       "14  Indonesia  Bali  \n",
       "15  Indonesia  Bali  \n",
       "16  Indonesia  Bali  \n",
       "17  Indonesia  Bali  \n",
       "18  Indonesia  Bali  \n",
       "19  Indonesia  Bali  \n",
       "20  Indonesia  Bali  \n",
       "21  Indonesia  Bali  \n",
       "22  Indonesia  Bali  \n",
       "23  Indonesia  Bali  \n",
       "24  Indonesia  Bali  \n",
       "25  Indonesia  Bali  \n",
       "26  Indonesia  Bali  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bali1[\"Dataset Number\"] = 2\n",
    "bali1[\"Dataset\"] = \"Bali bombings 2002, Indonesia\"\n",
    "bali1[\"Label\"] = \"Bali 2002\"\n",
    "bali1[\"Country\"] = \"Indonesia\"\n",
    "bali1[\"City\"] = \"Bali\"\n",
    "bali1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>594</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/17/05</td>\n",
       "      <td>8/17/08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>595</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/18/05</td>\n",
       "      <td>1/24/10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>596</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/17/05</td>\n",
       "      <td>5/17/09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/29/06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>810</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/10/05</td>\n",
       "      <td>9/1/14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>812</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/06</td>\n",
       "      <td>1/13/12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>814</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/9/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>815</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/1/05</td>\n",
       "      <td>11/1/20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>816</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/06</td>\n",
       "      <td>1/13/12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/19/06</td>\n",
       "      <td>1/19/18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>819</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/23/05</td>\n",
       "      <td>11/23/14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>820</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/18/06</td>\n",
       "      <td>1/25/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/1/06</td>\n",
       "      <td>11/29/11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>828</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/06</td>\n",
       "      <td>11/29/16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/1/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/1/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>831</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/1/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>834</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/06</td>\n",
       "      <td>11/1/12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>835</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/18/06</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>838</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/1/06</td>\n",
       "      <td>11/29/16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>839</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/9/05</td>\n",
       "      <td>9/7/24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>840</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/9/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/29/06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1605</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Bali bombings 2005, Indonesia</td>\n",
       "      <td>Bali 2005</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0    177    NaN   Red                      NaN        NaN          2   \n",
       "1    594    NaN   Red    11/17/05      8/17/08        NaN          2   \n",
       "2    595    NaN   Red    11/18/05      1/24/10        NaN          2   \n",
       "3    596    NaN   Red    11/17/05      5/17/09        NaN          2   \n",
       "4    800    NaN   Red         NaN          NaN    4/29/06          2   \n",
       "5    810    NaN   Red    11/10/05       9/1/14        NaN          2   \n",
       "6    812    NaN   Red     1/13/06      1/13/12        NaN          2   \n",
       "7    814    NaN   Red     1/13/03          NaN    11/9/05          2   \n",
       "8    815    NaN   Red     11/1/05      11/1/20        NaN          2   \n",
       "9    816    NaN   Red     1/13/06      1/13/12        NaN          2   \n",
       "10   817    NaN   Red     1/19/06      1/19/18        NaN          2   \n",
       "11   819    NaN   Red    11/23/05     11/23/14        NaN          2   \n",
       "12   820    NaN   Red     1/18/06      1/25/06        NaN          2   \n",
       "13   824    NaN   Red      1/1/06     11/29/11        NaN          2   \n",
       "14   828    NaN   Red     1/13/06     11/29/16        NaN          2   \n",
       "15   829    NaN   Red         NaN          NaN    10/1/05          2   \n",
       "16   830    NaN   Red         NaN          NaN    10/1/05          2   \n",
       "17   831    NaN   Red         NaN          NaN    10/1/05          2   \n",
       "18   834    NaN   Red     1/13/06      11/1/12        NaN          2   \n",
       "19   835    NaN   Red     1/18/06                     NaN          2   \n",
       "20   838    NaN   Red      1/1/06     11/29/16        NaN          2   \n",
       "21   839    NaN   Red     11/9/05       9/7/24        NaN          2   \n",
       "22   840    NaN   Red         NaN          NaN        NaN          2   \n",
       "23   841    NaN   Red         NaN          NaN        NaN          2   \n",
       "24  1579    NaN   Red         NaN          NaN    11/9/05          2   \n",
       "25  1580    NaN   Red         NaN          NaN    4/29/06          2   \n",
       "26  1605    NaN   Red         NaN          NaN        NaN          2   \n",
       "\n",
       "    1990_1994  Dataset Number                        Dataset      Label  \\\n",
       "0           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "1           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "2           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "3           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "4           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "5           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "6           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "7           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "8           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "9           2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "10          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "11          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "12          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "13          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "14          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "15          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "16          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "17          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "18          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "19          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "20          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "21          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "22          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "23          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "24          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "25          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "26          2               3  Bali bombings 2005, Indonesia  Bali 2005   \n",
       "\n",
       "      Country  City  \n",
       "0   Indonesia  Bali  \n",
       "1   Indonesia  Bali  \n",
       "2   Indonesia  Bali  \n",
       "3   Indonesia  Bali  \n",
       "4   Indonesia  Bali  \n",
       "5   Indonesia  Bali  \n",
       "6   Indonesia  Bali  \n",
       "7   Indonesia  Bali  \n",
       "8   Indonesia  Bali  \n",
       "9   Indonesia  Bali  \n",
       "10  Indonesia  Bali  \n",
       "11  Indonesia  Bali  \n",
       "12  Indonesia  Bali  \n",
       "13  Indonesia  Bali  \n",
       "14  Indonesia  Bali  \n",
       "15  Indonesia  Bali  \n",
       "16  Indonesia  Bali  \n",
       "17  Indonesia  Bali  \n",
       "18  Indonesia  Bali  \n",
       "19  Indonesia  Bali  \n",
       "20  Indonesia  Bali  \n",
       "21  Indonesia  Bali  \n",
       "22  Indonesia  Bali  \n",
       "23  Indonesia  Bali  \n",
       "24  Indonesia  Bali  \n",
       "25  Indonesia  Bali  \n",
       "26  Indonesia  Bali  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bali2[\"Dataset Number\"] = 3\n",
    "bali2[\"Dataset\"] = \"Bali bombings 2005, Indonesia\"\n",
    "bali2[\"Label\"] = \"Bali 2005\"\n",
    "bali2[\"Country\"] = \"Indonesia\"\n",
    "bali2[\"City\"] = \"Bali\"\n",
    "bali2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>10/?/2002</td>\n",
       "      <td>6/14/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>?/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>160</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/21/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/6/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>163</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>164</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/9/01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>176</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>4/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>180</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>9/27/02</td>\n",
       "      <td>3/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>193</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>8/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>4/27/03</td>\n",
       "      <td>8/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>368</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/?/2001</td>\n",
       "      <td>5/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>373</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>376</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>538</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>539</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>?/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>540</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>6/?2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>5/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>543</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>544</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>545</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2002</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>589</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>?/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>650</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1502</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/21/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1508</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1517</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>5/?/2003</td>\n",
       "      <td>?/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>?/?/2001</td>\n",
       "      <td>6/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1521</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>6/12/03</td>\n",
       "      <td>?/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1527</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/16/01</td>\n",
       "      <td>?/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/01</td>\n",
       "      <td>?/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1559</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>6/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1565</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>2/16/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>?/?/2001</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1573</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1576</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>1577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/25/02</td>\n",
       "      <td>1/15/07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/9/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1588</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1597</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>6/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Christmas Eve bombings 2000, Indonesia</td>\n",
       "      <td>CE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0    151    NaN   Red   10/?/2002      6/14/06        NaN          2   \n",
       "1    153    NaN   Red    ?/?/2003          NaN        NaN          2   \n",
       "2    155    NaN   Red   12/?/2002          NaN    11/8/08          2   \n",
       "3    160    NaN   Red    11/21/02          NaN    11/8/08          2   \n",
       "4    162    NaN   Red     11/6/02          NaN    11/8/08          2   \n",
       "5    163    NaN   Red     1/13/03          NaN        NaN          2   \n",
       "6    164    NaN   Red     12/9/01          NaN        NaN          2   \n",
       "7    176    NaN   Red     4/22/03          NaN        NaN          2   \n",
       "8    180    NaN   Red     9/27/02     3/?/2005        NaN          2   \n",
       "9    183    NaN   Red         NaN          NaN        NaN          2   \n",
       "10   189    NaN   Red         NaN          NaN        NaN          2   \n",
       "11   193    NaN   Red    8/?/2001          NaN        NaN          2   \n",
       "12   365    NaN   Red     4/27/03     8/?/2007        NaN          2   \n",
       "13   368    NaN   Red   12/?/2001     5/?/2006        NaN          2   \n",
       "14   373    NaN   Red   12/?/2001          NaN        NaN          2   \n",
       "15   376    NaN   Red   12/?/2001          NaN        NaN          2   \n",
       "16   538    NaN   Red         NaN          NaN   ?/?/2000          2   \n",
       "17   539    NaN   Red    ?/?/2002          NaN        NaN          2   \n",
       "18   540    NaN   Red     6/?2005          NaN        NaN          2   \n",
       "19   542    NaN   Red     5/22/03          NaN        NaN          2   \n",
       "20   543    NaN   Red         NaN          NaN   ?/?/2000          2   \n",
       "21   544    NaN   Red         NaN          NaN   ?/?/2000          2   \n",
       "22   545    NaN   Red         NaN          NaN   ?/?/2000          2   \n",
       "23   546    NaN   Red         NaN          NaN   ?/?/2002          2   \n",
       "24   589    NaN   Red    ?/?/2002          NaN        NaN          2   \n",
       "25   650    NaN   Red         NaN          NaN        NaN          2   \n",
       "26  1502    NaN   Red     1/21/03          NaN        NaN          2   \n",
       "27  1508    NaN   Red    1/?/2001          NaN        NaN          2   \n",
       "28  1517    NaN   Red    5/?/2003     ?/?/2006        NaN          2   \n",
       "29  1518    NaN   Red    ?/?/2001     6/?/2006        NaN          2   \n",
       "30  1521    NaN   Red     6/12/03     ?/?/2007        NaN          2   \n",
       "31  1527    NaN   Red     1/16/01     ?/?/2005        NaN          2   \n",
       "32  1546    NaN   Red     1/13/01     ?/?/2005        NaN          2   \n",
       "33  1559    NaN   Red    6/?/2003          NaN        NaN          2   \n",
       "34  1564    NaN   Red     1/13/03          NaN        NaN          2   \n",
       "35  1565    NaN   Red     2/16/04          NaN        NaN          2   \n",
       "36  1566    NaN   Red    ?/?/2001     ?/?/2004        NaN          2   \n",
       "37  1568    NaN   Red         NaN          NaN        NaN          2   \n",
       "38  1573    NaN   Red         NaN          NaN        NaN          2   \n",
       "39  1576    NaN   Red         NaN          NaN        NaN          2   \n",
       "40  1577    NaN   Red    11/25/02      1/15/07        NaN          2   \n",
       "41  1579    NaN   Red         NaN          NaN    11/9/05          2   \n",
       "42  1588    NaN   Red    1/?/2001          NaN        NaN          2   \n",
       "43  1597    NaN   Red    6/?/2003          NaN        NaN          2   \n",
       "44  2360    NaN   Red         NaN          NaN        NaN          2   \n",
       "\n",
       "    1990_1994  Dataset Number                                 Dataset Label  \\\n",
       "0           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "1           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "2           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "3           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "4           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "5           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "6           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "7           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "8           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "9           2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "10          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "11          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "12          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "13          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "14          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "15          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "16          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "17          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "18          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "19          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "20          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "21          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "22          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "23          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "24          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "25          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "26          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "27          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "28          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "29          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "30          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "31          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "32          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "33          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "34          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "35          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "36          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "37          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "38          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "39          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "40          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "41          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "42          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "43          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "44          2               4  Christmas Eve bombings 2000, Indonesia    CE   \n",
       "\n",
       "      Country  City  \n",
       "0   Indonesia   NaN  \n",
       "1   Indonesia   NaN  \n",
       "2   Indonesia   NaN  \n",
       "3   Indonesia   NaN  \n",
       "4   Indonesia   NaN  \n",
       "5   Indonesia   NaN  \n",
       "6   Indonesia   NaN  \n",
       "7   Indonesia   NaN  \n",
       "8   Indonesia   NaN  \n",
       "9   Indonesia   NaN  \n",
       "10  Indonesia   NaN  \n",
       "11  Indonesia   NaN  \n",
       "12  Indonesia   NaN  \n",
       "13  Indonesia   NaN  \n",
       "14  Indonesia   NaN  \n",
       "15  Indonesia   NaN  \n",
       "16  Indonesia   NaN  \n",
       "17  Indonesia   NaN  \n",
       "18  Indonesia   NaN  \n",
       "19  Indonesia   NaN  \n",
       "20  Indonesia   NaN  \n",
       "21  Indonesia   NaN  \n",
       "22  Indonesia   NaN  \n",
       "23  Indonesia   NaN  \n",
       "24  Indonesia   NaN  \n",
       "25  Indonesia   NaN  \n",
       "26  Indonesia   NaN  \n",
       "27  Indonesia   NaN  \n",
       "28  Indonesia   NaN  \n",
       "29  Indonesia   NaN  \n",
       "30  Indonesia   NaN  \n",
       "31  Indonesia   NaN  \n",
       "32  Indonesia   NaN  \n",
       "33  Indonesia   NaN  \n",
       "34  Indonesia   NaN  \n",
       "35  Indonesia   NaN  \n",
       "36  Indonesia   NaN  \n",
       "37  Indonesia   NaN  \n",
       "38  Indonesia   NaN  \n",
       "39  Indonesia   NaN  \n",
       "40  Indonesia   NaN  \n",
       "41  Indonesia   NaN  \n",
       "42  Indonesia   NaN  \n",
       "43  Indonesia   NaN  \n",
       "44  Indonesia   NaN  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ce[\"Dataset Number\"] = 4\n",
    "ce[\"Dataset\"] = \"Christmas Eve bombings 2000, Indonesia\"\n",
    "ce[\"Label\"] = \"CE\"\n",
    "ce[\"Country\"] = \"Indonesia\"\n",
    "ce[\"City\"] = np.nan\n",
    "ce"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/10/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1030</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/11/01</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1037</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1035</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1033</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1026</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>64</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>650</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/11/01</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7/?/2002</td>\n",
       "      <td>7/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>62</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/11/01</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1038</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1039</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2003</td>\n",
       "      <td>2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1042</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>The Hamburg 9/11 Cell 2001, Germany</td>\n",
       "      <td>HAM 9/11</td>\n",
       "      <td>Germany</td>\n",
       "      <td>Hamburg</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Group  Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0   1012    NaN    NaN        2001          NaN        NaN          2   \n",
       "1     57    NaN    NaN         NaN          NaN        NaN          2   \n",
       "2     58    NaN    NaN        2005         2005        NaN          2   \n",
       "3   1032    NaN    NaN         NaN          NaN        NaN          2   \n",
       "4   1036    NaN    NaN         NaN          NaN        NaN          2   \n",
       "5     54    NaN    NaN   11/?/2001          NaN        NaN          2   \n",
       "6     61    NaN    NaN    10/10/02          NaN        NaN          2   \n",
       "7     60    NaN    NaN   11/?/2001          NaN        NaN          2   \n",
       "8   1014    NaN    NaN         NaN          NaN        NaN          2   \n",
       "9   1030    NaN    NaN         NaN          NaN        NaN          2   \n",
       "10    63    NaN    NaN         NaN          NaN    9/11/01          2   \n",
       "11  1037    NaN    NaN         NaN          NaN        NaN          2   \n",
       "12  1035    NaN    NaN         NaN          NaN        NaN          2   \n",
       "13  1033    NaN    NaN         NaN          NaN        NaN          2   \n",
       "14  1026    NaN    NaN         NaN          NaN        NaN          2   \n",
       "15    59    NaN    NaN         NaN          NaN        NaN          2   \n",
       "16    64    NaN    NaN    9/?/2002          NaN        NaN          2   \n",
       "17   650    NaN    NaN         NaN          NaN        NaN          2   \n",
       "18  1011    NaN    NaN         NaN          NaN        NaN          2   \n",
       "19    65    NaN    NaN         NaN          NaN    9/11/01          2   \n",
       "20  1015    NaN    NaN         NaN          NaN        NaN          2   \n",
       "21  1034    NaN    NaN    7/?/2002     7/?/2002        NaN          2   \n",
       "22    62    NaN    NaN         NaN          NaN        NaN          2   \n",
       "23    66    NaN    NaN         NaN          NaN    9/11/01          2   \n",
       "24  1016    NaN    NaN         NaN          NaN        NaN          2   \n",
       "25  1017    NaN    NaN         NaN          NaN        NaN          2   \n",
       "26  1038    NaN    NaN         NaN          NaN        NaN          2   \n",
       "27  1039    NaN    NaN         NaN          NaN        NaN          2   \n",
       "28  1040    NaN    NaN         NaN          NaN        NaN          2   \n",
       "29  1031    NaN    NaN        2003         2005        NaN          2   \n",
       "30  1025    NaN    NaN         NaN          NaN        NaN          2   \n",
       "31  1041    NaN    NaN         NaN          NaN        NaN          2   \n",
       "32  1005    NaN    NaN         NaN          NaN        NaN          2   \n",
       "33  1042    NaN    NaN         NaN          NaN        NaN          2   \n",
       "\n",
       "    1990_1994  Dataset Number                              Dataset     Label  \\\n",
       "0           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "1           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "2           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "3           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "4           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "5           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "6           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "7           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "8           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "9           2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "10          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "11          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "12          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "13          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "14          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "15          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "16          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "17          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "18          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "19          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "20          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "21          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "22          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "23          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "24          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "25          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "26          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "27          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "28          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "29          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "30          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "31          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "32          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "33          2               5  The Hamburg 9/11 Cell 2001, Germany  HAM 9/11   \n",
       "\n",
       "    Country     City  \n",
       "0   Germany  Hamburg  \n",
       "1   Germany  Hamburg  \n",
       "2   Germany  Hamburg  \n",
       "3   Germany  Hamburg  \n",
       "4   Germany  Hamburg  \n",
       "5   Germany  Hamburg  \n",
       "6   Germany  Hamburg  \n",
       "7   Germany  Hamburg  \n",
       "8   Germany  Hamburg  \n",
       "9   Germany  Hamburg  \n",
       "10  Germany  Hamburg  \n",
       "11  Germany  Hamburg  \n",
       "12  Germany  Hamburg  \n",
       "13  Germany  Hamburg  \n",
       "14  Germany  Hamburg  \n",
       "15  Germany  Hamburg  \n",
       "16  Germany  Hamburg  \n",
       "17  Germany  Hamburg  \n",
       "18  Germany  Hamburg  \n",
       "19  Germany  Hamburg  \n",
       "20  Germany  Hamburg  \n",
       "21  Germany  Hamburg  \n",
       "22  Germany  Hamburg  \n",
       "23  Germany  Hamburg  \n",
       "24  Germany  Hamburg  \n",
       "25  Germany  Hamburg  \n",
       "26  Germany  Hamburg  \n",
       "27  Germany  Hamburg  \n",
       "28  Germany  Hamburg  \n",
       "29  Germany  Hamburg  \n",
       "30  Germany  Hamburg  \n",
       "31  Germany  Hamburg  \n",
       "32  Germany  Hamburg  \n",
       "33  Germany  Hamburg  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ham[\"Dataset Number\"] = 5\n",
    "ham[\"Dataset\"] = \"The Hamburg 9/11 Cell 2001, Germany\"\n",
    "ham[\"Label\"] = \"HAM 9/11\"\n",
    "ham[\"Country\"] = \"Germany\"\n",
    "ham[\"City\"] = \"Hamburg\"\n",
    "ham"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>11/13/01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3101</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3104</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>11/6/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3106</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>11/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3132</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/3/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>12/7/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3134</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3/30/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3/13/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3136</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>5/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3137</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>5/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3138</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3139</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>4/2/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3140</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>6/8/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3141</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>4/1/97</td>\n",
       "      <td>6/29/02</td>\n",
       "      <td>4/3/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3142</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>11/3/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3143</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>?/?/2003</td>\n",
       "      <td>4/3/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>3145</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/3/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3146</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>4/7/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3147</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/3/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>3148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/3/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3149</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/3/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3150</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3/18/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>3151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>12/2/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3152</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3/24/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3154</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>3155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1/12/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3156</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>3157</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>3158</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>2/1/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>3159</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>2/1/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>3160</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>2/1/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>3161</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>5/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>3162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>8/16/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>3163</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3/30/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>3164</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>4/2/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>3165</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>5/21/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>3166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>5/6/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>3167</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>3168</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>6/10/04</td>\n",
       "      <td>12/15/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>3169</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>6/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>3170</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>6/11/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>3171</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>6/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>3172</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>3173</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>7/1/04</td>\n",
       "      <td>2/15/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>3174</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>3176</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>3177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>3178</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>3179</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>3180</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>4/6/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>3181</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Blue</td>\n",
       "      <td>6/14/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>Madrid Train Bombings 2004, Spain</td>\n",
       "      <td>MAD</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0   3100    NaN  Blue    11/13/01          NaN        NaN          2   \n",
       "1   3101    NaN  Blue         NaN          NaN        NaN          2   \n",
       "2   3104    NaN  Blue     11/6/03          NaN        NaN          2   \n",
       "3   3106    NaN  Blue         NaN          NaN        NaN          2   \n",
       "4    318    NaN  Blue   11/?/2001          NaN        NaN          2   \n",
       "5   3132    NaN  Blue         NaN          NaN     4/3/04          2   \n",
       "6   3133    NaN  Blue     12/7/05          NaN        NaN          2   \n",
       "7   3134    NaN  Blue     3/30/04          NaN        NaN          2   \n",
       "8   3135    NaN  Blue     3/13/04          NaN        NaN          2   \n",
       "9   3136    NaN  Blue    5/?/2003          NaN        NaN          2   \n",
       "10  3137    NaN  Blue    5/?/2003          NaN        NaN          2   \n",
       "11  3138    NaN  Blue         NaN          NaN        NaN          2   \n",
       "12  3139    NaN  Blue      4/2/04          NaN        NaN          2   \n",
       "13  3140    NaN  Blue      6/8/04          NaN        NaN          2   \n",
       "14  3141    NaN  Blue      4/1/97      6/29/02     4/3/04          2   \n",
       "15  3142    NaN  Blue     11/3/04          NaN        NaN          2   \n",
       "16  3143    NaN  Blue         NaN          NaN        NaN          2   \n",
       "17  3144    NaN  Blue    ?/?/2000     ?/?/2003     4/3/04          2   \n",
       "18  3145    NaN  Blue         NaN          NaN     4/3/04          2   \n",
       "19  3146    NaN  Blue      4/7/04          NaN        NaN          2   \n",
       "20  3147    NaN  Blue         NaN          NaN     4/3/04          2   \n",
       "21  3148    NaN  Blue         NaN          NaN     4/3/04          2   \n",
       "22  3149    NaN  Blue         NaN          NaN     4/3/04          2   \n",
       "23  3150    NaN  Blue     3/18/04          NaN        NaN          2   \n",
       "24  3151    NaN  Blue     12/2/04          NaN        NaN          2   \n",
       "25  3152    NaN  Blue     3/24/04          NaN        NaN          2   \n",
       "26  3153    NaN  Blue         NaN          NaN        NaN          2   \n",
       "27  3154    NaN  Blue         NaN          NaN        NaN          2   \n",
       "28  3155    NaN  Blue     1/12/06          NaN        NaN          2   \n",
       "29  3156    NaN  Blue    3/?/2005          NaN        NaN          2   \n",
       "30  3157    NaN  Blue    3/?/2005          NaN        NaN          2   \n",
       "31  3158    NaN  Blue      2/1/05          NaN        NaN          2   \n",
       "32  3159    NaN  Blue      2/1/05          NaN        NaN          2   \n",
       "33  3160    NaN  Blue      2/1/05          NaN        NaN          2   \n",
       "34  3161    NaN  Blue    5/?/2005          NaN        NaN          2   \n",
       "35  3162    NaN  Blue     8/16/05          NaN        NaN          2   \n",
       "36  3163    NaN  Blue     3/30/04          NaN        NaN          2   \n",
       "37  3164    NaN  Blue      4/2/04          NaN        NaN          2   \n",
       "38  3165    NaN  Blue     5/21/04          NaN        NaN          2   \n",
       "39  3166    NaN  Blue      5/6/04          NaN        NaN          2   \n",
       "40  3167    NaN  Blue    ?/?/2004          NaN        NaN          2   \n",
       "41  3168    NaN  Blue     6/10/04     12/15/04        NaN          2   \n",
       "42  3169    NaN  Blue    6/?/2004          NaN        NaN          2   \n",
       "43  3170    NaN  Blue     6/11/04          NaN        NaN          2   \n",
       "44  3171    NaN  Blue    6/?/2004          NaN        NaN          2   \n",
       "45  3172    NaN  Blue    ?/?/2004          NaN        NaN          2   \n",
       "46  3173    NaN  Blue      7/1/04      2/15/05        NaN          2   \n",
       "47  3174    NaN  Blue    ?/?/2004          NaN        NaN          2   \n",
       "48  3176    NaN  Blue    ?/?/2004          NaN        NaN          2   \n",
       "49  3177    NaN  Blue    ?/?/2004          NaN        NaN          2   \n",
       "50  3178    NaN  Blue    ?/?/2004          NaN        NaN          2   \n",
       "51  3179    NaN  Blue         NaN          NaN        NaN          2   \n",
       "52  3180    NaN  Blue      4/6/04          NaN        NaN          2   \n",
       "53  3181    NaN  Blue     6/14/04          NaN        NaN          2   \n",
       "\n",
       "    1990_1994  Dataset Number                            Dataset Label  \\\n",
       "0           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "1           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "2           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "3           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "4           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "5           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "6           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "7           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "8           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "9           2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "10          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "11          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "12          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "13          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "14          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "15          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "16          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "17          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "18          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "19          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "20          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "21          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "22          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "23          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "24          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "25          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "26          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "27          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "28          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "29          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "30          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "31          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "32          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "33          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "34          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "35          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "36          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "37          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "38          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "39          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "40          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "41          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "42          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "43          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "44          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "45          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "46          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "47          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "48          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "49          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "50          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "51          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "52          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "53          2               6  Madrid Train Bombings 2004, Spain   MAD   \n",
       "\n",
       "   Country  City  \n",
       "0    Spain   NaN  \n",
       "1    Spain   NaN  \n",
       "2    Spain   NaN  \n",
       "3    Spain   NaN  \n",
       "4    Spain   NaN  \n",
       "5    Spain   NaN  \n",
       "6    Spain   NaN  \n",
       "7    Spain   NaN  \n",
       "8    Spain   NaN  \n",
       "9    Spain   NaN  \n",
       "10   Spain   NaN  \n",
       "11   Spain   NaN  \n",
       "12   Spain   NaN  \n",
       "13   Spain   NaN  \n",
       "14   Spain   NaN  \n",
       "15   Spain   NaN  \n",
       "16   Spain   NaN  \n",
       "17   Spain   NaN  \n",
       "18   Spain   NaN  \n",
       "19   Spain   NaN  \n",
       "20   Spain   NaN  \n",
       "21   Spain   NaN  \n",
       "22   Spain   NaN  \n",
       "23   Spain   NaN  \n",
       "24   Spain   NaN  \n",
       "25   Spain   NaN  \n",
       "26   Spain   NaN  \n",
       "27   Spain   NaN  \n",
       "28   Spain   NaN  \n",
       "29   Spain   NaN  \n",
       "30   Spain   NaN  \n",
       "31   Spain   NaN  \n",
       "32   Spain   NaN  \n",
       "33   Spain   NaN  \n",
       "34   Spain   NaN  \n",
       "35   Spain   NaN  \n",
       "36   Spain   NaN  \n",
       "37   Spain   NaN  \n",
       "38   Spain   NaN  \n",
       "39   Spain   NaN  \n",
       "40   Spain   NaN  \n",
       "41   Spain   NaN  \n",
       "42   Spain   NaN  \n",
       "43   Spain   NaN  \n",
       "44   Spain   NaN  \n",
       "45   Spain   NaN  \n",
       "46   Spain   NaN  \n",
       "47   Spain   NaN  \n",
       "48   Spain   NaN  \n",
       "49   Spain   NaN  \n",
       "50   Spain   NaN  \n",
       "51   Spain   NaN  \n",
       "52   Spain   NaN  \n",
       "53   Spain   NaN  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mad[\"Dataset Number\"] = 6\n",
    "mad[\"Dataset\"] = \"Madrid Train Bombings 2004, Spain\"\n",
    "mad[\"Label\"] = \"MAD\"\n",
    "mad[\"Country\"] = \"Spain\"\n",
    "mad[\"City\"] = np.nan\n",
    "mad"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>10/?/2002</td>\n",
       "      <td>6/14/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>?/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>159</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2003</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>11/6/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>163</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>193</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>8/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>368</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>12/?/2001</td>\n",
       "      <td>5/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>587</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>650</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1502</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/21/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1549</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>4/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1567</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red</td>\n",
       "      <td>10/?/2002</td>\n",
       "      <td>11/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Philippines Ambassador Residence Bombing 2000,...</td>\n",
       "      <td>PAR</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0    151    NaN   Red   10/?/2002      6/14/06        NaN          2   \n",
       "1    153    NaN   Red    ?/?/2003          NaN        NaN          2   \n",
       "2    155    NaN   Red   12/?/2002          NaN    11/8/08          2   \n",
       "3    159    NaN   Red    1/?/2002          NaN   ?/?/2003          2   \n",
       "4    162    NaN   Red     11/6/02          NaN    11/8/08          2   \n",
       "5    163    NaN   Red     1/13/03          NaN        NaN          2   \n",
       "6    183    NaN   Red         NaN          NaN        NaN          2   \n",
       "7    189    NaN   Red         NaN          NaN        NaN          2   \n",
       "8    193    NaN   Red    8/?/2001          NaN        NaN          2   \n",
       "9    368    NaN   Red   12/?/2001     5/?/2006        NaN          2   \n",
       "10   587    NaN   Red         NaN          NaN        NaN          2   \n",
       "11   650    NaN   Red         NaN          NaN        NaN          2   \n",
       "12  1502    NaN   Red     1/21/03          NaN        NaN          2   \n",
       "13  1549    NaN   Red     4/22/03          NaN        NaN          2   \n",
       "14  1564    NaN   Red     1/13/03          NaN        NaN          2   \n",
       "15  1567    NaN   Red   10/?/2002    11/?/2004        NaN          2   \n",
       "\n",
       "    1990_1994  Dataset Number  \\\n",
       "0           2               7   \n",
       "1           2               7   \n",
       "2           2               7   \n",
       "3           2               7   \n",
       "4           2               7   \n",
       "5           2               7   \n",
       "6           2               7   \n",
       "7           2               7   \n",
       "8           2               7   \n",
       "9           2               7   \n",
       "10          2               7   \n",
       "11          2               7   \n",
       "12          2               7   \n",
       "13          2               7   \n",
       "14          2               7   \n",
       "15          2               7   \n",
       "\n",
       "                                              Dataset Label    Country  \\\n",
       "0   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "1   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "2   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "3   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "4   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "5   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "6   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "7   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "8   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "9   Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "10  Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "11  Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "12  Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "13  Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "14  Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "15  Philippines Ambassador Residence Bombing 2000,...   PAR  Indonesia   \n",
       "\n",
       "       City  \n",
       "0   Jakarta  \n",
       "1   Jakarta  \n",
       "2   Jakarta  \n",
       "3   Jakarta  \n",
       "4   Jakarta  \n",
       "5   Jakarta  \n",
       "6   Jakarta  \n",
       "7   Jakarta  \n",
       "8   Jakarta  \n",
       "9   Jakarta  \n",
       "10  Jakarta  \n",
       "11  Jakarta  \n",
       "12  Jakarta  \n",
       "13  Jakarta  \n",
       "14  Jakarta  \n",
       "15  Jakarta  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "par[\"Dataset Number\"] = 7\n",
    "par[\"Dataset\"] = \"Philippines Ambassador Residence Bombing 2000, Jakarta\"\n",
    "par[\"Label\"] = \"PAR\"\n",
    "par[\"Country\"] = \"Indonesia\"\n",
    "par[\"City\"] = \"Jakarta\"\n",
    "par"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>10/?/2002</td>\n",
       "      <td>6/14/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>153</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>?/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>12/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>159</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>1/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2003</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>160</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/21/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>162</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/6/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/8/08</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>163</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>164</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>12/9/01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>175</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>176</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>4/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>180</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>9/27/02</td>\n",
       "      <td>3/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>193</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>8/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>4/27/03</td>\n",
       "      <td>8/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>368</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>12/?/2001</td>\n",
       "      <td>5/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>373</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>12/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>376</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>12/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>524</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10/12/02</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>538</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>539</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>?/?/2002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>540</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/?2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>5/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>543</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>544</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>545</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?/?/2002</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/9/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>587</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>1546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>1/13/01</td>\n",
       "      <td>?/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>1549</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>4/22/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1553</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/13/04</td>\n",
       "      <td>12/?/2006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>1555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/30/04</td>\n",
       "      <td>?/?/2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1556</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/27/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>1558</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/5/04</td>\n",
       "      <td>?/?/2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1559</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>1561</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/?/2004</td>\n",
       "      <td>3/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1562</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/?/2005</td>\n",
       "      <td>?/?/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>1563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/30/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>1564</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>1/13/03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>1565</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>2/16/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>1566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>?/?/2001</td>\n",
       "      <td>?/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>1567</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>10/?/2002</td>\n",
       "      <td>11/?/2004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>8/?/2004</td>\n",
       "      <td></td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>1573</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>1574</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1576</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>1577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/25/02</td>\n",
       "      <td>1/15/07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>1579</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11/9/05</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>1580</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/29/06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>1582</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/2/05</td>\n",
       "      <td>?/?/2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1588</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>1/?/2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>1590</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/5/04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>1594</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>11/21/02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>1595</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>7/26/04</td>\n",
       "      <td>3/?/2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>1597</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>6/?/2003</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1605</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>2360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Southeast Asian Aggregate Attack Series 2005, ...</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>108 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  \\\n",
       "0     151    NaN   red   10/?/2002      6/14/06        NaN          2   \n",
       "1     153    NaN   red    ?/?/2003          NaN        NaN          2   \n",
       "2     155    NaN   red   12/?/2002          NaN    11/8/08          2   \n",
       "3     159    NaN   red    1/?/2002          NaN   ?/?/2003          2   \n",
       "4     160    NaN   red    11/21/02          NaN    11/8/08          2   \n",
       "5     162    NaN   red     11/6/02          NaN    11/8/08          2   \n",
       "6     163    NaN   red     1/13/03          NaN        NaN          2   \n",
       "7     164    NaN   red     12/9/01          NaN        NaN          2   \n",
       "8     175    NaN   red         NaN          NaN        NaN          2   \n",
       "9     176    NaN   red     4/22/03          NaN        NaN          2   \n",
       "10    177    NaN   red         NaN          NaN        NaN          2   \n",
       "11    180    NaN   red     9/27/02     3/?/2005        NaN          2   \n",
       "12    183    NaN   red         NaN          NaN        NaN          2   \n",
       "13    189    NaN   red         NaN          NaN        NaN          2   \n",
       "14    193    NaN   red    8/?/2001          NaN        NaN          2   \n",
       "15    365    NaN   red     4/27/03     8/?/2007        NaN          2   \n",
       "16    368    NaN   red   12/?/2001     5/?/2006        NaN          2   \n",
       "17    373    NaN   red   12/?/2001          NaN        NaN          2   \n",
       "18    376    NaN   red   12/?/2001          NaN        NaN          2   \n",
       "19    524    NaN   red         NaN          NaN   10/12/02          2   \n",
       "20    538    NaN   red         NaN          NaN   ?/?/2000          2   \n",
       "21    539    NaN   red    ?/?/2002          NaN        NaN          2   \n",
       "22    540    NaN   red     6/?2005          NaN        NaN          2   \n",
       "23    542    NaN   red     5/22/03          NaN        NaN          2   \n",
       "24    543    NaN   red         NaN          NaN   ?/?/2000          2   \n",
       "25    544    NaN   red         NaN          NaN   ?/?/2000          2   \n",
       "26    545    NaN   red         NaN          NaN   ?/?/2000          2   \n",
       "27    546    NaN   red         NaN          NaN   ?/?/2002          2   \n",
       "28    577    NaN   red         NaN          NaN     9/9/04          2   \n",
       "29    587    NaN   red         NaN          NaN        NaN          2   \n",
       "..    ...    ...   ...         ...          ...        ...        ...   \n",
       "78   1546    NaN   red     1/13/01     ?/?/2005        NaN          2   \n",
       "79   1549    NaN   red     4/22/03          NaN        NaN          2   \n",
       "80   1553    NaN   red     7/13/04    12/?/2006        NaN          2   \n",
       "81   1555    NaN   red     6/30/04     ?/?/2011        NaN          2   \n",
       "82   1556    NaN   red     7/27/04          NaN        NaN          2   \n",
       "83   1558    NaN   red     11/5/04     ?/?/2014        NaN          2   \n",
       "84   1559    NaN   red    6/?/2003          NaN        NaN          2   \n",
       "85   1561    NaN   red    7/?/2004     3/?/2007        NaN          2   \n",
       "86   1562    NaN   red    6/?/2005     ?/?/2012        NaN          2   \n",
       "87   1563    NaN   red     6/30/04          NaN        NaN          2   \n",
       "88   1564    NaN   red     1/13/03          NaN        NaN          2   \n",
       "89   1565    NaN   red     2/16/04          NaN        NaN          2   \n",
       "90   1566    NaN   red    ?/?/2001     ?/?/2004        NaN          2   \n",
       "91   1567    NaN   red   10/?/2002    11/?/2004        NaN          2   \n",
       "92   1568    NaN   red         NaN          NaN        NaN          2   \n",
       "93   1570    NaN   red    8/?/2004                     NaN          2   \n",
       "94   1573    NaN   red         NaN          NaN        NaN          2   \n",
       "95   1574    NaN   red         NaN          NaN        NaN          2   \n",
       "96   1576    NaN   red         NaN          NaN        NaN          2   \n",
       "97   1577    NaN   red    11/25/02      1/15/07        NaN          2   \n",
       "98   1579    NaN   red         NaN          NaN    11/9/05          2   \n",
       "99   1580    NaN   red         NaN          NaN    4/29/06          2   \n",
       "100  1582    NaN   red      7/2/05     ?/?/2012        NaN          2   \n",
       "101  1588    NaN   red    1/?/2001          NaN        NaN          2   \n",
       "102  1590    NaN   red     11/5/04          NaN        NaN          2   \n",
       "103  1594    NaN   red    11/21/02          NaN        NaN          2   \n",
       "104  1595    NaN   red     7/26/04     3/?/2007        NaN          2   \n",
       "105  1597    NaN   red    6/?/2003          NaN        NaN          2   \n",
       "106  1605    NaN   red         NaN          NaN        NaN          2   \n",
       "107  2360    NaN   red         NaN          NaN        NaN          2   \n",
       "\n",
       "     1990_1994  Dataset Number  \\\n",
       "0            2               8   \n",
       "1            2               8   \n",
       "2            2               8   \n",
       "3            2               8   \n",
       "4            2               8   \n",
       "5            2               8   \n",
       "6            2               8   \n",
       "7            2               8   \n",
       "8            2               8   \n",
       "9            2               8   \n",
       "10           2               8   \n",
       "11           2               8   \n",
       "12           2               8   \n",
       "13           2               8   \n",
       "14           2               8   \n",
       "15           2               8   \n",
       "16           2               8   \n",
       "17           2               8   \n",
       "18           2               8   \n",
       "19           2               8   \n",
       "20           2               8   \n",
       "21           2               8   \n",
       "22           2               8   \n",
       "23           2               8   \n",
       "24           2               8   \n",
       "25           2               8   \n",
       "26           2               8   \n",
       "27           2               8   \n",
       "28           2               8   \n",
       "29           2               8   \n",
       "..         ...             ...   \n",
       "78           2               8   \n",
       "79           2               8   \n",
       "80           2               8   \n",
       "81           2               8   \n",
       "82           2               8   \n",
       "83           2               8   \n",
       "84           2               8   \n",
       "85           2               8   \n",
       "86           2               8   \n",
       "87           2               8   \n",
       "88           2               8   \n",
       "89           2               8   \n",
       "90           2               8   \n",
       "91           2               8   \n",
       "92           2               8   \n",
       "93           2               8   \n",
       "94           2               8   \n",
       "95           2               8   \n",
       "96           2               8   \n",
       "97           2               8   \n",
       "98           2               8   \n",
       "99           2               8   \n",
       "100          2               8   \n",
       "101          2               8   \n",
       "102          2               8   \n",
       "103          2               8   \n",
       "104          2               8   \n",
       "105          2               8   \n",
       "106          2               8   \n",
       "107          2               8   \n",
       "\n",
       "                                               Dataset Label    Country  City  \n",
       "0    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "1    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "2    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "3    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "4    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "5    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "6    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "7    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "8    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "9    Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "10   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "11   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "12   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "13   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "14   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "15   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "16   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "17   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "18   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "19   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "20   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "21   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "22   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "23   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "24   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "25   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "26   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "27   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "28   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "29   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "..                                                 ...   ...        ...   ...  \n",
       "78   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "79   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "80   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "81   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "82   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "83   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "84   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "85   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "86   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "87   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "88   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "89   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "90   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "91   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "92   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "93   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "94   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "95   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "96   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "97   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "98   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "99   Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "100  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "101  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "102  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "103  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "104  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "105  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "106  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "107  Southeast Asian Aggregate Attack Series 2005, ...   SEA  Indonesia   NaN  \n",
       "\n",
       "[108 rows x 13 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sea[\"Dataset Number\"] = 8\n",
    "sea[\"Dataset\"] = \"Southeast Asian Aggregate Attack Series 2005, Indonesia\"\n",
    "sea[\"Label\"] = \"SEA\"\n",
    "sea[\"Country\"] = \"Indonesia\"\n",
    "sea[\"City\"] = np.nan\n",
    "sea"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3000</td>\n",
       "      <td>1</td>\n",
       "      <td>Orange</td>\n",
       "      <td>7/27/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>Vivace Bombing Cell 7/21/2005, London</td>\n",
       "      <td>VIV</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3001</td>\n",
       "      <td>1</td>\n",
       "      <td>Orange</td>\n",
       "      <td>?/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>Vivace Bombing Cell 7/21/2005, London</td>\n",
       "      <td>VIV</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3002</td>\n",
       "      <td>1</td>\n",
       "      <td>Orange</td>\n",
       "      <td>?/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>Vivace Bombing Cell 7/21/2005, London</td>\n",
       "      <td>VIV</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3003</td>\n",
       "      <td>1</td>\n",
       "      <td>Orange</td>\n",
       "      <td>?/?/2005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>Vivace Bombing Cell 7/21/2005, London</td>\n",
       "      <td>VIV</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>London</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3004</td>\n",
       "      <td>1</td>\n",
       "      <td>Orange</td>\n",
       "      <td>7/29/05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>Vivace Bombing Cell 7/21/2005, London</td>\n",
       "      <td>VIV</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>London</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ID  Group   Color Arrest_Date  Release_Date  Death_Date  1985_1989  \\\n",
       "0  3000      1  Orange     7/27/05           NaN         NaN          2   \n",
       "1  3001      1  Orange    ?/?/2005           NaN         NaN          2   \n",
       "2  3002      1  Orange    ?/?/2005           NaN         NaN          2   \n",
       "3  3003      1  Orange    ?/?/2005           NaN         NaN          2   \n",
       "4  3004      1  Orange     7/29/05           NaN         NaN          2   \n",
       "\n",
       "   1990_1994  Dataset Number                                Dataset Label  \\\n",
       "0          2               9  Vivace Bombing Cell 7/21/2005, London   VIV   \n",
       "1          2               9  Vivace Bombing Cell 7/21/2005, London   VIV   \n",
       "2          2               9  Vivace Bombing Cell 7/21/2005, London   VIV   \n",
       "3          2               9  Vivace Bombing Cell 7/21/2005, London   VIV   \n",
       "4          2               9  Vivace Bombing Cell 7/21/2005, London   VIV   \n",
       "\n",
       "          Country    City  \n",
       "0  United Kingdom  London  \n",
       "1  United Kingdom  London  \n",
       "2  United Kingdom  London  \n",
       "3  United Kingdom  London  \n",
       "4  United Kingdom  London  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "viv[\"Dataset Number\"] = 9\n",
    "viv[\"Dataset\"] = \"Vivace Bombing Cell 7/21/2005, London\"\n",
    "viv[\"Label\"] = \"VIV\"\n",
    "viv[\"Country\"] = \"United Kingdom\"\n",
    "viv[\"City\"] = \"London\"\n",
    "viv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_nodes = pd.concat([ae,bali1,bali2,ce,ham,mad,par,sea,viv],sort=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "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>ID</th>\n",
       "      <th>Group</th>\n",
       "      <th>Color</th>\n",
       "      <th>Arrest_Date</th>\n",
       "      <th>Release_Date</th>\n",
       "      <th>Death_Date</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "      <th>Dataset Number</th>\n",
       "      <th>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Country</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>177</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>577</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9/9/04</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>598</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>1/?/2006</td>\n",
       "      <td>4/?/2008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4/29/06</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>red</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Embassy Bombing 2004, Indonesia</td>\n",
       "      <td>AE</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ID  Group Color Arrest_Date Release_Date Death_Date  1985_1989  1990_1994  \\\n",
       "0  177    NaN   red         NaN          NaN        NaN          2          2   \n",
       "1  577    NaN   red         NaN          NaN     9/9/04          2          2   \n",
       "2  598    NaN   red    1/?/2006     4/?/2008        NaN          2          2   \n",
       "3  800    NaN   red         NaN          NaN    4/29/06          2          2   \n",
       "4  801    NaN   red         NaN          NaN        NaN          2          2   \n",
       "\n",
       "   Dataset Number                                     Dataset Label  \\\n",
       "0               1  Australian Embassy Bombing 2004, Indonesia    AE   \n",
       "1               1  Australian Embassy Bombing 2004, Indonesia    AE   \n",
       "2               1  Australian Embassy Bombing 2004, Indonesia    AE   \n",
       "3               1  Australian Embassy Bombing 2004, Indonesia    AE   \n",
       "4               1  Australian Embassy Bombing 2004, Indonesia    AE   \n",
       "\n",
       "     Country City  \n",
       "0  Indonesia  NaN  \n",
       "1  Indonesia  NaN  \n",
       "2  Indonesia  NaN  \n",
       "3  Indonesia  NaN  \n",
       "4  Indonesia  NaN  "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_nodes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_nodes.to_csv('all_nodes.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>Operation_ID</th>\n",
       "      <th>Op_role</th>\n",
       "      <th>ID</th>\n",
       "      <th>Tie_ID</th>\n",
       "      <th>Tie_Year</th>\n",
       "      <th>Tie_Extinguish</th>\n",
       "      <th>Kinship</th>\n",
       "      <th>1985_1989</th>\n",
       "      <th>1990_1994</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>177</td>\n",
       "      <td>577</td>\n",
       "      <td>2004</td>\n",
       "      <td>2004</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>177</td>\n",
       "      <td>800</td>\n",
       "      <td>2004</td>\n",
       "      <td>2006</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>177</td>\n",
       "      <td>1504</td>\n",
       "      <td>2003</td>\n",
       "      <td>2004</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>177</td>\n",
       "      <td>1507</td>\n",
       "      <td>2004</td>\n",
       "      <td>2004</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>177</td>\n",
       "      <td>1509</td>\n",
       "      <td>2004</td>\n",
       "      <td>2005</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Operation_ID  Op_role   ID  Tie_ID Tie_Year Tie_Extinguish  Kinship  \\\n",
       "0           43      NaN  177     577     2004           2004      0.0   \n",
       "1           43      NaN  177     800     2004           2006      0.0   \n",
       "2           43      NaN  177    1504     2003           2004      0.0   \n",
       "3           43      NaN  177    1507     2004           2004      0.0   \n",
       "4           43      NaN  177    1509     2004           2005      0.0   \n",
       "\n",
       "  1985_1989 1990_1994  \n",
       "0       NaN       NaN  \n",
       "1       NaN       NaN  \n",
       "2       NaN       NaN  \n",
       "3       NaN       NaN  \n",
       "4       NaN       NaN  "
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_relations = pd.concat([a1,b1,c1,d1,f1,h1,i1,j1,k1],sort=False)\n",
    "all_relations.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_relations.to_csv('all_relations.csv')"
   ]
  }
 ],
 "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.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}