3sided_model_v3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\hp\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3398: DtypeWarning: Columns (47) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  exec(code_obj, self.user_global_ns, self.user_ns)\n"
     ]
    }
   ],
   "source": [
    "ISO_OUR_COUNTRY_CODES = ['AFG', 'CAF', 'COD', 'COG', 'COL', 'ETH', 'IRQ', 'JOR', \n",
    "                         'LBN', 'MMR', 'PAK', 'PSE', 'SOM', 'SSD', 'SDN', 'SYR', 'YEM']\n",
    "\n",
    "# нужно для датасета conflicts\n",
    "OUR_COUNTRY_NAMES    = ['Afghanistan', 'Central African Republic', 'DR Congo (Zaire)', 'Congo',\n",
    "                        'Colombia', 'Ethiopia', 'Iraq', 'Jordan',\n",
    "                        'Lebanon', 'Myanmar (Burma)', 'Pakistan', \"Israel: Palestine\",\n",
    "                        'Somalia', 'South Sudan', 'Sudan', 'Syria', 'Yemen (North Yemen)']\n",
    "COUNTRY_ISO          = dict(zip(OUR_COUNTRY_NAMES,ISO_OUR_COUNTRY_CODES)) \n",
    "\n",
    "# в table_long не хватает {'COG', 'PSE', 'SSD', 'SYR'}\n",
    "# general_description_2016 = pd.read_csv('data_3sided_model_(coflict_disaster_gdp)/table_long.csv')\n",
    "gdp_2016                 = pd.read_csv('data_3sided_model_(coflict_disaster_gdp)/gdp_2016.csv')\n",
    "\n",
    "\n",
    "# CBPF_codes_2016          = pd.read_csv('https://raw.githubusercontent.com/kamranuz/nis-network/master/Data/country_codes.csv')\n",
    "disasters_2016           = pd.read_csv('https://raw.githubusercontent.com/kamranuz/nis-network/master/Data/disasters_2016.csv')\n",
    "conflicts                = pd.read_csv('https://raw.githubusercontent.com/kamranuz/nis-network/master/data_3sided_model_(coflict_disaster_gdp)/ged221-csv.zip')\n",
    "population                = pd.read_csv('./data_3sided_model_(coflict_disaster_gdp)/population.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## population"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=0629e467-d7bb-49ec-a04d-eea4ace47881 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('0629e467-d7bb-49ec-a04d-eea4ace47881').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>iso</th>\n",
       "      <th>Country Name</th>\n",
       "      <th>population_2016</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AFG</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>35383028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CAF</td>\n",
       "      <td>Central African Republic</td>\n",
       "      <td>4537683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>COL</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>48175048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>COD</td>\n",
       "      <td>Congo, Dem. Rep.</td>\n",
       "      <td>78789130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>COG</td>\n",
       "      <td>Congo, Rep.</td>\n",
       "      <td>4980996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>SSD</td>\n",
       "      <td>South Sudan</td>\n",
       "      <td>10832520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>SDN</td>\n",
       "      <td>Sudan</td>\n",
       "      <td>39847433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>SYR</td>\n",
       "      <td>Syrian Arab Republic</td>\n",
       "      <td>17465567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PSE</td>\n",
       "      <td>West Bank and Gaza</td>\n",
       "      <td>4367088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>YEM</td>\n",
       "      <td>Yemen, Rep.</td>\n",
       "      <td>27168210</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "    iso              Country Name population_2016\n",
       "0   AFG               Afghanistan        35383028\n",
       "1   CAF  Central African Republic         4537683\n",
       "2   COL                  Colombia        48175048\n",
       "3   COD          Congo, Dem. Rep.        78789130\n",
       "4   COG               Congo, Rep.         4980996\n",
       "5   ETH                  Ethiopia       103603461\n",
       "6   IRQ                      Iraq        36610632\n",
       "7   JOR                    Jordan         9554286\n",
       "8   LBN                   Lebanon         6714281\n",
       "9   MMR                   Myanmar        53045199\n",
       "10  PAK                  Pakistan       203631356\n",
       "11  SOM                   Somalia        14185635\n",
       "12  SSD               South Sudan        10832520\n",
       "13  SDN                     Sudan        39847433\n",
       "14  SYR      Syrian Arab Republic        17465567\n",
       "15  PSE        West Bank and Gaza         4367088\n",
       "16  YEM               Yemen, Rep.        27168210"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "population_2016_our = population[['Country Code', 'Country Name',  '2016 [YR2016]']].dropna().rename(columns={'2016 [YR2016]':'population_2016','Country Code':'iso'})\n",
    "population_2016_our = population_2016_our[population_2016_our['iso'].isin(ISO_OUR_COUNTRY_CODES)].reset_index(drop=True)\n",
    "population_2016_our"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### gdp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "17\n",
      "(17, 3)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><div id=774304dc-3351-496d-84f7-c7877fcbd509 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('774304dc-3351-496d-84f7-c7877fcbd509').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country Name</th>\n",
       "      <th>iso</th>\n",
       "      <th>gdp_2016</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>1.811656e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Central African Republic</td>\n",
       "      <td>CAF</td>\n",
       "      <td>1.825018e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Congo, Dem. Rep.</td>\n",
       "      <td>COD</td>\n",
       "      <td>3.713480e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Congo, Rep.</td>\n",
       "      <td>COG</td>\n",
       "      <td>1.021934e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>2.828250e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Sudan</td>\n",
       "      <td>SDN</td>\n",
       "      <td>1.029437e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>Somalia</td>\n",
       "      <td>SOM</td>\n",
       "      <td>5.529873e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>South Sudan</td>\n",
       "      <td>SSD</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>Syrian Arab Republic</td>\n",
       "      <td>SYR</td>\n",
       "      <td>1.245346e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>Yemen, Rep.</td>\n",
       "      <td>YEM</td>\n",
       "      <td>3.131783e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                 Country Name  iso      gdp_2016\n",
       "2                 Afghanistan  AFG  1.811656e+10\n",
       "34   Central African Republic  CAF  1.825018e+09\n",
       "43           Congo, Dem. Rep.  COD  3.713480e+10\n",
       "44                Congo, Rep.  COG  1.021934e+10\n",
       "45                   Colombia  COL  2.828250e+11\n",
       "72                   Ethiopia  ETH  7.429662e+10\n",
       "113                      Iraq  IRQ  1.666025e+11\n",
       "118                    Jordan  JOR  3.989255e+10\n",
       "130                   Lebanon  LBN  5.114731e+10\n",
       "160                   Myanmar  MMR  6.029174e+10\n",
       "184                  Pakistan  PAK  3.136299e+11\n",
       "196        West Bank and Gaza  PSE  1.540540e+10\n",
       "206                     Sudan  SDN  1.029437e+11\n",
       "213                   Somalia  SOM  5.529873e+09\n",
       "216               South Sudan  SSD  0.000000e+00\n",
       "227      Syrian Arab Republic  SYR  1.245346e+10\n",
       "262               Yemen, Rep.  YEM  3.131783e+10"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdp_2016_our = gdp_2016[gdp_2016['Country Code'].isin(ISO_OUR_COUNTRY_CODES)]\n",
    "gdp_2016_our = gdp_2016_our.rename(columns={'Country Code':'iso','2016':'gdp_2016'})\n",
    "print(len(ISO_OUR_COUNTRY_CODES))\n",
    "print(gdp_2016_our.shape)\n",
    "gdp_2016_our"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### disasters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(533, 50)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Index(['Dis No', 'Year', 'Seq', 'Glide', 'Disaster Group', 'Disaster Subgroup',\n",
       "       'Disaster Type', 'Disaster Subtype', 'Disaster Subsubtype',\n",
       "       'Event Name', 'Country', 'ISO', 'Region', 'Continent', 'Location',\n",
       "       'Origin', 'Associated Dis', 'Associated Dis2', 'OFDA Response',\n",
       "       'Appeal', 'Declaration', 'AID Contribution ('000 US$)', 'Dis Mag Value',\n",
       "       'Dis Mag Scale', 'Latitude', 'Longitude', 'Local Time', 'River Basin',\n",
       "       'Start Year', 'Start Month', 'Start Day', 'End Year', 'End Month',\n",
       "       'End Day', 'Total Deaths', 'No Injured', 'No Affected', 'No Homeless',\n",
       "       'Total Affected', 'Reconstruction Costs ('000 US$)',\n",
       "       'Reconstruction Costs, Adjusted ('000 US$)',\n",
       "       'Insured Damages ('000 US$)', 'Insured Damages, Adjusted ('000 US$)',\n",
       "       'Total Damages ('000 US$)', 'Total Damages, Adjusted ('000 US$)', 'CPI',\n",
       "       'Adm Level', 'Admin1 Code', 'Admin2 Code', 'Geo Locations'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dis_cols = ['Country', 'ISO', 'Disaster Group', 'Total Affected','Total Deaths',\"Total Damages, Adjusted ('000 US$)\"]\n",
    "print(disasters_2016.shape)\n",
    "disasters_2016.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=5667c5a6-a2c7-4c68-af2a-9b3ccbab06f5 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('5667c5a6-a2c7-4c68-af2a-9b3ccbab06f5').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>country</th>\n",
       "      <th>iso</th>\n",
       "      <th>affected_natural</th>\n",
       "      <th>affected_techno</th>\n",
       "      <th>damages_natural</th>\n",
       "      <th>damages_techno</th>\n",
       "      <th>death_natural</th>\n",
       "      <th>death_techno</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>108.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>ALB</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>DZA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Angola</td>\n",
       "      <td>AGO</td>\n",
       "      <td>9899.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>113.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>ARG</td>\n",
       "      <td>85769.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1131264.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Venezuela (Bolivarian Republic of)</td>\n",
       "      <td>VEN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>VNM</td>\n",
       "      <td>2503129.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>955632.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>189.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>YEM</td>\n",
       "      <td>29950.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>60.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>ZMB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>ZWE</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                                country  iso  affected_natural  \\\n",
       "0                           Afghanistan  AFG               0.0   \n",
       "1                               Albania  ALB            4500.0   \n",
       "2                               Algeria  DZA               NaN   \n",
       "3                                Angola  AGO            9899.0   \n",
       "4                             Argentina  ARG           85769.0   \n",
       "..                                  ...  ...               ...   \n",
       "118  Venezuela (Bolivarian Republic of)  VEN               0.0   \n",
       "119                            Viet Nam  VNM         2503129.0   \n",
       "120                               Yemen  YEM           29950.0   \n",
       "121                              Zambia  ZMB               NaN   \n",
       "122                            Zimbabwe  ZWE            2000.0   \n",
       "\n",
       "     affected_techno  damages_natural  damages_techno  death_natural  \\\n",
       "0               20.0              0.0             0.0           84.0   \n",
       "1                NaN              0.0             NaN            2.0   \n",
       "2               24.0              NaN             0.0            NaN   \n",
       "3                NaN              0.0             NaN          113.0   \n",
       "4                NaN        1131264.0             NaN            0.0   \n",
       "..               ...              ...             ...            ...   \n",
       "118             14.0              0.0             0.0            0.0   \n",
       "119              0.0         955632.0             0.0          189.0   \n",
       "120              0.0              0.0             0.0           51.0   \n",
       "121              0.0              NaN             0.0            NaN   \n",
       "122             36.0              0.0             0.0           31.0   \n",
       "\n",
       "     death_techno  \n",
       "0           108.0  \n",
       "1             NaN  \n",
       "2            58.0  \n",
       "3             NaN  \n",
       "4             NaN  \n",
       "..            ...  \n",
       "118          11.0  \n",
       "119          13.0  \n",
       "120          60.0  \n",
       "121          24.0  \n",
       "122          30.0  \n",
       "\n",
       "[123 rows x 8 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# нет данных по {'COG', 'LBN', 'PSE', 'SYR'}\n",
    "df = disasters_2016[dis_cols].fillna(0).groupby(['Country','ISO','Disaster Group']).sum().reset_index()\n",
    "disasters_2016_our = pd.pivot_table(df,values=[\"Total Affected\",\"Total Deaths\",\"Total Damages, Adjusted ('000 US$)\"], index=['Country', 'ISO'], columns=['Disaster Group'])\n",
    "disasters_2016_our = disasters_2016_our.reset_index()\n",
    "disasters_2016_our.columns = ['country','iso','affected_natural','affected_techno','damages_natural','damages_techno','death_natural','death_techno']\n",
    "disasters_2016_our"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### conflicts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(9470, 49)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><div id=ed30ff24-c922-4e9b-9e89-88a36bce2198 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('ed30ff24-c922-4e9b-9e89-88a36bce2198').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>conflict_name</th>\n",
       "      <th>dyad_dset_id</th>\n",
       "      <th>dyad_name</th>\n",
       "      <th>source_article</th>\n",
       "      <th>date_prec</th>\n",
       "      <th>date_start</th>\n",
       "      <th>best</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>189431</th>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>Government of Iraq - IS</td>\n",
       "      <td>\"SOHR,2016-01-13,Clashes in the vicinity of Deir Ezzor airbase, and 4 Syrian ISIS members killed in the countryside of Deir Ezzor\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-01-13 00:00:00.000</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189432</th>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>Government of Iraq - IS</td>\n",
       "      <td>\"Waha Report,2016-02-15,Syria Daily Report 14/02/2016\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-02-14 00:00:00.000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189433</th>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>Government of Iraq - IS</td>\n",
       "      <td>\"Waha Report,2016-02-21,Syria Daily Report 19/02/2016\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-02-19 00:00:00.000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189434</th>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>Government of Iraq - IS</td>\n",
       "      <td>\"SOHR,2016-02-28,Airstrikes target Aleppo countryside and al-Raqqa city\";\"SOHR,2016-03-05,135 , including 32 civilians, were killed in 7 days of military operations in the truce areas\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-02-28 00:00:00.000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189435</th>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>Government of Iraq - IS</td>\n",
       "      <td>\"SOHR,2016-03-05,135 , including 32 civilians, were killed in 7 days of military operations in the truce areas\";\"SOHR,2016-03-03,Coalition airstrikes kill civilians in al-Raqqa, IS clashes with YPG in Hasakah countryside\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-03-02 00:00:00.000</td>\n",
       "      <td>3</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272658</th>\n",
       "      <td>Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-Islam, Jaysh Usud al-Sharqiya, Martyr Lieutenant Ahmed Abdou Brigades, Rahman Corps - IS</td>\n",
       "      <td>16112</td>\n",
       "      <td>Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-Islam, Jaysh Usud al-Sharqiya, Martyr Lieutenant Ahmed Abdou Brigades, Rahman Corps - IS</td>\n",
       "      <td>\"SOHR,2016-12-13,Clashes breakout in eastern Qlamon\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-12-13 00:00:00.000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272659</th>\n",
       "      <td>Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-Islam, Jaysh Usud al-Sharqiya, Martyr Lieutenant Ahmed Abdou Brigades, Rahman Corps - IS</td>\n",
       "      <td>16112</td>\n",
       "      <td>Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-Islam, Jaysh Usud al-Sharqiya, Martyr Lieutenant Ahmed Abdou Brigades, Rahman Corps - IS</td>\n",
       "      <td>\"SOHR,2016-12-24,Clashes in the Eastern Ghouta and the regime forces target the outskirts of the capital and clashes in the countryside of Daraa\";\"SOHR,2016-12-24,Clashes continue in Wadi Barada and clashes and casualties in the Eastern Qalamoun\";\"SOHR,2016-12-25,102 killed yesterday including 23 regime forces\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-12-24 00:00:00.000</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274059</th>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>16317</td>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>\"VDC,2016-01-15,Waleed Rayes al-Ayed Faisal Ismayel al-Hsain al-Jadaan Esmat Saleh al-Khodr al-Hawman Mohammad Hasan al-Shawakh\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-01-15 00:00:00.000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274060</th>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>16317</td>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>\"VDC,2016-01-26,Kamel Khaled al-Ali\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-01-26 00:00:00.000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274061</th>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>16317</td>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>\"VDC,2016-02-20,Mahmoud Modahi al-Hamad\"</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-02-20 00:00:00.000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                                            conflict_name  dyad_dset_id  \\\n",
       "189431                                   Iraq: Government           524   \n",
       "189432                                   Iraq: Government           524   \n",
       "189433                                   Iraq: Government           524   \n",
       "189434                                   Iraq: Government           524   \n",
       "189435                                   Iraq: Government           524   \n",
       "...                                                   ...           ...   \n",
       "272658  Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-...         16112   \n",
       "272659  Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-...         16112   \n",
       "274059            Authenticity and Development Front - IS         16317   \n",
       "274060            Authenticity and Development Front - IS         16317   \n",
       "274061            Authenticity and Development Front - IS         16317   \n",
       "\n",
       "                                                dyad_name  \\\n",
       "189431                            Government of Iraq - IS   \n",
       "189432                            Government of Iraq - IS   \n",
       "189433                            Government of Iraq - IS   \n",
       "189434                            Government of Iraq - IS   \n",
       "189435                            Government of Iraq - IS   \n",
       "...                                                   ...   \n",
       "272658  Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-...   \n",
       "272659  Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-...   \n",
       "274059            Authenticity and Development Front - IS   \n",
       "274060            Authenticity and Development Front - IS   \n",
       "274061            Authenticity and Development Front - IS   \n",
       "\n",
       "                                           source_article  date_prec  \\\n",
       "189431  \"SOHR,2016-01-13,Clashes in the vicinity of De...          1   \n",
       "189432  \"Waha Report,2016-02-15,Syria Daily Report 14/...          1   \n",
       "189433  \"Waha Report,2016-02-21,Syria Daily Report 19/...          1   \n",
       "189434  \"SOHR,2016-02-28,Airstrikes target Aleppo coun...          1   \n",
       "189435  \"SOHR,2016-03-05,135 , including 32 civilians,...          1   \n",
       "...                                                   ...        ...   \n",
       "272658  \"SOHR,2016-12-13,Clashes breakout in eastern Q...          1   \n",
       "272659  \"SOHR,2016-12-24,Clashes in the Eastern Ghouta...          1   \n",
       "274059  \"VDC,2016-01-15,Waleed Rayes al-Ayed Faisal Is...          1   \n",
       "274060               \"VDC,2016-01-26,Kamel Khaled al-Ali\"          1   \n",
       "274061           \"VDC,2016-02-20,Mahmoud Modahi al-Hamad\"          1   \n",
       "\n",
       "                     date_start  best  \n",
       "189431  2016-01-13 00:00:00.000     6  \n",
       "189432  2016-02-14 00:00:00.000     2  \n",
       "189433  2016-02-19 00:00:00.000     4  \n",
       "189434  2016-02-28 00:00:00.000     2  \n",
       "189435  2016-03-02 00:00:00.000     3  \n",
       "...                         ...   ...  \n",
       "272658  2016-12-13 00:00:00.000     2  \n",
       "272659  2016-12-24 00:00:00.000     8  \n",
       "274059  2016-01-15 00:00:00.000     4  \n",
       "274060  2016-01-26 00:00:00.000     1  \n",
       "274061  2016-02-20 00:00:00.000     1  \n",
       "\n",
       "[9470 rows x 7 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print( conflicts_2016_our[conflicts_2016_our.country == 'Syria'].shape)\n",
    "conflicts_2016_our[conflicts_2016_our.country == 'Syria'][[\n",
    "    # 'id', \n",
    "       # 'relid', 'year', 'active_year', 'code_status', 'type_of_violence',\n",
    "       #'conflict_dset_id', 'conflict_new_id', \n",
    "       'conflict_name', 'dyad_dset_id',\n",
    "       #'dyad_new_id', \n",
    "       'dyad_name', \n",
    "       # 'side_a_dset_id', 'side_a_new_id', 'side_a',\n",
    "       #'side_b_dset_id', 'side_b_new_id', 'side_b', 'number_of_sources',\n",
    "       'source_article', \n",
    "       # 'source_office', 'source_date', 'source_headline',\n",
    "       #'source_original', 'where_prec', 'where_coordinates',\n",
    "       #'where_description', 'adm_1', 'adm_2', 'latitude', 'longitude',\n",
    "       #'geom_wkt', 'priogrid_gid', 'country', 'country_id', 'region',\n",
    "    #    'event_clarity', \n",
    "       'date_prec', 'date_start', #'date_end', 'deaths_a','deaths_b', 'deaths_civilians', 'deaths_unknown', \n",
    "       'best', #'high', 'low',\n",
    "    #    'gwnoa', 'gwnob'\n",
    "       ]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=9a1f7e14-393a-439f-9119-d3a6e8b6977a style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('9a1f7e14-393a-439f-9119-d3a6e8b6977a').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>relid</th>\n",
       "      <th>year</th>\n",
       "      <th>active_year</th>\n",
       "      <th>code_status</th>\n",
       "      <th>type_of_violence</th>\n",
       "      <th>conflict_dset_id</th>\n",
       "      <th>conflict_new_id</th>\n",
       "      <th>conflict_name</th>\n",
       "      <th>dyad_dset_id</th>\n",
       "      <th>...</th>\n",
       "      <th>date_end</th>\n",
       "      <th>deaths_a</th>\n",
       "      <th>deaths_b</th>\n",
       "      <th>deaths_civilians</th>\n",
       "      <th>deaths_unknown</th>\n",
       "      <th>best</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>gwnoa</th>\n",
       "      <th>gwnob</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>189431</th>\n",
       "      <td>218010</td>\n",
       "      <td>IRQ-2016-1-524-107</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-01-13 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>645.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189432</th>\n",
       "      <td>217713</td>\n",
       "      <td>IRQ-2016-1-524-108</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-02-14 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>645.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189433</th>\n",
       "      <td>217945</td>\n",
       "      <td>IRQ-2016-1-524-91</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-02-19 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>645.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189434</th>\n",
       "      <td>216636</td>\n",
       "      <td>IRQ-2016-1-524-92</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-02-28 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>645.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189435</th>\n",
       "      <td>216822</td>\n",
       "      <td>IRQ-2016-1-524-94</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-03-02 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>645.0</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",
       "      <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>272658</th>\n",
       "      <td>235158</td>\n",
       "      <td>SYR-2016-2-16112-15</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>16112</td>\n",
       "      <td>14784</td>\n",
       "      <td>Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-Islam, Jaysh Usud al-Sharqiya, Martyr Lieutenant Ahmed Abdou Brigades, Rahman Corps - IS</td>\n",
       "      <td>16112</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-12-13 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272659</th>\n",
       "      <td>233371</td>\n",
       "      <td>SYR-2016-2-16112-36</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>16112</td>\n",
       "      <td>14784</td>\n",
       "      <td>Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-Islam, Jaysh Usud al-Sharqiya, Martyr Lieutenant Ahmed Abdou Brigades, Rahman Corps - IS</td>\n",
       "      <td>16112</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-12-24 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274059</th>\n",
       "      <td>367998</td>\n",
       "      <td>SYR-2016-2-16317-0</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>16317</td>\n",
       "      <td>14959</td>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>16317</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-01-15 00:00:00.000</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274060</th>\n",
       "      <td>368734</td>\n",
       "      <td>SYR-2016-2-16317-1</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>16317</td>\n",
       "      <td>14959</td>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>16317</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-01-26 00:00:00.000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274061</th>\n",
       "      <td>372031</td>\n",
       "      <td>SYR-2016-2-16317-2</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>16317</td>\n",
       "      <td>14959</td>\n",
       "      <td>Authenticity and Development Front - IS</td>\n",
       "      <td>16317</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-02-20 00:00:00.000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "            id                relid  year  active_year code_status  \\\n",
       "189431  218010   IRQ-2016-1-524-107  2016            1       Clear   \n",
       "189432  217713   IRQ-2016-1-524-108  2016            1       Clear   \n",
       "189433  217945    IRQ-2016-1-524-91  2016            1       Clear   \n",
       "189434  216636    IRQ-2016-1-524-92  2016            1       Clear   \n",
       "189435  216822    IRQ-2016-1-524-94  2016            1       Clear   \n",
       "...        ...                  ...   ...          ...         ...   \n",
       "272658  235158  SYR-2016-2-16112-15  2016            1       Clear   \n",
       "272659  233371  SYR-2016-2-16112-36  2016            1       Clear   \n",
       "274059  367998   SYR-2016-2-16317-0  2016            0       Clear   \n",
       "274060  368734   SYR-2016-2-16317-1  2016            0       Clear   \n",
       "274061  372031   SYR-2016-2-16317-2  2016            0       Clear   \n",
       "\n",
       "        type_of_violence  conflict_dset_id  conflict_new_id  \\\n",
       "189431                 1               259              259   \n",
       "189432                 1               259              259   \n",
       "189433                 1               259              259   \n",
       "189434                 1               259              259   \n",
       "189435                 1               259              259   \n",
       "...                  ...               ...              ...   \n",
       "272658                 2             16112            14784   \n",
       "272659                 2             16112            14784   \n",
       "274059                 2             16317            14959   \n",
       "274060                 2             16317            14959   \n",
       "274061                 2             16317            14959   \n",
       "\n",
       "                                            conflict_name  dyad_dset_id  ...  \\\n",
       "189431                                   Iraq: Government           524  ...   \n",
       "189432                                   Iraq: Government           524  ...   \n",
       "189433                                   Iraq: Government           524  ...   \n",
       "189434                                   Iraq: Government           524  ...   \n",
       "189435                                   Iraq: Government           524  ...   \n",
       "...                                                   ...           ...  ...   \n",
       "272658  Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-...         16112  ...   \n",
       "272659  Ahrar al-Sham, Jabhat Fateh al-Sham, Jaysh al-...         16112  ...   \n",
       "274059            Authenticity and Development Front - IS         16317  ...   \n",
       "274060            Authenticity and Development Front - IS         16317  ...   \n",
       "274061            Authenticity and Development Front - IS         16317  ...   \n",
       "\n",
       "                       date_end deaths_a  deaths_b  deaths_civilians  \\\n",
       "189431  2016-01-13 00:00:00.000        0         4                 2   \n",
       "189432  2016-02-14 00:00:00.000        0         2                 0   \n",
       "189433  2016-02-19 00:00:00.000        0         4                 0   \n",
       "189434  2016-02-28 00:00:00.000        0         2                 0   \n",
       "189435  2016-03-02 00:00:00.000        0         0                 3   \n",
       "...                         ...      ...       ...               ...   \n",
       "272658  2016-12-13 00:00:00.000        0         0                 0   \n",
       "272659  2016-12-24 00:00:00.000        0         8                 0   \n",
       "274059  2016-01-15 00:00:00.000        4         0                 0   \n",
       "274060  2016-01-26 00:00:00.000        1         0                 0   \n",
       "274061  2016-02-20 00:00:00.000        1         0                 0   \n",
       "\n",
       "       deaths_unknown  best  high low  gwnoa gwnob  \n",
       "189431              0     6     6   6  645.0   NaN  \n",
       "189432              0     2     2   2  645.0   NaN  \n",
       "189433              0     4     4   4  645.0   NaN  \n",
       "189434              0     2     2   2  645.0   NaN  \n",
       "189435              0     3     3   3  645.0   NaN  \n",
       "...               ...   ...   ...  ..    ...   ...  \n",
       "272658              2     2     2   2    NaN   NaN  \n",
       "272659              0     8     8   8    NaN   NaN  \n",
       "274059              0     4     4   4    NaN   NaN  \n",
       "274060              0     1     1   1    NaN   NaN  \n",
       "274061              0     1     1   1    NaN   NaN  \n",
       "\n",
       "[9470 rows x 49 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "conflicts_2016_our[conflicts_2016_our.country == 'Syria']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "conflicts (293634, 49)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><div id=307a772a-cfe9-4bfc-b2cf-57a471aa5cb2 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('307a772a-cfe9-4bfc-b2cf-57a471aa5cb2').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>relid</th>\n",
       "      <th>year</th>\n",
       "      <th>active_year</th>\n",
       "      <th>code_status</th>\n",
       "      <th>type_of_violence</th>\n",
       "      <th>conflict_dset_id</th>\n",
       "      <th>conflict_new_id</th>\n",
       "      <th>conflict_name</th>\n",
       "      <th>dyad_dset_id</th>\n",
       "      <th>...</th>\n",
       "      <th>date_end</th>\n",
       "      <th>deaths_a</th>\n",
       "      <th>deaths_b</th>\n",
       "      <th>deaths_civilians</th>\n",
       "      <th>deaths_unknown</th>\n",
       "      <th>best</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>gwnoa</th>\n",
       "      <th>gwnob</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>244657</td>\n",
       "      <td>IRQ-2017-1-524-322</td>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>259</td>\n",
       "      <td>259</td>\n",
       "      <td>Iraq: Government</td>\n",
       "      <td>524</td>\n",
       "      <td>...</td>\n",
       "      <td>2017-07-31 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>645</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "       id               relid  year  active_year code_status  \\\n",
       "0  244657  IRQ-2017-1-524-322  2017            1       Clear   \n",
       "\n",
       "   type_of_violence  conflict_dset_id  conflict_new_id     conflict_name  \\\n",
       "0                 1               259              259  Iraq: Government   \n",
       "\n",
       "   dyad_dset_id  ...                 date_end deaths_a  deaths_b  \\\n",
       "0           524  ...  2017-07-31 00:00:00.000        0         4   \n",
       "\n",
       "   deaths_civilians deaths_unknown  best  high low  gwnoa gwnob  \n",
       "0                 0              2     6     6   6    645   NaN  \n",
       "\n",
       "[1 rows x 49 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "conflicts_2016_our (14316, 49)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div><div id=65b3300c-d263-4da7-94f1-7cbf89b0e4c7 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('65b3300c-d263-4da7-94f1-7cbf89b0e4c7').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>relid</th>\n",
       "      <th>year</th>\n",
       "      <th>active_year</th>\n",
       "      <th>code_status</th>\n",
       "      <th>type_of_violence</th>\n",
       "      <th>conflict_dset_id</th>\n",
       "      <th>conflict_new_id</th>\n",
       "      <th>conflict_name</th>\n",
       "      <th>dyad_dset_id</th>\n",
       "      <th>...</th>\n",
       "      <th>date_end</th>\n",
       "      <th>deaths_a</th>\n",
       "      <th>deaths_b</th>\n",
       "      <th>deaths_civilians</th>\n",
       "      <th>deaths_unknown</th>\n",
       "      <th>best</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>gwnoa</th>\n",
       "      <th>gwnob</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>224766</td>\n",
       "      <td>AFG-2016-1-412-0</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>333</td>\n",
       "      <td>333</td>\n",
       "      <td>Afghanistan: Government</td>\n",
       "      <td>726</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-01-30 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>700</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>229861</td>\n",
       "      <td>AFG-2016-1-412-2.1</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>333</td>\n",
       "      <td>333</td>\n",
       "      <td>Afghanistan: Government</td>\n",
       "      <td>726</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-08-07 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>700</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>236473</td>\n",
       "      <td>AFG-2016-1-412-2.2</td>\n",
       "      <td>2016</td>\n",
       "      <td>0</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>333</td>\n",
       "      <td>333</td>\n",
       "      <td>Afghanistan: Government</td>\n",
       "      <td>726</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-08-07 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>700</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18037</th>\n",
       "      <td>210703</td>\n",
       "      <td>AFG-2016-1-327-4.2</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>333</td>\n",
       "      <td>333</td>\n",
       "      <td>Afghanistan: Government</td>\n",
       "      <td>735</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-01-04 00:00:00.000</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>700</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18038</th>\n",
       "      <td>224713</td>\n",
       "      <td>AFG-2016-1-327-51</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>1</td>\n",
       "      <td>333</td>\n",
       "      <td>333</td>\n",
       "      <td>Afghanistan: Government</td>\n",
       "      <td>735</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-01-19 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>230</td>\n",
       "      <td>0</td>\n",
       "      <td>700</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",
       "      <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>293440</th>\n",
       "      <td>227563</td>\n",
       "      <td>BNG-2016-2-14611-18</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>14611</td>\n",
       "      <td>13597</td>\n",
       "      <td>IS - Forces of Hadi</td>\n",
       "      <td>14611</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-08-29 00:00:00.000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>71</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>72</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293441</th>\n",
       "      <td>229568</td>\n",
       "      <td>BNG-2016-2-14611-19</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>14611</td>\n",
       "      <td>13597</td>\n",
       "      <td>IS - Forces of Hadi</td>\n",
       "      <td>14611</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-09-30 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293442</th>\n",
       "      <td>308552</td>\n",
       "      <td>AFG-2016-2-14611-5</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>14611</td>\n",
       "      <td>13597</td>\n",
       "      <td>IS - Forces of Hadi</td>\n",
       "      <td>14611</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-11-30 00:00:00.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293443</th>\n",
       "      <td>233570</td>\n",
       "      <td>AFG-2016-2-14611-0</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>14611</td>\n",
       "      <td>13597</td>\n",
       "      <td>IS - Forces of Hadi</td>\n",
       "      <td>14611</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-12-10 00:00:00.000</td>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>57</td>\n",
       "      <td>49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293444</th>\n",
       "      <td>233572</td>\n",
       "      <td>AFG-2016-2-14611-1</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>Clear</td>\n",
       "      <td>2</td>\n",
       "      <td>14611</td>\n",
       "      <td>13597</td>\n",
       "      <td>IS - Forces of Hadi</td>\n",
       "      <td>14611</td>\n",
       "      <td>...</td>\n",
       "      <td>2016-12-18 00:00:00.000</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "            id                relid  year  active_year code_status  \\\n",
       "384     224766     AFG-2016-1-412-0  2016            0       Clear   \n",
       "385     229861   AFG-2016-1-412-2.1  2016            0       Clear   \n",
       "386     236473   AFG-2016-1-412-2.2  2016            0       Clear   \n",
       "18037   210703   AFG-2016-1-327-4.2  2016            1       Clear   \n",
       "18038   224713    AFG-2016-1-327-51  2016            1       Clear   \n",
       "...        ...                  ...   ...          ...         ...   \n",
       "293440  227563  BNG-2016-2-14611-18  2016            1       Clear   \n",
       "293441  229568  BNG-2016-2-14611-19  2016            1       Clear   \n",
       "293442  308552   AFG-2016-2-14611-5  2016            1       Clear   \n",
       "293443  233570   AFG-2016-2-14611-0  2016            1       Clear   \n",
       "293444  233572   AFG-2016-2-14611-1  2016            1       Clear   \n",
       "\n",
       "        type_of_violence  conflict_dset_id  conflict_new_id  \\\n",
       "384                    1               333              333   \n",
       "385                    1               333              333   \n",
       "386                    1               333              333   \n",
       "18037                  1               333              333   \n",
       "18038                  1               333              333   \n",
       "...                  ...               ...              ...   \n",
       "293440                 2             14611            13597   \n",
       "293441                 2             14611            13597   \n",
       "293442                 2             14611            13597   \n",
       "293443                 2             14611            13597   \n",
       "293444                 2             14611            13597   \n",
       "\n",
       "                  conflict_name  dyad_dset_id  ...                 date_end  \\\n",
       "384     Afghanistan: Government           726  ...  2016-01-30 00:00:00.000   \n",
       "385     Afghanistan: Government           726  ...  2016-08-07 00:00:00.000   \n",
       "386     Afghanistan: Government           726  ...  2016-08-07 00:00:00.000   \n",
       "18037   Afghanistan: Government           735  ...  2016-01-04 00:00:00.000   \n",
       "18038   Afghanistan: Government           735  ...  2016-01-19 00:00:00.000   \n",
       "...                         ...           ...  ...                      ...   \n",
       "293440      IS - Forces of Hadi         14611  ...  2016-08-29 00:00:00.000   \n",
       "293441      IS - Forces of Hadi         14611  ...  2016-09-30 00:00:00.000   \n",
       "293442      IS - Forces of Hadi         14611  ...  2016-11-30 00:00:00.000   \n",
       "293443      IS - Forces of Hadi         14611  ...  2016-12-10 00:00:00.000   \n",
       "293444      IS - Forces of Hadi         14611  ...  2016-12-18 00:00:00.000   \n",
       "\n",
       "       deaths_a  deaths_b  deaths_civilians deaths_unknown  best  high low  \\\n",
       "384           0         0                 0              0     0     1   0   \n",
       "385           0         1                 0              0     1     1   1   \n",
       "386           0         1                 0              0     1     1   1   \n",
       "18037         2         0                 0              0     2     3   2   \n",
       "18038         0         0                 0              0     0   230   0   \n",
       "...         ...       ...               ...            ...   ...   ...  ..   \n",
       "293440        1         0                 0             71    72    72  72   \n",
       "293441        0         1                 0              0     1     1   1   \n",
       "293442        0         1                 0              0     1     1   1   \n",
       "293443        1        48                 0              0    49    57  49   \n",
       "293444        1        52                 0              0    53    53  53   \n",
       "\n",
       "        gwnoa gwnob  \n",
       "384       700   NaN  \n",
       "385       700   NaN  \n",
       "386       700   NaN  \n",
       "18037     700   NaN  \n",
       "18038     700   NaN  \n",
       "...       ...   ...  \n",
       "293440    NaN   NaN  \n",
       "293441    NaN   NaN  \n",
       "293442    NaN   NaN  \n",
       "293443    NaN   NaN  \n",
       "293444    NaN   NaN  \n",
       "\n",
       "[14316 rows x 49 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "cols_conf = ['country','country_id','year','deaths_civilians','best']\n",
    "print('conflicts',conflicts.shape)\n",
    "display(conflicts.head(1))\n",
    "\n",
    "conflicts_2016 = conflicts[cols_conf][conflicts.year == 2016]\n",
    "conflicts_2016_our = conflicts_2016[conflicts_2016.country.isin(OUR_COUNTRY_NAMES)]\n",
    "# conflicts_2016_our = conflicts_2016_our.groupby(['country', 'country_id', 'year']).agg({'best':['sum','count'],'deaths_civilians':['sum']}).reset_index()#.sum().reset_index()\n",
    "# conflicts_2016_our.columns = ['iso','country_id','year','death_total','conf_count','deaths_civilians']\n",
    "# ## conflicts_2016_our['iso'] = conflicts_2016_our.country\n",
    "# conflicts_2016_our = conflicts_2016_our.replace({'iso':COUNTRY_ISO})\n",
    "# ## conflicts_2016_our = conflicts_2016_our.rename(columns={'best':'death_total'})\n",
    "print('conflicts_2016_our', conflicts_2016_our.shape)\n",
    "display(conflicts_2016_our)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### gdp + disasters + conflicts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=56247ba9-bd5d-4e5d-ba7a-2a8e15c60e01 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('56247ba9-bd5d-4e5d-ba7a-2a8e15c60e01').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>iso</th>\n",
       "      <th>Country Name</th>\n",
       "      <th>gdp_2016</th>\n",
       "      <th>population_2016</th>\n",
       "      <th>affected_natural</th>\n",
       "      <th>affected_techno</th>\n",
       "      <th>death_natural</th>\n",
       "      <th>death_techno</th>\n",
       "      <th>damages_natural</th>\n",
       "      <th>damages_techno</th>\n",
       "      <th>deaths_civilians</th>\n",
       "      <th>death_total</th>\n",
       "      <th>conf_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016</td>\n",
       "      <td>AFG</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>1.811656e+10</td>\n",
       "      <td>35383028</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1084.0</td>\n",
       "      <td>18719.0</td>\n",
       "      <td>2424.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016</td>\n",
       "      <td>CAF</td>\n",
       "      <td>Central African Republic</td>\n",
       "      <td>1.825018e+09</td>\n",
       "      <td>4537683</td>\n",
       "      <td>266.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>511.0</td>\n",
       "      <td>688.0</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016</td>\n",
       "      <td>COD</td>\n",
       "      <td>Congo, Dem. Rep.</td>\n",
       "      <td>3.713480e+10</td>\n",
       "      <td>78789130</td>\n",
       "      <td>15273.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>737.0</td>\n",
       "      <td>2194.0</td>\n",
       "      <td>211.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016</td>\n",
       "      <td>COG</td>\n",
       "      <td>Congo, Rep.</td>\n",
       "      <td>1.021934e+10</td>\n",
       "      <td>4980996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016</td>\n",
       "      <td>COL</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>2.828250e+11</td>\n",
       "      <td>48175048</td>\n",
       "      <td>2284.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2016</td>\n",
       "      <td>PAK</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>3.136299e+11</td>\n",
       "      <td>203631356</td>\n",
       "      <td>11095.0</td>\n",
       "      <td>526.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>252.0</td>\n",
       "      <td>2258.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>384.0</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>158.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2016</td>\n",
       "      <td>SDN</td>\n",
       "      <td>Sudan</td>\n",
       "      <td>1.029437e+11</td>\n",
       "      <td>39847433</td>\n",
       "      <td>200636.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>790.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>249.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2016</td>\n",
       "      <td>SOM</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>5.529873e+09</td>\n",
       "      <td>14185635</td>\n",
       "      <td>14165.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>506.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>318.0</td>\n",
       "      <td>2065.0</td>\n",
       "      <td>376.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2016</td>\n",
       "      <td>SYR</td>\n",
       "      <td>Syrian Arab Republic</td>\n",
       "      <td>1.245346e+10</td>\n",
       "      <td>17465567</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14290.0</td>\n",
       "      <td>53863.0</td>\n",
       "      <td>9470.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2016</td>\n",
       "      <td>YEM</td>\n",
       "      <td>Yemen, Rep.</td>\n",
       "      <td>3.131783e+10</td>\n",
       "      <td>27168210</td>\n",
       "      <td>29950.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>3948.0</td>\n",
       "      <td>316.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "    year  iso              Country Name      gdp_2016 population_2016  \\\n",
       "0   2016  AFG               Afghanistan  1.811656e+10        35383028   \n",
       "1   2016  CAF  Central African Republic  1.825018e+09         4537683   \n",
       "2   2016  COD          Congo, Dem. Rep.  3.713480e+10        78789130   \n",
       "3   2016  COG               Congo, Rep.  1.021934e+10         4980996   \n",
       "4   2016  COL                  Colombia  2.828250e+11        48175048   \n",
       "5   2016  ETH                  Ethiopia  7.429662e+10       103603461   \n",
       "6   2016  IRQ                      Iraq  1.666025e+11        36610632   \n",
       "7   2016  JOR                    Jordan  3.989255e+10         9554286   \n",
       "8   2016  LBN                   Lebanon  5.114731e+10         6714281   \n",
       "9   2016  MMR                   Myanmar  6.029174e+10        53045199   \n",
       "10  2016  PAK                  Pakistan  3.136299e+11       203631356   \n",
       "11  2016  SDN                     Sudan  1.029437e+11        39847433   \n",
       "12  2016  SOM                   Somalia  5.529873e+09        14185635   \n",
       "13  2016  SYR      Syrian Arab Republic  1.245346e+10        17465567   \n",
       "14  2016  YEM               Yemen, Rep.  3.131783e+10        27168210   \n",
       "\n",
       "    affected_natural  affected_techno  death_natural  death_techno  \\\n",
       "0                0.0             20.0           84.0         108.0   \n",
       "1              266.0              NaN           21.0           NaN   \n",
       "2            15273.0             22.0          105.0          57.0   \n",
       "3                NaN              NaN            NaN           NaN   \n",
       "4             2284.0              6.0           10.0         140.0   \n",
       "5           493080.0              9.0          128.0          75.0   \n",
       "6                NaN              0.0            NaN          11.0   \n",
       "7                NaN             36.0            NaN          14.0   \n",
       "8                NaN              NaN            NaN           NaN   \n",
       "9           953350.0            154.0          131.0         106.0   \n",
       "10           11095.0            526.0          409.0         252.0   \n",
       "11          200636.0             29.0          190.0          16.0   \n",
       "12           14165.0              0.0          506.0         106.0   \n",
       "13               NaN              NaN            NaN           NaN   \n",
       "14           29950.0              0.0           51.0          60.0   \n",
       "\n",
       "    damages_natural  damages_techno  deaths_civilians  death_total  conf_count  \n",
       "0               0.0             0.0            1084.0      18719.0      2424.0  \n",
       "1               0.0             NaN             511.0        688.0        70.0  \n",
       "2               0.0             0.0             737.0       2194.0       211.0  \n",
       "3               NaN             NaN              42.0         73.0         8.0  \n",
       "4               0.0             0.0               3.0         38.0        16.0  \n",
       "5               0.0             0.0             451.0        529.0       148.0  \n",
       "6               NaN             0.0            4489.0      12025.0       726.0  \n",
       "7               NaN             0.0               3.0         37.0         5.0  \n",
       "8               NaN             NaN               5.0         56.0        13.0  \n",
       "9           18741.0             0.0              64.0        183.0        57.0  \n",
       "10           2258.0             0.0             384.0       1100.0       158.0  \n",
       "11              0.0             0.0             790.0       1994.0       249.0  \n",
       "12              0.0             0.0             318.0       2065.0       376.0  \n",
       "13              NaN             NaN           14290.0      53863.0      9470.0  \n",
       "14              0.0             0.0             647.0       3948.0       316.0  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all = gdp_2016_our.merge(disasters_2016_our,left_on='iso',right_on='iso',how='left', suffixes=('', '_y'))\n",
    "df_all = df_all.drop(df_all.filter(regex='_y$').columns, axis=1)\n",
    "\n",
    "df_all = df_all.merge(conflicts_2016_our,left_on='iso',right_on='iso',how='left', suffixes=('', '_y'))\n",
    "df_all = df_all.drop(df_all.filter(regex='_y$').columns, axis=1)\n",
    "\n",
    "df_all = df_all.merge(population_2016_our,left_on='iso',right_on='iso',how='left', suffixes=('', '_y'))\n",
    "df_all = df_all.drop(df_all.filter(regex='_y$').columns, axis=1)\n",
    "\n",
    "df_all = df_all[['year', 'iso','Country Name', \n",
    "                'gdp_2016', 'population_2016',\n",
    "                'affected_natural', 'affected_techno', 'death_natural','death_techno','damages_natural', 'damages_techno',\n",
    "                'deaths_civilians', 'death_total','conf_count']]\n",
    "\n",
    "df_all.year = 2016\n",
    "df_all = df_all[~(df_all.iso.isin(['PSE','SSD']))].reset_index(drop=True)\n",
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_all.to_csv('data_3sided_model_(coflict_disaster_gdp)/3sided_model_countries.csv',index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### conflicts and disasters analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'relid', 'year', 'active_year', 'code_status', 'type_of_violence',\n",
       "       'conflict_dset_id', 'conflict_new_id', 'conflict_name', 'dyad_dset_id',\n",
       "       'dyad_new_id', 'dyad_name', 'side_a_dset_id', 'side_a_new_id', 'side_a',\n",
       "       'side_b_dset_id', 'side_b_new_id', 'side_b', 'number_of_sources',\n",
       "       'source_article', 'source_office', 'source_date', 'source_headline',\n",
       "       'source_original', 'where_prec', 'where_coordinates',\n",
       "       'where_description', 'adm_1', 'adm_2', 'latitude', 'longitude',\n",
       "       'geom_wkt', 'priogrid_gid', 'country', 'country_id', 'region',\n",
       "       'event_clarity', 'date_prec', 'date_start', 'date_end', 'deaths_a',\n",
       "       'deaths_b', 'deaths_civilians', 'deaths_unknown', 'best', 'high', 'low',\n",
       "       'gwnoa', 'gwnob'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "conflicts.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><div id=13178836-40c5-473f-ac86-3d37e01e3275 style=\"display:none; background-color:#9D6CFF; color:white; width:200px; height:30px; padding-left:5px; border-radius:4px; flex-direction:row; justify-content:space-around; align-items:center;\" onmouseover=\"this.style.backgroundColor='#BA9BF8'\" onmouseout=\"this.style.backgroundColor='#9D6CFF'\" onclick=\"window.commands?.execute('create-mitosheet-from-dataframe-output');\">See Full Dataframe in Mito</div> <script> if (window.commands?.hasCommand('create-mitosheet-from-dataframe-output')) document.getElementById('13178836-40c5-473f-ac86-3d37e01e3275').style.display = 'flex' </script> <table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>qty_conf</th>\n",
       "      <th>death_total</th>\n",
       "      <th>deaths_civilians</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>region</th>\n",
       "      <th>country</th>\n",
       "      <th>dyad_name</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Africa</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">Central African Republic</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">3R - Civilians</th>\n",
       "      <th>6.714140</th>\n",
       "      <th>15.351430</th>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.779093</th>\n",
       "      <th>15.293645</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.845106</th>\n",
       "      <th>15.181429</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.936024</th>\n",
       "      <th>15.449854</th>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.983333</th>\n",
       "      <th>15.650000</th>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Middle East</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">Yemen (North Yemen)</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">IS - Forces of Hadi</th>\n",
       "      <th>12.779444</th>\n",
       "      <th>45.036667</th>\n",
       "      <td>16</td>\n",
       "      <td>293</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13.056667</th>\n",
       "      <th>44.881944</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13.166667</th>\n",
       "      <th>44.583332</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14.542481</th>\n",
       "      <th>49.124244</th>\n",
       "      <td>3</td>\n",
       "      <td>111</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16.000000</th>\n",
       "      <th>49.000000</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table></div>"
      ],
      "text/plain": [
       "                                                                              qty_conf  \\\n",
       "region      country                  dyad_name           latitude  longitude             \n",
       "Africa      Central African Republic 3R - Civilians      6.714140  15.351430         1   \n",
       "                                                         6.779093  15.293645         1   \n",
       "                                                         6.845106  15.181429         1   \n",
       "                                                         6.936024  15.449854         1   \n",
       "                                                         6.983333  15.650000         1   \n",
       "...                                                                                ...   \n",
       "Middle East Yemen (North Yemen)      IS - Forces of Hadi 12.779444 45.036667        16   \n",
       "                                                         13.056667 44.881944         1   \n",
       "                                                         13.166667 44.583332         1   \n",
       "                                                         14.542481 49.124244         3   \n",
       "                                                         16.000000 49.000000         1   \n",
       "\n",
       "                                                                              death_total  \\\n",
       "region      country                  dyad_name           latitude  longitude                \n",
       "Africa      Central African Republic 3R - Civilians      6.714140  15.351430           14   \n",
       "                                                         6.779093  15.293645            2   \n",
       "                                                         6.845106  15.181429            2   \n",
       "                                                         6.936024  15.449854           17   \n",
       "                                                         6.983333  15.650000           15   \n",
       "...                                                                                   ...   \n",
       "Middle East Yemen (North Yemen)      IS - Forces of Hadi 12.779444 45.036667          293   \n",
       "                                                         13.056667 44.881944            3   \n",
       "                                                         13.166667 44.583332            3   \n",
       "                                                         14.542481 49.124244          111   \n",
       "                                                         16.000000 49.000000            5   \n",
       "\n",
       "                                                                              deaths_civilians  \n",
       "region      country                  dyad_name           latitude  longitude                    \n",
       "Africa      Central African Republic 3R - Civilians      6.714140  15.351430                14  \n",
       "                                                         6.779093  15.293645                 2  \n",
       "                                                         6.845106  15.181429                 2  \n",
       "                                                         6.936024  15.449854                17  \n",
       "                                                         6.983333  15.650000                15  \n",
       "...                                                                                        ...  \n",
       "Middle East Yemen (North Yemen)      IS - Forces of Hadi 12.779444 45.036667                 1  \n",
       "                                                         13.056667 44.881944                 1  \n",
       "                                                         13.166667 44.583332                 0  \n",
       "                                                         14.542481 49.124244                 2  \n",
       "                                                         16.000000 49.000000                 0  \n",
       "\n",
       "[3780 rows x 3 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "conf_analysis = (conflicts[(conflicts.year == 2016) & (conflicts.country.isin(OUR_COUNTRY_NAMES))].groupby(['region','country','dyad_name','latitude', 'longitude'])[['deaths_civilians','best']]\n",
    "                                                                                  .agg({'best':['count','sum'],'deaths_civilians':['sum']}))\n",
    "conf_analysis.columns = ['qty_conf','death_total','deaths_civilians']\n",
    "\n",
    "\n",
    "conf_analysis.to_csv('data_3sided_model_(coflict_disaster_gdp)/analysis_conf.csv')\n",
    "conf_analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "conf_analysis"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.5 64-bit",
   "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.10.5"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "63963b3f4c440940f0b94a3100916033a226cb4f45979123153792d60aa56d6a"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}