Climate_Population_ConflictData.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Climate_Population_ConflictData.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyNEAVjlae39K16a79dKJZAF",
      "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/Climate_Population_ConflictData.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZhLdWzpIf2L4"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qA_uyLQVf83J",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 422
        },
        "outputId": "14c8e37a-2394-4565-8b19-2e20e84de4ce"
      },
      "source": [
        "test = pd.read_stata('/content/BS_replication_data.dta')\n",
        "test"
      ],
      "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>grid_id</th>\n",
              "      <th>year</th>\n",
              "      <th>month</th>\n",
              "      <th>edate</th>\n",
              "      <th>fh</th>\n",
              "      <th>sh</th>\n",
              "      <th>country_id</th>\n",
              "      <th>climate_id</th>\n",
              "      <th>above_equator</th>\n",
              "      <th>extreme</th>\n",
              "      <th>extreme_p</th>\n",
              "      <th>extreme_p5</th>\n",
              "      <th>extreme_1</th>\n",
              "      <th>extreme_2</th>\n",
              "      <th>extreme_p3</th>\n",
              "      <th>temp</th>\n",
              "      <th>prec</th>\n",
              "      <th>prec_ap_5</th>\n",
              "      <th>temp_ap_95</th>\n",
              "      <th>temp_sd</th>\n",
              "      <th>drought</th>\n",
              "      <th>spei</th>\n",
              "      <th>extreme_spei5</th>\n",
              "      <th>point_x</th>\n",
              "      <th>point_y</th>\n",
              "      <th>incidence</th>\n",
              "      <th>incidence_number</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>rural</th>\n",
              "      <th>agropastoral</th>\n",
              "      <th>onset_incidence</th>\n",
              "      <th>battle_terr</th>\n",
              "      <th>battle_noterr</th>\n",
              "      <th>riot</th>\n",
              "      <th>csi_mean</th>\n",
              "      <th>severity_ld</th>\n",
              "      <th>popgrowth_ipo</th>\n",
              "      <th>popdens_ipo</th>\n",
              "      <th>lnpopdens_ipo</th>\n",
              "      <th>popgrowth_25</th>\n",
              "      <th>popgrowth_50</th>\n",
              "      <th>popgrowth_75</th>\n",
              "      <th>popdens_25</th>\n",
              "      <th>popdens_50</th>\n",
              "      <th>popdens_75</th>\n",
              "      <th>pop_int</th>\n",
              "      <th>lnpopdens</th>\n",
              "      <th>popgrowth_int</th>\n",
              "      <th>popgrowth15</th>\n",
              "      <th>popgrowth00</th>\n",
              "      <th>migration_90_00</th>\n",
              "      <th>migration_70_80</th>\n",
              "      <th>migration_80_90</th>\n",
              "      <th>migration_70_00</th>\n",
              "      <th>migration_90_00_w</th>\n",
              "      <th>migration_80_90_w</th>\n",
              "      <th>migration_70_80_w</th>\n",
              "      <th>migration_70_00_w</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>35306</td>\n",
              "      <td>1979.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>19.283203</td>\n",
              "      <td>14.500032</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.121248</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.819580</td>\n",
              "      <td>0.0</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1595.902425</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.731092</td>\n",
              "      <td>0.711911</td>\n",
              "      <td>-4.437579</td>\n",
              "      <td>-0.939635</td>\n",
              "      <td>-1.530918</td>\n",
              "      <td>-6.908132</td>\n",
              "      <td>-226.829056</td>\n",
              "      <td>-78.253654</td>\n",
              "      <td>-48.029888</td>\n",
              "      <td>-353.112579</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>35306</td>\n",
              "      <td>1979.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>229.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>19.767779</td>\n",
              "      <td>47.636775</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.344347</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.358274</td>\n",
              "      <td>0.0</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1595.902425</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.731092</td>\n",
              "      <td>0.711911</td>\n",
              "      <td>-4.437579</td>\n",
              "      <td>-0.939635</td>\n",
              "      <td>-1.530918</td>\n",
              "      <td>-6.908132</td>\n",
              "      <td>-226.829056</td>\n",
              "      <td>-78.253654</td>\n",
              "      <td>-48.029888</td>\n",
              "      <td>-353.112579</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>35306</td>\n",
              "      <td>1979.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>230.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.573480</td>\n",
              "      <td>14.077872</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.794491</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-1.088404</td>\n",
              "      <td>0.0</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1595.902425</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.731092</td>\n",
              "      <td>0.711911</td>\n",
              "      <td>-4.437579</td>\n",
              "      <td>-0.939635</td>\n",
              "      <td>-1.530918</td>\n",
              "      <td>-6.908132</td>\n",
              "      <td>-226.829056</td>\n",
              "      <td>-78.253654</td>\n",
              "      <td>-48.029888</td>\n",
              "      <td>-353.112579</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>35306</td>\n",
              "      <td>1979.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>231.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.626755</td>\n",
              "      <td>12.358401</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.819019</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-1.888762</td>\n",
              "      <td>1.0</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1595.902425</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.731092</td>\n",
              "      <td>0.711911</td>\n",
              "      <td>-4.437579</td>\n",
              "      <td>-0.939635</td>\n",
              "      <td>-1.530918</td>\n",
              "      <td>-6.908132</td>\n",
              "      <td>-226.829056</td>\n",
              "      <td>-78.253654</td>\n",
              "      <td>-48.029888</td>\n",
              "      <td>-353.112579</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>35306</td>\n",
              "      <td>1979.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>232.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16.474423</td>\n",
              "      <td>51.673588</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-0.171916</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.495418</td>\n",
              "      <td>0.0</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1595.902425</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18.731092</td>\n",
              "      <td>0.711911</td>\n",
              "      <td>-4.437579</td>\n",
              "      <td>-0.939635</td>\n",
              "      <td>-1.530918</td>\n",
              "      <td>-6.908132</td>\n",
              "      <td>-226.829056</td>\n",
              "      <td>-78.253654</td>\n",
              "      <td>-48.029888</td>\n",
              "      <td>-353.112579</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",
              "      <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>2159611</th>\n",
              "      <td>81375</td>\n",
              "      <td>2015.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>667.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>26.640101</td>\n",
              "      <td>40.762784</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.773604</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1505.995947</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.08071</td>\n",
              "      <td>0.113253</td>\n",
              "      <td>0.158705</td>\n",
              "      <td>0.001322</td>\n",
              "      <td>0.009547</td>\n",
              "      <td>0.033859</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.394463</td>\n",
              "      <td>0.158746</td>\n",
              "      <td>-0.788217</td>\n",
              "      <td>-1.760981</td>\n",
              "      <td>-0.782203</td>\n",
              "      <td>-3.331401</td>\n",
              "      <td>-4.222525</td>\n",
              "      <td>-4.190309</td>\n",
              "      <td>-9.433680</td>\n",
              "      <td>-17.846514</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159612</th>\n",
              "      <td>81375</td>\n",
              "      <td>2015.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>668.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>24.980599</td>\n",
              "      <td>41.379215</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.407177</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1505.995947</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.08071</td>\n",
              "      <td>0.113253</td>\n",
              "      <td>0.158705</td>\n",
              "      <td>0.001322</td>\n",
              "      <td>0.009547</td>\n",
              "      <td>0.033859</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.394463</td>\n",
              "      <td>0.158746</td>\n",
              "      <td>-0.788217</td>\n",
              "      <td>-1.760981</td>\n",
              "      <td>-0.782203</td>\n",
              "      <td>-3.331401</td>\n",
              "      <td>-4.222525</td>\n",
              "      <td>-4.190309</td>\n",
              "      <td>-9.433680</td>\n",
              "      <td>-17.846514</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159613</th>\n",
              "      <td>81375</td>\n",
              "      <td>2015.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>669.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>22.002826</td>\n",
              "      <td>63.920994</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.749669</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1505.995947</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.08071</td>\n",
              "      <td>0.113253</td>\n",
              "      <td>0.158705</td>\n",
              "      <td>0.001322</td>\n",
              "      <td>0.009547</td>\n",
              "      <td>0.033859</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.394463</td>\n",
              "      <td>0.158746</td>\n",
              "      <td>-0.788217</td>\n",
              "      <td>-1.760981</td>\n",
              "      <td>-0.782203</td>\n",
              "      <td>-3.331401</td>\n",
              "      <td>-4.222525</td>\n",
              "      <td>-4.190309</td>\n",
              "      <td>-9.433680</td>\n",
              "      <td>-17.846514</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159614</th>\n",
              "      <td>81375</td>\n",
              "      <td>2015.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>670.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>17.902786</td>\n",
              "      <td>78.581017</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-0.155641</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1505.995947</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.08071</td>\n",
              "      <td>0.113253</td>\n",
              "      <td>0.158705</td>\n",
              "      <td>0.001322</td>\n",
              "      <td>0.009547</td>\n",
              "      <td>0.033859</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.394463</td>\n",
              "      <td>0.158746</td>\n",
              "      <td>-0.788217</td>\n",
              "      <td>-1.760981</td>\n",
              "      <td>-0.782203</td>\n",
              "      <td>-3.331401</td>\n",
              "      <td>-4.222525</td>\n",
              "      <td>-4.190309</td>\n",
              "      <td>-9.433680</td>\n",
              "      <td>-17.846514</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159615</th>\n",
              "      <td>81375</td>\n",
              "      <td>2015.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>671.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>15.387918</td>\n",
              "      <td>12.152959</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-0.710937</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1505.995947</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.08071</td>\n",
              "      <td>0.113253</td>\n",
              "      <td>0.158705</td>\n",
              "      <td>0.001322</td>\n",
              "      <td>0.009547</td>\n",
              "      <td>0.033859</td>\n",
              "      <td>0.260304</td>\n",
              "      <td>-1.345906</td>\n",
              "      <td>0.061718</td>\n",
              "      <td>0.394463</td>\n",
              "      <td>0.158746</td>\n",
              "      <td>-0.788217</td>\n",
              "      <td>-1.760981</td>\n",
              "      <td>-0.782203</td>\n",
              "      <td>-3.331401</td>\n",
              "      <td>-4.222525</td>\n",
              "      <td>-4.190309</td>\n",
              "      <td>-9.433680</td>\n",
              "      <td>-17.846514</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2159616 rows × 58 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "         grid_id    year  ...  migration_70_80_w  migration_70_00_w\n",
              "0          35306  1979.0  ...         -48.029888        -353.112579\n",
              "1          35306  1979.0  ...         -48.029888        -353.112579\n",
              "2          35306  1979.0  ...         -48.029888        -353.112579\n",
              "3          35306  1979.0  ...         -48.029888        -353.112579\n",
              "4          35306  1979.0  ...         -48.029888        -353.112579\n",
              "...          ...     ...  ...                ...                ...\n",
              "2159611    81375  2015.0  ...          -9.433680         -17.846514\n",
              "2159612    81375  2015.0  ...          -9.433680         -17.846514\n",
              "2159613    81375  2015.0  ...          -9.433680         -17.846514\n",
              "2159614    81375  2015.0  ...          -9.433680         -17.846514\n",
              "2159615    81375  2015.0  ...          -9.433680         -17.846514\n",
              "\n",
              "[2159616 rows x 58 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RlEq8KFagO5Z",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "f1d29bd4-9ec2-4ec7-8449-c8732791beb9"
      },
      "source": [
        "test.shape"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(2159616, 58)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8eL-DAA6yvep",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "1c8fc6cf-4bdd-4bee-a5eb-ea522d3be160"
      },
      "source": [
        "test['year'].nunique()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "37"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "grZFVp0APr3W",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 252
        },
        "outputId": "93826e43-285b-4ea6-e455-0af833393974"
      },
      "source": [
        "test.columns"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['grid_id', 'year', 'month', 'edate', 'fh', 'sh', 'country_id',\n",
              "       'climate_id', 'above_equator', 'extreme', 'extreme_p', 'extreme_p5',\n",
              "       'extreme_1', 'extreme_2', 'extreme_p3', 'temp', 'prec', 'prec_ap_5',\n",
              "       'temp_ap_95', 'temp_sd', 'drought', 'spei', 'extreme_spei5', 'point_x',\n",
              "       'point_y', 'incidence', 'incidence_number', 'fatalities', 'rural',\n",
              "       'agropastoral', 'onset_incidence', 'battle_terr', 'battle_noterr',\n",
              "       'riot', 'csi_mean', 'severity_ld', 'popgrowth_ipo', 'popdens_ipo',\n",
              "       'lnpopdens_ipo', 'popgrowth_25', 'popgrowth_50', 'popgrowth_75',\n",
              "       'popdens_25', 'popdens_50', 'popdens_75', 'pop_int', 'lnpopdens',\n",
              "       'popgrowth_int', 'popgrowth15', 'popgrowth00', 'migration_90_00',\n",
              "       'migration_70_80', 'migration_80_90', 'migration_70_00',\n",
              "       'migration_90_00_w', 'migration_80_90_w', 'migration_70_80_w',\n",
              "       'migration_70_00_w'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mxBo-e7wQHHg",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "c2aec880-508d-4cc2-fc7c-2d256d39c191"
      },
      "source": [
        "Fin = test.drop(['grid_id', 'extreme', 'extreme_p', 'edate', 'fh', 'sh', 'above_equator', 'extreme_1', 'migration_70_00_w', 'temp_ap_95', 'extreme_p5', 'extreme_2', 'extreme_p3', 'prec', 'prec_ap_5', 'drought', 'spei', 'extreme_spei5', 'incidence', 'incidence_number', 'rural', 'agropastoral', 'onset_incidence', 'battle_terr', 'battle_noterr', 'riot', 'csi_mean', 'popgrowth_ipo', 'popdens_ipo', 'lnpopdens_ipo', 'popgrowth_25', 'popgrowth_50', 'popgrowth_75', 'popdens_25', 'popdens_50', 'popdens_75', 'pop_int', 'lnpopdens', 'popgrowth_int', 'popgrowth15', 'popgrowth00', 'migration_90_00', 'migration_70_80', 'migration_80_90', 'migration_70_00', 'migration_90_00_w', 'migration_80_90_w', 'migration_70_80_w'], axis=1)\n",
        "Fin.head()"
      ],
      "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>year</th>\n",
              "      <th>month</th>\n",
              "      <th>country_id</th>\n",
              "      <th>climate_id</th>\n",
              "      <th>temp</th>\n",
              "      <th>temp_sd</th>\n",
              "      <th>point_x</th>\n",
              "      <th>point_y</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>severity_ld</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1979.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>19.283203</td>\n",
              "      <td>1.121248</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1979.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>19.767779</td>\n",
              "      <td>1.344347</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1979.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>18.573480</td>\n",
              "      <td>0.794491</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1979.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>18.626755</td>\n",
              "      <td>0.819019</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1979.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>16.474423</td>\n",
              "      <td>-0.171916</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     year  month  country_id  ...  point_y  fatalities  severity_ld\n",
              "0  1979.0    1.0        56.0  ...  -34.875         NaN     0.333333\n",
              "1  1979.0    2.0        56.0  ...  -34.875         NaN     0.333333\n",
              "2  1979.0    3.0        56.0  ...  -34.875         NaN     0.333333\n",
              "3  1979.0    4.0        56.0  ...  -34.875         NaN     0.333333\n",
              "4  1979.0    5.0        56.0  ...  -34.875         NaN     0.333333\n",
              "\n",
              "[5 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3h9EjCqMXJUu",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "c5ff0033-58f9-4274-d837-271da445d30a"
      },
      "source": [
        "Fin.tail()"
      ],
      "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>year</th>\n",
              "      <th>month</th>\n",
              "      <th>country_id</th>\n",
              "      <th>climate_id</th>\n",
              "      <th>temp</th>\n",
              "      <th>temp_sd</th>\n",
              "      <th>point_x</th>\n",
              "      <th>point_y</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>severity_ld</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2159611</th>\n",
              "      <td>2015.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>26.640101</td>\n",
              "      <td>1.773604</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159612</th>\n",
              "      <td>2015.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>24.980599</td>\n",
              "      <td>1.407177</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159613</th>\n",
              "      <td>2015.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>22.002826</td>\n",
              "      <td>0.749669</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159614</th>\n",
              "      <td>2015.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>17.902786</td>\n",
              "      <td>-0.155641</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159615</th>\n",
              "      <td>2015.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>15.387918</td>\n",
              "      <td>-0.710937</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "           year  month  country_id  ...  point_y  fatalities  severity_ld\n",
              "2159611  2015.0    8.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159612  2015.0    9.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159613  2015.0   10.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159614  2015.0   11.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159615  2015.0   12.0        53.0  ...   37.125         0.0     0.333333\n",
              "\n",
              "[5 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wFHJ3KyNYiiQ",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "9849a85d-3e1f-4c28-ddbf-56108c7c74fa"
      },
      "source": [
        "Fin['country_id'].nunique()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "58"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Fi1-KS8rYilv",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "6d25ed3c-6077-4f40-f782-bae75bd345d7"
      },
      "source": [
        "Fin['point_x'].nunique()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "131"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nfmQAah6Y6_F",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "2cbbc29a-22cb-458c-f13d-1219702fa261"
      },
      "source": [
        "Fin['year'].values"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([1979., 1979., 1979., ..., 2015., 2015., 2015.])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CARDv2Ce0h1L"
      },
      "source": [
        "Fin = Fin[Fin.year != 1979.0]\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZiQmtTR71C2V"
      },
      "source": [
        "Fin = Fin[Fin.year != 1980.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZwJHK5Dv1C47"
      },
      "source": [
        "Fin = Fin[Fin.year != 1981.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Ui9Yur2S1C7w"
      },
      "source": [
        "Fin = Fin[Fin.year != 1982.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Wgu8qtvL1C-u"
      },
      "source": [
        "Fin = Fin[Fin.year != 1983.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XKZVVYW11DCB"
      },
      "source": [
        "Fin = Fin[Fin.year != 1984.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "KCw5doxsZxqi"
      },
      "source": [
        "Fin = Fin[Fin.year != 1985.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MzuyQc1SZz88"
      },
      "source": [
        "Fin = Fin[Fin.year != 1986.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6bxi8auFZ2Ib"
      },
      "source": [
        "Fin = Fin[Fin.year != 1987.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lULdYm3xZ5Uv"
      },
      "source": [
        "Fin = Fin[Fin.year != 1988.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EW-P1HvYZ7ef"
      },
      "source": [
        "Fin = Fin[Fin.year != 1989.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3UGuiDx1Z-Gb"
      },
      "source": [
        "Fin = Fin[Fin.year != 2015.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8qGmrEsjaCuD",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "a97ec22d-cdd2-4967-f092-cf3bef35267d"
      },
      "source": [
        "Fin = Fin[Fin.year != 2014.0]\n",
        "Fin"
      ],
      "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>year</th>\n",
              "      <th>month</th>\n",
              "      <th>country_id</th>\n",
              "      <th>climate_id</th>\n",
              "      <th>temp</th>\n",
              "      <th>temp_sd</th>\n",
              "      <th>point_x</th>\n",
              "      <th>point_y</th>\n",
              "      <th>fatalities</th>\n",
              "      <th>severity_ld</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>19.498242</td>\n",
              "      <td>1.220252</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>20.090117</td>\n",
              "      <td>1.492752</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>19.614963</td>\n",
              "      <td>1.273991</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>17.656907</td>\n",
              "      <td>0.372500</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>16.014318</td>\n",
              "      <td>-0.383748</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.333333</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159587</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>25.947117</td>\n",
              "      <td>1.620589</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159588</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>24.217630</td>\n",
              "      <td>1.238710</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159589</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>23.224811</td>\n",
              "      <td>1.019490</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159590</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>17.373785</td>\n",
              "      <td>-0.272447</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159591</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>53.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>14.777726</td>\n",
              "      <td>-0.845671</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.333333</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1406760 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           year  month  country_id  ...  point_y  fatalities  severity_ld\n",
              "132      1990.0    1.0        56.0  ...  -34.875         NaN     0.333333\n",
              "133      1990.0    2.0        56.0  ...  -34.875         NaN     0.333333\n",
              "134      1990.0    3.0        56.0  ...  -34.875         NaN     0.333333\n",
              "135      1990.0    4.0        56.0  ...  -34.875         NaN     0.333333\n",
              "136      1990.0    5.0        56.0  ...  -34.875         NaN     0.333333\n",
              "...         ...    ...         ...  ...      ...         ...          ...\n",
              "2159587  2013.0    8.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159588  2013.0    9.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159589  2013.0   10.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159590  2013.0   11.0        53.0  ...   37.125         0.0     0.333333\n",
              "2159591  2013.0   12.0        53.0  ...   37.125         0.0     0.333333\n",
              "\n",
              "[1406760 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Dig3APlWaHwN"
      },
      "source": [
        "Fin.to_csv(r'C:\\Users\\surfb\\OneDrive\\Desktop\\Fin.csv', header=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MSbYCIMGa9qL",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "f98d45e8-a63d-4a16-b455-526a5a0a7f32"
      },
      "source": [
        "Fin_C1 = Fin.drop(['country_id', 'climate_id', 'temp_sd', 'severity_ld'], axis=1)\n",
        "Fin_C1"
      ],
      "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>year</th>\n",
              "      <th>month</th>\n",
              "      <th>temp</th>\n",
              "      <th>point_x</th>\n",
              "      <th>point_y</th>\n",
              "      <th>fatalities</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>19.498242</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>20.090117</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>19.614963</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>17.656907</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>16.014318</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159587</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>25.947117</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159588</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>24.217630</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159589</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>23.224811</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159590</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>17.373785</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159591</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>14.777726</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1406760 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           year  month       temp  point_x  point_y  fatalities\n",
              "132      1990.0    1.0  19.498242   19.125  -34.875         NaN\n",
              "133      1990.0    2.0  20.090117   19.125  -34.875         NaN\n",
              "134      1990.0    3.0  19.614963   19.125  -34.875         NaN\n",
              "135      1990.0    4.0  17.656907   19.125  -34.875         NaN\n",
              "136      1990.0    5.0  16.014318   19.125  -34.875         NaN\n",
              "...         ...    ...        ...      ...      ...         ...\n",
              "2159587  2013.0    8.0  25.947117   10.875   37.125         0.0\n",
              "2159588  2013.0    9.0  24.217630   10.875   37.125         0.0\n",
              "2159589  2013.0   10.0  23.224811   10.875   37.125         0.0\n",
              "2159590  2013.0   11.0  17.373785   10.875   37.125         0.0\n",
              "2159591  2013.0   12.0  14.777726   10.875   37.125         0.0\n",
              "\n",
              "[1406760 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PCCu8SaIemVM",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "d3268f2d-f4ef-4c44-faf8-39ffd69d309b"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 2.0]\n",
        "Fin_C1"
      ],
      "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>year</th>\n",
              "      <th>month</th>\n",
              "      <th>temp</th>\n",
              "      <th>point_x</th>\n",
              "      <th>point_y</th>\n",
              "      <th>fatalities</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>19.498242</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>19.614963</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>17.656907</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>16.014318</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>137</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>14.289014</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159587</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>25.947117</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159588</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>24.217630</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159589</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>23.224811</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159590</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>17.373785</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159591</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>14.777726</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1290936 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           year  month       temp  point_x  point_y  fatalities\n",
              "132      1990.0    1.0  19.498242   19.125  -34.875         NaN\n",
              "134      1990.0    3.0  19.614963   19.125  -34.875         NaN\n",
              "135      1990.0    4.0  17.656907   19.125  -34.875         NaN\n",
              "136      1990.0    5.0  16.014318   19.125  -34.875         NaN\n",
              "137      1990.0    6.0  14.289014   19.125  -34.875         NaN\n",
              "...         ...    ...        ...      ...      ...         ...\n",
              "2159587  2013.0    8.0  25.947117   10.875   37.125         0.0\n",
              "2159588  2013.0    9.0  24.217630   10.875   37.125         0.0\n",
              "2159589  2013.0   10.0  23.224811   10.875   37.125         0.0\n",
              "2159590  2013.0   11.0  17.373785   10.875   37.125         0.0\n",
              "2159591  2013.0   12.0  14.777726   10.875   37.125         0.0\n",
              "\n",
              "[1290936 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AYJBNSE5XFO9"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 3.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lP-Gy-FQXs2n"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 4.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "GSg2mnqvXuT6"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 1.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7zUjiAJ5Xxv_"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 5.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Jf88GoMYXzMF"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 6.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "N9nkEcf9X0d3"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 8.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pVr3odIfX2D7"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 9.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FlPhEpPlX3JA"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 10.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mWLBDgkTX4iZ"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 11.0]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dwkL9bbrX5sF",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "a6c034fc-9558-42ed-a2a5-3d04f60d3623"
      },
      "source": [
        "Fin_C1 = Fin_C1[Fin_C1.month != 12.0]\n",
        "Fin_C1"
      ],
      "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>year</th>\n",
              "      <th>month</th>\n",
              "      <th>temp</th>\n",
              "      <th>point_x</th>\n",
              "      <th>point_y</th>\n",
              "      <th>fatalities</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>138</th>\n",
              "      <td>1990.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>14.127029</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>150</th>\n",
              "      <td>1991.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>13.511719</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>162</th>\n",
              "      <td>1992.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>14.376554</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>174</th>\n",
              "      <td>1993.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>15.284355</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>186</th>\n",
              "      <td>1994.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>14.192374</td>\n",
              "      <td>19.125</td>\n",
              "      <td>-34.875</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159538</th>\n",
              "      <td>2009.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>25.192538</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159550</th>\n",
              "      <td>2010.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>24.576108</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159562</th>\n",
              "      <td>2011.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>24.847607</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159574</th>\n",
              "      <td>2012.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>25.837337</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2159586</th>\n",
              "      <td>2013.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>24.619241</td>\n",
              "      <td>10.875</td>\n",
              "      <td>37.125</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>132696 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           year  month       temp  point_x  point_y  fatalities\n",
              "138      1990.0    7.0  14.127029   19.125  -34.875         NaN\n",
              "150      1991.0    7.0  13.511719   19.125  -34.875         NaN\n",
              "162      1992.0    7.0  14.376554   19.125  -34.875         NaN\n",
              "174      1993.0    7.0  15.284355   19.125  -34.875         NaN\n",
              "186      1994.0    7.0  14.192374   19.125  -34.875         NaN\n",
              "...         ...    ...        ...      ...      ...         ...\n",
              "2159538  2009.0    7.0  25.192538   10.875   37.125         0.0\n",
              "2159550  2010.0    7.0  24.576108   10.875   37.125         0.0\n",
              "2159562  2011.0    7.0  24.847607   10.875   37.125         0.0\n",
              "2159574  2012.0    7.0  25.837337   10.875   37.125         0.0\n",
              "2159586  2013.0    7.0  24.619241   10.875   37.125         0.0\n",
              "\n",
              "[132696 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 39
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gJDnDrKtX8J3"
      },
      "source": [
        "Fin_C1.to_csv(r'C:\\Users\\surfb\\OneDrive\\Desktop\\Fin_C1.csv', header=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "laowEaoqYe_c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 252
        },
        "outputId": "70031a2d-58d6-4a20-f8e1-91ac9e1ec8e9"
      },
      "source": [
        "print (Fin_C1)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "           year  month       temp  point_x  point_y  fatalities\n",
            "138      1990.0    7.0  14.127029   19.125  -34.875         NaN\n",
            "150      1991.0    7.0  13.511719   19.125  -34.875         NaN\n",
            "162      1992.0    7.0  14.376554   19.125  -34.875         NaN\n",
            "174      1993.0    7.0  15.284355   19.125  -34.875         NaN\n",
            "186      1994.0    7.0  14.192374   19.125  -34.875         NaN\n",
            "...         ...    ...        ...      ...      ...         ...\n",
            "2159538  2009.0    7.0  25.192538   10.875   37.125         0.0\n",
            "2159550  2010.0    7.0  24.576108   10.875   37.125         0.0\n",
            "2159562  2011.0    7.0  24.847607   10.875   37.125         0.0\n",
            "2159574  2012.0    7.0  25.837337   10.875   37.125         0.0\n",
            "2159586  2013.0    7.0  24.619241   10.875   37.125         0.0\n",
            "\n",
            "[132696 rows x 6 columns]\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Sd_nvv0laYtt",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 121
        },
        "outputId": "a992d54c-5419-469f-f564-c5115f660bdc"
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Go to this URL in a browser: https://accounts.google.com/o/oauth2/auth?client_id=947318989803-6bn6qk8qdgf4n4g3pfee6491hc0brc4i.apps.googleusercontent.com&redirect_uri=urn%3aietf%3awg%3aoauth%3a2.0%3aoob&response_type=code&scope=email%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdocs.test%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive.photos.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fpeopleapi.readonly\n",
            "\n",
            "Enter your authorization code:\n",
            "··········\n",
            "Mounted at /content/drive\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nU8XMrItYuRi"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}