input_csv_basic_pipe.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "CfbKLFzo_PH_"
      },
      "outputs": [],
      "source": [
        "# install transformers library (uncomment the line below if needed)\n",
        "\n",
        "#!pip install datasets transformers[sentencepiece]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 10,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JXC3jvZHgEBp",
        "outputId": "1c121418-1683-4c0b-8834-3baf0d7bd2ab"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ],
      "source": [
        "# connect to google drive\n",
        "\n",
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "yQSGHMoeB4Pj",
        "outputId": "153a5ef0-8c8b-485c-ee79-179312752c59"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "No model was supplied, defaulted to distilbert-base-uncased-finetuned-sst-2-english (https://huggingface.co/distilbert-base-uncased-finetuned-sst-2-english)\n"
          ]
        },
        {
          "data": {
            "text/plain": [
              "[{'label': 'POSITIVE', 'score': 0.9208967685699463}]"
            ]
          },
          "execution_count": 11,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "from transformers import pipeline\n",
        "\n",
        "# create a classifier instance\n",
        "classifier = pipeline(\"sentiment-analysis\")\n",
        "# test the classifier\n",
        "classifier(\"Elon Musk did some stuff and made some money, but he also created the life of a puppy.\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 59,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "zh_ppNrCJyb4",
        "outputId": "e4186420-f0a9-44e1-cf3f-63cb0456a01f"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-6e6a10ce-b6d1-4a97-baea-a8e69d058b7c\">\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>Unnamed: 0</th>\n",
              "      <th>summary</th>\n",
              "      <th>country</th>\n",
              "      <th>author</th>\n",
              "      <th>link</th>\n",
              "      <th>language</th>\n",
              "      <th>media</th>\n",
              "      <th>title</th>\n",
              "      <th>media_content</th>\n",
              "      <th>clean_url</th>\n",
              "      <th>rights</th>\n",
              "      <th>rank</th>\n",
              "      <th>topic</th>\n",
              "      <th>published_date</th>\n",
              "      <th>_id</th>\n",
              "      <th>_score</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>North Hills,United States - June 7, 2022 /Pres...</td>\n",
              "      <td>US</td>\n",
              "      <td>Press Release Distribution Service</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://storage.googleapis.com/mmstudio-images...</td>\n",
              "      <td>US Gold IRA 401k Rollover 2022 Retirement Savi...</td>\n",
              "      <td>['https://storage.googleapis.com/mmstudio-imag...</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>4400</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 08:07:00</td>\n",
              "      <td>0e231495fc121d3516dc45e6591ab240</td>\n",
              "      <td>11.909276</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>By The Daily Upside - May 31, 2022 at 9:00PM Y...</td>\n",
              "      <td>US</td>\n",
              "      <td>newsfeedback@fool.com (The Daily Upside)</td>\n",
              "      <td>https://www.fool.com/investing/2022/05/31/sout...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://g.foolcdn.com/editorial/images/682824/...</td>\n",
              "      <td>South Africa's Gold Fields Buying Canada's Yam...</td>\n",
              "      <td>['https://g.foolcdn.com/misc-assets/logo-tmf-p...</td>\n",
              "      <td>fool.com</td>\n",
              "      <td>Copyright 1995-2022 The Motley Fool. All right...</td>\n",
              "      <td>673</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 01:00:13</td>\n",
              "      <td>428ae5b8ea67a469b41b478429b4a605</td>\n",
              "      <td>11.749602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>(ASA)   Report April 30, 2022 Shares Ticker AS...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ASA...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>ASA Gold and Precious Metals : Monthly Factshe...</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 19:32:06</td>\n",
              "      <td>3842fc656882661641ae53e72233910b</td>\n",
              "      <td>11.638879</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>Oat_Phawat/iStock via Getty Images Part I - In...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://seekingalpha.com/article/4515405-new-g...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://static.seekingalpha.com/cdn/s3/uploads...</td>\n",
              "      <td>New Gold: Lower Grade And Tonnes Processed At ...</td>\n",
              "      <td>['https://static.seekingalpha.com/uploads/2022...</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>892</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 10:54:49</td>\n",
              "      <td>d4ea9a8a5d62a4d7157b23df7f183af7</td>\n",
              "      <td>11.604368</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>Gold Fields Limited GFI and Yamana Gold Inc. A...</td>\n",
              "      <td>US</td>\n",
              "      <td>Zacks Equity Research</td>\n",
              "      <td>https://finance.yahoo.com/news/gold-fields-gfi...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://s.yimg.com/uu/api/res/1.2/G5XrE0LCS4YC...</td>\n",
              "      <td>Gold Fields (GFI) to Acquire Yamana Gold for $...</td>\n",
              "      <td>['https://s.yimg.com/cv/apiv2/default/20190501...</td>\n",
              "      <td>yahoo.com</td>\n",
              "      <td>yahoo.com</td>\n",
              "      <td>31</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 14:04:02</td>\n",
              "      <td>6e9c2ce7e93d4bb7a340564b36787d89</td>\n",
              "      <td>11.520050</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>5</td>\n",
              "      <td>Four companies won the licences - Lotus Gold, ...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/news/latest/Egy...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Egypt awards eight gold and metal mining explo...</td>\n",
              "      <td>['https://www.marketscreener.com/images/img_fo...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 09:41:08</td>\n",
              "      <td>12384bf62321340d06de9c80af21cce8</td>\n",
              "      <td>11.433958</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>6</td>\n",
              "      <td>adventtr/E+ via Getty Images Gold and silver a...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://seekingalpha.com/article/4515483-buyin...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://static.seekingalpha.com/cdn/s3/uploads...</td>\n",
              "      <td>Buying Physical Gold And Silver: Here Is What ...</td>\n",
              "      <td>['data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP...</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>892</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 16:11:53</td>\n",
              "      <td>f7c54993ae8183d2f3fa0b9606b48107</td>\n",
              "      <td>11.371989</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>7</td>\n",
              "      <td>GGCM has recently launched a Gold Guaranteed C...</td>\n",
              "      <td>US</td>\n",
              "      <td>Get News</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>GGCM develops a crypto platform for the cause ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4400</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 01:30:00</td>\n",
              "      <td>6b4c76f4f2e3c4c269a0f87184c9b72f</td>\n",
              "      <td>11.321525</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>8</td>\n",
              "      <td>Cetera Investment Advisers lessened its stake ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Joseph Griffin</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>Cetera Investment Advisers Sells 8,195 Shares ...</td>\n",
              "      <td>['https://c.statcounter.com/8291392/0/b2ca9722...</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>559448</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-06 07:55:51</td>\n",
              "      <td>7d4820c53df06bb014c199a4fdc657e9</td>\n",
              "      <td>11.053978</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>9</td>\n",
              "      <td>(KSN)   Report ASX: KSN Asia-Pacific Gold Prod...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/KIN...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Kingston Resources : Investor Presentation – R...</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 08:12:11</td>\n",
              "      <td>256306fb293e4a24e5ff07ca8ac87705</td>\n",
              "      <td>11.031989</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>10</td>\n",
              "      <td>June 1, 2022 (Investorideas.com Newswire) With...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.streetwisereports.com/images/White...</td>\n",
              "      <td>Yukon Explorer Looking to Start New Gold Rush</td>\n",
              "      <td>['https://www.investorideas.com/images/logos/t...</td>\n",
              "      <td>investorideas.com</td>\n",
              "      <td>C2000-2022 InvestorIdeas.com tm</td>\n",
              "      <td>51454</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 15:05:00</td>\n",
              "      <td>c9b2a94d1d7e7c675fd7271f8def6032</td>\n",
              "      <td>11.024569</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>11</td>\n",
              "      <td>Red Cloud's Mining Analyst to Interview Chairm...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/U-S...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>U.S. Gold Corp. Announces Live Webinar Hosted ...</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 12:48:04</td>\n",
              "      <td>b0261762b0754e66022feead05acd3cf</td>\n",
              "      <td>10.982766</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>12</td>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY – Get Rating) was...</td>\n",
              "      <td>US</td>\n",
              "      <td>Joseph Griffin</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...</td>\n",
              "      <td>['https://www.americanbankingnews.com/wp-conte...</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>559448</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-02 01:54:42</td>\n",
              "      <td>d408731732a7e73fc05d396cffe2f652</td>\n",
              "      <td>10.968813</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>13</td>\n",
              "      <td>Return of Shiba, the revolutionary blockchain ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Get News</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.getnews.info/uploads/a0471094df1da...</td>\n",
              "      <td>ShibDOSH – The World's First Gold Paying Rebas...</td>\n",
              "      <td>['https://www.getnews.info/uploads/a0471094df1...</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>4400</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-06 12:54:02</td>\n",
              "      <td>4937405351e131e11fcecb7a44bf225e</td>\n",
              "      <td>10.861591</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>14</td>\n",
              "      <td>Public Sector Pension Investment Board decreas...</td>\n",
              "      <td>US</td>\n",
              "      <td>Ethan Ryder</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>Public Sector Pension Investment Board Sells 2...</td>\n",
              "      <td>['https://c.statcounter.com/9021069/0/fdde5482...</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>559448</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-03 07:56:44</td>\n",
              "      <td>fc786d20f1b85b06b3deb61cc6d96c79</td>\n",
              "      <td>10.856547</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>15</td>\n",
              "      <td>SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...</td>\n",
              "      <td>US</td>\n",
              "      <td>Guskin Gold Corp. via AccessWire</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.accesswire.com/img.ashx?id=703263</td>\n",
              "      <td>Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...</td>\n",
              "      <td>['https://tracking.newsrpm.com/pixel?slug=acce...</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>4400</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 11:30:00</td>\n",
              "      <td>19fa03834f568387d0cedf9e90f94342</td>\n",
              "      <td>10.804963</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>16</td>\n",
              "      <td>(WRN)   Report TSX WRN NYSE AMERICAN WRN DEVEL...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/WES...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Western Copper and Gold : June 2022 Presentation</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-05 21:22:02</td>\n",
              "      <td>f2e81adc90869a5938af2e026339dda7</td>\n",
              "      <td>10.738883</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>17</td>\n",
              "      <td>Harmony Gold Mining (NYSE:HMY – Get Rating) wa...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Editor</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/zack...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://forextv.com/wp-content/uploads/2014/02...</td>\n",
              "      <td>Zacks Investment Research Downgrades Harmony G...</td>\n",
              "      <td>['https://assets.pinterest.com/images/PinExt.p...</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>122188</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-06 16:31:54</td>\n",
              "      <td>09c1eb4bb44090724d0654e63091625f</td>\n",
              "      <td>10.726349</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>18</td>\n",
              "      <td>HighTower Advisors LLC reduced its position in...</td>\n",
              "      <td>US</td>\n",
              "      <td>Joseph Griffin</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>HighTower Advisors LLC Sells 54,389 Shares of ...</td>\n",
              "      <td>['https://www.americanbankingnews.com/wp-conte...</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>559448</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 05:22:41</td>\n",
              "      <td>b919e626e193c987fa9421b14f7d5989</td>\n",
              "      <td>10.716049</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>19</td>\n",
              "      <td>(VGCX)   Report Discover Companies to Invest I...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/VIC...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>BTV Showcases Victoria Gold, Advance United, T...</td>\n",
              "      <td>['https://www.marketscreener.com/images/share/...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-02 13:05:01</td>\n",
              "      <td>024982c6f49e17c3ba4529a99e398542</td>\n",
              "      <td>10.694183</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>20</td>\n",
              "      <td>Gold price today (June 5, 2022) decreased marg...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Editor</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://forextv.com/wp-content/uploads/2014/02...</td>\n",
              "      <td>Gold price today, June 5: Gold rates drop afte...</td>\n",
              "      <td>['https://assets.pinterest.com/images/PinExt.p...</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>122188</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-05 02:31:04</td>\n",
              "      <td>a3280cba845a24a8e4aa78d2bdfde9bd</td>\n",
              "      <td>10.673847</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>21</td>\n",
              "      <td>chonticha wat/iStock via Getty Images iShares ...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://seekingalpha.com/article/4516774-ring-...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://static.seekingalpha.com/cdn/s3/uploads...</td>\n",
              "      <td>RING (RING): Gold Mining Companies Are Probabl...</td>\n",
              "      <td>['https://static.seekingalpha.com/uploads/2022...</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>892</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 04:09:45</td>\n",
              "      <td>3f68ca870a80d6f9df53449b3c0fe665</td>\n",
              "      <td>10.671701</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>22</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Gold Fields to Acquire Yamana Gold – a Combina...</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 05:45:01</td>\n",
              "      <td>301e50ee2ce13655618dd7a75382f515</td>\n",
              "      <td>10.645185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>23</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>REPEAT -- Gold Fields to Acquire Yamana Gold –...</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 11:02:02</td>\n",
              "      <td>31e4708df66a9f39295976a81fe0f3c5</td>\n",
              "      <td>10.645185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>24</td>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Editor</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/equi...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://forextv.com/wp-content/uploads/2014/02...</td>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...</td>\n",
              "      <td>['https://secure.gravatar.com/avatar/a1c3880e3...</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>122188</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 02:31:05</td>\n",
              "      <td>c7cc3e042f2e3b9c3ee0e7663abcc276</td>\n",
              "      <td>10.617748</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>25</td>\n",
              "      <td>The stock market had a nice bounce last week, ...</td>\n",
              "      <td>US</td>\n",
              "      <td>newsfeedback@fool.com (Dan Caplinger)</td>\n",
              "      <td>https://www.fool.com/investing/2022/05/31/thes...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://g.foolcdn.com/editorial/images/682619/...</td>\n",
              "      <td>These 2 Mergers Are the Real (Asset) Deal</td>\n",
              "      <td>['https://g.foolcdn.com/art/companylogos/mark/...</td>\n",
              "      <td>fool.com</td>\n",
              "      <td>Copyright 1995-2022 The Motley Fool. All right...</td>\n",
              "      <td>673</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 12:29:01</td>\n",
              "      <td>725ac2c4feae6e5be65d003816316e30</td>\n",
              "      <td>10.554268</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>26</td>\n",
              "      <td>(GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 13:31:46</td>\n",
              "      <td>cfcb3bc6b16b98d94e7ab977ff150fc0</td>\n",
              "      <td>10.537979</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>27</td>\n",
              "      <td>Gold bonds are considered one of the best opti...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Editor</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/how-...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://forextv.com/wp-content/uploads/2014/02...</td>\n",
              "      <td>How to buy Sovereign Gold Bonds: All you need ...</td>\n",
              "      <td>['https://forextv.com/wp-content/uploads/2014/...</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>122188</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 14:03:00</td>\n",
              "      <td>b06a45ffb7c2586ede2aa08e52d89018</td>\n",
              "      <td>10.517043</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>28</td>\n",
              "      <td>NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/TAL...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Thinking about buying stock in Mullen Automoti...</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 15:16:05</td>\n",
              "      <td>d681167bb8aaa5266e98b141fe3d0480</td>\n",
              "      <td>10.499984</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>29</td>\n",
              "      <td>Shares in the South Africa-listed mining compa...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/news/latest/S-A...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>S.Africa's Gold Fields to become fourth bigges...</td>\n",
              "      <td>['https://www.marketscreener.com/images/png-co...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 15:16:30</td>\n",
              "      <td>5c5af8dbf10307a0903fd4d6059e793c</td>\n",
              "      <td>10.489705</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>30</td>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR – Get Rating) w...</td>\n",
              "      <td>US</td>\n",
              "      <td>Teresa Graham</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/06/02/osisko...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR) Rating Lowered...</td>\n",
              "      <td>['https://www.americanbankingnews.com/wp-conte...</td>\n",
              "      <td>thecerbatgem.com</td>\n",
              "      <td>thecerbatgem.com</td>\n",
              "      <td>813419</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-02 08:18:43</td>\n",
              "      <td>58ba31169de8919d8d07a6667df11f17</td>\n",
              "      <td>10.480762</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>31</td>\n",
              "      <td>​​FN Media Group Presents Microsmallcap.com Ma...</td>\n",
              "      <td>US</td>\n",
              "      <td>FinancialNewsMedia</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>en</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Global Demand for Silver Could Hit a Record in...</td>\n",
              "      <td>['https://tracking.newsrpm.com/pixel?slug=fina...</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>4400</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 13:15:00</td>\n",
              "      <td>1484b03ffae2be12a6cd8512170d1104</td>\n",
              "      <td>10.466648</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>32</td>\n",
              "      <td>Gold prices today (June 4) increased by Rs 50 ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Editor</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://forextv.com/wp-content/uploads/2014/02...</td>\n",
              "      <td>Gold prices today, 4 June 2022: Yellow metal g...</td>\n",
              "      <td>['https://forextv.com/wp-content/uploads/ad-72...</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>122188</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-04 02:31:03</td>\n",
              "      <td>fba4b2f17633a9d3dbbbdda2211812b9</td>\n",
              "      <td>10.451029</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>33</td>\n",
              "      <td>Vancouver, British Columbia - (May 31, 2022) -...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ROV...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...</td>\n",
              "      <td>['https://img.zonebourse.com/MarketScreener_lo...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 10:10:36</td>\n",
              "      <td>1897e724e51562b845e186a1963e76b1</td>\n",
              "      <td>10.375981</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>34</td>\n",
              "      <td>Blair William &amp; Co. IL cut its stake in shares...</td>\n",
              "      <td>US</td>\n",
              "      <td>Joseph Griffin</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...</td>\n",
              "      <td>['https://www.americanbankingnews.com/wp-conte...</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>559448</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 07:54:46</td>\n",
              "      <td>acfe8bd6cdf2c8c6a045cdf9cdf20c3e</td>\n",
              "      <td>10.356234</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>35</td>\n",
              "      <td>(GFI)   Report Gold Fields Limited (Reg. No. 1...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Gold Fields : to Acquire Yamana Gold</td>\n",
              "      <td>['https://www.marketscreener.com/images/twitte...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 05:40:55</td>\n",
              "      <td>11cce97a16089512342e57f4b0096054</td>\n",
              "      <td>10.340160</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>36</td>\n",
              "      <td>By Jasmine Browley · Updated June 4, 2022 CNBC...</td>\n",
              "      <td>US</td>\n",
              "      <td>Jasmine Browley</td>\n",
              "      <td>https://www.essence.com/news/money-career/expe...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.essence.com/wp-content/uploads/202...</td>\n",
              "      <td>Money Mindset: These Expert Tips Will Help You...</td>\n",
              "      <td>['https://www.essence.com/wp-content/uploads/2...</td>\n",
              "      <td>essence.com</td>\n",
              "      <td>essence.com</td>\n",
              "      <td>4385</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 12:21:00</td>\n",
              "      <td>9f19c30665748733d545bf8f00e31e04</td>\n",
              "      <td>10.310701</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>37</td>\n",
              "      <td>June 3, 2022 (Investorideas.com Newswire) As O...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.streetwisereports.com/submit_artic...</td>\n",
              "      <td>First Stepout Drill Results Promising for Gold...</td>\n",
              "      <td>['https://www.investorideas.com/images/logos/s...</td>\n",
              "      <td>investorideas.com</td>\n",
              "      <td>C2000-2022 InvestorIdeas.com tm</td>\n",
              "      <td>51454</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-03 13:15:00</td>\n",
              "      <td>5b37a1ab0dd41c6ed2838f0fa19b7d4a</td>\n",
              "      <td>10.293328</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>38</td>\n",
              "      <td>(PGM)   Report The Heart of Red Lake. PureGold...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/PUR...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Pure Gold Mining : Corporate Presentation – Ju...</td>\n",
              "      <td>['https://www.marketscreener.com/images/twitte...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-01 21:52:24</td>\n",
              "      <td>f1cca70b8ec93408cca564b9c39e2713</td>\n",
              "      <td>10.292129</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>39</td>\n",
              "      <td>With Governor Bill Lee's signature on Friday, ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Sound Money Defense League via AccessWire</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.accesswire.com/users/newswire/imag...</td>\n",
              "      <td>Tennessee Governor Signs Full Repeal of Sales ...</td>\n",
              "      <td>['https://www.accesswire.com/users/newswire/im...</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>4400</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 05:00:00</td>\n",
              "      <td>340aae0949aa66d704424f026282b887</td>\n",
              "      <td>10.282953</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>40</td>\n",
              "      <td>Gold Fields Limited (NYSE:GFI – Get Rating) sh...</td>\n",
              "      <td>US</td>\n",
              "      <td>Amy Steele</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/05/31/gold-f...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>Gold Fields (NYSE:GFI) Shares Gap Down to $12.20</td>\n",
              "      <td>['https://www.americanbankingnews.com/wp-conte...</td>\n",
              "      <td>thecerbatgem.com</td>\n",
              "      <td>thecerbatgem.com</td>\n",
              "      <td>813419</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 10:58:46</td>\n",
              "      <td>a26c27c1644c7d5c2fd2d362add8c785</td>\n",
              "      <td>10.254315</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>41</td>\n",
              "      <td>RING invests in gold mining companies. RING's ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Editor</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/ring...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://forextv.com/wp-content/uploads/2014/02...</td>\n",
              "      <td>RING: Gold Mining Companies Are Probably Fairl...</td>\n",
              "      <td>['https://forextv.com/wp-content/uploads/ad-72...</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>122188</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 04:31:23</td>\n",
              "      <td>94c0e1aeb6bb669af4681fc373cbc625</td>\n",
              "      <td>10.219755</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>42</td>\n",
              "      <td>Area Development, the leading publication cove...</td>\n",
              "      <td>US</td>\n",
              "      <td>Area Development via Business Wire</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://cts.businesswire.com/ct/CT?id=bwnews&amp;s...</td>\n",
              "      <td>Area Development's 17th Annual Shovel Awards R...</td>\n",
              "      <td>['https://cts.businesswire.com/ct/CT?id=bwnews...</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>financialcontent.com</td>\n",
              "      <td>4400</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-03 14:00:00</td>\n",
              "      <td>18db28b8c681a9a80daf7087652dcd2a</td>\n",
              "      <td>10.161287</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>43</td>\n",
              "      <td>Invesco Ltd. boosted its position in shares of...</td>\n",
              "      <td>US</td>\n",
              "      <td>Ethan Ryder</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>Invesco Ltd. Purchases 263,880 Shares of Alamo...</td>\n",
              "      <td>['https://www.americanbankingnews.com/wp-conte...</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>559448</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 05:18:43</td>\n",
              "      <td>92fbbf402d5f264c06883ed19f717e06</td>\n",
              "      <td>10.154214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>44</td>\n",
              "      <td>Vancouver, Kelowna, Delta, BC - May 31, 2022 (...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://www.investorideas.com/news/2022/explor...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.investorideas.com/images/exploring...</td>\n",
              "      <td>Exploring Mining Podcast 278</td>\n",
              "      <td>['https://www.investorideas.com/images/mining-...</td>\n",
              "      <td>investorideas.com</td>\n",
              "      <td>C2000-2022 InvestorIdeas.com tm</td>\n",
              "      <td>51454</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 14:30:00</td>\n",
              "      <td>a7ce701f2787e3dcf3b5c4aef84c3eba</td>\n",
              "      <td>10.146378</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>45</td>\n",
              "      <td>GSA Capital Partners LLP bought a new stake in...</td>\n",
              "      <td>US</td>\n",
              "      <td>Logan Wallace</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.americanbankingnews.com/wp-content...</td>\n",
              "      <td>GSA Capital Partners LLP Buys New Position in ...</td>\n",
              "      <td>['https://www.marketbeat.com/scripts/SECFiling...</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>tickerreport.com</td>\n",
              "      <td>559448</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-07 05:36:41</td>\n",
              "      <td>78b73ca0eccbf0bc928d9e4f591aee52</td>\n",
              "      <td>10.141080</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>46</td>\n",
              "      <td>Indian gold markets are expected to be under p...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Editor</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://forextv.com/wp-content/uploads/2014/02...</td>\n",
              "      <td>Gold Rates In India Are On The Verge Of Fallin...</td>\n",
              "      <td>['https://forextv.com/wp-content/uploads/2014/...</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>forextv.com</td>\n",
              "      <td>122188</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-05-31 12:32:14</td>\n",
              "      <td>828a483c4da52577b85e861bc8566dda</td>\n",
              "      <td>10.120295</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>47</td>\n",
              "      <td>(FLOD) The Flowery Gold Mines Company of Nevad...</td>\n",
              "      <td>US</td>\n",
              "      <td>MarketScreener</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/FLO...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://www.marketscreener.com/images/twitter_...</td>\n",
              "      <td>Flowery Gold Mines : Ending 9-30-2021 FGMC Una...</td>\n",
              "      <td>['https://www.marketscreener.com/images/img_fo...</td>\n",
              "      <td>marketscreener.com</td>\n",
              "      <td>Copyright 2001 - 2022 Surperformance</td>\n",
              "      <td>3681</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-02 19:22:10</td>\n",
              "      <td>9007002fc3bf2e4cacce5a6379aa8a0a</td>\n",
              "      <td>10.118509</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>48</td>\n",
              "      <td>agnormark/iStock via Getty Images The Q1 Earni...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://seekingalpha.com/article/4516497-jagua...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://static.seekingalpha.com/cdn/s3/uploads...</td>\n",
              "      <td>Jaguar Mining: Inflationary Pressures Wreak Ha...</td>\n",
              "      <td>['https://static.seekingalpha.com/uploads/2022...</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>seekingalpha.com</td>\n",
              "      <td>892</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-05 02:23:59</td>\n",
              "      <td>6327b537da4cbe13f23f172d334c7849</td>\n",
              "      <td>10.090810</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>49</td>\n",
              "      <td>(RTTNews) - Indian shares followed global peer...</td>\n",
              "      <td>US</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://markets.businessinsider.com/news/stock...</td>\n",
              "      <td>en</td>\n",
              "      <td>https://markets.businessinsider.com/apple-touc...</td>\n",
              "      <td>Sensex, Nifty Rally As Tech Stocks Surge</td>\n",
              "      <td>['https://markets.businessinsider.com/public/a...</td>\n",
              "      <td>businessinsider.com</td>\n",
              "      <td>businessinsider.com</td>\n",
              "      <td>106</td>\n",
              "      <td>finance</td>\n",
              "      <td>2022-06-03 06:14:07</td>\n",
              "      <td>7ab0438f7f28b7379677f01832800362</td>\n",
              "      <td>10.080583</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-6e6a10ce-b6d1-4a97-baea-a8e69d058b7c')\"\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-6e6a10ce-b6d1-4a97-baea-a8e69d058b7c 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-6e6a10ce-b6d1-4a97-baea-a8e69d058b7c');\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",
              "  "
            ],
            "text/plain": [
              "    Unnamed: 0                                            summary country  \\\n",
              "0            0  North Hills,United States - June 7, 2022 /Pres...      US   \n",
              "1            1  By The Daily Upside - May 31, 2022 at 9:00PM Y...      US   \n",
              "2            2  (ASA)   Report April 30, 2022 Shares Ticker AS...      US   \n",
              "3            3  Oat_Phawat/iStock via Getty Images Part I - In...      US   \n",
              "4            4  Gold Fields Limited GFI and Yamana Gold Inc. A...      US   \n",
              "5            5  Four companies won the licences - Lotus Gold, ...      US   \n",
              "6            6  adventtr/E+ via Getty Images Gold and silver a...      US   \n",
              "7            7  GGCM has recently launched a Gold Guaranteed C...      US   \n",
              "8            8  Cetera Investment Advisers lessened its stake ...      US   \n",
              "9            9  (KSN)   Report ASX: KSN Asia-Pacific Gold Prod...      US   \n",
              "10          10  June 1, 2022 (Investorideas.com Newswire) With...      US   \n",
              "11          11  Red Cloud's Mining Analyst to Interview Chairm...      US   \n",
              "12          12  Fury Gold Mines (NASDAQ:FURY – Get Rating) was...      US   \n",
              "13          13  Return of Shiba, the revolutionary blockchain ...      US   \n",
              "14          14  Public Sector Pension Investment Board decreas...      US   \n",
              "15          15  SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...      US   \n",
              "16          16  (WRN)   Report TSX WRN NYSE AMERICAN WRN DEVEL...      US   \n",
              "17          17  Harmony Gold Mining (NYSE:HMY – Get Rating) wa...      US   \n",
              "18          18  HighTower Advisors LLC reduced its position in...      US   \n",
              "19          19  (VGCX)   Report Discover Companies to Invest I...      US   \n",
              "20          20  Gold price today (June 5, 2022) decreased marg...      US   \n",
              "21          21  chonticha wat/iStock via Getty Images iShares ...      US   \n",
              "22          22  (YRI)   Report Transaction creates a top-4 glo...      US   \n",
              "23          23  (YRI)   Report Transaction creates a top-4 glo...      US   \n",
              "24          24  Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...      US   \n",
              "25          25  The stock market had a nice bounce last week, ...      US   \n",
              "26          26  (GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...      US   \n",
              "27          27  Gold bonds are considered one of the best opti...      US   \n",
              "28          28  NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...      US   \n",
              "29          29  Shares in the South Africa-listed mining compa...      US   \n",
              "30          30  Osisko Gold Royalties (NYSE:OR – Get Rating) w...      US   \n",
              "31          31  ​​FN Media Group Presents Microsmallcap.com Ma...      US   \n",
              "32          32  Gold prices today (June 4) increased by Rs 50 ...      US   \n",
              "33          33  Vancouver, British Columbia - (May 31, 2022) -...      US   \n",
              "34          34  Blair William & Co. IL cut its stake in shares...      US   \n",
              "35          35  (GFI)   Report Gold Fields Limited (Reg. No. 1...      US   \n",
              "36          36  By Jasmine Browley · Updated June 4, 2022 CNBC...      US   \n",
              "37          37  June 3, 2022 (Investorideas.com Newswire) As O...      US   \n",
              "38          38  (PGM)   Report The Heart of Red Lake. PureGold...      US   \n",
              "39          39  With Governor Bill Lee's signature on Friday, ...      US   \n",
              "40          40  Gold Fields Limited (NYSE:GFI – Get Rating) sh...      US   \n",
              "41          41  RING invests in gold mining companies. RING's ...      US   \n",
              "42          42  Area Development, the leading publication cove...      US   \n",
              "43          43  Invesco Ltd. boosted its position in shares of...      US   \n",
              "44          44  Vancouver, Kelowna, Delta, BC - May 31, 2022 (...      US   \n",
              "45          45  GSA Capital Partners LLP bought a new stake in...      US   \n",
              "46          46  Indian gold markets are expected to be under p...      US   \n",
              "47          47  (FLOD) The Flowery Gold Mines Company of Nevad...      US   \n",
              "48          48  agnormark/iStock via Getty Images The Q1 Earni...      US   \n",
              "49          49  (RTTNews) - Indian shares followed global peer...      US   \n",
              "\n",
              "                                       author  \\\n",
              "0          Press Release Distribution Service   \n",
              "1    newsfeedback@fool.com (The Daily Upside)   \n",
              "2                              MarketScreener   \n",
              "3                                         NaN   \n",
              "4                       Zacks Equity Research   \n",
              "5                              MarketScreener   \n",
              "6                                         NaN   \n",
              "7                                    Get News   \n",
              "8                              Joseph Griffin   \n",
              "9                              MarketScreener   \n",
              "10                                        NaN   \n",
              "11                             MarketScreener   \n",
              "12                             Joseph Griffin   \n",
              "13                                   Get News   \n",
              "14                                Ethan Ryder   \n",
              "15           Guskin Gold Corp. via AccessWire   \n",
              "16                             MarketScreener   \n",
              "17                                Gold Editor   \n",
              "18                             Joseph Griffin   \n",
              "19                             MarketScreener   \n",
              "20                                Gold Editor   \n",
              "21                                        NaN   \n",
              "22                             MarketScreener   \n",
              "23                             MarketScreener   \n",
              "24                                Gold Editor   \n",
              "25      newsfeedback@fool.com (Dan Caplinger)   \n",
              "26                             MarketScreener   \n",
              "27                                Gold Editor   \n",
              "28                             MarketScreener   \n",
              "29                             MarketScreener   \n",
              "30                              Teresa Graham   \n",
              "31                         FinancialNewsMedia   \n",
              "32                                Gold Editor   \n",
              "33                             MarketScreener   \n",
              "34                             Joseph Griffin   \n",
              "35                             MarketScreener   \n",
              "36                            Jasmine Browley   \n",
              "37                                        NaN   \n",
              "38                             MarketScreener   \n",
              "39  Sound Money Defense League via AccessWire   \n",
              "40                                 Amy Steele   \n",
              "41                                Gold Editor   \n",
              "42         Area Development via Business Wire   \n",
              "43                                Ethan Ryder   \n",
              "44                                        NaN   \n",
              "45                              Logan Wallace   \n",
              "46                                Gold Editor   \n",
              "47                             MarketScreener   \n",
              "48                                        NaN   \n",
              "49                                        NaN   \n",
              "\n",
              "                                                 link language  \\\n",
              "0   https://markets.financialcontent.com/stocks/ar...       en   \n",
              "1   https://www.fool.com/investing/2022/05/31/sout...       en   \n",
              "2   https://www.marketscreener.com/quote/stock/ASA...       en   \n",
              "3   https://seekingalpha.com/article/4515405-new-g...       en   \n",
              "4   https://finance.yahoo.com/news/gold-fields-gfi...       en   \n",
              "5   https://www.marketscreener.com/news/latest/Egy...       en   \n",
              "6   https://seekingalpha.com/article/4515483-buyin...       en   \n",
              "7   https://markets.financialcontent.com/stocks/ar...       en   \n",
              "8   https://www.tickerreport.com/banking-finance/8...       en   \n",
              "9   https://www.marketscreener.com/quote/stock/KIN...       en   \n",
              "10  https://www.investorideas.com/news/2022/mining...       en   \n",
              "11  https://www.marketscreener.com/quote/stock/U-S...       en   \n",
              "12  https://www.tickerreport.com/banking-finance/8...       en   \n",
              "13  https://markets.financialcontent.com/stocks/ar...       en   \n",
              "14  https://www.tickerreport.com/banking-finance/8...       en   \n",
              "15  https://markets.financialcontent.com/stocks/ar...       en   \n",
              "16  https://www.marketscreener.com/quote/stock/WES...       en   \n",
              "17  https://forextv.com/xauusd-gold-us-dollar/zack...       en   \n",
              "18  https://www.tickerreport.com/banking-finance/8...       en   \n",
              "19  https://www.marketscreener.com/quote/stock/VIC...       en   \n",
              "20  https://forextv.com/xauusd-gold-us-dollar/gold...       en   \n",
              "21  https://seekingalpha.com/article/4516774-ring-...       en   \n",
              "22  https://www.marketscreener.com/quote/stock/YAM...       en   \n",
              "23  https://www.marketscreener.com/quote/stock/YAM...       en   \n",
              "24  https://forextv.com/xauusd-gold-us-dollar/equi...       en   \n",
              "25  https://www.fool.com/investing/2022/05/31/thes...       en   \n",
              "26  https://www.marketscreener.com/quote/stock/GOL...       en   \n",
              "27  https://forextv.com/xauusd-gold-us-dollar/how-...       en   \n",
              "28  https://www.marketscreener.com/quote/stock/TAL...       en   \n",
              "29  https://www.marketscreener.com/news/latest/S-A...       en   \n",
              "30  https://www.thecerbatgem.com/2022/06/02/osisko...       en   \n",
              "31  https://markets.financialcontent.com/stocks/ar...       en   \n",
              "32  https://forextv.com/xauusd-gold-us-dollar/gold...       en   \n",
              "33  https://www.marketscreener.com/quote/stock/ROV...       en   \n",
              "34  https://www.tickerreport.com/banking-finance/8...       en   \n",
              "35  https://www.marketscreener.com/quote/stock/GOL...       en   \n",
              "36  https://www.essence.com/news/money-career/expe...       en   \n",
              "37  https://www.investorideas.com/news/2022/mining...       en   \n",
              "38  https://www.marketscreener.com/quote/stock/PUR...       en   \n",
              "39  https://markets.financialcontent.com/stocks/ar...       en   \n",
              "40  https://www.thecerbatgem.com/2022/05/31/gold-f...       en   \n",
              "41  https://forextv.com/xauusd-gold-us-dollar/ring...       en   \n",
              "42  https://markets.financialcontent.com/stocks/ar...       en   \n",
              "43  https://www.tickerreport.com/banking-finance/8...       en   \n",
              "44  https://www.investorideas.com/news/2022/explor...       en   \n",
              "45  https://www.tickerreport.com/banking-finance/8...       en   \n",
              "46  https://forextv.com/xauusd-gold-us-dollar/gold...       en   \n",
              "47  https://www.marketscreener.com/quote/stock/FLO...       en   \n",
              "48  https://seekingalpha.com/article/4516497-jagua...       en   \n",
              "49  https://markets.businessinsider.com/news/stock...       en   \n",
              "\n",
              "                                                media  \\\n",
              "0   https://storage.googleapis.com/mmstudio-images...   \n",
              "1   https://g.foolcdn.com/editorial/images/682824/...   \n",
              "2   https://www.marketscreener.com/images/twitter_...   \n",
              "3   https://static.seekingalpha.com/cdn/s3/uploads...   \n",
              "4   https://s.yimg.com/uu/api/res/1.2/G5XrE0LCS4YC...   \n",
              "5   https://www.marketscreener.com/images/twitter_...   \n",
              "6   https://static.seekingalpha.com/cdn/s3/uploads...   \n",
              "7                                                 NaN   \n",
              "8   https://www.americanbankingnews.com/wp-content...   \n",
              "9   https://www.marketscreener.com/images/twitter_...   \n",
              "10  https://www.streetwisereports.com/images/White...   \n",
              "11  https://www.marketscreener.com/images/twitter_...   \n",
              "12  https://www.americanbankingnews.com/wp-content...   \n",
              "13  https://www.getnews.info/uploads/a0471094df1da...   \n",
              "14  https://www.americanbankingnews.com/wp-content...   \n",
              "15      https://www.accesswire.com/img.ashx?id=703263   \n",
              "16  https://www.marketscreener.com/images/twitter_...   \n",
              "17  https://forextv.com/wp-content/uploads/2014/02...   \n",
              "18  https://www.americanbankingnews.com/wp-content...   \n",
              "19  https://www.marketscreener.com/images/twitter_...   \n",
              "20  https://forextv.com/wp-content/uploads/2014/02...   \n",
              "21  https://static.seekingalpha.com/cdn/s3/uploads...   \n",
              "22  https://www.marketscreener.com/images/twitter_...   \n",
              "23  https://www.marketscreener.com/images/twitter_...   \n",
              "24  https://forextv.com/wp-content/uploads/2014/02...   \n",
              "25  https://g.foolcdn.com/editorial/images/682619/...   \n",
              "26  https://www.marketscreener.com/images/twitter_...   \n",
              "27  https://forextv.com/wp-content/uploads/2014/02...   \n",
              "28  https://www.marketscreener.com/images/twitter_...   \n",
              "29  https://www.marketscreener.com/images/twitter_...   \n",
              "30  https://www.americanbankingnews.com/wp-content...   \n",
              "31                                                NaN   \n",
              "32  https://forextv.com/wp-content/uploads/2014/02...   \n",
              "33  https://www.marketscreener.com/images/twitter_...   \n",
              "34  https://www.americanbankingnews.com/wp-content...   \n",
              "35  https://www.marketscreener.com/images/twitter_...   \n",
              "36  https://www.essence.com/wp-content/uploads/202...   \n",
              "37  https://www.streetwisereports.com/submit_artic...   \n",
              "38  https://www.marketscreener.com/images/twitter_...   \n",
              "39  https://www.accesswire.com/users/newswire/imag...   \n",
              "40  https://www.americanbankingnews.com/wp-content...   \n",
              "41  https://forextv.com/wp-content/uploads/2014/02...   \n",
              "42  https://cts.businesswire.com/ct/CT?id=bwnews&s...   \n",
              "43  https://www.americanbankingnews.com/wp-content...   \n",
              "44  https://www.investorideas.com/images/exploring...   \n",
              "45  https://www.americanbankingnews.com/wp-content...   \n",
              "46  https://forextv.com/wp-content/uploads/2014/02...   \n",
              "47  https://www.marketscreener.com/images/twitter_...   \n",
              "48  https://static.seekingalpha.com/cdn/s3/uploads...   \n",
              "49  https://markets.businessinsider.com/apple-touc...   \n",
              "\n",
              "                                                title  \\\n",
              "0   US Gold IRA 401k Rollover 2022 Retirement Savi...   \n",
              "1   South Africa's Gold Fields Buying Canada's Yam...   \n",
              "2   ASA Gold and Precious Metals : Monthly Factshe...   \n",
              "3   New Gold: Lower Grade And Tonnes Processed At ...   \n",
              "4   Gold Fields (GFI) to Acquire Yamana Gold for $...   \n",
              "5   Egypt awards eight gold and metal mining explo...   \n",
              "6   Buying Physical Gold And Silver: Here Is What ...   \n",
              "7   GGCM develops a crypto platform for the cause ...   \n",
              "8   Cetera Investment Advisers Sells 8,195 Shares ...   \n",
              "9   Kingston Resources : Investor Presentation – R...   \n",
              "10      Yukon Explorer Looking to Start New Gold Rush   \n",
              "11  U.S. Gold Corp. Announces Live Webinar Hosted ...   \n",
              "12  Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...   \n",
              "13  ShibDOSH – The World's First Gold Paying Rebas...   \n",
              "14  Public Sector Pension Investment Board Sells 2...   \n",
              "15  Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...   \n",
              "16   Western Copper and Gold : June 2022 Presentation   \n",
              "17  Zacks Investment Research Downgrades Harmony G...   \n",
              "18  HighTower Advisors LLC Sells 54,389 Shares of ...   \n",
              "19  BTV Showcases Victoria Gold, Advance United, T...   \n",
              "20  Gold price today, June 5: Gold rates drop afte...   \n",
              "21  RING (RING): Gold Mining Companies Are Probabl...   \n",
              "22  Gold Fields to Acquire Yamana Gold – a Combina...   \n",
              "23  REPEAT -- Gold Fields to Acquire Yamana Gold –...   \n",
              "24  Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...   \n",
              "25          These 2 Mergers Are the Real (Asset) Deal   \n",
              "26          GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.   \n",
              "27  How to buy Sovereign Gold Bonds: All you need ...   \n",
              "28  Thinking about buying stock in Mullen Automoti...   \n",
              "29  S.Africa's Gold Fields to become fourth bigges...   \n",
              "30  Osisko Gold Royalties (NYSE:OR) Rating Lowered...   \n",
              "31  Global Demand for Silver Could Hit a Record in...   \n",
              "32  Gold prices today, 4 June 2022: Yellow metal g...   \n",
              "33  ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...   \n",
              "34  Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...   \n",
              "35               Gold Fields : to Acquire Yamana Gold   \n",
              "36  Money Mindset: These Expert Tips Will Help You...   \n",
              "37  First Stepout Drill Results Promising for Gold...   \n",
              "38  Pure Gold Mining : Corporate Presentation – Ju...   \n",
              "39  Tennessee Governor Signs Full Repeal of Sales ...   \n",
              "40   Gold Fields (NYSE:GFI) Shares Gap Down to $12.20   \n",
              "41  RING: Gold Mining Companies Are Probably Fairl...   \n",
              "42  Area Development's 17th Annual Shovel Awards R...   \n",
              "43  Invesco Ltd. Purchases 263,880 Shares of Alamo...   \n",
              "44                       Exploring Mining Podcast 278   \n",
              "45  GSA Capital Partners LLP Buys New Position in ...   \n",
              "46  Gold Rates In India Are On The Verge Of Fallin...   \n",
              "47  Flowery Gold Mines : Ending 9-30-2021 FGMC Una...   \n",
              "48  Jaguar Mining: Inflationary Pressures Wreak Ha...   \n",
              "49           Sensex, Nifty Rally As Tech Stocks Surge   \n",
              "\n",
              "                                        media_content             clean_url  \\\n",
              "0   ['https://storage.googleapis.com/mmstudio-imag...  financialcontent.com   \n",
              "1   ['https://g.foolcdn.com/misc-assets/logo-tmf-p...              fool.com   \n",
              "2   ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "3   ['https://static.seekingalpha.com/uploads/2022...      seekingalpha.com   \n",
              "4   ['https://s.yimg.com/cv/apiv2/default/20190501...             yahoo.com   \n",
              "5   ['https://www.marketscreener.com/images/img_fo...    marketscreener.com   \n",
              "6   ['data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP...      seekingalpha.com   \n",
              "7                                                  []  financialcontent.com   \n",
              "8   ['https://c.statcounter.com/8291392/0/b2ca9722...      tickerreport.com   \n",
              "9   ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "10  ['https://www.investorideas.com/images/logos/t...     investorideas.com   \n",
              "11  ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "12  ['https://www.americanbankingnews.com/wp-conte...      tickerreport.com   \n",
              "13  ['https://www.getnews.info/uploads/a0471094df1...  financialcontent.com   \n",
              "14  ['https://c.statcounter.com/9021069/0/fdde5482...      tickerreport.com   \n",
              "15  ['https://tracking.newsrpm.com/pixel?slug=acce...  financialcontent.com   \n",
              "16  ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "17  ['https://assets.pinterest.com/images/PinExt.p...           forextv.com   \n",
              "18  ['https://www.americanbankingnews.com/wp-conte...      tickerreport.com   \n",
              "19  ['https://www.marketscreener.com/images/share/...    marketscreener.com   \n",
              "20  ['https://assets.pinterest.com/images/PinExt.p...           forextv.com   \n",
              "21  ['https://static.seekingalpha.com/uploads/2022...      seekingalpha.com   \n",
              "22  ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "23  ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "24  ['https://secure.gravatar.com/avatar/a1c3880e3...           forextv.com   \n",
              "25  ['https://g.foolcdn.com/art/companylogos/mark/...              fool.com   \n",
              "26  ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "27  ['https://forextv.com/wp-content/uploads/2014/...           forextv.com   \n",
              "28  ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "29  ['https://www.marketscreener.com/images/png-co...    marketscreener.com   \n",
              "30  ['https://www.americanbankingnews.com/wp-conte...      thecerbatgem.com   \n",
              "31  ['https://tracking.newsrpm.com/pixel?slug=fina...  financialcontent.com   \n",
              "32  ['https://forextv.com/wp-content/uploads/ad-72...           forextv.com   \n",
              "33  ['https://img.zonebourse.com/MarketScreener_lo...    marketscreener.com   \n",
              "34  ['https://www.americanbankingnews.com/wp-conte...      tickerreport.com   \n",
              "35  ['https://www.marketscreener.com/images/twitte...    marketscreener.com   \n",
              "36  ['https://www.essence.com/wp-content/uploads/2...           essence.com   \n",
              "37  ['https://www.investorideas.com/images/logos/s...     investorideas.com   \n",
              "38  ['https://www.marketscreener.com/images/twitte...    marketscreener.com   \n",
              "39  ['https://www.accesswire.com/users/newswire/im...  financialcontent.com   \n",
              "40  ['https://www.americanbankingnews.com/wp-conte...      thecerbatgem.com   \n",
              "41  ['https://forextv.com/wp-content/uploads/ad-72...           forextv.com   \n",
              "42  ['https://cts.businesswire.com/ct/CT?id=bwnews...  financialcontent.com   \n",
              "43  ['https://www.americanbankingnews.com/wp-conte...      tickerreport.com   \n",
              "44  ['https://www.investorideas.com/images/mining-...     investorideas.com   \n",
              "45  ['https://www.marketbeat.com/scripts/SECFiling...      tickerreport.com   \n",
              "46  ['https://forextv.com/wp-content/uploads/2014/...           forextv.com   \n",
              "47  ['https://www.marketscreener.com/images/img_fo...    marketscreener.com   \n",
              "48  ['https://static.seekingalpha.com/uploads/2022...      seekingalpha.com   \n",
              "49  ['https://markets.businessinsider.com/public/a...   businessinsider.com   \n",
              "\n",
              "                                               rights    rank    topic  \\\n",
              "0                                financialcontent.com    4400  finance   \n",
              "1   Copyright 1995-2022 The Motley Fool. All right...     673  finance   \n",
              "2                Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "3                                    seekingalpha.com     892  finance   \n",
              "4                                           yahoo.com      31  finance   \n",
              "5                Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "6                                    seekingalpha.com     892  finance   \n",
              "7                                                 NaN    4400  finance   \n",
              "8                                    tickerreport.com  559448  finance   \n",
              "9                Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "10                    C2000-2022 InvestorIdeas.com tm   51454  finance   \n",
              "11               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "12                                   tickerreport.com  559448  finance   \n",
              "13                               financialcontent.com    4400  finance   \n",
              "14                                   tickerreport.com  559448  finance   \n",
              "15                               financialcontent.com    4400  finance   \n",
              "16               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "17                                        forextv.com  122188  finance   \n",
              "18                                   tickerreport.com  559448  finance   \n",
              "19               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "20                                        forextv.com  122188  finance   \n",
              "21                                   seekingalpha.com     892  finance   \n",
              "22               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "23               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "24                                        forextv.com  122188  finance   \n",
              "25  Copyright 1995-2022 The Motley Fool. All right...     673  finance   \n",
              "26               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "27                                        forextv.com  122188  finance   \n",
              "28               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "29               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "30                                   thecerbatgem.com  813419  finance   \n",
              "31                               financialcontent.com    4400  finance   \n",
              "32                                        forextv.com  122188  finance   \n",
              "33               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "34                                   tickerreport.com  559448  finance   \n",
              "35               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "36                                        essence.com    4385  finance   \n",
              "37                    C2000-2022 InvestorIdeas.com tm   51454  finance   \n",
              "38               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "39                               financialcontent.com    4400  finance   \n",
              "40                                   thecerbatgem.com  813419  finance   \n",
              "41                                        forextv.com  122188  finance   \n",
              "42                               financialcontent.com    4400  finance   \n",
              "43                                   tickerreport.com  559448  finance   \n",
              "44                    C2000-2022 InvestorIdeas.com tm   51454  finance   \n",
              "45                                   tickerreport.com  559448  finance   \n",
              "46                                        forextv.com  122188  finance   \n",
              "47               Copyright 2001 - 2022 Surperformance    3681  finance   \n",
              "48                                   seekingalpha.com     892  finance   \n",
              "49                                businessinsider.com     106  finance   \n",
              "\n",
              "         published_date                               _id     _score  \n",
              "0   2022-06-07 08:07:00  0e231495fc121d3516dc45e6591ab240  11.909276  \n",
              "1   2022-06-01 01:00:13  428ae5b8ea67a469b41b478429b4a605  11.749602  \n",
              "2   2022-06-01 19:32:06  3842fc656882661641ae53e72233910b  11.638879  \n",
              "3   2022-05-31 10:54:49  d4ea9a8a5d62a4d7157b23df7f183af7  11.604368  \n",
              "4   2022-05-31 14:04:02  6e9c2ce7e93d4bb7a340564b36787d89  11.520050  \n",
              "5   2022-06-01 09:41:08  12384bf62321340d06de9c80af21cce8  11.433958  \n",
              "6   2022-05-31 16:11:53  f7c54993ae8183d2f3fa0b9606b48107  11.371989  \n",
              "7   2022-05-31 01:30:00  6b4c76f4f2e3c4c269a0f87184c9b72f  11.321525  \n",
              "8   2022-06-06 07:55:51  7d4820c53df06bb014c199a4fdc657e9  11.053978  \n",
              "9   2022-06-07 08:12:11  256306fb293e4a24e5ff07ca8ac87705  11.031989  \n",
              "10  2022-06-01 15:05:00  c9b2a94d1d7e7c675fd7271f8def6032  11.024569  \n",
              "11  2022-06-01 12:48:04  b0261762b0754e66022feead05acd3cf  10.982766  \n",
              "12  2022-06-02 01:54:42  d408731732a7e73fc05d396cffe2f652  10.968813  \n",
              "13  2022-06-06 12:54:02  4937405351e131e11fcecb7a44bf225e  10.861591  \n",
              "14  2022-06-03 07:56:44  fc786d20f1b85b06b3deb61cc6d96c79  10.856547  \n",
              "15  2022-05-31 11:30:00  19fa03834f568387d0cedf9e90f94342  10.804963  \n",
              "16  2022-06-05 21:22:02  f2e81adc90869a5938af2e026339dda7  10.738883  \n",
              "17  2022-06-06 16:31:54  09c1eb4bb44090724d0654e63091625f  10.726349  \n",
              "18  2022-06-07 05:22:41  b919e626e193c987fa9421b14f7d5989  10.716049  \n",
              "19  2022-06-02 13:05:01  024982c6f49e17c3ba4529a99e398542  10.694183  \n",
              "20  2022-06-05 02:31:04  a3280cba845a24a8e4aa78d2bdfde9bd  10.673847  \n",
              "21  2022-06-07 04:09:45  3f68ca870a80d6f9df53449b3c0fe665  10.671701  \n",
              "22  2022-05-31 05:45:01  301e50ee2ce13655618dd7a75382f515  10.645185  \n",
              "23  2022-05-31 11:02:02  31e4708df66a9f39295976a81fe0f3c5  10.645185  \n",
              "24  2022-05-31 02:31:05  c7cc3e042f2e3b9c3ee0e7663abcc276  10.617748  \n",
              "25  2022-05-31 12:29:01  725ac2c4feae6e5be65d003816316e30  10.554268  \n",
              "26  2022-05-31 13:31:46  cfcb3bc6b16b98d94e7ab977ff150fc0  10.537979  \n",
              "27  2022-05-31 14:03:00  b06a45ffb7c2586ede2aa08e52d89018  10.517043  \n",
              "28  2022-05-31 15:16:05  d681167bb8aaa5266e98b141fe3d0480  10.499984  \n",
              "29  2022-05-31 15:16:30  5c5af8dbf10307a0903fd4d6059e793c  10.489705  \n",
              "30  2022-06-02 08:18:43  58ba31169de8919d8d07a6667df11f17  10.480762  \n",
              "31  2022-06-01 13:15:00  1484b03ffae2be12a6cd8512170d1104  10.466648  \n",
              "32  2022-06-04 02:31:03  fba4b2f17633a9d3dbbbdda2211812b9  10.451029  \n",
              "33  2022-05-31 10:10:36  1897e724e51562b845e186a1963e76b1  10.375981  \n",
              "34  2022-06-01 07:54:46  acfe8bd6cdf2c8c6a045cdf9cdf20c3e  10.356234  \n",
              "35  2022-05-31 05:40:55  11cce97a16089512342e57f4b0096054  10.340160  \n",
              "36  2022-06-07 12:21:00  9f19c30665748733d545bf8f00e31e04  10.310701  \n",
              "37  2022-06-03 13:15:00  5b37a1ab0dd41c6ed2838f0fa19b7d4a  10.293328  \n",
              "38  2022-06-01 21:52:24  f1cca70b8ec93408cca564b9c39e2713  10.292129  \n",
              "39  2022-05-31 05:00:00  340aae0949aa66d704424f026282b887  10.282953  \n",
              "40  2022-05-31 10:58:46  a26c27c1644c7d5c2fd2d362add8c785  10.254315  \n",
              "41  2022-06-07 04:31:23  94c0e1aeb6bb669af4681fc373cbc625  10.219755  \n",
              "42  2022-06-03 14:00:00  18db28b8c681a9a80daf7087652dcd2a  10.161287  \n",
              "43  2022-06-07 05:18:43  92fbbf402d5f264c06883ed19f717e06  10.154214  \n",
              "44  2022-05-31 14:30:00  a7ce701f2787e3dcf3b5c4aef84c3eba  10.146378  \n",
              "45  2022-06-07 05:36:41  78b73ca0eccbf0bc928d9e4f591aee52  10.141080  \n",
              "46  2022-05-31 12:32:14  828a483c4da52577b85e861bc8566dda  10.120295  \n",
              "47  2022-06-02 19:22:10  9007002fc3bf2e4cacce5a6379aa8a0a  10.118509  \n",
              "48  2022-06-05 02:23:59  6327b537da4cbe13f23f172d334c7849  10.090810  \n",
              "49  2022-06-03 06:14:07  7ab0438f7f28b7379677f01832800362  10.080583  "
            ]
          },
          "execution_count": 59,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "import pandas as pd \n",
        "\n",
        "# choose already translated csv file by specifieng the lang paramenter\n",
        "lang = \"us\"\n",
        "\n",
        "#df = pd.read_csv(f\"/content/drive/MyDrive/2022.05.24_Final-Project_Shared-Folder/translated/{lang}-translated.csv\")\n",
        "df = pd.read_csv(f\"/content/drive/MyDrive/news_{lang}.csv\")\n",
        "df"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 13,
      "metadata": {
        "id": "WWcxOCvHRBp4"
      },
      "outputs": [],
      "source": [
        "#df.summary()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 60,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "08mKk6aXR1h3",
        "outputId": "795e2f89-e204-459d-de83-305458281fde"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "--------------------\n",
            "0\n",
            "[{'label': 'POSITIVE', 'score': 0.8871214389801025}]\n",
            "--------------------\n",
            "1\n",
            "[{'label': 'POSITIVE', 'score': 0.9549136757850647}]\n",
            "--------------------\n",
            "2\n",
            "[{'label': 'NEGATIVE', 'score': 0.9725818634033203}]\n",
            "--------------------\n",
            "3\n",
            "[{'label': 'NEGATIVE', 'score': 0.9927130341529846}]\n",
            "--------------------\n",
            "4\n",
            "[{'label': 'POSITIVE', 'score': 0.9996708631515503}]\n",
            "--------------------\n",
            "5\n",
            "[{'label': 'NEGATIVE', 'score': 0.9252613186836243}]\n",
            "--------------------\n",
            "6\n",
            "[{'label': 'NEGATIVE', 'score': 0.7249220609664917}]\n",
            "--------------------\n",
            "7\n",
            "[{'label': 'POSITIVE', 'score': 0.9995676875114441}]\n",
            "--------------------\n",
            "8\n",
            "[{'label': 'NEGATIVE', 'score': 0.9950361847877502}]\n",
            "--------------------\n",
            "9\n",
            "[{'label': 'POSITIVE', 'score': 0.9980121850967407}]\n",
            "--------------------\n",
            "10\n",
            "[{'label': 'POSITIVE', 'score': 0.995589017868042}]\n",
            "--------------------\n",
            "11\n",
            "[{'label': 'POSITIVE', 'score': 0.9649119973182678}]\n",
            "--------------------\n",
            "12\n",
            "[{'label': 'NEGATIVE', 'score': 0.9869105219841003}]\n",
            "--------------------\n",
            "13\n",
            "[{'label': 'POSITIVE', 'score': 0.9993385672569275}]\n",
            "--------------------\n",
            "14\n",
            "[{'label': 'NEGATIVE', 'score': 0.9983483552932739}]\n",
            "--------------------\n",
            "15\n",
            "[{'label': 'POSITIVE', 'score': 0.999622106552124}]\n",
            "--------------------\n",
            "16\n",
            "[{'label': 'NEGATIVE', 'score': 0.9952294826507568}]\n",
            "--------------------\n",
            "17\n",
            "[{'label': 'NEGATIVE', 'score': 0.999273955821991}]\n",
            "--------------------\n",
            "18\n",
            "[{'label': 'NEGATIVE', 'score': 0.9976409673690796}]\n",
            "--------------------\n",
            "19\n",
            "[{'label': 'POSITIVE', 'score': 0.9986353516578674}]\n",
            "--------------------\n",
            "20\n",
            "[{'label': 'NEGATIVE', 'score': 0.996260404586792}]\n",
            "--------------------\n",
            "21\n",
            "[{'label': 'POSITIVE', 'score': 0.9271125793457031}]\n",
            "--------------------\n",
            "22\n",
            "[{'label': 'POSITIVE', 'score': 0.9984413981437683}]\n",
            "--------------------\n",
            "23\n",
            "[{'label': 'POSITIVE', 'score': 0.9984413981437683}]\n",
            "--------------------\n",
            "24\n",
            "[{'label': 'NEGATIVE', 'score': 0.9987786412239075}]\n",
            "--------------------\n",
            "25\n",
            "[{'label': 'NEGATIVE', 'score': 0.9974457025527954}]\n",
            "--------------------\n",
            "26\n",
            "[{'label': 'POSITIVE', 'score': 0.998695433139801}]\n",
            "--------------------\n",
            "27\n",
            "[{'label': 'POSITIVE', 'score': 0.9990187883377075}]\n",
            "--------------------\n",
            "28\n",
            "[{'label': 'NEGATIVE', 'score': 0.9972509741783142}]\n",
            "--------------------\n",
            "29\n",
            "[{'label': 'POSITIVE', 'score': 0.6629235744476318}]\n",
            "--------------------\n",
            "30\n",
            "[{'label': 'NEGATIVE', 'score': 0.9991071820259094}]\n",
            "--------------------\n",
            "31\n",
            "[{'label': 'POSITIVE', 'score': 0.9940304160118103}]\n",
            "--------------------\n",
            "32\n",
            "[{'label': 'NEGATIVE', 'score': 0.5832330584526062}]\n",
            "--------------------\n",
            "33\n",
            "[{'label': 'POSITIVE', 'score': 0.9928295016288757}]\n",
            "--------------------\n",
            "34\n",
            "[{'label': 'NEGATIVE', 'score': 0.9967216849327087}]\n",
            "--------------------\n",
            "35\n",
            "[{'label': 'POSITIVE', 'score': 0.9966579675674438}]\n",
            "--------------------\n",
            "36\n",
            "[{'label': 'NEGATIVE', 'score': 0.9487919211387634}]\n",
            "--------------------\n",
            "37\n",
            "[{'label': 'POSITIVE', 'score': 0.9886548519134521}]\n",
            "--------------------\n",
            "38\n",
            "[{'label': 'POSITIVE', 'score': 0.9861230850219727}]\n",
            "--------------------\n",
            "39\n",
            "[{'label': 'POSITIVE', 'score': 0.994685173034668}]\n",
            "--------------------\n",
            "40\n",
            "[{'label': 'NEGATIVE', 'score': 0.988084614276886}]\n",
            "--------------------\n",
            "41\n",
            "[{'label': 'POSITIVE', 'score': 0.9855238795280457}]\n",
            "--------------------\n",
            "42\n",
            "[{'label': 'POSITIVE', 'score': 0.999620795249939}]\n",
            "--------------------\n",
            "43\n",
            "[{'label': 'POSITIVE', 'score': 0.979430615901947}]\n",
            "--------------------\n",
            "44\n",
            "[{'label': 'POSITIVE', 'score': 0.9885107278823853}]\n",
            "--------------------\n",
            "45\n",
            "[{'label': 'POSITIVE', 'score': 0.9825224876403809}]\n",
            "--------------------\n",
            "46\n",
            "[{'label': 'NEGATIVE', 'score': 0.7254703640937805}]\n",
            "--------------------\n",
            "47\n",
            "[{'label': 'NEGATIVE', 'score': 0.9831183552742004}]\n",
            "--------------------\n",
            "48\n",
            "[{'label': 'NEGATIVE', 'score': 0.9989171028137207}]\n",
            "--------------------\n",
            "49\n",
            "[{'label': 'NEGATIVE', 'score': 0.9910486936569214}]\n"
          ]
        }
      ],
      "source": [
        "# loop through summary and apply the classifier on each one\n",
        "\n",
        "summary_df = df[\"summary\"]\n",
        "i = 0\n",
        "classified = []\n",
        "\n",
        "for text in summary_df:\n",
        "  print(20*\"-\")\n",
        "  print(i)\n",
        "  cl = classifier(text)\n",
        "  print(cl)\n",
        "  classified.append(cl)\n",
        "  i += 1\n",
        "  "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 61,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "b2xm4kWYlmsa",
        "outputId": "7886d182-9fdd-4052-bf8a-79d125a3d54e"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "--------------------\n",
            "0\n",
            "[{'label': 'NEGATIVE', 'score': 0.9890596866607666}]\n",
            "--------------------\n",
            "1\n",
            "[{'label': 'POSITIVE', 'score': 0.9929807186126709}]\n",
            "--------------------\n",
            "2\n",
            "[{'label': 'NEGATIVE', 'score': 0.6336014866828918}]\n",
            "--------------------\n",
            "3\n",
            "[{'label': 'NEGATIVE', 'score': 0.9963493347167969}]\n",
            "--------------------\n",
            "4\n",
            "[{'label': 'NEGATIVE', 'score': 0.9421991109848022}]\n",
            "--------------------\n",
            "5\n",
            "[{'label': 'POSITIVE', 'score': 0.9890474677085876}]\n",
            "--------------------\n",
            "6\n",
            "[{'label': 'POSITIVE', 'score': 0.9827921986579895}]\n",
            "--------------------\n",
            "7\n",
            "[{'label': 'POSITIVE', 'score': 0.9754440188407898}]\n",
            "--------------------\n",
            "8\n",
            "[{'label': 'NEGATIVE', 'score': 0.9503557682037354}]\n",
            "--------------------\n",
            "9\n",
            "[{'label': 'POSITIVE', 'score': 0.9950008988380432}]\n",
            "--------------------\n",
            "10\n",
            "[{'label': 'POSITIVE', 'score': 0.9805324673652649}]\n",
            "--------------------\n",
            "11\n",
            "[{'label': 'POSITIVE', 'score': 0.9762083292007446}]\n",
            "--------------------\n",
            "12\n",
            "[{'label': 'NEGATIVE', 'score': 0.982549786567688}]\n",
            "--------------------\n",
            "13\n",
            "[{'label': 'POSITIVE', 'score': 0.9905421137809753}]\n",
            "--------------------\n",
            "14\n",
            "[{'label': 'NEGATIVE', 'score': 0.9635395407676697}]\n",
            "--------------------\n",
            "15\n",
            "[{'label': 'POSITIVE', 'score': 0.9920122027397156}]\n",
            "--------------------\n",
            "16\n",
            "[{'label': 'POSITIVE', 'score': 0.9871898293495178}]\n",
            "--------------------\n",
            "17\n",
            "[{'label': 'NEGATIVE', 'score': 0.9992449283599854}]\n",
            "--------------------\n",
            "18\n",
            "[{'label': 'NEGATIVE', 'score': 0.9786222577095032}]\n",
            "--------------------\n",
            "19\n",
            "[{'label': 'POSITIVE', 'score': 0.9982072114944458}]\n",
            "--------------------\n",
            "20\n",
            "[{'label': 'NEGATIVE', 'score': 0.6955170035362244}]\n",
            "--------------------\n",
            "21\n",
            "[{'label': 'POSITIVE', 'score': 0.9986799359321594}]\n",
            "--------------------\n",
            "22\n",
            "[{'label': 'POSITIVE', 'score': 0.9987109899520874}]\n",
            "--------------------\n",
            "23\n",
            "[{'label': 'POSITIVE', 'score': 0.9962424039840698}]\n",
            "--------------------\n",
            "24\n",
            "[{'label': 'NEGATIVE', 'score': 0.9965094923973083}]\n",
            "--------------------\n",
            "25\n",
            "[{'label': 'POSITIVE', 'score': 0.9791437983512878}]\n",
            "--------------------\n",
            "26\n",
            "[{'label': 'POSITIVE', 'score': 0.7945953011512756}]\n",
            "--------------------\n",
            "27\n",
            "[{'label': 'NEGATIVE', 'score': 0.9806100130081177}]\n",
            "--------------------\n",
            "28\n",
            "[{'label': 'NEGATIVE', 'score': 0.9859712719917297}]\n",
            "--------------------\n",
            "29\n",
            "[{'label': 'POSITIVE', 'score': 0.9976790547370911}]\n",
            "--------------------\n",
            "30\n",
            "[{'label': 'NEGATIVE', 'score': 0.9993370175361633}]\n",
            "--------------------\n",
            "31\n",
            "[{'label': 'POSITIVE', 'score': 0.9745157361030579}]\n",
            "--------------------\n",
            "32\n",
            "[{'label': 'NEGATIVE', 'score': 0.9938568472862244}]\n",
            "--------------------\n",
            "33\n",
            "[{'label': 'POSITIVE', 'score': 0.9921831488609314}]\n",
            "--------------------\n",
            "34\n",
            "[{'label': 'NEGATIVE', 'score': 0.9787802696228027}]\n",
            "--------------------\n",
            "35\n",
            "[{'label': 'POSITIVE', 'score': 0.990727424621582}]\n",
            "--------------------\n",
            "36\n",
            "[{'label': 'POSITIVE', 'score': 0.9978309273719788}]\n",
            "--------------------\n",
            "37\n",
            "[{'label': 'POSITIVE', 'score': 0.9929782748222351}]\n",
            "--------------------\n",
            "38\n",
            "[{'label': 'POSITIVE', 'score': 0.9970292448997498}]\n",
            "--------------------\n",
            "39\n",
            "[{'label': 'POSITIVE', 'score': 0.868423581123352}]\n",
            "--------------------\n",
            "40\n",
            "[{'label': 'NEGATIVE', 'score': 0.9925006031990051}]\n",
            "--------------------\n",
            "41\n",
            "[{'label': 'POSITIVE', 'score': 0.9988977909088135}]\n",
            "--------------------\n",
            "42\n",
            "[{'label': 'POSITIVE', 'score': 0.9952794313430786}]\n",
            "--------------------\n",
            "43\n",
            "[{'label': 'NEGATIVE', 'score': 0.9311738610267639}]\n",
            "--------------------\n",
            "44\n",
            "[{'label': 'NEGATIVE', 'score': 0.906542956829071}]\n",
            "--------------------\n",
            "45\n",
            "[{'label': 'NEGATIVE', 'score': 0.6849626898765564}]\n",
            "--------------------\n",
            "46\n",
            "[{'label': 'NEGATIVE', 'score': 0.9995760321617126}]\n",
            "--------------------\n",
            "47\n",
            "[{'label': 'NEGATIVE', 'score': 0.9776803851127625}]\n",
            "--------------------\n",
            "48\n",
            "[{'label': 'NEGATIVE', 'score': 0.9983648657798767}]\n",
            "--------------------\n",
            "49\n",
            "[{'label': 'POSITIVE', 'score': 0.9915212392807007}]\n"
          ]
        }
      ],
      "source": [
        "# loop through titles and apply the classifier on each one\n",
        "\n",
        "title_df = df[\"title\"]\n",
        "i = 0\n",
        "classified_title = []\n",
        "\n",
        "for text in title_df:\n",
        "  print(20*\"-\")\n",
        "  print(i)\n",
        "  cl = classifier(text)\n",
        "  print(cl)\n",
        "  classified_title.append(cl)\n",
        "  i += 1\n",
        "  "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 62,
      "metadata": {
        "id": "zuGVVSdTg27k"
      },
      "outputs": [],
      "source": [
        "#classified"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 63,
      "metadata": {
        "id": "4O1124s_nibr"
      },
      "outputs": [],
      "source": [
        "labels_list = []\n",
        "labels_title_list = []\n",
        "\n",
        "for cl in classified:\n",
        "  #print(20*\"-\")\n",
        "  #print(cl[0][\"label\"])\n",
        "  labels_list.append(cl[0][\"label\"])\n",
        "\n",
        "for cl in classified_title:\n",
        "  #print(20*\"-\")\n",
        "  #print(cl[0][\"label\"])\n",
        "  labels_title_list.append(cl[0][\"label\"])  "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 64,
      "metadata": {
        "id": "qVibvJWRiEZ_"
      },
      "outputs": [],
      "source": [
        "df[\"classification\"] = labels_list\n",
        "df[\"classification_title\"] = labels_title_list"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 65,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "ET8L3-diia2K",
        "outputId": "55671719-f4f8-4835-ee75-4dcaf16f322f"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-1145dc68-51bc-401b-ba45-49c48767b3cd\">\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>title</th>\n",
              "      <th>country</th>\n",
              "      <th>summary</th>\n",
              "      <th>classification</th>\n",
              "      <th>classification_title</th>\n",
              "      <th>language</th>\n",
              "      <th>topic</th>\n",
              "      <th>link</th>\n",
              "      <th>published_date</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>US Gold IRA 401k Rollover 2022 Retirement Savi...</td>\n",
              "      <td>US</td>\n",
              "      <td>North Hills,United States - June 7, 2022 /Pres...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-07 08:07:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>South Africa's Gold Fields Buying Canada's Yam...</td>\n",
              "      <td>US</td>\n",
              "      <td>By The Daily Upside - May 31, 2022 at 9:00PM Y...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.fool.com/investing/2022/05/31/sout...</td>\n",
              "      <td>2022-06-01 01:00:13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ASA Gold and Precious Metals : Monthly Factshe...</td>\n",
              "      <td>US</td>\n",
              "      <td>(ASA)   Report April 30, 2022 Shares Ticker AS...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ASA...</td>\n",
              "      <td>2022-06-01 19:32:06</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>New Gold: Lower Grade And Tonnes Processed At ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Oat_Phawat/iStock via Getty Images Part I - In...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4515405-new-g...</td>\n",
              "      <td>2022-05-31 10:54:49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Gold Fields (GFI) to Acquire Yamana Gold for $...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Fields Limited GFI and Yamana Gold Inc. A...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://finance.yahoo.com/news/gold-fields-gfi...</td>\n",
              "      <td>2022-05-31 14:04:02</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Egypt awards eight gold and metal mining explo...</td>\n",
              "      <td>US</td>\n",
              "      <td>Four companies won the licences - Lotus Gold, ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/news/latest/Egy...</td>\n",
              "      <td>2022-06-01 09:41:08</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Buying Physical Gold And Silver: Here Is What ...</td>\n",
              "      <td>US</td>\n",
              "      <td>adventtr/E+ via Getty Images Gold and silver a...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4515483-buyin...</td>\n",
              "      <td>2022-05-31 16:11:53</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>GGCM develops a crypto platform for the cause ...</td>\n",
              "      <td>US</td>\n",
              "      <td>GGCM has recently launched a Gold Guaranteed C...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 01:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Cetera Investment Advisers Sells 8,195 Shares ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Cetera Investment Advisers lessened its stake ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-06 07:55:51</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Kingston Resources : Investor Presentation – R...</td>\n",
              "      <td>US</td>\n",
              "      <td>(KSN)   Report ASX: KSN Asia-Pacific Gold Prod...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/KIN...</td>\n",
              "      <td>2022-06-07 08:12:11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Yukon Explorer Looking to Start New Gold Rush</td>\n",
              "      <td>US</td>\n",
              "      <td>June 1, 2022 (Investorideas.com Newswire) With...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>2022-06-01 15:05:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>U.S. Gold Corp. Announces Live Webinar Hosted ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Red Cloud's Mining Analyst to Interview Chairm...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/U-S...</td>\n",
              "      <td>2022-06-01 12:48:04</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...</td>\n",
              "      <td>US</td>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY – Get Rating) was...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-02 01:54:42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>ShibDOSH – The World's First Gold Paying Rebas...</td>\n",
              "      <td>US</td>\n",
              "      <td>Return of Shiba, the revolutionary blockchain ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-06 12:54:02</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Public Sector Pension Investment Board Sells 2...</td>\n",
              "      <td>US</td>\n",
              "      <td>Public Sector Pension Investment Board decreas...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-03 07:56:44</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...</td>\n",
              "      <td>US</td>\n",
              "      <td>SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 11:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Western Copper and Gold : June 2022 Presentation</td>\n",
              "      <td>US</td>\n",
              "      <td>(WRN)   Report TSX WRN NYSE AMERICAN WRN DEVEL...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/WES...</td>\n",
              "      <td>2022-06-05 21:22:02</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Zacks Investment Research Downgrades Harmony G...</td>\n",
              "      <td>US</td>\n",
              "      <td>Harmony Gold Mining (NYSE:HMY – Get Rating) wa...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/zack...</td>\n",
              "      <td>2022-06-06 16:31:54</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>HighTower Advisors LLC Sells 54,389 Shares of ...</td>\n",
              "      <td>US</td>\n",
              "      <td>HighTower Advisors LLC reduced its position in...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-07 05:22:41</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>BTV Showcases Victoria Gold, Advance United, T...</td>\n",
              "      <td>US</td>\n",
              "      <td>(VGCX)   Report Discover Companies to Invest I...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/VIC...</td>\n",
              "      <td>2022-06-02 13:05:01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Gold price today, June 5: Gold rates drop afte...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold price today (June 5, 2022) decreased marg...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-06-05 02:31:04</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>RING (RING): Gold Mining Companies Are Probabl...</td>\n",
              "      <td>US</td>\n",
              "      <td>chonticha wat/iStock via Getty Images iShares ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4516774-ring-...</td>\n",
              "      <td>2022-06-07 04:09:45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Gold Fields to Acquire Yamana Gold – a Combina...</td>\n",
              "      <td>US</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>2022-05-31 05:45:01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>REPEAT -- Gold Fields to Acquire Yamana Gold –...</td>\n",
              "      <td>US</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>2022-05-31 11:02:02</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/equi...</td>\n",
              "      <td>2022-05-31 02:31:05</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>These 2 Mergers Are the Real (Asset) Deal</td>\n",
              "      <td>US</td>\n",
              "      <td>The stock market had a nice bounce last week, ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.fool.com/investing/2022/05/31/thes...</td>\n",
              "      <td>2022-05-31 12:29:01</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.</td>\n",
              "      <td>US</td>\n",
              "      <td>(GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>2022-05-31 13:31:46</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>How to buy Sovereign Gold Bonds: All you need ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold bonds are considered one of the best opti...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/how-...</td>\n",
              "      <td>2022-05-31 14:03:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Thinking about buying stock in Mullen Automoti...</td>\n",
              "      <td>US</td>\n",
              "      <td>NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/TAL...</td>\n",
              "      <td>2022-05-31 15:16:05</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>S.Africa's Gold Fields to become fourth bigges...</td>\n",
              "      <td>US</td>\n",
              "      <td>Shares in the South Africa-listed mining compa...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/news/latest/S-A...</td>\n",
              "      <td>2022-05-31 15:16:30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR) Rating Lowered...</td>\n",
              "      <td>US</td>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR – Get Rating) w...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/06/02/osisko...</td>\n",
              "      <td>2022-06-02 08:18:43</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Global Demand for Silver Could Hit a Record in...</td>\n",
              "      <td>US</td>\n",
              "      <td>​​FN Media Group Presents Microsmallcap.com Ma...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-01 13:15:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Gold prices today, 4 June 2022: Yellow metal g...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold prices today (June 4) increased by Rs 50 ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-06-04 02:31:03</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...</td>\n",
              "      <td>US</td>\n",
              "      <td>Vancouver, British Columbia - (May 31, 2022) -...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ROV...</td>\n",
              "      <td>2022-05-31 10:10:36</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...</td>\n",
              "      <td>US</td>\n",
              "      <td>Blair William &amp; Co. IL cut its stake in shares...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-01 07:54:46</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Gold Fields : to Acquire Yamana Gold</td>\n",
              "      <td>US</td>\n",
              "      <td>(GFI)   Report Gold Fields Limited (Reg. No. 1...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>2022-05-31 05:40:55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Money Mindset: These Expert Tips Will Help You...</td>\n",
              "      <td>US</td>\n",
              "      <td>By Jasmine Browley · Updated June 4, 2022 CNBC...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.essence.com/news/money-career/expe...</td>\n",
              "      <td>2022-06-07 12:21:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>First Stepout Drill Results Promising for Gold...</td>\n",
              "      <td>US</td>\n",
              "      <td>June 3, 2022 (Investorideas.com Newswire) As O...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>2022-06-03 13:15:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Pure Gold Mining : Corporate Presentation – Ju...</td>\n",
              "      <td>US</td>\n",
              "      <td>(PGM)   Report The Heart of Red Lake. PureGold...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/PUR...</td>\n",
              "      <td>2022-06-01 21:52:24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>Tennessee Governor Signs Full Repeal of Sales ...</td>\n",
              "      <td>US</td>\n",
              "      <td>With Governor Bill Lee's signature on Friday, ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 05:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>Gold Fields (NYSE:GFI) Shares Gap Down to $12.20</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Fields Limited (NYSE:GFI – Get Rating) sh...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/05/31/gold-f...</td>\n",
              "      <td>2022-05-31 10:58:46</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>RING: Gold Mining Companies Are Probably Fairl...</td>\n",
              "      <td>US</td>\n",
              "      <td>RING invests in gold mining companies. RING's ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/ring...</td>\n",
              "      <td>2022-06-07 04:31:23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>Area Development's 17th Annual Shovel Awards R...</td>\n",
              "      <td>US</td>\n",
              "      <td>Area Development, the leading publication cove...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-03 14:00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>Invesco Ltd. Purchases 263,880 Shares of Alamo...</td>\n",
              "      <td>US</td>\n",
              "      <td>Invesco Ltd. boosted its position in shares of...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-07 05:18:43</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Exploring Mining Podcast 278</td>\n",
              "      <td>US</td>\n",
              "      <td>Vancouver, Kelowna, Delta, BC - May 31, 2022 (...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/explor...</td>\n",
              "      <td>2022-05-31 14:30:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>GSA Capital Partners LLP Buys New Position in ...</td>\n",
              "      <td>US</td>\n",
              "      <td>GSA Capital Partners LLP bought a new stake in...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-07 05:36:41</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Gold Rates In India Are On The Verge Of Fallin...</td>\n",
              "      <td>US</td>\n",
              "      <td>Indian gold markets are expected to be under p...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-05-31 12:32:14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Flowery Gold Mines : Ending 9-30-2021 FGMC Una...</td>\n",
              "      <td>US</td>\n",
              "      <td>(FLOD) The Flowery Gold Mines Company of Nevad...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/FLO...</td>\n",
              "      <td>2022-06-02 19:22:10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Jaguar Mining: Inflationary Pressures Wreak Ha...</td>\n",
              "      <td>US</td>\n",
              "      <td>agnormark/iStock via Getty Images The Q1 Earni...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4516497-jagua...</td>\n",
              "      <td>2022-06-05 02:23:59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Sensex, Nifty Rally As Tech Stocks Surge</td>\n",
              "      <td>US</td>\n",
              "      <td>(RTTNews) - Indian shares followed global peer...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.businessinsider.com/news/stock...</td>\n",
              "      <td>2022-06-03 06:14:07</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1145dc68-51bc-401b-ba45-49c48767b3cd')\"\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-1145dc68-51bc-401b-ba45-49c48767b3cd 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-1145dc68-51bc-401b-ba45-49c48767b3cd');\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",
              "  "
            ],
            "text/plain": [
              "                                                title country  \\\n",
              "0   US Gold IRA 401k Rollover 2022 Retirement Savi...      US   \n",
              "1   South Africa's Gold Fields Buying Canada's Yam...      US   \n",
              "2   ASA Gold and Precious Metals : Monthly Factshe...      US   \n",
              "3   New Gold: Lower Grade And Tonnes Processed At ...      US   \n",
              "4   Gold Fields (GFI) to Acquire Yamana Gold for $...      US   \n",
              "5   Egypt awards eight gold and metal mining explo...      US   \n",
              "6   Buying Physical Gold And Silver: Here Is What ...      US   \n",
              "7   GGCM develops a crypto platform for the cause ...      US   \n",
              "8   Cetera Investment Advisers Sells 8,195 Shares ...      US   \n",
              "9   Kingston Resources : Investor Presentation – R...      US   \n",
              "10      Yukon Explorer Looking to Start New Gold Rush      US   \n",
              "11  U.S. Gold Corp. Announces Live Webinar Hosted ...      US   \n",
              "12  Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...      US   \n",
              "13  ShibDOSH – The World's First Gold Paying Rebas...      US   \n",
              "14  Public Sector Pension Investment Board Sells 2...      US   \n",
              "15  Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...      US   \n",
              "16   Western Copper and Gold : June 2022 Presentation      US   \n",
              "17  Zacks Investment Research Downgrades Harmony G...      US   \n",
              "18  HighTower Advisors LLC Sells 54,389 Shares of ...      US   \n",
              "19  BTV Showcases Victoria Gold, Advance United, T...      US   \n",
              "20  Gold price today, June 5: Gold rates drop afte...      US   \n",
              "21  RING (RING): Gold Mining Companies Are Probabl...      US   \n",
              "22  Gold Fields to Acquire Yamana Gold – a Combina...      US   \n",
              "23  REPEAT -- Gold Fields to Acquire Yamana Gold –...      US   \n",
              "24  Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...      US   \n",
              "25          These 2 Mergers Are the Real (Asset) Deal      US   \n",
              "26          GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.      US   \n",
              "27  How to buy Sovereign Gold Bonds: All you need ...      US   \n",
              "28  Thinking about buying stock in Mullen Automoti...      US   \n",
              "29  S.Africa's Gold Fields to become fourth bigges...      US   \n",
              "30  Osisko Gold Royalties (NYSE:OR) Rating Lowered...      US   \n",
              "31  Global Demand for Silver Could Hit a Record in...      US   \n",
              "32  Gold prices today, 4 June 2022: Yellow metal g...      US   \n",
              "33  ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...      US   \n",
              "34  Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...      US   \n",
              "35               Gold Fields : to Acquire Yamana Gold      US   \n",
              "36  Money Mindset: These Expert Tips Will Help You...      US   \n",
              "37  First Stepout Drill Results Promising for Gold...      US   \n",
              "38  Pure Gold Mining : Corporate Presentation – Ju...      US   \n",
              "39  Tennessee Governor Signs Full Repeal of Sales ...      US   \n",
              "40   Gold Fields (NYSE:GFI) Shares Gap Down to $12.20      US   \n",
              "41  RING: Gold Mining Companies Are Probably Fairl...      US   \n",
              "42  Area Development's 17th Annual Shovel Awards R...      US   \n",
              "43  Invesco Ltd. Purchases 263,880 Shares of Alamo...      US   \n",
              "44                       Exploring Mining Podcast 278      US   \n",
              "45  GSA Capital Partners LLP Buys New Position in ...      US   \n",
              "46  Gold Rates In India Are On The Verge Of Fallin...      US   \n",
              "47  Flowery Gold Mines : Ending 9-30-2021 FGMC Una...      US   \n",
              "48  Jaguar Mining: Inflationary Pressures Wreak Ha...      US   \n",
              "49           Sensex, Nifty Rally As Tech Stocks Surge      US   \n",
              "\n",
              "                                              summary classification  \\\n",
              "0   North Hills,United States - June 7, 2022 /Pres...       POSITIVE   \n",
              "1   By The Daily Upside - May 31, 2022 at 9:00PM Y...       POSITIVE   \n",
              "2   (ASA)   Report April 30, 2022 Shares Ticker AS...       NEGATIVE   \n",
              "3   Oat_Phawat/iStock via Getty Images Part I - In...       NEGATIVE   \n",
              "4   Gold Fields Limited GFI and Yamana Gold Inc. A...       POSITIVE   \n",
              "5   Four companies won the licences - Lotus Gold, ...       NEGATIVE   \n",
              "6   adventtr/E+ via Getty Images Gold and silver a...       NEGATIVE   \n",
              "7   GGCM has recently launched a Gold Guaranteed C...       POSITIVE   \n",
              "8   Cetera Investment Advisers lessened its stake ...       NEGATIVE   \n",
              "9   (KSN)   Report ASX: KSN Asia-Pacific Gold Prod...       POSITIVE   \n",
              "10  June 1, 2022 (Investorideas.com Newswire) With...       POSITIVE   \n",
              "11  Red Cloud's Mining Analyst to Interview Chairm...       POSITIVE   \n",
              "12  Fury Gold Mines (NASDAQ:FURY – Get Rating) was...       NEGATIVE   \n",
              "13  Return of Shiba, the revolutionary blockchain ...       POSITIVE   \n",
              "14  Public Sector Pension Investment Board decreas...       NEGATIVE   \n",
              "15  SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...       POSITIVE   \n",
              "16  (WRN)   Report TSX WRN NYSE AMERICAN WRN DEVEL...       NEGATIVE   \n",
              "17  Harmony Gold Mining (NYSE:HMY – Get Rating) wa...       NEGATIVE   \n",
              "18  HighTower Advisors LLC reduced its position in...       NEGATIVE   \n",
              "19  (VGCX)   Report Discover Companies to Invest I...       POSITIVE   \n",
              "20  Gold price today (June 5, 2022) decreased marg...       NEGATIVE   \n",
              "21  chonticha wat/iStock via Getty Images iShares ...       POSITIVE   \n",
              "22  (YRI)   Report Transaction creates a top-4 glo...       POSITIVE   \n",
              "23  (YRI)   Report Transaction creates a top-4 glo...       POSITIVE   \n",
              "24  Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...       NEGATIVE   \n",
              "25  The stock market had a nice bounce last week, ...       NEGATIVE   \n",
              "26  (GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...       POSITIVE   \n",
              "27  Gold bonds are considered one of the best opti...       POSITIVE   \n",
              "28  NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...       NEGATIVE   \n",
              "29  Shares in the South Africa-listed mining compa...       POSITIVE   \n",
              "30  Osisko Gold Royalties (NYSE:OR – Get Rating) w...       NEGATIVE   \n",
              "31  ​​FN Media Group Presents Microsmallcap.com Ma...       POSITIVE   \n",
              "32  Gold prices today (June 4) increased by Rs 50 ...       NEGATIVE   \n",
              "33  Vancouver, British Columbia - (May 31, 2022) -...       POSITIVE   \n",
              "34  Blair William & Co. IL cut its stake in shares...       NEGATIVE   \n",
              "35  (GFI)   Report Gold Fields Limited (Reg. No. 1...       POSITIVE   \n",
              "36  By Jasmine Browley · Updated June 4, 2022 CNBC...       NEGATIVE   \n",
              "37  June 3, 2022 (Investorideas.com Newswire) As O...       POSITIVE   \n",
              "38  (PGM)   Report The Heart of Red Lake. PureGold...       POSITIVE   \n",
              "39  With Governor Bill Lee's signature on Friday, ...       POSITIVE   \n",
              "40  Gold Fields Limited (NYSE:GFI – Get Rating) sh...       NEGATIVE   \n",
              "41  RING invests in gold mining companies. RING's ...       POSITIVE   \n",
              "42  Area Development, the leading publication cove...       POSITIVE   \n",
              "43  Invesco Ltd. boosted its position in shares of...       POSITIVE   \n",
              "44  Vancouver, Kelowna, Delta, BC - May 31, 2022 (...       POSITIVE   \n",
              "45  GSA Capital Partners LLP bought a new stake in...       POSITIVE   \n",
              "46  Indian gold markets are expected to be under p...       NEGATIVE   \n",
              "47  (FLOD) The Flowery Gold Mines Company of Nevad...       NEGATIVE   \n",
              "48  agnormark/iStock via Getty Images The Q1 Earni...       NEGATIVE   \n",
              "49  (RTTNews) - Indian shares followed global peer...       NEGATIVE   \n",
              "\n",
              "   classification_title language    topic  \\\n",
              "0              NEGATIVE       en  finance   \n",
              "1              POSITIVE       en  finance   \n",
              "2              NEGATIVE       en  finance   \n",
              "3              NEGATIVE       en  finance   \n",
              "4              NEGATIVE       en  finance   \n",
              "5              POSITIVE       en  finance   \n",
              "6              POSITIVE       en  finance   \n",
              "7              POSITIVE       en  finance   \n",
              "8              NEGATIVE       en  finance   \n",
              "9              POSITIVE       en  finance   \n",
              "10             POSITIVE       en  finance   \n",
              "11             POSITIVE       en  finance   \n",
              "12             NEGATIVE       en  finance   \n",
              "13             POSITIVE       en  finance   \n",
              "14             NEGATIVE       en  finance   \n",
              "15             POSITIVE       en  finance   \n",
              "16             POSITIVE       en  finance   \n",
              "17             NEGATIVE       en  finance   \n",
              "18             NEGATIVE       en  finance   \n",
              "19             POSITIVE       en  finance   \n",
              "20             NEGATIVE       en  finance   \n",
              "21             POSITIVE       en  finance   \n",
              "22             POSITIVE       en  finance   \n",
              "23             POSITIVE       en  finance   \n",
              "24             NEGATIVE       en  finance   \n",
              "25             POSITIVE       en  finance   \n",
              "26             POSITIVE       en  finance   \n",
              "27             NEGATIVE       en  finance   \n",
              "28             NEGATIVE       en  finance   \n",
              "29             POSITIVE       en  finance   \n",
              "30             NEGATIVE       en  finance   \n",
              "31             POSITIVE       en  finance   \n",
              "32             NEGATIVE       en  finance   \n",
              "33             POSITIVE       en  finance   \n",
              "34             NEGATIVE       en  finance   \n",
              "35             POSITIVE       en  finance   \n",
              "36             POSITIVE       en  finance   \n",
              "37             POSITIVE       en  finance   \n",
              "38             POSITIVE       en  finance   \n",
              "39             POSITIVE       en  finance   \n",
              "40             NEGATIVE       en  finance   \n",
              "41             POSITIVE       en  finance   \n",
              "42             POSITIVE       en  finance   \n",
              "43             NEGATIVE       en  finance   \n",
              "44             NEGATIVE       en  finance   \n",
              "45             NEGATIVE       en  finance   \n",
              "46             NEGATIVE       en  finance   \n",
              "47             NEGATIVE       en  finance   \n",
              "48             NEGATIVE       en  finance   \n",
              "49             POSITIVE       en  finance   \n",
              "\n",
              "                                                 link       published_date  \n",
              "0   https://markets.financialcontent.com/stocks/ar...  2022-06-07 08:07:00  \n",
              "1   https://www.fool.com/investing/2022/05/31/sout...  2022-06-01 01:00:13  \n",
              "2   https://www.marketscreener.com/quote/stock/ASA...  2022-06-01 19:32:06  \n",
              "3   https://seekingalpha.com/article/4515405-new-g...  2022-05-31 10:54:49  \n",
              "4   https://finance.yahoo.com/news/gold-fields-gfi...  2022-05-31 14:04:02  \n",
              "5   https://www.marketscreener.com/news/latest/Egy...  2022-06-01 09:41:08  \n",
              "6   https://seekingalpha.com/article/4515483-buyin...  2022-05-31 16:11:53  \n",
              "7   https://markets.financialcontent.com/stocks/ar...  2022-05-31 01:30:00  \n",
              "8   https://www.tickerreport.com/banking-finance/8...  2022-06-06 07:55:51  \n",
              "9   https://www.marketscreener.com/quote/stock/KIN...  2022-06-07 08:12:11  \n",
              "10  https://www.investorideas.com/news/2022/mining...  2022-06-01 15:05:00  \n",
              "11  https://www.marketscreener.com/quote/stock/U-S...  2022-06-01 12:48:04  \n",
              "12  https://www.tickerreport.com/banking-finance/8...  2022-06-02 01:54:42  \n",
              "13  https://markets.financialcontent.com/stocks/ar...  2022-06-06 12:54:02  \n",
              "14  https://www.tickerreport.com/banking-finance/8...  2022-06-03 07:56:44  \n",
              "15  https://markets.financialcontent.com/stocks/ar...  2022-05-31 11:30:00  \n",
              "16  https://www.marketscreener.com/quote/stock/WES...  2022-06-05 21:22:02  \n",
              "17  https://forextv.com/xauusd-gold-us-dollar/zack...  2022-06-06 16:31:54  \n",
              "18  https://www.tickerreport.com/banking-finance/8...  2022-06-07 05:22:41  \n",
              "19  https://www.marketscreener.com/quote/stock/VIC...  2022-06-02 13:05:01  \n",
              "20  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-06-05 02:31:04  \n",
              "21  https://seekingalpha.com/article/4516774-ring-...  2022-06-07 04:09:45  \n",
              "22  https://www.marketscreener.com/quote/stock/YAM...  2022-05-31 05:45:01  \n",
              "23  https://www.marketscreener.com/quote/stock/YAM...  2022-05-31 11:02:02  \n",
              "24  https://forextv.com/xauusd-gold-us-dollar/equi...  2022-05-31 02:31:05  \n",
              "25  https://www.fool.com/investing/2022/05/31/thes...  2022-05-31 12:29:01  \n",
              "26  https://www.marketscreener.com/quote/stock/GOL...  2022-05-31 13:31:46  \n",
              "27  https://forextv.com/xauusd-gold-us-dollar/how-...  2022-05-31 14:03:00  \n",
              "28  https://www.marketscreener.com/quote/stock/TAL...  2022-05-31 15:16:05  \n",
              "29  https://www.marketscreener.com/news/latest/S-A...  2022-05-31 15:16:30  \n",
              "30  https://www.thecerbatgem.com/2022/06/02/osisko...  2022-06-02 08:18:43  \n",
              "31  https://markets.financialcontent.com/stocks/ar...  2022-06-01 13:15:00  \n",
              "32  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-06-04 02:31:03  \n",
              "33  https://www.marketscreener.com/quote/stock/ROV...  2022-05-31 10:10:36  \n",
              "34  https://www.tickerreport.com/banking-finance/8...  2022-06-01 07:54:46  \n",
              "35  https://www.marketscreener.com/quote/stock/GOL...  2022-05-31 05:40:55  \n",
              "36  https://www.essence.com/news/money-career/expe...  2022-06-07 12:21:00  \n",
              "37  https://www.investorideas.com/news/2022/mining...  2022-06-03 13:15:00  \n",
              "38  https://www.marketscreener.com/quote/stock/PUR...  2022-06-01 21:52:24  \n",
              "39  https://markets.financialcontent.com/stocks/ar...  2022-05-31 05:00:00  \n",
              "40  https://www.thecerbatgem.com/2022/05/31/gold-f...  2022-05-31 10:58:46  \n",
              "41  https://forextv.com/xauusd-gold-us-dollar/ring...  2022-06-07 04:31:23  \n",
              "42  https://markets.financialcontent.com/stocks/ar...  2022-06-03 14:00:00  \n",
              "43  https://www.tickerreport.com/banking-finance/8...  2022-06-07 05:18:43  \n",
              "44  https://www.investorideas.com/news/2022/explor...  2022-05-31 14:30:00  \n",
              "45  https://www.tickerreport.com/banking-finance/8...  2022-06-07 05:36:41  \n",
              "46  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-05-31 12:32:14  \n",
              "47  https://www.marketscreener.com/quote/stock/FLO...  2022-06-02 19:22:10  \n",
              "48  https://seekingalpha.com/article/4516497-jagua...  2022-06-05 02:23:59  \n",
              "49  https://markets.businessinsider.com/news/stock...  2022-06-03 06:14:07  "
            ]
          },
          "execution_count": 65,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df3 = df[[\"title\", \"country\", \"summary\", \"classification\", \"classification_title\", \"language\", \"topic\", \"link\", \"published_date\"]]\n",
        "df3"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 66,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "lLvqbBZgs7Sg",
        "outputId": "6ca13641-c52c-4ea1-a1cb-9a5870d24124"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:5: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  \"\"\"\n"
          ]
        },
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-08c0c164-0cae-4b50-b5a3-29ee0b6516fd\">\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>title</th>\n",
              "      <th>country</th>\n",
              "      <th>summary</th>\n",
              "      <th>classification</th>\n",
              "      <th>classification_title</th>\n",
              "      <th>language</th>\n",
              "      <th>topic</th>\n",
              "      <th>link</th>\n",
              "      <th>published_date</th>\n",
              "      <th>review</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>US Gold IRA 401k Rollover 2022 Retirement Savi...</td>\n",
              "      <td>US</td>\n",
              "      <td>North Hills,United States - June 7, 2022 /Pres...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-07 08:07:00</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>South Africa's Gold Fields Buying Canada's Yam...</td>\n",
              "      <td>US</td>\n",
              "      <td>By The Daily Upside - May 31, 2022 at 9:00PM Y...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.fool.com/investing/2022/05/31/sout...</td>\n",
              "      <td>2022-06-01 01:00:13</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ASA Gold and Precious Metals : Monthly Factshe...</td>\n",
              "      <td>US</td>\n",
              "      <td>(ASA)   Report April 30, 2022 Shares Ticker AS...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ASA...</td>\n",
              "      <td>2022-06-01 19:32:06</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>New Gold: Lower Grade And Tonnes Processed At ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Oat_Phawat/iStock via Getty Images Part I - In...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4515405-new-g...</td>\n",
              "      <td>2022-05-31 10:54:49</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Gold Fields (GFI) to Acquire Yamana Gold for $...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Fields Limited GFI and Yamana Gold Inc. A...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://finance.yahoo.com/news/gold-fields-gfi...</td>\n",
              "      <td>2022-05-31 14:04:02</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Egypt awards eight gold and metal mining explo...</td>\n",
              "      <td>US</td>\n",
              "      <td>Four companies won the licences - Lotus Gold, ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/news/latest/Egy...</td>\n",
              "      <td>2022-06-01 09:41:08</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Buying Physical Gold And Silver: Here Is What ...</td>\n",
              "      <td>US</td>\n",
              "      <td>adventtr/E+ via Getty Images Gold and silver a...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4515483-buyin...</td>\n",
              "      <td>2022-05-31 16:11:53</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>GGCM develops a crypto platform for the cause ...</td>\n",
              "      <td>US</td>\n",
              "      <td>GGCM has recently launched a Gold Guaranteed C...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 01:30:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Cetera Investment Advisers Sells 8,195 Shares ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Cetera Investment Advisers lessened its stake ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-06 07:55:51</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Kingston Resources : Investor Presentation – R...</td>\n",
              "      <td>US</td>\n",
              "      <td>(KSN)   Report ASX: KSN Asia-Pacific Gold Prod...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/KIN...</td>\n",
              "      <td>2022-06-07 08:12:11</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Yukon Explorer Looking to Start New Gold Rush</td>\n",
              "      <td>US</td>\n",
              "      <td>June 1, 2022 (Investorideas.com Newswire) With...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>2022-06-01 15:05:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>U.S. Gold Corp. Announces Live Webinar Hosted ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Red Cloud's Mining Analyst to Interview Chairm...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/U-S...</td>\n",
              "      <td>2022-06-01 12:48:04</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...</td>\n",
              "      <td>US</td>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY – Get Rating) was...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-02 01:54:42</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>ShibDOSH – The World's First Gold Paying Rebas...</td>\n",
              "      <td>US</td>\n",
              "      <td>Return of Shiba, the revolutionary blockchain ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-06 12:54:02</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Public Sector Pension Investment Board Sells 2...</td>\n",
              "      <td>US</td>\n",
              "      <td>Public Sector Pension Investment Board decreas...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-03 07:56:44</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...</td>\n",
              "      <td>US</td>\n",
              "      <td>SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 11:30:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Western Copper and Gold : June 2022 Presentation</td>\n",
              "      <td>US</td>\n",
              "      <td>(WRN)   Report TSX WRN NYSE AMERICAN WRN DEVEL...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/WES...</td>\n",
              "      <td>2022-06-05 21:22:02</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Zacks Investment Research Downgrades Harmony G...</td>\n",
              "      <td>US</td>\n",
              "      <td>Harmony Gold Mining (NYSE:HMY – Get Rating) wa...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/zack...</td>\n",
              "      <td>2022-06-06 16:31:54</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>HighTower Advisors LLC Sells 54,389 Shares of ...</td>\n",
              "      <td>US</td>\n",
              "      <td>HighTower Advisors LLC reduced its position in...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-07 05:22:41</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>BTV Showcases Victoria Gold, Advance United, T...</td>\n",
              "      <td>US</td>\n",
              "      <td>(VGCX)   Report Discover Companies to Invest I...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/VIC...</td>\n",
              "      <td>2022-06-02 13:05:01</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Gold price today, June 5: Gold rates drop afte...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold price today (June 5, 2022) decreased marg...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-06-05 02:31:04</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>RING (RING): Gold Mining Companies Are Probabl...</td>\n",
              "      <td>US</td>\n",
              "      <td>chonticha wat/iStock via Getty Images iShares ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4516774-ring-...</td>\n",
              "      <td>2022-06-07 04:09:45</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Gold Fields to Acquire Yamana Gold – a Combina...</td>\n",
              "      <td>US</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>2022-05-31 05:45:01</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>REPEAT -- Gold Fields to Acquire Yamana Gold –...</td>\n",
              "      <td>US</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>2022-05-31 11:02:02</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/equi...</td>\n",
              "      <td>2022-05-31 02:31:05</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>These 2 Mergers Are the Real (Asset) Deal</td>\n",
              "      <td>US</td>\n",
              "      <td>The stock market had a nice bounce last week, ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.fool.com/investing/2022/05/31/thes...</td>\n",
              "      <td>2022-05-31 12:29:01</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.</td>\n",
              "      <td>US</td>\n",
              "      <td>(GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>2022-05-31 13:31:46</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>How to buy Sovereign Gold Bonds: All you need ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold bonds are considered one of the best opti...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/how-...</td>\n",
              "      <td>2022-05-31 14:03:00</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Thinking about buying stock in Mullen Automoti...</td>\n",
              "      <td>US</td>\n",
              "      <td>NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/TAL...</td>\n",
              "      <td>2022-05-31 15:16:05</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>S.Africa's Gold Fields to become fourth bigges...</td>\n",
              "      <td>US</td>\n",
              "      <td>Shares in the South Africa-listed mining compa...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/news/latest/S-A...</td>\n",
              "      <td>2022-05-31 15:16:30</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR) Rating Lowered...</td>\n",
              "      <td>US</td>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR – Get Rating) w...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/06/02/osisko...</td>\n",
              "      <td>2022-06-02 08:18:43</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Global Demand for Silver Could Hit a Record in...</td>\n",
              "      <td>US</td>\n",
              "      <td>​​FN Media Group Presents Microsmallcap.com Ma...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-01 13:15:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Gold prices today, 4 June 2022: Yellow metal g...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold prices today (June 4) increased by Rs 50 ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-06-04 02:31:03</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...</td>\n",
              "      <td>US</td>\n",
              "      <td>Vancouver, British Columbia - (May 31, 2022) -...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ROV...</td>\n",
              "      <td>2022-05-31 10:10:36</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...</td>\n",
              "      <td>US</td>\n",
              "      <td>Blair William &amp; Co. IL cut its stake in shares...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-01 07:54:46</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Gold Fields : to Acquire Yamana Gold</td>\n",
              "      <td>US</td>\n",
              "      <td>(GFI)   Report Gold Fields Limited (Reg. No. 1...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>2022-05-31 05:40:55</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Money Mindset: These Expert Tips Will Help You...</td>\n",
              "      <td>US</td>\n",
              "      <td>By Jasmine Browley · Updated June 4, 2022 CNBC...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.essence.com/news/money-career/expe...</td>\n",
              "      <td>2022-06-07 12:21:00</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>First Stepout Drill Results Promising for Gold...</td>\n",
              "      <td>US</td>\n",
              "      <td>June 3, 2022 (Investorideas.com Newswire) As O...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>2022-06-03 13:15:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Pure Gold Mining : Corporate Presentation – Ju...</td>\n",
              "      <td>US</td>\n",
              "      <td>(PGM)   Report The Heart of Red Lake. PureGold...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/PUR...</td>\n",
              "      <td>2022-06-01 21:52:24</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>Tennessee Governor Signs Full Repeal of Sales ...</td>\n",
              "      <td>US</td>\n",
              "      <td>With Governor Bill Lee's signature on Friday, ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 05:00:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>Gold Fields (NYSE:GFI) Shares Gap Down to $12.20</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Fields Limited (NYSE:GFI – Get Rating) sh...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/05/31/gold-f...</td>\n",
              "      <td>2022-05-31 10:58:46</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>RING: Gold Mining Companies Are Probably Fairl...</td>\n",
              "      <td>US</td>\n",
              "      <td>RING invests in gold mining companies. RING's ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/ring...</td>\n",
              "      <td>2022-06-07 04:31:23</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>Area Development's 17th Annual Shovel Awards R...</td>\n",
              "      <td>US</td>\n",
              "      <td>Area Development, the leading publication cove...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-03 14:00:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>Invesco Ltd. Purchases 263,880 Shares of Alamo...</td>\n",
              "      <td>US</td>\n",
              "      <td>Invesco Ltd. boosted its position in shares of...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-07 05:18:43</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Exploring Mining Podcast 278</td>\n",
              "      <td>US</td>\n",
              "      <td>Vancouver, Kelowna, Delta, BC - May 31, 2022 (...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/explor...</td>\n",
              "      <td>2022-05-31 14:30:00</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>GSA Capital Partners LLP Buys New Position in ...</td>\n",
              "      <td>US</td>\n",
              "      <td>GSA Capital Partners LLP bought a new stake in...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-07 05:36:41</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Gold Rates In India Are On The Verge Of Fallin...</td>\n",
              "      <td>US</td>\n",
              "      <td>Indian gold markets are expected to be under p...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-05-31 12:32:14</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Flowery Gold Mines : Ending 9-30-2021 FGMC Una...</td>\n",
              "      <td>US</td>\n",
              "      <td>(FLOD) The Flowery Gold Mines Company of Nevad...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/FLO...</td>\n",
              "      <td>2022-06-02 19:22:10</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Jaguar Mining: Inflationary Pressures Wreak Ha...</td>\n",
              "      <td>US</td>\n",
              "      <td>agnormark/iStock via Getty Images The Q1 Earni...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4516497-jagua...</td>\n",
              "      <td>2022-06-05 02:23:59</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Sensex, Nifty Rally As Tech Stocks Surge</td>\n",
              "      <td>US</td>\n",
              "      <td>(RTTNews) - Indian shares followed global peer...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.businessinsider.com/news/stock...</td>\n",
              "      <td>2022-06-03 06:14:07</td>\n",
              "      <td>True</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-08c0c164-0cae-4b50-b5a3-29ee0b6516fd')\"\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-08c0c164-0cae-4b50-b5a3-29ee0b6516fd 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-08c0c164-0cae-4b50-b5a3-29ee0b6516fd');\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",
              "  "
            ],
            "text/plain": [
              "                                                title country  \\\n",
              "0   US Gold IRA 401k Rollover 2022 Retirement Savi...      US   \n",
              "1   South Africa's Gold Fields Buying Canada's Yam...      US   \n",
              "2   ASA Gold and Precious Metals : Monthly Factshe...      US   \n",
              "3   New Gold: Lower Grade And Tonnes Processed At ...      US   \n",
              "4   Gold Fields (GFI) to Acquire Yamana Gold for $...      US   \n",
              "5   Egypt awards eight gold and metal mining explo...      US   \n",
              "6   Buying Physical Gold And Silver: Here Is What ...      US   \n",
              "7   GGCM develops a crypto platform for the cause ...      US   \n",
              "8   Cetera Investment Advisers Sells 8,195 Shares ...      US   \n",
              "9   Kingston Resources : Investor Presentation – R...      US   \n",
              "10      Yukon Explorer Looking to Start New Gold Rush      US   \n",
              "11  U.S. Gold Corp. Announces Live Webinar Hosted ...      US   \n",
              "12  Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...      US   \n",
              "13  ShibDOSH – The World's First Gold Paying Rebas...      US   \n",
              "14  Public Sector Pension Investment Board Sells 2...      US   \n",
              "15  Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...      US   \n",
              "16   Western Copper and Gold : June 2022 Presentation      US   \n",
              "17  Zacks Investment Research Downgrades Harmony G...      US   \n",
              "18  HighTower Advisors LLC Sells 54,389 Shares of ...      US   \n",
              "19  BTV Showcases Victoria Gold, Advance United, T...      US   \n",
              "20  Gold price today, June 5: Gold rates drop afte...      US   \n",
              "21  RING (RING): Gold Mining Companies Are Probabl...      US   \n",
              "22  Gold Fields to Acquire Yamana Gold – a Combina...      US   \n",
              "23  REPEAT -- Gold Fields to Acquire Yamana Gold –...      US   \n",
              "24  Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...      US   \n",
              "25          These 2 Mergers Are the Real (Asset) Deal      US   \n",
              "26          GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.      US   \n",
              "27  How to buy Sovereign Gold Bonds: All you need ...      US   \n",
              "28  Thinking about buying stock in Mullen Automoti...      US   \n",
              "29  S.Africa's Gold Fields to become fourth bigges...      US   \n",
              "30  Osisko Gold Royalties (NYSE:OR) Rating Lowered...      US   \n",
              "31  Global Demand for Silver Could Hit a Record in...      US   \n",
              "32  Gold prices today, 4 June 2022: Yellow metal g...      US   \n",
              "33  ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...      US   \n",
              "34  Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...      US   \n",
              "35               Gold Fields : to Acquire Yamana Gold      US   \n",
              "36  Money Mindset: These Expert Tips Will Help You...      US   \n",
              "37  First Stepout Drill Results Promising for Gold...      US   \n",
              "38  Pure Gold Mining : Corporate Presentation – Ju...      US   \n",
              "39  Tennessee Governor Signs Full Repeal of Sales ...      US   \n",
              "40   Gold Fields (NYSE:GFI) Shares Gap Down to $12.20      US   \n",
              "41  RING: Gold Mining Companies Are Probably Fairl...      US   \n",
              "42  Area Development's 17th Annual Shovel Awards R...      US   \n",
              "43  Invesco Ltd. Purchases 263,880 Shares of Alamo...      US   \n",
              "44                       Exploring Mining Podcast 278      US   \n",
              "45  GSA Capital Partners LLP Buys New Position in ...      US   \n",
              "46  Gold Rates In India Are On The Verge Of Fallin...      US   \n",
              "47  Flowery Gold Mines : Ending 9-30-2021 FGMC Una...      US   \n",
              "48  Jaguar Mining: Inflationary Pressures Wreak Ha...      US   \n",
              "49           Sensex, Nifty Rally As Tech Stocks Surge      US   \n",
              "\n",
              "                                              summary classification  \\\n",
              "0   North Hills,United States - June 7, 2022 /Pres...       POSITIVE   \n",
              "1   By The Daily Upside - May 31, 2022 at 9:00PM Y...       POSITIVE   \n",
              "2   (ASA)   Report April 30, 2022 Shares Ticker AS...       NEGATIVE   \n",
              "3   Oat_Phawat/iStock via Getty Images Part I - In...       NEGATIVE   \n",
              "4   Gold Fields Limited GFI and Yamana Gold Inc. A...       POSITIVE   \n",
              "5   Four companies won the licences - Lotus Gold, ...       NEGATIVE   \n",
              "6   adventtr/E+ via Getty Images Gold and silver a...       NEGATIVE   \n",
              "7   GGCM has recently launched a Gold Guaranteed C...       POSITIVE   \n",
              "8   Cetera Investment Advisers lessened its stake ...       NEGATIVE   \n",
              "9   (KSN)   Report ASX: KSN Asia-Pacific Gold Prod...       POSITIVE   \n",
              "10  June 1, 2022 (Investorideas.com Newswire) With...       POSITIVE   \n",
              "11  Red Cloud's Mining Analyst to Interview Chairm...       POSITIVE   \n",
              "12  Fury Gold Mines (NASDAQ:FURY – Get Rating) was...       NEGATIVE   \n",
              "13  Return of Shiba, the revolutionary blockchain ...       POSITIVE   \n",
              "14  Public Sector Pension Investment Board decreas...       NEGATIVE   \n",
              "15  SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...       POSITIVE   \n",
              "16  (WRN)   Report TSX WRN NYSE AMERICAN WRN DEVEL...       NEGATIVE   \n",
              "17  Harmony Gold Mining (NYSE:HMY – Get Rating) wa...       NEGATIVE   \n",
              "18  HighTower Advisors LLC reduced its position in...       NEGATIVE   \n",
              "19  (VGCX)   Report Discover Companies to Invest I...       POSITIVE   \n",
              "20  Gold price today (June 5, 2022) decreased marg...       NEGATIVE   \n",
              "21  chonticha wat/iStock via Getty Images iShares ...       POSITIVE   \n",
              "22  (YRI)   Report Transaction creates a top-4 glo...       POSITIVE   \n",
              "23  (YRI)   Report Transaction creates a top-4 glo...       POSITIVE   \n",
              "24  Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...       NEGATIVE   \n",
              "25  The stock market had a nice bounce last week, ...       NEGATIVE   \n",
              "26  (GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...       POSITIVE   \n",
              "27  Gold bonds are considered one of the best opti...       POSITIVE   \n",
              "28  NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...       NEGATIVE   \n",
              "29  Shares in the South Africa-listed mining compa...       POSITIVE   \n",
              "30  Osisko Gold Royalties (NYSE:OR – Get Rating) w...       NEGATIVE   \n",
              "31  ​​FN Media Group Presents Microsmallcap.com Ma...       POSITIVE   \n",
              "32  Gold prices today (June 4) increased by Rs 50 ...       NEGATIVE   \n",
              "33  Vancouver, British Columbia - (May 31, 2022) -...       POSITIVE   \n",
              "34  Blair William & Co. IL cut its stake in shares...       NEGATIVE   \n",
              "35  (GFI)   Report Gold Fields Limited (Reg. No. 1...       POSITIVE   \n",
              "36  By Jasmine Browley · Updated June 4, 2022 CNBC...       NEGATIVE   \n",
              "37  June 3, 2022 (Investorideas.com Newswire) As O...       POSITIVE   \n",
              "38  (PGM)   Report The Heart of Red Lake. PureGold...       POSITIVE   \n",
              "39  With Governor Bill Lee's signature on Friday, ...       POSITIVE   \n",
              "40  Gold Fields Limited (NYSE:GFI – Get Rating) sh...       NEGATIVE   \n",
              "41  RING invests in gold mining companies. RING's ...       POSITIVE   \n",
              "42  Area Development, the leading publication cove...       POSITIVE   \n",
              "43  Invesco Ltd. boosted its position in shares of...       POSITIVE   \n",
              "44  Vancouver, Kelowna, Delta, BC - May 31, 2022 (...       POSITIVE   \n",
              "45  GSA Capital Partners LLP bought a new stake in...       POSITIVE   \n",
              "46  Indian gold markets are expected to be under p...       NEGATIVE   \n",
              "47  (FLOD) The Flowery Gold Mines Company of Nevad...       NEGATIVE   \n",
              "48  agnormark/iStock via Getty Images The Q1 Earni...       NEGATIVE   \n",
              "49  (RTTNews) - Indian shares followed global peer...       NEGATIVE   \n",
              "\n",
              "   classification_title language    topic  \\\n",
              "0              NEGATIVE       en  finance   \n",
              "1              POSITIVE       en  finance   \n",
              "2              NEGATIVE       en  finance   \n",
              "3              NEGATIVE       en  finance   \n",
              "4              NEGATIVE       en  finance   \n",
              "5              POSITIVE       en  finance   \n",
              "6              POSITIVE       en  finance   \n",
              "7              POSITIVE       en  finance   \n",
              "8              NEGATIVE       en  finance   \n",
              "9              POSITIVE       en  finance   \n",
              "10             POSITIVE       en  finance   \n",
              "11             POSITIVE       en  finance   \n",
              "12             NEGATIVE       en  finance   \n",
              "13             POSITIVE       en  finance   \n",
              "14             NEGATIVE       en  finance   \n",
              "15             POSITIVE       en  finance   \n",
              "16             POSITIVE       en  finance   \n",
              "17             NEGATIVE       en  finance   \n",
              "18             NEGATIVE       en  finance   \n",
              "19             POSITIVE       en  finance   \n",
              "20             NEGATIVE       en  finance   \n",
              "21             POSITIVE       en  finance   \n",
              "22             POSITIVE       en  finance   \n",
              "23             POSITIVE       en  finance   \n",
              "24             NEGATIVE       en  finance   \n",
              "25             POSITIVE       en  finance   \n",
              "26             POSITIVE       en  finance   \n",
              "27             NEGATIVE       en  finance   \n",
              "28             NEGATIVE       en  finance   \n",
              "29             POSITIVE       en  finance   \n",
              "30             NEGATIVE       en  finance   \n",
              "31             POSITIVE       en  finance   \n",
              "32             NEGATIVE       en  finance   \n",
              "33             POSITIVE       en  finance   \n",
              "34             NEGATIVE       en  finance   \n",
              "35             POSITIVE       en  finance   \n",
              "36             POSITIVE       en  finance   \n",
              "37             POSITIVE       en  finance   \n",
              "38             POSITIVE       en  finance   \n",
              "39             POSITIVE       en  finance   \n",
              "40             NEGATIVE       en  finance   \n",
              "41             POSITIVE       en  finance   \n",
              "42             POSITIVE       en  finance   \n",
              "43             NEGATIVE       en  finance   \n",
              "44             NEGATIVE       en  finance   \n",
              "45             NEGATIVE       en  finance   \n",
              "46             NEGATIVE       en  finance   \n",
              "47             NEGATIVE       en  finance   \n",
              "48             NEGATIVE       en  finance   \n",
              "49             POSITIVE       en  finance   \n",
              "\n",
              "                                                 link       published_date  \\\n",
              "0   https://markets.financialcontent.com/stocks/ar...  2022-06-07 08:07:00   \n",
              "1   https://www.fool.com/investing/2022/05/31/sout...  2022-06-01 01:00:13   \n",
              "2   https://www.marketscreener.com/quote/stock/ASA...  2022-06-01 19:32:06   \n",
              "3   https://seekingalpha.com/article/4515405-new-g...  2022-05-31 10:54:49   \n",
              "4   https://finance.yahoo.com/news/gold-fields-gfi...  2022-05-31 14:04:02   \n",
              "5   https://www.marketscreener.com/news/latest/Egy...  2022-06-01 09:41:08   \n",
              "6   https://seekingalpha.com/article/4515483-buyin...  2022-05-31 16:11:53   \n",
              "7   https://markets.financialcontent.com/stocks/ar...  2022-05-31 01:30:00   \n",
              "8   https://www.tickerreport.com/banking-finance/8...  2022-06-06 07:55:51   \n",
              "9   https://www.marketscreener.com/quote/stock/KIN...  2022-06-07 08:12:11   \n",
              "10  https://www.investorideas.com/news/2022/mining...  2022-06-01 15:05:00   \n",
              "11  https://www.marketscreener.com/quote/stock/U-S...  2022-06-01 12:48:04   \n",
              "12  https://www.tickerreport.com/banking-finance/8...  2022-06-02 01:54:42   \n",
              "13  https://markets.financialcontent.com/stocks/ar...  2022-06-06 12:54:02   \n",
              "14  https://www.tickerreport.com/banking-finance/8...  2022-06-03 07:56:44   \n",
              "15  https://markets.financialcontent.com/stocks/ar...  2022-05-31 11:30:00   \n",
              "16  https://www.marketscreener.com/quote/stock/WES...  2022-06-05 21:22:02   \n",
              "17  https://forextv.com/xauusd-gold-us-dollar/zack...  2022-06-06 16:31:54   \n",
              "18  https://www.tickerreport.com/banking-finance/8...  2022-06-07 05:22:41   \n",
              "19  https://www.marketscreener.com/quote/stock/VIC...  2022-06-02 13:05:01   \n",
              "20  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-06-05 02:31:04   \n",
              "21  https://seekingalpha.com/article/4516774-ring-...  2022-06-07 04:09:45   \n",
              "22  https://www.marketscreener.com/quote/stock/YAM...  2022-05-31 05:45:01   \n",
              "23  https://www.marketscreener.com/quote/stock/YAM...  2022-05-31 11:02:02   \n",
              "24  https://forextv.com/xauusd-gold-us-dollar/equi...  2022-05-31 02:31:05   \n",
              "25  https://www.fool.com/investing/2022/05/31/thes...  2022-05-31 12:29:01   \n",
              "26  https://www.marketscreener.com/quote/stock/GOL...  2022-05-31 13:31:46   \n",
              "27  https://forextv.com/xauusd-gold-us-dollar/how-...  2022-05-31 14:03:00   \n",
              "28  https://www.marketscreener.com/quote/stock/TAL...  2022-05-31 15:16:05   \n",
              "29  https://www.marketscreener.com/news/latest/S-A...  2022-05-31 15:16:30   \n",
              "30  https://www.thecerbatgem.com/2022/06/02/osisko...  2022-06-02 08:18:43   \n",
              "31  https://markets.financialcontent.com/stocks/ar...  2022-06-01 13:15:00   \n",
              "32  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-06-04 02:31:03   \n",
              "33  https://www.marketscreener.com/quote/stock/ROV...  2022-05-31 10:10:36   \n",
              "34  https://www.tickerreport.com/banking-finance/8...  2022-06-01 07:54:46   \n",
              "35  https://www.marketscreener.com/quote/stock/GOL...  2022-05-31 05:40:55   \n",
              "36  https://www.essence.com/news/money-career/expe...  2022-06-07 12:21:00   \n",
              "37  https://www.investorideas.com/news/2022/mining...  2022-06-03 13:15:00   \n",
              "38  https://www.marketscreener.com/quote/stock/PUR...  2022-06-01 21:52:24   \n",
              "39  https://markets.financialcontent.com/stocks/ar...  2022-05-31 05:00:00   \n",
              "40  https://www.thecerbatgem.com/2022/05/31/gold-f...  2022-05-31 10:58:46   \n",
              "41  https://forextv.com/xauusd-gold-us-dollar/ring...  2022-06-07 04:31:23   \n",
              "42  https://markets.financialcontent.com/stocks/ar...  2022-06-03 14:00:00   \n",
              "43  https://www.tickerreport.com/banking-finance/8...  2022-06-07 05:18:43   \n",
              "44  https://www.investorideas.com/news/2022/explor...  2022-05-31 14:30:00   \n",
              "45  https://www.tickerreport.com/banking-finance/8...  2022-06-07 05:36:41   \n",
              "46  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-05-31 12:32:14   \n",
              "47  https://www.marketscreener.com/quote/stock/FLO...  2022-06-02 19:22:10   \n",
              "48  https://seekingalpha.com/article/4516497-jagua...  2022-06-05 02:23:59   \n",
              "49  https://markets.businessinsider.com/news/stock...  2022-06-03 06:14:07   \n",
              "\n",
              "    review  \n",
              "0     True  \n",
              "1    False  \n",
              "2    False  \n",
              "3    False  \n",
              "4     True  \n",
              "5     True  \n",
              "6     True  \n",
              "7    False  \n",
              "8    False  \n",
              "9    False  \n",
              "10   False  \n",
              "11   False  \n",
              "12   False  \n",
              "13   False  \n",
              "14   False  \n",
              "15   False  \n",
              "16    True  \n",
              "17   False  \n",
              "18   False  \n",
              "19   False  \n",
              "20   False  \n",
              "21   False  \n",
              "22   False  \n",
              "23   False  \n",
              "24   False  \n",
              "25    True  \n",
              "26   False  \n",
              "27    True  \n",
              "28   False  \n",
              "29   False  \n",
              "30   False  \n",
              "31   False  \n",
              "32   False  \n",
              "33   False  \n",
              "34   False  \n",
              "35   False  \n",
              "36    True  \n",
              "37   False  \n",
              "38   False  \n",
              "39   False  \n",
              "40   False  \n",
              "41   False  \n",
              "42   False  \n",
              "43    True  \n",
              "44    True  \n",
              "45    True  \n",
              "46   False  \n",
              "47   False  \n",
              "48   False  \n",
              "49    True  "
            ]
          },
          "execution_count": 66,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# if the classification of title and summary don't have the same result - mark for manual review \n",
        "\n",
        "import numpy as np\n",
        "\n",
        "df3[\"review\"] = np.where((df3['classification'] != df3['classification_title']), True, False)\n",
        "\n",
        "df3"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "-POP5FB5uZ3L"
      },
      "outputs": [],
      "source": [
        "# in case there is no time for manual review uncomment:\n",
        "#df3.drop(df3[df3.review == True].index, inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 68,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "LQ_B9oxmxzYY",
        "outputId": "f9afd190-5d3d-4e42-fdf3-f2167608faf8"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-adf161fe-fa94-4759-8aff-6b53af31b4c3\">\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>title</th>\n",
              "      <th>country</th>\n",
              "      <th>summary</th>\n",
              "      <th>classification</th>\n",
              "      <th>classification_title</th>\n",
              "      <th>language</th>\n",
              "      <th>topic</th>\n",
              "      <th>link</th>\n",
              "      <th>published_date</th>\n",
              "      <th>review</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>South Africa's Gold Fields Buying Canada's Yam...</td>\n",
              "      <td>US</td>\n",
              "      <td>By The Daily Upside - May 31, 2022 at 9:00PM Y...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.fool.com/investing/2022/05/31/sout...</td>\n",
              "      <td>2022-06-01 01:00:13</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ASA Gold and Precious Metals : Monthly Factshe...</td>\n",
              "      <td>US</td>\n",
              "      <td>(ASA)   Report April 30, 2022 Shares Ticker AS...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ASA...</td>\n",
              "      <td>2022-06-01 19:32:06</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>New Gold: Lower Grade And Tonnes Processed At ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Oat_Phawat/iStock via Getty Images Part I - In...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4515405-new-g...</td>\n",
              "      <td>2022-05-31 10:54:49</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>GGCM develops a crypto platform for the cause ...</td>\n",
              "      <td>US</td>\n",
              "      <td>GGCM has recently launched a Gold Guaranteed C...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 01:30:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Cetera Investment Advisers Sells 8,195 Shares ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Cetera Investment Advisers lessened its stake ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-06 07:55:51</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Kingston Resources : Investor Presentation – R...</td>\n",
              "      <td>US</td>\n",
              "      <td>(KSN)   Report ASX: KSN Asia-Pacific Gold Prod...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/KIN...</td>\n",
              "      <td>2022-06-07 08:12:11</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Yukon Explorer Looking to Start New Gold Rush</td>\n",
              "      <td>US</td>\n",
              "      <td>June 1, 2022 (Investorideas.com Newswire) With...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>2022-06-01 15:05:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>U.S. Gold Corp. Announces Live Webinar Hosted ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Red Cloud's Mining Analyst to Interview Chairm...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/U-S...</td>\n",
              "      <td>2022-06-01 12:48:04</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...</td>\n",
              "      <td>US</td>\n",
              "      <td>Fury Gold Mines (NASDAQ:FURY – Get Rating) was...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-02 01:54:42</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>ShibDOSH – The World's First Gold Paying Rebas...</td>\n",
              "      <td>US</td>\n",
              "      <td>Return of Shiba, the revolutionary blockchain ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-06 12:54:02</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Public Sector Pension Investment Board Sells 2...</td>\n",
              "      <td>US</td>\n",
              "      <td>Public Sector Pension Investment Board decreas...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-03 07:56:44</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...</td>\n",
              "      <td>US</td>\n",
              "      <td>SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 11:30:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Zacks Investment Research Downgrades Harmony G...</td>\n",
              "      <td>US</td>\n",
              "      <td>Harmony Gold Mining (NYSE:HMY – Get Rating) wa...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/zack...</td>\n",
              "      <td>2022-06-06 16:31:54</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>HighTower Advisors LLC Sells 54,389 Shares of ...</td>\n",
              "      <td>US</td>\n",
              "      <td>HighTower Advisors LLC reduced its position in...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-07 05:22:41</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>BTV Showcases Victoria Gold, Advance United, T...</td>\n",
              "      <td>US</td>\n",
              "      <td>(VGCX)   Report Discover Companies to Invest I...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/VIC...</td>\n",
              "      <td>2022-06-02 13:05:01</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Gold price today, June 5: Gold rates drop afte...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold price today (June 5, 2022) decreased marg...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-06-05 02:31:04</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>RING (RING): Gold Mining Companies Are Probabl...</td>\n",
              "      <td>US</td>\n",
              "      <td>chonticha wat/iStock via Getty Images iShares ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4516774-ring-...</td>\n",
              "      <td>2022-06-07 04:09:45</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Gold Fields to Acquire Yamana Gold – a Combina...</td>\n",
              "      <td>US</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>2022-05-31 05:45:01</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>REPEAT -- Gold Fields to Acquire Yamana Gold –...</td>\n",
              "      <td>US</td>\n",
              "      <td>(YRI)   Report Transaction creates a top-4 glo...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/YAM...</td>\n",
              "      <td>2022-05-31 11:02:02</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...</td>\n",
              "      <td>US</td>\n",
              "      <td>Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/equi...</td>\n",
              "      <td>2022-05-31 02:31:05</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.</td>\n",
              "      <td>US</td>\n",
              "      <td>(GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>2022-05-31 13:31:46</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Thinking about buying stock in Mullen Automoti...</td>\n",
              "      <td>US</td>\n",
              "      <td>NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/TAL...</td>\n",
              "      <td>2022-05-31 15:16:05</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>S.Africa's Gold Fields to become fourth bigges...</td>\n",
              "      <td>US</td>\n",
              "      <td>Shares in the South Africa-listed mining compa...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/news/latest/S-A...</td>\n",
              "      <td>2022-05-31 15:16:30</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR) Rating Lowered...</td>\n",
              "      <td>US</td>\n",
              "      <td>Osisko Gold Royalties (NYSE:OR – Get Rating) w...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/06/02/osisko...</td>\n",
              "      <td>2022-06-02 08:18:43</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Global Demand for Silver Could Hit a Record in...</td>\n",
              "      <td>US</td>\n",
              "      <td>​​FN Media Group Presents Microsmallcap.com Ma...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-01 13:15:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Gold prices today, 4 June 2022: Yellow metal g...</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold prices today (June 4) increased by Rs 50 ...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-06-04 02:31:03</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...</td>\n",
              "      <td>US</td>\n",
              "      <td>Vancouver, British Columbia - (May 31, 2022) -...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/ROV...</td>\n",
              "      <td>2022-05-31 10:10:36</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...</td>\n",
              "      <td>US</td>\n",
              "      <td>Blair William &amp; Co. IL cut its stake in shares...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.tickerreport.com/banking-finance/8...</td>\n",
              "      <td>2022-06-01 07:54:46</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Gold Fields : to Acquire Yamana Gold</td>\n",
              "      <td>US</td>\n",
              "      <td>(GFI)   Report Gold Fields Limited (Reg. No. 1...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/GOL...</td>\n",
              "      <td>2022-05-31 05:40:55</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>First Stepout Drill Results Promising for Gold...</td>\n",
              "      <td>US</td>\n",
              "      <td>June 3, 2022 (Investorideas.com Newswire) As O...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.investorideas.com/news/2022/mining...</td>\n",
              "      <td>2022-06-03 13:15:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Pure Gold Mining : Corporate Presentation – Ju...</td>\n",
              "      <td>US</td>\n",
              "      <td>(PGM)   Report The Heart of Red Lake. PureGold...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/PUR...</td>\n",
              "      <td>2022-06-01 21:52:24</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>Tennessee Governor Signs Full Repeal of Sales ...</td>\n",
              "      <td>US</td>\n",
              "      <td>With Governor Bill Lee's signature on Friday, ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-05-31 05:00:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>Gold Fields (NYSE:GFI) Shares Gap Down to $12.20</td>\n",
              "      <td>US</td>\n",
              "      <td>Gold Fields Limited (NYSE:GFI – Get Rating) sh...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.thecerbatgem.com/2022/05/31/gold-f...</td>\n",
              "      <td>2022-05-31 10:58:46</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>RING: Gold Mining Companies Are Probably Fairl...</td>\n",
              "      <td>US</td>\n",
              "      <td>RING invests in gold mining companies. RING's ...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/ring...</td>\n",
              "      <td>2022-06-07 04:31:23</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>Area Development's 17th Annual Shovel Awards R...</td>\n",
              "      <td>US</td>\n",
              "      <td>Area Development, the leading publication cove...</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>POSITIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://markets.financialcontent.com/stocks/ar...</td>\n",
              "      <td>2022-06-03 14:00:00</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Gold Rates In India Are On The Verge Of Fallin...</td>\n",
              "      <td>US</td>\n",
              "      <td>Indian gold markets are expected to be under p...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://forextv.com/xauusd-gold-us-dollar/gold...</td>\n",
              "      <td>2022-05-31 12:32:14</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Flowery Gold Mines : Ending 9-30-2021 FGMC Una...</td>\n",
              "      <td>US</td>\n",
              "      <td>(FLOD) The Flowery Gold Mines Company of Nevad...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://www.marketscreener.com/quote/stock/FLO...</td>\n",
              "      <td>2022-06-02 19:22:10</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Jaguar Mining: Inflationary Pressures Wreak Ha...</td>\n",
              "      <td>US</td>\n",
              "      <td>agnormark/iStock via Getty Images The Q1 Earni...</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>NEGATIVE</td>\n",
              "      <td>en</td>\n",
              "      <td>finance</td>\n",
              "      <td>https://seekingalpha.com/article/4516497-jagua...</td>\n",
              "      <td>2022-06-05 02:23:59</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-adf161fe-fa94-4759-8aff-6b53af31b4c3')\"\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-adf161fe-fa94-4759-8aff-6b53af31b4c3 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-adf161fe-fa94-4759-8aff-6b53af31b4c3');\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",
              "  "
            ],
            "text/plain": [
              "                                                title country  \\\n",
              "1   South Africa's Gold Fields Buying Canada's Yam...      US   \n",
              "2   ASA Gold and Precious Metals : Monthly Factshe...      US   \n",
              "3   New Gold: Lower Grade And Tonnes Processed At ...      US   \n",
              "7   GGCM develops a crypto platform for the cause ...      US   \n",
              "8   Cetera Investment Advisers Sells 8,195 Shares ...      US   \n",
              "9   Kingston Resources : Investor Presentation – R...      US   \n",
              "10      Yukon Explorer Looking to Start New Gold Rush      US   \n",
              "11  U.S. Gold Corp. Announces Live Webinar Hosted ...      US   \n",
              "12  Fury Gold Mines (NASDAQ:FURY) Stock Rating Upg...      US   \n",
              "13  ShibDOSH – The World's First Gold Paying Rebas...      US   \n",
              "14  Public Sector Pension Investment Board Sells 2...      US   \n",
              "15  Guskin Gold Corp. (OTCQB:GKIN) Engages Integri...      US   \n",
              "17  Zacks Investment Research Downgrades Harmony G...      US   \n",
              "18  HighTower Advisors LLC Sells 54,389 Shares of ...      US   \n",
              "19  BTV Showcases Victoria Gold, Advance United, T...      US   \n",
              "20  Gold price today, June 5: Gold rates drop afte...      US   \n",
              "21  RING (RING): Gold Mining Companies Are Probabl...      US   \n",
              "22  Gold Fields to Acquire Yamana Gold – a Combina...      US   \n",
              "23  REPEAT -- Gold Fields to Acquire Yamana Gold –...      US   \n",
              "24  Equinox Gold (NYSEAMERICAN:EQX) Downgraded to ...      US   \n",
              "26          GOLD FIELDS : TO ACQUIRE YAMANA GOLD INC.      US   \n",
              "28  Thinking about buying stock in Mullen Automoti...      US   \n",
              "29  S.Africa's Gold Fields to become fourth bigges...      US   \n",
              "30  Osisko Gold Royalties (NYSE:OR) Rating Lowered...      US   \n",
              "31  Global Demand for Silver Could Hit a Record in...      US   \n",
              "32  Gold prices today, 4 June 2022: Yellow metal g...      US   \n",
              "33  ROVER METALS : PROVIDES AN INFRASTRUCTURE UPDA...      US   \n",
              "34  Sprott Physical Gold Trust (NYSEARCA:PHYS) Sha...      US   \n",
              "35               Gold Fields : to Acquire Yamana Gold      US   \n",
              "37  First Stepout Drill Results Promising for Gold...      US   \n",
              "38  Pure Gold Mining : Corporate Presentation – Ju...      US   \n",
              "39  Tennessee Governor Signs Full Repeal of Sales ...      US   \n",
              "40   Gold Fields (NYSE:GFI) Shares Gap Down to $12.20      US   \n",
              "41  RING: Gold Mining Companies Are Probably Fairl...      US   \n",
              "42  Area Development's 17th Annual Shovel Awards R...      US   \n",
              "46  Gold Rates In India Are On The Verge Of Fallin...      US   \n",
              "47  Flowery Gold Mines : Ending 9-30-2021 FGMC Una...      US   \n",
              "48  Jaguar Mining: Inflationary Pressures Wreak Ha...      US   \n",
              "\n",
              "                                              summary classification  \\\n",
              "1   By The Daily Upside - May 31, 2022 at 9:00PM Y...       POSITIVE   \n",
              "2   (ASA)   Report April 30, 2022 Shares Ticker AS...       NEGATIVE   \n",
              "3   Oat_Phawat/iStock via Getty Images Part I - In...       NEGATIVE   \n",
              "7   GGCM has recently launched a Gold Guaranteed C...       POSITIVE   \n",
              "8   Cetera Investment Advisers lessened its stake ...       NEGATIVE   \n",
              "9   (KSN)   Report ASX: KSN Asia-Pacific Gold Prod...       POSITIVE   \n",
              "10  June 1, 2022 (Investorideas.com Newswire) With...       POSITIVE   \n",
              "11  Red Cloud's Mining Analyst to Interview Chairm...       POSITIVE   \n",
              "12  Fury Gold Mines (NASDAQ:FURY – Get Rating) was...       NEGATIVE   \n",
              "13  Return of Shiba, the revolutionary blockchain ...       POSITIVE   \n",
              "14  Public Sector Pension Investment Board decreas...       NEGATIVE   \n",
              "15  SAN JOSE, CA / ACCESSWIRE / May 31, 2022 / Gus...       POSITIVE   \n",
              "17  Harmony Gold Mining (NYSE:HMY – Get Rating) wa...       NEGATIVE   \n",
              "18  HighTower Advisors LLC reduced its position in...       NEGATIVE   \n",
              "19  (VGCX)   Report Discover Companies to Invest I...       POSITIVE   \n",
              "20  Gold price today (June 5, 2022) decreased marg...       NEGATIVE   \n",
              "21  chonticha wat/iStock via Getty Images iShares ...       POSITIVE   \n",
              "22  (YRI)   Report Transaction creates a top-4 glo...       POSITIVE   \n",
              "23  (YRI)   Report Transaction creates a top-4 glo...       POSITIVE   \n",
              "24  Equinox Gold (NYSEAMERICAN:EQX – Get Rating) w...       NEGATIVE   \n",
              "26  (GFI)   Report GOLD FIELDS TO ACQUIRE YAMANA G...       POSITIVE   \n",
              "28  NEW YORK, May 31, 2022 /PRNewswire/ -- Investo...       NEGATIVE   \n",
              "29  Shares in the South Africa-listed mining compa...       POSITIVE   \n",
              "30  Osisko Gold Royalties (NYSE:OR – Get Rating) w...       NEGATIVE   \n",
              "31  ​​FN Media Group Presents Microsmallcap.com Ma...       POSITIVE   \n",
              "32  Gold prices today (June 4) increased by Rs 50 ...       NEGATIVE   \n",
              "33  Vancouver, British Columbia - (May 31, 2022) -...       POSITIVE   \n",
              "34  Blair William & Co. IL cut its stake in shares...       NEGATIVE   \n",
              "35  (GFI)   Report Gold Fields Limited (Reg. No. 1...       POSITIVE   \n",
              "37  June 3, 2022 (Investorideas.com Newswire) As O...       POSITIVE   \n",
              "38  (PGM)   Report The Heart of Red Lake. PureGold...       POSITIVE   \n",
              "39  With Governor Bill Lee's signature on Friday, ...       POSITIVE   \n",
              "40  Gold Fields Limited (NYSE:GFI – Get Rating) sh...       NEGATIVE   \n",
              "41  RING invests in gold mining companies. RING's ...       POSITIVE   \n",
              "42  Area Development, the leading publication cove...       POSITIVE   \n",
              "46  Indian gold markets are expected to be under p...       NEGATIVE   \n",
              "47  (FLOD) The Flowery Gold Mines Company of Nevad...       NEGATIVE   \n",
              "48  agnormark/iStock via Getty Images The Q1 Earni...       NEGATIVE   \n",
              "\n",
              "   classification_title language    topic  \\\n",
              "1              POSITIVE       en  finance   \n",
              "2              NEGATIVE       en  finance   \n",
              "3              NEGATIVE       en  finance   \n",
              "7              POSITIVE       en  finance   \n",
              "8              NEGATIVE       en  finance   \n",
              "9              POSITIVE       en  finance   \n",
              "10             POSITIVE       en  finance   \n",
              "11             POSITIVE       en  finance   \n",
              "12             NEGATIVE       en  finance   \n",
              "13             POSITIVE       en  finance   \n",
              "14             NEGATIVE       en  finance   \n",
              "15             POSITIVE       en  finance   \n",
              "17             NEGATIVE       en  finance   \n",
              "18             NEGATIVE       en  finance   \n",
              "19             POSITIVE       en  finance   \n",
              "20             NEGATIVE       en  finance   \n",
              "21             POSITIVE       en  finance   \n",
              "22             POSITIVE       en  finance   \n",
              "23             POSITIVE       en  finance   \n",
              "24             NEGATIVE       en  finance   \n",
              "26             POSITIVE       en  finance   \n",
              "28             NEGATIVE       en  finance   \n",
              "29             POSITIVE       en  finance   \n",
              "30             NEGATIVE       en  finance   \n",
              "31             POSITIVE       en  finance   \n",
              "32             NEGATIVE       en  finance   \n",
              "33             POSITIVE       en  finance   \n",
              "34             NEGATIVE       en  finance   \n",
              "35             POSITIVE       en  finance   \n",
              "37             POSITIVE       en  finance   \n",
              "38             POSITIVE       en  finance   \n",
              "39             POSITIVE       en  finance   \n",
              "40             NEGATIVE       en  finance   \n",
              "41             POSITIVE       en  finance   \n",
              "42             POSITIVE       en  finance   \n",
              "46             NEGATIVE       en  finance   \n",
              "47             NEGATIVE       en  finance   \n",
              "48             NEGATIVE       en  finance   \n",
              "\n",
              "                                                 link       published_date  \\\n",
              "1   https://www.fool.com/investing/2022/05/31/sout...  2022-06-01 01:00:13   \n",
              "2   https://www.marketscreener.com/quote/stock/ASA...  2022-06-01 19:32:06   \n",
              "3   https://seekingalpha.com/article/4515405-new-g...  2022-05-31 10:54:49   \n",
              "7   https://markets.financialcontent.com/stocks/ar...  2022-05-31 01:30:00   \n",
              "8   https://www.tickerreport.com/banking-finance/8...  2022-06-06 07:55:51   \n",
              "9   https://www.marketscreener.com/quote/stock/KIN...  2022-06-07 08:12:11   \n",
              "10  https://www.investorideas.com/news/2022/mining...  2022-06-01 15:05:00   \n",
              "11  https://www.marketscreener.com/quote/stock/U-S...  2022-06-01 12:48:04   \n",
              "12  https://www.tickerreport.com/banking-finance/8...  2022-06-02 01:54:42   \n",
              "13  https://markets.financialcontent.com/stocks/ar...  2022-06-06 12:54:02   \n",
              "14  https://www.tickerreport.com/banking-finance/8...  2022-06-03 07:56:44   \n",
              "15  https://markets.financialcontent.com/stocks/ar...  2022-05-31 11:30:00   \n",
              "17  https://forextv.com/xauusd-gold-us-dollar/zack...  2022-06-06 16:31:54   \n",
              "18  https://www.tickerreport.com/banking-finance/8...  2022-06-07 05:22:41   \n",
              "19  https://www.marketscreener.com/quote/stock/VIC...  2022-06-02 13:05:01   \n",
              "20  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-06-05 02:31:04   \n",
              "21  https://seekingalpha.com/article/4516774-ring-...  2022-06-07 04:09:45   \n",
              "22  https://www.marketscreener.com/quote/stock/YAM...  2022-05-31 05:45:01   \n",
              "23  https://www.marketscreener.com/quote/stock/YAM...  2022-05-31 11:02:02   \n",
              "24  https://forextv.com/xauusd-gold-us-dollar/equi...  2022-05-31 02:31:05   \n",
              "26  https://www.marketscreener.com/quote/stock/GOL...  2022-05-31 13:31:46   \n",
              "28  https://www.marketscreener.com/quote/stock/TAL...  2022-05-31 15:16:05   \n",
              "29  https://www.marketscreener.com/news/latest/S-A...  2022-05-31 15:16:30   \n",
              "30  https://www.thecerbatgem.com/2022/06/02/osisko...  2022-06-02 08:18:43   \n",
              "31  https://markets.financialcontent.com/stocks/ar...  2022-06-01 13:15:00   \n",
              "32  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-06-04 02:31:03   \n",
              "33  https://www.marketscreener.com/quote/stock/ROV...  2022-05-31 10:10:36   \n",
              "34  https://www.tickerreport.com/banking-finance/8...  2022-06-01 07:54:46   \n",
              "35  https://www.marketscreener.com/quote/stock/GOL...  2022-05-31 05:40:55   \n",
              "37  https://www.investorideas.com/news/2022/mining...  2022-06-03 13:15:00   \n",
              "38  https://www.marketscreener.com/quote/stock/PUR...  2022-06-01 21:52:24   \n",
              "39  https://markets.financialcontent.com/stocks/ar...  2022-05-31 05:00:00   \n",
              "40  https://www.thecerbatgem.com/2022/05/31/gold-f...  2022-05-31 10:58:46   \n",
              "41  https://forextv.com/xauusd-gold-us-dollar/ring...  2022-06-07 04:31:23   \n",
              "42  https://markets.financialcontent.com/stocks/ar...  2022-06-03 14:00:00   \n",
              "46  https://forextv.com/xauusd-gold-us-dollar/gold...  2022-05-31 12:32:14   \n",
              "47  https://www.marketscreener.com/quote/stock/FLO...  2022-06-02 19:22:10   \n",
              "48  https://seekingalpha.com/article/4516497-jagua...  2022-06-05 02:23:59   \n",
              "\n",
              "    review  \n",
              "1    False  \n",
              "2    False  \n",
              "3    False  \n",
              "7    False  \n",
              "8    False  \n",
              "9    False  \n",
              "10   False  \n",
              "11   False  \n",
              "12   False  \n",
              "13   False  \n",
              "14   False  \n",
              "15   False  \n",
              "17   False  \n",
              "18   False  \n",
              "19   False  \n",
              "20   False  \n",
              "21   False  \n",
              "22   False  \n",
              "23   False  \n",
              "24   False  \n",
              "26   False  \n",
              "28   False  \n",
              "29   False  \n",
              "30   False  \n",
              "31   False  \n",
              "32   False  \n",
              "33   False  \n",
              "34   False  \n",
              "35   False  \n",
              "37   False  \n",
              "38   False  \n",
              "39   False  \n",
              "40   False  \n",
              "41   False  \n",
              "42   False  \n",
              "46   False  \n",
              "47   False  \n",
              "48   False  "
            ]
          },
          "execution_count": 68,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df3"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 70,
      "metadata": {
        "id": "Fuwtu087IGIU"
      },
      "outputs": [],
      "source": [
        "# give your csv a name here\n",
        "# save dataframe to csv\n",
        "df3.to_csv(f\"/content/drive/MyDrive/2022.05.24_Final-Project_Shared-Folder/classified/classified-more-{lang}.csv\")"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "collapsed_sections": [],
      "name": "input_csv_basic_pipe.ipynb",
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}