pandas_import_html_table.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:df3007f07bd5bd10bedbc51d078340c76b1cb1cdde8f49b00c80571d9c989941"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# Importing an HTML table into pandas\n",
      "\n",
      "This snippit was written by [Chris R. Albon](http://www.chrisralbon.com/) and is part of his collection of [well-documented Python snippits](https://github.com/chrisalbon/code_py). All code is written in Python 3 in iPython notebook and offered under the [Creative Commons Attribution-ShareAlike 4.0 International License](http://creativecommons.org/licenses/by-sa/4.0/)."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# Import the required module\n",
      "import pandas as pd"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 46
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# Create a variable with the url to the website contain the html table\n",
      "url = \"http://floodobservatory.colorado.edu/Archives/MasterListrev.htm\""
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 47
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# Read the html table into pandas\n",
      "data = pd.read_html(url, header=0)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 48
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "The resulting data will be a list of dataframe objects"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# View the data\n",
      "data"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 49,
       "text": [
        "[    Register  #  Annual DFO #  (discontinued)             Glide #  \\\n",
        " 0          4163                           NaN                   0   \n",
        " 1          4162                           NaN                   0   \n",
        " 2          4161                           NaN                   0   \n",
        " 3          4160                           NaN                   0   \n",
        " 4          4159                           NaN                   0   \n",
        " 5          4158                           NaN                   0   \n",
        " 6          4157                           NaN                   0   \n",
        " 7          4156                           NaN                   0   \n",
        " 8          4155                           NaN                   0   \n",
        " 9          4154                           NaN                   0   \n",
        " 10         4153                           NaN                   0   \n",
        " 11         4152                           NaN                   0   \n",
        " 12         4151                           NaN                   0   \n",
        " 13         4150                           NaN                   0   \n",
        " 14         4149                           NaN                   0   \n",
        " 15         4148                           NaN  TC-2014-000071-MEX   \n",
        " 16         4147                           NaN                   0   \n",
        " 17         4146                           NaN                   0   \n",
        " 18         4145                           NaN  FL-2014-000070-LKA   \n",
        " 19         4144                           NaN                   0   \n",
        " 20         4143                           NaN  FL-2014-000062-CHN   \n",
        " 21         4142                           NaN  FL-2014-000063-TJK   \n",
        " 22         4141                           NaN                   0   \n",
        " 23         4140                           NaN                   0   \n",
        " 24         4139                           NaN                   0   \n",
        " 25         4138                           NaN  FF-2014-000059-SRB   \n",
        " 26         4137                           NaN                   0   \n",
        " 27         4136                           NaN  FF-2014-000060-AFG   \n",
        " 28         4135                           NaN                   0   \n",
        " 29         4134                           NaN                   0   \n",
        " 30         4133                           NaN                   0   \n",
        " 31         4132                           NaN  FL-2014-000045-SLB   \n",
        " 32         4131                           NaN  FL-2014-000038-ZAF   \n",
        " 33         4130                           NaN                   0   \n",
        " 34         4129                           NaN                   0   \n",
        " 35         4128                           NaN                   0   \n",
        " 36         4127                           NaN  FL-2014-000030-PRY   \n",
        " 37         4126                           NaN                   0   \n",
        " 38         4125                           NaN                   0   \n",
        " 39         4124                           NaN  SS-2014-000032-MHL   \n",
        " 40         4123                           NaN                   0   \n",
        " 41         4122                           NaN                   0   \n",
        " 42         4121                           NaN                   0   \n",
        " 43         4120                           NaN                   0   \n",
        " 44         4119                           NaN                   0   \n",
        " 45         4118                           NaN                   0   \n",
        " 46         4117                           NaN  FL-2014-000008-BOL   \n",
        " 47         4116                           NaN                   0   \n",
        " 48         4115                           NaN                   0   \n",
        " 49         4114                           NaN  FL-2013-000159-LCA   \n",
        " 50         4113                           NaN  FL-2013-000157-BRA   \n",
        " 51         4112                           NaN                   0   \n",
        " 52         4111                           NaN                   0   \n",
        " 53         4110                           NaN  FL-2013-000149-THA   \n",
        " 54         4109                           NaN                   0   \n",
        " 55         4108                           NaN                   0   \n",
        " 56         4107                           NaN  FL-2013-000148-MYS   \n",
        " 57         4106                           NaN                   0   \n",
        " 58         4105                           NaN  FL-2013-000141-SOM   \n",
        " 59         4104                           NaN                   0   \n",
        "             ...                           ...                 ...   \n",
        " \n",
        "             Country      Other  Nations  Affected  \\\n",
        " 0            Brazil    Uruguay      NaN       NaN   \n",
        " 1             Nepal          0      NaN       NaN   \n",
        " 2        Bangladesh          0      NaN       NaN   \n",
        " 3               USA          0      NaN       NaN   \n",
        " 4            Brazil          0      NaN       NaN   \n",
        " 5             Sudan          0      NaN       NaN   \n",
        " 6       New Zealand          0      NaN       NaN   \n",
        " 7          Thailand          0      NaN       NaN   \n",
        " 8             China          0      NaN       NaN   \n",
        " 9             India          0      NaN       NaN   \n",
        " 10      Philippines          0      NaN       NaN   \n",
        " 11              USA          0      NaN       NaN   \n",
        " 12         Bulgaria          0      NaN       NaN   \n",
        " 13         Paraguay     Brazil      NaN       NaN   \n",
        " 14           Russia          0      NaN       NaN   \n",
        " 15           Mexico  Guatamala      NaN       NaN   \n",
        " 16             Iran          0      NaN       NaN   \n",
        " 17            China          0      NaN       NaN   \n",
        " 18        Sri Lanka          0      NaN       NaN   \n",
        " 19      Afghanistan          0      NaN       NaN   \n",
        " 20            China          0      NaN       NaN   \n",
        " 21       Tajikistan          0      NaN       NaN   \n",
        " 22            Italy          0      NaN       NaN   \n",
        " 23         Tanzania          0      NaN       NaN   \n",
        " 24           Serbia     Bosnia      NaN       NaN   \n",
        " 25          Romania   Bulgaria      NaN       NaN   \n",
        " 26         Tanzania          0      NaN       NaN   \n",
        " 27      Afghanistan          0      NaN       NaN   \n",
        " 28              USA          0      NaN       NaN   \n",
        " 29              USA          0      NaN       NaN   \n",
        " 30        Argentina          0      NaN       NaN   \n",
        " 31  Solomon Islands          0      NaN       NaN   \n",
        " 32     South Africa    Namibia      NaN       NaN   \n",
        " 33        Australia          0      NaN       NaN   \n",
        " 34              USA          0      NaN       NaN   \n",
        " 35          Zimbawe          0      NaN       NaN   \n",
        " 36         Paraguay          0      NaN       NaN   \n",
        " 37          Burundi          0      NaN       NaN   \n",
        " 38      New Zealand          0      NaN       NaN   \n",
        " 39              USA          0      NaN       NaN   \n",
        " 40       Mozambique          0      NaN       NaN   \n",
        " 41           France      Italy      NaN       NaN   \n",
        " 42        Indonesia          0      NaN       NaN   \n",
        " 43        Australia          0      NaN       NaN   \n",
        " 44          Zimbawe          0      NaN       NaN   \n",
        " 45          Zimbawe          0      NaN       NaN   \n",
        " 46          Bolivia          0      NaN       NaN   \n",
        " 47             Peru          0      NaN       NaN   \n",
        " 48              USA          0      NaN       NaN   \n",
        " 49    Saint Vincent  St. Lucia      NaN       NaN   \n",
        " 50           Brazil          0      NaN       NaN   \n",
        " 51        Indonesia          0      NaN       NaN   \n",
        " 52   United Kingdom    Ireland      NaN       NaN   \n",
        " 53         Thailand          0      NaN       NaN   \n",
        " 54             Cuba          0      NaN       NaN   \n",
        " 55            Niger          0      NaN       NaN   \n",
        " 56         Malaysia          0      NaN       NaN   \n",
        " 57   United Kingdom    Germany      NaN       NaN   \n",
        " 58          Somalia          0      NaN       NaN   \n",
        " 59     Saudi Arabia          0      NaN       NaN   \n",
        "                 ...        ...      ...       ...   \n",
        " \n",
        "    Detailed  Locations (click on active links to access inundation extents)  \\\n",
        " 0           State of Rio Grande do Sul; Uruguay River                         \n",
        " 1   Sindhupalchok, Lalitpur and Chitwan districts ...                         \n",
        " 2   Bhola District in the Division of Barisal, Ban...                         \n",
        " 3          Mendenhall Lake and  River, Juneau, Alaska                         \n",
        " 4   Amazonas State; Northwestern Brazil; Careiro d...                         \n",
        " 5   Sinja locality in the eastern Sudan state of S...                         \n",
        " 6   North Island, Hikurangi Swamp area, north of W...                         \n",
        " 7                      Rayong, Chiang Rai, and  Trang                         \n",
        " 8   Southern China; Hunan,  Jiangxi provinces; Gua...                         \n",
        " 9                                               Assam                         \n",
        " 10        Southern Philippine province of Maguindanao                         \n",
        " 11  South Dakota, Iowa, Illinois, Missouri, Minnesota                         \n",
        " 12  Eastern Bulgaria; Varna district of Asparuhov;...                         \n",
        " 13  Southern Brazil, Parana State; Paraguay River ...                         \n",
        " 14  Altai region, Khakassia  Republic, and Altai R...                         \n",
        " 15                     Chiapas, SE Mexico.W Guatamala                         \n",
        " 16          Khorasan, Mazandaran and Semnan provinces                         \n",
        " 17                 Southern China, Guangdong Province                         \n",
        " 18                     Western districts of Sri Lanka                         \n",
        " 19                                    Baghlan provinc                         \n",
        " 20  Hunan Province, including Guiyang, Shenzhen ci...                         \n",
        " 21  Khatlon Province, Rudaki and Vahdat districts,...                         \n",
        " 22                     Marche region of central Italy                         \n",
        " 23                    Rufiji District in Coast Region                         \n",
        " 24                             Bosnia,Serbia, Croatia                         \n",
        " 25                 Bulgaria, Serbia, southern Romania                         \n",
        " 26                               Dar es Salaam region                         \n",
        " 27  Northwestern Afghanistan; Jowzjan Province, pr...                         \n",
        " 28               Gulf Coast; Northeast Atlantic Coast                         \n",
        " 29             Southern Alabama, southern Mississippi                         \n",
        " 30                       Western province of Neuquenr                         \n",
        " 31                                            Honiara                         \n",
        " 32                         SADC region, Zambezi River                         \n",
        " 33  Southeast and Central Queensland; Yeppoon area...                         \n",
        " 34             Southern Mississippi, Wilkinson County                         \n",
        " 35                                       Tokwe-Mukosi                         \n",
        " 36   Luque, Mariano Roque Alonso, Lambar\u00e9, and Limpio                         \n",
        " 37                                          Bujumbura                         \n",
        " 38                 Christchurch, including Avon River                         \n",
        " 39                                             Majuro                         \n",
        " 40  Johannesburg , Kliptown, Soweto; eastern South...                         \n",
        " 41  Southeastern France, western France, Pisa, Lig...                         \n",
        " 42                                 Jakarta, Tangerang                         \n",
        " 43                        Top End, Northern Territory                         \n",
        " 44  Communities downstream of the Tokwe-Mukrosi Da...                         \n",
        " 45                                         Muzarabani                         \n",
        " 46  La Paz, Beni, Santa Cruz  and Cochabamba; Beni...                         \n",
        " 47                       Southern Andean Cusco region                         \n",
        " 48              Nelson and Carroll Counties, Kentucky                         \n",
        " 49        Saint Vincent and the Grenadines, St. Lucia                         \n",
        " 50  Southeast states of Minas Gerais and Espirito ...                         \n",
        " 51                    North Sumatras Langkat district                         \n",
        " 52  Central and southern Scotland, Wales, Ireland,...                         \n",
        " 53  Southeast provinces; Nakhon Si Thammarat, Song...                         \n",
        " 54                                             Havana                         \n",
        " 55                 South-east Niger, Komadougou River                         \n",
        " 56  Kuala Lumpur, east coast states of Pahang and ...                         \n",
        " 57     Eastern England coast, northern European coast                         \n",
        " 58                                 Northeast Puntland                         \n",
        " 59  Riyadh, other parts of the Kingdom including n...                         \n",
        "                                                   ...                         \n",
        " \n",
        "    Validation  (post event #3503)      Began      Ended  Duration in  Days  \\\n",
        " 0                            News 2014-07-03 2014-07-14                 12   \n",
        " 1                            News 2014-07-01 2014-07-14                 14   \n",
        " 2                            News 2014-07-13 2014-07-14                  2   \n",
        " 3                            News 2014-07-11 2014-07-14                  4   \n",
        " 4                            News 2014-05-22 2014-07-14                 54   \n",
        " 5                            News 2014-07-07 2014-07-14                  8   \n",
        " 6                            News 2014-07-05 2014-07-14                 10   \n",
        " 7                            News 2014-07-11 2014-07-14                  4   \n",
        " 8                            News 2014-06-05 2014-06-25                 21   \n",
        " 9                            News 2014-06-23 2014-06-25                  3   \n",
        " 10                           News 2014-06-17 2014-06-25                  9   \n",
        " 11                           News 2014-06-10 2014-07-14                 35   \n",
        " 12                           News 2014-06-19 2014-06-25                  7   \n",
        " 13                           News 2014-06-03 2014-07-14                 42   \n",
        " 14                           News 2014-06-04 2014-06-10                  7   \n",
        " 15                           News 2014-06-01 2014-06-10                 10   \n",
        " 16                           News 2014-06-01 2014-06-10                 10   \n",
        " 17                           News 2014-05-30 2014-06-10                 12   \n",
        " 18                           News 2014-06-04 2014-06-10                  7   \n",
        " 19                           News 2014-06-03 2014-06-10                  8   \n",
        " 20                           News 2014-05-12 2014-05-16                  5   \n",
        " 21                           News 2014-05-10 2014-05-16                  7   \n",
        " 22                           News 2014-05-02 2014-05-10                  9   \n",
        " 23                           News 2014-05-10 2014-05-16                  7   \n",
        " 24                           News 2014-05-12 2014-05-16                  5   \n",
        " 25                           News 2014-04-17 2014-05-01                 15   \n",
        " 26                           News 2014-04-18 2014-05-01                 14   \n",
        " 27                           News 2014-04-20 2014-05-16                 27   \n",
        " 28                           News 2014-04-30 2014-05-01                  2   \n",
        " 29                           News 2014-04-01 2014-04-08                  8   \n",
        " 30                           News 2014-04-01 2014-04-08                  8   \n",
        " 31                           News 2014-04-01 2014-04-08                  8   \n",
        " 32                           News 2014-03-01 2014-03-30                 30   \n",
        " 33                           News 2014-03-24 2014-03-30                  7   \n",
        " 34                           News 2014-03-25 2014-03-30                  6   \n",
        " 35                           News 2014-02-01 2014-03-30                 58   \n",
        " 36                           News 2014-02-25 2014-03-10                 14   \n",
        " 37                           News 2014-02-19 2014-03-10                 20   \n",
        " 38                           News 2014-03-03 2014-03-10                  8   \n",
        " 39                           News 2014-03-03 2014-03-10                  8   \n",
        " 40                           News 2014-02-24 2014-03-10                 15   \n",
        " 41                           News 2014-01-20 2014-02-07                 19   \n",
        " 42                           News 2014-01-08 2014-02-07                 31   \n",
        " 43                           News 2014-02-02 2014-02-07                  6   \n",
        " 44                           News 2014-01-15 2014-02-07                 24   \n",
        " 45                           News 2014-01-15 2014-02-07                 24   \n",
        " 46                           News 2014-01-10 2014-05-01                112   \n",
        " 47                           News 2014-01-01 2014-01-04                  4   \n",
        " 48                           News 2013-12-22 2014-01-04                 14   \n",
        " 49                           News 2013-12-26 2014-01-04                 10   \n",
        " 50                           News 2013-12-23 2014-01-04                 13   \n",
        " 51                           News 2013-12-29 2014-01-04                  7   \n",
        " 52                           News 2013-12-27 2014-02-07                 43   \n",
        " 53                           News 2013-11-20 2013-12-08                 19   \n",
        " 54                           News 2013-12-01 2013-12-08                  8   \n",
        " 55                           News 2013-11-03 2013-12-08                 36   \n",
        " 56                           News 2013-12-01 2013-12-08                  8   \n",
        " 57                           News 2013-12-05 2013-12-08                  4   \n",
        " 58                           News 2013-11-08 2013-11-19                 12   \n",
        " 59                           News 2013-11-18 2013-11-19                  2   \n",
        "                               ...        ...        ...                ...   \n",
        " \n",
        "     Dead  Displaced  Damage (USD)                 Main cause  Severity *  \\\n",
        " 0     10      50000           NaN                 Heavy Rain         2.0   \n",
        " 1     16       2400           NaN            Torrential Rain         1.5   \n",
        " 2      0      30000           NaN  Heavy Rain and  High Tide         1.5   \n",
        " 3      0          0           NaN                 J\u00f6kulhlaup         1.0   \n",
        " 4      0          0           NaN                 Heavy Rain         2.0   \n",
        " 5      0      42400           NaN                 Heavy Rain         1.5   \n",
        " 6      0          0           NaN                 Heavy Rain         1.0   \n",
        " 7      0        500           NaN                 Heavy Rain         1.0   \n",
        " 8     14     337000           NaN             Monsoonal Rain         1.0   \n",
        " 9      0      10000           NaN              Monsoonal Ran         1.0   \n",
        " 10     0      35000           NaN                 Heavy Rain         1.0   \n",
        " 11     0        600           NaN                 Heavy Rain         2.0   \n",
        " 12    12       2000           NaN            Torrential Rain         2.0   \n",
        " 13     9     265000           NaN                  Heay Rain         2.0   \n",
        " 14    70       3000           NaN            Torrential Rain         1.5   \n",
        " 15    22      25000           NaN             Monsoonal Rain         1.5   \n",
        " 16    37     440000           NaN             Monsoonal Rain         1.5   \n",
        " 17     6        500           NaN                 Heavy Rain         1.0   \n",
        " 18     5      16000           NaN      Tropical Storm  Boris         1.5   \n",
        " 19     0        300           NaN                 Heavy Rain         1.5   \n",
        " 20     1      10000           NaN                 Heavy Rain         2.0   \n",
        " 21     0        425           NaN                 Heavy Rain         1.5   \n",
        " 22     2        250           NaN            Torrential Rain         1.5   \n",
        " 23     0      22000           NaN                 Heavy Rain         1.0   \n",
        " 24     3       4000           NaN                 Heavy Rain         2.0   \n",
        " 25     0        640           NaN            Torrential Rain         1.5   \n",
        " 26    41          0           NaN            Torrential Rain         1.5   \n",
        " 27   123       6000           NaN            Torrential Rain         1.5   \n",
        " 28     1        200           NaN            Torrential Rain         2.0   \n",
        " 29     2        300           NaN                 heavy Rain         1.5   \n",
        " 30     0       2000           NaN                 Heavy Rain         1.5   \n",
        " 31    23      10000           NaN                 Heavy Rain         2.0   \n",
        " 32    37       3528           NaN                 Heavy Rain         1.5   \n",
        " 33     1          0           NaN            Torrential Rain         1.5   \n",
        " 34     0        200           NaN                 Heavy Rain         1.5   \n",
        " 35     0       4000           NaN                  Dam Break         1.0   \n",
        " 36     0       2000           NaN                 Heavy Rain         1.0   \n",
        " 37    69      20000           NaN            Torrential Rain         2.0   \n",
        " 38     0         80           NaN                 Heavy Rain         2.0   \n",
        " 39     0        900           NaN                Storm Surge         1.5   \n",
        " 40     4      20000           NaN                 Heavy Rain         1.0   \n",
        " 41     4       1000           NaN                 Heavy Rain         1.5   \n",
        " 42    23      20000           NaN                 Heavy Rain         1.5   \n",
        " 43     0          0           NaN   Tropical Storm  Fletcher         1.0   \n",
        " 44     0       4000           NaN                 Heavy Rain         1.5   \n",
        " 45     0          0           NaN                 Heavy Rain         1.5   \n",
        " 46    60      84000           NaN                 Heavy Rain         2.0   \n",
        " 47     0        300           NaN                 Heavy Rain         1.0   \n",
        " 48     5          0           NaN                 Heavy Rain         1.0   \n",
        " 49    11          0           NaN                 Heavy Rain         1.0   \n",
        " 50    45      60000           NaN                 Heavy Rain         2.0   \n",
        " 51     0       4500           NaN                 Heavy Rain         1.0   \n",
        " 52     0        200           NaN                 Heavy Rain         1.5   \n",
        " 53    23      15254           NaN             Monsoonal Rain         1.5   \n",
        " 54     2        227           NaN            Torrential Rain         1.0   \n",
        " 55     0       1000           NaN                 Heavy Rain         1.0   \n",
        " 56     1      19000           NaN             Monsoonal Rain         1.5   \n",
        " 57     8       4000           NaN                Storm Surge         2.0   \n",
        " 58   100          0           NaN             Tropical Storm         1.5   \n",
        " 59    15        121           NaN            Torrential Rain         1.5   \n",
        "      ...        ...           ...                        ...         ...   \n",
        " \n",
        "     Affected sq  km  Magnitude  (M)**  Centroid X      \n",
        " 0        44866.4600               6.0   -58.02560 ...  \n",
        " 1        11578.7700               5.4    84.62070 ...  \n",
        " 2          217.5290               2.8    90.54980 ...  \n",
        " 3         2950.8200               4.1  -134.44600 ...  \n",
        " 4       256564.5700               7.4   -59.55970 ...  \n",
        " 5       137141.2800               6.2    33.08000 ...  \n",
        " 6         8581.2400               4.9   174.06800 ...  \n",
        " 7        15921.6300               4.8    99.73900 ...  \n",
        " 8       377101.6300               6.9   112.35800 ...  \n",
        " 9        49220.5300               5.2    94.71600 ...  \n",
        " 10       15356.3100               5.1   124.73000 ...  \n",
        " 11      418317.1300               7.5   -94.79440 ...  \n",
        " 12       24415.4200               5.5    27.04260 ...  \n",
        " 13      554605.2500               7.7   -53.54700 ...  \n",
        " 14     1829701.4000               7.3    94.36960 ...  \n",
        " 15      113685.4300               6.2   -94.02740 ...  \n",
        " 16      305525.2500               6.7    57.25440 ...  \n",
        " 17       45994.3000               5.7   113.34200 ...  \n",
        " 18       10337.4700               5.0    80.16680 ...  \n",
        " 19       44203.9300               5.7    68.01780 ...  \n",
        " 20      205001.2700               6.3   111.46700 ...  \n",
        " 21       41719.4600               5.6    69.37870 ...  \n",
        " 22       11256.3300               5.2    13.01300 ...  \n",
        " 23       22249.3400               5.2    38.94420 ...  \n",
        " 24      115747.6900               6.1    19.22360 ...  \n",
        " 25       87430.6900               6.3    24.49400 ...  \n",
        " 26       18498.3900               5.6    38.96890 ...  \n",
        " 27       83722.3400               6.5    66.43420 ...  \n",
        " 28      260469.8100               6.0   -84.94650 ...  \n",
        " 29       82418.5600               6.0   -87.61880 ...  \n",
        " 30       69876.7800               5.9   -70.29840 ...  \n",
        " 31        5480.7500               4.9   160.34200 ...  \n",
        " 32     1037639.2000               7.7    25.60740 ...  \n",
        " 33      250162.1200               6.4   150.11700 ...  \n",
        " 34       53220.7900               5.7   -89.12820 ...  \n",
        " 35       17205.6400               6.0    31.34790 ...  \n",
        " 36        6829.5700               5.0   -57.58330 ...  \n",
        " 37        3237.4200               5.1    29.64990 ...  \n",
        " 38        1015.8400               4.2   172.61300 ...  \n",
        " 39          34.8366               2.6   168.72900 ...  \n",
        " 40      481907.8800               6.9    31.54590 ...  \n",
        " 41       82989.4500               6.4     7.09930 ...  \n",
        " 42       35769.2200               6.2   107.70600 ...  \n",
        " 43      426979.8400               6.4   131.73200 ...  \n",
        " 44       72462.2300               6.4    28.92310 ...  \n",
        " 45      142586.1000               6.7    30.85310 ...  \n",
        " 46      381576.6500               7.9   -64.01350 ...  \n",
        " 47       74144.6600               5.5   -71.52320 ...  \n",
        " 48       16069.9100               5.4   -86.78990 ...  \n",
        " 49         830.2320               3.9   -60.98860 ...  \n",
        " 50      314284.9100               6.9   -41.94230 ...  \n",
        " 51       22524.6300               5.2    97.28930 ...  \n",
        " 52      126149.7900               6.9    -1.51144 ...  \n",
        " 53       38676.7100               6.0   100.39500 ...  \n",
        " 54        7627.3000               4.8   -81.39580 ...  \n",
        " 55       65791.1400               6.4    13.20170 ...  \n",
        " 56      106697.5300               6.1   102.36200 ...  \n",
        " 57       51279.6000               5.6     7.53306 ...  \n",
        " 58      181848.0200               6.5    57.42760 ...  \n",
        " 59      361386.8400               6.0    44.80840 ...  \n",
        "                 ...               ...         ...      \n",
        " \n",
        " [276 rows x 29 columns]]"
       ]
      }
     ],
     "prompt_number": 49
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# Select the first (and in this case only) dataframe object\n",
      "data[0]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>Register  #</th>\n",
        "      <th>Annual DFO #  (discontinued)</th>\n",
        "      <th>Glide #</th>\n",
        "      <th>Country</th>\n",
        "      <th>Other</th>\n",
        "      <th>Nations</th>\n",
        "      <th>Affected</th>\n",
        "      <th>Detailed  Locations (click on active links to access inundation extents)</th>\n",
        "      <th>Validation  (post event #3503)</th>\n",
        "      <th>Began</th>\n",
        "      <th>Ended</th>\n",
        "      <th>Duration in  Days</th>\n",
        "      <th>Dead</th>\n",
        "      <th>Displaced</th>\n",
        "      <th>Damage (USD)</th>\n",
        "      <th>Main cause</th>\n",
        "      <th>Severity *</th>\n",
        "      <th>Affected sq  km</th>\n",
        "      <th>Magnitude  (M)**</th>\n",
        "      <th>Centroid X</th>\n",
        "      <th></th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> 4163</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>          Brazil</td>\n",
        "      <td>   Uruguay</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>         State of Rio Grande do Sul; Uruguay River</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-07-03</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>  12</td>\n",
        "      <td>  10</td>\n",
        "      <td>  50000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>   44866.4600</td>\n",
        "      <td> 6.0</td>\n",
        "      <td> -58.02560</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> 4162</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>           Nepal</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Sindhupalchok, Lalitpur and Chitwan districts ...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-07-01</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>  14</td>\n",
        "      <td>  16</td>\n",
        "      <td>   2400</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   11578.7700</td>\n",
        "      <td> 5.4</td>\n",
        "      <td>  84.62070</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> 4161</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>      Bangladesh</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Bhola District in the Division of Barisal, Ban...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-07-13</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>   2</td>\n",
        "      <td>   0</td>\n",
        "      <td>  30000</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Heavy Rain and  High Tide</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>     217.5290</td>\n",
        "      <td> 2.8</td>\n",
        "      <td>  90.54980</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> 4160</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>             USA</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>        Mendenhall Lake and  River, Juneau, Alaska</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-07-11</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>   4</td>\n",
        "      <td>   0</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                J\u00f6kulhlaup</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>    2950.8200</td>\n",
        "      <td> 4.1</td>\n",
        "      <td>-134.44600</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> 4159</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>          Brazil</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Amazonas State; Northwestern Brazil; Careiro d...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-05-22</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>  54</td>\n",
        "      <td>   0</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  256564.5700</td>\n",
        "      <td> 7.4</td>\n",
        "      <td> -59.55970</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> 4158</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>           Sudan</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Sinja locality in the eastern Sudan state of S...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-07-07</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>   8</td>\n",
        "      <td>   0</td>\n",
        "      <td>  42400</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  137141.2800</td>\n",
        "      <td> 6.2</td>\n",
        "      <td>  33.08000</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> 4157</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>     New Zealand</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> North Island, Hikurangi Swamp area, north of W...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-07-05</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>  10</td>\n",
        "      <td>   0</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>    8581.2400</td>\n",
        "      <td> 4.9</td>\n",
        "      <td> 174.06800</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> 4156</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>        Thailand</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                    Rayong, Chiang Rai, and  Trang</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-07-11</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>   4</td>\n",
        "      <td>   0</td>\n",
        "      <td>    500</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   15921.6300</td>\n",
        "      <td> 4.8</td>\n",
        "      <td>  99.73900</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> 4155</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>           China</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Southern China; Hunan,  Jiangxi provinces; Gua...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-05</td>\n",
        "      <td>2014-06-25</td>\n",
        "      <td>  21</td>\n",
        "      <td>  14</td>\n",
        "      <td> 337000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Monsoonal Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>  377101.6300</td>\n",
        "      <td> 6.9</td>\n",
        "      <td> 112.35800</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> 4154</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>           India</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                             Assam</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-23</td>\n",
        "      <td>2014-06-25</td>\n",
        "      <td>   3</td>\n",
        "      <td>   0</td>\n",
        "      <td>  10000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>             Monsoonal Ran</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   49220.5300</td>\n",
        "      <td> 5.2</td>\n",
        "      <td>  94.71600</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> 4153</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>     Philippines</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>       Southern Philippine province of Maguindanao</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-17</td>\n",
        "      <td>2014-06-25</td>\n",
        "      <td>   9</td>\n",
        "      <td>   0</td>\n",
        "      <td>  35000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   15356.3100</td>\n",
        "      <td> 5.1</td>\n",
        "      <td> 124.73000</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> 4152</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>             USA</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> South Dakota, Iowa, Illinois, Missouri, Minnesota</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-10</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>  35</td>\n",
        "      <td>   0</td>\n",
        "      <td>    600</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  418317.1300</td>\n",
        "      <td> 7.5</td>\n",
        "      <td> -94.79440</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td> 4151</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>        Bulgaria</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Eastern Bulgaria; Varna district of Asparuhov;...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-19</td>\n",
        "      <td>2014-06-25</td>\n",
        "      <td>   7</td>\n",
        "      <td>  12</td>\n",
        "      <td>   2000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>   24415.4200</td>\n",
        "      <td> 5.5</td>\n",
        "      <td>  27.04260</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td> 4150</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>        Paraguay</td>\n",
        "      <td>    Brazil</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Southern Brazil, Parana State; Paraguay River ...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-03</td>\n",
        "      <td>2014-07-14</td>\n",
        "      <td>  42</td>\n",
        "      <td>   9</td>\n",
        "      <td> 265000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                 Heay Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  554605.2500</td>\n",
        "      <td> 7.7</td>\n",
        "      <td> -53.54700</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td> 4149</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>          Russia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Altai region, Khakassia  Republic, and Altai R...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-04</td>\n",
        "      <td>2014-06-10</td>\n",
        "      <td>   7</td>\n",
        "      <td>  70</td>\n",
        "      <td>   3000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td> 1829701.4000</td>\n",
        "      <td> 7.3</td>\n",
        "      <td>  94.36960</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td> 4148</td>\n",
        "      <td>NaN</td>\n",
        "      <td> TC-2014-000071-MEX</td>\n",
        "      <td>          Mexico</td>\n",
        "      <td> Guatamala</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                    Chiapas, SE Mexico.W Guatamala</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-01</td>\n",
        "      <td>2014-06-10</td>\n",
        "      <td>  10</td>\n",
        "      <td>  22</td>\n",
        "      <td>  25000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Monsoonal Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  113685.4300</td>\n",
        "      <td> 6.2</td>\n",
        "      <td> -94.02740</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td> 4147</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>            Iran</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>         Khorasan, Mazandaran and Semnan provinces</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-01</td>\n",
        "      <td>2014-06-10</td>\n",
        "      <td>  10</td>\n",
        "      <td>  37</td>\n",
        "      <td> 440000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Monsoonal Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  305525.2500</td>\n",
        "      <td> 6.7</td>\n",
        "      <td>  57.25440</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td> 4146</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>           China</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Southern China, Guangdong Province</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-05-30</td>\n",
        "      <td>2014-06-10</td>\n",
        "      <td>  12</td>\n",
        "      <td>   6</td>\n",
        "      <td>    500</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   45994.3000</td>\n",
        "      <td> 5.7</td>\n",
        "      <td> 113.34200</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td> 4145</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2014-000070-LKA</td>\n",
        "      <td>       Sri Lanka</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                    Western districts of Sri Lanka</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-04</td>\n",
        "      <td>2014-06-10</td>\n",
        "      <td>   7</td>\n",
        "      <td>   5</td>\n",
        "      <td>  16000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>     Tropical Storm  Boris</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   10337.4700</td>\n",
        "      <td> 5.0</td>\n",
        "      <td>  80.16680</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td> 4144</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>     Afghanistan</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                   Baghlan provinc</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-06-03</td>\n",
        "      <td>2014-06-10</td>\n",
        "      <td>   8</td>\n",
        "      <td>   0</td>\n",
        "      <td>    300</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   44203.9300</td>\n",
        "      <td> 5.7</td>\n",
        "      <td>  68.01780</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td> 4143</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2014-000062-CHN</td>\n",
        "      <td>           China</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Hunan Province, including Guiyang, Shenzhen ci...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-05-12</td>\n",
        "      <td>2014-05-16</td>\n",
        "      <td>   5</td>\n",
        "      <td>   1</td>\n",
        "      <td>  10000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  205001.2700</td>\n",
        "      <td> 6.3</td>\n",
        "      <td> 111.46700</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td> 4142</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2014-000063-TJK</td>\n",
        "      <td>      Tajikistan</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Khatlon Province, Rudaki and Vahdat districts,...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-05-10</td>\n",
        "      <td>2014-05-16</td>\n",
        "      <td>   7</td>\n",
        "      <td>   0</td>\n",
        "      <td>    425</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   41719.4600</td>\n",
        "      <td> 5.6</td>\n",
        "      <td>  69.37870</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td> 4141</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>           Italy</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                    Marche region of central Italy</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-05-02</td>\n",
        "      <td>2014-05-10</td>\n",
        "      <td>   9</td>\n",
        "      <td>   2</td>\n",
        "      <td>    250</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   11256.3300</td>\n",
        "      <td> 5.2</td>\n",
        "      <td>  13.01300</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td> 4140</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>        Tanzania</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                   Rufiji District in Coast Region</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-05-10</td>\n",
        "      <td>2014-05-16</td>\n",
        "      <td>   7</td>\n",
        "      <td>   0</td>\n",
        "      <td>  22000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   22249.3400</td>\n",
        "      <td> 5.2</td>\n",
        "      <td>  38.94420</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td> 4139</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>          Serbia</td>\n",
        "      <td>    Bosnia</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                            Bosnia,Serbia, Croatia</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-05-12</td>\n",
        "      <td>2014-05-16</td>\n",
        "      <td>   5</td>\n",
        "      <td>   3</td>\n",
        "      <td>   4000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  115747.6900</td>\n",
        "      <td> 6.1</td>\n",
        "      <td>  19.22360</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td> 4138</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FF-2014-000059-SRB</td>\n",
        "      <td>         Romania</td>\n",
        "      <td>  Bulgaria</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Bulgaria, Serbia, southern Romania</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-04-17</td>\n",
        "      <td>2014-05-01</td>\n",
        "      <td>  15</td>\n",
        "      <td>   0</td>\n",
        "      <td>    640</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   87430.6900</td>\n",
        "      <td> 6.3</td>\n",
        "      <td>  24.49400</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td> 4137</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>        Tanzania</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                              Dar es Salaam region</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-04-18</td>\n",
        "      <td>2014-05-01</td>\n",
        "      <td>  14</td>\n",
        "      <td>  41</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   18498.3900</td>\n",
        "      <td> 5.6</td>\n",
        "      <td>  38.96890</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td> 4136</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FF-2014-000060-AFG</td>\n",
        "      <td>     Afghanistan</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Northwestern Afghanistan; Jowzjan Province, pr...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-04-20</td>\n",
        "      <td>2014-05-16</td>\n",
        "      <td>  27</td>\n",
        "      <td> 123</td>\n",
        "      <td>   6000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   83722.3400</td>\n",
        "      <td> 6.5</td>\n",
        "      <td>  66.43420</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td> 4135</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>             USA</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>              Gulf Coast; Northeast Atlantic Coast</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-04-30</td>\n",
        "      <td>2014-05-01</td>\n",
        "      <td>   2</td>\n",
        "      <td>   1</td>\n",
        "      <td>    200</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  260469.8100</td>\n",
        "      <td> 6.0</td>\n",
        "      <td> -84.94650</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td> 4134</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>             USA</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Southern Alabama, southern Mississippi</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-04-01</td>\n",
        "      <td>2014-04-08</td>\n",
        "      <td>   8</td>\n",
        "      <td>   2</td>\n",
        "      <td>    300</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   82418.5600</td>\n",
        "      <td> 6.0</td>\n",
        "      <td> -87.61880</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>30</th>\n",
        "      <td> 4133</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>       Argentina</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                      Western province of Neuquenr</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-04-01</td>\n",
        "      <td>2014-04-08</td>\n",
        "      <td>   8</td>\n",
        "      <td>   0</td>\n",
        "      <td>   2000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   69876.7800</td>\n",
        "      <td> 5.9</td>\n",
        "      <td> -70.29840</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>31</th>\n",
        "      <td> 4132</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2014-000045-SLB</td>\n",
        "      <td> Solomon Islands</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                           Honiara</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-04-01</td>\n",
        "      <td>2014-04-08</td>\n",
        "      <td>   8</td>\n",
        "      <td>  23</td>\n",
        "      <td>  10000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>    5480.7500</td>\n",
        "      <td> 4.9</td>\n",
        "      <td> 160.34200</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>32</th>\n",
        "      <td> 4131</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2014-000038-ZAF</td>\n",
        "      <td>    South Africa</td>\n",
        "      <td>   Namibia</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                        SADC region, Zambezi River</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-03-01</td>\n",
        "      <td>2014-03-30</td>\n",
        "      <td>  30</td>\n",
        "      <td>  37</td>\n",
        "      <td>   3528</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td> 1037639.2000</td>\n",
        "      <td> 7.7</td>\n",
        "      <td>  25.60740</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>33</th>\n",
        "      <td> 4130</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>       Australia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Southeast and Central Queensland; Yeppoon area...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-03-24</td>\n",
        "      <td>2014-03-30</td>\n",
        "      <td>   7</td>\n",
        "      <td>   1</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  250162.1200</td>\n",
        "      <td> 6.4</td>\n",
        "      <td> 150.11700</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>34</th>\n",
        "      <td> 4129</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>             USA</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Southern Mississippi, Wilkinson County</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-03-25</td>\n",
        "      <td>2014-03-30</td>\n",
        "      <td>   6</td>\n",
        "      <td>   0</td>\n",
        "      <td>    200</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   53220.7900</td>\n",
        "      <td> 5.7</td>\n",
        "      <td> -89.12820</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>35</th>\n",
        "      <td> 4128</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>         Zimbawe</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                      Tokwe-Mukosi</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-02-01</td>\n",
        "      <td>2014-03-30</td>\n",
        "      <td>  58</td>\n",
        "      <td>   0</td>\n",
        "      <td>   4000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                 Dam Break</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   17205.6400</td>\n",
        "      <td> 6.0</td>\n",
        "      <td>  31.34790</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>36</th>\n",
        "      <td> 4127</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2014-000030-PRY</td>\n",
        "      <td>        Paraguay</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  Luque, Mariano Roque Alonso, Lambar\u00e9, and Limpio</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-02-25</td>\n",
        "      <td>2014-03-10</td>\n",
        "      <td>  14</td>\n",
        "      <td>   0</td>\n",
        "      <td>   2000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>    6829.5700</td>\n",
        "      <td> 5.0</td>\n",
        "      <td> -57.58330</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>37</th>\n",
        "      <td> 4126</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>         Burundi</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                         Bujumbura</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-02-19</td>\n",
        "      <td>2014-03-10</td>\n",
        "      <td>  20</td>\n",
        "      <td>  69</td>\n",
        "      <td>  20000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>    3237.4200</td>\n",
        "      <td> 5.1</td>\n",
        "      <td>  29.64990</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>38</th>\n",
        "      <td> 4125</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>     New Zealand</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Christchurch, including Avon River</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-03-03</td>\n",
        "      <td>2014-03-10</td>\n",
        "      <td>   8</td>\n",
        "      <td>   0</td>\n",
        "      <td>     80</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>    1015.8400</td>\n",
        "      <td> 4.2</td>\n",
        "      <td> 172.61300</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>39</th>\n",
        "      <td> 4124</td>\n",
        "      <td>NaN</td>\n",
        "      <td> SS-2014-000032-MHL</td>\n",
        "      <td>             USA</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                            Majuro</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-03-03</td>\n",
        "      <td>2014-03-10</td>\n",
        "      <td>   8</td>\n",
        "      <td>   0</td>\n",
        "      <td>    900</td>\n",
        "      <td>NaN</td>\n",
        "      <td>               Storm Surge</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>      34.8366</td>\n",
        "      <td> 2.6</td>\n",
        "      <td> 168.72900</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>40</th>\n",
        "      <td> 4123</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>      Mozambique</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Johannesburg , Kliptown, Soweto; eastern South...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-02-24</td>\n",
        "      <td>2014-03-10</td>\n",
        "      <td>  15</td>\n",
        "      <td>   4</td>\n",
        "      <td>  20000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>  481907.8800</td>\n",
        "      <td> 6.9</td>\n",
        "      <td>  31.54590</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>41</th>\n",
        "      <td> 4122</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>          France</td>\n",
        "      <td>     Italy</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Southeastern France, western France, Pisa, Lig...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-01-20</td>\n",
        "      <td>2014-02-07</td>\n",
        "      <td>  19</td>\n",
        "      <td>   4</td>\n",
        "      <td>   1000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   82989.4500</td>\n",
        "      <td> 6.4</td>\n",
        "      <td>   7.09930</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>42</th>\n",
        "      <td> 4121</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>       Indonesia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                Jakarta, Tangerang</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-01-08</td>\n",
        "      <td>2014-02-07</td>\n",
        "      <td>  31</td>\n",
        "      <td>  23</td>\n",
        "      <td>  20000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   35769.2200</td>\n",
        "      <td> 6.2</td>\n",
        "      <td> 107.70600</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>43</th>\n",
        "      <td> 4120</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>       Australia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                       Top End, Northern Territory</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-02-02</td>\n",
        "      <td>2014-02-07</td>\n",
        "      <td>   6</td>\n",
        "      <td>   0</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  Tropical Storm  Fletcher</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>  426979.8400</td>\n",
        "      <td> 6.4</td>\n",
        "      <td> 131.73200</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>44</th>\n",
        "      <td> 4119</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>         Zimbawe</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Communities downstream of the Tokwe-Mukrosi Da...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-01-15</td>\n",
        "      <td>2014-02-07</td>\n",
        "      <td>  24</td>\n",
        "      <td>   0</td>\n",
        "      <td>   4000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   72462.2300</td>\n",
        "      <td> 6.4</td>\n",
        "      <td>  28.92310</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>45</th>\n",
        "      <td> 4118</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>         Zimbawe</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                        Muzarabani</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-01-15</td>\n",
        "      <td>2014-02-07</td>\n",
        "      <td>  24</td>\n",
        "      <td>   0</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  142586.1000</td>\n",
        "      <td> 6.7</td>\n",
        "      <td>  30.85310</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>46</th>\n",
        "      <td> 4117</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2014-000008-BOL</td>\n",
        "      <td>         Bolivia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> La Paz, Beni, Santa Cruz  and Cochabamba; Beni...</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-01-10</td>\n",
        "      <td>2014-05-01</td>\n",
        "      <td> 112</td>\n",
        "      <td>  60</td>\n",
        "      <td>  84000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  381576.6500</td>\n",
        "      <td> 7.9</td>\n",
        "      <td> -64.01350</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>47</th>\n",
        "      <td> 4116</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>            Peru</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                      Southern Andean Cusco region</td>\n",
        "      <td> News</td>\n",
        "      <td>2014-01-01</td>\n",
        "      <td>2014-01-04</td>\n",
        "      <td>   4</td>\n",
        "      <td>   0</td>\n",
        "      <td>    300</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   74144.6600</td>\n",
        "      <td> 5.5</td>\n",
        "      <td> -71.52320</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>48</th>\n",
        "      <td> 4115</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>             USA</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>             Nelson and Carroll Counties, Kentucky</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-22</td>\n",
        "      <td>2014-01-04</td>\n",
        "      <td>  14</td>\n",
        "      <td>   5</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   16069.9100</td>\n",
        "      <td> 5.4</td>\n",
        "      <td> -86.78990</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>49</th>\n",
        "      <td> 4114</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2013-000159-LCA</td>\n",
        "      <td>   Saint Vincent</td>\n",
        "      <td> St. Lucia</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>       Saint Vincent and the Grenadines, St. Lucia</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-26</td>\n",
        "      <td>2014-01-04</td>\n",
        "      <td>  10</td>\n",
        "      <td>  11</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>     830.2320</td>\n",
        "      <td> 3.9</td>\n",
        "      <td> -60.98860</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>50</th>\n",
        "      <td> 4113</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2013-000157-BRA</td>\n",
        "      <td>          Brazil</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Southeast states of Minas Gerais and Espirito ...</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-23</td>\n",
        "      <td>2014-01-04</td>\n",
        "      <td>  13</td>\n",
        "      <td>  45</td>\n",
        "      <td>  60000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>  314284.9100</td>\n",
        "      <td> 6.9</td>\n",
        "      <td> -41.94230</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>51</th>\n",
        "      <td> 4112</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>       Indonesia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                   North Sumatras Langkat district</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-29</td>\n",
        "      <td>2014-01-04</td>\n",
        "      <td>   7</td>\n",
        "      <td>   0</td>\n",
        "      <td>   4500</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   22524.6300</td>\n",
        "      <td> 5.2</td>\n",
        "      <td>  97.28930</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>52</th>\n",
        "      <td> 4111</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>  United Kingdom</td>\n",
        "      <td>   Ireland</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Central and southern Scotland, Wales, Ireland,...</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-27</td>\n",
        "      <td>2014-02-07</td>\n",
        "      <td>  43</td>\n",
        "      <td>   0</td>\n",
        "      <td>    200</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  126149.7900</td>\n",
        "      <td> 6.9</td>\n",
        "      <td>  -1.51144</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>53</th>\n",
        "      <td> 4110</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2013-000149-THA</td>\n",
        "      <td>        Thailand</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Southeast provinces; Nakhon Si Thammarat, Song...</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-11-20</td>\n",
        "      <td>2013-12-08</td>\n",
        "      <td>  19</td>\n",
        "      <td>  23</td>\n",
        "      <td>  15254</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Monsoonal Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>   38676.7100</td>\n",
        "      <td> 6.0</td>\n",
        "      <td> 100.39500</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>54</th>\n",
        "      <td> 4109</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>            Cuba</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                            Havana</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-01</td>\n",
        "      <td>2013-12-08</td>\n",
        "      <td>   8</td>\n",
        "      <td>   2</td>\n",
        "      <td>    227</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>    7627.3000</td>\n",
        "      <td> 4.8</td>\n",
        "      <td> -81.39580</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>55</th>\n",
        "      <td> 4108</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>           Niger</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                South-east Niger, Komadougou River</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-11-03</td>\n",
        "      <td>2013-12-08</td>\n",
        "      <td>  36</td>\n",
        "      <td>   0</td>\n",
        "      <td>   1000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                Heavy Rain</td>\n",
        "      <td> 1.0</td>\n",
        "      <td>   65791.1400</td>\n",
        "      <td> 6.4</td>\n",
        "      <td>  13.20170</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>56</th>\n",
        "      <td> 4107</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2013-000148-MYS</td>\n",
        "      <td>        Malaysia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Kuala Lumpur, east coast states of Pahang and ...</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-01</td>\n",
        "      <td>2013-12-08</td>\n",
        "      <td>   8</td>\n",
        "      <td>   1</td>\n",
        "      <td>  19000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Monsoonal Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  106697.5300</td>\n",
        "      <td> 6.1</td>\n",
        "      <td> 102.36200</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>57</th>\n",
        "      <td> 4106</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>  United Kingdom</td>\n",
        "      <td>   Germany</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>    Eastern England coast, northern European coast</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-12-05</td>\n",
        "      <td>2013-12-08</td>\n",
        "      <td>   4</td>\n",
        "      <td>   8</td>\n",
        "      <td>   4000</td>\n",
        "      <td>NaN</td>\n",
        "      <td>               Storm Surge</td>\n",
        "      <td> 2.0</td>\n",
        "      <td>   51279.6000</td>\n",
        "      <td> 5.6</td>\n",
        "      <td>   7.53306</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>58</th>\n",
        "      <td> 4105</td>\n",
        "      <td>NaN</td>\n",
        "      <td> FL-2013-000141-SOM</td>\n",
        "      <td>         Somalia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                                Northeast Puntland</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-11-08</td>\n",
        "      <td>2013-11-19</td>\n",
        "      <td>  12</td>\n",
        "      <td> 100</td>\n",
        "      <td>      0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>            Tropical Storm</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  181848.0200</td>\n",
        "      <td> 6.5</td>\n",
        "      <td>  57.42760</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>59</th>\n",
        "      <td> 4104</td>\n",
        "      <td>NaN</td>\n",
        "      <td>                  0</td>\n",
        "      <td>    Saudi Arabia</td>\n",
        "      <td>         0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> Riyadh, other parts of the Kingdom including n...</td>\n",
        "      <td> News</td>\n",
        "      <td>2013-11-18</td>\n",
        "      <td>2013-11-19</td>\n",
        "      <td>   2</td>\n",
        "      <td>  15</td>\n",
        "      <td>    121</td>\n",
        "      <td>NaN</td>\n",
        "      <td>           Torrential Rain</td>\n",
        "      <td> 1.5</td>\n",
        "      <td>  361386.8400</td>\n",
        "      <td> 6.0</td>\n",
        "      <td>  44.80840</td>\n",
        "      <td>...</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",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>276 rows \u00d7 29 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 50,
       "text": [
        "    Register  #  Annual DFO #  (discontinued)             Glide #  \\\n",
        "0          4163                           NaN                   0   \n",
        "1          4162                           NaN                   0   \n",
        "2          4161                           NaN                   0   \n",
        "3          4160                           NaN                   0   \n",
        "4          4159                           NaN                   0   \n",
        "5          4158                           NaN                   0   \n",
        "6          4157                           NaN                   0   \n",
        "7          4156                           NaN                   0   \n",
        "8          4155                           NaN                   0   \n",
        "9          4154                           NaN                   0   \n",
        "10         4153                           NaN                   0   \n",
        "11         4152                           NaN                   0   \n",
        "12         4151                           NaN                   0   \n",
        "13         4150                           NaN                   0   \n",
        "14         4149                           NaN                   0   \n",
        "15         4148                           NaN  TC-2014-000071-MEX   \n",
        "16         4147                           NaN                   0   \n",
        "17         4146                           NaN                   0   \n",
        "18         4145                           NaN  FL-2014-000070-LKA   \n",
        "19         4144                           NaN                   0   \n",
        "20         4143                           NaN  FL-2014-000062-CHN   \n",
        "21         4142                           NaN  FL-2014-000063-TJK   \n",
        "22         4141                           NaN                   0   \n",
        "23         4140                           NaN                   0   \n",
        "24         4139                           NaN                   0   \n",
        "25         4138                           NaN  FF-2014-000059-SRB   \n",
        "26         4137                           NaN                   0   \n",
        "27         4136                           NaN  FF-2014-000060-AFG   \n",
        "28         4135                           NaN                   0   \n",
        "29         4134                           NaN                   0   \n",
        "30         4133                           NaN                   0   \n",
        "31         4132                           NaN  FL-2014-000045-SLB   \n",
        "32         4131                           NaN  FL-2014-000038-ZAF   \n",
        "33         4130                           NaN                   0   \n",
        "34         4129                           NaN                   0   \n",
        "35         4128                           NaN                   0   \n",
        "36         4127                           NaN  FL-2014-000030-PRY   \n",
        "37         4126                           NaN                   0   \n",
        "38         4125                           NaN                   0   \n",
        "39         4124                           NaN  SS-2014-000032-MHL   \n",
        "40         4123                           NaN                   0   \n",
        "41         4122                           NaN                   0   \n",
        "42         4121                           NaN                   0   \n",
        "43         4120                           NaN                   0   \n",
        "44         4119                           NaN                   0   \n",
        "45         4118                           NaN                   0   \n",
        "46         4117                           NaN  FL-2014-000008-BOL   \n",
        "47         4116                           NaN                   0   \n",
        "48         4115                           NaN                   0   \n",
        "49         4114                           NaN  FL-2013-000159-LCA   \n",
        "50         4113                           NaN  FL-2013-000157-BRA   \n",
        "51         4112                           NaN                   0   \n",
        "52         4111                           NaN                   0   \n",
        "53         4110                           NaN  FL-2013-000149-THA   \n",
        "54         4109                           NaN                   0   \n",
        "55         4108                           NaN                   0   \n",
        "56         4107                           NaN  FL-2013-000148-MYS   \n",
        "57         4106                           NaN                   0   \n",
        "58         4105                           NaN  FL-2013-000141-SOM   \n",
        "59         4104                           NaN                   0   \n",
        "            ...                           ...                 ...   \n",
        "\n",
        "            Country      Other  Nations  Affected  \\\n",
        "0            Brazil    Uruguay      NaN       NaN   \n",
        "1             Nepal          0      NaN       NaN   \n",
        "2        Bangladesh          0      NaN       NaN   \n",
        "3               USA          0      NaN       NaN   \n",
        "4            Brazil          0      NaN       NaN   \n",
        "5             Sudan          0      NaN       NaN   \n",
        "6       New Zealand          0      NaN       NaN   \n",
        "7          Thailand          0      NaN       NaN   \n",
        "8             China          0      NaN       NaN   \n",
        "9             India          0      NaN       NaN   \n",
        "10      Philippines          0      NaN       NaN   \n",
        "11              USA          0      NaN       NaN   \n",
        "12         Bulgaria          0      NaN       NaN   \n",
        "13         Paraguay     Brazil      NaN       NaN   \n",
        "14           Russia          0      NaN       NaN   \n",
        "15           Mexico  Guatamala      NaN       NaN   \n",
        "16             Iran          0      NaN       NaN   \n",
        "17            China          0      NaN       NaN   \n",
        "18        Sri Lanka          0      NaN       NaN   \n",
        "19      Afghanistan          0      NaN       NaN   \n",
        "20            China          0      NaN       NaN   \n",
        "21       Tajikistan          0      NaN       NaN   \n",
        "22            Italy          0      NaN       NaN   \n",
        "23         Tanzania          0      NaN       NaN   \n",
        "24           Serbia     Bosnia      NaN       NaN   \n",
        "25          Romania   Bulgaria      NaN       NaN   \n",
        "26         Tanzania          0      NaN       NaN   \n",
        "27      Afghanistan          0      NaN       NaN   \n",
        "28              USA          0      NaN       NaN   \n",
        "29              USA          0      NaN       NaN   \n",
        "30        Argentina          0      NaN       NaN   \n",
        "31  Solomon Islands          0      NaN       NaN   \n",
        "32     South Africa    Namibia      NaN       NaN   \n",
        "33        Australia          0      NaN       NaN   \n",
        "34              USA          0      NaN       NaN   \n",
        "35          Zimbawe          0      NaN       NaN   \n",
        "36         Paraguay          0      NaN       NaN   \n",
        "37          Burundi          0      NaN       NaN   \n",
        "38      New Zealand          0      NaN       NaN   \n",
        "39              USA          0      NaN       NaN   \n",
        "40       Mozambique          0      NaN       NaN   \n",
        "41           France      Italy      NaN       NaN   \n",
        "42        Indonesia          0      NaN       NaN   \n",
        "43        Australia          0      NaN       NaN   \n",
        "44          Zimbawe          0      NaN       NaN   \n",
        "45          Zimbawe          0      NaN       NaN   \n",
        "46          Bolivia          0      NaN       NaN   \n",
        "47             Peru          0      NaN       NaN   \n",
        "48              USA          0      NaN       NaN   \n",
        "49    Saint Vincent  St. Lucia      NaN       NaN   \n",
        "50           Brazil          0      NaN       NaN   \n",
        "51        Indonesia          0      NaN       NaN   \n",
        "52   United Kingdom    Ireland      NaN       NaN   \n",
        "53         Thailand          0      NaN       NaN   \n",
        "54             Cuba          0      NaN       NaN   \n",
        "55            Niger          0      NaN       NaN   \n",
        "56         Malaysia          0      NaN       NaN   \n",
        "57   United Kingdom    Germany      NaN       NaN   \n",
        "58          Somalia          0      NaN       NaN   \n",
        "59     Saudi Arabia          0      NaN       NaN   \n",
        "                ...        ...      ...       ...   \n",
        "\n",
        "   Detailed  Locations (click on active links to access inundation extents)  \\\n",
        "0           State of Rio Grande do Sul; Uruguay River                         \n",
        "1   Sindhupalchok, Lalitpur and Chitwan districts ...                         \n",
        "2   Bhola District in the Division of Barisal, Ban...                         \n",
        "3          Mendenhall Lake and  River, Juneau, Alaska                         \n",
        "4   Amazonas State; Northwestern Brazil; Careiro d...                         \n",
        "5   Sinja locality in the eastern Sudan state of S...                         \n",
        "6   North Island, Hikurangi Swamp area, north of W...                         \n",
        "7                      Rayong, Chiang Rai, and  Trang                         \n",
        "8   Southern China; Hunan,  Jiangxi provinces; Gua...                         \n",
        "9                                               Assam                         \n",
        "10        Southern Philippine province of Maguindanao                         \n",
        "11  South Dakota, Iowa, Illinois, Missouri, Minnesota                         \n",
        "12  Eastern Bulgaria; Varna district of Asparuhov;...                         \n",
        "13  Southern Brazil, Parana State; Paraguay River ...                         \n",
        "14  Altai region, Khakassia  Republic, and Altai R...                         \n",
        "15                     Chiapas, SE Mexico.W Guatamala                         \n",
        "16          Khorasan, Mazandaran and Semnan provinces                         \n",
        "17                 Southern China, Guangdong Province                         \n",
        "18                     Western districts of Sri Lanka                         \n",
        "19                                    Baghlan provinc                         \n",
        "20  Hunan Province, including Guiyang, Shenzhen ci...                         \n",
        "21  Khatlon Province, Rudaki and Vahdat districts,...                         \n",
        "22                     Marche region of central Italy                         \n",
        "23                    Rufiji District in Coast Region                         \n",
        "24                             Bosnia,Serbia, Croatia                         \n",
        "25                 Bulgaria, Serbia, southern Romania                         \n",
        "26                               Dar es Salaam region                         \n",
        "27  Northwestern Afghanistan; Jowzjan Province, pr...                         \n",
        "28               Gulf Coast; Northeast Atlantic Coast                         \n",
        "29             Southern Alabama, southern Mississippi                         \n",
        "30                       Western province of Neuquenr                         \n",
        "31                                            Honiara                         \n",
        "32                         SADC region, Zambezi River                         \n",
        "33  Southeast and Central Queensland; Yeppoon area...                         \n",
        "34             Southern Mississippi, Wilkinson County                         \n",
        "35                                       Tokwe-Mukosi                         \n",
        "36   Luque, Mariano Roque Alonso, Lambar\u00e9, and Limpio                         \n",
        "37                                          Bujumbura                         \n",
        "38                 Christchurch, including Avon River                         \n",
        "39                                             Majuro                         \n",
        "40  Johannesburg , Kliptown, Soweto; eastern South...                         \n",
        "41  Southeastern France, western France, Pisa, Lig...                         \n",
        "42                                 Jakarta, Tangerang                         \n",
        "43                        Top End, Northern Territory                         \n",
        "44  Communities downstream of the Tokwe-Mukrosi Da...                         \n",
        "45                                         Muzarabani                         \n",
        "46  La Paz, Beni, Santa Cruz  and Cochabamba; Beni...                         \n",
        "47                       Southern Andean Cusco region                         \n",
        "48              Nelson and Carroll Counties, Kentucky                         \n",
        "49        Saint Vincent and the Grenadines, St. Lucia                         \n",
        "50  Southeast states of Minas Gerais and Espirito ...                         \n",
        "51                    North Sumatras Langkat district                         \n",
        "52  Central and southern Scotland, Wales, Ireland,...                         \n",
        "53  Southeast provinces; Nakhon Si Thammarat, Song...                         \n",
        "54                                             Havana                         \n",
        "55                 South-east Niger, Komadougou River                         \n",
        "56  Kuala Lumpur, east coast states of Pahang and ...                         \n",
        "57     Eastern England coast, northern European coast                         \n",
        "58                                 Northeast Puntland                         \n",
        "59  Riyadh, other parts of the Kingdom including n...                         \n",
        "                                                  ...                         \n",
        "\n",
        "   Validation  (post event #3503)      Began      Ended  Duration in  Days  \\\n",
        "0                            News 2014-07-03 2014-07-14                 12   \n",
        "1                            News 2014-07-01 2014-07-14                 14   \n",
        "2                            News 2014-07-13 2014-07-14                  2   \n",
        "3                            News 2014-07-11 2014-07-14                  4   \n",
        "4                            News 2014-05-22 2014-07-14                 54   \n",
        "5                            News 2014-07-07 2014-07-14                  8   \n",
        "6                            News 2014-07-05 2014-07-14                 10   \n",
        "7                            News 2014-07-11 2014-07-14                  4   \n",
        "8                            News 2014-06-05 2014-06-25                 21   \n",
        "9                            News 2014-06-23 2014-06-25                  3   \n",
        "10                           News 2014-06-17 2014-06-25                  9   \n",
        "11                           News 2014-06-10 2014-07-14                 35   \n",
        "12                           News 2014-06-19 2014-06-25                  7   \n",
        "13                           News 2014-06-03 2014-07-14                 42   \n",
        "14                           News 2014-06-04 2014-06-10                  7   \n",
        "15                           News 2014-06-01 2014-06-10                 10   \n",
        "16                           News 2014-06-01 2014-06-10                 10   \n",
        "17                           News 2014-05-30 2014-06-10                 12   \n",
        "18                           News 2014-06-04 2014-06-10                  7   \n",
        "19                           News 2014-06-03 2014-06-10                  8   \n",
        "20                           News 2014-05-12 2014-05-16                  5   \n",
        "21                           News 2014-05-10 2014-05-16                  7   \n",
        "22                           News 2014-05-02 2014-05-10                  9   \n",
        "23                           News 2014-05-10 2014-05-16                  7   \n",
        "24                           News 2014-05-12 2014-05-16                  5   \n",
        "25                           News 2014-04-17 2014-05-01                 15   \n",
        "26                           News 2014-04-18 2014-05-01                 14   \n",
        "27                           News 2014-04-20 2014-05-16                 27   \n",
        "28                           News 2014-04-30 2014-05-01                  2   \n",
        "29                           News 2014-04-01 2014-04-08                  8   \n",
        "30                           News 2014-04-01 2014-04-08                  8   \n",
        "31                           News 2014-04-01 2014-04-08                  8   \n",
        "32                           News 2014-03-01 2014-03-30                 30   \n",
        "33                           News 2014-03-24 2014-03-30                  7   \n",
        "34                           News 2014-03-25 2014-03-30                  6   \n",
        "35                           News 2014-02-01 2014-03-30                 58   \n",
        "36                           News 2014-02-25 2014-03-10                 14   \n",
        "37                           News 2014-02-19 2014-03-10                 20   \n",
        "38                           News 2014-03-03 2014-03-10                  8   \n",
        "39                           News 2014-03-03 2014-03-10                  8   \n",
        "40                           News 2014-02-24 2014-03-10                 15   \n",
        "41                           News 2014-01-20 2014-02-07                 19   \n",
        "42                           News 2014-01-08 2014-02-07                 31   \n",
        "43                           News 2014-02-02 2014-02-07                  6   \n",
        "44                           News 2014-01-15 2014-02-07                 24   \n",
        "45                           News 2014-01-15 2014-02-07                 24   \n",
        "46                           News 2014-01-10 2014-05-01                112   \n",
        "47                           News 2014-01-01 2014-01-04                  4   \n",
        "48                           News 2013-12-22 2014-01-04                 14   \n",
        "49                           News 2013-12-26 2014-01-04                 10   \n",
        "50                           News 2013-12-23 2014-01-04                 13   \n",
        "51                           News 2013-12-29 2014-01-04                  7   \n",
        "52                           News 2013-12-27 2014-02-07                 43   \n",
        "53                           News 2013-11-20 2013-12-08                 19   \n",
        "54                           News 2013-12-01 2013-12-08                  8   \n",
        "55                           News 2013-11-03 2013-12-08                 36   \n",
        "56                           News 2013-12-01 2013-12-08                  8   \n",
        "57                           News 2013-12-05 2013-12-08                  4   \n",
        "58                           News 2013-11-08 2013-11-19                 12   \n",
        "59                           News 2013-11-18 2013-11-19                  2   \n",
        "                              ...        ...        ...                ...   \n",
        "\n",
        "    Dead  Displaced  Damage (USD)                 Main cause  Severity *  \\\n",
        "0     10      50000           NaN                 Heavy Rain         2.0   \n",
        "1     16       2400           NaN            Torrential Rain         1.5   \n",
        "2      0      30000           NaN  Heavy Rain and  High Tide         1.5   \n",
        "3      0          0           NaN                 J\u00f6kulhlaup         1.0   \n",
        "4      0          0           NaN                 Heavy Rain         2.0   \n",
        "5      0      42400           NaN                 Heavy Rain         1.5   \n",
        "6      0          0           NaN                 Heavy Rain         1.0   \n",
        "7      0        500           NaN                 Heavy Rain         1.0   \n",
        "8     14     337000           NaN             Monsoonal Rain         1.0   \n",
        "9      0      10000           NaN              Monsoonal Ran         1.0   \n",
        "10     0      35000           NaN                 Heavy Rain         1.0   \n",
        "11     0        600           NaN                 Heavy Rain         2.0   \n",
        "12    12       2000           NaN            Torrential Rain         2.0   \n",
        "13     9     265000           NaN                  Heay Rain         2.0   \n",
        "14    70       3000           NaN            Torrential Rain         1.5   \n",
        "15    22      25000           NaN             Monsoonal Rain         1.5   \n",
        "16    37     440000           NaN             Monsoonal Rain         1.5   \n",
        "17     6        500           NaN                 Heavy Rain         1.0   \n",
        "18     5      16000           NaN      Tropical Storm  Boris         1.5   \n",
        "19     0        300           NaN                 Heavy Rain         1.5   \n",
        "20     1      10000           NaN                 Heavy Rain         2.0   \n",
        "21     0        425           NaN                 Heavy Rain         1.5   \n",
        "22     2        250           NaN            Torrential Rain         1.5   \n",
        "23     0      22000           NaN                 Heavy Rain         1.0   \n",
        "24     3       4000           NaN                 Heavy Rain         2.0   \n",
        "25     0        640           NaN            Torrential Rain         1.5   \n",
        "26    41          0           NaN            Torrential Rain         1.5   \n",
        "27   123       6000           NaN            Torrential Rain         1.5   \n",
        "28     1        200           NaN            Torrential Rain         2.0   \n",
        "29     2        300           NaN                 heavy Rain         1.5   \n",
        "30     0       2000           NaN                 Heavy Rain         1.5   \n",
        "31    23      10000           NaN                 Heavy Rain         2.0   \n",
        "32    37       3528           NaN                 Heavy Rain         1.5   \n",
        "33     1          0           NaN            Torrential Rain         1.5   \n",
        "34     0        200           NaN                 Heavy Rain         1.5   \n",
        "35     0       4000           NaN                  Dam Break         1.0   \n",
        "36     0       2000           NaN                 Heavy Rain         1.0   \n",
        "37    69      20000           NaN            Torrential Rain         2.0   \n",
        "38     0         80           NaN                 Heavy Rain         2.0   \n",
        "39     0        900           NaN                Storm Surge         1.5   \n",
        "40     4      20000           NaN                 Heavy Rain         1.0   \n",
        "41     4       1000           NaN                 Heavy Rain         1.5   \n",
        "42    23      20000           NaN                 Heavy Rain         1.5   \n",
        "43     0          0           NaN   Tropical Storm  Fletcher         1.0   \n",
        "44     0       4000           NaN                 Heavy Rain         1.5   \n",
        "45     0          0           NaN                 Heavy Rain         1.5   \n",
        "46    60      84000           NaN                 Heavy Rain         2.0   \n",
        "47     0        300           NaN                 Heavy Rain         1.0   \n",
        "48     5          0           NaN                 Heavy Rain         1.0   \n",
        "49    11          0           NaN                 Heavy Rain         1.0   \n",
        "50    45      60000           NaN                 Heavy Rain         2.0   \n",
        "51     0       4500           NaN                 Heavy Rain         1.0   \n",
        "52     0        200           NaN                 Heavy Rain         1.5   \n",
        "53    23      15254           NaN             Monsoonal Rain         1.5   \n",
        "54     2        227           NaN            Torrential Rain         1.0   \n",
        "55     0       1000           NaN                 Heavy Rain         1.0   \n",
        "56     1      19000           NaN             Monsoonal Rain         1.5   \n",
        "57     8       4000           NaN                Storm Surge         2.0   \n",
        "58   100          0           NaN             Tropical Storm         1.5   \n",
        "59    15        121           NaN            Torrential Rain         1.5   \n",
        "     ...        ...           ...                        ...         ...   \n",
        "\n",
        "    Affected sq  km  Magnitude  (M)**  Centroid X      \n",
        "0        44866.4600               6.0   -58.02560 ...  \n",
        "1        11578.7700               5.4    84.62070 ...  \n",
        "2          217.5290               2.8    90.54980 ...  \n",
        "3         2950.8200               4.1  -134.44600 ...  \n",
        "4       256564.5700               7.4   -59.55970 ...  \n",
        "5       137141.2800               6.2    33.08000 ...  \n",
        "6         8581.2400               4.9   174.06800 ...  \n",
        "7        15921.6300               4.8    99.73900 ...  \n",
        "8       377101.6300               6.9   112.35800 ...  \n",
        "9        49220.5300               5.2    94.71600 ...  \n",
        "10       15356.3100               5.1   124.73000 ...  \n",
        "11      418317.1300               7.5   -94.79440 ...  \n",
        "12       24415.4200               5.5    27.04260 ...  \n",
        "13      554605.2500               7.7   -53.54700 ...  \n",
        "14     1829701.4000               7.3    94.36960 ...  \n",
        "15      113685.4300               6.2   -94.02740 ...  \n",
        "16      305525.2500               6.7    57.25440 ...  \n",
        "17       45994.3000               5.7   113.34200 ...  \n",
        "18       10337.4700               5.0    80.16680 ...  \n",
        "19       44203.9300               5.7    68.01780 ...  \n",
        "20      205001.2700               6.3   111.46700 ...  \n",
        "21       41719.4600               5.6    69.37870 ...  \n",
        "22       11256.3300               5.2    13.01300 ...  \n",
        "23       22249.3400               5.2    38.94420 ...  \n",
        "24      115747.6900               6.1    19.22360 ...  \n",
        "25       87430.6900               6.3    24.49400 ...  \n",
        "26       18498.3900               5.6    38.96890 ...  \n",
        "27       83722.3400               6.5    66.43420 ...  \n",
        "28      260469.8100               6.0   -84.94650 ...  \n",
        "29       82418.5600               6.0   -87.61880 ...  \n",
        "30       69876.7800               5.9   -70.29840 ...  \n",
        "31        5480.7500               4.9   160.34200 ...  \n",
        "32     1037639.2000               7.7    25.60740 ...  \n",
        "33      250162.1200               6.4   150.11700 ...  \n",
        "34       53220.7900               5.7   -89.12820 ...  \n",
        "35       17205.6400               6.0    31.34790 ...  \n",
        "36        6829.5700               5.0   -57.58330 ...  \n",
        "37        3237.4200               5.1    29.64990 ...  \n",
        "38        1015.8400               4.2   172.61300 ...  \n",
        "39          34.8366               2.6   168.72900 ...  \n",
        "40      481907.8800               6.9    31.54590 ...  \n",
        "41       82989.4500               6.4     7.09930 ...  \n",
        "42       35769.2200               6.2   107.70600 ...  \n",
        "43      426979.8400               6.4   131.73200 ...  \n",
        "44       72462.2300               6.4    28.92310 ...  \n",
        "45      142586.1000               6.7    30.85310 ...  \n",
        "46      381576.6500               7.9   -64.01350 ...  \n",
        "47       74144.6600               5.5   -71.52320 ...  \n",
        "48       16069.9100               5.4   -86.78990 ...  \n",
        "49         830.2320               3.9   -60.98860 ...  \n",
        "50      314284.9100               6.9   -41.94230 ...  \n",
        "51       22524.6300               5.2    97.28930 ...  \n",
        "52      126149.7900               6.9    -1.51144 ...  \n",
        "53       38676.7100               6.0   100.39500 ...  \n",
        "54        7627.3000               4.8   -81.39580 ...  \n",
        "55       65791.1400               6.4    13.20170 ...  \n",
        "56      106697.5300               6.1   102.36200 ...  \n",
        "57       51279.6000               5.6     7.53306 ...  \n",
        "58      181848.0200               6.5    57.42760 ...  \n",
        "59      361386.8400               6.0    44.80840 ...  \n",
        "                ...               ...         ...      \n",
        "\n",
        "[276 rows x 29 columns]"
       ]
      }
     ],
     "prompt_number": 50
    }
   ],
   "metadata": {}
  }
 ]
}