cleaned.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 180,
   "id": "a99ed6cb",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "id": "11c203af",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"lanslide_global.csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "id": "a3d976b2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>source_name</th>\n",
       "      <th>source_link</th>\n",
       "      <th>event_id</th>\n",
       "      <th>event_date</th>\n",
       "      <th>event_time</th>\n",
       "      <th>event_title</th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_name</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>gazeteer_closest_point</th>\n",
       "      <th>gazeteer_distance</th>\n",
       "      <th>submitted_date</th>\n",
       "      <th>created_date</th>\n",
       "      <th>last_edited_date</th>\n",
       "      <th>longitude</th>\n",
       "      <th>latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AGU</td>\n",
       "      <td>https://blogs.agu.org/landslideblog/2008/10/14...</td>\n",
       "      <td>684</td>\n",
       "      <td>08/01/2008 12:00:00 AM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>occurred early in morning, 11 villagers buried...</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>rain</td>\n",
       "      <td>large</td>\n",
       "      <td>mine</td>\n",
       "      <td>11.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>684.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>Shaanxi</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Jingyang</td>\n",
       "      <td>41.02145</td>\n",
       "      <td>04/01/2014 12:00:00 AM</td>\n",
       "      <td>11/20/2017 03:17:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>107.45</td>\n",
       "      <td>32.5625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Oregonian</td>\n",
       "      <td>http://www.oregonlive.com/news/index.ssf/2009/...</td>\n",
       "      <td>956</td>\n",
       "      <td>01/02/2009 02:00:00 AM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>Hours of heavy rain are to blame for an overni...</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>5km</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>downpour</td>\n",
       "      <td>small</td>\n",
       "      <td>unknown</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>956.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>36619.0</td>\n",
       "      <td>Lake Oswego</td>\n",
       "      <td>0.60342</td>\n",
       "      <td>04/01/2014 12:00:00 AM</td>\n",
       "      <td>11/20/2017 03:17:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>-122.663</td>\n",
       "      <td>45.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CBS News</td>\n",
       "      <td>https://www.cbsnews.com/news/dozens-missing-af...</td>\n",
       "      <td>973</td>\n",
       "      <td>01/19/2007 12:00:00 AM</td>\n",
       "      <td>nan</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>landslide</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>10.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>Junín</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>San Ramón</td>\n",
       "      <td>0.85548</td>\n",
       "      <td>04/01/2014 12:00:00 AM</td>\n",
       "      <td>11/20/2017 03:17:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>-75.3587</td>\n",
       "      <td>-11.1295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Reuters</td>\n",
       "      <td>https://in.reuters.com/article/idINIndia-41450...</td>\n",
       "      <td>1067</td>\n",
       "      <td>07/31/2009 12:00:00 AM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>Mid Western</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>Dailekh</td>\n",
       "      <td>0.75395</td>\n",
       "      <td>04/01/2014 12:00:00 AM</td>\n",
       "      <td>11/20/2017 03:17:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>81.708</td>\n",
       "      <td>28.8378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Freeman</td>\n",
       "      <td>http://www.philstar.com/cebu-news/621414/lands...</td>\n",
       "      <td>2603</td>\n",
       "      <td>10/16/2010 12:00:00 PM</td>\n",
       "      <td>nan</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>Another landslide in sitio Bakilid in barangay...</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>5km</td>\n",
       "      <td>landslide</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>Supertyphoon Juan (Megi)</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2603.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>Central Visayas</td>\n",
       "      <td>798634.0</td>\n",
       "      <td>Cebu City</td>\n",
       "      <td>2.02204</td>\n",
       "      <td>04/01/2014 12:00:00 AM</td>\n",
       "      <td>11/20/2017 03:17:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>123.8978</td>\n",
       "      <td>10.3336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028</th>\n",
       "      <td>The Jakarta Post</td>\n",
       "      <td>http://www.thejakartapost.com/news/2017/04/02/...</td>\n",
       "      <td>11109</td>\n",
       "      <td>04/01/2017 01:34:00 PM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Major landslide in Banaran</td>\n",
       "      <td>Landslide exacerbated by deforestation and bad...</td>\n",
       "      <td>Banaran, Ponorogo, Jawa Timur, Indonesia</td>\n",
       "      <td>5km</td>\n",
       "      <td>landslide</td>\n",
       "      <td>rain</td>\n",
       "      <td>medium</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://img.jakpost.net/c/2017/04/02/2017_04_02...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>07/28/2017 01:34:00 PM</td>\n",
       "      <td>12/19/2017 09:42:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>111.6799444</td>\n",
       "      <td>-7.853409423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11029</th>\n",
       "      <td>Greater Kashmir</td>\n",
       "      <td>http://www.greaterkashmir.com/news/jammu/lands...</td>\n",
       "      <td>10845</td>\n",
       "      <td>03/25/2017 05:32:00 PM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Barnari Sigdi Landslide</td>\n",
       "      <td>Two teenage girls died after they were buried ...</td>\n",
       "      <td>Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...</td>\n",
       "      <td>5km</td>\n",
       "      <td>landslide</td>\n",
       "      <td>other</td>\n",
       "      <td>small</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>Nallah is a steep narrow valley.</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>09/21/2017 05:32:00 PM</td>\n",
       "      <td>12/05/2017 06:45:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>75.68061125</td>\n",
       "      <td>33.40307977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>NBC Daily</td>\n",
       "      <td>http://www.nbcdaily.com/separate-landslides-ki...</td>\n",
       "      <td>10973</td>\n",
       "      <td>12/15/2016 05:00:00 AM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Landslide at Pub Sarania Hill</td>\n",
       "      <td>An octogenarian was killed when a sudden lands...</td>\n",
       "      <td>Pub Sarania Hill, Guwahati, Assam, India</td>\n",
       "      <td>1km</td>\n",
       "      <td>landslide</td>\n",
       "      <td>unknown</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>07/26/2017 01:22:00 PM</td>\n",
       "      <td>12/08/2017 08:37:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>91.772042</td>\n",
       "      <td>26.181606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11031</th>\n",
       "      <td>AGU Landslide Blog</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/2017/05/02/...</td>\n",
       "      <td>10901</td>\n",
       "      <td>04/29/2017 07:03:00 PM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Mayor landslide at Ayu village</td>\n",
       "      <td>Landslide triggered by heavy rainfall buried 1...</td>\n",
       "      <td>Ayu, Ozgon, Osh, Kyrgyzstan</td>\n",
       "      <td>1km</td>\n",
       "      <td>translational_slide</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>24.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/files/2017/...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>07/14/2017 07:03:00 PM</td>\n",
       "      <td>12/07/2017 09:19:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>73.47237853</td>\n",
       "      <td>40.88639497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11032</th>\n",
       "      <td>The Times of India</td>\n",
       "      <td>https://timesofindia.indiatimes.com/city/hyder...</td>\n",
       "      <td>10949</td>\n",
       "      <td>03/13/2017 02:32:00 PM</td>\n",
       "      <td>nan</td>\n",
       "      <td>Kondapur Commercial Complex Construction Mudslide</td>\n",
       "      <td>A mudslide at an under-construction commercial...</td>\n",
       "      <td>Hyderabad, Rangareddy, Telangana</td>\n",
       "      <td>1km</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>construction</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>https://timesofindia.indiatimes.com/thumb/msid...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>10/05/2017 02:32:00 PM</td>\n",
       "      <td>12/08/2017 07:57:00 PM</td>\n",
       "      <td>02/15/2018 03:51:00 PM</td>\n",
       "      <td>78.35650524</td>\n",
       "      <td>17.46562972</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11033 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              source_name                                        source_link  \\\n",
       "0                     AGU  https://blogs.agu.org/landslideblog/2008/10/14...   \n",
       "1               Oregonian  http://www.oregonlive.com/news/index.ssf/2009/...   \n",
       "2                CBS News  https://www.cbsnews.com/news/dozens-missing-af...   \n",
       "3                 Reuters  https://in.reuters.com/article/idINIndia-41450...   \n",
       "4             The Freeman  http://www.philstar.com/cebu-news/621414/lands...   \n",
       "...                   ...                                                ...   \n",
       "11028    The Jakarta Post  http://www.thejakartapost.com/news/2017/04/02/...   \n",
       "11029     Greater Kashmir  http://www.greaterkashmir.com/news/jammu/lands...   \n",
       "11030           NBC Daily  http://www.nbcdaily.com/separate-landslides-ki...   \n",
       "11031  AGU Landslide Blog  http://blogs.agu.org/landslideblog/2017/05/02/...   \n",
       "11032  The Times of India  https://timesofindia.indiatimes.com/city/hyder...   \n",
       "\n",
       "      event_id              event_date event_time  \\\n",
       "0          684  08/01/2008 12:00:00 AM        nan   \n",
       "1          956  01/02/2009 02:00:00 AM        nan   \n",
       "2          973  01/19/2007 12:00:00 AM        nan   \n",
       "3         1067  07/31/2009 12:00:00 AM        nan   \n",
       "4         2603  10/16/2010 12:00:00 PM        nan   \n",
       "...        ...                     ...        ...   \n",
       "11028    11109  04/01/2017 01:34:00 PM        nan   \n",
       "11029    10845  03/25/2017 05:32:00 PM        nan   \n",
       "11030    10973  12/15/2016 05:00:00 AM        nan   \n",
       "11031    10901  04/29/2017 07:03:00 PM        nan   \n",
       "11032    10949  03/13/2017 02:32:00 PM        nan   \n",
       "\n",
       "                                             event_title  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province   \n",
       "1                                    Lake Oswego, Oregon   \n",
       "2      San Ramon district, 195 miles northeast of the...   \n",
       "3                                       Dailekh district   \n",
       "4                        sitio Bakilid in barangay Lahug   \n",
       "...                                                  ...   \n",
       "11028                         Major landslide in Banaran   \n",
       "11029                            Barnari Sigdi Landslide   \n",
       "11030                      Landslide at Pub Sarania Hill   \n",
       "11031                     Mayor landslide at Ayu village   \n",
       "11032  Kondapur Commercial Complex Construction Mudslide   \n",
       "\n",
       "                                       event_description  \\\n",
       "0      occurred early in morning, 11 villagers buried...   \n",
       "1      Hours of heavy rain are to blame for an overni...   \n",
       "2      (CBS/AP) At least 10 people died and as many a...   \n",
       "3      One person was killed in Dailekh district, pol...   \n",
       "4      Another landslide in sitio Bakilid in barangay...   \n",
       "...                                                  ...   \n",
       "11028  Landslide exacerbated by deforestation and bad...   \n",
       "11029  Two teenage girls died after they were buried ...   \n",
       "11030  An octogenarian was killed when a sudden lands...   \n",
       "11031  Landslide triggered by heavy rainfall buried 1...   \n",
       "11032  A mudslide at an under-construction commercial...   \n",
       "\n",
       "                                    location_description location_accuracy  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province           unknown   \n",
       "1                                    Lake Oswego, Oregon               5km   \n",
       "2      San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                       Dailekh district           unknown   \n",
       "4                        sitio Bakilid in barangay Lahug               5km   \n",
       "...                                                  ...               ...   \n",
       "11028           Banaran, Ponorogo, Jawa Timur, Indonesia               5km   \n",
       "11029  Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...               5km   \n",
       "11030           Pub Sarania Hill, Guwahati, Assam, India               1km   \n",
       "11031                        Ayu, Ozgon, Osh, Kyrgyzstan               1km   \n",
       "11032                   Hyderabad, Rangareddy, Telangana               1km   \n",
       "\n",
       "        landslide_category landslide_trigger landslide_size landslide_setting  \\\n",
       "0                landslide              rain          large              mine   \n",
       "1                 mudslide          downpour          small           unknown   \n",
       "2                landslide          downpour          large           unknown   \n",
       "3                landslide           monsoon         medium           unknown   \n",
       "4                landslide  tropical_cyclone         medium           unknown   \n",
       "...                    ...               ...            ...               ...   \n",
       "11028            landslide              rain         medium     natural_slope   \n",
       "11029            landslide             other          small     natural_slope   \n",
       "11030            landslide           unknown          small             urban   \n",
       "11031  translational_slide          downpour          large     natural_slope   \n",
       "11032             mudslide      construction          small             urban   \n",
       "\n",
       "      fatality_count injury_count                storm_name  \\\n",
       "0               11.0          nan                       nan   \n",
       "1                0.0          nan                       nan   \n",
       "2               10.0          nan                       nan   \n",
       "3                1.0          nan                       nan   \n",
       "4                0.0          nan  Supertyphoon Juan (Megi)   \n",
       "...              ...          ...                       ...   \n",
       "11028           27.0          0.0                       nan   \n",
       "11029            2.0          0.0                       nan   \n",
       "11030            1.0          0.0                       nan   \n",
       "11031           24.0          nan                       nan   \n",
       "11032            2.0          0.0                       nan   \n",
       "\n",
       "                                              photo_link  \\\n",
       "0                                                    nan   \n",
       "1                                                    nan   \n",
       "2                                                    nan   \n",
       "3                                                    nan   \n",
       "4                                                    nan   \n",
       "...                                                  ...   \n",
       "11028  http://img.jakpost.net/c/2017/04/02/2017_04_02...   \n",
       "11029                                                nan   \n",
       "11030                                                nan   \n",
       "11031  http://blogs.agu.org/landslideblog/files/2017/...   \n",
       "11032  https://timesofindia.indiatimes.com/thumb/msid...   \n",
       "\n",
       "                                  notes event_import_source event_import_id  \\\n",
       "0                                   nan                 glc           684.0   \n",
       "1                                   nan                 glc           956.0   \n",
       "2                                   nan                 glc           973.0   \n",
       "3                                   nan                 glc          1067.0   \n",
       "4                                   nan                 glc          2603.0   \n",
       "...                                 ...                 ...             ...   \n",
       "11028                               nan                 nan             nan   \n",
       "11029  Nallah is a steep narrow valley.                 nan             nan   \n",
       "11030                               nan                 nan             nan   \n",
       "11031                               nan                 nan             nan   \n",
       "11032                               nan                 nan             nan   \n",
       "\n",
       "        country_name country_code admin_division_name  \\\n",
       "0              China           CN             Shaanxi   \n",
       "1      United States           US              Oregon   \n",
       "2               Peru           PE               Junín   \n",
       "3              Nepal           NP         Mid Western   \n",
       "4        Philippines           PH     Central Visayas   \n",
       "...              ...          ...                 ...   \n",
       "11028            nan          nan                 nan   \n",
       "11029            nan          nan                 nan   \n",
       "11030            nan          nan                 nan   \n",
       "11031            nan          nan                 nan   \n",
       "11032            nan          nan                 nan   \n",
       "\n",
       "      admin_division_population gazeteer_closest_point gazeteer_distance  \\\n",
       "0                           0.0               Jingyang          41.02145   \n",
       "1                       36619.0            Lake Oswego           0.60342   \n",
       "2                       14708.0              San Ramón           0.85548   \n",
       "3                       20908.0                Dailekh           0.75395   \n",
       "4                      798634.0              Cebu City           2.02204   \n",
       "...                         ...                    ...               ...   \n",
       "11028                       nan                    nan               nan   \n",
       "11029                       nan                    nan               nan   \n",
       "11030                       nan                    nan               nan   \n",
       "11031                       nan                    nan               nan   \n",
       "11032                       nan                    nan               nan   \n",
       "\n",
       "               submitted_date            created_date        last_edited_date  \\\n",
       "0      04/01/2014 12:00:00 AM  11/20/2017 03:17:00 PM  02/15/2018 03:51:00 PM   \n",
       "1      04/01/2014 12:00:00 AM  11/20/2017 03:17:00 PM  02/15/2018 03:51:00 PM   \n",
       "2      04/01/2014 12:00:00 AM  11/20/2017 03:17:00 PM  02/15/2018 03:51:00 PM   \n",
       "3      04/01/2014 12:00:00 AM  11/20/2017 03:17:00 PM  02/15/2018 03:51:00 PM   \n",
       "4      04/01/2014 12:00:00 AM  11/20/2017 03:17:00 PM  02/15/2018 03:51:00 PM   \n",
       "...                       ...                     ...                     ...   \n",
       "11028  07/28/2017 01:34:00 PM  12/19/2017 09:42:00 PM  02/15/2018 03:51:00 PM   \n",
       "11029  09/21/2017 05:32:00 PM  12/05/2017 06:45:00 PM  02/15/2018 03:51:00 PM   \n",
       "11030  07/26/2017 01:22:00 PM  12/08/2017 08:37:00 PM  02/15/2018 03:51:00 PM   \n",
       "11031  07/14/2017 07:03:00 PM  12/07/2017 09:19:00 PM  02/15/2018 03:51:00 PM   \n",
       "11032  10/05/2017 02:32:00 PM  12/08/2017 07:57:00 PM  02/15/2018 03:51:00 PM   \n",
       "\n",
       "         longitude      latitude  \n",
       "0           107.45       32.5625  \n",
       "1         -122.663         45.42  \n",
       "2         -75.3587      -11.1295  \n",
       "3           81.708       28.8378  \n",
       "4         123.8978       10.3336  \n",
       "...            ...           ...  \n",
       "11028  111.6799444  -7.853409423  \n",
       "11029  75.68061125   33.40307977  \n",
       "11030    91.772042     26.181606  \n",
       "11031  73.47237853   40.88639497  \n",
       "11032  78.35650524   17.46562972  \n",
       "\n",
       "[11033 rows x 31 columns]"
      ]
     },
     "execution_count": 182,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df.astype(str)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "id": "7068ba29",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['source_name', 'source_link', 'event_id', 'event_date', 'event_time',\n",
       "       'event_title', 'event_description', 'location_description',\n",
       "       'location_accuracy', 'landslide_category', 'landslide_trigger',\n",
       "       'landslide_size', 'landslide_setting', 'fatality_count', 'injury_count',\n",
       "       'storm_name', 'photo_link', 'notes', 'event_import_source',\n",
       "       'event_import_id', 'country_name', 'country_code',\n",
       "       'admin_division_name', 'admin_division_population',\n",
       "       'gazeteer_closest_point', 'gazeteer_distance', 'submitted_date',\n",
       "       'created_date', 'last_edited_date', 'longitude', 'latitude'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 184,
   "id": "623144ac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>occurred early in morning, 11 villagers buried...</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>unknown</td>\n",
       "      <td>rain</td>\n",
       "      <td>large</td>\n",
       "      <td>mine</td>\n",
       "      <td>landslide</td>\n",
       "      <td>11.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>684.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hours of heavy rain are to blame for an overni...</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>small</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>956.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>36619.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Another landslide in sitio Bakilid in barangay...</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>5km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>Supertyphoon Juan (Megi)</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2603.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>798634.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028</th>\n",
       "      <td>Landslide exacerbated by deforestation and bad...</td>\n",
       "      <td>Banaran, Ponorogo, Jawa Timur, Indonesia</td>\n",
       "      <td>5km</td>\n",
       "      <td>rain</td>\n",
       "      <td>medium</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://img.jakpost.net/c/2017/04/02/2017_04_02...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11029</th>\n",
       "      <td>Two teenage girls died after they were buried ...</td>\n",
       "      <td>Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...</td>\n",
       "      <td>5km</td>\n",
       "      <td>other</td>\n",
       "      <td>small</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>Nallah is a steep narrow valley.</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>An octogenarian was killed when a sudden lands...</td>\n",
       "      <td>Pub Sarania Hill, Guwahati, Assam, India</td>\n",
       "      <td>1km</td>\n",
       "      <td>unknown</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11031</th>\n",
       "      <td>Landslide triggered by heavy rainfall buried 1...</td>\n",
       "      <td>Ayu, Ozgon, Osh, Kyrgyzstan</td>\n",
       "      <td>1km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>translational_slide</td>\n",
       "      <td>24.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/files/2017/...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11032</th>\n",
       "      <td>A mudslide at an under-construction commercial...</td>\n",
       "      <td>Hyderabad, Rangareddy, Telangana</td>\n",
       "      <td>1km</td>\n",
       "      <td>construction</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>https://timesofindia.indiatimes.com/thumb/msid...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11033 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       event_description  \\\n",
       "0      occurred early in morning, 11 villagers buried...   \n",
       "1      Hours of heavy rain are to blame for an overni...   \n",
       "2      (CBS/AP) At least 10 people died and as many a...   \n",
       "3      One person was killed in Dailekh district, pol...   \n",
       "4      Another landslide in sitio Bakilid in barangay...   \n",
       "...                                                  ...   \n",
       "11028  Landslide exacerbated by deforestation and bad...   \n",
       "11029  Two teenage girls died after they were buried ...   \n",
       "11030  An octogenarian was killed when a sudden lands...   \n",
       "11031  Landslide triggered by heavy rainfall buried 1...   \n",
       "11032  A mudslide at an under-construction commercial...   \n",
       "\n",
       "                                    location_description location_accuracy  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province           unknown   \n",
       "1                                    Lake Oswego, Oregon               5km   \n",
       "2      San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                       Dailekh district           unknown   \n",
       "4                        sitio Bakilid in barangay Lahug               5km   \n",
       "...                                                  ...               ...   \n",
       "11028           Banaran, Ponorogo, Jawa Timur, Indonesia               5km   \n",
       "11029  Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...               5km   \n",
       "11030           Pub Sarania Hill, Guwahati, Assam, India               1km   \n",
       "11031                        Ayu, Ozgon, Osh, Kyrgyzstan               1km   \n",
       "11032                   Hyderabad, Rangareddy, Telangana               1km   \n",
       "\n",
       "      landslide_trigger landslide_size landslide_setting   landslide_category  \\\n",
       "0                  rain          large              mine            landslide   \n",
       "1              downpour          small           unknown             mudslide   \n",
       "2              downpour          large           unknown            landslide   \n",
       "3               monsoon         medium           unknown            landslide   \n",
       "4      tropical_cyclone         medium           unknown            landslide   \n",
       "...                 ...            ...               ...                  ...   \n",
       "11028              rain         medium     natural_slope            landslide   \n",
       "11029             other          small     natural_slope            landslide   \n",
       "11030           unknown          small             urban            landslide   \n",
       "11031          downpour          large     natural_slope  translational_slide   \n",
       "11032      construction          small             urban             mudslide   \n",
       "\n",
       "      fatality_count injury_count                storm_name  \\\n",
       "0               11.0          nan                       nan   \n",
       "1                0.0          nan                       nan   \n",
       "2               10.0          nan                       nan   \n",
       "3                1.0          nan                       nan   \n",
       "4                0.0          nan  Supertyphoon Juan (Megi)   \n",
       "...              ...          ...                       ...   \n",
       "11028           27.0          0.0                       nan   \n",
       "11029            2.0          0.0                       nan   \n",
       "11030            1.0          0.0                       nan   \n",
       "11031           24.0          nan                       nan   \n",
       "11032            2.0          0.0                       nan   \n",
       "\n",
       "                                              photo_link  \\\n",
       "0                                                    nan   \n",
       "1                                                    nan   \n",
       "2                                                    nan   \n",
       "3                                                    nan   \n",
       "4                                                    nan   \n",
       "...                                                  ...   \n",
       "11028  http://img.jakpost.net/c/2017/04/02/2017_04_02...   \n",
       "11029                                                nan   \n",
       "11030                                                nan   \n",
       "11031  http://blogs.agu.org/landslideblog/files/2017/...   \n",
       "11032  https://timesofindia.indiatimes.com/thumb/msid...   \n",
       "\n",
       "                                  notes event_import_source event_import_id  \\\n",
       "0                                   nan                 glc           684.0   \n",
       "1                                   nan                 glc           956.0   \n",
       "2                                   nan                 glc           973.0   \n",
       "3                                   nan                 glc          1067.0   \n",
       "4                                   nan                 glc          2603.0   \n",
       "...                                 ...                 ...             ...   \n",
       "11028                               nan                 nan             nan   \n",
       "11029  Nallah is a steep narrow valley.                 nan             nan   \n",
       "11030                               nan                 nan             nan   \n",
       "11031                               nan                 nan             nan   \n",
       "11032                               nan                 nan             nan   \n",
       "\n",
       "        country_name country_code admin_division_population  \n",
       "0              China           CN                       0.0  \n",
       "1      United States           US                   36619.0  \n",
       "2               Peru           PE                   14708.0  \n",
       "3              Nepal           NP                   20908.0  \n",
       "4        Philippines           PH                  798634.0  \n",
       "...              ...          ...                       ...  \n",
       "11028            nan          nan                       nan  \n",
       "11029            nan          nan                       nan  \n",
       "11030            nan          nan                       nan  \n",
       "11031            nan          nan                       nan  \n",
       "11032            nan          nan                       nan  \n",
       "\n",
       "[11033 rows x 17 columns]"
      ]
     },
     "execution_count": 184,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df[['event_description', 'location_description',\n",
    "       'location_accuracy','landslide_trigger',\n",
    "       'landslide_size', 'landslide_setting', 'landslide_category','fatality_count', 'injury_count',\n",
    "       'storm_name', 'photo_link', 'notes', 'event_import_source',\n",
    "       'event_import_id', 'country_name', 'country_code','admin_division_population']]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "id": "3fc24b2e",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2562071507.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[\"rain\"]=df['landslide_trigger'].apply(lambda x: 1 if ('rain' in x.lower()) or ('monsoon' in x.lower()) or ('flood' in x .lower()) or ('downpour' in x.lower()) else 0)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2562071507.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['earthquake']=df['landslide_trigger'].apply(lambda x: 1 if \"earthquake\" in x.lower() else 0)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2562071507.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df[\"downpour\"]=df['landslide_trigger'].apply(lambda x: 1 if  ('flood' in x.lower()) or ('downpour' in x.lower()) else 0)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2562071507.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['snow']=df['landslide_trigger'].apply(lambda x: 1 if ('snow' in x.lower()) or ('freeze' in x.lower()) else 0)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2562071507.py:6: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['other']=df['landslide_trigger'].apply(lambda x: 1 if ('other'in x.lower()) or ('cyclone' in x.lower()) or ('no_apparent_trigger' in x) or ('volcanic' in x.lower()) or ('construction' in x.lower()) else 0)\n"
     ]
    }
   ],
   "source": [
    "#trigger\n",
    "df[\"rain\"]=df['landslide_trigger'].apply(lambda x: 1 if ('rain' in x.lower()) or ('monsoon' in x.lower()) or ('flood' in x .lower()) or ('downpour' in x.lower()) else 0)\n",
    "df['earthquake']=df['landslide_trigger'].apply(lambda x: 1 if \"earthquake\" in x.lower() else 0)\n",
    "df[\"downpour\"]=df['landslide_trigger'].apply(lambda x: 1 if  ('flood' in x.lower()) or ('downpour' in x.lower()) else 0)\n",
    "df['snow']=df['landslide_trigger'].apply(lambda x: 1 if ('snow' in x.lower()) or ('freeze' in x.lower()) else 0)\n",
    "df['other']=df['landslide_trigger'].apply(lambda x: 1 if ('other'in x.lower()) or ('cyclone' in x.lower()) or ('no_apparent_trigger' in x) or ('volcanic' in x.lower()) or ('construction' in x.lower()) else 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "id": "96085718",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\1042095918.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['small_scale']=df['landslide_size'].apply(lambda x: 1 if \"samll\" in x.lower() else 0)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\1042095918.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['medium_scale']=df['landslide_size'].apply(lambda x: 1 if \"medium\" in x.lower() else 0)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\1042095918.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['large_scale']=df['landslide_size'].apply(lambda x: 1 if \"large\" in x.lower() else 0)\n"
     ]
    }
   ],
   "source": [
    "#scale\n",
    "df['small_scale']=df['landslide_size'].apply(lambda x: 1 if \"samll\" in x.lower() else 0)\n",
    "df['medium_scale']=df['landslide_size'].apply(lambda x: 1 if \"medium\" in x.lower() else 0)\n",
    "df['large_scale']=df['landslide_size'].apply(lambda x: 1 if \"large\" in x.lower() else 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "id": "23c6e125",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    6278\n",
       "1    4755\n",
       "Name: downpour, dtype: int64"
      ]
     },
     "execution_count": 187,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.downpour.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "id": "e88b7ac2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    8224\n",
       "0    2809\n",
       "Name: rain, dtype: int64"
      ]
     },
     "execution_count": 188,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.rain.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "id": "6e4fa992",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\1551188734.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['admin_division_population']=df['admin_division_population'].apply(lambda x: 'nan' if '0.0' in x.lower() else x)\n"
     ]
    }
   ],
   "source": [
    "#remove nan from population divsion\n",
    "df['admin_division_population']=df['admin_division_population'].apply(lambda x: 'nan' if '0.0' in x.lower() else x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "id": "acd4f899",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>rain</th>\n",
       "      <th>earthquake</th>\n",
       "      <th>downpour</th>\n",
       "      <th>snow</th>\n",
       "      <th>other</th>\n",
       "      <th>small_scale</th>\n",
       "      <th>medium_scale</th>\n",
       "      <th>large_scale</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>occurred early in morning, 11 villagers buried...</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>unknown</td>\n",
       "      <td>rain</td>\n",
       "      <td>large</td>\n",
       "      <td>mine</td>\n",
       "      <td>landslide</td>\n",
       "      <td>11.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>684.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hours of heavy rain are to blame for an overni...</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>small</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>956.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>36619.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Another landslide in sitio Bakilid in barangay...</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>5km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>Supertyphoon Juan (Megi)</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2603.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>798634.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028</th>\n",
       "      <td>Landslide exacerbated by deforestation and bad...</td>\n",
       "      <td>Banaran, Ponorogo, Jawa Timur, Indonesia</td>\n",
       "      <td>5km</td>\n",
       "      <td>rain</td>\n",
       "      <td>medium</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://img.jakpost.net/c/2017/04/02/2017_04_02...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11029</th>\n",
       "      <td>Two teenage girls died after they were buried ...</td>\n",
       "      <td>Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...</td>\n",
       "      <td>5km</td>\n",
       "      <td>other</td>\n",
       "      <td>small</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>Nallah is a steep narrow valley.</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>An octogenarian was killed when a sudden lands...</td>\n",
       "      <td>Pub Sarania Hill, Guwahati, Assam, India</td>\n",
       "      <td>1km</td>\n",
       "      <td>unknown</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11031</th>\n",
       "      <td>Landslide triggered by heavy rainfall buried 1...</td>\n",
       "      <td>Ayu, Ozgon, Osh, Kyrgyzstan</td>\n",
       "      <td>1km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>translational_slide</td>\n",
       "      <td>24.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/files/2017/...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11032</th>\n",
       "      <td>A mudslide at an under-construction commercial...</td>\n",
       "      <td>Hyderabad, Rangareddy, Telangana</td>\n",
       "      <td>1km</td>\n",
       "      <td>construction</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>https://timesofindia.indiatimes.com/thumb/msid...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11033 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       event_description  \\\n",
       "0      occurred early in morning, 11 villagers buried...   \n",
       "1      Hours of heavy rain are to blame for an overni...   \n",
       "2      (CBS/AP) At least 10 people died and as many a...   \n",
       "3      One person was killed in Dailekh district, pol...   \n",
       "4      Another landslide in sitio Bakilid in barangay...   \n",
       "...                                                  ...   \n",
       "11028  Landslide exacerbated by deforestation and bad...   \n",
       "11029  Two teenage girls died after they were buried ...   \n",
       "11030  An octogenarian was killed when a sudden lands...   \n",
       "11031  Landslide triggered by heavy rainfall buried 1...   \n",
       "11032  A mudslide at an under-construction commercial...   \n",
       "\n",
       "                                    location_description location_accuracy  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province           unknown   \n",
       "1                                    Lake Oswego, Oregon               5km   \n",
       "2      San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                       Dailekh district           unknown   \n",
       "4                        sitio Bakilid in barangay Lahug               5km   \n",
       "...                                                  ...               ...   \n",
       "11028           Banaran, Ponorogo, Jawa Timur, Indonesia               5km   \n",
       "11029  Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...               5km   \n",
       "11030           Pub Sarania Hill, Guwahati, Assam, India               1km   \n",
       "11031                        Ayu, Ozgon, Osh, Kyrgyzstan               1km   \n",
       "11032                   Hyderabad, Rangareddy, Telangana               1km   \n",
       "\n",
       "      landslide_trigger landslide_size landslide_setting   landslide_category  \\\n",
       "0                  rain          large              mine            landslide   \n",
       "1              downpour          small           unknown             mudslide   \n",
       "2              downpour          large           unknown            landslide   \n",
       "3               monsoon         medium           unknown            landslide   \n",
       "4      tropical_cyclone         medium           unknown            landslide   \n",
       "...                 ...            ...               ...                  ...   \n",
       "11028              rain         medium     natural_slope            landslide   \n",
       "11029             other          small     natural_slope            landslide   \n",
       "11030           unknown          small             urban            landslide   \n",
       "11031          downpour          large     natural_slope  translational_slide   \n",
       "11032      construction          small             urban             mudslide   \n",
       "\n",
       "      fatality_count injury_count                storm_name  \\\n",
       "0               11.0          nan                       nan   \n",
       "1                0.0          nan                       nan   \n",
       "2               10.0          nan                       nan   \n",
       "3                1.0          nan                       nan   \n",
       "4                0.0          nan  Supertyphoon Juan (Megi)   \n",
       "...              ...          ...                       ...   \n",
       "11028           27.0          0.0                       nan   \n",
       "11029            2.0          0.0                       nan   \n",
       "11030            1.0          0.0                       nan   \n",
       "11031           24.0          nan                       nan   \n",
       "11032            2.0          0.0                       nan   \n",
       "\n",
       "                                              photo_link  \\\n",
       "0                                                    nan   \n",
       "1                                                    nan   \n",
       "2                                                    nan   \n",
       "3                                                    nan   \n",
       "4                                                    nan   \n",
       "...                                                  ...   \n",
       "11028  http://img.jakpost.net/c/2017/04/02/2017_04_02...   \n",
       "11029                                                nan   \n",
       "11030                                                nan   \n",
       "11031  http://blogs.agu.org/landslideblog/files/2017/...   \n",
       "11032  https://timesofindia.indiatimes.com/thumb/msid...   \n",
       "\n",
       "                                  notes event_import_source event_import_id  \\\n",
       "0                                   nan                 glc           684.0   \n",
       "1                                   nan                 glc           956.0   \n",
       "2                                   nan                 glc           973.0   \n",
       "3                                   nan                 glc          1067.0   \n",
       "4                                   nan                 glc          2603.0   \n",
       "...                                 ...                 ...             ...   \n",
       "11028                               nan                 nan             nan   \n",
       "11029  Nallah is a steep narrow valley.                 nan             nan   \n",
       "11030                               nan                 nan             nan   \n",
       "11031                               nan                 nan             nan   \n",
       "11032                               nan                 nan             nan   \n",
       "\n",
       "        country_name country_code admin_division_population  rain  earthquake  \\\n",
       "0              China           CN                       nan     1           0   \n",
       "1      United States           US                   36619.0     1           0   \n",
       "2               Peru           PE                   14708.0     1           0   \n",
       "3              Nepal           NP                   20908.0     1           0   \n",
       "4        Philippines           PH                  798634.0     0           0   \n",
       "...              ...          ...                       ...   ...         ...   \n",
       "11028            nan          nan                       nan     1           0   \n",
       "11029            nan          nan                       nan     0           0   \n",
       "11030            nan          nan                       nan     0           0   \n",
       "11031            nan          nan                       nan     1           0   \n",
       "11032            nan          nan                       nan     0           0   \n",
       "\n",
       "       downpour  snow  other  small_scale  medium_scale  large_scale  \n",
       "0             0     0      0            0             0            1  \n",
       "1             1     0      0            0             0            0  \n",
       "2             1     0      0            0             0            1  \n",
       "3             0     0      0            0             1            0  \n",
       "4             0     0      1            0             1            0  \n",
       "...         ...   ...    ...          ...           ...          ...  \n",
       "11028         0     0      0            0             1            0  \n",
       "11029         0     0      1            0             0            0  \n",
       "11030         0     0      0            0             0            0  \n",
       "11031         1     0      0            0             0            1  \n",
       "11032         0     0      1            0             0            0  \n",
       "\n",
       "[11033 rows x 25 columns]"
      ]
     },
     "execution_count": 190,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "id": "835ae2d1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['event_description', 'location_description', 'location_accuracy',\n",
       "       'landslide_trigger', 'landslide_size', 'landslide_setting',\n",
       "       'landslide_category', 'fatality_count', 'injury_count', 'storm_name',\n",
       "       'photo_link', 'notes', 'event_import_source', 'event_import_id',\n",
       "       'country_name', 'country_code', 'admin_division_population', 'rain',\n",
       "       'earthquake', 'downpour', 'snow', 'other', 'small_scale',\n",
       "       'medium_scale', 'large_scale'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 191,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "id": "92cef4a8",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\1721615330.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['home_destroyed']=df['event_description'].apply(lambda x: 1 if 'home' in x.lower() else 0)\n"
     ]
    }
   ],
   "source": [
    "df['home_destroyed']=df['event_description'].apply(lambda x: 1 if 'home' in x.lower() else 0)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "id": "e8c980ef",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    9888\n",
       "1    1145\n",
       "Name: home_destroyed, dtype: int64"
      ]
     },
     "execution_count": 193,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['home_destroyed'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "id": "c84ea427",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2113223445.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['mudslide']=df['landslide_category'].apply(lambda x: 1 if 'mudslide' in x.lower() else 0)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2113223445.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['landslide']=df['landslide_category'].apply(lambda x: 1 if 'landslide' in x.lower() else 0)\n"
     ]
    }
   ],
   "source": [
    "df['mudslide']=df['landslide_category'].apply(lambda x: 1 if 'mudslide' in x.lower() else 0)\n",
    "df['landslide']=df['landslide_category'].apply(lambda x: 1 if 'landslide' in x.lower() else 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "id": "117ab93f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>rain</th>\n",
       "      <th>earthquake</th>\n",
       "      <th>downpour</th>\n",
       "      <th>snow</th>\n",
       "      <th>other</th>\n",
       "      <th>small_scale</th>\n",
       "      <th>medium_scale</th>\n",
       "      <th>large_scale</th>\n",
       "      <th>home_destroyed</th>\n",
       "      <th>mudslide</th>\n",
       "      <th>landslide</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>occurred early in morning, 11 villagers buried...</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>unknown</td>\n",
       "      <td>rain</td>\n",
       "      <td>large</td>\n",
       "      <td>mine</td>\n",
       "      <td>landslide</td>\n",
       "      <td>11.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>684.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hours of heavy rain are to blame for an overni...</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>small</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>956.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>36619.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Another landslide in sitio Bakilid in barangay...</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>5km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>Supertyphoon Juan (Megi)</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2603.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>798634.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028</th>\n",
       "      <td>Landslide exacerbated by deforestation and bad...</td>\n",
       "      <td>Banaran, Ponorogo, Jawa Timur, Indonesia</td>\n",
       "      <td>5km</td>\n",
       "      <td>rain</td>\n",
       "      <td>medium</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://img.jakpost.net/c/2017/04/02/2017_04_02...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11029</th>\n",
       "      <td>Two teenage girls died after they were buried ...</td>\n",
       "      <td>Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...</td>\n",
       "      <td>5km</td>\n",
       "      <td>other</td>\n",
       "      <td>small</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>Nallah is a steep narrow valley.</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>An octogenarian was killed when a sudden lands...</td>\n",
       "      <td>Pub Sarania Hill, Guwahati, Assam, India</td>\n",
       "      <td>1km</td>\n",
       "      <td>unknown</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11031</th>\n",
       "      <td>Landslide triggered by heavy rainfall buried 1...</td>\n",
       "      <td>Ayu, Ozgon, Osh, Kyrgyzstan</td>\n",
       "      <td>1km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>translational_slide</td>\n",
       "      <td>24.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/files/2017/...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11032</th>\n",
       "      <td>A mudslide at an under-construction commercial...</td>\n",
       "      <td>Hyderabad, Rangareddy, Telangana</td>\n",
       "      <td>1km</td>\n",
       "      <td>construction</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>https://timesofindia.indiatimes.com/thumb/msid...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11033 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       event_description  \\\n",
       "0      occurred early in morning, 11 villagers buried...   \n",
       "1      Hours of heavy rain are to blame for an overni...   \n",
       "2      (CBS/AP) At least 10 people died and as many a...   \n",
       "3      One person was killed in Dailekh district, pol...   \n",
       "4      Another landslide in sitio Bakilid in barangay...   \n",
       "...                                                  ...   \n",
       "11028  Landslide exacerbated by deforestation and bad...   \n",
       "11029  Two teenage girls died after they were buried ...   \n",
       "11030  An octogenarian was killed when a sudden lands...   \n",
       "11031  Landslide triggered by heavy rainfall buried 1...   \n",
       "11032  A mudslide at an under-construction commercial...   \n",
       "\n",
       "                                    location_description location_accuracy  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province           unknown   \n",
       "1                                    Lake Oswego, Oregon               5km   \n",
       "2      San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                       Dailekh district           unknown   \n",
       "4                        sitio Bakilid in barangay Lahug               5km   \n",
       "...                                                  ...               ...   \n",
       "11028           Banaran, Ponorogo, Jawa Timur, Indonesia               5km   \n",
       "11029  Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...               5km   \n",
       "11030           Pub Sarania Hill, Guwahati, Assam, India               1km   \n",
       "11031                        Ayu, Ozgon, Osh, Kyrgyzstan               1km   \n",
       "11032                   Hyderabad, Rangareddy, Telangana               1km   \n",
       "\n",
       "      landslide_trigger landslide_size landslide_setting   landslide_category  \\\n",
       "0                  rain          large              mine            landslide   \n",
       "1              downpour          small           unknown             mudslide   \n",
       "2              downpour          large           unknown            landslide   \n",
       "3               monsoon         medium           unknown            landslide   \n",
       "4      tropical_cyclone         medium           unknown            landslide   \n",
       "...                 ...            ...               ...                  ...   \n",
       "11028              rain         medium     natural_slope            landslide   \n",
       "11029             other          small     natural_slope            landslide   \n",
       "11030           unknown          small             urban            landslide   \n",
       "11031          downpour          large     natural_slope  translational_slide   \n",
       "11032      construction          small             urban             mudslide   \n",
       "\n",
       "      fatality_count injury_count                storm_name  \\\n",
       "0               11.0          nan                       nan   \n",
       "1                0.0          nan                       nan   \n",
       "2               10.0          nan                       nan   \n",
       "3                1.0          nan                       nan   \n",
       "4                0.0          nan  Supertyphoon Juan (Megi)   \n",
       "...              ...          ...                       ...   \n",
       "11028           27.0          0.0                       nan   \n",
       "11029            2.0          0.0                       nan   \n",
       "11030            1.0          0.0                       nan   \n",
       "11031           24.0          nan                       nan   \n",
       "11032            2.0          0.0                       nan   \n",
       "\n",
       "                                              photo_link  \\\n",
       "0                                                    nan   \n",
       "1                                                    nan   \n",
       "2                                                    nan   \n",
       "3                                                    nan   \n",
       "4                                                    nan   \n",
       "...                                                  ...   \n",
       "11028  http://img.jakpost.net/c/2017/04/02/2017_04_02...   \n",
       "11029                                                nan   \n",
       "11030                                                nan   \n",
       "11031  http://blogs.agu.org/landslideblog/files/2017/...   \n",
       "11032  https://timesofindia.indiatimes.com/thumb/msid...   \n",
       "\n",
       "                                  notes event_import_source event_import_id  \\\n",
       "0                                   nan                 glc           684.0   \n",
       "1                                   nan                 glc           956.0   \n",
       "2                                   nan                 glc           973.0   \n",
       "3                                   nan                 glc          1067.0   \n",
       "4                                   nan                 glc          2603.0   \n",
       "...                                 ...                 ...             ...   \n",
       "11028                               nan                 nan             nan   \n",
       "11029  Nallah is a steep narrow valley.                 nan             nan   \n",
       "11030                               nan                 nan             nan   \n",
       "11031                               nan                 nan             nan   \n",
       "11032                               nan                 nan             nan   \n",
       "\n",
       "        country_name country_code admin_division_population  rain  earthquake  \\\n",
       "0              China           CN                       nan     1           0   \n",
       "1      United States           US                   36619.0     1           0   \n",
       "2               Peru           PE                   14708.0     1           0   \n",
       "3              Nepal           NP                   20908.0     1           0   \n",
       "4        Philippines           PH                  798634.0     0           0   \n",
       "...              ...          ...                       ...   ...         ...   \n",
       "11028            nan          nan                       nan     1           0   \n",
       "11029            nan          nan                       nan     0           0   \n",
       "11030            nan          nan                       nan     0           0   \n",
       "11031            nan          nan                       nan     1           0   \n",
       "11032            nan          nan                       nan     0           0   \n",
       "\n",
       "       downpour  snow  other  small_scale  medium_scale  large_scale  \\\n",
       "0             0     0      0            0             0            1   \n",
       "1             1     0      0            0             0            0   \n",
       "2             1     0      0            0             0            1   \n",
       "3             0     0      0            0             1            0   \n",
       "4             0     0      1            0             1            0   \n",
       "...         ...   ...    ...          ...           ...          ...   \n",
       "11028         0     0      0            0             1            0   \n",
       "11029         0     0      1            0             0            0   \n",
       "11030         0     0      0            0             0            0   \n",
       "11031         1     0      0            0             0            1   \n",
       "11032         0     0      1            0             0            0   \n",
       "\n",
       "       home_destroyed  mudslide  landslide  \n",
       "0                   0         0          1  \n",
       "1                   0         1          0  \n",
       "2                   0         0          1  \n",
       "3                   0         0          1  \n",
       "4                   1         0          1  \n",
       "...               ...       ...        ...  \n",
       "11028               0         0          1  \n",
       "11029               0         0          1  \n",
       "11030               0         0          1  \n",
       "11031               0         0          0  \n",
       "11032               0         1          0  \n",
       "\n",
       "[11033 rows x 28 columns]"
      ]
     },
     "execution_count": 195,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "id": "31d0b05f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>rain</th>\n",
       "      <th>earthquake</th>\n",
       "      <th>downpour</th>\n",
       "      <th>snow</th>\n",
       "      <th>other</th>\n",
       "      <th>small_scale</th>\n",
       "      <th>medium_scale</th>\n",
       "      <th>large_scale</th>\n",
       "      <th>home_destroyed</th>\n",
       "      <th>mudslide</th>\n",
       "      <th>landslide</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>occurred early in morning, 11 villagers buried...</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>unknown</td>\n",
       "      <td>rain</td>\n",
       "      <td>large</td>\n",
       "      <td>mine</td>\n",
       "      <td>landslide</td>\n",
       "      <td>11.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>684.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hours of heavy rain are to blame for an overni...</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>small</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>956.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>36619.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Another landslide in sitio Bakilid in barangay...</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>5km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>Supertyphoon Juan (Megi)</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2603.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>798634.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028</th>\n",
       "      <td>Landslide exacerbated by deforestation and bad...</td>\n",
       "      <td>Banaran, Ponorogo, Jawa Timur, Indonesia</td>\n",
       "      <td>5km</td>\n",
       "      <td>rain</td>\n",
       "      <td>medium</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://img.jakpost.net/c/2017/04/02/2017_04_02...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11029</th>\n",
       "      <td>Two teenage girls died after they were buried ...</td>\n",
       "      <td>Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...</td>\n",
       "      <td>5km</td>\n",
       "      <td>other</td>\n",
       "      <td>small</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>Nallah is a steep narrow valley.</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>An octogenarian was killed when a sudden lands...</td>\n",
       "      <td>Pub Sarania Hill, Guwahati, Assam, India</td>\n",
       "      <td>1km</td>\n",
       "      <td>unknown</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11031</th>\n",
       "      <td>Landslide triggered by heavy rainfall buried 1...</td>\n",
       "      <td>Ayu, Ozgon, Osh, Kyrgyzstan</td>\n",
       "      <td>1km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>translational_slide</td>\n",
       "      <td>24.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/files/2017/...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11032</th>\n",
       "      <td>A mudslide at an under-construction commercial...</td>\n",
       "      <td>Hyderabad, Rangareddy, Telangana</td>\n",
       "      <td>1km</td>\n",
       "      <td>construction</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>https://timesofindia.indiatimes.com/thumb/msid...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11033 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       event_description  \\\n",
       "0      occurred early in morning, 11 villagers buried...   \n",
       "1      Hours of heavy rain are to blame for an overni...   \n",
       "2      (CBS/AP) At least 10 people died and as many a...   \n",
       "3      One person was killed in Dailekh district, pol...   \n",
       "4      Another landslide in sitio Bakilid in barangay...   \n",
       "...                                                  ...   \n",
       "11028  Landslide exacerbated by deforestation and bad...   \n",
       "11029  Two teenage girls died after they were buried ...   \n",
       "11030  An octogenarian was killed when a sudden lands...   \n",
       "11031  Landslide triggered by heavy rainfall buried 1...   \n",
       "11032  A mudslide at an under-construction commercial...   \n",
       "\n",
       "                                    location_description location_accuracy  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province           unknown   \n",
       "1                                    Lake Oswego, Oregon               5km   \n",
       "2      San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                       Dailekh district           unknown   \n",
       "4                        sitio Bakilid in barangay Lahug               5km   \n",
       "...                                                  ...               ...   \n",
       "11028           Banaran, Ponorogo, Jawa Timur, Indonesia               5km   \n",
       "11029  Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...               5km   \n",
       "11030           Pub Sarania Hill, Guwahati, Assam, India               1km   \n",
       "11031                        Ayu, Ozgon, Osh, Kyrgyzstan               1km   \n",
       "11032                   Hyderabad, Rangareddy, Telangana               1km   \n",
       "\n",
       "      landslide_trigger landslide_size landslide_setting   landslide_category  \\\n",
       "0                  rain          large              mine            landslide   \n",
       "1              downpour          small           unknown             mudslide   \n",
       "2              downpour          large           unknown            landslide   \n",
       "3               monsoon         medium           unknown            landslide   \n",
       "4      tropical_cyclone         medium           unknown            landslide   \n",
       "...                 ...            ...               ...                  ...   \n",
       "11028              rain         medium     natural_slope            landslide   \n",
       "11029             other          small     natural_slope            landslide   \n",
       "11030           unknown          small             urban            landslide   \n",
       "11031          downpour          large     natural_slope  translational_slide   \n",
       "11032      construction          small             urban             mudslide   \n",
       "\n",
       "      fatality_count injury_count                storm_name  \\\n",
       "0               11.0          nan                       nan   \n",
       "1                0.0          nan                       nan   \n",
       "2               10.0          nan                       nan   \n",
       "3                1.0          nan                       nan   \n",
       "4                0.0          nan  Supertyphoon Juan (Megi)   \n",
       "...              ...          ...                       ...   \n",
       "11028           27.0          0.0                       nan   \n",
       "11029            2.0          0.0                       nan   \n",
       "11030            1.0          0.0                       nan   \n",
       "11031           24.0          nan                       nan   \n",
       "11032            2.0          0.0                       nan   \n",
       "\n",
       "                                              photo_link  \\\n",
       "0                                                    nan   \n",
       "1                                                    nan   \n",
       "2                                                    nan   \n",
       "3                                                    nan   \n",
       "4                                                    nan   \n",
       "...                                                  ...   \n",
       "11028  http://img.jakpost.net/c/2017/04/02/2017_04_02...   \n",
       "11029                                                nan   \n",
       "11030                                                nan   \n",
       "11031  http://blogs.agu.org/landslideblog/files/2017/...   \n",
       "11032  https://timesofindia.indiatimes.com/thumb/msid...   \n",
       "\n",
       "                                  notes event_import_source event_import_id  \\\n",
       "0                                   nan                 glc           684.0   \n",
       "1                                   nan                 glc           956.0   \n",
       "2                                   nan                 glc           973.0   \n",
       "3                                   nan                 glc          1067.0   \n",
       "4                                   nan                 glc          2603.0   \n",
       "...                                 ...                 ...             ...   \n",
       "11028                               nan                 nan             nan   \n",
       "11029  Nallah is a steep narrow valley.                 nan             nan   \n",
       "11030                               nan                 nan             nan   \n",
       "11031                               nan                 nan             nan   \n",
       "11032                               nan                 nan             nan   \n",
       "\n",
       "        country_name country_code admin_division_population  rain  earthquake  \\\n",
       "0              China           CN                       nan     1           0   \n",
       "1      United States           US                   36619.0     1           0   \n",
       "2               Peru           PE                   14708.0     1           0   \n",
       "3              Nepal           NP                   20908.0     1           0   \n",
       "4        Philippines           PH                  798634.0     0           0   \n",
       "...              ...          ...                       ...   ...         ...   \n",
       "11028            nan          nan                       nan     1           0   \n",
       "11029            nan          nan                       nan     0           0   \n",
       "11030            nan          nan                       nan     0           0   \n",
       "11031            nan          nan                       nan     1           0   \n",
       "11032            nan          nan                       nan     0           0   \n",
       "\n",
       "       downpour  snow  other  small_scale  medium_scale  large_scale  \\\n",
       "0             0     0      0            0             0            1   \n",
       "1             1     0      0            0             0            0   \n",
       "2             1     0      0            0             0            1   \n",
       "3             0     0      0            0             1            0   \n",
       "4             0     0      1            0             1            0   \n",
       "...         ...   ...    ...          ...           ...          ...   \n",
       "11028         0     0      0            0             1            0   \n",
       "11029         0     0      1            0             0            0   \n",
       "11030         0     0      0            0             0            0   \n",
       "11031         1     0      0            0             0            1   \n",
       "11032         0     0      1            0             0            0   \n",
       "\n",
       "       home_destroyed  mudslide  landslide  \n",
       "0                   0         0          1  \n",
       "1                   0         1          0  \n",
       "2                   0         0          1  \n",
       "3                   0         0          1  \n",
       "4                   1         0          1  \n",
       "...               ...       ...        ...  \n",
       "11028               0         0          1  \n",
       "11029               0         0          1  \n",
       "11030               0         0          1  \n",
       "11031               0         0          0  \n",
       "11032               0         1          0  \n",
       "\n",
       "[11033 rows x 28 columns]"
      ]
     },
     "execution_count": 196,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "if df['fatality_count'].empty and df['injury_count'].empty:\n",
    "    df=df.dropna()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "id": "c6c42691",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2747596352.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['injury_count']=df['injury_count'].apply(lambda x: '0.0' if 'nan' in x.lower() else x)\n",
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\2747596352.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['fatality_count']=df['fatality_count'].apply(lambda x: '0.0' if 'nan' in x.lower() else x)\n"
     ]
    }
   ],
   "source": [
    "df['injury_count']=df['injury_count'].apply(lambda x: '0.0' if 'nan' in x.lower() else x)\n",
    "df['fatality_count']=df['fatality_count'].apply(lambda x: '0.0' if 'nan' in x.lower() else x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "id": "e29f119b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>rain</th>\n",
       "      <th>earthquake</th>\n",
       "      <th>downpour</th>\n",
       "      <th>snow</th>\n",
       "      <th>other</th>\n",
       "      <th>small_scale</th>\n",
       "      <th>medium_scale</th>\n",
       "      <th>large_scale</th>\n",
       "      <th>home_destroyed</th>\n",
       "      <th>mudslide</th>\n",
       "      <th>landslide</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>occurred early in morning, 11 villagers buried...</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>unknown</td>\n",
       "      <td>rain</td>\n",
       "      <td>large</td>\n",
       "      <td>mine</td>\n",
       "      <td>landslide</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>684.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hours of heavy rain are to blame for an overni...</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>small</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>956.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>36619.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Another landslide in sitio Bakilid in barangay...</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>5km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Supertyphoon Juan (Megi)</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2603.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>798634.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028</th>\n",
       "      <td>Landslide exacerbated by deforestation and bad...</td>\n",
       "      <td>Banaran, Ponorogo, Jawa Timur, Indonesia</td>\n",
       "      <td>5km</td>\n",
       "      <td>rain</td>\n",
       "      <td>medium</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://img.jakpost.net/c/2017/04/02/2017_04_02...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11029</th>\n",
       "      <td>Two teenage girls died after they were buried ...</td>\n",
       "      <td>Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...</td>\n",
       "      <td>5km</td>\n",
       "      <td>other</td>\n",
       "      <td>small</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>Nallah is a steep narrow valley.</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>An octogenarian was killed when a sudden lands...</td>\n",
       "      <td>Pub Sarania Hill, Guwahati, Assam, India</td>\n",
       "      <td>1km</td>\n",
       "      <td>unknown</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11031</th>\n",
       "      <td>Landslide triggered by heavy rainfall buried 1...</td>\n",
       "      <td>Ayu, Ozgon, Osh, Kyrgyzstan</td>\n",
       "      <td>1km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>translational_slide</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/files/2017/...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11032</th>\n",
       "      <td>A mudslide at an under-construction commercial...</td>\n",
       "      <td>Hyderabad, Rangareddy, Telangana</td>\n",
       "      <td>1km</td>\n",
       "      <td>construction</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>https://timesofindia.indiatimes.com/thumb/msid...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11033 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       event_description  \\\n",
       "0      occurred early in morning, 11 villagers buried...   \n",
       "1      Hours of heavy rain are to blame for an overni...   \n",
       "2      (CBS/AP) At least 10 people died and as many a...   \n",
       "3      One person was killed in Dailekh district, pol...   \n",
       "4      Another landslide in sitio Bakilid in barangay...   \n",
       "...                                                  ...   \n",
       "11028  Landslide exacerbated by deforestation and bad...   \n",
       "11029  Two teenage girls died after they were buried ...   \n",
       "11030  An octogenarian was killed when a sudden lands...   \n",
       "11031  Landslide triggered by heavy rainfall buried 1...   \n",
       "11032  A mudslide at an under-construction commercial...   \n",
       "\n",
       "                                    location_description location_accuracy  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province           unknown   \n",
       "1                                    Lake Oswego, Oregon               5km   \n",
       "2      San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                       Dailekh district           unknown   \n",
       "4                        sitio Bakilid in barangay Lahug               5km   \n",
       "...                                                  ...               ...   \n",
       "11028           Banaran, Ponorogo, Jawa Timur, Indonesia               5km   \n",
       "11029  Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...               5km   \n",
       "11030           Pub Sarania Hill, Guwahati, Assam, India               1km   \n",
       "11031                        Ayu, Ozgon, Osh, Kyrgyzstan               1km   \n",
       "11032                   Hyderabad, Rangareddy, Telangana               1km   \n",
       "\n",
       "      landslide_trigger landslide_size landslide_setting   landslide_category  \\\n",
       "0                  rain          large              mine            landslide   \n",
       "1              downpour          small           unknown             mudslide   \n",
       "2              downpour          large           unknown            landslide   \n",
       "3               monsoon         medium           unknown            landslide   \n",
       "4      tropical_cyclone         medium           unknown            landslide   \n",
       "...                 ...            ...               ...                  ...   \n",
       "11028              rain         medium     natural_slope            landslide   \n",
       "11029             other          small     natural_slope            landslide   \n",
       "11030           unknown          small             urban            landslide   \n",
       "11031          downpour          large     natural_slope  translational_slide   \n",
       "11032      construction          small             urban             mudslide   \n",
       "\n",
       "      fatality_count injury_count                storm_name  \\\n",
       "0               11.0          0.0                       nan   \n",
       "1                0.0          0.0                       nan   \n",
       "2               10.0          0.0                       nan   \n",
       "3                1.0          0.0                       nan   \n",
       "4                0.0          0.0  Supertyphoon Juan (Megi)   \n",
       "...              ...          ...                       ...   \n",
       "11028           27.0          0.0                       nan   \n",
       "11029            2.0          0.0                       nan   \n",
       "11030            1.0          0.0                       nan   \n",
       "11031           24.0          0.0                       nan   \n",
       "11032            2.0          0.0                       nan   \n",
       "\n",
       "                                              photo_link  \\\n",
       "0                                                    nan   \n",
       "1                                                    nan   \n",
       "2                                                    nan   \n",
       "3                                                    nan   \n",
       "4                                                    nan   \n",
       "...                                                  ...   \n",
       "11028  http://img.jakpost.net/c/2017/04/02/2017_04_02...   \n",
       "11029                                                nan   \n",
       "11030                                                nan   \n",
       "11031  http://blogs.agu.org/landslideblog/files/2017/...   \n",
       "11032  https://timesofindia.indiatimes.com/thumb/msid...   \n",
       "\n",
       "                                  notes event_import_source event_import_id  \\\n",
       "0                                   nan                 glc           684.0   \n",
       "1                                   nan                 glc           956.0   \n",
       "2                                   nan                 glc           973.0   \n",
       "3                                   nan                 glc          1067.0   \n",
       "4                                   nan                 glc          2603.0   \n",
       "...                                 ...                 ...             ...   \n",
       "11028                               nan                 nan             nan   \n",
       "11029  Nallah is a steep narrow valley.                 nan             nan   \n",
       "11030                               nan                 nan             nan   \n",
       "11031                               nan                 nan             nan   \n",
       "11032                               nan                 nan             nan   \n",
       "\n",
       "        country_name country_code admin_division_population  rain  earthquake  \\\n",
       "0              China           CN                       nan     1           0   \n",
       "1      United States           US                   36619.0     1           0   \n",
       "2               Peru           PE                   14708.0     1           0   \n",
       "3              Nepal           NP                   20908.0     1           0   \n",
       "4        Philippines           PH                  798634.0     0           0   \n",
       "...              ...          ...                       ...   ...         ...   \n",
       "11028            nan          nan                       nan     1           0   \n",
       "11029            nan          nan                       nan     0           0   \n",
       "11030            nan          nan                       nan     0           0   \n",
       "11031            nan          nan                       nan     1           0   \n",
       "11032            nan          nan                       nan     0           0   \n",
       "\n",
       "       downpour  snow  other  small_scale  medium_scale  large_scale  \\\n",
       "0             0     0      0            0             0            1   \n",
       "1             1     0      0            0             0            0   \n",
       "2             1     0      0            0             0            1   \n",
       "3             0     0      0            0             1            0   \n",
       "4             0     0      1            0             1            0   \n",
       "...         ...   ...    ...          ...           ...          ...   \n",
       "11028         0     0      0            0             1            0   \n",
       "11029         0     0      1            0             0            0   \n",
       "11030         0     0      0            0             0            0   \n",
       "11031         1     0      0            0             0            1   \n",
       "11032         0     0      1            0             0            0   \n",
       "\n",
       "       home_destroyed  mudslide  landslide  \n",
       "0                   0         0          1  \n",
       "1                   0         1          0  \n",
       "2                   0         0          1  \n",
       "3                   0         0          1  \n",
       "4                   1         0          1  \n",
       "...               ...       ...        ...  \n",
       "11028               0         0          1  \n",
       "11029               0         0          1  \n",
       "11030               0         0          1  \n",
       "11031               0         0          0  \n",
       "11032               0         1          0  \n",
       "\n",
       "[11033 rows x 28 columns]"
      ]
     },
     "execution_count": 198,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "id": "ee9d26d4",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ebeng\\AppData\\Local\\Temp\\ipykernel_3388\\3314882358.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1.drop(df1[condition].index, inplace=True)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>rain</th>\n",
       "      <th>earthquake</th>\n",
       "      <th>downpour</th>\n",
       "      <th>snow</th>\n",
       "      <th>other</th>\n",
       "      <th>small_scale</th>\n",
       "      <th>medium_scale</th>\n",
       "      <th>large_scale</th>\n",
       "      <th>home_destroyed</th>\n",
       "      <th>mudslide</th>\n",
       "      <th>landslide</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3 killed, including 2 children when rocks fell...</td>\n",
       "      <td>calle Granjas, Ampliación Miguel de la Madrid,...</td>\n",
       "      <td>10km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>complex</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Tropical Storm Henrietta</td>\n",
       "      <td>http://www.cronica.com.mx/oimagenes11/1/f94ae8...</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>225.0</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>MX</td>\n",
       "      <td>3191.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Yunnan has so far reported 40 deaths and 43 pe...</td>\n",
       "      <td>Kunming, Yunnan</td>\n",
       "      <td>25km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>complex</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>874.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>1023674.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>A landslide hit the village in barangay Gadgar...</td>\n",
       "      <td>Gadgaron village of Matnog town, Sorsogon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>955.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>6721.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9837</th>\n",
       "      <td>With the recovery of three more bodies, the to...</td>\n",
       "      <td>Darjeeling Sadar, Darjeeling West Bengal</td>\n",
       "      <td>25km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Cyclone Aila</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1030.0</td>\n",
       "      <td>India</td>\n",
       "      <td>IN</td>\n",
       "      <td>123797.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9853</th>\n",
       "      <td>Clearing operations are ongoing in many  roads...</td>\n",
       "      <td>Kennon Road, Benguet</td>\n",
       "      <td>25km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Utor</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>5314.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>2653.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9855</th>\n",
       "      <td>Specific information was not given. Multiple l...</td>\n",
       "      <td>nan</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "      <td>40.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>9261.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>21867.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9867</th>\n",
       "      <td>SÃO PAULO — Brazilian authorities say a couple...</td>\n",
       "      <td>Maua, Sao Paulo</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2935.0</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>BR</td>\n",
       "      <td>386069.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9869</th>\n",
       "      <td>Two contractors working near Field, B.C. were ...</td>\n",
       "      <td>nan</td>\n",
       "      <td>10km</td>\n",
       "      <td>construction</td>\n",
       "      <td>medium</td>\n",
       "      <td>mine</td>\n",
       "      <td>rock_fall</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://shawglobalnews.files.wordpress.com/2016...</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>9663.0</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CA</td>\n",
       "      <td>4038.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1512 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      event_description  \\\n",
       "2     (CBS/AP) At least 10 people died and as many a...   \n",
       "3     One person was killed in Dailekh district, pol...   \n",
       "7     3 killed, including 2 children when rocks fell...   \n",
       "10    Yunnan has so far reported 40 deaths and 43 pe...   \n",
       "14    A landslide hit the village in barangay Gadgar...   \n",
       "...                                                 ...   \n",
       "9837  With the recovery of three more bodies, the to...   \n",
       "9853  Clearing operations are ongoing in many  roads...   \n",
       "9855  Specific information was not given. Multiple l...   \n",
       "9867  SÃO PAULO — Brazilian authorities say a couple...   \n",
       "9869  Two contractors working near Field, B.C. were ...   \n",
       "\n",
       "                                   location_description location_accuracy  \\\n",
       "2     San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                      Dailekh district           unknown   \n",
       "7     calle Granjas, Ampliación Miguel de la Madrid,...              10km   \n",
       "10                                      Kunming, Yunnan              25km   \n",
       "14           Gadgaron village of Matnog town, Sorsogon                5km   \n",
       "...                                                 ...               ...   \n",
       "9837           Darjeeling Sadar, Darjeeling West Bengal              25km   \n",
       "9853                               Kennon Road, Benguet              25km   \n",
       "9855                                                nan           unknown   \n",
       "9867                                    Maua, Sao Paulo               5km   \n",
       "9869                                                nan              10km   \n",
       "\n",
       "     landslide_trigger landslide_size landslide_setting landslide_category  \\\n",
       "2             downpour          large           unknown          landslide   \n",
       "3              monsoon         medium           unknown          landslide   \n",
       "7     tropical_cyclone         medium           unknown            complex   \n",
       "10            downpour         medium           unknown            complex   \n",
       "14            downpour         medium           unknown          landslide   \n",
       "...                ...            ...               ...                ...   \n",
       "9837  tropical_cyclone         medium           unknown          landslide   \n",
       "9853  tropical_cyclone         medium           unknown          landslide   \n",
       "9855           monsoon        unknown           unknown            unknown   \n",
       "9867          downpour         medium           unknown           mudslide   \n",
       "9869      construction         medium              mine          rock_fall   \n",
       "\n",
       "     fatality_count injury_count                storm_name  \\\n",
       "2              10.0          0.0                       nan   \n",
       "3               1.0          0.0                       nan   \n",
       "7               3.0          0.0  Tropical Storm Henrietta   \n",
       "10              4.0          0.0                       nan   \n",
       "14              0.0          1.0                       nan   \n",
       "...             ...          ...                       ...   \n",
       "9837           14.0          0.0              Cyclone Aila   \n",
       "9853            1.0          0.0                      Utor   \n",
       "9855           40.0         20.0                       nan   \n",
       "9867            2.0          0.0                       nan   \n",
       "9869            0.0          2.0                       nan   \n",
       "\n",
       "                                             photo_link notes  \\\n",
       "2                                                   nan   nan   \n",
       "3                                                   nan   nan   \n",
       "7     http://www.cronica.com.mx/oimagenes11/1/f94ae8...   nan   \n",
       "10                                                  nan   nan   \n",
       "14                                                  nan   nan   \n",
       "...                                                 ...   ...   \n",
       "9837                                                nan   nan   \n",
       "9853                                                nan   nan   \n",
       "9855                                                nan   nan   \n",
       "9867                                                nan   nan   \n",
       "9869  http://shawglobalnews.files.wordpress.com/2016...   nan   \n",
       "\n",
       "     event_import_source event_import_id country_name country_code  \\\n",
       "2                    glc           973.0         Peru           PE   \n",
       "3                    glc          1067.0        Nepal           NP   \n",
       "7                    glc           225.0       Mexico           MX   \n",
       "10                   glc           874.0        China           CN   \n",
       "14                   glc           955.0  Philippines           PH   \n",
       "...                  ...             ...          ...          ...   \n",
       "9837                 glc          1030.0        India           IN   \n",
       "9853                 glc          5314.0  Philippines           PH   \n",
       "9855                 glc          9261.0        Nepal           NP   \n",
       "9867                 glc          2935.0       Brazil           BR   \n",
       "9869                 glc          9663.0       Canada           CA   \n",
       "\n",
       "     admin_division_population  rain  earthquake  downpour  snow  other  \\\n",
       "2                      14708.0     1           0         1     0      0   \n",
       "3                      20908.0     1           0         0     0      0   \n",
       "7                       3191.0     0           0         0     0      1   \n",
       "10                   1023674.0     1           0         1     0      0   \n",
       "14                      6721.0     1           0         1     0      0   \n",
       "...                        ...   ...         ...       ...   ...    ...   \n",
       "9837                  123797.0     0           0         0     0      1   \n",
       "9853                    2653.0     0           0         0     0      1   \n",
       "9855                   21867.0     1           0         0     0      0   \n",
       "9867                  386069.0     1           0         1     0      0   \n",
       "9869                    4038.0     0           0         0     0      1   \n",
       "\n",
       "      small_scale  medium_scale  large_scale  home_destroyed  mudslide  \\\n",
       "2               0             0            1               0         0   \n",
       "3               0             1            0               0         0   \n",
       "7               0             1            0               1         0   \n",
       "10              0             1            0               0         0   \n",
       "14              0             1            0               0         0   \n",
       "...           ...           ...          ...             ...       ...   \n",
       "9837            0             1            0               1         0   \n",
       "9853            0             1            0               0         0   \n",
       "9855            0             0            0               0         0   \n",
       "9867            0             1            0               1         1   \n",
       "9869            0             1            0               0         0   \n",
       "\n",
       "      landslide  \n",
       "2             1  \n",
       "3             1  \n",
       "7             0  \n",
       "10            0  \n",
       "14            1  \n",
       "...         ...  \n",
       "9837          1  \n",
       "9853          1  \n",
       "9855          0  \n",
       "9867          0  \n",
       "9869          0  \n",
       "\n",
       "[1512 rows x 28 columns]"
      ]
     },
     "execution_count": 219,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "df1 = df.loc[df[\"admin_division_population\"] !='nan' ]\n",
    "condition = (df1['injury_count'] == '0.0') & (df1['fatality_count'] == '0.0')\n",
    "df1.drop(df1[condition].index, inplace=True)\n",
    "\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 220,
   "id": "c5806c21",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>rain</th>\n",
       "      <th>earthquake</th>\n",
       "      <th>downpour</th>\n",
       "      <th>snow</th>\n",
       "      <th>other</th>\n",
       "      <th>small_scale</th>\n",
       "      <th>medium_scale</th>\n",
       "      <th>large_scale</th>\n",
       "      <th>home_destroyed</th>\n",
       "      <th>mudslide</th>\n",
       "      <th>landslide</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>occurred early in morning, 11 villagers buried...</td>\n",
       "      <td>Sigou Village, Loufan County, Shanxi Province</td>\n",
       "      <td>unknown</td>\n",
       "      <td>rain</td>\n",
       "      <td>large</td>\n",
       "      <td>mine</td>\n",
       "      <td>landslide</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>684.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hours of heavy rain are to blame for an overni...</td>\n",
       "      <td>Lake Oswego, Oregon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>small</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>956.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>US</td>\n",
       "      <td>36619.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Another landslide in sitio Bakilid in barangay...</td>\n",
       "      <td>sitio Bakilid in barangay Lahug</td>\n",
       "      <td>5km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Supertyphoon Juan (Megi)</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>glc</td>\n",
       "      <td>2603.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>798634.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11028</th>\n",
       "      <td>Landslide exacerbated by deforestation and bad...</td>\n",
       "      <td>Banaran, Ponorogo, Jawa Timur, Indonesia</td>\n",
       "      <td>5km</td>\n",
       "      <td>rain</td>\n",
       "      <td>medium</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://img.jakpost.net/c/2017/04/02/2017_04_02...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11029</th>\n",
       "      <td>Two teenage girls died after they were buried ...</td>\n",
       "      <td>Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...</td>\n",
       "      <td>5km</td>\n",
       "      <td>other</td>\n",
       "      <td>small</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>landslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>Nallah is a steep narrow valley.</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11030</th>\n",
       "      <td>An octogenarian was killed when a sudden lands...</td>\n",
       "      <td>Pub Sarania Hill, Guwahati, Assam, India</td>\n",
       "      <td>1km</td>\n",
       "      <td>unknown</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11031</th>\n",
       "      <td>Landslide triggered by heavy rainfall buried 1...</td>\n",
       "      <td>Ayu, Ozgon, Osh, Kyrgyzstan</td>\n",
       "      <td>1km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>natural_slope</td>\n",
       "      <td>translational_slide</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>http://blogs.agu.org/landslideblog/files/2017/...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11032</th>\n",
       "      <td>A mudslide at an under-construction commercial...</td>\n",
       "      <td>Hyderabad, Rangareddy, Telangana</td>\n",
       "      <td>1km</td>\n",
       "      <td>construction</td>\n",
       "      <td>small</td>\n",
       "      <td>urban</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>nan</td>\n",
       "      <td>https://timesofindia.indiatimes.com/thumb/msid...</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>nan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11033 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       event_description  \\\n",
       "0      occurred early in morning, 11 villagers buried...   \n",
       "1      Hours of heavy rain are to blame for an overni...   \n",
       "2      (CBS/AP) At least 10 people died and as many a...   \n",
       "3      One person was killed in Dailekh district, pol...   \n",
       "4      Another landslide in sitio Bakilid in barangay...   \n",
       "...                                                  ...   \n",
       "11028  Landslide exacerbated by deforestation and bad...   \n",
       "11029  Two teenage girls died after they were buried ...   \n",
       "11030  An octogenarian was killed when a sudden lands...   \n",
       "11031  Landslide triggered by heavy rainfall buried 1...   \n",
       "11032  A mudslide at an under-construction commercial...   \n",
       "\n",
       "                                    location_description location_accuracy  \\\n",
       "0          Sigou Village, Loufan County, Shanxi Province           unknown   \n",
       "1                                    Lake Oswego, Oregon               5km   \n",
       "2      San Ramon district, 195 miles northeast of the...              10km   \n",
       "3                                       Dailekh district           unknown   \n",
       "4                        sitio Bakilid in barangay Lahug               5km   \n",
       "...                                                  ...               ...   \n",
       "11028           Banaran, Ponorogo, Jawa Timur, Indonesia               5km   \n",
       "11029  Barnari Sigdi area, Tehsil Mughalmaidan, Kisht...               5km   \n",
       "11030           Pub Sarania Hill, Guwahati, Assam, India               1km   \n",
       "11031                        Ayu, Ozgon, Osh, Kyrgyzstan               1km   \n",
       "11032                   Hyderabad, Rangareddy, Telangana               1km   \n",
       "\n",
       "      landslide_trigger landslide_size landslide_setting   landslide_category  \\\n",
       "0                  rain          large              mine            landslide   \n",
       "1              downpour          small           unknown             mudslide   \n",
       "2              downpour          large           unknown            landslide   \n",
       "3               monsoon         medium           unknown            landslide   \n",
       "4      tropical_cyclone         medium           unknown            landslide   \n",
       "...                 ...            ...               ...                  ...   \n",
       "11028              rain         medium     natural_slope            landslide   \n",
       "11029             other          small     natural_slope            landslide   \n",
       "11030           unknown          small             urban            landslide   \n",
       "11031          downpour          large     natural_slope  translational_slide   \n",
       "11032      construction          small             urban             mudslide   \n",
       "\n",
       "      fatality_count injury_count                storm_name  \\\n",
       "0               11.0          0.0                       nan   \n",
       "1                0.0          0.0                       nan   \n",
       "2               10.0          0.0                       nan   \n",
       "3                1.0          0.0                       nan   \n",
       "4                0.0          0.0  Supertyphoon Juan (Megi)   \n",
       "...              ...          ...                       ...   \n",
       "11028           27.0          0.0                       nan   \n",
       "11029            2.0          0.0                       nan   \n",
       "11030            1.0          0.0                       nan   \n",
       "11031           24.0          0.0                       nan   \n",
       "11032            2.0          0.0                       nan   \n",
       "\n",
       "                                              photo_link  \\\n",
       "0                                                    nan   \n",
       "1                                                    nan   \n",
       "2                                                    nan   \n",
       "3                                                    nan   \n",
       "4                                                    nan   \n",
       "...                                                  ...   \n",
       "11028  http://img.jakpost.net/c/2017/04/02/2017_04_02...   \n",
       "11029                                                nan   \n",
       "11030                                                nan   \n",
       "11031  http://blogs.agu.org/landslideblog/files/2017/...   \n",
       "11032  https://timesofindia.indiatimes.com/thumb/msid...   \n",
       "\n",
       "                                  notes event_import_source event_import_id  \\\n",
       "0                                   nan                 glc           684.0   \n",
       "1                                   nan                 glc           956.0   \n",
       "2                                   nan                 glc           973.0   \n",
       "3                                   nan                 glc          1067.0   \n",
       "4                                   nan                 glc          2603.0   \n",
       "...                                 ...                 ...             ...   \n",
       "11028                               nan                 nan             nan   \n",
       "11029  Nallah is a steep narrow valley.                 nan             nan   \n",
       "11030                               nan                 nan             nan   \n",
       "11031                               nan                 nan             nan   \n",
       "11032                               nan                 nan             nan   \n",
       "\n",
       "        country_name country_code admin_division_population  rain  earthquake  \\\n",
       "0              China           CN                       nan     1           0   \n",
       "1      United States           US                   36619.0     1           0   \n",
       "2               Peru           PE                   14708.0     1           0   \n",
       "3              Nepal           NP                   20908.0     1           0   \n",
       "4        Philippines           PH                  798634.0     0           0   \n",
       "...              ...          ...                       ...   ...         ...   \n",
       "11028            nan          nan                       nan     1           0   \n",
       "11029            nan          nan                       nan     0           0   \n",
       "11030            nan          nan                       nan     0           0   \n",
       "11031            nan          nan                       nan     1           0   \n",
       "11032            nan          nan                       nan     0           0   \n",
       "\n",
       "       downpour  snow  other  small_scale  medium_scale  large_scale  \\\n",
       "0             0     0      0            0             0            1   \n",
       "1             1     0      0            0             0            0   \n",
       "2             1     0      0            0             0            1   \n",
       "3             0     0      0            0             1            0   \n",
       "4             0     0      1            0             1            0   \n",
       "...         ...   ...    ...          ...           ...          ...   \n",
       "11028         0     0      0            0             1            0   \n",
       "11029         0     0      1            0             0            0   \n",
       "11030         0     0      0            0             0            0   \n",
       "11031         1     0      0            0             0            1   \n",
       "11032         0     0      1            0             0            0   \n",
       "\n",
       "       home_destroyed  mudslide  landslide  \n",
       "0                   0         0          1  \n",
       "1                   0         1          0  \n",
       "2                   0         0          1  \n",
       "3                   0         0          1  \n",
       "4                   1         0          1  \n",
       "...               ...       ...        ...  \n",
       "11028               0         0          1  \n",
       "11029               0         0          1  \n",
       "11030               0         0          1  \n",
       "11031               0         0          0  \n",
       "11032               0         1          0  \n",
       "\n",
       "[11033 rows x 28 columns]"
      ]
     },
     "execution_count": 220,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 216,
   "id": "01ca5b3b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.to_csv(\"cleaned_data.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 217,
   "id": "3d868c31",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_description</th>\n",
       "      <th>location_description</th>\n",
       "      <th>location_accuracy</th>\n",
       "      <th>landslide_trigger</th>\n",
       "      <th>landslide_size</th>\n",
       "      <th>landslide_setting</th>\n",
       "      <th>landslide_category</th>\n",
       "      <th>fatality_count</th>\n",
       "      <th>injury_count</th>\n",
       "      <th>storm_name</th>\n",
       "      <th>photo_link</th>\n",
       "      <th>notes</th>\n",
       "      <th>event_import_source</th>\n",
       "      <th>event_import_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>country_code</th>\n",
       "      <th>admin_division_population</th>\n",
       "      <th>rain</th>\n",
       "      <th>earthquake</th>\n",
       "      <th>downpour</th>\n",
       "      <th>snow</th>\n",
       "      <th>other</th>\n",
       "      <th>small_scale</th>\n",
       "      <th>medium_scale</th>\n",
       "      <th>large_scale</th>\n",
       "      <th>home_destroyed</th>\n",
       "      <th>mudslide</th>\n",
       "      <th>landslide</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>(CBS/AP) At least 10 people died and as many a...</td>\n",
       "      <td>San Ramon district, 195 miles northeast of the...</td>\n",
       "      <td>10km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>large</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>973.0</td>\n",
       "      <td>Peru</td>\n",
       "      <td>PE</td>\n",
       "      <td>14708.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>One person was killed in Dailekh district, pol...</td>\n",
       "      <td>Dailekh district</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>20908.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3 killed, including 2 children when rocks fell...</td>\n",
       "      <td>calle Granjas, Ampliación Miguel de la Madrid,...</td>\n",
       "      <td>10km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>complex</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Tropical Storm Henrietta</td>\n",
       "      <td>http://www.cronica.com.mx/oimagenes11/1/f94ae8...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>225.0</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>MX</td>\n",
       "      <td>3191.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Yunnan has so far reported 40 deaths and 43 pe...</td>\n",
       "      <td>Kunming, Yunnan</td>\n",
       "      <td>25km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>complex</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>874.0</td>\n",
       "      <td>China</td>\n",
       "      <td>CN</td>\n",
       "      <td>1023674.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A landslide hit the village in barangay Gadgar...</td>\n",
       "      <td>Gadgaron village of Matnog town, Sorsogon</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>955.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>6721.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1507</th>\n",
       "      <td>With the recovery of three more bodies, the to...</td>\n",
       "      <td>Darjeeling Sadar, Darjeeling West Bengal</td>\n",
       "      <td>25km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Cyclone Aila</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>1030.0</td>\n",
       "      <td>India</td>\n",
       "      <td>IN</td>\n",
       "      <td>123797.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1508</th>\n",
       "      <td>Clearing operations are ongoing in many  roads...</td>\n",
       "      <td>Kennon Road, Benguet</td>\n",
       "      <td>25km</td>\n",
       "      <td>tropical_cyclone</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>landslide</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Utor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>5314.0</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>PH</td>\n",
       "      <td>2653.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1509</th>\n",
       "      <td>Specific information was not given. Multiple l...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>unknown</td>\n",
       "      <td>monsoon</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "      <td>unknown</td>\n",
       "      <td>40.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>9261.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>NP</td>\n",
       "      <td>21867.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1510</th>\n",
       "      <td>SÃO PAULO — Brazilian authorities say a couple...</td>\n",
       "      <td>Maua, Sao Paulo</td>\n",
       "      <td>5km</td>\n",
       "      <td>downpour</td>\n",
       "      <td>medium</td>\n",
       "      <td>unknown</td>\n",
       "      <td>mudslide</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>2935.0</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>BR</td>\n",
       "      <td>386069.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1511</th>\n",
       "      <td>Two contractors working near Field, B.C. were ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10km</td>\n",
       "      <td>construction</td>\n",
       "      <td>medium</td>\n",
       "      <td>mine</td>\n",
       "      <td>rock_fall</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://shawglobalnews.files.wordpress.com/2016...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>glc</td>\n",
       "      <td>9663.0</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CA</td>\n",
       "      <td>4038.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1512 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      event_description  \\\n",
       "0     (CBS/AP) At least 10 people died and as many a...   \n",
       "1     One person was killed in Dailekh district, pol...   \n",
       "2     3 killed, including 2 children when rocks fell...   \n",
       "3     Yunnan has so far reported 40 deaths and 43 pe...   \n",
       "4     A landslide hit the village in barangay Gadgar...   \n",
       "...                                                 ...   \n",
       "1507  With the recovery of three more bodies, the to...   \n",
       "1508  Clearing operations are ongoing in many  roads...   \n",
       "1509  Specific information was not given. Multiple l...   \n",
       "1510  SÃO PAULO — Brazilian authorities say a couple...   \n",
       "1511  Two contractors working near Field, B.C. were ...   \n",
       "\n",
       "                                   location_description location_accuracy  \\\n",
       "0     San Ramon district, 195 miles northeast of the...              10km   \n",
       "1                                      Dailekh district           unknown   \n",
       "2     calle Granjas, Ampliación Miguel de la Madrid,...              10km   \n",
       "3                                       Kunming, Yunnan              25km   \n",
       "4            Gadgaron village of Matnog town, Sorsogon                5km   \n",
       "...                                                 ...               ...   \n",
       "1507           Darjeeling Sadar, Darjeeling West Bengal              25km   \n",
       "1508                               Kennon Road, Benguet              25km   \n",
       "1509                                                NaN           unknown   \n",
       "1510                                    Maua, Sao Paulo               5km   \n",
       "1511                                                NaN              10km   \n",
       "\n",
       "     landslide_trigger landslide_size landslide_setting landslide_category  \\\n",
       "0             downpour          large           unknown          landslide   \n",
       "1              monsoon         medium           unknown          landslide   \n",
       "2     tropical_cyclone         medium           unknown            complex   \n",
       "3             downpour         medium           unknown            complex   \n",
       "4             downpour         medium           unknown          landslide   \n",
       "...                ...            ...               ...                ...   \n",
       "1507  tropical_cyclone         medium           unknown          landslide   \n",
       "1508  tropical_cyclone         medium           unknown          landslide   \n",
       "1509           monsoon        unknown           unknown            unknown   \n",
       "1510          downpour         medium           unknown           mudslide   \n",
       "1511      construction         medium              mine          rock_fall   \n",
       "\n",
       "      fatality_count  injury_count                storm_name  \\\n",
       "0               10.0           0.0                       NaN   \n",
       "1                1.0           0.0                       NaN   \n",
       "2                3.0           0.0  Tropical Storm Henrietta   \n",
       "3                4.0           0.0                       NaN   \n",
       "4                0.0           1.0                       NaN   \n",
       "...              ...           ...                       ...   \n",
       "1507            14.0           0.0              Cyclone Aila   \n",
       "1508             1.0           0.0                      Utor   \n",
       "1509            40.0          20.0                       NaN   \n",
       "1510             2.0           0.0                       NaN   \n",
       "1511             0.0           2.0                       NaN   \n",
       "\n",
       "                                             photo_link notes  \\\n",
       "0                                                   NaN   NaN   \n",
       "1                                                   NaN   NaN   \n",
       "2     http://www.cronica.com.mx/oimagenes11/1/f94ae8...   NaN   \n",
       "3                                                   NaN   NaN   \n",
       "4                                                   NaN   NaN   \n",
       "...                                                 ...   ...   \n",
       "1507                                                NaN   NaN   \n",
       "1508                                                NaN   NaN   \n",
       "1509                                                NaN   NaN   \n",
       "1510                                                NaN   NaN   \n",
       "1511  http://shawglobalnews.files.wordpress.com/2016...   NaN   \n",
       "\n",
       "     event_import_source  event_import_id country_name country_code  \\\n",
       "0                    glc            973.0         Peru           PE   \n",
       "1                    glc           1067.0        Nepal           NP   \n",
       "2                    glc            225.0       Mexico           MX   \n",
       "3                    glc            874.0        China           CN   \n",
       "4                    glc            955.0  Philippines           PH   \n",
       "...                  ...              ...          ...          ...   \n",
       "1507                 glc           1030.0        India           IN   \n",
       "1508                 glc           5314.0  Philippines           PH   \n",
       "1509                 glc           9261.0        Nepal           NP   \n",
       "1510                 glc           2935.0       Brazil           BR   \n",
       "1511                 glc           9663.0       Canada           CA   \n",
       "\n",
       "      admin_division_population  rain  earthquake  downpour  snow  other  \\\n",
       "0                       14708.0     1           0         1     0      0   \n",
       "1                       20908.0     1           0         0     0      0   \n",
       "2                        3191.0     0           0         0     0      1   \n",
       "3                     1023674.0     1           0         1     0      0   \n",
       "4                        6721.0     1           0         1     0      0   \n",
       "...                         ...   ...         ...       ...   ...    ...   \n",
       "1507                   123797.0     0           0         0     0      1   \n",
       "1508                     2653.0     0           0         0     0      1   \n",
       "1509                    21867.0     1           0         0     0      0   \n",
       "1510                   386069.0     1           0         1     0      0   \n",
       "1511                     4038.0     0           0         0     0      1   \n",
       "\n",
       "      small_scale  medium_scale  large_scale  home_destroyed  mudslide  \\\n",
       "0               0             0            1               0         0   \n",
       "1               0             1            0               0         0   \n",
       "2               0             1            0               1         0   \n",
       "3               0             1            0               0         0   \n",
       "4               0             1            0               0         0   \n",
       "...           ...           ...          ...             ...       ...   \n",
       "1507            0             1            0               1         0   \n",
       "1508            0             1            0               0         0   \n",
       "1509            0             0            0               0         0   \n",
       "1510            0             1            0               1         1   \n",
       "1511            0             1            0               0         0   \n",
       "\n",
       "      landslide  \n",
       "0             1  \n",
       "1             1  \n",
       "2             0  \n",
       "3             0  \n",
       "4             1  \n",
       "...         ...  \n",
       "1507          1  \n",
       "1508          1  \n",
       "1509          0  \n",
       "1510          0  \n",
       "1511          0  \n",
       "\n",
       "[1512 rows x 28 columns]"
      ]
     },
     "execution_count": 217,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new=pd.read_csv(\"cleaned_data.csv\")\n",
    "df_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5d4a1365",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "306122f3",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}