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