CSV_Sentiment.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Untitled35.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyPjo5Xj5hI2Xsoi8q2xM4r/",
      "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/SatadruMukherjee/Data-Preprocessing-Models/blob/main/CSV_Sentiment.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install boto3"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-tfpqAHDSe40",
        "outputId": "d42905ed-3287-4df6-e710-a87a565f2ac4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Collecting boto3\n",
            "  Downloading boto3-1.21.27-py3-none-any.whl (132 kB)\n",
            "\u001b[?25l\r\u001b[K     |██▌                             | 10 kB 19.3 MB/s eta 0:00:01\r\u001b[K     |█████                           | 20 kB 14.4 MB/s eta 0:00:01\r\u001b[K     |███████▍                        | 30 kB 9.8 MB/s eta 0:00:01\r\u001b[K     |██████████                      | 40 kB 3.8 MB/s eta 0:00:01\r\u001b[K     |████████████▍                   | 51 kB 3.9 MB/s eta 0:00:01\r\u001b[K     |██████████████▉                 | 61 kB 4.5 MB/s eta 0:00:01\r\u001b[K     |█████████████████▍              | 71 kB 4.8 MB/s eta 0:00:01\r\u001b[K     |███████████████████▉            | 81 kB 5.0 MB/s eta 0:00:01\r\u001b[K     |██████████████████████▎         | 92 kB 5.6 MB/s eta 0:00:01\r\u001b[K     |████████████████████████▊       | 102 kB 4.4 MB/s eta 0:00:01\r\u001b[K     |███████████████████████████▎    | 112 kB 4.4 MB/s eta 0:00:01\r\u001b[K     |█████████████████████████████▊  | 122 kB 4.4 MB/s eta 0:00:01\r\u001b[K     |████████████████████████████████| 132 kB 4.4 MB/s \n",
            "\u001b[?25hCollecting s3transfer<0.6.0,>=0.5.0\n",
            "  Downloading s3transfer-0.5.2-py3-none-any.whl (79 kB)\n",
            "\u001b[K     |████████████████████████████████| 79 kB 7.2 MB/s \n",
            "\u001b[?25hCollecting jmespath<2.0.0,>=0.7.1\n",
            "  Downloading jmespath-1.0.0-py3-none-any.whl (23 kB)\n",
            "Collecting botocore<1.25.0,>=1.24.27\n",
            "  Downloading botocore-1.24.27-py3-none-any.whl (8.6 MB)\n",
            "\u001b[K     |████████████████████████████████| 8.6 MB 48.1 MB/s \n",
            "\u001b[?25hCollecting urllib3<1.27,>=1.25.4\n",
            "  Downloading urllib3-1.26.9-py2.py3-none-any.whl (138 kB)\n",
            "\u001b[K     |████████████████████████████████| 138 kB 62.4 MB/s \n",
            "\u001b[?25hRequirement already satisfied: python-dateutil<3.0.0,>=2.1 in /usr/local/lib/python3.7/dist-packages (from botocore<1.25.0,>=1.24.27->boto3) (2.8.2)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil<3.0.0,>=2.1->botocore<1.25.0,>=1.24.27->boto3) (1.15.0)\n",
            "Installing collected packages: urllib3, jmespath, botocore, s3transfer, boto3\n",
            "  Attempting uninstall: urllib3\n",
            "    Found existing installation: urllib3 1.24.3\n",
            "    Uninstalling urllib3-1.24.3:\n",
            "      Successfully uninstalled urllib3-1.24.3\n",
            "\u001b[31mERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.\n",
            "requests 2.23.0 requires urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1, but you have urllib3 1.26.9 which is incompatible.\n",
            "datascience 0.10.6 requires folium==0.2.1, but you have folium 0.8.3 which is incompatible.\u001b[0m\n",
            "Successfully installed boto3-1.21.27 botocore-1.24.27 jmespath-1.0.0 s3transfer-0.5.2 urllib3-1.26.9\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "DJ606VjrPknY"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import boto3"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "aws_access_key=\"\"\n",
        "aws_secret_key=\"\""
      ],
      "metadata": {
        "id": "VGJDLObNSOJB"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "session = boto3.Session(aws_access_key_id=aws_access_key,\n",
        "    aws_secret_access_key=aws_secret_key,\n",
        "    region_name='us-east-1'\n",
        ")\n",
        "comprehend = session.client(service_name='comprehend')\n"
      ],
      "metadata": {
        "id": "Wx-uPcy7Rm0q"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "ms=pd.read_csv('/content/dummy_dataset.csv')"
      ],
      "metadata": {
        "id": "j7b_fTuZRSlv"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "ms.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "qnLL01wSRWUZ",
        "outputId": "64055de5-a196-40c6-c5d6-6e63079cfafb"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           publish_time                                            content  \\\n",
              "0  2022-03-26T05:19:13Z  A senior White House official says Indias posi...   \n",
              "1  2022-03-26T07:00:29Z  Evelyn Frison was delighted to receive a surpr...   \n",
              "2  2022-03-26T11:03:45Z  As with questions of replacing Russian oil and...   \n",
              "3  2022-03-27T04:00:15Z  International nurses working for NHS trusts an...   \n",
              "4  2022-03-26T04:59:50Z  (CNN)Tonight, for the 15th consecutive year, p...   \n",
              "\n",
              "                                                 url  \n",
              "0  https://www.aljazeera.com/news/2022/3/26/unsat...  \n",
              "1  https://www.fastcompany.com/90734896/evening-g...  \n",
              "2  https://nationalpost.com/news/world/russia-ukr...  \n",
              "3  https://amp.theguardian.com/society/2022/mar/2...  \n",
              "4  https://www.cnn.com/2022/03/26/world/earth-hou...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a3f6821e-3fe2-4635-afc7-fec1d147e580\">\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>publish_time</th>\n",
              "      <th>content</th>\n",
              "      <th>url</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022-03-26T05:19:13Z</td>\n",
              "      <td>A senior White House official says Indias posi...</td>\n",
              "      <td>https://www.aljazeera.com/news/2022/3/26/unsat...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2022-03-26T07:00:29Z</td>\n",
              "      <td>Evelyn Frison was delighted to receive a surpr...</td>\n",
              "      <td>https://www.fastcompany.com/90734896/evening-g...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2022-03-26T11:03:45Z</td>\n",
              "      <td>As with questions of replacing Russian oil and...</td>\n",
              "      <td>https://nationalpost.com/news/world/russia-ukr...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2022-03-27T04:00:15Z</td>\n",
              "      <td>International nurses working for NHS trusts an...</td>\n",
              "      <td>https://amp.theguardian.com/society/2022/mar/2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2022-03-26T04:59:50Z</td>\n",
              "      <td>(CNN)Tonight, for the 15th consecutive year, p...</td>\n",
              "      <td>https://www.cnn.com/2022/03/26/world/earth-hou...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a3f6821e-3fe2-4635-afc7-fec1d147e580')\"\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-a3f6821e-3fe2-4635-afc7-fec1d147e580 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-a3f6821e-3fe2-4635-afc7-fec1d147e580');\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": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def getSentiment(sentence):\n",
        "    detected_sentiment=comprehend.detect_sentiment(Text=sentence, LanguageCode='en')['Sentiment']\n",
        "    return detected_sentiment"
      ],
      "metadata": {
        "id": "9B5rAdeFRXwk"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "ms['sentiment_detected']=ms['content'].apply(getSentiment)"
      ],
      "metadata": {
        "id": "U2iU8yuDR1ch"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "ms.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1100
        },
        "id": "59la4zEnS_n2",
        "outputId": "74e022cf-1d4b-4b39-c469-de200984d0bc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            publish_time                                            content  \\\n",
              "0   2022-03-26T05:19:13Z  A senior White House official says Indias posi...   \n",
              "1   2022-03-26T07:00:29Z  Evelyn Frison was delighted to receive a surpr...   \n",
              "2   2022-03-26T11:03:45Z  As with questions of replacing Russian oil and...   \n",
              "3   2022-03-27T04:00:15Z  International nurses working for NHS trusts an...   \n",
              "4   2022-03-26T04:59:50Z  (CNN)Tonight, for the 15th consecutive year, p...   \n",
              "5   2022-03-26T07:05:01Z  The Samsung Galaxy M33unveiled earlier this mo...   \n",
              "6   2022-03-26T08:00:51Z  The latest edition of the Indian Premier Leagu...   \n",
              "7   2022-03-26T11:00:00Z  At a barbecue restaurant in Lviv called Meat a...   \n",
              "8   2022-03-26T16:10:01Z  We reviewed the iQOO 9 Prounveiled in January ...   \n",
              "9   2022-03-26T16:12:00Z  KATHMANDU, March 26 (Reuters) - China and Nepa...   \n",
              "10  2022-03-26T17:18:00Z  MUMBAI, March 26 (Reuters) - Softbank Group-ba...   \n",
              "11  2022-03-26T18:10:00Z  MUMBAI, March 26 (Reuters) - The expanded Indi...   \n",
              "12  2022-03-26T18:22:03Z  Openly acknowledged or not, regime change in M...   \n",
              "13  2022-03-26T19:47:36Z  FLORIDA The newest COVID-19 subvariant is maki...   \n",
              "14  2022-03-27T00:31:23Z  By Meryl SebastianBBC News, Delhi\\r\\nImage sou...   \n",
              "15  2022-03-27T00:41:59Z  Myanmars military usually marks Armed Forces D...   \n",
              "16  2022-03-27T02:41:00Z  HONG KONG, March 27 (Reuters) - Hong Kong said...   \n",
              "17  2022-03-27T04:58:03Z  <table><tr><th>Women's World Cup, Wellington</...   \n",
              "18  2022-03-27T06:29:33Z  England are through to the semi-finals at the ...   \n",
              "19  2022-03-26T13:44:00Z  The Oscar-nominated documentary Writing With F...   \n",
              "\n",
              "                                                  url sentiment_detected  \n",
              "0   https://www.aljazeera.com/news/2022/3/26/unsat...            NEUTRAL  \n",
              "1   https://www.fastcompany.com/90734896/evening-g...           POSITIVE  \n",
              "2   https://nationalpost.com/news/world/russia-ukr...            NEUTRAL  \n",
              "3   https://amp.theguardian.com/society/2022/mar/2...            NEUTRAL  \n",
              "4   https://www.cnn.com/2022/03/26/world/earth-hou...            NEUTRAL  \n",
              "5   https://www.gsmarena.com/samsung_galaxy_m33_5g...            NEUTRAL  \n",
              "6   https://amp.theguardian.com/sport/blog/2022/ma...           POSITIVE  \n",
              "7   https://www.nybooks.com/daily/2022/03/26/among...            NEUTRAL  \n",
              "8   https://www.gsmarena.com/iqoo_9_in_for_review-...            NEUTRAL  \n",
              "9   https://www.reuters.com/world/asia-pacific/chi...            NEUTRAL  \n",
              "10  https://www.reuters.com/world/india/indias-ola...            NEUTRAL  \n",
              "11  https://www.reuters.com/lifestyle/sports/kolka...            NEUTRAL  \n",
              "12  https://amp.theguardian.com/commentisfree/2022...            NEUTRAL  \n",
              "13  https://patch.com/florida/stpete/covid-19-subv...            NEUTRAL  \n",
              "14  https://www.bbc.co.uk/news/world-asia-india-60...            NEUTRAL  \n",
              "15  https://www.aljazeera.com/news/2022/3/27/holds...            NEUTRAL  \n",
              "16  https://www.reuters.com/world/asia-pacific/hon...            NEUTRAL  \n",
              "17       https://www.bbc.co.uk/sport/cricket/60890065            NEUTRAL  \n",
              "18  https://amp.theguardian.com/sport/2022/mar/27/...            NEUTRAL  \n",
              "19  https://www.npr.org/sections/goatsandsoda/2022...            NEUTRAL  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b0a5a332-10fb-4834-a810-e753e4deebca\">\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>publish_time</th>\n",
              "      <th>content</th>\n",
              "      <th>url</th>\n",
              "      <th>sentiment_detected</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022-03-26T05:19:13Z</td>\n",
              "      <td>A senior White House official says Indias posi...</td>\n",
              "      <td>https://www.aljazeera.com/news/2022/3/26/unsat...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2022-03-26T07:00:29Z</td>\n",
              "      <td>Evelyn Frison was delighted to receive a surpr...</td>\n",
              "      <td>https://www.fastcompany.com/90734896/evening-g...</td>\n",
              "      <td>POSITIVE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2022-03-26T11:03:45Z</td>\n",
              "      <td>As with questions of replacing Russian oil and...</td>\n",
              "      <td>https://nationalpost.com/news/world/russia-ukr...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2022-03-27T04:00:15Z</td>\n",
              "      <td>International nurses working for NHS trusts an...</td>\n",
              "      <td>https://amp.theguardian.com/society/2022/mar/2...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2022-03-26T04:59:50Z</td>\n",
              "      <td>(CNN)Tonight, for the 15th consecutive year, p...</td>\n",
              "      <td>https://www.cnn.com/2022/03/26/world/earth-hou...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>2022-03-26T07:05:01Z</td>\n",
              "      <td>The Samsung Galaxy M33unveiled earlier this mo...</td>\n",
              "      <td>https://www.gsmarena.com/samsung_galaxy_m33_5g...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>2022-03-26T08:00:51Z</td>\n",
              "      <td>The latest edition of the Indian Premier Leagu...</td>\n",
              "      <td>https://amp.theguardian.com/sport/blog/2022/ma...</td>\n",
              "      <td>POSITIVE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>2022-03-26T11:00:00Z</td>\n",
              "      <td>At a barbecue restaurant in Lviv called Meat a...</td>\n",
              "      <td>https://www.nybooks.com/daily/2022/03/26/among...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>2022-03-26T16:10:01Z</td>\n",
              "      <td>We reviewed the iQOO 9 Prounveiled in January ...</td>\n",
              "      <td>https://www.gsmarena.com/iqoo_9_in_for_review-...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>2022-03-26T16:12:00Z</td>\n",
              "      <td>KATHMANDU, March 26 (Reuters) - China and Nepa...</td>\n",
              "      <td>https://www.reuters.com/world/asia-pacific/chi...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>2022-03-26T17:18:00Z</td>\n",
              "      <td>MUMBAI, March 26 (Reuters) - Softbank Group-ba...</td>\n",
              "      <td>https://www.reuters.com/world/india/indias-ola...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>2022-03-26T18:10:00Z</td>\n",
              "      <td>MUMBAI, March 26 (Reuters) - The expanded Indi...</td>\n",
              "      <td>https://www.reuters.com/lifestyle/sports/kolka...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>2022-03-26T18:22:03Z</td>\n",
              "      <td>Openly acknowledged or not, regime change in M...</td>\n",
              "      <td>https://amp.theguardian.com/commentisfree/2022...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>2022-03-26T19:47:36Z</td>\n",
              "      <td>FLORIDA The newest COVID-19 subvariant is maki...</td>\n",
              "      <td>https://patch.com/florida/stpete/covid-19-subv...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>2022-03-27T00:31:23Z</td>\n",
              "      <td>By Meryl SebastianBBC News, Delhi\\r\\nImage sou...</td>\n",
              "      <td>https://www.bbc.co.uk/news/world-asia-india-60...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>2022-03-27T00:41:59Z</td>\n",
              "      <td>Myanmars military usually marks Armed Forces D...</td>\n",
              "      <td>https://www.aljazeera.com/news/2022/3/27/holds...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>2022-03-27T02:41:00Z</td>\n",
              "      <td>HONG KONG, March 27 (Reuters) - Hong Kong said...</td>\n",
              "      <td>https://www.reuters.com/world/asia-pacific/hon...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>2022-03-27T04:58:03Z</td>\n",
              "      <td>&lt;table&gt;&lt;tr&gt;&lt;th&gt;Women's World Cup, Wellington&lt;/...</td>\n",
              "      <td>https://www.bbc.co.uk/sport/cricket/60890065</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>2022-03-27T06:29:33Z</td>\n",
              "      <td>England are through to the semi-finals at the ...</td>\n",
              "      <td>https://amp.theguardian.com/sport/2022/mar/27/...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>2022-03-26T13:44:00Z</td>\n",
              "      <td>The Oscar-nominated documentary Writing With F...</td>\n",
              "      <td>https://www.npr.org/sections/goatsandsoda/2022...</td>\n",
              "      <td>NEUTRAL</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b0a5a332-10fb-4834-a810-e753e4deebca')\"\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-b0a5a332-10fb-4834-a810-e753e4deebca 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-b0a5a332-10fb-4834-a810-e753e4deebca');\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": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        ""
      ],
      "metadata": {
        "id": "pyY-gu9mTCJa"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}