Tweets_Pre_processing_and_NER.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Tweets Pre-processing and NER",
      "provenance": [],
      "authorship_tag": "ABX9TyOMB35J3cX1nUi+sYe8Hrfl",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/debjyoti003/Important-Colab-Notebooks/blob/main/Tweets_Pre_processing_and_NER.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "8cBQEVQquG4P",
        "outputId": "f47389b2-50b7-4847-a27f-2b7f6eb341f6"
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Mounted at /content/drive\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "wh8FnyeuucW3",
        "outputId": "38e70970-9482-45c2-aee5-50ce2c22df29"
      },
      "source": [
        "import pandas as pd\n",
        "import re, os\n",
        "import seaborn as sns\n",
        "from wordcloud import WordCloud\n",
        "import matplotlib.pyplot as plt\n",
        "import nltk.corpus\n",
        "import spacy\n",
        "nltk.download(\"stopwords\")\n",
        "from nltk.corpus import stopwords\n",
        "nltk.download('wordnet')\n",
        "from nltk.stem import WordNetLemmatizer"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "[nltk_data] Downloading package stopwords to /root/nltk_data...\n",
            "[nltk_data]   Unzipping corpora/stopwords.zip.\n",
            "[nltk_data] Downloading package wordnet to /root/nltk_data...\n",
            "[nltk_data]   Unzipping corpora/wordnet.zip.\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "OlpkaLwGuisc"
      },
      "source": [
        "os.chdir('/content/drive/MyDrive/')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 652
        },
        "id": "syGS3k9Mu96i",
        "outputId": "549cddf7-3ead-407e-82c3-727ecb6959c9"
      },
      "source": [
        "df = pd.read_csv('extracted_tweets.csv')\n",
        "df.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>conversation_id</th>\n",
              "      <th>created_at</th>\n",
              "      <th>date</th>\n",
              "      <th>time</th>\n",
              "      <th>timezone</th>\n",
              "      <th>user_id</th>\n",
              "      <th>username</th>\n",
              "      <th>name</th>\n",
              "      <th>place</th>\n",
              "      <th>tweet</th>\n",
              "      <th>language</th>\n",
              "      <th>mentions</th>\n",
              "      <th>urls</th>\n",
              "      <th>photos</th>\n",
              "      <th>replies_count</th>\n",
              "      <th>retweets_count</th>\n",
              "      <th>likes_count</th>\n",
              "      <th>hashtags</th>\n",
              "      <th>cashtags</th>\n",
              "      <th>link</th>\n",
              "      <th>retweet</th>\n",
              "      <th>quote_url</th>\n",
              "      <th>video</th>\n",
              "      <th>thumbnail</th>\n",
              "      <th>near</th>\n",
              "      <th>geo</th>\n",
              "      <th>source</th>\n",
              "      <th>user_rt_id</th>\n",
              "      <th>user_rt</th>\n",
              "      <th>retweet_id</th>\n",
              "      <th>reply_to</th>\n",
              "      <th>retweet_date</th>\n",
              "      <th>translate</th>\n",
              "      <th>trans_src</th>\n",
              "      <th>trans_dest</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.392400e+18</td>\n",
              "      <td>1.392400e+18</td>\n",
              "      <td>2021-05-12 14:01:43 India Standard Time</td>\n",
              "      <td>12-05-2021</td>\n",
              "      <td>14:01:43</td>\n",
              "      <td>530</td>\n",
              "      <td>8.929951e+08</td>\n",
              "      <td>ifrcafrica</td>\n",
              "      <td>IFRC Africa</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Across Africa, at any given time, Red Cross an...</td>\n",
              "      <td>en</td>\n",
              "      <td>[]</td>\n",
              "      <td>['http://bit.ly/2RNeRSU']</td>\n",
              "      <td>['https://pbs.twimg.com/media/E1LJvvxWEAIRV86....</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>['floods']</td>\n",
              "      <td>[]</td>\n",
              "      <td>https://twitter.com/IFRCAfrica/status/13923970...</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>https://pbs.twimg.com/media/E1LJvvxWEAIRV86.jpg</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>[]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1.392400e+18</td>\n",
              "      <td>1.392400e+18</td>\n",
              "      <td>2021-05-12 13:55:41 India Standard Time</td>\n",
              "      <td>12-05-2021</td>\n",
              "      <td>13:55:41</td>\n",
              "      <td>530</td>\n",
              "      <td>9.085950e+17</td>\n",
              "      <td>wanjohikinguru</td>\n",
              "      <td>Wanjohi King'uru</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Poor drainage in Transami means we have to end...</td>\n",
              "      <td>en</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>['nairobi', 'floods']</td>\n",
              "      <td>[]</td>\n",
              "      <td>https://twitter.com/WanjohiKinguru/status/1392...</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>https://pbs.twimg.com/ext_tw_video_thumb/13923...</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>[]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1.392390e+18</td>\n",
              "      <td>1.392390e+18</td>\n",
              "      <td>2021-05-12 13:35:46 India Standard Time</td>\n",
              "      <td>12-05-2021</td>\n",
              "      <td>13:35:46</td>\n",
              "      <td>530</td>\n",
              "      <td>1.604304e+07</td>\n",
              "      <td>ncedigital</td>\n",
              "      <td>New Civil Engineer</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Daily brief:  🌥️ Queen's Speech intensifies #H...</td>\n",
              "      <td>en</td>\n",
              "      <td>[{'screen_name': 'networkrail', 'name': 'netwo...</td>\n",
              "      <td>['https://buff.ly/3eDdK1i', 'https://buff.ly/3...</td>\n",
              "      <td>['https://pbs.twimg.com/media/E1LDz05XIAAptuR....</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>['hs2', 'engineering', 'civilengineering', 'ra...</td>\n",
              "      <td>[]</td>\n",
              "      <td>https://twitter.com/ncedigital/status/13923905...</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>https://pbs.twimg.com/media/E1LDz05XIAAptuR.jpg</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>[]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1.392390e+18</td>\n",
              "      <td>1.392390e+18</td>\n",
              "      <td>2021-05-12 13:34:05 India Standard Time</td>\n",
              "      <td>12-05-2021</td>\n",
              "      <td>13:34:05</td>\n",
              "      <td>530</td>\n",
              "      <td>2.985111e+09</td>\n",
              "      <td>malurussally</td>\n",
              "      <td>Sally Forsstrom</td>\n",
              "      <td>NaN</td>\n",
              "      <td>#climate change impacts here already with #dro...</td>\n",
              "      <td>en</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>['climate', 'drought', 'bushfires', 'floods', ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>https://twitter.com/MalurusSally/status/139239...</td>\n",
              "      <td>False</td>\n",
              "      <td>https://twitter.com/shoebridgemlc/status/13922...</td>\n",
              "      <td>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>[]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1.392390e+18</td>\n",
              "      <td>1.392390e+18</td>\n",
              "      <td>2021-05-12 13:29:27 India Standard Time</td>\n",
              "      <td>12-05-2021</td>\n",
              "      <td>13:29:27</td>\n",
              "      <td>530</td>\n",
              "      <td>8.565930e+17</td>\n",
              "      <td>infonile</td>\n",
              "      <td>InfoNile</td>\n",
              "      <td>NaN</td>\n",
              "      <td>🧵: This is Thirst in a River Basin, an interac...</td>\n",
              "      <td>en</td>\n",
              "      <td>[]</td>\n",
              "      <td>['https://maps.infonile.org/covid-water-scarci...</td>\n",
              "      <td>['https://pbs.twimg.com/media/E1LCXHmXoAM1J_9....</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>['infomap', 'rainfall', 'droughts', 'floods', ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>https://twitter.com/infoNILE/status/1392388939...</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>https://pbs.twimg.com/media/E1LCXHmXoAM1J_9.jpg</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>[]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "             id  conversation_id  ... trans_src trans_dest\n",
              "0  1.392400e+18     1.392400e+18  ...       NaN        NaN\n",
              "1  1.392400e+18     1.392400e+18  ...       NaN        NaN\n",
              "2  1.392390e+18     1.392390e+18  ...       NaN        NaN\n",
              "3  1.392390e+18     1.392390e+18  ...       NaN        NaN\n",
              "4  1.392390e+18     1.392390e+18  ...       NaN        NaN\n",
              "\n",
              "[5 rows x 36 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "p8vlRiTUvtrh",
        "outputId": "859b3e1f-d99f-4357-cc6e-c930b25926ee"
      },
      "source": [
        "df.shape"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(10089, 36)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jmVQjcXLwM_J",
        "outputId": "673b56da-26aa-44c7-996e-8b7fc4489b98"
      },
      "source": [
        "df.isnull().sum()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "id                     0\n",
              "conversation_id        0\n",
              "created_at             0\n",
              "date                   0\n",
              "time                   0\n",
              "timezone               0\n",
              "user_id                0\n",
              "username               0\n",
              "name                   0\n",
              "place              10023\n",
              "tweet                  0\n",
              "language               0\n",
              "mentions               0\n",
              "urls                   0\n",
              "photos                 0\n",
              "replies_count          0\n",
              "retweets_count         0\n",
              "likes_count            0\n",
              "hashtags               0\n",
              "cashtags               0\n",
              "link                   0\n",
              "retweet                0\n",
              "quote_url           9108\n",
              "video                  0\n",
              "thumbnail           5942\n",
              "near               10089\n",
              "geo                10089\n",
              "source             10089\n",
              "user_rt_id         10089\n",
              "user_rt            10089\n",
              "retweet_id         10089\n",
              "reply_to               0\n",
              "retweet_date       10089\n",
              "translate          10089\n",
              "trans_src          10089\n",
              "trans_dest         10089\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aEbTnCYU5Hte"
      },
      "source": [
        "pd.set_option('display.max_colwidth', None)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 262
        },
        "id": "G1NI2DG6whvO",
        "outputId": "183674d2-da81-4601-e422-5a24f82d0898"
      },
      "source": [
        "# df2 = df.drop(df.columns.difference(['tweet']), axis = 1)\n",
        "df2 = df[['tweet']]\n",
        "df2.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tweet</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>#climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                                                                                                                                                                                                                                                                             tweet\n",
              "0                                                                                                   Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE\n",
              "1                                                                                                                           Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO\n",
              "2         Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C\n",
              "3                                                                                                                                                                #climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions\n",
              "4  🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ReNpyCSZ7X_H"
      },
      "source": [
        "Below I have removed 'https' links and username defined by @, as links are not useful, also username won't help much in the detection of location. Whole purpose of doing this is to detect the locations from the tweets. My purpose of not removing the hastags is, as in many of the hastags we can get the location names, so I have kept it there."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_AjtViBD4mM8",
        "outputId": "ddb42a5a-149f-4cbe-8eb6-72645339e070"
      },
      "source": [
        "def cleaned_data(text):\n",
        "    clean=re.sub(\"http\\S+\",\"\",text)\n",
        "    clean = clean.lower()\n",
        "    clean=re.sub(\"@\\S+\",\"\",clean)\n",
        "    clean = re.sub('#', '', clean)\n",
        "    # clean=re.sub(\"[^a-zA-Z0-9]\",\" \",clean)\n",
        "    return clean\n",
        "df2['Cleaned Tweets'] = df2['tweet'].apply(cleaned_data)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:8: 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",
            "  \n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 995
        },
        "id": "y9Zzxekc6ABg",
        "outputId": "70cf0ea9-9400-4f4d-81ae-b12732c1cacc"
      },
      "source": [
        "df2.head(15)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tweet</th>\n",
              "      <th>Cleaned Tweets</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE</td>\n",
              "      <td>across africa, at any given time, red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions.  learn more:</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi. we need to redo the drainage networks in the city. nairobi floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C</td>\n",
              "      <td>daily brief:  🌥️ queen's speech intensifies hs2 anxiety    🌥️  station competition winner revealed    🌥️ flood action plan launched    engineering civilengineering rail stations floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>#climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019 - march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p</td>\n",
              "      <td>🧵: this is thirst in a river basin, an interactive  infomap 🌍that pinpoints the areas most vulnerable to changing rainfall and runoff patterns - factors that contribute to droughts and floods - and those already facing 💧 water scarcity in the nile.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>ఉత్తరాఖండ్‌లో వరదలు...  #Kaitvmedia #Keemedia1 #Urvasiott #Keeyoungmantra #Az7amnews #Uttarakhand #Floods #Theri  https://t.co/MpgLkAMm9X</td>\n",
              "      <td>ఉత్తరాఖండ్‌లో వరదలు...  kaitvmedia keemedia1 urvasiott keeyoungmantra az7amnews uttarakhand floods theri</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>What if we could avoid Fatbergs, #Sewer Blockages, and #Floods? That's what Brian Moloney shares us in this week's #Podcast. 🎧 Fatbergs Right Ahead? Not if you Harvest the Right Data! ▶ Listen to the full episode on your favorite Podcatcher, or on  https://t.co/PaCpbIkwNx  https://t.co/NuVfDwoiTD</td>\n",
              "      <td>what if we could avoid fatbergs, sewer blockages, and floods? that's what brian moloney shares us in this week's podcast. 🎧 fatbergs right ahead? not if you harvest the right data! ▶ listen to the full episode on your favorite podcatcher, or on</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>#UPDATE 🇺🇳#UN #Somalia #Geneva #FLOODS Map by @CopernicusEMS  On Tuesday, UN humanitarians said that torrential rains in parts of Somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.  https://t.co/lZH0rKlCaE</td>\n",
              "      <td>update 🇺🇳un somalia geneva floods map by   on tuesday, un humanitarians said that torrential rains in parts of somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>@redcrosscanada help !!! @amnesty @HRWatchdog #FortSimpson #floods</td>\n",
              "      <td>help !!!   fortsimpson floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Indian and Global #films. How have they depicted #floods and flood #victims? Welcoming Dr. Suchandra Ghatak as a speaker. TMYS Review Sept 2021  Calling for #essays, #stories, #poems on Migration, Resettlement and Displacement of Flood victims.  https://t.co/yEphjmZDgt  https://t.co/QIrjC6B38S</td>\n",
              "      <td>indian and global films. how have they depicted floods and flood victims? welcoming dr. suchandra ghatak as a speaker. tmys review sept 2021  calling for essays, stories, poems on migration, resettlement and displacement of flood victims.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Fangak appeals for humanitarian aid as #floods engulf areas  https://t.co/8qso0r7YwB</td>\n",
              "      <td>fangak appeals for humanitarian aid as floods engulf areas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>#SUPERBOYPROJECT #ANTWONTRINH #GARGANTUAN FOAMS MOLDINGS VIA #PROJECTTSUNAMI &amp;amp; #FLOODS  PREVENTIONS READY; #WINDMILL W/ SOLAR POWER/WATER MILL CHARGER, FLOAT EMPTY BARRIERS _ IN WATER, AND SAME H20/SAND @ INLANDS †  🌊  https://t.co/bSThvaYS2M 💦  🏝️  https://t.co/58wcXtwpFR 🏖️  https://t.co/kHU3ywFeKd</td>\n",
              "      <td>superboyproject antwontrinh gargantuan foams moldings via projecttsunami &amp;amp; floods  preventions ready; windmill w/ solar power/water mill charger, float empty barriers _ in water, and same h20/sand @ inlands †  🌊   💦  🏝️   🏖️</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Sharing my new open access article about floods' effect on men's and women's time-use in Pakistan. Findings show men help out more in household work after #floods leading to a decline in #gender #inequality in unpaid work. Data source: @IFPRI PRHPS.  https://t.co/wtgOR5xUtS  https://t.co/kSPZ7R41mr</td>\n",
              "      <td>sharing my new open access article about floods' effect on men's and women's time-use in pakistan. findings show men help out more in household work after floods leading to a decline in gender inequality in unpaid work. data source:  prhps.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/HPSPgFf3kQ</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors    tayikistán floods kulob dushanbe storm flooding кулоб душанбе</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/sVZyowdxoN</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors    tayikistán floods kulob dushanbe storm flooding кулоб душанбе</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                                                                                                                                                                                                                                                                                tweet                                                                                                                                                                                                                                                Cleaned Tweets\n",
              "0                                                                                                      Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE                                                                                                across africa, at any given time, red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions.  learn more:    \n",
              "1                                                                                                                              Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO                                                                                                 poor drainage in transami means we have to endure flooding when there is rain in nairobi. we need to redo the drainage networks in the city. nairobi floods  \n",
              "2            Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C                                                                    daily brief:  🌥️ queen's speech intensifies hs2 anxiety    🌥️  station competition winner revealed    🌥️ flood action plan launched    engineering civilengineering rail stations floods  \n",
              "3                                                                                                                                                                   #climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions                                                                                                                  climate change impacts here already with drought the bushfires from august 2019 - march 2020 then floods we need a plan for netzeroemissions\n",
              "4     🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p  🧵: this is thirst in a river basin, an interactive  infomap 🌍that pinpoints the areas most vulnerable to changing rainfall and runoff patterns - factors that contribute to droughts and floods - and those already facing 💧 water scarcity in the nile.    \n",
              "5                                                                                                                                                                           ఉత్తరాఖండ్‌లో వరదలు...  #Kaitvmedia #Keemedia1 #Urvasiott #Keeyoungmantra #Az7amnews #Uttarakhand #Floods #Theri  https://t.co/MpgLkAMm9X                                                                                                                                                    ఉత్తరాఖండ్‌లో వరదలు...  kaitvmedia keemedia1 urvasiott keeyoungmantra az7amnews uttarakhand floods theri  \n",
              "6           What if we could avoid Fatbergs, #Sewer Blockages, and #Floods? That's what Brian Moloney shares us in this week's #Podcast. 🎧 Fatbergs Right Ahead? Not if you Harvest the Right Data! ▶ Listen to the full episode on your favorite Podcatcher, or on  https://t.co/PaCpbIkwNx  https://t.co/NuVfDwoiTD      what if we could avoid fatbergs, sewer blockages, and floods? that's what brian moloney shares us in this week's podcast. 🎧 fatbergs right ahead? not if you harvest the right data! ▶ listen to the full episode on your favorite podcatcher, or on    \n",
              "7                                  #UPDATE 🇺🇳#UN #Somalia #Geneva #FLOODS Map by @CopernicusEMS  On Tuesday, UN humanitarians said that torrential rains in parts of Somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.  https://t.co/lZH0rKlCaE                      update 🇺🇳un somalia geneva floods map by   on tuesday, un humanitarians said that torrential rains in parts of somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.  \n",
              "8                                                                                                                                                                                                                                                  @redcrosscanada help !!! @amnesty @HRWatchdog #FortSimpson #floods                                                                                                                                                                                                                                 help !!!   fortsimpson floods\n",
              "9              Indian and Global #films. How have they depicted #floods and flood #victims? Welcoming Dr. Suchandra Ghatak as a speaker. TMYS Review Sept 2021  Calling for #essays, #stories, #poems on Migration, Resettlement and Displacement of Flood victims.  https://t.co/yEphjmZDgt  https://t.co/QIrjC6B38S            indian and global films. how have they depicted floods and flood victims? welcoming dr. suchandra ghatak as a speaker. tmys review sept 2021  calling for essays, stories, poems on migration, resettlement and displacement of flood victims.    \n",
              "10                                                                                                                                                                                                                               Fangak appeals for humanitarian aid as #floods engulf areas  https://t.co/8qso0r7YwB                                                                                                                                                                                                  fangak appeals for humanitarian aid as floods engulf areas  \n",
              "11  #SUPERBOYPROJECT #ANTWONTRINH #GARGANTUAN FOAMS MOLDINGS VIA #PROJECTTSUNAMI &amp; #FLOODS  PREVENTIONS READY; #WINDMILL W/ SOLAR POWER/WATER MILL CHARGER, FLOAT EMPTY BARRIERS _ IN WATER, AND SAME H20/SAND @ INLANDS †  🌊  https://t.co/bSThvaYS2M 💦  🏝️  https://t.co/58wcXtwpFR 🏖️  https://t.co/kHU3ywFeKd                        superboyproject antwontrinh gargantuan foams moldings via projecttsunami &amp; floods  preventions ready; windmill w/ solar power/water mill charger, float empty barriers _ in water, and same h20/sand @ inlands †  🌊   💦  🏝️   🏖️  \n",
              "12        Sharing my new open access article about floods' effect on men's and women's time-use in Pakistan. Findings show men help out more in household work after #floods leading to a decline in #gender #inequality in unpaid work. Data source: @IFPRI PRHPS.  https://t.co/wtgOR5xUtS  https://t.co/kSPZ7R41mr          sharing my new open access article about floods' effect on men's and women's time-use in pakistan. findings show men help out more in household work after floods leading to a decline in gender inequality in unpaid work. data source:  prhps.    \n",
              "13                                                                                                                                           Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/HPSPgFf3kQ                                                                                                                                            tajikistan sinks flash flood in several sectors    tayikistán floods kulob dushanbe storm flooding кулоб душанбе  \n",
              "14                                                                                                                                           Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/sVZyowdxoN                                                                                                                                            tajikistan sinks flash flood in several sectors    tayikistán floods kulob dushanbe storm flooding кулоб душанбе  "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "FmZ58b2h93Ay",
        "outputId": "f18e258c-321f-41ac-cd4d-abb2e50d97ae"
      },
      "source": [
        "!pip install contractions"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Collecting contractions\n",
            "  Downloading https://files.pythonhosted.org/packages/11/4d/378ab91284c2c3a06ab475b287721c09b7951d5ecb3edf4ffb0e1e7a568a/contractions-0.0.49-py2.py3-none-any.whl\n",
            "Collecting textsearch>=0.0.21\n",
            "  Downloading https://files.pythonhosted.org/packages/d3/fe/021d7d76961b5ceb9f8d022c4138461d83beff36c3938dc424586085e559/textsearch-0.0.21-py2.py3-none-any.whl\n",
            "Collecting pyahocorasick\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/7f/c2/eae730037ae1cbbfaa229d27030d1d5e34a1e41114b21447d1202ae9c220/pyahocorasick-1.4.2.tar.gz (321kB)\n",
            "\u001b[K     |████████████████████████████████| 327kB 6.7MB/s \n",
            "\u001b[?25hCollecting anyascii\n",
            "\u001b[?25l  Downloading https://files.pythonhosted.org/packages/a3/14/666cd44bf53f36a961544af592cb5c5c800013f9c51a4745af8d7c17362a/anyascii-0.2.0-py3-none-any.whl (283kB)\n",
            "\u001b[K     |████████████████████████████████| 286kB 8.8MB/s \n",
            "\u001b[?25hBuilding wheels for collected packages: pyahocorasick\n",
            "  Building wheel for pyahocorasick (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for pyahocorasick: filename=pyahocorasick-1.4.2-cp37-cp37m-linux_x86_64.whl size=85396 sha256=c15e1c31c823f25127d4c523b9d9d1c7fbbbcbc541ff861423b456059372beaf\n",
            "  Stored in directory: /root/.cache/pip/wheels/3a/03/34/77e3ece0bba8b86bfac88a79f923b36d805cad63caeba38842\n",
            "Successfully built pyahocorasick\n",
            "Installing collected packages: pyahocorasick, anyascii, textsearch, contractions\n",
            "Successfully installed anyascii-0.2.0 contractions-0.0.49 pyahocorasick-1.4.2 textsearch-0.0.21\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ozmWthaE-FAQ"
      },
      "source": [
        "import contractions"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "reHf6fE1L_Ah"
      },
      "source": [
        "**Below python package helps in expand contractions in text like don't -> do not, isn't -> is not etc..**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "w-em1dPm-GTV",
        "outputId": "ba07fdb5-7833-4df2-84cf-57b72ff1a117"
      },
      "source": [
        "text = '''I'll be there within 5 min. Shouldn't you be there too? \n",
        "          I'd love to see u there my dear. It's awesome to meet new friends.\n",
        "          We've been waiting for this day for so long.'''\n",
        "  \n",
        "# creating an empty list\n",
        "expanded_words = []    \n",
        "for word in text.split():\n",
        "  # using contractions.fix to expand the shotened words\n",
        "  expanded_words.append(contractions.fix(word))   \n",
        "    \n",
        "expanded_text = ' '.join(expanded_words)\n",
        "print('Original text: ' + text)\n",
        "print('Expanded_text: ' + expanded_text)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Original text: I'll be there within 5 min. Shouldn't you be there too? \n",
            "          I'd love to see u there my dear. It's awesome to meet new friends.\n",
            "          We've been waiting for this day for so long.\n",
            "Expanded_text: I will be there within 5 min. should not you be there too? I would love to see you there my dear. it is awesome to meet new friends. we have been waiting for this day for so long.\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "VAn-NrDm-mHn",
        "outputId": "30267c96-58c1-4376-ab3e-e7b7d8e6c2e4"
      },
      "source": [
        "def expanded(text):\n",
        "    expanded_words = []    \n",
        "    try:\n",
        "      for word in text.split():\n",
        "        expanded_words.append(contractions.fix(word))\n",
        "    except Exception:\n",
        "      pass         \n",
        "    expanded_text = ' '.join(expanded_words)\n",
        "    return expanded_text\n",
        "\n",
        "df2['Cleaned Tweets'] = df2['Cleaned Tweets'].apply(expanded)\n",
        "df2.head(15)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:11: 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",
            "  # This is added back by InteractiveShellApp.init_path()\n"
          ],
          "name": "stderr"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tweet</th>\n",
              "      <th>Cleaned Tweets</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE</td>\n",
              "      <td>across africa, at any given time, red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions. learn more:</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi. we need to redo the drainage networks in the city. nairobi floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C</td>\n",
              "      <td>daily brief: 🌥️ queen's speech intensifies hs2 anxiety 🌥️ station competition winner revealed 🌥️ flood action plan launched engineering civilengineering rail stations floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>#climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019 - march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p</td>\n",
              "      <td>🧵: this is thirst in a river basin, an interactive infomap 🌍that pinpoints the areas most vulnerable to changing rainfall and runoff patterns - factors that contribute to droughts and floods - and those already facing 💧 water scarcity in the nile.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>ఉత్తరాఖండ్‌లో వరదలు...  #Kaitvmedia #Keemedia1 #Urvasiott #Keeyoungmantra #Az7amnews #Uttarakhand #Floods #Theri  https://t.co/MpgLkAMm9X</td>\n",
              "      <td>ఉత్తరాఖండ్‌లో వరదలు... kaitvmedia keemedia1 urvasiott keeyoungmantra az7amnews uttarakhand floods theri</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>What if we could avoid Fatbergs, #Sewer Blockages, and #Floods? That's what Brian Moloney shares us in this week's #Podcast. 🎧 Fatbergs Right Ahead? Not if you Harvest the Right Data! ▶ Listen to the full episode on your favorite Podcatcher, or on  https://t.co/PaCpbIkwNx  https://t.co/NuVfDwoiTD</td>\n",
              "      <td>what if we could avoid fatbergs, sewer blockages, and floods? that is what brian moloney shares us in this week's podcast. 🎧 fatbergs right ahead? not if you harvest the right data! ▶ listen to the full episode on your favorite podcatcher, or on</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>#UPDATE 🇺🇳#UN #Somalia #Geneva #FLOODS Map by @CopernicusEMS  On Tuesday, UN humanitarians said that torrential rains in parts of Somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.  https://t.co/lZH0rKlCaE</td>\n",
              "      <td>update 🇺🇳un somalia geneva floods map by on tuesday, un humanitarians said that torrential rains in parts of somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>@redcrosscanada help !!! @amnesty @HRWatchdog #FortSimpson #floods</td>\n",
              "      <td>help !!! fortsimpson floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Indian and Global #films. How have they depicted #floods and flood #victims? Welcoming Dr. Suchandra Ghatak as a speaker. TMYS Review Sept 2021  Calling for #essays, #stories, #poems on Migration, Resettlement and Displacement of Flood victims.  https://t.co/yEphjmZDgt  https://t.co/QIrjC6B38S</td>\n",
              "      <td>indian and global films. how have they depicted floods and flood victims? welcoming dr. suchandra ghatak as a speaker. tmys review sept 2021 calling for essays, stories, poems on migration, resettlement and displacement of flood victims.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Fangak appeals for humanitarian aid as #floods engulf areas  https://t.co/8qso0r7YwB</td>\n",
              "      <td>fangak appeals for humanitarian aid as floods engulf areas</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>#SUPERBOYPROJECT #ANTWONTRINH #GARGANTUAN FOAMS MOLDINGS VIA #PROJECTTSUNAMI &amp;amp; #FLOODS  PREVENTIONS READY; #WINDMILL W/ SOLAR POWER/WATER MILL CHARGER, FLOAT EMPTY BARRIERS _ IN WATER, AND SAME H20/SAND @ INLANDS †  🌊  https://t.co/bSThvaYS2M 💦  🏝️  https://t.co/58wcXtwpFR 🏖️  https://t.co/kHU3ywFeKd</td>\n",
              "      <td>superboyproject antwontrinh gargantuan foams moldings via projecttsunami &amp;amp; floods preventions ready; windmill w/ solar power/water mill charger, float empty barriers _ in water, and same h20/sand @ inlands † 🌊 💦 🏝️ 🏖️</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Sharing my new open access article about floods' effect on men's and women's time-use in Pakistan. Findings show men help out more in household work after #floods leading to a decline in #gender #inequality in unpaid work. Data source: @IFPRI PRHPS.  https://t.co/wtgOR5xUtS  https://t.co/kSPZ7R41mr</td>\n",
              "      <td>sharing my new open access article about floods' effect on men's and women's time-use in pakistan. findings show men help out more in household work after floods leading to a decline in gender inequality in unpaid work. data source: prhps.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/HPSPgFf3kQ</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors tayikistán floods kulob dushanbe storm flooding кулоб душанбе</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/sVZyowdxoN</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors tayikistán floods kulob dushanbe storm flooding кулоб душанбе</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                                                                                                                                                                                                                                                                                tweet                                                                                                                                                                                                                                           Cleaned Tweets\n",
              "0                                                                                                      Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE                                                                                                across africa, at any given time, red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions. learn more:\n",
              "1                                                                                                                              Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO                                                                                              poor drainage in transami means we have to endure flooding when there is rain in nairobi. we need to redo the drainage networks in the city. nairobi floods\n",
              "2            Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C                                                                            daily brief: 🌥️ queen's speech intensifies hs2 anxiety 🌥️ station competition winner revealed 🌥️ flood action plan launched engineering civilengineering rail stations floods\n",
              "3                                                                                                                                                                   #climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions                                                                                                             climate change impacts here already with drought the bushfires from august 2019 - march 2020 then floods we need a plan for netzeroemissions\n",
              "4     🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p  🧵: this is thirst in a river basin, an interactive infomap 🌍that pinpoints the areas most vulnerable to changing rainfall and runoff patterns - factors that contribute to droughts and floods - and those already facing 💧 water scarcity in the nile.\n",
              "5                                                                                                                                                                           ఉత్తరాఖండ్‌లో వరదలు...  #Kaitvmedia #Keemedia1 #Urvasiott #Keeyoungmantra #Az7amnews #Uttarakhand #Floods #Theri  https://t.co/MpgLkAMm9X                                                                                                                                                  ఉత్తరాఖండ్‌లో వరదలు... kaitvmedia keemedia1 urvasiott keeyoungmantra az7amnews uttarakhand floods theri\n",
              "6           What if we could avoid Fatbergs, #Sewer Blockages, and #Floods? That's what Brian Moloney shares us in this week's #Podcast. 🎧 Fatbergs Right Ahead? Not if you Harvest the Right Data! ▶ Listen to the full episode on your favorite Podcatcher, or on  https://t.co/PaCpbIkwNx  https://t.co/NuVfDwoiTD    what if we could avoid fatbergs, sewer blockages, and floods? that is what brian moloney shares us in this week's podcast. 🎧 fatbergs right ahead? not if you harvest the right data! ▶ listen to the full episode on your favorite podcatcher, or on\n",
              "7                                  #UPDATE 🇺🇳#UN #Somalia #Geneva #FLOODS Map by @CopernicusEMS  On Tuesday, UN humanitarians said that torrential rains in parts of Somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.  https://t.co/lZH0rKlCaE                     update 🇺🇳un somalia geneva floods map by on tuesday, un humanitarians said that torrential rains in parts of somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.\n",
              "8                                                                                                                                                                                                                                                  @redcrosscanada help !!! @amnesty @HRWatchdog #FortSimpson #floods                                                                                                                                                                                                                              help !!! fortsimpson floods\n",
              "9              Indian and Global #films. How have they depicted #floods and flood #victims? Welcoming Dr. Suchandra Ghatak as a speaker. TMYS Review Sept 2021  Calling for #essays, #stories, #poems on Migration, Resettlement and Displacement of Flood victims.  https://t.co/yEphjmZDgt  https://t.co/QIrjC6B38S            indian and global films. how have they depicted floods and flood victims? welcoming dr. suchandra ghatak as a speaker. tmys review sept 2021 calling for essays, stories, poems on migration, resettlement and displacement of flood victims.\n",
              "10                                                                                                                                                                                                                               Fangak appeals for humanitarian aid as #floods engulf areas  https://t.co/8qso0r7YwB                                                                                                                                                                                               fangak appeals for humanitarian aid as floods engulf areas\n",
              "11  #SUPERBOYPROJECT #ANTWONTRINH #GARGANTUAN FOAMS MOLDINGS VIA #PROJECTTSUNAMI &amp; #FLOODS  PREVENTIONS READY; #WINDMILL W/ SOLAR POWER/WATER MILL CHARGER, FLOAT EMPTY BARRIERS _ IN WATER, AND SAME H20/SAND @ INLANDS †  🌊  https://t.co/bSThvaYS2M 💦  🏝️  https://t.co/58wcXtwpFR 🏖️  https://t.co/kHU3ywFeKd                            superboyproject antwontrinh gargantuan foams moldings via projecttsunami &amp; floods preventions ready; windmill w/ solar power/water mill charger, float empty barriers _ in water, and same h20/sand @ inlands † 🌊 💦 🏝️ 🏖️\n",
              "12        Sharing my new open access article about floods' effect on men's and women's time-use in Pakistan. Findings show men help out more in household work after #floods leading to a decline in #gender #inequality in unpaid work. Data source: @IFPRI PRHPS.  https://t.co/wtgOR5xUtS  https://t.co/kSPZ7R41mr          sharing my new open access article about floods' effect on men's and women's time-use in pakistan. findings show men help out more in household work after floods leading to a decline in gender inequality in unpaid work. data source: prhps.\n",
              "13                                                                                                                                           Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/HPSPgFf3kQ                                                                                                                                            tajikistan sinks flash flood in several sectors tayikistán floods kulob dushanbe storm flooding кулоб душанбе\n",
              "14                                                                                                                                           Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/sVZyowdxoN                                                                                                                                            tajikistan sinks flash flood in several sectors tayikistán floods kulob dushanbe storm flooding кулоб душанбе"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6oivXHE6MYLe"
      },
      "source": [
        "Below code will remove all the characters other than alphanumeric. This I could have done earlier, but is done later to make sure it doesn't remove other important things."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 582
        },
        "id": "_mn73TyWKGo9",
        "outputId": "d1b6c56d-61c2-47d2-ba0b-bc095101c8cc"
      },
      "source": [
        "def cleaned_further(text):\n",
        "    clean=re.sub(\"[^a-zA-Z0-9]\",\" \",text)\n",
        "    return clean\n",
        "df2['Cleaned Tweets Further'] = df2['Cleaned Tweets'].apply(cleaned_further)\n",
        "df2.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.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",
            "  after removing the cwd from sys.path.\n"
          ],
          "name": "stderr"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tweet</th>\n",
              "      <th>Cleaned Tweets</th>\n",
              "      <th>Cleaned Tweets Further</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE</td>\n",
              "      <td>across africa, at any given time, red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions. learn more:</td>\n",
              "      <td>across africa  at any given time  red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions  learn more</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi. we need to redo the drainage networks in the city. nairobi floods</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi  we need to redo the drainage networks in the city  nairobi floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C</td>\n",
              "      <td>daily brief: 🌥️ queen's speech intensifies hs2 anxiety 🌥️ station competition winner revealed 🌥️ flood action plan launched engineering civilengineering rail stations floods</td>\n",
              "      <td>daily brief     queen s speech intensifies hs2 anxiety    station competition winner revealed    flood action plan launched engineering civilengineering rail stations floods</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>#climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019 - march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019   march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p</td>\n",
              "      <td>🧵: this is thirst in a river basin, an interactive infomap 🌍that pinpoints the areas most vulnerable to changing rainfall and runoff patterns - factors that contribute to droughts and floods - and those already facing 💧 water scarcity in the nile.</td>\n",
              "      <td>this is thirst in a river basin  an interactive infomap  that pinpoints the areas most vulnerable to changing rainfall and runoff patterns   factors that contribute to droughts and floods   and those already facing   water scarcity in the nile</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                                                                                                                                                                                                                                                                             tweet  ...                                                                                                                                                                                                                                   Cleaned Tweets Further\n",
              "0                                                                                                   Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE  ...                                                                                                across africa  at any given time  red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions  learn more \n",
              "1                                                                                                                           Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO  ...                                                                                              poor drainage in transami means we have to endure flooding when there is rain in nairobi  we need to redo the drainage networks in the city  nairobi floods\n",
              "2         Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C  ...                                                                            daily brief     queen s speech intensifies hs2 anxiety    station competition winner revealed    flood action plan launched engineering civilengineering rail stations floods\n",
              "3                                                                                                                                                                #climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions  ...                                                                                                             climate change impacts here already with drought the bushfires from august 2019   march 2020 then floods we need a plan for netzeroemissions\n",
              "4  🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p  ...     this is thirst in a river basin  an interactive infomap  that pinpoints the areas most vulnerable to changing rainfall and runoff patterns   factors that contribute to droughts and floods   and those already facing   water scarcity in the nile \n",
              "\n",
              "[5 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "n-fuZmnHM5lf"
      },
      "source": [
        "**Almost all most of the pre-processing is done, now the only part that is remaining is extracting the locations from all the text. I will update it soon. You guys also work on it.**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "d14pNTKCvu_C"
      },
      "source": [
        "nlp = spacy.load('en_core_web_sm')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 632
        },
        "id": "mY9FvBcSxY9v",
        "outputId": "cc23b8fb-c4cf-4957-bb83-781e96b1153e"
      },
      "source": [
        "def entity_extract(text):\n",
        "  doc = nlp(text)\n",
        "  return [ent.text for ent in doc.ents if ent.label_ == 'GPE']\n",
        "\n",
        "df2['Location Name'] = df2['Cleaned Tweets Further'].apply(entity_extract)\n",
        "\n",
        "df2.head()\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.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",
            "  \"\"\"\n"
          ],
          "name": "stderr"
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tweet</th>\n",
              "      <th>Cleaned Tweets</th>\n",
              "      <th>Cleaned Tweets Further</th>\n",
              "      <th>Location Name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE</td>\n",
              "      <td>across africa, at any given time, red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions. learn more:</td>\n",
              "      <td>across africa  at any given time  red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions  learn more</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi. we need to redo the drainage networks in the city. nairobi floods</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi  we need to redo the drainage networks in the city  nairobi floods</td>\n",
              "      <td>[transami, nairobi, nairobi]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C</td>\n",
              "      <td>daily brief: 🌥️ queen's speech intensifies hs2 anxiety 🌥️ station competition winner revealed 🌥️ flood action plan launched engineering civilengineering rail stations floods</td>\n",
              "      <td>daily brief     queen s speech intensifies hs2 anxiety    station competition winner revealed    flood action plan launched engineering civilengineering rail stations floods</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>#climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019 - march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019   march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p</td>\n",
              "      <td>🧵: this is thirst in a river basin, an interactive infomap 🌍that pinpoints the areas most vulnerable to changing rainfall and runoff patterns - factors that contribute to droughts and floods - and those already facing 💧 water scarcity in the nile.</td>\n",
              "      <td>this is thirst in a river basin  an interactive infomap  that pinpoints the areas most vulnerable to changing rainfall and runoff patterns   factors that contribute to droughts and floods   and those already facing   water scarcity in the nile</td>\n",
              "      <td>[infomap]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                                                                                                                                                                                                                                                                             tweet  ...                 Location Name\n",
              "0                                                                                                   Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE  ...                            []\n",
              "1                                                                                                                           Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO  ...  [transami, nairobi, nairobi]\n",
              "2         Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C  ...                            []\n",
              "3                                                                                                                                                                #climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions  ...                            []\n",
              "4  🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p  ...                     [infomap]\n",
              "\n",
              "[5 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "G6eMLKrr5wqv",
        "outputId": "ed992878-f707-43b7-cd5c-2c5f2277d364"
      },
      "source": [
        "df2.head(50)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>tweet</th>\n",
              "      <th>Cleaned Tweets</th>\n",
              "      <th>Cleaned Tweets Further</th>\n",
              "      <th>Location Name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE</td>\n",
              "      <td>across africa, at any given time, red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions. learn more:</td>\n",
              "      <td>across africa  at any given time  red cross and red crescent national societies are responding to floods or cyclones with lifesaving actions  learn more</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi. we need to redo the drainage networks in the city. nairobi floods</td>\n",
              "      <td>poor drainage in transami means we have to endure flooding when there is rain in nairobi  we need to redo the drainage networks in the city  nairobi floods</td>\n",
              "      <td>[transami, nairobi, nairobi]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C</td>\n",
              "      <td>daily brief: 🌥️ queen's speech intensifies hs2 anxiety 🌥️ station competition winner revealed 🌥️ flood action plan launched engineering civilengineering rail stations floods</td>\n",
              "      <td>daily brief     queen s speech intensifies hs2 anxiety    station competition winner revealed    flood action plan launched engineering civilengineering rail stations floods</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>#climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019 - march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "      <td>climate change impacts here already with drought the bushfires from august 2019   march 2020 then floods we need a plan for netzeroemissions</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p</td>\n",
              "      <td>🧵: this is thirst in a river basin, an interactive infomap 🌍that pinpoints the areas most vulnerable to changing rainfall and runoff patterns - factors that contribute to droughts and floods - and those already facing 💧 water scarcity in the nile.</td>\n",
              "      <td>this is thirst in a river basin  an interactive infomap  that pinpoints the areas most vulnerable to changing rainfall and runoff patterns   factors that contribute to droughts and floods   and those already facing   water scarcity in the nile</td>\n",
              "      <td>[infomap]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>ఉత్తరాఖండ్‌లో వరదలు...  #Kaitvmedia #Keemedia1 #Urvasiott #Keeyoungmantra #Az7amnews #Uttarakhand #Floods #Theri  https://t.co/MpgLkAMm9X</td>\n",
              "      <td>ఉత్తరాఖండ్‌లో వరదలు... kaitvmedia keemedia1 urvasiott keeyoungmantra az7amnews uttarakhand floods theri</td>\n",
              "      <td>kaitvmedia keemedia1 urvasiott keeyoungmantra az7amnews uttarakhand floods theri</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>What if we could avoid Fatbergs, #Sewer Blockages, and #Floods? That's what Brian Moloney shares us in this week's #Podcast. 🎧 Fatbergs Right Ahead? Not if you Harvest the Right Data! ▶ Listen to the full episode on your favorite Podcatcher, or on  https://t.co/PaCpbIkwNx  https://t.co/NuVfDwoiTD</td>\n",
              "      <td>what if we could avoid fatbergs, sewer blockages, and floods? that is what brian moloney shares us in this week's podcast. 🎧 fatbergs right ahead? not if you harvest the right data! ▶ listen to the full episode on your favorite podcatcher, or on</td>\n",
              "      <td>what if we could avoid fatbergs  sewer blockages  and floods  that is what brian moloney shares us in this week s podcast    fatbergs right ahead  not if you harvest the right data    listen to the full episode on your favorite podcatcher  or on</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>#UPDATE 🇺🇳#UN #Somalia #Geneva #FLOODS Map by @CopernicusEMS  On Tuesday, UN humanitarians said that torrential rains in parts of Somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.  https://t.co/lZH0rKlCaE</td>\n",
              "      <td>update 🇺🇳un somalia geneva floods map by on tuesday, un humanitarians said that torrential rains in parts of somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.</td>\n",
              "      <td>update   un somalia geneva floods map by on tuesday  un humanitarians said that torrential rains in parts of somalia caused flash floods  killing at least 25 people just two weeks after the country was declared drought stricken</td>\n",
              "      <td>[somalia, somalia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>@redcrosscanada help !!! @amnesty @HRWatchdog #FortSimpson #floods</td>\n",
              "      <td>help !!! fortsimpson floods</td>\n",
              "      <td>help     fortsimpson floods</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Indian and Global #films. How have they depicted #floods and flood #victims? Welcoming Dr. Suchandra Ghatak as a speaker. TMYS Review Sept 2021  Calling for #essays, #stories, #poems on Migration, Resettlement and Displacement of Flood victims.  https://t.co/yEphjmZDgt  https://t.co/QIrjC6B38S</td>\n",
              "      <td>indian and global films. how have they depicted floods and flood victims? welcoming dr. suchandra ghatak as a speaker. tmys review sept 2021 calling for essays, stories, poems on migration, resettlement and displacement of flood victims.</td>\n",
              "      <td>indian and global films  how have they depicted floods and flood victims  welcoming dr  suchandra ghatak as a speaker  tmys review sept 2021 calling for essays  stories  poems on migration  resettlement and displacement of flood victims</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Fangak appeals for humanitarian aid as #floods engulf areas  https://t.co/8qso0r7YwB</td>\n",
              "      <td>fangak appeals for humanitarian aid as floods engulf areas</td>\n",
              "      <td>fangak appeals for humanitarian aid as floods engulf areas</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>#SUPERBOYPROJECT #ANTWONTRINH #GARGANTUAN FOAMS MOLDINGS VIA #PROJECTTSUNAMI &amp;amp; #FLOODS  PREVENTIONS READY; #WINDMILL W/ SOLAR POWER/WATER MILL CHARGER, FLOAT EMPTY BARRIERS _ IN WATER, AND SAME H20/SAND @ INLANDS †  🌊  https://t.co/bSThvaYS2M 💦  🏝️  https://t.co/58wcXtwpFR 🏖️  https://t.co/kHU3ywFeKd</td>\n",
              "      <td>superboyproject antwontrinh gargantuan foams moldings via projecttsunami &amp;amp; floods preventions ready; windmill w/ solar power/water mill charger, float empty barriers _ in water, and same h20/sand @ inlands † 🌊 💦 🏝️ 🏖️</td>\n",
              "      <td>superboyproject antwontrinh gargantuan foams moldings via projecttsunami  amp  floods preventions ready  windmill w  solar power water mill charger  float empty barriers   in water  and same h20 sand   inlands</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Sharing my new open access article about floods' effect on men's and women's time-use in Pakistan. Findings show men help out more in household work after #floods leading to a decline in #gender #inequality in unpaid work. Data source: @IFPRI PRHPS.  https://t.co/wtgOR5xUtS  https://t.co/kSPZ7R41mr</td>\n",
              "      <td>sharing my new open access article about floods' effect on men's and women's time-use in pakistan. findings show men help out more in household work after floods leading to a decline in gender inequality in unpaid work. data source: prhps.</td>\n",
              "      <td>sharing my new open access article about floods  effect on men s and women s time use in pakistan  findings show men help out more in household work after floods leading to a decline in gender inequality in unpaid work  data source  prhps</td>\n",
              "      <td>[pakistan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/HPSPgFf3kQ</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors tayikistán floods kulob dushanbe storm flooding кулоб душанбе</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors tayikist n floods kulob dushanbe storm flooding</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/sVZyowdxoN</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors tayikistán floods kulob dushanbe storm flooding кулоб душанбе</td>\n",
              "      <td>tajikistan sinks flash flood in several sectors tayikist n floods kulob dushanbe storm flooding</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Winter storm #FLOODS New England neighborhoods  https://t.co/oN7VFXeA09</td>\n",
              "      <td>winter storm floods new england neighborhoods</td>\n",
              "      <td>winter storm floods new england neighborhoods</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Winter storm #FLOODS New England neighborhoods  https://t.co/JPoN9QUBJj #GPWX</td>\n",
              "      <td>winter storm floods new england neighborhoods gpwx</td>\n",
              "      <td>winter storm floods new england neighborhoods gpwx</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>There’s a lot to know about the difference between floods and flash floods. Though the endgame is always the same, knowing the difference between the two might be helpful. Read this week’s blog to know more. →  https://t.co/EWsElqtSJF  #Floods #FlashFloods #FloodSolutions</td>\n",
              "      <td>there is a lot to know about the difference between floods and flash floods. though the endgame is always the same, knowing the difference between the two might be helpful. read this week’s blog to know more. → floods flashfloods floodsolutions</td>\n",
              "      <td>there is a lot to know about the difference between floods and flash floods  though the endgame is always the same  knowing the difference between the two might be helpful  read this week s blog to know more    floods flashfloods floodsolutions</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>@farmercate2 @LucyThack @samheagney @LiberalAus And just as we have needed help with #drought, #bushfires, #floods (haven't got it but need it!) so too do you need help. And this is a problem which will only get worse without radical, cohesive, concerted help - a plan, systematic eradication</td>\n",
              "      <td>and just as we have needed help with drought, bushfires, floods (have not got it but need it!) so too do you need help. and this is a problem which will only get worse without radical, cohesive, concerted help - a plan, systematic eradication</td>\n",
              "      <td>and just as we have needed help with drought  bushfires  floods  have not got it but need it   so too do you need help  and this is a problem which will only get worse without radical  cohesive  concerted help   a plan  systematic eradication</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>It’s Spring and with #Spring comes, you guessed it, rain! There are 3 types of #floods: river, #flashfloods and surface water, and storm surge.  Determine what type of insurance you have. Speak to your #insurancebroker about water damage insurance.  #flood #insurance #broker  https://t.co/3Wwy19j1o9</td>\n",
              "      <td>it is spring and with spring comes, you guessed it, rain! there are 3 types of floods: river, flashfloods and surface water, and storm surge. determine what type of insurance you have. speak to your insurancebroker about water damage insurance. flood insurance broker</td>\n",
              "      <td>it is spring and with spring comes  you guessed it  rain  there are 3 types of floods  river  flashfloods and surface water  and storm surge  determine what type of insurance you have  speak to your insurancebroker about water damage insurance  flood insurance broker</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>@HShPrez2Ware @ItalyinSomalia @SwedeninSomalia @EU_in_Somalia @WorldBank Absolutely unacceptable amid #Floods affecting local residents, loosing all their assets and livelihoods. There has to be true sense of #accountability at federal level. Govt bureaucracy shldnt come to this level in denying funds to FMSs #SaveFloodprone areas.</td>\n",
              "      <td>absolutely unacceptable amid floods affecting local residents, loosing all their assets and livelihoods. there has to be true sense of accountability at federal level. govt bureaucracy shldnt come to this level in denying funds to fmss savefloodprone areas.</td>\n",
              "      <td>absolutely unacceptable amid floods affecting local residents  loosing all their assets and livelihoods  there has to be true sense of accountability at federal level  govt bureaucracy shldnt come to this level in denying funds to fmss savefloodprone areas</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>World’s biggest tea-growing areas will be among the worst hit by #extremeweather, and their yields are likely to be vastly reduced in the coming decades if #climatebreakdown continues at its current pace. #Floods, #droughts, #heatw… https://t.co/lCWuukDAbS  https://t.co/SUtupViBIu</td>\n",
              "      <td>world’s biggest tea-growing areas will be among the worst hit by extremeweather, and their yields are likely to be vastly reduced in the coming decades if climatebreakdown continues at its current pace. floods, droughts, heatw…</td>\n",
              "      <td>world s biggest tea growing areas will be among the worst hit by extremeweather  and their yields are likely to be vastly reduced in the coming decades if climatebreakdown continues at its current pace  floods  droughts  heatw</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>“It’s not like me to be scared about not being home, but this is just scary and I’m not used to it. I’ve never been in a flood before.”  https://t.co/nh4jCzzOSa via @CBCNorth  #NWT #floods #environment</td>\n",
              "      <td>“it is not like me to be scared about not being home, but this is just scary and I am not used to it. I have never been in a flood before.” via nwt floods environment</td>\n",
              "      <td>it is not like me to be scared about not being home  but this is just scary and I am not used to it  I have never been in a flood before   via nwt floods environment</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>A Survivalist’s Guide to Dealing with Floods  See:  https://t.co/qey7loGc0a  #isrgrajan #TuesdayMotivation #Floods #FloodsinIndia #Storms  https://t.co/qjm8DnXdKf</td>\n",
              "      <td>a survivalist’s guide to dealing with floods see: isrgrajan tuesdaymotivation floods floodsinindia storms</td>\n",
              "      <td>a survivalist s guide to dealing with floods see  isrgrajan tuesdaymotivation floods floodsinindia storms</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>What a storm we’ve just had! #floods Some lightening for a bit of nitrogen!</td>\n",
              "      <td>what a storm we have just had! floods some lightening for a bit of nitrogen!</td>\n",
              "      <td>what a storm we have just had  floods some lightening for a bit of nitrogen</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Opinion piece: What’s worse than a pandemic? A pandemic combined with #drought, natural disaster, violent conflict, and/or structural inequality. We need better ways to tackle these compound risks:  https://t.co/A43W48ds0v #COVID19 #Earthquake #Hurricane #Floods #ClimateChange  https://t.co/XUJXNbllat</td>\n",
              "      <td>opinion piece: what is worse than a pandemic? a pandemic combined with drought, natural disaster, violent conflict, and/or structural inequality. we need better ways to tackle these compound risks: covid19 earthquake hurricane floods climatechange</td>\n",
              "      <td>opinion piece  what is worse than a pandemic  a pandemic combined with drought  natural disaster  violent conflict  and or structural inequality  we need better ways to tackle these compound risks  covid19 earthquake hurricane floods climatechange</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Just in time for hurricane season! We are so grateful to be part of a project that is going to positively impact so many. Great work, team! #flood #floods #flooding #water</td>\n",
              "      <td>just in time for hurricane season! we are so grateful to be part of a project that is going to positively impact so many. great work, team! flood floods flooding water</td>\n",
              "      <td>just in time for hurricane season  we are so grateful to be part of a project that is going to positively impact so many  great work  team  flood floods flooding water</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Listen to our cofounder @escanepa in the new episode of the podcast #PreviewOfTomorrow! He will be talking about #floods and #technology applied. Click on the link:  https://t.co/cSRSAx7nAj #smartcities #innovation</td>\n",
              "      <td>listen to our cofounder in the new episode of the podcast previewoftomorrow! he will be talking about floods and technology applied. click on the link: smartcities innovation</td>\n",
              "      <td>listen to our cofounder in the new episode of the podcast previewoftomorrow  he will be talking about floods and technology applied  click on the link  smartcities innovation</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Did you know, flood damage losses are annually over ONE billion dollars in America every year? Contact our professionals at ESI Waterproofing to ensure you have the best plan in place to prevent water damage.   #Water #Damage #Floods #Boston #Professionals  https://t.co/BsSEeaXatF</td>\n",
              "      <td>did you know, flood damage losses are annually over one billion dollars in america every year? contact our professionals at esi waterproofing to ensure you have the best plan in place to prevent water damage. water damage floods boston professionals</td>\n",
              "      <td>did you know  flood damage losses are annually over one billion dollars in america every year  contact our professionals at esi waterproofing to ensure you have the best plan in place to prevent water damage  water damage floods boston professionals</td>\n",
              "      <td>[america, boston]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>https://t.co/TIUcnjpoYN #Disaster: #Cloud #burst in #Devprayag #Tehri #Garhwal  on May 11, 2021.  #Floods and #Cloud #Burst #Disasters in #Uttrakhand #Hills</td>\n",
              "      <td>disaster: cloud burst in devprayag tehri garhwal on may 11, 2021. floods and cloud burst disasters in uttrakhand hills</td>\n",
              "      <td>disaster  cloud burst in devprayag tehri garhwal on may 11  2021  floods and cloud burst disasters in uttrakhand hills</td>\n",
              "      <td>[uttrakhand]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>#Disaster: #Cloud #burst in #Devprayag #Tehri #Garhwal  on May 11, 2021.  #Floods and #Cloud #Burst #Disasters in #Uttrakhand #Hills</td>\n",
              "      <td>disaster: cloud burst in devprayag tehri garhwal on may 11, 2021. floods and cloud burst disasters in uttrakhand hills</td>\n",
              "      <td>disaster  cloud burst in devprayag tehri garhwal on may 11  2021  floods and cloud burst disasters in uttrakhand hills</td>\n",
              "      <td>[uttrakhand]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>ઉત્તરાખંડ: દેવપ્રયાગમાં વાદળ ફાટતા જળબંબાકાર, તબાહીનો VIDEO જોઈને રુવાંડા ઉભા થઈ જશે  #Uttarakhand  #floods #Uttarakhand #devprayag #cloudburst #disaster #uttarakhandnews    https://t.co/WpcoFB3Pef</td>\n",
              "      <td>ઉત્તરાખંડ: દેવપ્રયાગમાં વાદળ ફાટતા જળબંબાકાર, તબાહીનો video જોઈને રુવાંડા ઉભા થઈ જશે uttarakhand floods uttarakhand devprayag cloudburst disaster uttarakhandnews</td>\n",
              "      <td>video                          uttarakhand floods uttarakhand devprayag cloudburst disaster uttarakhandnews</td>\n",
              "      <td>[uttarakhand]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Several shops and houses have been damaged because of a cloudburst at #Uttarakhand's Devprayag, around 120 kilometres from #Dehradun, news agency ANI has reported. . . #cloudburst #Uttarakhand #Devprayag #shops #houses #damaged #india #water #floods  https://t.co/IEAOPMVPpH</td>\n",
              "      <td>several shops and houses have been damaged because of a cloudburst at uttarakhand's devprayag, around 120 kilometres from dehradun, news agency ani has reported. . . cloudburst uttarakhand devprayag shops houses damaged india water floods</td>\n",
              "      <td>several shops and houses have been damaged because of a cloudburst at uttarakhand s devprayag  around 120 kilometres from dehradun  news agency ani has reported      cloudburst uttarakhand devprayag shops houses damaged india water floods</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>@cmouttarakhand @ndmaindia @NDRFHQ Many structures have suffered significant damage and debris continues to flow down through the slope.   #Uttarakhand  #Cloudburst #floods  https://t.co/48llJ2d3ZS</td>\n",
              "      <td>many structures have suffered significant damage and debris continues to flow down through the slope. uttarakhand cloudburst floods</td>\n",
              "      <td>many structures have suffered significant damage and debris continues to flow down through the slope  uttarakhand cloudburst floods</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Cloudburst and flash #floods reported today evening at Badkot, Devprayag in Uttarkashi  in #Uttarakhand.    Detailed report soon.   Video: By arrangement  @cmouttarakhand @ndmaindia @NDRFHQ  https://t.co/aDtF14s2NU</td>\n",
              "      <td>cloudburst and flash floods reported today evening at badkot, devprayag in uttarkashi in uttarakhand. detailed report soon. video: by arrangement</td>\n",
              "      <td>cloudburst and flash floods reported today evening at badkot  devprayag in uttarkashi in uttarakhand  detailed report soon  video  by arrangement</td>\n",
              "      <td>[uttarakhand]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Floods. Destruction. Displacement. Can the Faculty of Film Studies make a difference? Coming soon. #Floods Driven Displacement &amp;amp; Victim Rehabilitation. TMYS Review Sept 2021 in association with @EHCenterVU Submit #shortstories #essays #poems on the theme.  https://t.co/yEphjmZDgt  https://t.co/0fFTxUTigZ</td>\n",
              "      <td>floods. destruction. displacement. can the faculty of film studies make a difference? coming soon. floods driven displacement &amp;amp; victim rehabilitation. tmys review sept 2021 in association with submit shortstories essays poems on the theme.</td>\n",
              "      <td>floods  destruction  displacement  can the faculty of film studies make a difference  coming soon  floods driven displacement  amp  victim rehabilitation  tmys review sept 2021 in association with submit shortstories essays poems on the theme</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>प्राकृतिक आपदाएं। प्रकृति नियम के सामने मानव असहाय @SonuSood @FcSonuSood @SonuSoodArmy @BJP4UK #naturalcalamaties #floods #india #Monsoon2021</td>\n",
              "      <td>प्राकृतिक आपदाएं। प्रकृति नियम के सामने मानव असहाय naturalcalamaties floods india monsoon2021</td>\n",
              "      <td>naturalcalamaties floods india monsoon2021</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>Video: Anegaciones en vialidades y viviendas, la caída de dos bardas y un árbol fueron los estragos que ocasionaron en #Atizapan de Zaragoza las fuertes #Lluvias  #Lluvias #inundaciones #floods #tormentas #clima #mexico #CDMX #LOULTIMO #noticias  #Urgente  https://t.co/PwtTLhe1cK</td>\n",
              "      <td>video: anegaciones en vialidades y viviendas, la caída de dos bardas y un árbol fueron los estragos que ocasionaron en atizapan de zaragoza las fuertes lluvias lluvias inundaciones floods tormentas clima mexico cdmx loultimo noticias urgente</td>\n",
              "      <td>video  anegaciones en vialidades y viviendas  la ca da de dos bardas y un  rbol fueron los estragos que ocasionaron en atizapan de zaragoza las fuertes lluvias lluvias inundaciones floods tormentas clima mexico cdmx loultimo noticias urgente</td>\n",
              "      <td>[mexico]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Heavy rains cause flooding in Metepec, Toluca Mexico Fuertes lluvias causan inundaciones en Metepec, Toluca México Full video ➤ https://t.co/V0UkmQMmMS  #Mexico #Metepec #hailstorm #floods #toluca #disaster #flooding #rains #floodstoluca Перевести твит  https://t.co/6ortopQZKg</td>\n",
              "      <td>heavy rains because flooding in metepec, toluca mexico fuertes lluvias causan inundaciones en metepec, toluca méxico full video ➤ mexico metepec hailstorm floods toluca disaster flooding rains floodstoluca перевести твит</td>\n",
              "      <td>heavy rains because flooding in metepec  toluca mexico fuertes lluvias causan inundaciones en metepec  toluca m xico full video   mexico metepec hailstorm floods toluca disaster flooding rains floodstoluca</td>\n",
              "      <td>[mexico, mexico]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>#Ambientales Fuertes lluvias provocan inundaciones en #Atizapan y Cuautitlán, #Edomex  #Lluvias #inundaciones #floods #tormentas #clima #mexico #CDMX #LOULTIMO #noticias #Internacional  https://t.co/favHh3Kav5</td>\n",
              "      <td>ambientales fuertes lluvias provocan inundaciones en atizapan y cuautitlán, edomex lluvias inundaciones floods tormentas clima mexico cdmx loultimo noticias internacional</td>\n",
              "      <td>ambientales fuertes lluvias provocan inundaciones en atizapan y cuautitl n  edomex lluvias inundaciones floods tormentas clima mexico cdmx loultimo noticias internacional</td>\n",
              "      <td>[mexico]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>What can we learn from a null result with norm nudges?   New &amp;amp; Open Access in #FirstView   A deep dive into #Nudge failure; lab experiments on household flood preparedness  Open Access in #FirstView  👉  https://t.co/WWediHKVcy   #SocialNorms #PresentBias #floods  https://t.co/7iUSUsKxrR</td>\n",
              "      <td>what can we learn from a null result with norm nudges? new &amp;amp; open access in firstview a deep dive into nudge failure; lab experiments on household flood preparedness open access in firstview 👉 socialnorms presentbias floods</td>\n",
              "      <td>what can we learn from a null result with norm nudges  new  amp  open access in firstview a deep dive into nudge failure  lab experiments on household flood preparedness open access in firstview   socialnorms presentbias floods</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>Pappu Yadav who came with you in the #floods, came during #Chamki and now have extended their hand to help even in the Corona era. But what did the opportunistic people give to Pappu Yadav, why arrest ?   #ReleasePappuYadav  https://t.co/htyPCEUlJv</td>\n",
              "      <td>pappu yadav who came with you in the floods, came during chamki and now have extended their hand to help even in the corona era. but what did the opportunistic people give to pappu yadav, why arrest ? releasepappuyadav</td>\n",
              "      <td>pappu yadav who came with you in the floods  came during chamki and now have extended their hand to help even in the corona era  but what did the opportunistic people give to pappu yadav  why arrest   releasepappuyadav</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>When it #rains in #Nairobi,the CBD to the outskirts of the city centre,flash #floods and stagnant #water have been a constant fixture.The problem has been blamed on outdated designs and continuous dumping of solid #waste in drainage systems.  https://t.co/DSDbMw8aqM</td>\n",
              "      <td>when it rains in nairobi,the cbd to the outskirts of the city centre,flash floods and stagnant water have been a constant fixture.the problem has been blamed on outdated designs and continuous dumping of solid waste in drainage systems.</td>\n",
              "      <td>when it rains in nairobi the cbd to the outskirts of the city centre flash floods and stagnant water have been a constant fixture the problem has been blamed on outdated designs and continuous dumping of solid waste in drainage systems</td>\n",
              "      <td>[nairobi]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>Abdiqani Ibrahim Said and his family of seven have been sleeping rough up a mountain for the past week after their home in Hegale, 150 km from Wader town in Ethiopia’s Somali region, was partly demolished by floods.#ERGO #NewsUpdates #Somalia #floods    https://t.co/vl0WB98bka</td>\n",
              "      <td>abdiqani ibrahim said and his family of seven have been sleeping rough up a mountain for the past week after their home in hegale, 150 km from wader town in ethiopia’s somali region, was partly demolished by floods.ergo newsupdates somalia floods</td>\n",
              "      <td>abdiqani ibrahim said and his family of seven have been sleeping rough up a mountain for the past week after their home in hegale  150 km from wader town in ethiopia s somali region  was partly demolished by floods ergo newsupdates somalia floods</td>\n",
              "      <td>[ethiopia, somalia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>#Floods have displaced hundreds of people in #Somalia and destroyed large areas of farmland. A river burst its banks near the city of #Jowhar which is now on the verge of being submerged. The road between it town and the airport has been cut off.  https://t.co/0kLOV9px9P</td>\n",
              "      <td>floods have displaced hundreds of people in somalia and destroyed large areas of farmland. a river burst its banks near the city of jowhar which is now on the verge of being submerged. the road between it town and the airport has been cut off.</td>\n",
              "      <td>floods have displaced hundreds of people in somalia and destroyed large areas of farmland  a river burst its banks near the city of jowhar which is now on the verge of being submerged  the road between it town and the airport has been cut off</td>\n",
              "      <td>[somalia, jowhar]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>fllood effected ryk a lot, Maiza hameed M.P.A done a great job for relife &amp;amp; rehabilition for local community, well done &amp;amp; keep it up #floods #SouthPunjab #efforts to #rescue people in #cm #shabazsharif #nemories being the only #women #mpa I did my very best  #memoriesforlife  https://t.co/tEc2URnFQx</td>\n",
              "      <td>fllood effected ryk a lot, maiza hameed m.p.a done a great job for relife &amp;amp; rehabilition for local community, well done &amp;amp; keep it up floods southpunjab efforts to rescue people in cm shabazsharif nemories being the only women mpa i did my very best memoriesforlife</td>\n",
              "      <td>fllood effected ryk a lot  maiza hameed m p a done a great job for relife  amp  rehabilition for local community  well done  amp  keep it up floods southpunjab efforts to rescue people in cm shabazsharif nemories being the only women mpa i did my very best memoriesforlife</td>\n",
              "      <td>[fllood, cm]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>#Floods have displaced hundreds of people in #Somalia and destroyed large areas of farmland. A river burst its banks near the city of #Jowhar which is now on the verge of being submerged. The road between it town and the airport has been cut off.  https://t.co/MjIdLkFb7G</td>\n",
              "      <td>floods have displaced hundreds of people in somalia and destroyed large areas of farmland. a river burst its banks near the city of jowhar which is now on the verge of being submerged. the road between it town and the airport has been cut off.</td>\n",
              "      <td>floods have displaced hundreds of people in somalia and destroyed large areas of farmland  a river burst its banks near the city of jowhar which is now on the verge of being submerged  the road between it town and the airport has been cut off</td>\n",
              "      <td>[somalia, jowhar]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>@DelRealFoods #1YearToSaveEarth Hire me for sales+social+mktg to help you switch to plant-based 🌽🥑products only to cool our fun+rad+dying biosphere. #ClimateChange #Monster #Heatwaves #Wildfires #Floods may kill 45% of all life in 5 - 6 yrs.  https://t.co/pLI4iXSAgO #Love #Vegan</td>\n",
              "      <td>1yeartosaveearth hire me for sales+social+mktg to help you switch to plant-based 🌽🥑products only to cool our fun+rad+dying biosphere. climatechange monster heatwaves wildfires floods may kill 45% of all life in 5 - 6 yrs. love vegan</td>\n",
              "      <td>1yeartosaveearth hire me for sales social mktg to help you switch to plant based   products only to cool our fun rad dying biosphere  climatechange monster heatwaves wildfires floods may kill 45  of all life in 5   6 yrs  love vegan</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>@litehousefoods #1YearToSaveEarth Hire me for sales+social+mktg to help you switch to plant-based cheese 🧀 products only to cool our fun+rad+dying biosphere. #ClimateChange #Monster #Heatwaves #Wildfires #Floods may kill 45% of all life in 5 yrs.  https://t.co/pLI4iXSAgO #Vegan</td>\n",
              "      <td>1yeartosaveearth hire me for sales+social+mktg to help you switch to plant-based cheese 🧀 products only to cool our fun+rad+dying biosphere. climatechange monster heatwaves wildfires floods may kill 45% of all life in 5 yrs. vegan</td>\n",
              "      <td>1yeartosaveearth hire me for sales social mktg to help you switch to plant based cheese   products only to cool our fun rad dying biosphere  climatechange monster heatwaves wildfires floods may kill 45  of all life in 5 yrs  vegan</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>@Resers #1YearToSaveEarth Hire me for 🥦sales+social+mktg to help you switch to plant-based products only to cool our fun+rad+dying biosphere. #ClimateChange #Monster #Heatwaves #Wildfires #Floods may kill 45% of all mc life in 5 yrs.  https://t.co/pLI4iXSAgO #Love #Life #Vegan</td>\n",
              "      <td>1yeartosaveearth hire me for 🥦sales+social+mktg to help you switch to plant-based products only to cool our fun+rad+dying biosphere. climatechange monster heatwaves wildfires floods may kill 45% of all mc life in 5 yrs. love life vegan</td>\n",
              "      <td>1yeartosaveearth hire me for  sales social mktg to help you switch to plant based products only to cool our fun rad dying biosphere  climatechange monster heatwaves wildfires floods may kill 45  of all mc life in 5 yrs  love life vegan</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                                                                                                                                                                                                                                                                                                            tweet  ...                 Location Name\n",
              "0                                                                                                                                  Across Africa, at any given time, Red Cross and Red Crescent National Societies are responding to #floods or cyclones with lifesaving actions.  Learn more:  https://t.co/iLiQpJQbOi.  https://t.co/6vhltAOkdE  ...                            []\n",
              "1                                                                                                                                                          Poor drainage in Transami means we have to endure flooding when there is rain in Nairobi. We need to redo the drainage networks in the city. #Nairobi #Floods  https://t.co/FfwBfro0KO  ...  [transami, nairobi, nairobi]\n",
              "2                                        Daily brief:  🌥️ Queen's Speech intensifies #HS2 anxiety  https://t.co/Oqapyv1m9s  🌥️ @networkrail station competition winner revealed  https://t.co/Px3PLn9huQ  🌥️ Flood Action Plan launched  https://t.co/qIWqDlDQQn  #Engineering #CivilEngineering #Rail #Stations #Floods  https://t.co/mQWXqpiq2C  ...                            []\n",
              "3                                                                                                                                                                                               #climate change impacts here already with #drought the #bushfires from August 2019 - March 2020 then #floods we need a plan for #NetZeroEmissions  ...                            []\n",
              "4                                 🧵: This is Thirst in a River Basin, an interactive  #InfoMap 🌍that pinpoints the areas most vulnerable to changing #rainfall and runoff patterns - factors that contribute to #droughts and #floods - and those already facing 💧 #water scarcity in the Nile.  https://t.co/gOZUu08Gxa  https://t.co/uaDstL349p  ...                     [infomap]\n",
              "5                                                                                                                                                                                                       ఉత్తరాఖండ్‌లో వరదలు...  #Kaitvmedia #Keemedia1 #Urvasiott #Keeyoungmantra #Az7amnews #Uttarakhand #Floods #Theri  https://t.co/MpgLkAMm9X  ...                            []\n",
              "6                                       What if we could avoid Fatbergs, #Sewer Blockages, and #Floods? That's what Brian Moloney shares us in this week's #Podcast. 🎧 Fatbergs Right Ahead? Not if you Harvest the Right Data! ▶ Listen to the full episode on your favorite Podcatcher, or on  https://t.co/PaCpbIkwNx  https://t.co/NuVfDwoiTD  ...                            []\n",
              "7                                                              #UPDATE 🇺🇳#UN #Somalia #Geneva #FLOODS Map by @CopernicusEMS  On Tuesday, UN humanitarians said that torrential rains in parts of Somalia caused flash floods, killing at least 25 people just two weeks after the country was declared drought-stricken.  https://t.co/lZH0rKlCaE  ...            [somalia, somalia]\n",
              "8                                                                                                                                                                                                                                                                              @redcrosscanada help !!! @amnesty @HRWatchdog #FortSimpson #floods  ...                            []\n",
              "9                                          Indian and Global #films. How have they depicted #floods and flood #victims? Welcoming Dr. Suchandra Ghatak as a speaker. TMYS Review Sept 2021  Calling for #essays, #stories, #poems on Migration, Resettlement and Displacement of Flood victims.  https://t.co/yEphjmZDgt  https://t.co/QIrjC6B38S  ...                            []\n",
              "10                                                                                                                                                                                                                                                           Fangak appeals for humanitarian aid as #floods engulf areas  https://t.co/8qso0r7YwB  ...                            []\n",
              "11                              #SUPERBOYPROJECT #ANTWONTRINH #GARGANTUAN FOAMS MOLDINGS VIA #PROJECTTSUNAMI &amp; #FLOODS  PREVENTIONS READY; #WINDMILL W/ SOLAR POWER/WATER MILL CHARGER, FLOAT EMPTY BARRIERS _ IN WATER, AND SAME H20/SAND @ INLANDS †  🌊  https://t.co/bSThvaYS2M 💦  🏝️  https://t.co/58wcXtwpFR 🏖️  https://t.co/kHU3ywFeKd  ...                            []\n",
              "12                                    Sharing my new open access article about floods' effect on men's and women's time-use in Pakistan. Findings show men help out more in household work after #floods leading to a decline in #gender #inequality in unpaid work. Data source: @IFPRI PRHPS.  https://t.co/wtgOR5xUtS  https://t.co/kSPZ7R41mr  ...                    [pakistan]\n",
              "13                                                                                                                                                                       Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/HPSPgFf3kQ  ...                            []\n",
              "14                                                                                                                                                                       Tajikistan sinks flash flood in several sectors  https://t.co/nnWZXPcKRT  #Tayikistán #floods #kulob #dushanbe #storm #flooding #Кулоб #Душанбе  https://t.co/sVZyowdxoN  ...                            []\n",
              "15                                                                                                                                                                                                                                                                        Winter storm #FLOODS New England neighborhoods  https://t.co/oN7VFXeA09  ...                            []\n",
              "16                                                                                                                                                                                                                                                                  Winter storm #FLOODS New England neighborhoods  https://t.co/JPoN9QUBJj #GPWX  ...                            []\n",
              "17                                                               There’s a lot to know about the difference between floods and flash floods. Though the endgame is always the same, knowing the difference between the two might be helpful. Read this week’s blog to know more. →  https://t.co/EWsElqtSJF  #Floods #FlashFloods #FloodSolutions  ...                            []\n",
              "18                                           @farmercate2 @LucyThack @samheagney @LiberalAus And just as we have needed help with #drought, #bushfires, #floods (haven't got it but need it!) so too do you need help. And this is a problem which will only get worse without radical, cohesive, concerted help - a plan, systematic eradication  ...                            []\n",
              "19                                   It’s Spring and with #Spring comes, you guessed it, rain! There are 3 types of #floods: river, #flashfloods and surface water, and storm surge.  Determine what type of insurance you have. Speak to your #insurancebroker about water damage insurance.  #flood #insurance #broker  https://t.co/3Wwy19j1o9  ...                            []\n",
              "20  @HShPrez2Ware @ItalyinSomalia @SwedeninSomalia @EU_in_Somalia @WorldBank Absolutely unacceptable amid #Floods affecting local residents, loosing all their assets and livelihoods. There has to be true sense of #accountability at federal level. Govt bureaucracy shldnt come to this level in denying funds to FMSs #SaveFloodprone areas.  ...                            []\n",
              "21                                                      World’s biggest tea-growing areas will be among the worst hit by #extremeweather, and their yields are likely to be vastly reduced in the coming decades if #climatebreakdown continues at its current pace. #Floods, #droughts, #heatw… https://t.co/lCWuukDAbS  https://t.co/SUtupViBIu  ...                            []\n",
              "22                                                                                                                                      “It’s not like me to be scared about not being home, but this is just scary and I’m not used to it. I’ve never been in a flood before.”  https://t.co/nh4jCzzOSa via @CBCNorth  #NWT #floods #environment  ...                            []\n",
              "23                                                                                                                                                                             A Survivalist’s Guide to Dealing with Floods  See:  https://t.co/qey7loGc0a  #isrgrajan #TuesdayMotivation #Floods #FloodsinIndia #Storms  https://t.co/qjm8DnXdKf  ...                            []\n",
              "24                                                                                                                                                                                                                                                                    What a storm we’ve just had! #floods Some lightening for a bit of nitrogen!  ...                            []\n",
              "25                                 Opinion piece: What’s worse than a pandemic? A pandemic combined with #drought, natural disaster, violent conflict, and/or structural inequality. We need better ways to tackle these compound risks:  https://t.co/A43W48ds0v #COVID19 #Earthquake #Hurricane #Floods #ClimateChange  https://t.co/XUJXNbllat  ...                            []\n",
              "26                                                                                                                                                                    Just in time for hurricane season! We are so grateful to be part of a project that is going to positively impact so many. Great work, team! #flood #floods #flooding #water  ...                            []\n",
              "27                                                                                                                         Listen to our cofounder @escanepa in the new episode of the podcast #PreviewOfTomorrow! He will be talking about #floods and #technology applied. Click on the link:  https://t.co/cSRSAx7nAj #smartcities #innovation  ...                            []\n",
              "28                                                      Did you know, flood damage losses are annually over ONE billion dollars in America every year? Contact our professionals at ESI Waterproofing to ensure you have the best plan in place to prevent water damage.   #Water #Damage #Floods #Boston #Professionals  https://t.co/BsSEeaXatF  ...             [america, boston]\n",
              "29                                                                                                                                                                                   https://t.co/TIUcnjpoYN #Disaster: #Cloud #burst in #Devprayag #Tehri #Garhwal  on May 11, 2021.  #Floods and #Cloud #Burst #Disasters in #Uttrakhand #Hills  ...                  [uttrakhand]\n",
              "30                                                                                                                                                                                                           #Disaster: #Cloud #burst in #Devprayag #Tehri #Garhwal  on May 11, 2021.  #Floods and #Cloud #Burst #Disasters in #Uttrakhand #Hills  ...                  [uttrakhand]\n",
              "31                                                                                                                                          ઉત્તરાખંડ: દેવપ્રયાગમાં વાદળ ફાટતા જળબંબાકાર, તબાહીનો VIDEO જોઈને રુવાંડા ઉભા થઈ જશે  #Uttarakhand  #floods #Uttarakhand #devprayag #cloudburst #disaster #uttarakhandnews    https://t.co/WpcoFB3Pef  ...                 [uttarakhand]\n",
              "32                                                             Several shops and houses have been damaged because of a cloudburst at #Uttarakhand's Devprayag, around 120 kilometres from #Dehradun, news agency ANI has reported. . . #cloudburst #Uttarakhand #Devprayag #shops #houses #damaged #india #water #floods  https://t.co/IEAOPMVPpH  ...                       [india]\n",
              "33                                                                                                                                          @cmouttarakhand @ndmaindia @NDRFHQ Many structures have suffered significant damage and debris continues to flow down through the slope.   #Uttarakhand  #Cloudburst #floods  https://t.co/48llJ2d3ZS  ...                            []\n",
              "34                                                                                                                         Cloudburst and flash #floods reported today evening at Badkot, Devprayag in Uttarkashi  in #Uttarakhand.    Detailed report soon.   Video: By arrangement  @cmouttarakhand @ndmaindia @NDRFHQ  https://t.co/aDtF14s2NU  ...                 [uttarakhand]\n",
              "35                          Floods. Destruction. Displacement. Can the Faculty of Film Studies make a difference? Coming soon. #Floods Driven Displacement &amp; Victim Rehabilitation. TMYS Review Sept 2021 in association with @EHCenterVU Submit #shortstories #essays #poems on the theme.  https://t.co/yEphjmZDgt  https://t.co/0fFTxUTigZ  ...                            []\n",
              "36                                                                                                                                                                                                  प्राकृतिक आपदाएं। प्रकृति नियम के सामने मानव असहाय @SonuSood @FcSonuSood @SonuSoodArmy @BJP4UK #naturalcalamaties #floods #india #Monsoon2021  ...                       [india]\n",
              "37                                                       Video: Anegaciones en vialidades y viviendas, la caída de dos bardas y un árbol fueron los estragos que ocasionaron en #Atizapan de Zaragoza las fuertes #Lluvias  #Lluvias #inundaciones #floods #tormentas #clima #mexico #CDMX #LOULTIMO #noticias  #Urgente  https://t.co/PwtTLhe1cK  ...                      [mexico]\n",
              "38                                                          Heavy rains cause flooding in Metepec, Toluca Mexico Fuertes lluvias causan inundaciones en Metepec, Toluca México Full video ➤ https://t.co/V0UkmQMmMS  #Mexico #Metepec #hailstorm #floods #toluca #disaster #flooding #rains #floodstoluca Перевести твит  https://t.co/6ortopQZKg  ...              [mexico, mexico]\n",
              "39                                                                                                                              #Ambientales Fuertes lluvias provocan inundaciones en #Atizapan y Cuautitlán, #Edomex  #Lluvias #inundaciones #floods #tormentas #clima #mexico #CDMX #LOULTIMO #noticias #Internacional  https://t.co/favHh3Kav5  ...                      [mexico]\n",
              "40                                            What can we learn from a null result with norm nudges?   New &amp; Open Access in #FirstView   A deep dive into #Nudge failure; lab experiments on household flood preparedness  Open Access in #FirstView  👉  https://t.co/WWediHKVcy   #SocialNorms #PresentBias #floods  https://t.co/7iUSUsKxrR  ...                            []\n",
              "41                                                                                       Pappu Yadav who came with you in the #floods, came during #Chamki and now have extended their hand to help even in the Corona era. But what did the opportunistic people give to Pappu Yadav, why arrest ?   #ReleasePappuYadav  https://t.co/htyPCEUlJv  ...                            []\n",
              "42                                                                     When it #rains in #Nairobi,the CBD to the outskirts of the city centre,flash #floods and stagnant #water have been a constant fixture.The problem has been blamed on outdated designs and continuous dumping of solid #waste in drainage systems.  https://t.co/DSDbMw8aqM  ...                     [nairobi]\n",
              "43                                                          Abdiqani Ibrahim Said and his family of seven have been sleeping rough up a mountain for the past week after their home in Hegale, 150 km from Wader town in Ethiopia’s Somali region, was partly demolished by floods.#ERGO #NewsUpdates #Somalia #floods    https://t.co/vl0WB98bka  ...           [ethiopia, somalia]\n",
              "44                                                                #Floods have displaced hundreds of people in #Somalia and destroyed large areas of farmland. A river burst its banks near the city of #Jowhar which is now on the verge of being submerged. The road between it town and the airport has been cut off.  https://t.co/0kLOV9px9P  ...             [somalia, jowhar]\n",
              "45                           fllood effected ryk a lot, Maiza hameed M.P.A done a great job for relife &amp; rehabilition for local community, well done &amp; keep it up #floods #SouthPunjab #efforts to #rescue people in #cm #shabazsharif #nemories being the only #women #mpa I did my very best  #memoriesforlife  https://t.co/tEc2URnFQx  ...                  [fllood, cm]\n",
              "46                                                                #Floods have displaced hundreds of people in #Somalia and destroyed large areas of farmland. A river burst its banks near the city of #Jowhar which is now on the verge of being submerged. The road between it town and the airport has been cut off.  https://t.co/MjIdLkFb7G  ...             [somalia, jowhar]\n",
              "47                                                        @DelRealFoods #1YearToSaveEarth Hire me for sales+social+mktg to help you switch to plant-based 🌽🥑products only to cool our fun+rad+dying biosphere. #ClimateChange #Monster #Heatwaves #Wildfires #Floods may kill 45% of all life in 5 - 6 yrs.  https://t.co/pLI4iXSAgO #Love #Vegan  ...                            []\n",
              "48                                                         @litehousefoods #1YearToSaveEarth Hire me for sales+social+mktg to help you switch to plant-based cheese 🧀 products only to cool our fun+rad+dying biosphere. #ClimateChange #Monster #Heatwaves #Wildfires #Floods may kill 45% of all life in 5 yrs.  https://t.co/pLI4iXSAgO #Vegan  ...                            []\n",
              "49                                                          @Resers #1YearToSaveEarth Hire me for 🥦sales+social+mktg to help you switch to plant-based products only to cool our fun+rad+dying biosphere. #ClimateChange #Monster #Heatwaves #Wildfires #Floods may kill 45% of all mc life in 5 yrs.  https://t.co/pLI4iXSAgO #Love #Life #Vegan  ...                            []\n",
              "\n",
              "[50 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    }
  ]
}