AsiaConflictClean.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "AsiaConflictClean.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyMAT38ZhoPX/DAlpQsUBQ7Y",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/kvinne-anc/Conflict-and-Climate-Project/blob/main/AsiaConflictClean.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oEC6ugcSH__5"
      },
      "source": [
        "import pandas as pd\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "stKqhDxdIF0d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 387
        },
        "outputId": "e386c326-ab68-4973-e7dc-663c3808c3c9"
      },
      "source": [
        "conflict = pd.read_csv('/content/asia_conflicts.csv')\n",
        "conflict.head"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "error",
          "ename": "FileNotFoundError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-5-627adc7424a5>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mconflict\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'/content/asia_conflicts.csv'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0mconflict\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36mparser_f\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)\u001b[0m\n\u001b[1;32m    674\u001b[0m         )\n\u001b[1;32m    675\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 676\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    677\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    678\u001b[0m     \u001b[0mparser_f\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__name__\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    446\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    447\u001b[0m     \u001b[0;31m# Create the parser.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 448\u001b[0;31m     \u001b[0mparser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfp_or_buf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    449\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    450\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[1;32m    878\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"has_index_names\"\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"has_index_names\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    879\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 880\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    881\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    882\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[0;34m(self, engine)\u001b[0m\n\u001b[1;32m   1112\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"c\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1113\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m\"c\"\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1114\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mCParserWrapper\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1115\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1116\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m\"python\"\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, src, **kwds)\u001b[0m\n\u001b[1;32m   1889\u001b[0m         \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"usecols\"\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0musecols\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1890\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1891\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mparsers\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mTextReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msrc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1892\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munnamed_cols\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munnamed_cols\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1893\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader.__cinit__\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._setup_parser_source\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] File /content/asia_conflicts.csv does not exist: '/content/asia_conflicts.csv'"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "I-JiZ4E1IszR",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "085d87e2-d52a-4cce-a82d-a3d4d0168893"
      },
      "source": [
        "conflict = conflict[conflict.country != 'Bangladesh']\n",
        "conflict\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>data_id</th>\n",
              "      <th>iso</th>\n",
              "      <th>event_id_cnty</th>\n",
              "      <th>event_id_no_cnty</th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>time_precision</th>\n",
              "      <th>event_type</th>\n",
              "      <th>actor1</th>\n",
              "      <th>assoc_actor_1</th>\n",
              "      <th>inter1</th>\n",
              "      <th>actor2</th>\n",
              "      <th>assoc_actor_2</th>\n",
              "      <th>inter2</th>\n",
              "      <th>interaction</th>\n",
              "      <th>region</th>\n",
              "      <th>country</th>\n",
              "      <th>admin1</th>\n",
              "      <th>admin2</th>\n",
              "      <th>admin3</th>\n",
              "      <th>location</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>geo_precision</th>\n",
              "      <th>source</th>\n",
              "      <th>source_scale</th>\n",
              "      <th>notes</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>timestamp</th>\n",
              "      <th>iso3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1733345</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33731</td>\n",
              "      <td>33731.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, a \"tribal\" man was allegedly kille...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1733346</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33732</td>\n",
              "      <td>33732.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>Unidentified Communal Group (India)</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, in the Chukka Goyyi area of Gudem ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1733347</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33733</td>\n",
              "      <td>33733.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>ABVP: Akhil Bharatiya Vidyarthi Parishad</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>Published on July 28, the ABVP of Panjab Unive...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1733348</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33734</td>\n",
              "      <td>33734.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Battle-No change of territory</td>\n",
              "      <td>Military Forces of India (1949-)</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>1</td>\n",
              "      <td>Military Forces of Pakistan (2008-)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Jammu</td>\n",
              "      <td>Akhnoor</td>\n",
              "      <td>Keri</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "      <td>2</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, an Indian solider was injured in cr...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1733349</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33735</td>\n",
              "      <td>33735.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>Labour Group (India)</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Katra</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "      <td>1</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, business owners blocked traffic in ...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</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",
              "      <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>216674</th>\n",
              "      <td>1531160</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK9</td>\n",
              "      <td>9.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Sindh</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Protests occurred in Hyderabad in solidarity w...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>1531188</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK5</td>\n",
              "      <td>5.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>2</td>\n",
              "      <td>Strategic development</td>\n",
              "      <td>Police Forces of Pakistan (2008-) Pakistan Ran...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Balochistan</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>Quetta City</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "      <td>2</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Agents of a Pakistani law enforcement agency r...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216676</th>\n",
              "      <td>1707379</td>\n",
              "      <td>764</td>\n",
              "      <td>THA1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Strategic development</td>\n",
              "      <td>Unidentified Armed Group (Thailand)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>30</td>\n",
              "      <td>South-Eastern Asia</td>\n",
              "      <td>Thailand</td>\n",
              "      <td>Pattani</td>\n",
              "      <td>Sai Buri</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Kadunong</td>\n",
              "      <td>6.6427</td>\n",
              "      <td>101.5531</td>\n",
              "      <td>2</td>\n",
              "      <td>The Nation</td>\n",
              "      <td>National</td>\n",
              "      <td>Property destruction: An unidentified assailan...</td>\n",
              "      <td>0</td>\n",
              "      <td>1531246498</td>\n",
              "      <td>THA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>1673081</td>\n",
              "      <td>144</td>\n",
              "      <td>SRI1298</td>\n",
              "      <td>1298.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Sri Lanka)</td>\n",
              "      <td>UNF: United National Front; SLFP: Sri Lanka Fr...</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>Southern</td>\n",
              "      <td>Matara</td>\n",
              "      <td>Matara Four Gravets</td>\n",
              "      <td>Makavita</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "      <td>1</td>\n",
              "      <td>Daily Mirror</td>\n",
              "      <td>National</td>\n",
              "      <td>A group of residents from the Makawita area st...</td>\n",
              "      <td>0</td>\n",
              "      <td>1531145065</td>\n",
              "      <td>LKA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216678</th>\n",
              "      <td>1728203</td>\n",
              "      <td>104</td>\n",
              "      <td>MMR1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>Military Forces of Myanmar (1988-2011)</td>\n",
              "      <td>DKBA (Buddhist): Democratic Karen Buddhist Arm...</td>\n",
              "      <td>1</td>\n",
              "      <td>Civilians (Myanmar)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>17</td>\n",
              "      <td>South-Eastern Asia</td>\n",
              "      <td>Myanmar</td>\n",
              "      <td>Kayin</td>\n",
              "      <td>Kawkareik</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>16.0408</td>\n",
              "      <td>98.1232</td>\n",
              "      <td>2</td>\n",
              "      <td>Democratic Voice of Burma</td>\n",
              "      <td>National</td>\n",
              "      <td>On 1 January 2010, the Democratic Karen Buddhi...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986401</td>\n",
              "      <td>MMR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>209892 rows × 30 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        data_id  iso event_id_cnty  ...  fatalities   timestamp  iso3\n",
              "1       1733345  356      IND33731  ...           1  1532986405   IND\n",
              "2       1733346  356      IND33732  ...           1  1532986405   IND\n",
              "3       1733347  356      IND33733  ...           0  1532986405   IND\n",
              "4       1733348  356      IND33734  ...           0  1532986405   IND\n",
              "5       1733349  356      IND33735  ...           0  1532986405   IND\n",
              "...         ...  ...           ...  ...         ...         ...   ...\n",
              "216674  1531160  586          PAK9  ...           0  1524053974   PAK\n",
              "216675  1531188  586          PAK5  ...           0  1524053974   PAK\n",
              "216676  1707379  764          THA1  ...           0  1531246498   THA\n",
              "216677  1673081  144       SRI1298  ...           0  1531145065   LKA\n",
              "216678  1728203  104          MMR1  ...           0  1532986401   MMR\n",
              "\n",
              "[209892 rows x 30 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Vv4r5LanI3E-",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "3841d0e6-05f1-4965-cfe8-569c790ff592"
      },
      "source": [
        "conflict = conflict[conflict.country != 'Thailand']\n",
        "conflict"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>data_id</th>\n",
              "      <th>iso</th>\n",
              "      <th>event_id_cnty</th>\n",
              "      <th>event_id_no_cnty</th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>time_precision</th>\n",
              "      <th>event_type</th>\n",
              "      <th>actor1</th>\n",
              "      <th>assoc_actor_1</th>\n",
              "      <th>inter1</th>\n",
              "      <th>actor2</th>\n",
              "      <th>assoc_actor_2</th>\n",
              "      <th>inter2</th>\n",
              "      <th>interaction</th>\n",
              "      <th>region</th>\n",
              "      <th>country</th>\n",
              "      <th>admin1</th>\n",
              "      <th>admin2</th>\n",
              "      <th>admin3</th>\n",
              "      <th>location</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>geo_precision</th>\n",
              "      <th>source</th>\n",
              "      <th>source_scale</th>\n",
              "      <th>notes</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>timestamp</th>\n",
              "      <th>iso3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1733345</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33731</td>\n",
              "      <td>33731.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, a \"tribal\" man was allegedly kille...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1733346</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33732</td>\n",
              "      <td>33732.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>Unidentified Communal Group (India)</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, in the Chukka Goyyi area of Gudem ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1733347</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33733</td>\n",
              "      <td>33733.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>ABVP: Akhil Bharatiya Vidyarthi Parishad</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>Published on July 28, the ABVP of Panjab Unive...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1733348</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33734</td>\n",
              "      <td>33734.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Battle-No change of territory</td>\n",
              "      <td>Military Forces of India (1949-)</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>1</td>\n",
              "      <td>Military Forces of Pakistan (2008-)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Jammu</td>\n",
              "      <td>Akhnoor</td>\n",
              "      <td>Keri</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "      <td>2</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, an Indian solider was injured in cr...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1733349</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33735</td>\n",
              "      <td>33735.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>Labour Group (India)</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Katra</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "      <td>1</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, business owners blocked traffic in ...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</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",
              "      <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>216673</th>\n",
              "      <td>1531187</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK8</td>\n",
              "      <td>8.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>TTP: Tehreek-i-Taliban Pakistan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Khyber Pakhtunkhwa</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>A police spokesman confirmed at least 93 were ...</td>\n",
              "      <td>93</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>1531160</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK9</td>\n",
              "      <td>9.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Sindh</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Protests occurred in Hyderabad in solidarity w...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>1531188</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK5</td>\n",
              "      <td>5.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>2</td>\n",
              "      <td>Strategic development</td>\n",
              "      <td>Police Forces of Pakistan (2008-) Pakistan Ran...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Balochistan</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>Quetta City</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "      <td>2</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Agents of a Pakistani law enforcement agency r...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>1673081</td>\n",
              "      <td>144</td>\n",
              "      <td>SRI1298</td>\n",
              "      <td>1298.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Sri Lanka)</td>\n",
              "      <td>UNF: United National Front; SLFP: Sri Lanka Fr...</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>Southern</td>\n",
              "      <td>Matara</td>\n",
              "      <td>Matara Four Gravets</td>\n",
              "      <td>Makavita</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "      <td>1</td>\n",
              "      <td>Daily Mirror</td>\n",
              "      <td>National</td>\n",
              "      <td>A group of residents from the Makawita area st...</td>\n",
              "      <td>0</td>\n",
              "      <td>1531145065</td>\n",
              "      <td>LKA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216678</th>\n",
              "      <td>1728203</td>\n",
              "      <td>104</td>\n",
              "      <td>MMR1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>Military Forces of Myanmar (1988-2011)</td>\n",
              "      <td>DKBA (Buddhist): Democratic Karen Buddhist Arm...</td>\n",
              "      <td>1</td>\n",
              "      <td>Civilians (Myanmar)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>17</td>\n",
              "      <td>South-Eastern Asia</td>\n",
              "      <td>Myanmar</td>\n",
              "      <td>Kayin</td>\n",
              "      <td>Kawkareik</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>16.0408</td>\n",
              "      <td>98.1232</td>\n",
              "      <td>2</td>\n",
              "      <td>Democratic Voice of Burma</td>\n",
              "      <td>National</td>\n",
              "      <td>On 1 January 2010, the Democratic Karen Buddhi...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986401</td>\n",
              "      <td>MMR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>206973 rows × 30 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        data_id  iso event_id_cnty  ...  fatalities   timestamp  iso3\n",
              "1       1733345  356      IND33731  ...           1  1532986405   IND\n",
              "2       1733346  356      IND33732  ...           1  1532986405   IND\n",
              "3       1733347  356      IND33733  ...           0  1532986405   IND\n",
              "4       1733348  356      IND33734  ...           0  1532986405   IND\n",
              "5       1733349  356      IND33735  ...           0  1532986405   IND\n",
              "...         ...  ...           ...  ...         ...         ...   ...\n",
              "216673  1531187  586          PAK8  ...          93  1524053974   PAK\n",
              "216674  1531160  586          PAK9  ...           0  1524053974   PAK\n",
              "216675  1531188  586          PAK5  ...           0  1524053974   PAK\n",
              "216677  1673081  144       SRI1298  ...           0  1531145065   LKA\n",
              "216678  1728203  104          MMR1  ...           0  1532986401   MMR\n",
              "\n",
              "[206973 rows x 30 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5lulsGNOJHbk",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "312ea185-f4b9-4c1d-da9d-a10e7bb9dec4"
      },
      "source": [
        "conflict = conflict[conflict.country != 'Yemen']\n",
        "conflict"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>data_id</th>\n",
              "      <th>iso</th>\n",
              "      <th>event_id_cnty</th>\n",
              "      <th>event_id_no_cnty</th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>time_precision</th>\n",
              "      <th>event_type</th>\n",
              "      <th>actor1</th>\n",
              "      <th>assoc_actor_1</th>\n",
              "      <th>inter1</th>\n",
              "      <th>actor2</th>\n",
              "      <th>assoc_actor_2</th>\n",
              "      <th>inter2</th>\n",
              "      <th>interaction</th>\n",
              "      <th>region</th>\n",
              "      <th>country</th>\n",
              "      <th>admin1</th>\n",
              "      <th>admin2</th>\n",
              "      <th>admin3</th>\n",
              "      <th>location</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>geo_precision</th>\n",
              "      <th>source</th>\n",
              "      <th>source_scale</th>\n",
              "      <th>notes</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>timestamp</th>\n",
              "      <th>iso3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1733345</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33731</td>\n",
              "      <td>33731.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, a \"tribal\" man was allegedly kille...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1733346</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33732</td>\n",
              "      <td>33732.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>Unidentified Communal Group (India)</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, in the Chukka Goyyi area of Gudem ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1733347</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33733</td>\n",
              "      <td>33733.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>ABVP: Akhil Bharatiya Vidyarthi Parishad</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>Published on July 28, the ABVP of Panjab Unive...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1733348</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33734</td>\n",
              "      <td>33734.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Battle-No change of territory</td>\n",
              "      <td>Military Forces of India (1949-)</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>1</td>\n",
              "      <td>Military Forces of Pakistan (2008-)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Jammu</td>\n",
              "      <td>Akhnoor</td>\n",
              "      <td>Keri</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "      <td>2</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, an Indian solider was injured in cr...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1733349</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33735</td>\n",
              "      <td>33735.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>Labour Group (India)</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Katra</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "      <td>1</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, business owners blocked traffic in ...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</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",
              "      <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>216673</th>\n",
              "      <td>1531187</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK8</td>\n",
              "      <td>8.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>TTP: Tehreek-i-Taliban Pakistan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Khyber Pakhtunkhwa</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>A police spokesman confirmed at least 93 were ...</td>\n",
              "      <td>93</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>1531160</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK9</td>\n",
              "      <td>9.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Sindh</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Protests occurred in Hyderabad in solidarity w...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>1531188</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK5</td>\n",
              "      <td>5.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>2</td>\n",
              "      <td>Strategic development</td>\n",
              "      <td>Police Forces of Pakistan (2008-) Pakistan Ran...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Balochistan</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>Quetta City</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "      <td>2</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Agents of a Pakistani law enforcement agency r...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>1673081</td>\n",
              "      <td>144</td>\n",
              "      <td>SRI1298</td>\n",
              "      <td>1298.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Sri Lanka)</td>\n",
              "      <td>UNF: United National Front; SLFP: Sri Lanka Fr...</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>Southern</td>\n",
              "      <td>Matara</td>\n",
              "      <td>Matara Four Gravets</td>\n",
              "      <td>Makavita</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "      <td>1</td>\n",
              "      <td>Daily Mirror</td>\n",
              "      <td>National</td>\n",
              "      <td>A group of residents from the Makawita area st...</td>\n",
              "      <td>0</td>\n",
              "      <td>1531145065</td>\n",
              "      <td>LKA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216678</th>\n",
              "      <td>1728203</td>\n",
              "      <td>104</td>\n",
              "      <td>MMR1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>Military Forces of Myanmar (1988-2011)</td>\n",
              "      <td>DKBA (Buddhist): Democratic Karen Buddhist Arm...</td>\n",
              "      <td>1</td>\n",
              "      <td>Civilians (Myanmar)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>17</td>\n",
              "      <td>South-Eastern Asia</td>\n",
              "      <td>Myanmar</td>\n",
              "      <td>Kayin</td>\n",
              "      <td>Kawkareik</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>16.0408</td>\n",
              "      <td>98.1232</td>\n",
              "      <td>2</td>\n",
              "      <td>Democratic Voice of Burma</td>\n",
              "      <td>National</td>\n",
              "      <td>On 1 January 2010, the Democratic Karen Buddhi...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986401</td>\n",
              "      <td>MMR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>184934 rows × 30 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        data_id  iso event_id_cnty  ...  fatalities   timestamp  iso3\n",
              "1       1733345  356      IND33731  ...           1  1532986405   IND\n",
              "2       1733346  356      IND33732  ...           1  1532986405   IND\n",
              "3       1733347  356      IND33733  ...           0  1532986405   IND\n",
              "4       1733348  356      IND33734  ...           0  1532986405   IND\n",
              "5       1733349  356      IND33735  ...           0  1532986405   IND\n",
              "...         ...  ...           ...  ...         ...         ...   ...\n",
              "216673  1531187  586          PAK8  ...          93  1524053974   PAK\n",
              "216674  1531160  586          PAK9  ...           0  1524053974   PAK\n",
              "216675  1531188  586          PAK5  ...           0  1524053974   PAK\n",
              "216677  1673081  144       SRI1298  ...           0  1531145065   LKA\n",
              "216678  1728203  104          MMR1  ...           0  1532986401   MMR\n",
              "\n",
              "[184934 rows x 30 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "01nA1Tx8JNc-",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "fc4422e1-7f2d-4c93-f005-5246b3931215"
      },
      "source": [
        "conflict = conflict[conflict.country != 'Cambodia']\n",
        "conflict"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>data_id</th>\n",
              "      <th>iso</th>\n",
              "      <th>event_id_cnty</th>\n",
              "      <th>event_id_no_cnty</th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>time_precision</th>\n",
              "      <th>event_type</th>\n",
              "      <th>actor1</th>\n",
              "      <th>assoc_actor_1</th>\n",
              "      <th>inter1</th>\n",
              "      <th>actor2</th>\n",
              "      <th>assoc_actor_2</th>\n",
              "      <th>inter2</th>\n",
              "      <th>interaction</th>\n",
              "      <th>region</th>\n",
              "      <th>country</th>\n",
              "      <th>admin1</th>\n",
              "      <th>admin2</th>\n",
              "      <th>admin3</th>\n",
              "      <th>location</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>geo_precision</th>\n",
              "      <th>source</th>\n",
              "      <th>source_scale</th>\n",
              "      <th>notes</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>timestamp</th>\n",
              "      <th>iso3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1733345</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33731</td>\n",
              "      <td>33731.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, a \"tribal\" man was allegedly kille...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1733346</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33732</td>\n",
              "      <td>33732.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>Unidentified Communal Group (India)</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, in the Chukka Goyyi area of Gudem ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1733347</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33733</td>\n",
              "      <td>33733.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>ABVP: Akhil Bharatiya Vidyarthi Parishad</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>Published on July 28, the ABVP of Panjab Unive...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1733348</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33734</td>\n",
              "      <td>33734.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Battle-No change of territory</td>\n",
              "      <td>Military Forces of India (1949-)</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>1</td>\n",
              "      <td>Military Forces of Pakistan (2008-)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Jammu</td>\n",
              "      <td>Akhnoor</td>\n",
              "      <td>Keri</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "      <td>2</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, an Indian solider was injured in cr...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1733349</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33735</td>\n",
              "      <td>33735.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>Labour Group (India)</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Katra</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "      <td>1</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, business owners blocked traffic in ...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</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",
              "      <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>216673</th>\n",
              "      <td>1531187</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK8</td>\n",
              "      <td>8.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>TTP: Tehreek-i-Taliban Pakistan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Khyber Pakhtunkhwa</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>A police spokesman confirmed at least 93 were ...</td>\n",
              "      <td>93</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>1531160</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK9</td>\n",
              "      <td>9.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Sindh</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Protests occurred in Hyderabad in solidarity w...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>1531188</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK5</td>\n",
              "      <td>5.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>2</td>\n",
              "      <td>Strategic development</td>\n",
              "      <td>Police Forces of Pakistan (2008-) Pakistan Ran...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Balochistan</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>Quetta City</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "      <td>2</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Agents of a Pakistani law enforcement agency r...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>1673081</td>\n",
              "      <td>144</td>\n",
              "      <td>SRI1298</td>\n",
              "      <td>1298.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Sri Lanka)</td>\n",
              "      <td>UNF: United National Front; SLFP: Sri Lanka Fr...</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>Southern</td>\n",
              "      <td>Matara</td>\n",
              "      <td>Matara Four Gravets</td>\n",
              "      <td>Makavita</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "      <td>1</td>\n",
              "      <td>Daily Mirror</td>\n",
              "      <td>National</td>\n",
              "      <td>A group of residents from the Makawita area st...</td>\n",
              "      <td>0</td>\n",
              "      <td>1531145065</td>\n",
              "      <td>LKA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216678</th>\n",
              "      <td>1728203</td>\n",
              "      <td>104</td>\n",
              "      <td>MMR1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>Military Forces of Myanmar (1988-2011)</td>\n",
              "      <td>DKBA (Buddhist): Democratic Karen Buddhist Arm...</td>\n",
              "      <td>1</td>\n",
              "      <td>Civilians (Myanmar)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>17</td>\n",
              "      <td>South-Eastern Asia</td>\n",
              "      <td>Myanmar</td>\n",
              "      <td>Kayin</td>\n",
              "      <td>Kawkareik</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>Kyainseikgyi</td>\n",
              "      <td>16.0408</td>\n",
              "      <td>98.1232</td>\n",
              "      <td>2</td>\n",
              "      <td>Democratic Voice of Burma</td>\n",
              "      <td>National</td>\n",
              "      <td>On 1 January 2010, the Democratic Karen Buddhi...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986401</td>\n",
              "      <td>MMR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>183141 rows × 30 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        data_id  iso event_id_cnty  ...  fatalities   timestamp  iso3\n",
              "1       1733345  356      IND33731  ...           1  1532986405   IND\n",
              "2       1733346  356      IND33732  ...           1  1532986405   IND\n",
              "3       1733347  356      IND33733  ...           0  1532986405   IND\n",
              "4       1733348  356      IND33734  ...           0  1532986405   IND\n",
              "5       1733349  356      IND33735  ...           0  1532986405   IND\n",
              "...         ...  ...           ...  ...         ...         ...   ...\n",
              "216673  1531187  586          PAK8  ...          93  1524053974   PAK\n",
              "216674  1531160  586          PAK9  ...           0  1524053974   PAK\n",
              "216675  1531188  586          PAK5  ...           0  1524053974   PAK\n",
              "216677  1673081  144       SRI1298  ...           0  1531145065   LKA\n",
              "216678  1728203  104          MMR1  ...           0  1532986401   MMR\n",
              "\n",
              "[183141 rows x 30 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FuLIkElOJON1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "f9d5753d-1fad-4018-89d1-ad7037ccf3bb"
      },
      "source": [
        "conflict = conflict[conflict.country != 'Myanmar']\n",
        "conflict"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>data_id</th>\n",
              "      <th>iso</th>\n",
              "      <th>event_id_cnty</th>\n",
              "      <th>event_id_no_cnty</th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>time_precision</th>\n",
              "      <th>event_type</th>\n",
              "      <th>actor1</th>\n",
              "      <th>assoc_actor_1</th>\n",
              "      <th>inter1</th>\n",
              "      <th>actor2</th>\n",
              "      <th>assoc_actor_2</th>\n",
              "      <th>inter2</th>\n",
              "      <th>interaction</th>\n",
              "      <th>region</th>\n",
              "      <th>country</th>\n",
              "      <th>admin1</th>\n",
              "      <th>admin2</th>\n",
              "      <th>admin3</th>\n",
              "      <th>location</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>geo_precision</th>\n",
              "      <th>source</th>\n",
              "      <th>source_scale</th>\n",
              "      <th>notes</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>timestamp</th>\n",
              "      <th>iso3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1733345</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33731</td>\n",
              "      <td>33731.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, a \"tribal\" man was allegedly kille...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1733346</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33732</td>\n",
              "      <td>33732.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>Unidentified Communal Group (India)</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, in the Chukka Goyyi area of Gudem ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1733347</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33733</td>\n",
              "      <td>33733.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>ABVP: Akhil Bharatiya Vidyarthi Parishad</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>Published on July 28, the ABVP of Panjab Unive...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1733348</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33734</td>\n",
              "      <td>33734.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Battle-No change of territory</td>\n",
              "      <td>Military Forces of India (1949-)</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>1</td>\n",
              "      <td>Military Forces of Pakistan (2008-)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Jammu</td>\n",
              "      <td>Akhnoor</td>\n",
              "      <td>Keri</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "      <td>2</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, an Indian solider was injured in cr...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1733349</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33735</td>\n",
              "      <td>33735.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>Labour Group (India)</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Katra</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "      <td>1</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, business owners blocked traffic in ...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</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",
              "      <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>216672</th>\n",
              "      <td>1531186</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK7</td>\n",
              "      <td>7.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Remote violence</td>\n",
              "      <td>TTP: Tehreek-i-Taliban Pakistan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>FATA</td>\n",
              "      <td>Bajaur Agency</td>\n",
              "      <td>Salarzai Tehsil</td>\n",
              "      <td>Salarzai</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>At least 5 people, including a pro-government ...</td>\n",
              "      <td>5</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>1531187</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK8</td>\n",
              "      <td>8.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>TTP: Tehreek-i-Taliban Pakistan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Khyber Pakhtunkhwa</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>A police spokesman confirmed at least 93 were ...</td>\n",
              "      <td>93</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>1531160</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK9</td>\n",
              "      <td>9.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Sindh</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Protests occurred in Hyderabad in solidarity w...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>1531188</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK5</td>\n",
              "      <td>5.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>2</td>\n",
              "      <td>Strategic development</td>\n",
              "      <td>Police Forces of Pakistan (2008-) Pakistan Ran...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Balochistan</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>Quetta City</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "      <td>2</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Agents of a Pakistani law enforcement agency r...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>1673081</td>\n",
              "      <td>144</td>\n",
              "      <td>SRI1298</td>\n",
              "      <td>1298.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Sri Lanka)</td>\n",
              "      <td>UNF: United National Front; SLFP: Sri Lanka Fr...</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>Southern</td>\n",
              "      <td>Matara</td>\n",
              "      <td>Matara Four Gravets</td>\n",
              "      <td>Makavita</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "      <td>1</td>\n",
              "      <td>Daily Mirror</td>\n",
              "      <td>National</td>\n",
              "      <td>A group of residents from the Makawita area st...</td>\n",
              "      <td>0</td>\n",
              "      <td>1531145065</td>\n",
              "      <td>LKA</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177568 rows × 30 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        data_id  iso event_id_cnty  ...  fatalities   timestamp  iso3\n",
              "1       1733345  356      IND33731  ...           1  1532986405   IND\n",
              "2       1733346  356      IND33732  ...           1  1532986405   IND\n",
              "3       1733347  356      IND33733  ...           0  1532986405   IND\n",
              "4       1733348  356      IND33734  ...           0  1532986405   IND\n",
              "5       1733349  356      IND33735  ...           0  1532986405   IND\n",
              "...         ...  ...           ...  ...         ...         ...   ...\n",
              "216672  1531186  586          PAK7  ...           5  1524053974   PAK\n",
              "216673  1531187  586          PAK8  ...          93  1524053974   PAK\n",
              "216674  1531160  586          PAK9  ...           0  1524053974   PAK\n",
              "216675  1531188  586          PAK5  ...           0  1524053974   PAK\n",
              "216677  1673081  144       SRI1298  ...           0  1531145065   LKA\n",
              "\n",
              "[177568 rows x 30 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "eYMCQFn4JXiI",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "07e33c01-eda9-4a80-b397-e10694fa36a1"
      },
      "source": [
        "conflict = conflict[conflict.country != 'Indonesia']\n",
        "conflict"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>data_id</th>\n",
              "      <th>iso</th>\n",
              "      <th>event_id_cnty</th>\n",
              "      <th>event_id_no_cnty</th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>time_precision</th>\n",
              "      <th>event_type</th>\n",
              "      <th>actor1</th>\n",
              "      <th>assoc_actor_1</th>\n",
              "      <th>inter1</th>\n",
              "      <th>actor2</th>\n",
              "      <th>assoc_actor_2</th>\n",
              "      <th>inter2</th>\n",
              "      <th>interaction</th>\n",
              "      <th>region</th>\n",
              "      <th>country</th>\n",
              "      <th>admin1</th>\n",
              "      <th>admin2</th>\n",
              "      <th>admin3</th>\n",
              "      <th>location</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>geo_precision</th>\n",
              "      <th>source</th>\n",
              "      <th>source_scale</th>\n",
              "      <th>notes</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>timestamp</th>\n",
              "      <th>iso3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1733345</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33731</td>\n",
              "      <td>33731.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, a \"tribal\" man was allegedly kille...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1733346</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33732</td>\n",
              "      <td>33732.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>CPI (Maoist): Communist Party of India (Maoist)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (India)</td>\n",
              "      <td>Unidentified Communal Group (India)</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Andhra Pradesh</td>\n",
              "      <td>Visakhapatnam</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>Gudem Kotha Veedhi</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>On July 28, in the Chukka Goyyi area of Gudem ...</td>\n",
              "      <td>1</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1733347</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33733</td>\n",
              "      <td>33733.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>ABVP: Akhil Bharatiya Vidyarthi Parishad</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>Chandigarh</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "      <td>1</td>\n",
              "      <td>Hindustan Times</td>\n",
              "      <td>National</td>\n",
              "      <td>Published on July 28, the ABVP of Panjab Unive...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1733348</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33734</td>\n",
              "      <td>33734.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Battle-No change of territory</td>\n",
              "      <td>Military Forces of India (1949-)</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>1</td>\n",
              "      <td>Military Forces of Pakistan (2008-)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Jammu</td>\n",
              "      <td>Akhnoor</td>\n",
              "      <td>Keri</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "      <td>2</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, an Indian solider was injured in cr...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1733349</td>\n",
              "      <td>356</td>\n",
              "      <td>IND33735</td>\n",
              "      <td>33735.0</td>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (India)</td>\n",
              "      <td>Labour Group (India)</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>India</td>\n",
              "      <td>Jammu and Kashmir</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Reasi</td>\n",
              "      <td>Katra</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "      <td>1</td>\n",
              "      <td>Early Times (India)</td>\n",
              "      <td>National</td>\n",
              "      <td>On 28 Jul, business owners blocked traffic in ...</td>\n",
              "      <td>0</td>\n",
              "      <td>1532986405</td>\n",
              "      <td>IND</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",
              "      <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>216672</th>\n",
              "      <td>1531186</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK7</td>\n",
              "      <td>7.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Remote violence</td>\n",
              "      <td>TTP: Tehreek-i-Taliban Pakistan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>FATA</td>\n",
              "      <td>Bajaur Agency</td>\n",
              "      <td>Salarzai Tehsil</td>\n",
              "      <td>Salarzai</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>At least 5 people, including a pro-government ...</td>\n",
              "      <td>5</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>1531187</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK8</td>\n",
              "      <td>8.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Violence against civilians</td>\n",
              "      <td>TTP: Tehreek-i-Taliban Pakistan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>Civilians (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>27</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Khyber Pakhtunkhwa</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>Lakki Marwat</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>A police spokesman confirmed at least 93 were ...</td>\n",
              "      <td>93</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>1531160</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK9</td>\n",
              "      <td>9.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Pakistan)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Sindh</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>Hyderabad</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "      <td>1</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Protests occurred in Hyderabad in solidarity w...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>1531188</td>\n",
              "      <td>586</td>\n",
              "      <td>PAK5</td>\n",
              "      <td>5.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>2</td>\n",
              "      <td>Strategic development</td>\n",
              "      <td>Police Forces of Pakistan (2008-) Pakistan Ran...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>Police Forces of India (1949-) Border Security...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>Balochistan</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>Quetta City</td>\n",
              "      <td>Quetta</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "      <td>2</td>\n",
              "      <td>Right Vision News</td>\n",
              "      <td>National</td>\n",
              "      <td>Agents of a Pakistani law enforcement agency r...</td>\n",
              "      <td>0</td>\n",
              "      <td>1524053974</td>\n",
              "      <td>PAK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>1673081</td>\n",
              "      <td>144</td>\n",
              "      <td>SRI1298</td>\n",
              "      <td>1298.0</td>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>1</td>\n",
              "      <td>Riots/Protests</td>\n",
              "      <td>Protesters (Sri Lanka)</td>\n",
              "      <td>UNF: United National Front; SLFP: Sri Lanka Fr...</td>\n",
              "      <td>6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>60</td>\n",
              "      <td>Southern Asia</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>Southern</td>\n",
              "      <td>Matara</td>\n",
              "      <td>Matara Four Gravets</td>\n",
              "      <td>Makavita</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "      <td>1</td>\n",
              "      <td>Daily Mirror</td>\n",
              "      <td>National</td>\n",
              "      <td>A group of residents from the Makawita area st...</td>\n",
              "      <td>0</td>\n",
              "      <td>1531145065</td>\n",
              "      <td>LKA</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 30 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        data_id  iso event_id_cnty  ...  fatalities   timestamp  iso3\n",
              "1       1733345  356      IND33731  ...           1  1532986405   IND\n",
              "2       1733346  356      IND33732  ...           1  1532986405   IND\n",
              "3       1733347  356      IND33733  ...           0  1532986405   IND\n",
              "4       1733348  356      IND33734  ...           0  1532986405   IND\n",
              "5       1733349  356      IND33735  ...           0  1532986405   IND\n",
              "...         ...  ...           ...  ...         ...         ...   ...\n",
              "216672  1531186  586          PAK7  ...           5  1524053974   PAK\n",
              "216673  1531187  586          PAK8  ...          93  1524053974   PAK\n",
              "216674  1531160  586          PAK9  ...           0  1524053974   PAK\n",
              "216675  1531188  586          PAK5  ...           0  1524053974   PAK\n",
              "216677  1673081  144       SRI1298  ...           0  1531145065   LKA\n",
              "\n",
              "[177157 rows x 30 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SF3U1hdISv4l",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 134
        },
        "outputId": "12fd282f-bb01-4ba2-e6c1-f87e6a90fab5"
      },
      "source": [
        "conflict.columns"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['data_id', 'iso', 'event_id_cnty', 'event_id_no_cnty', 'event_date',\n",
              "       'year', 'time_precision', 'event_type', 'actor1', 'assoc_actor_1',\n",
              "       'inter1', 'actor2', 'assoc_actor_2', 'inter2', 'interaction', 'region',\n",
              "       'country', 'admin1', 'admin2', 'admin3', 'location', 'latitude',\n",
              "       'longitude', 'geo_precision', 'source', 'source_scale', 'notes',\n",
              "       'fatalities', 'timestamp', 'iso3'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CgWrQGLgJOeu",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "d95b7fa6-3b85-43f3-a92a-4e8b8707cd9d"
      },
      "source": [
        "MENA = conflict.drop(['data_id', 'fatalities', 'iso', 'event_id_cnty', 'event_id_no_cnty', 'time_precision', 'event_type', 'actor1', 'assoc_actor_1', 'inter1', 'actor2', 'assoc_actor_2', 'inter2', 'interaction', 'admin2', 'admin3', 'region', 'admin1', 'location', 'geo_precision', 'source', 'source_scale', 'notes', 'timestamp', 'iso3'],axis=1)\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[177157 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PD7jM5yjUvkA",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "4abbe7bc-914a-4072-c173-b65a08d0fec8"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Bangladesh']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[177157 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BWQiA7hWUvni",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "e16caa61-1673-4f18-cdff-c2a08af29856"
      },
      "source": [
        "MENA.dropna()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[177157 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "e0ZZi9YiPBgl",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "d5897a3e-0c4a-49cb-dd2d-9d90c7609189"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Cambodia']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[177157 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rBswHs8QPBj_",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "efd1685c-8f46-4c1c-e7d8-dc195595ff2e"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Indonesia']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[177157 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Z5oUJd-PVxX8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "70816fde-8393-4f10-e37e-3c24d05ca9d4"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Myanmar']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[177157 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TKnLVJ2jV0fx",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "3bc7174f-61b7-4af8-b9b2-6cd0b8b3e38d"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Yemen']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177157 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[177157 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_q1gyWjQV4pU",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "aa24c0d7-ce59-4431-e8b2-c76d9c75d50b"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Philippines']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>171794 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[171794 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bJdylUO0V9JG",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "c2d24651-4006-4bd1-f649-4e92eea4150b"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Thailand']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216677</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Sri Lanka</td>\n",
              "      <td>5.9666</td>\n",
              "      <td>80.5666</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>171794 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year    country  latitude  longitude\n",
              "1          28 July 2018  2018      India   17.8635    82.1959\n",
              "2          28 July 2018  2018      India   17.8619    82.1970\n",
              "3          28 July 2018  2018      India   30.7362    76.7884\n",
              "4          28 July 2018  2018      India   32.9413    74.5498\n",
              "5          28 July 2018  2018      India   32.9917    74.9320\n",
              "...                 ...   ...        ...       ...        ...\n",
              "216672  01 January 2010  2010   Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010   Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010   Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010   Pakistan   30.1999    67.0097\n",
              "216677  01 January 2010  2010  Sri Lanka    5.9666    80.5666\n",
              "\n",
              "[171794 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NKRiMc9lWAXT",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "d1c2ab15-27d4-4b71-fcc5-aaa80c128fae"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Sri Lanka']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216671</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>33.1500</td>\n",
              "      <td>70.4325</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>169223 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year   country  latitude  longitude\n",
              "1          28 July 2018  2018     India   17.8635    82.1959\n",
              "2          28 July 2018  2018     India   17.8619    82.1970\n",
              "3          28 July 2018  2018     India   30.7362    76.7884\n",
              "4          28 July 2018  2018     India   32.9413    74.5498\n",
              "5          28 July 2018  2018     India   32.9917    74.9320\n",
              "...                 ...   ...       ...       ...        ...\n",
              "216671  01 January 2010  2010  Pakistan   33.1500    70.4325\n",
              "216672  01 January 2010  2010  Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010  Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010  Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010  Pakistan   30.1999    67.0097\n",
              "\n",
              "[169223 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EAbammKCQvys",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "7d8594f2-17aa-407f-cca6-66bba9b00284"
      },
      "source": [
        "MENA = MENA[MENA.country != 'Bahrain']\n",
        "MENA"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8635</td>\n",
              "      <td>82.1959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>17.8619</td>\n",
              "      <td>82.1970</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.7362</td>\n",
              "      <td>76.7884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9413</td>\n",
              "      <td>74.5498</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>28 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>32.9917</td>\n",
              "      <td>74.9320</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216671</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>33.1500</td>\n",
              "      <td>70.4325</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216672</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.9256</td>\n",
              "      <td>71.5141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216673</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.5992</td>\n",
              "      <td>70.8511</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216674</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216675</th>\n",
              "      <td>01 January 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>30.1999</td>\n",
              "      <td>67.0097</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>168410 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "             event_date  year   country  latitude  longitude\n",
              "1          28 July 2018  2018     India   17.8635    82.1959\n",
              "2          28 July 2018  2018     India   17.8619    82.1970\n",
              "3          28 July 2018  2018     India   30.7362    76.7884\n",
              "4          28 July 2018  2018     India   32.9413    74.5498\n",
              "5          28 July 2018  2018     India   32.9917    74.9320\n",
              "...                 ...   ...       ...       ...        ...\n",
              "216671  01 January 2010  2010  Pakistan   33.1500    70.4325\n",
              "216672  01 January 2010  2010  Pakistan   34.9256    71.5141\n",
              "216673  01 January 2010  2010  Pakistan   32.5992    70.8511\n",
              "216674  01 January 2010  2010  Pakistan   25.3942    68.3736\n",
              "216675  01 January 2010  2010  Pakistan   30.1999    67.0097\n",
              "\n",
              "[168410 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "exZFQH0GQcBt",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 787
        },
        "outputId": "85653864-1be0-4909-e5fc-2e8a523b7c2b"
      },
      "source": [
        "MENA.sample(25)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>event_date</th>\n",
              "      <th>year</th>\n",
              "      <th>country</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>175713</th>\n",
              "      <td>26 February 2015</td>\n",
              "      <td>2015</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>27.5271</td>\n",
              "      <td>68.7452</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6237</th>\n",
              "      <td>28 June 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>31.1044</td>\n",
              "      <td>77.1666</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>204270</th>\n",
              "      <td>20 December 2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.1532</td>\n",
              "      <td>71.7066</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>208182</th>\n",
              "      <td>07 April 2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>25.3942</td>\n",
              "      <td>68.3736</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18111</th>\n",
              "      <td>29 April 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>29.6919</td>\n",
              "      <td>76.9844</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77845</th>\n",
              "      <td>19 July 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>Syria</td>\n",
              "      <td>36.3095</td>\n",
              "      <td>36.6884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>210848</th>\n",
              "      <td>03 October 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>33.7214</td>\n",
              "      <td>73.0432</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>178336</th>\n",
              "      <td>26 November 2014</td>\n",
              "      <td>2014</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>34.0197</td>\n",
              "      <td>71.5822</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51755</th>\n",
              "      <td>21 November 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>India</td>\n",
              "      <td>27.4727</td>\n",
              "      <td>94.9121</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>153593</th>\n",
              "      <td>12 May 2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>India</td>\n",
              "      <td>29.3874</td>\n",
              "      <td>76.9682</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>73833</th>\n",
              "      <td>06 August 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>Syria</td>\n",
              "      <td>35.9428</td>\n",
              "      <td>39.0519</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41789</th>\n",
              "      <td>10 January 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>India</td>\n",
              "      <td>30.9120</td>\n",
              "      <td>75.8537</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160966</th>\n",
              "      <td>02 March 2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>Iraq</td>\n",
              "      <td>36.4747</td>\n",
              "      <td>42.6691</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77472</th>\n",
              "      <td>21 July 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>India</td>\n",
              "      <td>11.1154</td>\n",
              "      <td>77.3545</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4808</th>\n",
              "      <td>05 July 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>Iraq</td>\n",
              "      <td>36.3350</td>\n",
              "      <td>43.1189</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62187</th>\n",
              "      <td>28 September 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>Iraq</td>\n",
              "      <td>37.1391</td>\n",
              "      <td>43.2560</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160423</th>\n",
              "      <td>07 March 2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>31.4166</td>\n",
              "      <td>73.0833</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>137013</th>\n",
              "      <td>15 September 2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>Iraq</td>\n",
              "      <td>33.1009</td>\n",
              "      <td>44.5824</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>214147</th>\n",
              "      <td>09 April 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>24.8542</td>\n",
              "      <td>67.0160</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53762</th>\n",
              "      <td>09 November 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>Syria</td>\n",
              "      <td>32.6241</td>\n",
              "      <td>36.1049</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>215049</th>\n",
              "      <td>17 March 2010</td>\n",
              "      <td>2010</td>\n",
              "      <td>Nepal</td>\n",
              "      <td>27.7017</td>\n",
              "      <td>85.3206</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>116912</th>\n",
              "      <td>26 January 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>Syria</td>\n",
              "      <td>33.5224</td>\n",
              "      <td>36.4584</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61581</th>\n",
              "      <td>02 October 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>27.5333</td>\n",
              "      <td>67.7666</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19858</th>\n",
              "      <td>20 April 2018</td>\n",
              "      <td>2018</td>\n",
              "      <td>Syria</td>\n",
              "      <td>33.7472</td>\n",
              "      <td>36.7064</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>94237</th>\n",
              "      <td>01 May 2017</td>\n",
              "      <td>2017</td>\n",
              "      <td>Pakistan</td>\n",
              "      <td>32.3011</td>\n",
              "      <td>69.5799</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "               event_date  year   country  latitude  longitude\n",
              "175713   26 February 2015  2015  Pakistan   27.5271    68.7452\n",
              "6237         28 June 2018  2018     India   31.1044    77.1666\n",
              "204270   20 December 2011  2011  Pakistan   34.1532    71.7066\n",
              "208182      07 April 2011  2011  Pakistan   25.3942    68.3736\n",
              "18111       29 April 2018  2018     India   29.6919    76.9844\n",
              "77845        19 July 2017  2017     Syria   36.3095    36.6884\n",
              "210848    03 October 2010  2010  Pakistan   33.7214    73.0432\n",
              "178336   26 November 2014  2014  Pakistan   34.0197    71.5822\n",
              "51755    21 November 2017  2017     India   27.4727    94.9121\n",
              "153593        12 May 2016  2016     India   29.3874    76.9682\n",
              "73833      06 August 2017  2017     Syria   35.9428    39.0519\n",
              "41789     10 January 2018  2018     India   30.9120    75.8537\n",
              "160966      02 March 2016  2016      Iraq   36.4747    42.6691\n",
              "77472        21 July 2017  2017     India   11.1154    77.3545\n",
              "4808         05 July 2018  2018      Iraq   36.3350    43.1189\n",
              "62187   28 September 2017  2017      Iraq   37.1391    43.2560\n",
              "160423      07 March 2016  2016  Pakistan   31.4166    73.0833\n",
              "137013  15 September 2016  2016      Iraq   33.1009    44.5824\n",
              "214147      09 April 2010  2010  Pakistan   24.8542    67.0160\n",
              "53762    09 November 2017  2017     Syria   32.6241    36.1049\n",
              "215049      17 March 2010  2010     Nepal   27.7017    85.3206\n",
              "116912    26 January 2017  2017     Syria   33.5224    36.4584\n",
              "61581     02 October 2017  2017  Pakistan   27.5333    67.7666\n",
              "19858       20 April 2018  2018     Syria   33.7472    36.7064\n",
              "94237         01 May 2017  2017  Pakistan   32.3011    69.5799"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WhjRZWrPQfDk"
      },
      "source": [
        "MENA.to_csv(r'C:\\Users\\surfb\\OneDrive\\Desktop\\MENA.csv', header=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "B6NVO7RkQfGe"
      },
      "source": [
        "#Find out if lat/long format matches Braith format\n",
        "#Drop years 2014-2018"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MbAyq8gWaIcK"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rXgzhxeaaIf3"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iGPiknz-QfJR"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1Gq1EMi_QfMp"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}