sentiment_analysis_notebook_1.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyMpTEb61Lj8mo4AxhwUR972",
      "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/miraytopal/Turkey-Earthquake-Tweets-Sentiment-Analysis/blob/main/sentiment_analysis_notebook_1.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "###Importing Libraries"
      ],
      "metadata": {
        "id": "-shN1X_34mIH"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "FtKzgc6saUFR",
        "outputId": "46ba8a7d-b08e-4952-cb5d-b5c9872c50c0"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting transformers\n",
            "  Downloading transformers-4.28.1-py3-none-any.whl (7.0 MB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m7.0/7.0 MB\u001b[0m \u001b[31m44.1 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: filelock in /usr/local/lib/python3.9/dist-packages (from transformers) (3.11.0)\n",
            "Collecting huggingface-hub<1.0,>=0.11.0\n",
            "  Downloading huggingface_hub-0.13.4-py3-none-any.whl (200 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m200.1/200.1 kB\u001b[0m \u001b[31m23.2 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: requests in /usr/local/lib/python3.9/dist-packages (from transformers) (2.27.1)\n",
            "Collecting tokenizers!=0.11.3,<0.14,>=0.11.1\n",
            "  Downloading tokenizers-0.13.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (7.8 MB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m7.8/7.8 MB\u001b[0m \u001b[31m52.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hRequirement already satisfied: pyyaml>=5.1 in /usr/local/lib/python3.9/dist-packages (from transformers) (6.0)\n",
            "Requirement already satisfied: regex!=2019.12.17 in /usr/local/lib/python3.9/dist-packages (from transformers) (2022.10.31)\n",
            "Requirement already satisfied: tqdm>=4.27 in /usr/local/lib/python3.9/dist-packages (from transformers) (4.65.0)\n",
            "Requirement already satisfied: numpy>=1.17 in /usr/local/lib/python3.9/dist-packages (from transformers) (1.22.4)\n",
            "Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.9/dist-packages (from transformers) (23.0)\n",
            "Requirement already satisfied: typing-extensions>=3.7.4.3 in /usr/local/lib/python3.9/dist-packages (from huggingface-hub<1.0,>=0.11.0->transformers) (4.5.0)\n",
            "Requirement already satisfied: charset-normalizer~=2.0.0 in /usr/local/lib/python3.9/dist-packages (from requests->transformers) (2.0.12)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.9/dist-packages (from requests->transformers) (3.4)\n",
            "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /usr/local/lib/python3.9/dist-packages (from requests->transformers) (1.26.15)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.9/dist-packages (from requests->transformers) (2022.12.7)\n",
            "Installing collected packages: tokenizers, huggingface-hub, transformers\n",
            "Successfully installed huggingface-hub-0.13.4 tokenizers-0.13.3 transformers-4.28.1\n",
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting emoji\n",
            "  Downloading emoji-2.2.0.tar.gz (240 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m240.9/240.9 kB\u001b[0m \u001b[31m9.7 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25h  Preparing metadata (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "Building wheels for collected packages: emoji\n",
            "  Building wheel for emoji (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for emoji: filename=emoji-2.2.0-py3-none-any.whl size=234926 sha256=0637de297bb51b9e7bff73d16ffd41829efc40c55f7034cb442571f544e02a1d\n",
            "  Stored in directory: /root/.cache/pip/wheels/9a/b8/0f/f580817231cbf59f6ade9fd132ff60ada1de9f7dc85521f857\n",
            "Successfully built emoji\n",
            "Installing collected packages: emoji\n",
            "Successfully installed emoji-2.2.0\n",
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting sentencepiece\n",
            "  Downloading sentencepiece-0.1.98-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.3 MB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m1.3/1.3 MB\u001b[0m \u001b[31m28.7 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hInstalling collected packages: sentencepiece\n",
            "Successfully installed sentencepiece-0.1.98\n",
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Requirement already satisfied: nltk in /usr/local/lib/python3.9/dist-packages (3.8.1)\n",
            "Requirement already satisfied: tqdm in /usr/local/lib/python3.9/dist-packages (from nltk) (4.65.0)\n",
            "Requirement already satisfied: click in /usr/local/lib/python3.9/dist-packages (from nltk) (8.1.3)\n",
            "Requirement already satisfied: regex>=2021.8.3 in /usr/local/lib/python3.9/dist-packages (from nltk) (2022.10.31)\n",
            "Requirement already satisfied: joblib in /usr/local/lib/python3.9/dist-packages (from nltk) (1.2.0)\n",
            "Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n",
            "Collecting emot==3.1\n",
            "  Downloading emot-3.1-py3-none-any.whl (61 kB)\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m61.5/61.5 kB\u001b[0m \u001b[31m3.3 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hInstalling collected packages: emot\n",
            "Successfully installed emot-3.1\n"
          ]
        }
      ],
      "source": [
        "!pip install transformers\n",
        "!pip install emoji\n",
        "!pip install sentencepiece\n",
        "!pip install nltk\n",
        "!pip install emot==3.1"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "p2LkEgx4MKNj",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "d11816ba-7583-4f64-b705-c0052295144f"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "[nltk_data] Downloading package punkt to /root/nltk_data...\n",
            "[nltk_data]   Unzipping tokenizers/punkt.zip.\n"
          ]
        }
      ],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "\n",
        "# visualization\n",
        "import matplotlib\n",
        "import seaborn as sns\n",
        "import matplotlib.pyplot as plt\n",
        "%matplotlib inline \n",
        "\n",
        "from wordcloud import WordCloud, STOPWORDS, ImageColorGenerator\n",
        "from sklearn.decomposition import LatentDirichletAllocation\n",
        "from collections import Counter\n",
        "from nltk.sentiment import SentimentIntensityAnalyzer\n",
        "from textblob import TextBlob\n",
        "\n",
        "import warnings\n",
        "warnings.filterwarnings(\"ignore\")\n",
        "warnings.simplefilter(action='ignore', category=FutureWarning)\n",
        "\n",
        "pd.set_option('display.max_columns', None)\n",
        "pd.options.display.float_format = '{:.4f}'.format\n",
        "\n",
        "import io\n",
        "from datetime import timedelta\n",
        "\n",
        "# nltk\n",
        "import nltk\n",
        "from nltk.corpus import stopwords\n",
        "from  nltk.stem import SnowballStemmer\n",
        "nltk.download('punkt')\n",
        "from nltk.tokenize import word_tokenize\n",
        "from nltk.probability import FreqDist\n",
        "\n",
        "from transformers import AutoModelForSequenceClassification, AutoTokenizer, pipeline\n",
        "import re\n",
        "import emoji\n",
        "from tqdm.notebook import tqdm\n",
        "tqdm.pandas()"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "###Loading Data"
      ],
      "metadata": {
        "id": "BgCBEKe-4roE"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "CSufslWrRh3N"
      },
      "outputs": [],
      "source": [
        "path = '/content/tweets.csv'\n",
        "df = pd.read_csv(path)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 458
        },
        "id": "GRRd4sm5RohT",
        "outputId": "517f3217-8736-42d5-d080-ecd2bd3a28a8"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                        date  \\\n",
              "0  2023-02-21 03:30:04+00:00   \n",
              "1  2023-02-21 03:29:07+00:00   \n",
              "2  2023-02-21 03:29:04+00:00   \n",
              "3  2023-02-21 03:28:06+00:00   \n",
              "4  2023-02-21 03:27:38+00:00   \n",
              "\n",
              "                                             content  \\\n",
              "0  तुर्की में सोमवार देर रात भूंकप के तेज झटके मह...   \n",
              "1  New search &amp; rescue work is in progress in...   \n",
              "2  Can't imagine those who still haven't recovere...   \n",
              "3  its a highkey sign for all of us to ponder ove...   \n",
              "4  Turkiye Earthquake: तुर्किए में फिर आया भूकंप ...   \n",
              "\n",
              "                                            hashtags  like_count  rt_count  \\\n",
              "0  ['ATDigital', 'Turkey', 'Earthquake', 'TurkeyE...      0.0000    0.0000   \n",
              "1  ['Hatay', 'earthquakes', 'Türkiye', 'TurkiyeQu...      1.0000    0.0000   \n",
              "2  ['Turkey', 'earthquake', 'turkeyearthquake2023...      0.0000    0.0000   \n",
              "3    ['turkeyearthquake2023', 'earthquake', 'Syria']      0.0000    0.0000   \n",
              "4  ['turkey', 'earthquake', 'turkiye', 'india', '...      0.0000    0.0000   \n",
              "\n",
              "   followers_count isVerified language coordinates place                source  \n",
              "0    19727712.0000       True       hi         NaN   NaN  Twitter Media Studio  \n",
              "1        5697.0000       True       en         NaN   NaN       Twitter Web App  \n",
              "2           1.0000      False       en         NaN   NaN   Twitter for Android  \n",
              "3           3.0000      False       en         NaN   NaN   Twitter for Android  \n",
              "4          17.0000      False      und         NaN   NaN   Twitter for Android  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-aada41d5-e081-4db2-8d47-011d219fd789\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>date</th>\n",
              "      <th>content</th>\n",
              "      <th>hashtags</th>\n",
              "      <th>like_count</th>\n",
              "      <th>rt_count</th>\n",
              "      <th>followers_count</th>\n",
              "      <th>isVerified</th>\n",
              "      <th>language</th>\n",
              "      <th>coordinates</th>\n",
              "      <th>place</th>\n",
              "      <th>source</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2023-02-21 03:30:04+00:00</td>\n",
              "      <td>तुर्की में सोमवार देर रात भूंकप के तेज झटके मह...</td>\n",
              "      <td>['ATDigital', 'Turkey', 'Earthquake', 'TurkeyE...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>19727712.0000</td>\n",
              "      <td>True</td>\n",
              "      <td>hi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter Media Studio</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2023-02-21 03:29:07+00:00</td>\n",
              "      <td>New search &amp;amp; rescue work is in progress in...</td>\n",
              "      <td>['Hatay', 'earthquakes', 'Türkiye', 'TurkiyeQu...</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>5697.0000</td>\n",
              "      <td>True</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter Web App</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2023-02-21 03:29:04+00:00</td>\n",
              "      <td>Can't imagine those who still haven't recovere...</td>\n",
              "      <td>['Turkey', 'earthquake', 'turkeyearthquake2023...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2023-02-21 03:28:06+00:00</td>\n",
              "      <td>its a highkey sign for all of us to ponder ove...</td>\n",
              "      <td>['turkeyearthquake2023', 'earthquake', 'Syria']</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>3.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2023-02-21 03:27:38+00:00</td>\n",
              "      <td>Turkiye Earthquake: तुर्किए में फिर आया भूकंप ...</td>\n",
              "      <td>['turkey', 'earthquake', 'turkiye', 'india', '...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>17.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>und</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-aada41d5-e081-4db2-8d47-011d219fd789')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-aada41d5-e081-4db2-8d47-011d219fd789 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-aada41d5-e081-4db2-8d47-011d219fd789');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ],
      "source": [
        "df.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Data Exploration"
      ],
      "metadata": {
        "id": "0kUylNEb8cGf"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pwL5IY9LRuJg",
        "outputId": "66b131ee-ff0f-4670-9797-405c811d2aa3"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Dataset size : (445248, 11)\n",
            "# -------------------------------------------- # \n",
            "\n",
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 445248 entries, 0 to 445247\n",
            "Data columns (total 11 columns):\n",
            " #   Column           Non-Null Count   Dtype  \n",
            "---  ------           --------------   -----  \n",
            " 0   date             445248 non-null  object \n",
            " 1   content          445248 non-null  object \n",
            " 2   hashtags         445229 non-null  object \n",
            " 3   like_count       445230 non-null  float64\n",
            " 4   rt_count         445230 non-null  float64\n",
            " 5   followers_count  445230 non-null  float64\n",
            " 6   isVerified       445230 non-null  object \n",
            " 7   language         445230 non-null  object \n",
            " 8   coordinates      19191 non-null   object \n",
            " 9   place            18737 non-null   object \n",
            " 10  source           445230 non-null  object \n",
            "dtypes: float64(3), object(8)\n",
            "memory usage: 37.4+ MB\n",
            "Shape : None\n",
            "# -------------------------------------------- # \n",
            "\n",
            "Shape :        like_count    rt_count  followers_count\n",
            "count 445230.0000 445230.0000      445230.0000\n",
            "mean      16.8849      6.1607       55181.4513\n",
            "std      382.9287     82.2906      632980.9489\n",
            "min        0.0000      0.0000           0.0000\n",
            "25%        0.0000      0.0000          50.0000\n",
            "50%        1.0000      0.0000         310.0000\n",
            "75%        3.0000      2.0000        1925.0000\n",
            "max   146023.0000  17153.0000    25755087.0000\n",
            "# -------------------------------------------- # \n",
            "\n",
            "Memory usage :  37.4+ MB\n",
            "# -------------------------------------------- # \n",
            "\n"
          ]
        }
      ],
      "source": [
        "def info(dataframe):\n",
        "    print('Dataset size :', df.shape)\n",
        "    print(\"# -------------------------------------------- #\", \"\\n\")\n",
        "    print('Shape :', df.info())\n",
        "    print(\"# -------------------------------------------- #\", \"\\n\")\n",
        "    print('Shape :', df.describe())\n",
        "    print(\"# -------------------------------------------- #\", \"\\n\")\n",
        "    buf = io.StringIO()\n",
        "    pd.read_csv(path).info(buf=buf)\n",
        "    info = buf.getvalue().split('\\n')[-2].split(\":\")[1].strip()\n",
        "    print('Memory usage : ', info)\n",
        "    print(\"# -------------------------------------------- #\", \"\\n\")\n",
        "\n",
        "info(df)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xWbdMtUqttUZ",
        "outputId": "85893dcc-24b8-4791-a4b4-2f577623338d"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "en     173361\n",
              "tr     134589\n",
              "qme     36983\n",
              "ar      16080\n",
              "qht     12495\n",
              "Name: language, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ],
      "source": [
        "# Let's take a look at the most used languages\n",
        "df_language = df['language'].value_counts()\n",
        "df_language[:5]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1Ia2Xrvj1enl",
        "outputId": "09ddf364-3adf-4913-bc80-703474bf0834"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Twitter for Android    205586\n",
              "Twitter for iPhone     119452\n",
              "Twitter Web App         77576\n",
              "TweetDeck                5311\n",
              "emsc-csem                3755\n",
              "Name: source, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ],
      "source": [
        "# Most used sources for tweeting\n",
        "df['source'].value_counts().head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 406
        },
        "id": "U5BgMYmyR1LA",
        "outputId": "eae5ae7c-9db0-4c75-c23f-38fc412d02fe"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         date                                            content  \\\n",
              "0  2023-02-21  तुर्की में सोमवार देर रात भूंकप के तेज झटके मह...   \n",
              "1  2023-02-21  New search &amp; rescue work is in progress in...   \n",
              "2  2023-02-21  Can't imagine those who still haven't recovere...   \n",
              "3  2023-02-21  its a highkey sign for all of us to ponder ove...   \n",
              "4  2023-02-21  Turkiye Earthquake: तुर्किए में फिर आया भूकंप ...   \n",
              "\n",
              "                                            hashtags  like_count  rt_count  \\\n",
              "0  ['ATDigital', 'Turkey', 'Earthquake', 'TurkeyE...      0.0000    0.0000   \n",
              "1  ['Hatay', 'earthquakes', 'Türkiye', 'TurkiyeQu...      1.0000    0.0000   \n",
              "2  ['Turkey', 'earthquake', 'turkeyearthquake2023...      0.0000    0.0000   \n",
              "3    ['turkeyearthquake2023', 'earthquake', 'Syria']      0.0000    0.0000   \n",
              "4  ['turkey', 'earthquake', 'turkiye', 'india', '...      0.0000    0.0000   \n",
              "\n",
              "   followers_count isVerified language coordinates place                source  \n",
              "0    19727712.0000       True       hi         NaN   NaN  Twitter Media Studio  \n",
              "1        5697.0000       True       en         NaN   NaN       Twitter Web App  \n",
              "2           1.0000      False       en         NaN   NaN   Twitter for Android  \n",
              "3           3.0000      False       en         NaN   NaN   Twitter for Android  \n",
              "4          17.0000      False      und         NaN   NaN   Twitter for Android  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bc766e41-4587-4007-a909-cf5dbe3a482d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>date</th>\n",
              "      <th>content</th>\n",
              "      <th>hashtags</th>\n",
              "      <th>like_count</th>\n",
              "      <th>rt_count</th>\n",
              "      <th>followers_count</th>\n",
              "      <th>isVerified</th>\n",
              "      <th>language</th>\n",
              "      <th>coordinates</th>\n",
              "      <th>place</th>\n",
              "      <th>source</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>तुर्की में सोमवार देर रात भूंकप के तेज झटके मह...</td>\n",
              "      <td>['ATDigital', 'Turkey', 'Earthquake', 'TurkeyE...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>19727712.0000</td>\n",
              "      <td>True</td>\n",
              "      <td>hi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter Media Studio</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>New search &amp;amp; rescue work is in progress in...</td>\n",
              "      <td>['Hatay', 'earthquakes', 'Türkiye', 'TurkiyeQu...</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>5697.0000</td>\n",
              "      <td>True</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter Web App</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>Can't imagine those who still haven't recovere...</td>\n",
              "      <td>['Turkey', 'earthquake', 'turkeyearthquake2023...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>its a highkey sign for all of us to ponder ove...</td>\n",
              "      <td>['turkeyearthquake2023', 'earthquake', 'Syria']</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>3.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>Turkiye Earthquake: तुर्किए में फिर आया भूकंप ...</td>\n",
              "      <td>['turkey', 'earthquake', 'turkiye', 'india', '...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>17.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>und</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bc766e41-4587-4007-a909-cf5dbe3a482d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bc766e41-4587-4007-a909-cf5dbe3a482d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bc766e41-4587-4007-a909-cf5dbe3a482d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ],
      "source": [
        "df['date'] = pd.to_datetime(df['date'])\n",
        "df['date'] = df['date'].dt.date\n",
        "df.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 445
        },
        "id": "IbuUbhpHR6Vi",
        "outputId": "650a99ab-8285-4618-b7ca-27c079f1cd89"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 1000x500 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA14AAAGsCAYAAADNHXbJAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAABbb0lEQVR4nO3deVyVZf7/8fc57NsBUQFRRMtyH3eRFpsmJlKnGZvmm9uklWk1Wppt+qvMmiYb29Q2syytyTKbcspcIsusJBVcQVEzdzugIhxAWc/9+wM5clREFLxZXs/H4zyA+7rOdX/uq8Le3te5bothGIYAAAAAADXGanYBAAAAAFDfEbwAAAAAoIYRvAAAAACghhG8AAAAAKCGEbwAAAAAoIYRvAAAAACghhG8AAAAAKCGeZpdQG3mdDp16NAhBQUFyWKxmF0OAAAAAJMYhqGcnBxFRkbKaq36/SuC1zkcOnRIUVFRZpcBAAAAoJbYv3+/WrRoUeX3EbzOISgoSFLp5NpsNpOrAQAAAGAWh8OhqKgoV0aoKoLXOZQtL7TZbAQvAAAAABf8ESQ21wAAAACAGkbwAgAAAIAaRvACAAAAgBpG8AIAAACAGkbwAgAAAIAaRvACAAAAgBpG8AIAAACAGkbwAgAAAIAaRvACAAAAgBpG8AIAAACAGkbwAgAAAIAaRvACAAAAgBpG8AIAAACAGkbwqiOcTkPv/PCrThSWmF0KAAAAgCoieNURzyzeqme/2qaR89bpeGGx2eUAAAAAqAKCVx0x4HfNFODtodW7juquueuUV0D4AgAAAOqKKgevVatW6eabb1ZkZKQsFosWLVpUYd97771XFotF06dPdzuemZmpYcOGyWazKSQkRCNHjlRubq5bn82bN+vaa6+Vr6+voqKiNG3atDPGX7hwodq1aydfX1917txZS5YscWs3DEOTJ09Ws2bN5Ofnp7i4OO3cubOql1wr9GoVqvdH9lagj6d+/jVTd763TrmELwAAAKBOqHLwysvLU5cuXfT666+fs9/nn3+un3/+WZGRkWe0DRs2TKmpqUpISNDixYu1atUqjR492tXucDh04403Kjo6WsnJyXrhhRc0ZcoUzZ4929Vn9erVGjJkiEaOHKkNGzZo4MCBGjhwoFJSUlx9pk2bppkzZ2rWrFlas2aNAgICFB8fr/z8/Kpedq3QIzpUH4zsrSAfT63dk6k73l2rnPwis8sCAAAAUAmLYRjGBb/ZYtHnn3+ugQMHuh0/ePCgYmJitHz5cg0YMEDjx4/X+PHjJUnbtm1Thw4dtG7dOvXs2VOStGzZMvXv318HDhxQZGSk3nzzTT3++OOy2+3y9vaWJE2cOFGLFi1SWlqaJGnQoEHKy8vT4sWLXeft06ePunbtqlmzZskwDEVGRuqhhx7Sww8/LEnKzs5WeHi45s6dq8GDB1d6fQ6HQ8HBwcrOzpbNZrvQaap2m/Zn6fY5a+TIL1a3liGad1dv2Xy9zC4LAAAAqLcuNhtU+2e8nE6nbr/9dj3yyCPq2LHjGe2JiYkKCQlxhS5JiouLk9Vq1Zo1a1x9+vbt6wpdkhQfH6/t27fr2LFjrj5xcXFuY8fHxysxMVGStHv3btntdrc+wcHBiomJcfU5XUFBgRwOh9urNuoSFaIP7+6jYD8vbdiXpdvnrFX2Ce58AQAAALVVtQevf//73/L09NQDDzxw1na73a6wsDC3Y56engoNDZXdbnf1CQ8Pd+tT9nNlfcq3l3/f2fqcburUqQoODna9oqKiKr1es3RuEawP745RiL+X6w5Y9nHCFwAAAFAbVWvwSk5O1owZMzR37lxZLJbqHPqSmDRpkrKzs12v/fv3m13SOXVqHqz5d/dRI38vbT6QrWFzflbW8UKzywIAAABwmmoNXj/88IMyMjLUsmVLeXp6ytPTU3v37tVDDz2kVq1aSZIiIiKUkZHh9r7i4mJlZmYqIiLC1Sc9Pd2tT9nPlfUp317+fWfrczofHx/ZbDa3V23XIdKmj0b3UeMAb6UcdGjo22uUmUf4AgAAAGqTag1et99+uzZv3qyNGze6XpGRkXrkkUe0fPlySVJsbKyysrKUnJzset+3334rp9OpmJgYV59Vq1apqOjU0rmEhAS1bdtWjRo1cvVZsWKF2/kTEhIUGxsrSWrdurUiIiLc+jgcDq1Zs8bVp75oF1EavpoEemvrbw4NfftnHc0tMLssAAAAACdVOXjl5ua6QpVUuonFxo0btW/fPjVu3FidOnVye3l5eSkiIkJt27aVJLVv31433XSTRo0apbVr1+qnn37S2LFjNXjwYNfW80OHDpW3t7dGjhyp1NRULViwQDNmzNCECRNcdYwbN07Lli3TSy+9pLS0NE2ZMkVJSUkaO3aspNIdF8ePH69nn31WX3zxhbZs2aLhw4crMjLyjF0Y64Mrw4P08eg+ahrkozR7joa8/bMO5xC+AAAAgNqgysErKSlJ3bp1U7du3SRJEyZMULdu3TR58uTzHuPDDz9Uu3btdMMNN6h///665ppr3J7RFRwcrK+//lq7d+9Wjx499NBDD2ny5Mluz/q66qqrNH/+fM2ePVtdunTRp59+qkWLFqlTp06uPo8++qjuv/9+jR49Wr169VJubq6WLVsmX1/fql52ndAmrDR8hQX5aEd6roa8/bMycurmM8sAAACA+uSinuNV39XW53hVZveRPA2Z/bPsjnxd1jRAH43qo3Bb/QybAAAAwKVQ657jBfO1bhKgBff0UWSwr349nKfBs3+WPZs7XwAAAIBZCF71VHTjAC24J1bNQ/y0+0ieBs1O1KGsE2aXBQAAADRIBK96LCrUXx+P7qMWjfy09+hxDZ79sw4SvgAAAIBLjuBVz0WF+mvBPbFqGeqvfZnHNeitRO3PPG52WQAAAECDQvBqAJqH+Onj0X3UqrG/Dhw7ocGzf9a+o4QvAAAA4FIheDUQkSF++nh0rC5rEqCDWSc0eHai9h7NM7ssAAAAoEEgeDUgEcG++nh0H13eNECHsvM16K2ftfsI4QsAAACoaQSvBibM5quPRvfRFWGBsjvyNeitRO06nGt2WQAAAEC9RvBqgMKCSsNX2/AgZeQUaPDsn/VLRo7ZZQEAAAD1FsGrgWoS6KP5o2LULiJIh0+Grx3phC8AAACgJhC8GrDGgT6aP6qPOjSz6UhuoYbM/llpdofZZQEAAAD1DsGrgQsN8Nb8UTHq1Nymo3mFGvr2Gm09RPgCAAAAqhPBCwrx99aHI/vody2ClZlXqKHv/KyUg9lmlwUAAADUGwQvSJKC/b30wcgYdY0KUdbxIg17Z422HCB8AQAAANWB4AWXYD8vvT+yt7q1DFH2iSINfednbdqfZXZZAAAAQJ1H8IIbm6+X3r+rt3pGN1JOfrH+/s4ard93zOyyAAAAgDqN4IUzBPl6ae5dvdW7VahyCoo1fM5aJe/NNLssAAAAoM4ieOGsAn08NfeuXupzWahyT4avdXsIXwAAAMCFIHihQv7ennrvjt666vLGyiss0Yh312rNr0fNLgsAAACocwheOCc/bw/NGdFL117RRMcLS3THe+uUuIvwBQAAAFQFwQuV8vP20NvDe6rvlU11oqhEd85dq59+OWJ2WQAAAECdQfDCefH18tDs23vo+rZNlV/k1F1z12nVjsNmlwUAAADUCQQvnDdfLw/Nur2H4tqHqaDYqbvfT9LK7RlmlwUAAADUegQvVImPp4feGNZDf+wQrsJip0a/n6xv09LNLgsAAACo1QheqDJvT6veGNZdN3WMUGGJU/d8kKxvthK+AAAAgIoQvHBBvDysenVoNw3o3ExFJYbu+zBZy1PtZpcFAAAA1EoEL1wwLw+rZgzuqpu7RKqoxNCYD9dr6ZbfzC4LAAAAqHUIXrgonh5WvXJbF/2la6SKnYbGfrRBizcfMrssAAAAoFYheOGieXpY9fJtXfXXbs1V4jQ07uON+mIT4QsAAAAoQ/BCtfCwWvTC/3XR33q0UInT0PiPN2jRhoNmlwUAAADUCgQvVBsPq0XTbv2dBveKktOQHvxko/6bfMDssgAAAADTEbxQraxWi567pbOGxrSUYUgPf7pJnyTtN7ssAAAAwFQEL1Q7q9WiZ//SSbf3iZZhSI9+ulkfr91ndlkAAACAaQheqBFWq0XP/KWj7riqlSRp4mdb2GoeAAAADRbBCzXGYrHoqZs7aFhMS0nSuz/tNrkiAAAAwBwEL9Qoi8WisX9oI0lK2ntM6Y58kysCAAAALj2CF2pcs2A/dW8ZIsOQlqXYzS4HAAAAuOQIXrgk+nduJklawue8AAAA0AARvHBJ3NQpQpK0dk+mDucUmFwNAAAAcGlVOXitWrVKN998syIjI2WxWLRo0SJXW1FRkR577DF17txZAQEBioyM1PDhw3Xo0CG3MTIzMzVs2DDZbDaFhIRo5MiRys3NdeuzefNmXXvttfL19VVUVJSmTZt2Ri0LFy5Uu3bt5Ovrq86dO2vJkiVu7YZhaPLkyWrWrJn8/PwUFxennTt3VvWSUQ1aNPJXlxbBMgxpeSrLDQEAANCwVDl45eXlqUuXLnr99dfPaDt+/LjWr1+vJ598UuvXr9dnn32m7du3689//rNbv2HDhik1NVUJCQlavHixVq1apdGjR7vaHQ6HbrzxRkVHRys5OVkvvPCCpkyZotmzZ7v6rF69WkOGDNHIkSO1YcMGDRw4UAMHDlRKSoqrz7Rp0zRz5kzNmjVLa9asUUBAgOLj45WfzwYPZuh3crnh0hSWGwIAAKBhsRiGYVzwmy0Wff755xo4cGCFfdatW6fevXtr7969atmypbZt26YOHTpo3bp16tmzpyRp2bJl6t+/vw4cOKDIyEi9+eabevzxx2W32+Xt7S1JmjhxohYtWqS0tDRJ0qBBg5SXl6fFixe7ztWnTx917dpVs2bNkmEYioyM1EMPPaSHH35YkpSdna3w8HDNnTtXgwcPrvT6HA6HgoODlZ2dLZvNdqHThJP2HT2uvi98Jw+rRWv/3w1qHOhjdkkAAADAebnYbFDjn/HKzs6WxWJRSEiIJCkxMVEhISGu0CVJcXFxslqtWrNmjatP3759XaFLkuLj47V9+3YdO3bM1ScuLs7tXPHx8UpMTJQk7d69W3a73a1PcHCwYmJiXH1OV1BQIIfD4fZC9WnZ2F+dmttU4jSUsDXd7HIAAACAS6ZGg1d+fr4ee+wxDRkyxJUK7Xa7wsLC3Pp5enoqNDRUdrvd1Sc8PNytT9nPlfUp317+fWfrc7qpU6cqODjY9YqKiqryNePc+nU6ubsh28oDAACgAamx4FVUVKTbbrtNhmHozTffrKnTVKtJkyYpOzvb9dq/f7/ZJdU7/U7ubrj6lyPKOl5ocjUAAADApVEjwassdO3du1cJCQluayAjIiKUkZHh1r+4uFiZmZmKiIhw9UlPd1+KVvZzZX3Kt5d/39n6nM7Hx0c2m83thep1WdNAtYsIUrHT0NcsNwQAAEADUe3Bqyx07dy5U998840aN27s1h4bG6usrCwlJye7jn377bdyOp2KiYlx9Vm1apWKiopcfRISEtS2bVs1atTI1WfFihVuYyckJCg2NlaS1Lp1a0VERLj1cTgcWrNmjasPzFH2MOWlPEwZAAAADUSVg1dubq42btyojRs3SirdxGLjxo3at2+fioqK9Le//U1JSUn68MMPVVJSIrvdLrvdrsLC0mVl7du310033aRRo0Zp7dq1+umnnzR27FgNHjxYkZGRkqShQ4fK29tbI0eOVGpqqhYsWKAZM2ZowoQJrjrGjRunZcuW6aWXXlJaWpqmTJmipKQkjR07VlLpjovjx4/Xs88+qy+++EJbtmzR8OHDFRkZec5dGFHz+ncuveP44y9HlH2iqJLeAAAAQD1gVNF3331nSDrjNWLECGP37t1nbZNkfPfdd64xjh49agwZMsQIDAw0bDabceeddxo5OTlu59m0aZNxzTXXGD4+Pkbz5s2N559//oxaPvnkE+PKK680vL29jY4dOxpfffWVW7vT6TSefPJJIzw83PDx8TFuuOEGY/v27ed9rdnZ2YYkIzs7u2qThErFvbTSiH5ssfHf5P1mlwIAAABU6mKzwUU9x6u+4zleNeflhB2auWKn4tqH650RPSt/AwAAAGCiWv8cL+BsypYbrtp5WDn5LDcEAABA/UbwginahgfpsqYBKix26tu0jMrfAAAAANRhBC+YwmKxqH+nst0NeZgyAAAA6jeCF0zT7+Ryw++2ZyivoNjkagAAAICaQ/CCaTo0sym6sb8Kip36bjvLDQEAAFB/EbxgGovFon4sNwQAAEADQPCCqcp2N/w2LUMnCktMrgYAAACoGQQvmKpz82A1D/HTiaISfb+D5YYAAAConwheMJXFYnHd9VrCckMAAADUUwQvmK5f59LPea3Ylq78IpYbAgAAoP4heMF03aJCFBnsq7zCEv2w84jZ5QAAAADVjuAF01ksFt3k2t3wN5OrAQAAAKofwQu1QtnnvBK2paugmOWGAAAAqF8IXqgVurdspLAgH+XkF+unX1huCAAAgPqF4IVawWq1qF8ndjcEAABA/UTwQq1Rtrvh16l2FRY7Ta4GAAAAqD4EL9QavVqFqkmgtxz5xUr89ajZ5QAAAADVhuCFWsPDalF8x9LlhuxuCAAAgPqE4IVapf/J5YbLU+0qLmG5IQAAAOoHghdqlZjWoQoN8Nax40VaszvT7HIAAACAakHwQq3i6WFVfMdwSdISlhsCAACgniB4odbp1+nUcsMSp2FyNQAAAMDFI3ih1om9vLGC/bx0JLdQa1luCAAAgHqA4IVax8vDqhs7lC43XJrCckMAAADUfQQv1EpluxsuTbHLyXJDAAAA1HEEL9RKV7VprCBfTx3OKVDyvmNmlwMAAABcFIIXaiUfTw/9sT27GwIAAKB+IHih1up3crnhMpYbAgAAoI4jeKHWuvaKJgr08dRv2fnaeCDL7HIAAACAC0bwQq3l6+WhG9qHSZKWstwQAAAAdRjBC7Va2cOUl2yxyzBYbggAAIC6ieCFWu33bZvK39tDB7NOaPOBbLPLAQAAAC4IwQu1mq+Xh65vV7rccAkPUwYAAEAdRfBCrdf/5HLDpSw3BAAAQB1F8EKt9/u2TeXrZdW+zONKPeQwuxwAAACgygheqPUCfDz1+ytP7m7IckMAAADUQQQv1An9OkdIYndDAAAA1E0EL9QJN7QPl7enVbuP5Gl7eo7Z5QAAAABVUuXgtWrVKt18882KjIyUxWLRokWL3NoNw9DkyZPVrFkz+fn5KS4uTjt37nTrk5mZqWHDhslmsykkJEQjR45Ubm6uW5/Nmzfr2muvla+vr6KiojRt2rQzalm4cKHatWsnX19fde7cWUuWLKlyLagbAn08dd2VTSWV3vUCAAAA6pIqB6+8vDx16dJFr7/++lnbp02bppkzZ2rWrFlas2aNAgICFB8fr/z8fFefYcOGKTU1VQkJCVq8eLFWrVql0aNHu9odDoduvPFGRUdHKzk5WS+88IKmTJmi2bNnu/qsXr1aQ4YM0ciRI7VhwwYNHDhQAwcOVEpKSpVqQd3R/+Ryw6Vb+JwXAAAA6haLcREfmLFYLPr88881cOBASaV3mCIjI/XQQw/p4YcfliRlZ2crPDxcc+fO1eDBg7Vt2zZ16NBB69atU8+ePSVJy5YtU//+/XXgwAFFRkbqzTff1OOPPy673S5vb29J0sSJE7Vo0SKlpaVJkgYNGqS8vDwtXrzYVU+fPn3UtWtXzZo167xqqYzD4VBwcLCys7Nls9kudJpQTRz5RerxzwQVlRhKeLCvrggPMrskAAAANBAXmw2q9TNeu3fvlt1uV1xcnOtYcHCwYmJilJiYKElKTExUSEiIK3RJUlxcnKxWq9asWePq07dvX1fokqT4+Hht375dx44dc/Upf56yPmXnOZ9aTldQUCCHw+H2Qu1h8/XStVew3BAAAAB1T7UGL7u99H+Gw8PD3Y6Hh4e72ux2u8LCwtzaPT09FRoa6tbnbGOUP0dFfcq3V1bL6aZOnarg4GDXKyoq6jyuGpdSv04nlxuyrTwAAADqEHY1LGfSpEnKzs52vfbv3292STjNHzuEy9NqUZo9R7sO51b+BgAAAKAWqNbgFRFRejciPT3d7Xh6erqrLSIiQhkZGW7txcXFyszMdOtztjHKn6OiPuXbK6vldD4+PrLZbG4v1C4h/t66qk0TSdKyFJYbAgAAoG6o1uDVunVrRUREaMWKFa5jDodDa9asUWxsrCQpNjZWWVlZSk5OdvX59ttv5XQ6FRMT4+qzatUqFRUVufokJCSobdu2atSokatP+fOU9Sk7z/nUgrqpf6eyhymz3BAAAAB1Q5WDV25urjZu3KiNGzdKKt3EYuPGjdq3b58sFovGjx+vZ599Vl988YW2bNmi4cOHKzIy0rXzYfv27XXTTTdp1KhRWrt2rX766SeNHTtWgwcPVmRkpCRp6NCh8vb21siRI5WamqoFCxZoxowZmjBhgquOcePGadmyZXrppZeUlpamKVOmKCkpSWPHjpWk86oFddONHSPkYbUo9ZBDe4/mmV0OAAAAUDmjir777jtD0hmvESNGGIZhGE6n03jyySeN8PBww8fHx7jhhhuM7du3u41x9OhRY8iQIUZgYKBhs9mMO++808jJyXHrs2nTJuOaa64xfHx8jObNmxvPP//8GbV88sknxpVXXml4e3sbHTt2NL766iu39vOp5Vyys7MNSUZ2dvZ5vweXxrC3fzaiH1tsvLnyF7NLAQAAQANwsdngop7jVd/xHK/a68M1e/X45ynq0iJY/xt7jdnlAAAAoJ6rVc/xAi6VGztEyGqRNh3I1oFjx80uBwAAADgnghfqpKZBPurdOlSStJSHKQMAAKCWI3ihzurfuZkkaQkPUwYAAEAtR/BCnRXfMUIWi7RhX5YOZZ0wuxwAAACgQgQv1FnhNl/1jC59rhsPUwYAAEBtRvBCndavU+lyw6UsNwQAAEAtRvBCndavc4QkKWnvMaU78k2uBgAAADg7ghfqtGbBfureMkSGIS1PZbkhAAAAaieCF+o81+6GW1huCAAAgNqJ4IU676ZOpcsN1+7O1OGcApOrAQAAAM5E8EKd16KRv7q0CJaT5YYAAACopQheqBf6dWZ3QwAAANReBC/UC/1OLjf8+ddMHc1luSEAAABqF4IX6oXoxgHqGGlTidNQwtZ0s8sBAAAA3BC8UG+4djdM4XNeAAAAqF0IXqg3ypYbrv7liLKOF5pcDQAAAHAKwQv1xmVNA9UuIkjFLDcEAABALUPwQr3S37W7IcsNAQAAUHsQvFCv9O9cutzwh52H5cgvMrkaAAAAoBTBC/VKm7AgXREWqKISQ9+w3BAAAAC1BMEL9U7Zw5SXbGG5IQAAAGoHghfqnbLlhqt2HlYOyw0BAABQCxC8UO+0DQ/SZU0CVFjs1LdpGWaXAwAAABC8UP9YLJZTuxuy3BAAAAC1AMEL9VK/k8sNv9ueobyCYpOrAQAAQENH8EK91KGZTdGN/VVQ7NTK7YfNLgcAAAANHMEL9ZLFYlG/Tid3N0z5zeRqAAAA0NARvFBvle1u+F1ahk4UlphcDQAAABoyghfqrc7Ng9U8xE/HC0v0/Q52NwQAAIB5CF6ot0p3Nyy968XDlAEAAGAmghfqtX4nt5VfsS1d+UUsNwQAAIA5CF6o17q2CFGzYF/lFZboh51HzC4HAAAADRTBC/Wa1Xpqd8OlW9jdEAAAAOYgeKHeK/ucV8K2dBUUs9wQAAAAlx7BC/Ve95aNFBbko5z8Yq3+5ajZ5QAAAKABInih3itdbli2uyHLDQEAAHDpEbzQIJTtbvj11nQVlThNrgYAAAANDcELDUKvVqFqEuit7BNFWr2L5YYAAAC4tKo9eJWUlOjJJ59U69at5efnp8svv1z//Oc/ZRiGq49hGJo8ebKaNWsmPz8/xcXFaefOnW7jZGZmatiwYbLZbAoJCdHIkSOVm5vr1mfz5s269tpr5evrq6ioKE2bNu2MehYuXKh27drJ19dXnTt31pIlS6r7klEHeFgtiu9YutyQ3Q0BAABwqVV78Pr3v/+tN998U6+99pq2bdumf//735o2bZpeffVVV59p06Zp5syZmjVrltasWaOAgADFx8crPz/f1WfYsGFKTU1VQkKCFi9erFWrVmn06NGudofDoRtvvFHR0dFKTk7WCy+8oClTpmj27NmuPqtXr9aQIUM0cuRIbdiwQQMHDtTAgQOVkpJS3ZeNOqD/yeWGy1PtKma5IQAAAC4hi1H+VlQ1+NOf/qTw8HDNmTPHdezWW2+Vn5+f/vOf/8gwDEVGRuqhhx7Sww8/LEnKzs5WeHi45s6dq8GDB2vbtm3q0KGD1q1bp549e0qSli1bpv79++vAgQOKjIzUm2++qccff1x2u13e3t6SpIkTJ2rRokVKS0uTJA0aNEh5eXlavHixq5Y+ffqoa9eumjVrVqXX4nA4FBwcrOzsbNlstmqbI5ijuMSp3s+tUGZeoT68O0ZXt2lidkkAAACoIy42G1T7Ha+rrrpKK1as0I4dOyRJmzZt0o8//qh+/fpJknbv3i273a64uDjXe4KDgxUTE6PExERJUmJiokJCQlyhS5Li4uJktVq1Zs0aV5++ffu6QpckxcfHa/v27Tp27JirT/nzlPUpO8/pCgoK5HA43F6oPzw9rIrvGC6J3Q0BAABwaVV78Jo4caIGDx6sdu3aycvLS926ddP48eM1bNgwSZLdbpckhYeHu70vPDzc1Wa32xUWFubW7unpqdDQULc+Zxuj/Dkq6lPWfrqpU6cqODjY9YqKiqry9aN269fp1HLDEme13uwFAAAAKlTtweuTTz7Rhx9+qPnz52v9+vWaN2+eXnzxRc2bN6+6T1XtJk2apOzsbNdr//79ZpeEahZ7eWMF+3npSG6h1u3JNLscAAAANBDVHrweeeQR112vzp076/bbb9eDDz6oqVOnSpIiIkp3lktPT3d7X3p6uqstIiJCGRkZbu3FxcXKzMx063O2Mcqfo6I+Ze2n8/Hxkc1mc3uhfvHysOrGDqV3QdndEAAAAJdKtQev48ePy2p1H9bDw0NOZ+kucq1bt1ZERIRWrFjhanc4HFqzZo1iY2MlSbGxscrKylJycrKrz7fffiun06mYmBhXn1WrVqmoqMjVJyEhQW3btlWjRo1cfcqfp6xP2XnQMJXtbrg0xS4nyw0BAABwCVR78Lr55pv1r3/9S1999ZX27Nmjzz//XC+//LJuueUWSZLFYtH48eP17LPP6osvvtCWLVs0fPhwRUZGauDAgZKk9u3b66abbtKoUaO0du1a/fTTTxo7dqwGDx6syMhISdLQoUPl7e2tkSNHKjU1VQsWLNCMGTM0YcIEVy3jxo3TsmXL9NJLLyktLU1TpkxRUlKSxo4dW92XjTrkqjaNFeTrqYycAiXvO2Z2OQAAAGgAqn07+ZycHD355JP6/PPPlZGRocjISA0ZMkSTJ0927UBoGIaeeuopzZ49W1lZWbrmmmv0xhtv6Morr3SNk5mZqbFjx+rLL7+U1WrVrbfeqpkzZyowMNDVZ/PmzRozZozWrVunJk2a6P7779djjz3mVs/ChQv1xBNPaM+ePbriiis0bdo09e/f/7yuhe3k668JCzbqsw0HdefVrfTUzR3NLgcAAAC13MVmg2oPXvUJwav+StiarlHvJ6lZsK9+euwPslotZpcEAACAWqzWPccLqAuuvaKJAn089Vt2vjYeyDK7HAAAANRzBC80SL5eHrqhfemz4tjdEAAAADWN4IUGq+xhyku22MWKWwAAANQkghcarN+3bSp/bw8dzDqhLQezzS4HAAAA9RjBCw2Wr5eHrm9XutxwyRa7ydUAAACgPiN4oUHr36nsYcq/sdwQAAAANYbghQbt922bytfLqr1Hjyv1kMPscgAAAFBPEbzQoAX4eOr3V57c3TCF3Q0BAABQMwheaPD6dY6QxO6GAAAAqDkELzR4N7QPl7enVbuP5Gl7eo7Z5QAAAKAeInihwQv08dR1VzaVxO6GAAAAqBkEL0BS/5PLDZdu4XNeAAAAqH4EL0Clyw29PCzamZGrnSw3BAAAQDUjeAGSbL5euvaK0uWGS1NYbggAAIDqRfACTurXqWx3Q5YbAgAAoHoRvICT/tghXJ5Wi9LsOfr1cK7Z5QAAAKAeIXgBJ4X4e+uqNk0ksdwQAAAA1YvgBZTTn+WGAAAAqAEEL6CcGztGyMNqUeohh/YezTO7HAAAANQTBC+gnNAAb8Ve1lgSyw0BAABQfQhewGn68TBlAAAAVDOCF3CaGztEyGqRNh3I1oFjx80uBwAAAPUAwQs4TdMgH/VuHSpJWsZyQwAAAFQDghdwFv07N5PE7oYAAACoHgQv4CziO0bIYpHW78vSoawTZpcDAACAOo7gBZxFuM1XPaMbSWK5IQAAAC4ewQuoQL9OpcsNl6aw3BAAAAAXh+AFVKBsW/mkvceU7sg3uRoAAADUZQQvoALNgv3UvWWIDENamLTf7HIAAABQhxG8gHP4v55RkqSXE3bo61Q+6wUAAIALQ/ACzmFwrygN6hklpyHd/9EGJe3JNLskAAAA1EEEL+AcLBaL/nVLJ8W1D1NBsVN3zV2nHek5ZpcFAACAOobgBVTC08OqV4d0V/eWIXLkF2vEu2t5thcAAACqhOAFnAc/bw/NGdFLbcIC9Vt2vka8u1ZZxwvNLgsAAAB1BMELOE+NArw1767eirD5amdGru6el6T8ohKzywIAAEAdQPACqqB5iJ/m3dVbQb6eStp7TPd/tEHFJU6zywIAAEAtR/ACqqhtRJDeGd5T3p5WJWxN15P/S5VhGGaXBQAAgFqM4AVcgJjLGmvm4G6yWqSP1u7T9G92ml0SAAAAajGCF3CBbuoUoWf+0kmSNGPFTn24Zq/JFQEAAKC2qpHgdfDgQf39739X48aN5efnp86dOyspKcnVbhiGJk+erGbNmsnPz09xcXHaudP9jkFmZqaGDRsmm82mkJAQjRw5Urm5uW59Nm/erGuvvVa+vr6KiorStGnTzqhl4cKFateunXx9fdW5c2ctWbKkJi4ZDdTf+0TrgRuukCQ9uShFy1PtJlcEAACA2qjag9exY8d09dVXy8vLS0uXLtXWrVv10ksvqVGjRq4+06ZN08yZMzVr1iytWbNGAQEBio+PV35+vqvPsGHDlJqaqoSEBC1evFirVq3S6NGjXe0Oh0M33nijoqOjlZycrBdeeEFTpkzR7NmzXX1Wr16tIUOGaOTIkdqwYYMGDhyogQMHKiUlpbovGw3Yg3FXaEjvKDkN6f6PNmjt7kyzSwIAAEAtYzGqeVeAiRMn6qefftIPP/xw1nbDMBQZGamHHnpIDz/8sCQpOztb4eHhmjt3rgYPHqxt27apQ4cOWrdunXr27ClJWrZsmfr3768DBw4oMjJSb775ph5//HHZ7XZ5e3u7zr1o0SKlpaVJkgYNGqS8vDwtXrzYdf4+ffqoa9eumjVrVqXX4nA4FBwcrOzsbNlstouaF9RvxSVO3fuf9fpmW7psvp5aeO9VahsRZHZZAAAAqCYXmw2q/Y7XF198oZ49e+r//u//FBYWpm7duuntt992te/evVt2u11xcXGuY8HBwYqJiVFiYqIkKTExUSEhIa7QJUlxcXGyWq1as2aNq0/fvn1doUuS4uPjtX37dh07dszVp/x5yvqUned0BQUFcjgcbi/gfHh6WPXa0G7qEd1IjvxijXh3rQ5mnTC7LAAAANQS1R68fv31V7355pu64oortHz5ct1333164IEHNG/ePEmS3V76GZjw8HC394WHh7va7Ha7wsLC3No9PT0VGhrq1udsY5Q/R0V9ytpPN3XqVAUHB7teUVFRVb5+NFy+Xh6aM6KnrggLlN2RrxHvrlXW8UKzywIAAEAtUO3By+l0qnv37nruuefUrVs3jR49WqNGjTqvpX1mmzRpkrKzs12v/fv3m10S6pgQf2/Nu6u3Imy++iUjVyPnJelEYYnZZQEAAMBk1R68mjVrpg4dOrgda9++vfbt2ydJioiIkCSlp6e79UlPT3e1RUREKCMjw629uLhYmZmZbn3ONkb5c1TUp6z9dD4+PrLZbG4voKoiQ/z0/sjesvl6KnnvMd3/0QYVlzjNLgsAAAAmqvbgdfXVV2v79u1ux3bs2KHo6GhJUuvWrRUREaEVK1a42h0Oh9asWaPY2FhJUmxsrLKyspScnOzq8+2338rpdComJsbVZ9WqVSoqKnL1SUhIUNu2bV07KMbGxrqdp6xP2XmAmnJleJDm3NFLPp5WfbMtXU8sSlE172MDAACAOqTag9eDDz6on3/+Wc8995x++eUXzZ8/X7Nnz9aYMWMkSRaLRePHj9ezzz6rL774Qlu2bNHw4cMVGRmpgQMHSiq9Q3bTTTdp1KhRWrt2rX766SeNHTtWgwcPVmRkpCRp6NCh8vb21siRI5WamqoFCxZoxowZmjBhgquWcePGadmyZXrppZeUlpamKVOmKCkpSWPHjq3uywbO0KtVqGYO6SarRfp43X69krDD7JIAAABgkmrfTl6SFi9erEmTJmnnzp1q3bq1JkyYoFGjRrnaDcPQU089pdmzZysrK0vXXHON3njjDV155ZWuPpmZmRo7dqy+/PJLWa1W3XrrrZo5c6YCAwNdfTZv3qwxY8Zo3bp1atKkie6//3499thjbrUsXLhQTzzxhPbs2aMrrrhC06ZNU//+/c/rOthOHtVh/pp9+n+fb5Ek/XNgJ93eJ9rkigAAAFBVF5sNaiR41RcEL1SX6d/s0PRvdspikd4c1l03dWpmdkkAAACoglr3HC8AZxp3wxUa0rulDEN64OONWvPrUbNLAgAAwCVE8AIuAYvFomcHdtKNHcJVWOzU3e8nKc3OA7oBAAAaCoIXcIl4WC2aOaSberVqpJz8Yo14d60OZp0wuywAAABcAgQv4BLy9fLQO8N76crwQKU7CjR8zhodyys0uywAAADUMIIXcIkF+3tp7p291SzYV7sO52nkvHU6UVhidlkAAACoQQQvwASRIX56/67eCvbz0vp9WRo7f72KS5xmlwUAAIAaQvACTHJFeJDmjOgpH0+rVqRl6P99vkU83QEAAKB+IngBJurZKlSvDe0uq0X6JOmAXk7YYXZJAAAAqAEEL8Bkf+wQrn/d0lmS9Oq3v+iDxD3mFgQAAIBqR/ACaoEhvVvqwbgrJUmTv0jVki2/mVwRAAAAqhPBC6glHrihjYbFtJRhSOM/3qiffz1qdkkAAACoJgQvoJawWCx65i+dFN8xXIUlTo2al6RtvznMLgsAAADVgOAF1CIeVotmDO6m3q1ClVNQrDveW6sDx46bXRYAAAAuEsELqGV8vTz09vCeahsepHRHgYa/u1bH8grNLgsAAAAXgeAF1ELB/l6ae1cvRQb76tfDebpr3jodLyw2uywAAABcIIIXUEs1C/bT+yN7K9jPSxv2ZWns/A0qKnGaXRYAAAAuAMELqMXahAXp3Tt6ytfLqm/TMvT/PtsiwzDMLgsAAABVRPACarke0aF6bUh3WS3SwuQDevHr7WaXBAAAgCoieAF1QFyHcD13S2dJ0uvf7dK81XvMLQgAAABVQvAC6ojBvVvqoT9eKUma8mWqvtr8m8kVAQAA4HwRvIA6ZOwf2uj2PtEyDOnBBRuVuOuo2SUBAADgPBC8gDrEYrFoyp87ql+nCBWWODX6/SRtPeQwuywAAABUguAF1DEeVoteGdRVvVuHKqegWHe8t1b7M4+bXRYAAADOgeAF1EG+Xh56e3hPtYsIUkZOgUa8u1aZeYVmlwUAAIAKELyAOirYz0tz7+yt5iF++vVInu6cu07HC4vNLgsAAABnQfAC6rCIYF/Nu6u3Qvy9tGl/lsZ8uF5FJU6zywIAAMBpCF5AHdcmLFBzRvSSr5dV320/rIn/3SLDMMwuCwAAAOUQvIB6oEd0I70+tLs8rBb9d/0BvbB8u9klAQAAoByCF1BP3NA+XFP/2lmS9MbKXZr7026TKwIAAEAZghdQj9zWM0qPxLeVJD29eKsWbz5kckUAAACQCF5AvfOP31+u4bHRMgxpwoJNStx11OySAAAAGjyCF1DPWCwWPXVzR/XvHKHCEqfu+zBZe47kmV0WAABAg0bwAuohD6tFL9/WVV2iQpR1vEh3v58kR36R2WUBAAA0WAQvoJ7y9fLQ27f3UITNV79k5OqBjzaoxMk28wAAAGYgeAH1WJjNV++M6ClfL6tWbj+s55ZsM7skAACABongBdRznZoH6+XbukqS5vy4WwvW7TO3IAAAgAaI4AU0AP07N9ODcVdKkp5YlKI1v7LTIQAAwKVE8AIaiAduaKMBv2umohJD9324Xvszj5tdEgAAQINR48Hr+eefl8Vi0fjx413H8vPzNWbMGDVu3FiBgYG69dZblZ6e7va+ffv2acCAAfL391dYWJgeeeQRFRcXu/VZuXKlunfvLh8fH7Vp00Zz58494/yvv/66WrVqJV9fX8XExGjt2rU1cZlArWexWPTi37rody2ClZlXqJHz1imHnQ4BAAAuiRoNXuvWrdNbb72l3/3ud27HH3zwQX355ZdauHChvv/+ex06dEh//etfXe0lJSUaMGCACgsLtXr1as2bN09z587V5MmTXX12796tAQMG6Prrr9fGjRs1fvx43X333Vq+fLmrz4IFCzRhwgQ99dRTWr9+vbp06aL4+HhlZGTU5GUDtZaft4dm395TYUE+2pGeq3Efb2SnQwAAgEvAYhhGjfxfV25urrp376433nhDzz77rLp27arp06crOztbTZs21fz58/W3v/1NkpSWlqb27dsrMTFRffr00dKlS/WnP/1Jhw4dUnh4uCRp1qxZeuyxx3T48GF5e3vrscce01dffaWUlBTXOQcPHqysrCwtW7ZMkhQTE6NevXrptddekyQ5nU5FRUXp/vvv18SJEyu9BofDoeDgYGVnZ8tms1X3FAGm2bQ/S7e9laiCYqfu6XuZJvVvb3ZJAAAAtdrFZoMau+M1ZswYDRgwQHFxcW7Hk5OTVVRU5Ha8Xbt2atmypRITEyVJiYmJ6ty5syt0SVJ8fLwcDodSU1NdfU4fOz4+3jVGYWGhkpOT3fpYrVbFxcW5+pyuoKBADofD7QXUR12iQvTC/3WRJL216lctTNpvckUAAAD1W40Er48//ljr16/X1KlTz2iz2+3y9vZWSEiI2/Hw8HDZ7XZXn/Khq6y9rO1cfRwOh06cOKEjR46opKTkrH3Kxjjd1KlTFRwc7HpFRUWd/0UDdcyfu0TqgT+0kSQ9/nmKkvZkmlwRAABA/VXtwWv//v0aN26cPvzwQ/n6+lb38DVq0qRJys7Odr327+cuAOq38XFXql+nCBWWOHXPB8nsdAgAAFBDqj14JScnKyMjQ927d5enp6c8PT31/fffa+bMmfL09FR4eLgKCwuVlZXl9r709HRFRERIkiIiIs7Y5bDs58r62Gw2+fn5qUmTJvLw8Dhrn7IxTufj4yObzeb2Auozq9Wil27roo6RNh3NK9So95OUW1Bc+RsBAABQJdUevG644QZt2bJFGzdudL169uypYcOGub738vLSihUrXO/Zvn279u3bp9jYWElSbGystmzZ4rb7YEJCgmw2mzp06ODqU36Msj5lY3h7e6tHjx5ufZxOp1asWOHqA0Dy9/bU28N7qkmgj9LsORr/8UY52ekQAACgWnlW94BBQUHq1KmT27GAgAA1btzYdXzkyJGaMGGCQkNDZbPZdP/99ys2NlZ9+vSRJN14443q0KGDbr/9dk2bNk12u11PPPGExowZIx8fH0nSvffeq9dee02PPvqo7rrrLn377bf65JNP9NVXX7nOO2HCBI0YMUI9e/ZU7969NX36dOXl5enOO++s7ssG6rTIED+9PbyHBs3+Wd9sS9cLX2/XYze1M7ssAACAeqPag9f5eOWVV2S1WnXrrbeqoKBA8fHxeuONN1ztHh4eWrx4se677z7FxsYqICBAI0aM0DPPPOPq07p1a3311Vd68MEHNWPGDLVo0ULvvPOO4uPjXX0GDRqkw4cPa/LkybLb7eratauWLVt2xoYbAKRuLRvphb/9TuM+3qg3V+7SFWGB+mv3FmaXBQAAUC/U2HO86gOe44WG6IXlaXr9u13y9rDqo9F91CO6kdklAQAAmK7WPscLQN300B/b6sYO4Sd3OkzSwawTZpcEAABQ5xG8ALixWi16ZVBXtW9m05HcQo2al6Tjhex0CAAAcDEIXgDOEODjqXdG9FSTQG9t/c2hBxew0yEAAMDFIHgBOKvmIX566/Ye8vawanlqul5O2GF2SQAAAHUWwQtAhXpEh2rqXztLkl777hf9b+NBkysCAAComwheAM7p1h4tdM91l0mSHvl0szbuzzK3IAAAgDqI4AWgUo/Gt1Nc+zAVFjs16v0k/ZbNTocAAABVQfACUCkPq0XTB3dT2/AgHc4p0Kj32ekQAACgKgheAM5L4MmdDkMDvJVy0KGHF25ip0MAAIDzRPACcN6iQv311u095OVh0ZItds1YsdPskgAAAOoEgheAKunVKlT/uqV0p8MZK3Zq8eZDJlcEAABQ+xG8AFTZbT2jNOra1pKkhz7ZpM0HsswtCAAAoJYjeAG4IBP7tdf1bZuq4OROh+mOfLNLAgAAqLUIXgAuiIfVoplDuumKsEClOwo0+v0k5ReVmF0WAABArUTwAnDBgny9NGdELzXy99KmA9l65NPNMgx2OgQAADgdwQvARWnZ2F9vDOshT6tFX246pFe//cXskgAAAGodgheAixZ7eWP9c2AnSdLLCTu0dMtvJlcEAABQuxC8AFSLIb1b6s6rW0mSJnyySSkHs80tCAAAoBYheAGoNo/3b6++VzbViaISjXo/SRnsdAgAACCJ4AWgGnl6WPXqkG66rGmAfsvO1+gPktnpEAAAQAQvANUs2K90p8NgPy9t3J+lif9lp0MAAACCF4Bq17pJgN4c1l2eVosWbTykN1buMrskAAAAUxG8ANSIq9o00ZQ/d5QkvbB8u5an2k2uCAAAwDwELwA15u99ojU8NlqS9OCCjdp6yGFyRQAAAOYgeAGoUZP/1EHXtGmi44UlunveOh3OKTC7JAAAgEuO4AWgRnl6WPX60O66rEmADmXn654PklRQzE6HAACgYSF4Aahxwf5eemdET9l8PbV+X5YmfbaFnQ4BAECDQvACcElc1jRQrw/rLg+rRZ+tP6i3Vv1qdkkAAACXDMELwCVz7RVNNflPHSRJ/16WpoSt6SZXBAAAcGkQvABcUsNjozUspqUMQxr/8Qal2dnpEAAA1H8ELwCXlMVi0ZQ/d1TsZY2VV1iiu+cl6WguOx0CAID6jeAF4JLz8rDqjWHdFd3YXweOndC9/0lmp0MAAFCvEbwAmKJRgLfmjOipIB9PrdtzTE98nsJOhwAAoN4ieAEwTZuwIL06tJusFmlh8gHN+XG32SUBAADUCIIXAFP9vm2YnhhQutPhc0u26bu0DJMrAgAAqH4ELwCmu/PqVhrcK0pOQ7r/ow3akZ5jdkkAAADViuAFwHQWi0XP/KWTYlqHKregWCPnrVNmXqHZZQEAAFQbgheAWsHb06o3/95DLUP9tT+zdKdDtpkHAAD1RbUHr6lTp6pXr14KCgpSWFiYBg4cqO3bt7v1yc/P15gxY9S4cWMFBgbq1ltvVXp6ulufffv2acCAAfL391dYWJgeeeQRFRcXu/VZuXKlunfvLh8fH7Vp00Zz5849o57XX39drVq1kq+vr2JiYrR27drqvmQA1SQ0wFvvjOipQB9Prd2dqR7PfqM/vLhSj366SZ8k7devh3PZ+RAAANRJ1R68vv/+e40ZM0Y///yzEhISVFRUpBtvvFF5eXmuPg8++KC+/PJLLVy4UN9//70OHTqkv/71r672kpISDRgwQIWFhVq9erXmzZunuXPnavLkya4+u3fv1oABA3T99ddr48aNGj9+vO6++24tX77c1WfBggWaMGGCnnrqKa1fv15dunRRfHy8MjL48D5QW10ZHqTZw3uoXUSQJOnXI3n6JOmAHv10s/7w0vfq+ew3uueDJL296ldt2HdMhcVOkysGAAConMWo4b8+Pnz4sMLCwvT999+rb9++ys7OVtOmTTV//nz97W9/kySlpaWpffv2SkxMVJ8+fbR06VL96U9/0qFDhxQeHi5JmjVrlh577DEdPnxY3t7eeuyxx/TVV18pJSXFda7BgwcrKytLy5YtkyTFxMSoV69eeu211yRJTqdTUVFRuv/++zVx4sRKa3c4HAoODlZ2drZsNlt1Tw2ASmQdL9T6fce0bs8xJe3J1KYD2WcELV8vq7q0CFGvVqHq2aqRukc3ks3Xy6SKAQBAfXWx2cCzBmpyk52dLUkKDQ2VJCUnJ6uoqEhxcXGuPu3atVPLli1dwSsxMVGdO3d2hS5Jio+P13333afU1FR169ZNiYmJbmOU9Rk/frwkqbCwUMnJyZo0aZKr3Wq1Ki4uTomJiWettaCgQAUFpz5T4nA4Lu7iAVyUEH9v/aFduP7QrvR3QUFxiVIOZp8MYseUtDdTWceLtGZ3ptbszpQkWSxS2/AgVxDr2SpUzUP8zLwMAACAmg1eTqdT48eP19VXX61OnTpJkux2u7y9vRUSEuLWNzw8XHa73dWnfOgqay9rO1cfh8OhEydO6NixYyopKTlrn7S0tLPWO3XqVD399NMXdrEAapyPp4d6RIeqR3SodJ3kdBr69UiukvacvCu2N1N7jx5Xmj1HafYcffDzXklSZLCvepYFsehQtY0IkofVYvLVAACAhqRGg9eYMWOUkpKiH3/8sSZPU20mTZqkCRMmuH52OByKiooysSIA52K1WtQmLEhtwoI0uHdLSVJGTr6STwax5L2ZSjnk0KHsfH2x6ZC+2HRIkhTk46lu0Y3UK7r0jljXqBD5eXuYeSkAAKCeq7HgNXbsWC1evFirVq1SixYtXMcjIiJUWFiorKwst7te6enpioiIcPU5fffBsl0Py/c5fSfE9PR02Ww2+fn5ycPDQx4eHmftUzbG6Xx8fOTj43NhFwygVggL8lW/zs3Ur3MzSdLxwmJt3JfluiO2fu8x5RQUa9WOw1q147AkydNqUcfmwa4g1rNVIzUJ5HcBAACoPtUevAzD0P3336/PP/9cK1euVOvWrd3ae/ToIS8vL61YsUK33nqrJGn79u3at2+fYmNjJUmxsbH617/+pYyMDIWFhUmSEhISZLPZ1KFDB1efJUuWuI2dkJDgGsPb21s9evTQihUrNHDgQEmlSx9XrFihsWPHVvdlA6il/L09dVWbJrqqTRNJUnGJU2n2HCXtyVTS3mNatydT6Y4CbdqfpU37s/TOj7slSa2bBKhndCPX58QuaxIgi4XliQAA4MJU+66G//jHPzR//nz973//U9u2bV3Hg4OD5edX+gH3++67T0uWLNHcuXNls9l0//33S5JWr14tqXQ7+a5duyoyMlLTpk2T3W7X7bffrrvvvlvPPfecpNLt5Dt16qQxY8borrvu0rfffqsHHnhAX331leLj4yWVbic/YsQIvfXWW+rdu7emT5+uTz75RGlpaWd89uts2NUQqP8Mw9CBYyeUfDKEJe05ph0ZOTr9N2NogLd6RDdSr5NBrFNksLw9eQY9AAANxcVmg2oPXhX9jfB7772nO+64Q1LpA5QfeughffTRRyooKFB8fLzeeOMNtyWAe/fu1X333aeVK1cqICBAI0aM0PPPPy9Pz1M36VauXKkHH3xQW7duVYsWLfTkk0+6zlHmtdde0wsvvCC73a6uXbtq5syZiomJOa9rIXgBDVP28aKT29iX3hXbuD/rjG3sfTyt6hIV4gpi3Vs2UrAf29gDAFBf1brgVZ8QvABIZdvYO5S8N9P1TLFjx4vc+pRtY9+zVSN1aRGiAB9PeVgt8rRaZD35tfRnqzyskofVWu7YmX2sVp3se+p42fcseQQA4NIjeNUggheAszEMQ7sO57kFsT1Hj1+y81stOmc4O/Pnc4W88u+xyubnpbuvba3LmwZesusBAKAuIHjVIIIXgPN1OKfAFcTS7A4VFRsqdjpVYkglTqeKSwyVOA2VGKVfz/zZWfrVachpGCoqMe9Xs6+XVRNvaqfhsa1k5XlnAABIInjVKIIXADM5ywWxYqehkpKTYe5kYCsLb64+rp+dp/18MuSV+/5sfZyGoa9T0/XjL0ckSVe3aawX/tZFkSF+Js8EAADmI3jVIIIXgIbG6TT0nzV79dySbcovcirI11NP/7mjbunWnM+WAQAatIvNBuyFDABwsVotGh7bSkseuFZdo0KUk1+sCZ9s0n3/Wa+juQVmlwcAQJ1F8AIAnOGypoH69N5YPXzjlfK0WrQs1a746auUsDXd7NIAAKiTCF4AgLPy9LBq7B+u0KIxV+vK8EAdyS3UqPeT9Oinm5STX1T5AAAAwIXgBQA4p07Ng/XF2Gt0T9/LZLFInyQd0E3Tf9DPvx41uzQAAOoMghcAoFK+Xh6a1L+9FoyOVVSonw5mndCQt3/Ws4u3Kr+oxOzyAACo9QheAIDz1rt1qJaO66shvaNkGNI7P+7Wza/+qC0Hss0uDQCAWo3gBQCokkAfT0396+/07h091STQRzszcnXLGz9pxjc7VVTiNLs8AABqJYIXAOCC/KFduL5+sK/6d45QsdPQK9/s0N/eXK1dh3PNLg0AgFqH4AUAuGChAd56fWh3zRjcVTZfT206kK3+M37Qez/tltNpmF0eAAC1BsELAHBRLBaL/tK1uZY/2FfXXtFEBcVOPf3lVv19zhodzDphdnkAANQKBC8AQLVoFuyn9+/qrX8O7CQ/Lw+t3nVUN72ySv9NPiDD4O4XAKBhI3gBAKqNxWLR7X2itWTcterWMkQ5BcV6aOEm3fufZB3NLTC7PAAATEPwAgBUu9ZNArTwnlg9Et9WXh4WLU9NV/z0Vfo61W52aQAAmILgBQCoEZ4eVo25vo0WjblabcODdCS3UKM/SNbDCzfJkV9kdnkAAFxSBC8AQI3qGBmsL+6/Wvdcd5ksFunT5APqN/0Hrd51xOzSAAC4ZAheAIAa5+PpoUn92uuTe2IVFeqng1knNPTtNXrmy63KLyoxuzwAAGocwQsAcMn0ahWqpeP6akjvlpKkd3/arQEzf9DmA1nmFgYAQA0jeAEALqlAH09N/WtnvXdHLzUN8tGuw3m65Y3Vmv7NDhWVOM0uDwCAGkHwAgCY4vp2Yfp6fF8N+F0zlTgNTf9mp259c7V+ycg1uzQAAKodwQsAYJpGAd56fWh3zRzSTcF+Xtp8IFsDZv6gd3/cLaeThy4DAOoPghcAwHR/7hKp5eP7qu+VTVVQ7NQzi7dq2DtrdDDrhNmlAQBQLQheAIBaISLYV/Pu7KVnB3aSn5eHEn89qpteWaVPkw/IMLj7BQCo2wheAIBaw2Kx6O99orV03LXq3jJEOQXFenjhJt3zQbKO5BaYXR4AABeM4AUAqHVaNQnQwnuv0qM3tZWXh0Vfb01X/CurtDzVbnZpAABcEIIXAKBW8rBa9I/ft9H/xlyjdhFBOppXqHs+SNZDn2ySI7/I7PIAAKgSghcAoFbrEGnT/8ZerXuvu1xWi/Tf9QfUb/oPWr3riNmlAQBw3gheAIBaz8fTQxP7tdMn98SqZai/Dmad0NC31+jpL1OVX1RidnkAAFSK4AUAqDN6tgrV0nHXalhMS0nSez/t0YCZP2jT/ixzCwMAoBIWgz16K+RwOBQcHKzs7GzZbDazywEAlPPd9gw99ulmZeQUyMNq0T19L1PMZY3VJNBbTQN9FBrgLU8P/n4RAFA9LjYbELzOgeAFALVb1vFCPfm/VH256dAZbRaLFOrvrSaBPmoSVPq1aaCPmgT5lB4LLD0WFkRIAwBUjuBVgwheAFA3fLX5Ny1I2q8MR76O5BYoM69Qzir86WaxSI38vV1hrEmgj5qWD2hBpaGt6cmQ5kVIA1DLGIYhx4liHco+od+yT+hQVr4OZZ3Qb9mlX4udhlqG+iu6sb9aNQ5QdGN/RTcOUCN/L1ksFrPLrxMIXjWI4AUAdVOJ01BmXqGO5BbocE6BjuSWvQp1JKdAh13HC5WZV1ClkCZJjfy9zgxo5e6qlR1rHEhIA1A98gqKXYGq/NeyYPVbdr6OF1Z9s6EgX0+1ahyglo391epkGIsO9VerJgEKC/IhlJVD8KpBBC8AqP9KnIaOHS90D2g5p0Lb4bLAllugo7lVD2khrpDmraZBvq67ak1PhrWmgb4K8feSp4dFFllktUgWS+lXq8Uiq8Uii7Xs+9KvkvvPlpPvAVA35ReVyJ6dX3q3qixYZefrt3J3rBz5xec1ViN/LzUL9lNkiO/Jr6Xfe1gt2pd5XHuPHNeeo3nal3lcv2Xnn3MsPy+PU3fJmgSoZeipu2WRIX7ysDas3zsErxpE8AIAlFcW0sqHszMC2snvM/MKVVLVlHYRLJZTYcxisciiM8OZ1Wpx62O1yD3sWcuFPUsFYc9aNt6pNk+rRV4eVnl6lH7vaS393svDWvqzh1VeHhZ5WE87dvJr6c/ux7w8Sscpfc9p/T0s8jqtrXwNXlarPDxO1dXQ/ucQtUtxiVPpOQU6lHXCdWfqt6yTwepk0DqaV3heYwX5eKqZK1CVfm0W7KvIkNKvzYL95Oftcd615ReVlIaxo8e192ie9hzNO/n9cR04dvycf9Hk5WFRVCN/15LF8ksYWzTyl7dn/bvbT/CqQQQvAMCFcrpCmvuSx8On3VE7klugrBNFMgxDTkNyGob4k7l6WSySl7VcMCwX1E4PmBaL5GG1nBEuz7gTaT3truQZ45R+f2qss7efOVbZeU4es56syXJ6aC4Nqx7W0ms69dV66mePCo67tZ/leLngesbxkz9bCbOSSv87P5Jb4Lo75XaX6mSoysjJP6875b5eVkUG+50KVsG+ahbiHqyCfL1q/qJOKipx6uCxE64wtudonvad/Lo/84QKS5wVvtdqkSJD/M5cwtjYX9GhAVUKh7UJwes8vP7663rhhRdkt9vVpUsXvfrqq+rdu3el7yN4AQDMUj6IlYUxZ/lw5pQMnaOP89TPhsoCXbn+Trm954w+ztKvboGwfB/nqfMWlRgqdjpVVGKoxGmouMTpdqy4xFCJ06mi09qKS4yT7znVVlxiuH1f7HSq2HnyHCVl35e1lR+ntO1S3mVsyCwWnTWQub56VHD85MuisiWycgumkvvPFp28g2vRqTu0VpV7f9md25PvLx9gT/aV667u2cY8eXfYWsG5Sg+6fj5RVOK6S3Uo+4TSHfkqKqn83zkvD4vCbaUBqixQRZ68Q9UsxFeRwX4KqUObXJQ4Ddkd+dp7JE97jh7X3sw8tyWMlX3WLNzmo+jQgDOXMDbxl+0ShsuqInhVYsGCBRo+fLhmzZqlmJgYTZ8+XQsXLtT27dsVFhZ2zvcSvAAAqFsMw3AFwKKToay4xD30lThPBbWyYOkeSisJveW+L3Geu9019mljlr+7Wb7NbexztBc7S8csDZul1+I0ykKu4QqhxU6n+88lFRx3ngrNpx/HuVktUliQrytANSsfrE5+bRLo02DuEhqGocO5Ba4li6VLGI9r39E87T6SV+ln1UIDvE8GsXJ3yRoHqEMzm+l3yghelYiJiVGvXr302muvSZKcTqeioqJ0//33a+LEied8L8ELAAA0ZKeCXrlAVnKhwc7pajckt7utRvm7r+W+lt3VrayvVP7ncsec5e/UnnzvaX0NnWorH4jP1tfH03pGsAoP8uE5gFWQdbzQtXTx9HB2JLegwvctGnO1ukaFXLpCz+Jis4FnDdRUaxQWFio5OVmTJk1yHbNarYqLi1NiYuIZ/QsKClRQcOofuMPhuCR1AgAA1EYWi0UeFsnDWjc/k4PaJ8TfWyH+3upylhCVW1CsfeXvkmXmac+R0p+jQ/0vfbHVrF4HryNHjqikpETh4eFux8PDw5WWlnZG/6lTp+rpp5++VOUBAAAAOCnQx1MdIm3qEFk/V5pxX7ScSZMmKTs72/Xav3+/2SUBAAAAqAfq9R2vJk2ayMPDQ+np6W7H09PTFRERcUZ/Hx8f+fj4XKryAAAAADQQ9fqOl7e3t3r06KEVK1a4jjmdTq1YsUKxsbEmVgYAAACgIanXd7wkacKECRoxYoR69uyp3r17a/r06crLy9Odd95pdmkAAAAAGoh6H7wGDRqkw4cPa/LkybLb7eratauWLVt2xoYbAAAAAFBT6v1zvC4Gz/ECAAAAIF18NqjXn/ECAAAAgNqA4AUAAAAANYzgBQAAAAA1jOAFAAAAADWM4AUAAAAANYzgBQAAAAA1jOAFAAAAADWM4AUAAAAANczT7AJqs7JnSzscDpMrAQAAAGCmskxQlhGqiuB1Djk5OZKkqKgokysBAAAAUBvk5OQoODi4yu+zGBca2RoAp9OpQ4cOKSgoSBaLxexy6jSHw6GoqCjt379fNpvN7HIaBObcHMy7OZh3czDv5mDezcG8m6M2zbthGMrJyVFkZKSs1qp/Yos7XudgtVrVokULs8uoV2w2m+n/0TQ0zLk5mHdzMO/mYN7Nwbybg3k3R22Z9wu501WGzTUAAAAAoIYRvAAAAACghhG8cEn4+Pjoqaeeko+Pj9mlNBjMuTmYd3Mw7+Zg3s3BvJuDeTdHfZp3NtcAAAAAgBrGHS8AAAAAqGEELwAAAACoYQQvAAAAAKhhBC8AAAAAqGEELwAAAACoYQSvembq1Knq1auXgoKCFBYWpoEDB2r79u1uffLz8zVmzBg1btxYgYGBuvXWW5Wenu5q37Rpk4YMGaKoqCj5+fmpffv2mjFjhtsYP/74o66++mo1btxYfn5+ateunV555ZVK6zMMQ5MnT1azZs3k5+enuLg47dy509W+Z88ejRw5Uq1bt5afn58uv/xyPfXUUyosLKx07JUrV6p79+7y8fFRmzZtNHfuXLf2Vq1ayWKxnPEaM2ZMpWNXhnmveN5zcnI0fvx4RUdHy8/PT1dddZXWrVtX6biVaahz/ttvv2no0KG68sorZbVaNX78+DP6pKam6tZbb3X9Oz99+vRK6z1fzHvF8/7ZZ5+pZ8+eCgkJUUBAgLp27aoPPvig0prPB/Ne8bzPnTv3jN/rvr6+ldZ8Ppj3iuf997///Vn/TB0wYECldVeGea943ouKivTMM8/o8ssvl6+vr7p06aJly5ZVWvP5aKjz/tlnn+mPf/yjmjZtKpvNptjYWC1fvtytz6pVq3TzzTcrMjJSFotFixYtqrTeii4C9Uh8fLzx3nvvGSkpKcbGjRuN/v37Gy1btjRyc3Ndfe69914jKirKWLFihZGUlGT06dPHuOqqq1ztc+bMMR544AFj5cqVxq5du4wPPvjA8PPzM1599VVXn/Xr1xvz5883UlJSjN27dxsffPCB4e/vb7z11lvnrO/55583goODjUWLFhmbNm0y/vznPxutW7c2Tpw4YRiGYSxdutS44447jOXLlxu7du0y/ve//xlhYWHGQw89dM5xf/31V8Pf39+YMGGCsXXrVuPVV181PDw8jGXLlrn6ZGRkGL/99pvrlZCQYEgyvvvuu6pM8Vkx7xXP+2233WZ06NDB+P77742dO3caTz31lGGz2YwDBw5UaY5P11DnfPfu3cYDDzxgzJs3z+jatasxbty4M/qsXbvWePjhh42PPvrIiIiIMF555ZXzmNHzw7xXPO/fffed8dlnnxlbt241fvnlF2P69Oln/PdwoZj3iuf9vffeM2w2m9vvd7vdfj7TWinmveJ5P3r0qNucp6SkGB4eHsZ77713HjN7bsx7xfP+6KOPGpGRkcZXX31l7Nq1y3jjjTcMX19fY/369ecztefUUOd93Lhxxr///W9j7dq1xo4dO4xJkyYZXl5ebnO6ZMkS4/HHHzc+++wzQ5Lx+eefV2VqXQhe9VxGRoYhyfj+++8NwzCMrKwsw8vLy1i4cKGrz7Zt2wxJRmJiYoXj/OMf/zCuv/76c57rlltuMf7+979X2O50Oo2IiAjjhRdecB3LysoyfHx8jI8++qjC902bNs1o3br1Oc/96KOPGh07dnQ7NmjQICM+Pr7C94wbN864/PLLDafTec6xLwTzXjrvx48fNzw8PIzFixe79enevbvx+OOPn3Psqmooc17eddddd9Y/mMuLjo6u1uB1Oub93Lp162Y88cQT5z32+WLeT3nvvfeM4ODg8x7nYjDvFXvllVeMoKAgt/9Jry7M+ynNmjUzXnvtNbdjf/3rX41hw4ad99jnqyHOe5kOHToYTz/99FnbLiZ4sdSwnsvOzpYkhYaGSpKSk5NVVFSkuLg4V5927dqpZcuWSkxMPOc4ZWOczYYNG7R69Wpdd911FfbZvXu37Ha727mDg4MVExNzUeeWpMTERLdxJSk+Pr7CcQsLC/Wf//xHd911lywWyznHvhDMe+m4xcXFKikpOWPZj5+fn3788cdzjl1VDWXOaxvm/ewMw9CKFSu0fft29e3bt1rHlpj30+Xm5io6OlpRUVH6y1/+otTU1GoZ93TMe8XmzJmjwYMHKyAgoNrHZt5PKSgouCR/pkoNd96dTqdycnJq5L8Tz2ofEbWG0+nU+PHjdfXVV6tTp06SJLvdLm9vb4WEhLj1DQ8Pl91uP+s4q1ev1oIFC/TVV1+d0daiRQsdPnxYxcXFmjJliu6+++4K6ykbPzw8/LzP/csvv+jVV1/Viy++WOG4ZWOfbVyHw6ETJ07Iz8/PrW3RokXKysrSHXfccc5xLwTzfmreg4KCFBsbq3/+859q3769wsPD9dFHHykxMVFt2rQ559hV0ZDmvDZh3s+UnZ2t5s2bq6CgQB4eHnrjjTf0xz/+sVrGLsO8u2vbtq3effdd/e53v1N2drZefPFFXXXVVUpNTVWLFi0uevwyzHvF1q5dq5SUFM2ZM6dax5WY99PFx8fr5ZdfVt++fXX55ZdrxYoV+uyzz1RSUnLRY5fXkOf9xRdfVG5urm677bYqve98cMerHhszZoxSUlL08ccfX/AYKSkp+stf/qKnnnpKN9544xntP/zwg5KSkjRr1ixNnz5dH330kSTpww8/VGBgoOv1ww8/VPncBw8e1E033aT/+7//06hRo1zHy4977733XtB1zZkzR/369VNkZOQFvf9cmHd3H3zwgQzDUPPmzeXj46OZM2dqyJAhslqr79cPc24O5v1MQUFB2rhxo9atW6d//etfmjBhglauXFnl2s6FeXcXGxur4cOHq2vXrrruuuv02WefqWnTpnrrrbeqXNu5MO8VmzNnjjp37qzevXtf0PvPhXl3N2PGDF1xxRVq166dvL29NXbsWN15553V+meq1HDnff78+Xr66af1ySefKCwsrMrnrQx3vOqpsWPHavHixVq1apXb3/hFRESosLBQWVlZbn9jkZ6eroiICLcxtm7dqhtuuEGjR4/WE088cdbztG7dWpLUuXNnpaena8qUKRoyZIj+/Oc/KyYmxtWvefPm+u2331znatasmdu5u3bt6jbuoUOHdP311+uqq67S7Nmz3do2btzo+t5ms7muq/yuOmXj2my2M+527d27V998840+++yzs17TxWDez5z3yy+/XN9//73y8vLkcDjUrFkzDRo0SJdddtlZr62qGtqc1xbM+9lZrVbX3dyuXbtq27Ztmjp1qn7/+99XaZyKMO+V8/LyUrdu3fTLL79c8BinY94rlpeXp48//ljPPPNMld9bGeb9TE2bNtWiRYuUn5+vo0ePKjIyUhMnTqy2P1OlhjvvH3/8se6++24tXLjwjI9RVJsL+mQYai2n02mMGTPGiIyMNHbs2HFGe9kHIz/99FPXsbS0tDM+GJmSkmKEhYUZjzzyyHmf++mnnzaio6PPWVtERITx4osvuo5lZ2ef8cHIAwcOGFdccYUxePBgo7i4+LzO/eijjxqdOnVyOzZkyJCzbq7x1FNPGREREUZRUdF5jX0+mPdTKpr3MpmZmUZwcHCluxdVpqHOeXlmbK7BvFdtc40777zTuO6666p8jtMx7+c/78XFxUbbtm2NBx98sMrnOB3zXvm8v/fee4aPj49x5MiRKo9dEeb9/P99LywsNC6//HJj0qRJVT7H6RryvM+fP9/w9fU1Fi1aVGlfsashytx3331GcHCwsXLlSrdtXo8fP+7qc++99xotW7Y0vv32WyMpKcmIjY01YmNjXe1btmwxmjZtavz97393GyMjI8PV57XXXjO++OILY8eOHcaOHTuMd955xwgKCqp0p7rnn3/eCAkJMf73v/8ZmzdvNv7yl7+4bQV64MABo02bNsYNN9xgHDhwwO3851K2rfkjjzxibNu2zXj99dfPuo1zSUmJ0bJlS+Oxxx477zk9H8x7xfO+bNkyY+nSpcavv/5qfP3110aXLl2MmJgYo7CwsEpzfLqGOueGYRgbNmwwNmzYYPTo0cMYOnSosWHDBiM1NdXVXlBQ4OrTrFkz4+GHHzY2bNhg7Ny587zntyLMe8Xz/txzzxlff/21sWvXLmPr1q3Giy++aHh6ehpvv/32ec9vRZj3iuf96aefdm0fnZycbAwePNjw9fV163OhmPeK573MNddcYwwaNKjS8aqCea943n/++Wfjv//9r7Fr1y5j1apVxh/+8AejdevWxrFjx853eivUUOf9ww8/NDw9PY3XX3/d7T1ZWVmuPjk5Oa5/NpKMl19+2diwYYOxd+/eKs0xwauekXTWV/nnapw4ccL4xz/+YTRq1Mjw9/c3brnlFrd/KZ966qmzjlH+byJmzpxpdOzY0fD39zdsNpvRrVs344033jBKSkrOWZ/T6TSefPJJIzw83PDx8TFuuOEGY/v27a729957r8JrqMx3331ndO3a1fD29jYuu+yysz5LZPny5YYkt3NWB+a94nlfsGCBcdlllxne3t5GRESEMWbMGLdfZheqIc95ZTXv3r37rH2q484L815xzY8//rjRpk0bw9fX12jUqJERGxtrfPzxx5VP6nlg3iuuefz48UbLli0Nb29vIzw83Ojfv3+1PNOoonMz76eU3e34+uuvKx2vKpj3imteuXKl0b59e8PHx8do3LixcfvttxsHDx6sfFLPQ0Od9+uuu+6s7xkxYoSrz3fffVdpn/NhMQzDEAAAAACgxrCrIQAAAADUMIIXAAAAANQwghcAAAAA1DCCFwAAAADUMIIXAAAAANQwghcAAAAA1DCCFwAAAADUMIIXAAAAANQwghcAAAAA1DCCFwAAAADUMIIXAAAAANSw/w8CvZcDWNGs7QAAAABJRU5ErkJggg==\n"
          },
          "metadata": {}
        }
      ],
      "source": [
        "# tweeting trend by day\n",
        "df['date'].value_counts().plot(figsize=(10,5));"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "0k-IVr5gJWaW"
      },
      "outputs": [],
      "source": [
        "# We'll go on with only Turkish tweets\n",
        "df = df[df.language =='tr']"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 530
        },
        "id": "T7IgayJ4JzGo",
        "outputId": "a6368679-744d-4a13-e04d-1ffbb033b828"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           date                                            content  \\\n",
              "180  2023-02-21  Hayatını kaybeden çocukların anısına bazı enka...   \n",
              "192  2023-02-21  Vatan hainleri yine TAG açmış: #70ildeOkullarK...   \n",
              "213  2023-02-21  2023 Bizi Sal Artık 🤦🏻‍♀️   #earthquake #turke...   \n",
              "219  2023-02-21  Türkiye'nin Güneyi ve Suriye'de 6.4 büyüklüğün...   \n",
              "257  2023-02-21  Selocum onlar istifa etmiyor. Devlet malı deni...   \n",
              "\n",
              "                                              hashtags  like_count  rt_count  \\\n",
              "180  ['earthquake', 'DEPREMANI', 'depremoldu', 'dep...      1.0000    0.0000   \n",
              "192  ['70ildeOkullarKapatılsın', 'deprem', 'earthqu...      3.0000    1.0000   \n",
              "213  ['earthquake', 'turkeyearthquake2023', 'Turkey...      0.0000    0.0000   \n",
              "219                  ['Turkey', 'earthquake', 'Syria']      0.0000    0.0000   \n",
              "257  ['earthquake', 'Erdbeben', 'depremoldu', 'Turk...      0.0000    0.0000   \n",
              "\n",
              "     followers_count isVerified language  \\\n",
              "180         149.0000      False       tr   \n",
              "192           0.0000      False       tr   \n",
              "213        1252.0000      False       tr   \n",
              "219        3338.0000      False       tr   \n",
              "257         297.0000      False       tr   \n",
              "\n",
              "                                           coordinates  \\\n",
              "180                                                NaN   \n",
              "192                                                NaN   \n",
              "213                                                NaN   \n",
              "219                                                NaN   \n",
              "257  Coordinates(longitude=40.149462, latitude=37.8...   \n",
              "\n",
              "                                                 place               source  \n",
              "180                                                NaN  Twitter for Android  \n",
              "192                                                NaN   Twitter for iPhone  \n",
              "213                                                NaN  Twitter for Android  \n",
              "219                                                NaN  Twitter for Android  \n",
              "257  Place(fullName='Diyarbakır, Türkiye', name='Di...  Twitter for Android  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-83db7895-a064-4aa4-8302-6d207a4820bf\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>date</th>\n",
              "      <th>content</th>\n",
              "      <th>hashtags</th>\n",
              "      <th>like_count</th>\n",
              "      <th>rt_count</th>\n",
              "      <th>followers_count</th>\n",
              "      <th>isVerified</th>\n",
              "      <th>language</th>\n",
              "      <th>coordinates</th>\n",
              "      <th>place</th>\n",
              "      <th>source</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>180</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>Hayatını kaybeden çocukların anısına bazı enka...</td>\n",
              "      <td>['earthquake', 'DEPREMANI', 'depremoldu', 'dep...</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>149.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>192</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>Vatan hainleri yine TAG açmış: #70ildeOkullarK...</td>\n",
              "      <td>['70ildeOkullarKapatılsın', 'deprem', 'earthqu...</td>\n",
              "      <td>3.0000</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for iPhone</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>213</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>2023 Bizi Sal Artık 🤦🏻‍♀️   #earthquake #turke...</td>\n",
              "      <td>['earthquake', 'turkeyearthquake2023', 'Turkey...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1252.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>219</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>Türkiye'nin Güneyi ve Suriye'de 6.4 büyüklüğün...</td>\n",
              "      <td>['Turkey', 'earthquake', 'Syria']</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>3338.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>Selocum onlar istifa etmiyor. Devlet malı deni...</td>\n",
              "      <td>['earthquake', 'Erdbeben', 'depremoldu', 'Turk...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>297.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>Coordinates(longitude=40.149462, latitude=37.8...</td>\n",
              "      <td>Place(fullName='Diyarbakır, Türkiye', name='Di...</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-83db7895-a064-4aa4-8302-6d207a4820bf')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-83db7895-a064-4aa4-8302-6d207a4820bf button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-83db7895-a064-4aa4-8302-6d207a4820bf');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ],
      "source": [
        "df.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "IRdnf1x3J1l6",
        "outputId": "7f442a1a-0753-4d53-f5d4-b74530b12ce4"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(134589, 11)"
            ]
          },
          "metadata": {},
          "execution_count": 30
        }
      ],
      "source": [
        "df.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "cdM6CyIswqKm",
        "outputId": "b475af3a-243e-4969-fbb4-6c3e75561830"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(132934, 11)"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ],
      "source": [
        "# remove duplicate tweets\n",
        "df.drop_duplicates('content', inplace=True)\n",
        "df.shape"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "###Data Cleaning"
      ],
      "metadata": {
        "id": "RlDAkM8F8o1P"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "caID6miehRQM"
      },
      "outputs": [],
      "source": [
        "def preprocess_word(word):\n",
        "    \n",
        "    # Convert more than 2 letter repetitions to 2 letter\n",
        "    word = re.sub(r'(.)\\1+', r'\\1\\1', word)\n",
        "    # Remove - & '\n",
        "    word = re.sub(r'(-|\\')', '', word)\n",
        "    return word\n",
        "\n",
        "def is_valid_word(word):\n",
        "    # Check the validity of the word according to the Turkish alphabet\n",
        "    return (re.search(r'^[a-zA-Z0-9ğüışöçIİĞÜŞÖÇ]+$', word) is not None)\n",
        "\n",
        "def remove_emoji(tweet):\n",
        "  \n",
        "  # Positive emojis\n",
        "  tweet = re.sub(r'(:\\s?\\)|:-\\)|\\(\\s?:|\\(-:|:\\'\\)|:\\s?D|:-D|x-?D|X-?D|<3|:\\*)', '', tweet)\n",
        "  # Negative emojis\n",
        "  tweet = re.sub(r'(;-?\\)|;-?D|\\(-?;)|:\\s?\\(|:-\\(|\\)\\s?:|\\)-:|:,\\(|:\\'\\(|:\"\\(', '', tweet)\n",
        "\n",
        "  emoji_pattern = re.compile(\n",
        "    '['\n",
        "    u'\\U0001F600-\\U0001F64F'  # emoticons\n",
        "    u'\\U0001F300-\\U0001F5FF'  # symbols & pictographs\n",
        "    u'\\U0001F680-\\U0001F6FF'  # transport & map symbols\n",
        "    u'\\U0001F1E0-\\U0001F1FF'  # flags (iOS)\n",
        "    u'\\U00002702-\\U000027B0'\n",
        "    u'\\U000024C2-\\U0001F251'\n",
        "    ']+',\n",
        "    flags=re.UNICODE)\n",
        "  \n",
        "  tweet = emoji_pattern.sub(r'', tweet)\n",
        "  \n",
        "  return tweet\n",
        "\n",
        "def preprocess_tweet(tweet):\n",
        "    processed_tweet = []\n",
        "    # Convert to lower case\n",
        "    tweet = tweet.lower()\n",
        "    \n",
        "    #Clean only digits\n",
        "    tweet = re.sub(\"^\\d+\\s|\\s\\d+\\s|\\s\\d+$\", \" \", tweet)\n",
        "\n",
        "    # Remove URLs, user mentions and hashtags\n",
        "    tweet = re.sub(r'((www\\.[\\S]+)|(https?://[\\S]+)|(@[\\S]+)|(#(\\S+)))', '', tweet)\n",
        "    \n",
        "    # Remove RT (retweet)\n",
        "    tweet = re.sub(r'\\brt\\b', '', tweet)\n",
        "    \n",
        "    # Replace 2+ dots with space\n",
        "    tweet = re.sub(r'\\.{2,}', ' ', tweet)\n",
        "    \n",
        "    # Strip space, \" and ' from tweet\n",
        "    tweet = tweet.strip(' \"\\'')\n",
        "\n",
        "    #remove emojis\n",
        "    tweet = remove_emoji(tweet)\n",
        "    \n",
        "    # Replace multiple spaces with a single space\n",
        "    tweet = re.sub(r'\\s+', ' ', tweet)\n",
        "    words = tweet.split()\n",
        "\n",
        "    for word in words:\n",
        "      word = preprocess_word(word)\n",
        "      if is_valid_word(word):      \n",
        "        processed_tweet.append(word)\n",
        "\n",
        "    return ' '.join(processed_tweet)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "ccmcZuczZcGl"
      },
      "outputs": [],
      "source": [
        "df[\"content\"] = df.content.map(preprocess_tweet)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 547
        },
        "id": "RzI0DJUirN-b",
        "outputId": "127ccf4a-7be0-462a-9144-03872b7d8e69"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           date                                            content  \\\n",
              "180  2023-02-21  hayatını kaybeden çocukların anısına bazı enka...   \n",
              "192  2023-02-21  vatan hainleri yine tag en okullar açik açik m...   \n",
              "213  2023-02-21                                     bizi sal artık   \n",
              "219  2023-02-21  türkiyenin güneyi ve suriyede büyüklüğündeki d...   \n",
              "257  2023-02-21  selocum onlar istifa devlet malı deniz yemeyen...   \n",
              "\n",
              "                                              hashtags  like_count  rt_count  \\\n",
              "180  ['earthquake', 'DEPREMANI', 'depremoldu', 'dep...      1.0000    0.0000   \n",
              "192  ['70ildeOkullarKapatılsın', 'deprem', 'earthqu...      3.0000    1.0000   \n",
              "213  ['earthquake', 'turkeyearthquake2023', 'Turkey...      0.0000    0.0000   \n",
              "219                  ['Turkey', 'earthquake', 'Syria']      0.0000    0.0000   \n",
              "257  ['earthquake', 'Erdbeben', 'depremoldu', 'Turk...      0.0000    0.0000   \n",
              "\n",
              "     followers_count isVerified language  \\\n",
              "180         149.0000      False       tr   \n",
              "192           0.0000      False       tr   \n",
              "213        1252.0000      False       tr   \n",
              "219        3338.0000      False       tr   \n",
              "257         297.0000      False       tr   \n",
              "\n",
              "                                           coordinates  \\\n",
              "180                                                NaN   \n",
              "192                                                NaN   \n",
              "213                                                NaN   \n",
              "219                                                NaN   \n",
              "257  Coordinates(longitude=40.149462, latitude=37.8...   \n",
              "\n",
              "                                                 place               source  \n",
              "180                                                NaN  Twitter for Android  \n",
              "192                                                NaN   Twitter for iPhone  \n",
              "213                                                NaN  Twitter for Android  \n",
              "219                                                NaN  Twitter for Android  \n",
              "257  Place(fullName='Diyarbakır, Türkiye', name='Di...  Twitter for Android  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c8ed3ecf-2635-4d76-b663-3ac26bef4b8f\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>date</th>\n",
              "      <th>content</th>\n",
              "      <th>hashtags</th>\n",
              "      <th>like_count</th>\n",
              "      <th>rt_count</th>\n",
              "      <th>followers_count</th>\n",
              "      <th>isVerified</th>\n",
              "      <th>language</th>\n",
              "      <th>coordinates</th>\n",
              "      <th>place</th>\n",
              "      <th>source</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>180</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>hayatını kaybeden çocukların anısına bazı enka...</td>\n",
              "      <td>['earthquake', 'DEPREMANI', 'depremoldu', 'dep...</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>149.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>192</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>vatan hainleri yine tag en okullar açik açik m...</td>\n",
              "      <td>['70ildeOkullarKapatılsın', 'deprem', 'earthqu...</td>\n",
              "      <td>3.0000</td>\n",
              "      <td>1.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for iPhone</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>213</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>bizi sal artık</td>\n",
              "      <td>['earthquake', 'turkeyearthquake2023', 'Turkey...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>1252.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>219</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>türkiyenin güneyi ve suriyede büyüklüğündeki d...</td>\n",
              "      <td>['Turkey', 'earthquake', 'Syria']</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>3338.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>2023-02-21</td>\n",
              "      <td>selocum onlar istifa devlet malı deniz yemeyen...</td>\n",
              "      <td>['earthquake', 'Erdbeben', 'depremoldu', 'Turk...</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>297.0000</td>\n",
              "      <td>False</td>\n",
              "      <td>tr</td>\n",
              "      <td>Coordinates(longitude=40.149462, latitude=37.8...</td>\n",
              "      <td>Place(fullName='Diyarbakır, Türkiye', name='Di...</td>\n",
              "      <td>Twitter for Android</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c8ed3ecf-2635-4d76-b663-3ac26bef4b8f')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c8ed3ecf-2635-4d76-b663-3ac26bef4b8f button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c8ed3ecf-2635-4d76-b663-3ac26bef4b8f');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ],
      "source": [
        "df.head()"
      ]
    }
  ]
}