Extracting_Disaster_Dates.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Extracting_Disaster_Dates.ipynb",
      "provenance": [],
      "mount_file_id": "13udKKzGgiMHX48bMsXx5NPcP6n-Wg_yB",
      "authorship_tag": "ABX9TyNxzgWEOO3W9IjTU8lYuQ9L",
      "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/Max-FM/SPRINT-Colombia/blob/main/Extracting_Disaster_Dates.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kUL2SWioRUiC"
      },
      "source": [
        "# Extracting Disaster Dates from Extreme Weather Spreadsheet"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "HmL4FWUXWFOD"
      },
      "source": [
        "## Importing Extreme Weather Event Spreadsheet"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "B_J0uK62WEzN",
        "outputId": "adca4070-cac3-431e-e84f-021ded1d22d6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "disaster_dates = pd.read_excel('/content/drive/Shared drives/Colombia SPRINT/Test Districts/Colombia extreme weather in test districts.xlsx')\n",
        "\n",
        "extreme_weather_table[['Disaster', 'Start Year', 'Month', 'Day', 'End Year', 'End Month', 'End Day']]"
      ],
      "execution_count": 7,
      "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>Disaster</th>\n",
              "      <th>Start Year</th>\n",
              "      <th>Month</th>\n",
              "      <th>Day</th>\n",
              "      <th>End Year</th>\n",
              "      <th>End Month</th>\n",
              "      <th>End Day</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Drought</td>\n",
              "      <td>1998.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Flood</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>19.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Earthquake</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>26.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Flood</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>31.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>24.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Wildfire</td>\n",
              "      <td>2001.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2001.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2002.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2003.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2002.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>2002.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>29.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2003.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2003.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2004.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2004.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>28.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2004.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>7.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>17.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2006.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2006.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>27.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2006.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2007.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2007.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>2007.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>26.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2008.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2008.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>19.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2008.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>2009.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>12.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Drought</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Wildfire</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>6.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>2011.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>12.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2011.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>2011.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2011.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2011.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>31.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2012.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>2012.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>14.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Earthquake</td>\n",
              "      <td>2013.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>2013.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>9.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2013.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>2013.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2015.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2016.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Storm</td>\n",
              "      <td>2016.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>2016.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>23.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2017.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>17.0</td>\n",
              "      <td>2017.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>16.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2017.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2018.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>7.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2018.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2020.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2019.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>2019.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>26.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2020.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>2020.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>10.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Disaster  Start Year  Month   Day  End Year  End Month  End Day\n",
              "0      Drought      1998.0    1.0   1.0    1999.0        1.0      1.0\n",
              "1        Flood      1999.0    1.0  10.0    1999.0        5.0     19.0\n",
              "2   Earthquake      1999.0    1.0  25.0    1999.0        1.0     26.0\n",
              "3        Flood      1999.0   10.0  28.0    1999.0       12.0     31.0\n",
              "4        Flood      2000.0    5.0  18.0    2000.0        5.0     24.0\n",
              "5     Wildfire      2001.0    8.0   1.0    2001.0        9.0      1.0\n",
              "6      Drought      2002.0    1.0   1.0    2003.0        1.0      1.0\n",
              "7        Flood      2002.0    4.0  24.0    2002.0        4.0     29.0\n",
              "8        Flood      2003.0    8.0   1.0    2003.0       12.0      1.0\n",
              "9        Flood      2004.0    1.0   1.0    2004.0        6.0     28.0\n",
              "10     Drought      2004.0    1.0   1.0    2005.0        1.0      1.0\n",
              "11       Flood      2005.0    4.0  12.0    2005.0        5.0      7.0\n",
              "12       Flood      2005.0    9.0  15.0    2005.0       11.0     17.0\n",
              "13       Flood      2006.0    1.0   1.0    2006.0        4.0     27.0\n",
              "14     Drought      2006.0    1.0   1.0    2007.0        1.0      1.0\n",
              "15       Flood      2007.0   10.0  20.0    2007.0       10.0     26.0\n",
              "16       Flood      2008.0    1.0   1.0    2008.0        5.0     19.0\n",
              "17       Flood      2008.0   11.0  16.0    2009.0        1.0     12.0\n",
              "18     Drought         NaN    NaN   NaN       NaN        NaN      NaN\n",
              "19    Wildfire      2010.0    1.0   1.0    2010.0        4.0      6.0\n",
              "20       Flood      2010.0   10.0  30.0    2011.0        1.0     12.0\n",
              "21       Flood      2011.0    2.0  10.0    2011.0        6.0      5.0\n",
              "22       Flood      2011.0    9.0   1.0    2011.0       12.0     31.0\n",
              "23       Flood      2012.0    3.0  15.0    2012.0        5.0     14.0\n",
              "24  Earthquake      2013.0    2.0   9.0    2013.0        2.0      9.0\n",
              "25       Flood      2013.0    9.0  15.0    2013.0       12.0      1.0\n",
              "26     Drought      2015.0    8.0   1.0    2016.0        2.0      1.0\n",
              "27       Storm      2016.0    9.0  20.0    2016.0        9.0     23.0\n",
              "28       Flood      2017.0    3.0  17.0    2017.0        5.0     16.0\n",
              "29       Flood      2017.0   12.0   1.0    2018.0        1.0      7.0\n",
              "30     Drought      2018.0    1.0   1.0    2020.0        1.0      1.0\n",
              "31       Flood      2019.0    2.0  20.0    2019.0        2.0     26.0\n",
              "32       Flood      2020.0    6.0  10.0    2020.0        7.0     10.0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NwiWAKACdURZ",
        "outputId": "691ae86c-06d4-46ee-98bf-d060749e9e1a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "# Reimporting to ensure consistency in case cell is run multiple times.\n",
        "extreme_weather_table = pd.read_excel('/content/drive/Shared drives/Colombia SPRINT/Test Districts/Colombia extreme weather in test districts.xlsx')\n",
        "\n",
        "# Filling in empty values for dates.\n",
        "extreme_weather_table['Day'].fillna(1, inplace=True)\n",
        "extreme_weather_table['Month'].fillna(1, inplace=True)\n",
        "extreme_weather_table['End Day'].fillna(1, inplace=True)\n",
        "extreme_weather_table['End Month'].fillna(1, inplace=True)\n",
        "\n",
        "# Dealing with duplicate start/end dates.\n",
        "extreme_weather_table.loc[0, 'End Year'] = 1999 # Assuming this drought lasts a year.\n",
        "extreme_weather_table.loc[1, 'End Day'] = 26 # Assuming this earthquake lasts a day.\n",
        "extreme_weather_table.loc[5, 'End Month'] = 9 # Assuming this wildfire lasts a month.\n",
        "extreme_weather_table.loc[31, 'End Month'] = 7 # Assuming this flood event lasts a month.\n",
        "\n",
        "# Converting date columns into a single datetime column.\n",
        "extreme_weather_table['Start_Datetime'] = pd.to_datetime(extreme_weather_table['Start Year'].astype(str) + '-' +\n",
        "                                          extreme_weather_table['Month'].astype(int).astype(str) + '-' +\n",
        "                                          extreme_weather_table['Day'].astype(int).astype(str))\n",
        "\n",
        "extreme_weather_table['End_Datetime'] = pd.to_datetime(extreme_weather_table['End Year'].astype(str) + '-' +\n",
        "                                        extreme_weather_table['End Month'].astype(int).astype(str) + '-' +\n",
        "                                        extreme_weather_table['End Day'].astype(int).astype(str))\n",
        "\n",
        "\n",
        "# Adding in missing events.\n",
        "extreme_weather_table = extreme_weather_table.append({'Disaster': 'Drought', \n",
        "                                                     'Start_Datetime': pd.to_datetime('2009-01-01'), \n",
        "                                                     'End_Datetime': pd.to_datetime('2010-01-01')},\n",
        "                                                     ignore_index=True) \\\n",
        "                                             .sort_values(by='Start_Datetime') \\\n",
        "                                             .reset_index() # 2009 El Nino drought.\n",
        "\n",
        "disaster_dates = extreme_weather_table[['Disaster', 'Start_Datetime', 'End_Datetime']]\n",
        "\n",
        "disaster_dates"
      ],
      "execution_count": 5,
      "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>Disaster</th>\n",
              "      <th>Start_Datetime</th>\n",
              "      <th>End_Datetime</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Drought</td>\n",
              "      <td>1998-01-01</td>\n",
              "      <td>1999-01-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Flood</td>\n",
              "      <td>1999-01-10</td>\n",
              "      <td>1999-05-19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Earthquake</td>\n",
              "      <td>1999-01-25</td>\n",
              "      <td>1999-01-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Flood</td>\n",
              "      <td>1999-10-28</td>\n",
              "      <td>1999-12-31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2000-05-18</td>\n",
              "      <td>2000-05-24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Wildfire</td>\n",
              "      <td>2001-08-01</td>\n",
              "      <td>2001-09-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2002-01-01</td>\n",
              "      <td>2003-01-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2002-04-24</td>\n",
              "      <td>2002-04-29</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2003-08-01</td>\n",
              "      <td>2003-12-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2004-01-01</td>\n",
              "      <td>2004-06-28</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2004-01-01</td>\n",
              "      <td>2005-01-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2005-04-12</td>\n",
              "      <td>2005-05-07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2005-09-15</td>\n",
              "      <td>2005-11-17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2006-01-01</td>\n",
              "      <td>2006-04-27</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2006-01-01</td>\n",
              "      <td>2007-01-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2007-10-20</td>\n",
              "      <td>2007-10-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2008-01-01</td>\n",
              "      <td>2008-05-19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2008-11-16</td>\n",
              "      <td>2009-01-12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2009-01-01</td>\n",
              "      <td>2010-01-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Wildfire</td>\n",
              "      <td>2010-01-01</td>\n",
              "      <td>2010-04-06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2010-10-30</td>\n",
              "      <td>2011-01-12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2011-02-10</td>\n",
              "      <td>2011-06-05</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2011-09-01</td>\n",
              "      <td>2011-12-31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2012-03-15</td>\n",
              "      <td>2012-05-14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Earthquake</td>\n",
              "      <td>2013-02-09</td>\n",
              "      <td>2013-02-09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2013-09-15</td>\n",
              "      <td>2013-12-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2015-08-01</td>\n",
              "      <td>2016-02-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Storm</td>\n",
              "      <td>2016-09-20</td>\n",
              "      <td>2016-09-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2017-03-17</td>\n",
              "      <td>2017-05-16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2017-12-01</td>\n",
              "      <td>2018-01-07</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Drought</td>\n",
              "      <td>2018-01-01</td>\n",
              "      <td>2020-01-01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2019-02-20</td>\n",
              "      <td>2019-02-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Flood</td>\n",
              "      <td>2020-06-10</td>\n",
              "      <td>2020-07-10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Disaster Start_Datetime End_Datetime\n",
              "0      Drought     1998-01-01   1999-01-01\n",
              "1        Flood     1999-01-10   1999-05-19\n",
              "2   Earthquake     1999-01-25   1999-01-26\n",
              "3        Flood     1999-10-28   1999-12-31\n",
              "4        Flood     2000-05-18   2000-05-24\n",
              "5     Wildfire     2001-08-01   2001-09-01\n",
              "6      Drought     2002-01-01   2003-01-01\n",
              "7        Flood     2002-04-24   2002-04-29\n",
              "8        Flood     2003-08-01   2003-12-01\n",
              "9        Flood     2004-01-01   2004-06-28\n",
              "10     Drought     2004-01-01   2005-01-01\n",
              "11       Flood     2005-04-12   2005-05-07\n",
              "12       Flood     2005-09-15   2005-11-17\n",
              "13       Flood     2006-01-01   2006-04-27\n",
              "14     Drought     2006-01-01   2007-01-01\n",
              "15       Flood     2007-10-20   2007-10-26\n",
              "16       Flood     2008-01-01   2008-05-19\n",
              "17       Flood     2008-11-16   2009-01-12\n",
              "18     Drought     2009-01-01   2010-01-01\n",
              "19    Wildfire     2010-01-01   2010-04-06\n",
              "20       Flood     2010-10-30   2011-01-12\n",
              "21       Flood     2011-02-10   2011-06-05\n",
              "22       Flood     2011-09-01   2011-12-31\n",
              "23       Flood     2012-03-15   2012-05-14\n",
              "24  Earthquake     2013-02-09   2013-02-09\n",
              "25       Flood     2013-09-15   2013-12-01\n",
              "26     Drought     2015-08-01   2016-02-01\n",
              "27       Storm     2016-09-20   2016-09-23\n",
              "28       Flood     2017-03-17   2017-05-16\n",
              "29       Flood     2017-12-01   2018-01-07\n",
              "30     Drought     2018-01-01   2020-01-01\n",
              "31       Flood     2019-02-20   2019-02-26\n",
              "32       Flood     2020-06-10   2020-07-10"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lF-gxzG9Retn"
      },
      "source": [
        "# Exporting extracted and amended disaster dates to CSV format.\n",
        "disaster_dates.to_csv('/content/drive/Shared drives/Colombia SPRINT/Test Districts/disaster_dates.csv')"
      ],
      "execution_count": 6,
      "outputs": []
    }
  ]
}