MSc_Lexicon_Based_Approach.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[]},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","source":["!pip install vaderSentiment"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"qtSVda5pBNnC","outputId":"be2f8b83-cf2d-4888-90c9-658639d2b669","executionInfo":{"status":"ok","timestamp":1667904175612,"user_tz":0,"elapsed":12902,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":1,"outputs":[{"output_type":"stream","name":"stdout","text":["Looking in indexes: https://pypi.org/simple, https://us-python.pkg.dev/colab-wheels/public/simple/\n","Collecting vaderSentiment\n","  Downloading vaderSentiment-3.3.2-py2.py3-none-any.whl (125 kB)\n","\u001b[K     |████████████████████████████████| 125 kB 7.8 MB/s \n","\u001b[?25hRequirement already satisfied: requests in /usr/local/lib/python3.7/dist-packages (from vaderSentiment) (2.23.0)\n","Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests->vaderSentiment) (1.24.3)\n","Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests->vaderSentiment) (3.0.4)\n","Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests->vaderSentiment) (2.10)\n","Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests->vaderSentiment) (2022.9.24)\n","Installing collected packages: vaderSentiment\n","Successfully installed vaderSentiment-3.3.2\n"]}]},{"cell_type":"code","source":["# Code to read csv file into Colaboratory:\n","!pip install -U -q PyDrive\n","from pydrive.auth import GoogleAuth\n","from pydrive.drive import GoogleDrive\n","from google.colab import auth\n","from oauth2client.client import GoogleCredentials\n","# Authenticate and create the PyDrive client.\n","auth.authenticate_user()\n","gauth = GoogleAuth()\n","gauth.credentials = GoogleCredentials.get_application_default()\n","drive = GoogleDrive(gauth)"],"metadata":{"id":"sy2RvANg8ZVC","executionInfo":{"status":"ok","timestamp":1667904199521,"user_tz":0,"elapsed":21268,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":2,"outputs":[]},{"cell_type":"code","source":["import pandas as pd\n","import matplotlib.pyplot as plt\n","from textblob import TextBlob\n","from vaderSentiment.vaderSentiment import SentimentIntensityAnalyzer"],"metadata":{"id":"cBK-SSRT8u2t","executionInfo":{"status":"ok","timestamp":1667904203709,"user_tz":0,"elapsed":1264,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":3,"outputs":[]},{"cell_type":"code","source":["# link = 'https://drive.google.com/file/d/1zB7FDPKT-K_HyK5gwv6042-W16udBvgo/view?usp=share_link\n","id = '1zB7FDPKT-K_HyK5gwv6042-W16udBvgo'"],"metadata":{"id":"8uAbm5yQ85sh","executionInfo":{"status":"ok","timestamp":1667904206011,"user_tz":0,"elapsed":292,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":4,"outputs":[]},{"cell_type":"code","source":["downloaded = drive.CreateFile({'id':id}) \n","downloaded.GetContentFile('UkTweets_new.csv',)"],"metadata":{"id":"eVNcd_3c6lLg","executionInfo":{"status":"ok","timestamp":1667904222555,"user_tz":0,"elapsed":14135,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":5,"outputs":[]},{"cell_type":"code","source":["df = pd.read_csv('UkTweets_new.csv',index_col=[0])\n","df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":887},"id":"-THRMmsM-NqN","outputId":"d53bacf5-f7f2-4ace-b001-0e1978bb1ccd","executionInfo":{"status":"ok","timestamp":1667904231669,"user_tz":0,"elapsed":3943,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":6,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                  author_id         username      author_location  \\\n","0        712000889427521537  community001500     Bristol, England   \n","1       1242068059088728065        dmm251144  South East, England   \n","2                 558636361          lochend   Cambridge, England   \n","3                  25550559     linda_whyman       United Kingdom   \n","4       1136757030822305792   Blueerryforest      London, England   \n","...                     ...              ...                  ...   \n","541723           3155243418        partyka_m  south east England    \n","541724  1418314766729289729       dree_kelly          Scotland uk   \n","541725            545512624       withthing2  South West, England   \n","541726            206900588  justalittlechat      London, England   \n","541727           2942221013     frogcrutches         South Wales.   \n","\n","                                                     text  \\\n","0       RT @StrikeMapUK: The Cost of Living Crisis is ...   \n","1       RT @0Calamity: This is not a #CostOfLivingCris...   \n","2       RT @geoffh33: Every non-Tory MP should have st...   \n","3       RT @hewitson10: Ian Blackford owned the show a...   \n","4       RT @snowy2007: Serious question for Scottish P...   \n","...                                                   ...   \n","541723  RT @SB_Sarah10: Do you honestly think #LizTrus...   \n","541724  RT @michaelbartrum: Every hour, 10 people die ...   \n","541725  Jesus! £170 billion excess profits over 2 yrs!...   \n","541726  RT @maxwellwoodger: Attended the Final @Conser...   \n","541727  #BorisJohnson plans to visit sites of his grea...   \n","\n","                       created_at tweet_location  retweets  replies   likes  \\\n","0       2022-03-30 23:56:24+00:00            NaN      48.0      0.0     0.0   \n","1       2022-03-30 23:56:01+00:00            NaN      44.0      0.0     0.0   \n","2       2022-03-30 23:50:10+00:00            NaN       4.0      0.0     0.0   \n","3       2022-03-30 23:48:39+00:00            NaN      58.0      0.0     0.0   \n","4       2022-03-30 23:46:14+00:00            NaN      34.0      0.0     0.0   \n","...                           ...            ...       ...      ...     ...   \n","541723  2022-09-01 00:38:56+00:00            NaN      55.0      0.0     0.0   \n","541724  2022-09-01 00:29:40+00:00            NaN       1.0      0.0     0.0   \n","541725  2022-09-01 00:28:15+00:00            NaN       0.0      0.0     0.0   \n","541726  2022-09-01 00:21:52+00:00            NaN       1.0      0.0     0.0   \n","541727  2022-09-01 00:02:29+00:00            NaN     502.0     20.0  1230.0   \n","\n","        quote_count                                     Cleaned_tweets  \n","0               0.0  cost living crisis political choice yet tory t...  \n","1               0.0  costoflivingcrisis stateimposedpoverty do quit...  \n","2               0.0  every non tory mp stand today call borisjohnso...  \n","3               0.0  ian blackford own show always tory care costof...  \n","4               0.0  serious question scottish power say energy gre...  \n","...             ...                                                ...  \n","541723          0.0    honestly think liztruss plan cost living crisis  \n","541724          0.0  every hour people die poverty uk rise costofli...  \n","541725          0.0  jesus billion excess profit yrs time take stre...  \n","541726          0.0  attend final leadership debate uk husting fell...  \n","541727         18.0     borisjohnson plan visit site great achievement  \n","\n","[541512 rows x 11 columns]"],"text/html":["\n","  <div id=\"df-8ec23dd8-6cd7-4f11-80b9-b20110b2c92a\">\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>author_id</th>\n","      <th>username</th>\n","      <th>author_location</th>\n","      <th>text</th>\n","      <th>created_at</th>\n","      <th>tweet_location</th>\n","      <th>retweets</th>\n","      <th>replies</th>\n","      <th>likes</th>\n","      <th>quote_count</th>\n","      <th>Cleaned_tweets</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>712000889427521537</td>\n","      <td>community001500</td>\n","      <td>Bristol, England</td>\n","      <td>RT @StrikeMapUK: The Cost of Living Crisis is ...</td>\n","      <td>2022-03-30 23:56:24+00:00</td>\n","      <td>NaN</td>\n","      <td>48.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>cost living crisis political choice yet tory t...</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1242068059088728065</td>\n","      <td>dmm251144</td>\n","      <td>South East, England</td>\n","      <td>RT @0Calamity: This is not a #CostOfLivingCris...</td>\n","      <td>2022-03-30 23:56:01+00:00</td>\n","      <td>NaN</td>\n","      <td>44.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>costoflivingcrisis stateimposedpoverty do quit...</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>558636361</td>\n","      <td>lochend</td>\n","      <td>Cambridge, England</td>\n","      <td>RT @geoffh33: Every non-Tory MP should have st...</td>\n","      <td>2022-03-30 23:50:10+00:00</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every non tory mp stand today call borisjohnso...</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>25550559</td>\n","      <td>linda_whyman</td>\n","      <td>United Kingdom</td>\n","      <td>RT @hewitson10: Ian Blackford owned the show a...</td>\n","      <td>2022-03-30 23:48:39+00:00</td>\n","      <td>NaN</td>\n","      <td>58.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>ian blackford own show always tory care costof...</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1136757030822305792</td>\n","      <td>Blueerryforest</td>\n","      <td>London, England</td>\n","      <td>RT @snowy2007: Serious question for Scottish P...</td>\n","      <td>2022-03-30 23:46:14+00:00</td>\n","      <td>NaN</td>\n","      <td>34.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>serious question scottish power say energy gre...</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>541723</th>\n","      <td>3155243418</td>\n","      <td>partyka_m</td>\n","      <td>south east England</td>\n","      <td>RT @SB_Sarah10: Do you honestly think #LizTrus...</td>\n","      <td>2022-09-01 00:38:56+00:00</td>\n","      <td>NaN</td>\n","      <td>55.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>honestly think liztruss plan cost living crisis</td>\n","    </tr>\n","    <tr>\n","      <th>541724</th>\n","      <td>1418314766729289729</td>\n","      <td>dree_kelly</td>\n","      <td>Scotland uk</td>\n","      <td>RT @michaelbartrum: Every hour, 10 people die ...</td>\n","      <td>2022-09-01 00:29:40+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every hour people die poverty uk rise costofli...</td>\n","    </tr>\n","    <tr>\n","      <th>541725</th>\n","      <td>545512624</td>\n","      <td>withthing2</td>\n","      <td>South West, England</td>\n","      <td>Jesus! £170 billion excess profits over 2 yrs!...</td>\n","      <td>2022-09-01 00:28:15+00:00</td>\n","      <td>NaN</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>jesus billion excess profit yrs time take stre...</td>\n","    </tr>\n","    <tr>\n","      <th>541726</th>\n","      <td>206900588</td>\n","      <td>justalittlechat</td>\n","      <td>London, England</td>\n","      <td>RT @maxwellwoodger: Attended the Final @Conser...</td>\n","      <td>2022-09-01 00:21:52+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>attend final leadership debate uk husting fell...</td>\n","    </tr>\n","    <tr>\n","      <th>541727</th>\n","      <td>2942221013</td>\n","      <td>frogcrutches</td>\n","      <td>South Wales.</td>\n","      <td>#BorisJohnson plans to visit sites of his grea...</td>\n","      <td>2022-09-01 00:02:29+00:00</td>\n","      <td>NaN</td>\n","      <td>502.0</td>\n","      <td>20.0</td>\n","      <td>1230.0</td>\n","      <td>18.0</td>\n","      <td>borisjohnson plan visit site great achievement</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>541512 rows × 11 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8ec23dd8-6cd7-4f11-80b9-b20110b2c92a')\"\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-8ec23dd8-6cd7-4f11-80b9-b20110b2c92a 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-8ec23dd8-6cd7-4f11-80b9-b20110b2c92a');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":6}]},{"cell_type":"code","source":["newdata = df.copy()\n","newdata"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":887},"id":"WLnfGVMd-o7q","outputId":"e009f23e-7dad-42fc-b85f-a4c6c4e57a31","executionInfo":{"status":"ok","timestamp":1667904236131,"user_tz":0,"elapsed":308,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                  author_id         username      author_location  \\\n","0        712000889427521537  community001500     Bristol, England   \n","1       1242068059088728065        dmm251144  South East, England   \n","2                 558636361          lochend   Cambridge, England   \n","3                  25550559     linda_whyman       United Kingdom   \n","4       1136757030822305792   Blueerryforest      London, England   \n","...                     ...              ...                  ...   \n","541723           3155243418        partyka_m  south east England    \n","541724  1418314766729289729       dree_kelly          Scotland uk   \n","541725            545512624       withthing2  South West, England   \n","541726            206900588  justalittlechat      London, England   \n","541727           2942221013     frogcrutches         South Wales.   \n","\n","                                                     text  \\\n","0       RT @StrikeMapUK: The Cost of Living Crisis is ...   \n","1       RT @0Calamity: This is not a #CostOfLivingCris...   \n","2       RT @geoffh33: Every non-Tory MP should have st...   \n","3       RT @hewitson10: Ian Blackford owned the show a...   \n","4       RT @snowy2007: Serious question for Scottish P...   \n","...                                                   ...   \n","541723  RT @SB_Sarah10: Do you honestly think #LizTrus...   \n","541724  RT @michaelbartrum: Every hour, 10 people die ...   \n","541725  Jesus! £170 billion excess profits over 2 yrs!...   \n","541726  RT @maxwellwoodger: Attended the Final @Conser...   \n","541727  #BorisJohnson plans to visit sites of his grea...   \n","\n","                       created_at tweet_location  retweets  replies   likes  \\\n","0       2022-03-30 23:56:24+00:00            NaN      48.0      0.0     0.0   \n","1       2022-03-30 23:56:01+00:00            NaN      44.0      0.0     0.0   \n","2       2022-03-30 23:50:10+00:00            NaN       4.0      0.0     0.0   \n","3       2022-03-30 23:48:39+00:00            NaN      58.0      0.0     0.0   \n","4       2022-03-30 23:46:14+00:00            NaN      34.0      0.0     0.0   \n","...                           ...            ...       ...      ...     ...   \n","541723  2022-09-01 00:38:56+00:00            NaN      55.0      0.0     0.0   \n","541724  2022-09-01 00:29:40+00:00            NaN       1.0      0.0     0.0   \n","541725  2022-09-01 00:28:15+00:00            NaN       0.0      0.0     0.0   \n","541726  2022-09-01 00:21:52+00:00            NaN       1.0      0.0     0.0   \n","541727  2022-09-01 00:02:29+00:00            NaN     502.0     20.0  1230.0   \n","\n","        quote_count                                     Cleaned_tweets  \n","0               0.0  cost living crisis political choice yet tory t...  \n","1               0.0  costoflivingcrisis stateimposedpoverty do quit...  \n","2               0.0  every non tory mp stand today call borisjohnso...  \n","3               0.0  ian blackford own show always tory care costof...  \n","4               0.0  serious question scottish power say energy gre...  \n","...             ...                                                ...  \n","541723          0.0    honestly think liztruss plan cost living crisis  \n","541724          0.0  every hour people die poverty uk rise costofli...  \n","541725          0.0  jesus billion excess profit yrs time take stre...  \n","541726          0.0  attend final leadership debate uk husting fell...  \n","541727         18.0     borisjohnson plan visit site great achievement  \n","\n","[541512 rows x 11 columns]"],"text/html":["\n","  <div id=\"df-4a998fcb-5824-4267-9193-20c33a333a3f\">\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>author_id</th>\n","      <th>username</th>\n","      <th>author_location</th>\n","      <th>text</th>\n","      <th>created_at</th>\n","      <th>tweet_location</th>\n","      <th>retweets</th>\n","      <th>replies</th>\n","      <th>likes</th>\n","      <th>quote_count</th>\n","      <th>Cleaned_tweets</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>712000889427521537</td>\n","      <td>community001500</td>\n","      <td>Bristol, England</td>\n","      <td>RT @StrikeMapUK: The Cost of Living Crisis is ...</td>\n","      <td>2022-03-30 23:56:24+00:00</td>\n","      <td>NaN</td>\n","      <td>48.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>cost living crisis political choice yet tory t...</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1242068059088728065</td>\n","      <td>dmm251144</td>\n","      <td>South East, England</td>\n","      <td>RT @0Calamity: This is not a #CostOfLivingCris...</td>\n","      <td>2022-03-30 23:56:01+00:00</td>\n","      <td>NaN</td>\n","      <td>44.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>costoflivingcrisis stateimposedpoverty do quit...</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>558636361</td>\n","      <td>lochend</td>\n","      <td>Cambridge, England</td>\n","      <td>RT @geoffh33: Every non-Tory MP should have st...</td>\n","      <td>2022-03-30 23:50:10+00:00</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every non tory mp stand today call borisjohnso...</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>25550559</td>\n","      <td>linda_whyman</td>\n","      <td>United Kingdom</td>\n","      <td>RT @hewitson10: Ian Blackford owned the show a...</td>\n","      <td>2022-03-30 23:48:39+00:00</td>\n","      <td>NaN</td>\n","      <td>58.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>ian blackford own show always tory care costof...</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1136757030822305792</td>\n","      <td>Blueerryforest</td>\n","      <td>London, England</td>\n","      <td>RT @snowy2007: Serious question for Scottish P...</td>\n","      <td>2022-03-30 23:46:14+00:00</td>\n","      <td>NaN</td>\n","      <td>34.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>serious question scottish power say energy gre...</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>541723</th>\n","      <td>3155243418</td>\n","      <td>partyka_m</td>\n","      <td>south east England</td>\n","      <td>RT @SB_Sarah10: Do you honestly think #LizTrus...</td>\n","      <td>2022-09-01 00:38:56+00:00</td>\n","      <td>NaN</td>\n","      <td>55.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>honestly think liztruss plan cost living crisis</td>\n","    </tr>\n","    <tr>\n","      <th>541724</th>\n","      <td>1418314766729289729</td>\n","      <td>dree_kelly</td>\n","      <td>Scotland uk</td>\n","      <td>RT @michaelbartrum: Every hour, 10 people die ...</td>\n","      <td>2022-09-01 00:29:40+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every hour people die poverty uk rise costofli...</td>\n","    </tr>\n","    <tr>\n","      <th>541725</th>\n","      <td>545512624</td>\n","      <td>withthing2</td>\n","      <td>South West, England</td>\n","      <td>Jesus! £170 billion excess profits over 2 yrs!...</td>\n","      <td>2022-09-01 00:28:15+00:00</td>\n","      <td>NaN</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>jesus billion excess profit yrs time take stre...</td>\n","    </tr>\n","    <tr>\n","      <th>541726</th>\n","      <td>206900588</td>\n","      <td>justalittlechat</td>\n","      <td>London, England</td>\n","      <td>RT @maxwellwoodger: Attended the Final @Conser...</td>\n","      <td>2022-09-01 00:21:52+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>attend final leadership debate uk husting fell...</td>\n","    </tr>\n","    <tr>\n","      <th>541727</th>\n","      <td>2942221013</td>\n","      <td>frogcrutches</td>\n","      <td>South Wales.</td>\n","      <td>#BorisJohnson plans to visit sites of his grea...</td>\n","      <td>2022-09-01 00:02:29+00:00</td>\n","      <td>NaN</td>\n","      <td>502.0</td>\n","      <td>20.0</td>\n","      <td>1230.0</td>\n","      <td>18.0</td>\n","      <td>borisjohnson plan visit site great achievement</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>541512 rows × 11 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4a998fcb-5824-4267-9193-20c33a333a3f')\"\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-4a998fcb-5824-4267-9193-20c33a333a3f 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-4a998fcb-5824-4267-9193-20c33a333a3f');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":7}]},{"cell_type":"code","source":["# newdata = newdata.drop('Unnamed: 0', axis=1)\n","# newdata"],"metadata":{"id":"9BJq-eNu-Qe-"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["newdata.drop_duplicates()\n","newdata"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":887},"id":"lZIlwlDdrX3G","outputId":"13d9ddfb-860d-460c-d639-af2516e3fc2f","executionInfo":{"status":"ok","timestamp":1667904242859,"user_tz":0,"elapsed":1462,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                  author_id         username      author_location  \\\n","0        712000889427521537  community001500     Bristol, England   \n","1       1242068059088728065        dmm251144  South East, England   \n","2                 558636361          lochend   Cambridge, England   \n","3                  25550559     linda_whyman       United Kingdom   \n","4       1136757030822305792   Blueerryforest      London, England   \n","...                     ...              ...                  ...   \n","541723           3155243418        partyka_m  south east England    \n","541724  1418314766729289729       dree_kelly          Scotland uk   \n","541725            545512624       withthing2  South West, England   \n","541726            206900588  justalittlechat      London, England   \n","541727           2942221013     frogcrutches         South Wales.   \n","\n","                                                     text  \\\n","0       RT @StrikeMapUK: The Cost of Living Crisis is ...   \n","1       RT @0Calamity: This is not a #CostOfLivingCris...   \n","2       RT @geoffh33: Every non-Tory MP should have st...   \n","3       RT @hewitson10: Ian Blackford owned the show a...   \n","4       RT @snowy2007: Serious question for Scottish P...   \n","...                                                   ...   \n","541723  RT @SB_Sarah10: Do you honestly think #LizTrus...   \n","541724  RT @michaelbartrum: Every hour, 10 people die ...   \n","541725  Jesus! £170 billion excess profits over 2 yrs!...   \n","541726  RT @maxwellwoodger: Attended the Final @Conser...   \n","541727  #BorisJohnson plans to visit sites of his grea...   \n","\n","                       created_at tweet_location  retweets  replies   likes  \\\n","0       2022-03-30 23:56:24+00:00            NaN      48.0      0.0     0.0   \n","1       2022-03-30 23:56:01+00:00            NaN      44.0      0.0     0.0   \n","2       2022-03-30 23:50:10+00:00            NaN       4.0      0.0     0.0   \n","3       2022-03-30 23:48:39+00:00            NaN      58.0      0.0     0.0   \n","4       2022-03-30 23:46:14+00:00            NaN      34.0      0.0     0.0   \n","...                           ...            ...       ...      ...     ...   \n","541723  2022-09-01 00:38:56+00:00            NaN      55.0      0.0     0.0   \n","541724  2022-09-01 00:29:40+00:00            NaN       1.0      0.0     0.0   \n","541725  2022-09-01 00:28:15+00:00            NaN       0.0      0.0     0.0   \n","541726  2022-09-01 00:21:52+00:00            NaN       1.0      0.0     0.0   \n","541727  2022-09-01 00:02:29+00:00            NaN     502.0     20.0  1230.0   \n","\n","        quote_count                                     Cleaned_tweets  \n","0               0.0  cost living crisis political choice yet tory t...  \n","1               0.0  costoflivingcrisis stateimposedpoverty do quit...  \n","2               0.0  every non tory mp stand today call borisjohnso...  \n","3               0.0  ian blackford own show always tory care costof...  \n","4               0.0  serious question scottish power say energy gre...  \n","...             ...                                                ...  \n","541723          0.0    honestly think liztruss plan cost living crisis  \n","541724          0.0  every hour people die poverty uk rise costofli...  \n","541725          0.0  jesus billion excess profit yrs time take stre...  \n","541726          0.0  attend final leadership debate uk husting fell...  \n","541727         18.0     borisjohnson plan visit site great achievement  \n","\n","[541512 rows x 11 columns]"],"text/html":["\n","  <div id=\"df-8bd66851-340a-46fb-81c3-f79ebce01869\">\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>author_id</th>\n","      <th>username</th>\n","      <th>author_location</th>\n","      <th>text</th>\n","      <th>created_at</th>\n","      <th>tweet_location</th>\n","      <th>retweets</th>\n","      <th>replies</th>\n","      <th>likes</th>\n","      <th>quote_count</th>\n","      <th>Cleaned_tweets</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>712000889427521537</td>\n","      <td>community001500</td>\n","      <td>Bristol, England</td>\n","      <td>RT @StrikeMapUK: The Cost of Living Crisis is ...</td>\n","      <td>2022-03-30 23:56:24+00:00</td>\n","      <td>NaN</td>\n","      <td>48.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>cost living crisis political choice yet tory t...</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1242068059088728065</td>\n","      <td>dmm251144</td>\n","      <td>South East, England</td>\n","      <td>RT @0Calamity: This is not a #CostOfLivingCris...</td>\n","      <td>2022-03-30 23:56:01+00:00</td>\n","      <td>NaN</td>\n","      <td>44.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>costoflivingcrisis stateimposedpoverty do quit...</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>558636361</td>\n","      <td>lochend</td>\n","      <td>Cambridge, England</td>\n","      <td>RT @geoffh33: Every non-Tory MP should have st...</td>\n","      <td>2022-03-30 23:50:10+00:00</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every non tory mp stand today call borisjohnso...</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>25550559</td>\n","      <td>linda_whyman</td>\n","      <td>United Kingdom</td>\n","      <td>RT @hewitson10: Ian Blackford owned the show a...</td>\n","      <td>2022-03-30 23:48:39+00:00</td>\n","      <td>NaN</td>\n","      <td>58.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>ian blackford own show always tory care costof...</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1136757030822305792</td>\n","      <td>Blueerryforest</td>\n","      <td>London, England</td>\n","      <td>RT @snowy2007: Serious question for Scottish P...</td>\n","      <td>2022-03-30 23:46:14+00:00</td>\n","      <td>NaN</td>\n","      <td>34.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>serious question scottish power say energy gre...</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>541723</th>\n","      <td>3155243418</td>\n","      <td>partyka_m</td>\n","      <td>south east England</td>\n","      <td>RT @SB_Sarah10: Do you honestly think #LizTrus...</td>\n","      <td>2022-09-01 00:38:56+00:00</td>\n","      <td>NaN</td>\n","      <td>55.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>honestly think liztruss plan cost living crisis</td>\n","    </tr>\n","    <tr>\n","      <th>541724</th>\n","      <td>1418314766729289729</td>\n","      <td>dree_kelly</td>\n","      <td>Scotland uk</td>\n","      <td>RT @michaelbartrum: Every hour, 10 people die ...</td>\n","      <td>2022-09-01 00:29:40+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every hour people die poverty uk rise costofli...</td>\n","    </tr>\n","    <tr>\n","      <th>541725</th>\n","      <td>545512624</td>\n","      <td>withthing2</td>\n","      <td>South West, England</td>\n","      <td>Jesus! £170 billion excess profits over 2 yrs!...</td>\n","      <td>2022-09-01 00:28:15+00:00</td>\n","      <td>NaN</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>jesus billion excess profit yrs time take stre...</td>\n","    </tr>\n","    <tr>\n","      <th>541726</th>\n","      <td>206900588</td>\n","      <td>justalittlechat</td>\n","      <td>London, England</td>\n","      <td>RT @maxwellwoodger: Attended the Final @Conser...</td>\n","      <td>2022-09-01 00:21:52+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>attend final leadership debate uk husting fell...</td>\n","    </tr>\n","    <tr>\n","      <th>541727</th>\n","      <td>2942221013</td>\n","      <td>frogcrutches</td>\n","      <td>South Wales.</td>\n","      <td>#BorisJohnson plans to visit sites of his grea...</td>\n","      <td>2022-09-01 00:02:29+00:00</td>\n","      <td>NaN</td>\n","      <td>502.0</td>\n","      <td>20.0</td>\n","      <td>1230.0</td>\n","      <td>18.0</td>\n","      <td>borisjohnson plan visit site great achievement</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>541512 rows × 11 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8bd66851-340a-46fb-81c3-f79ebce01869')\"\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-8bd66851-340a-46fb-81c3-f79ebce01869 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-8bd66851-340a-46fb-81c3-f79ebce01869');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":8}]},{"cell_type":"markdown","source":["### TextBlob Sentiment "],"metadata":{"id":"T7ZnMRCorj1p"}},{"cell_type":"code","execution_count":10,"metadata":{"id":"TxagZ4fv6RA4","executionInfo":{"status":"ok","timestamp":1667904342651,"user_tz":0,"elapsed":318,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"outputs":[],"source":["# function to calculate subjectivity\n","def getSubjectivity(tweet):\n","    return TextBlob(tweet).sentiment.subjectivity"]},{"cell_type":"code","source":["newdata['Subjectivity'] = newdata['Cleaned_tweets'].apply(getSubjectivity)\n","newdata"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":887},"id":"83PrvHkT15ye","executionInfo":{"status":"ok","timestamp":1667904453359,"user_tz":0,"elapsed":107002,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}},"outputId":"848b7b70-c268-4f1c-e596-ac4a40f2edef"},"execution_count":11,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                  author_id         username      author_location  \\\n","0        712000889427521537  community001500     Bristol, England   \n","1       1242068059088728065        dmm251144  South East, England   \n","2                 558636361          lochend   Cambridge, England   \n","3                  25550559     linda_whyman       United Kingdom   \n","4       1136757030822305792   Blueerryforest      London, England   \n","...                     ...              ...                  ...   \n","541723           3155243418        partyka_m  south east England    \n","541724  1418314766729289729       dree_kelly          Scotland uk   \n","541725            545512624       withthing2  South West, England   \n","541726            206900588  justalittlechat      London, England   \n","541727           2942221013     frogcrutches         South Wales.   \n","\n","                                                     text  \\\n","0       RT @StrikeMapUK: The Cost of Living Crisis is ...   \n","1       RT @0Calamity: This is not a #CostOfLivingCris...   \n","2       RT @geoffh33: Every non-Tory MP should have st...   \n","3       RT @hewitson10: Ian Blackford owned the show a...   \n","4       RT @snowy2007: Serious question for Scottish P...   \n","...                                                   ...   \n","541723  RT @SB_Sarah10: Do you honestly think #LizTrus...   \n","541724  RT @michaelbartrum: Every hour, 10 people die ...   \n","541725  Jesus! £170 billion excess profits over 2 yrs!...   \n","541726  RT @maxwellwoodger: Attended the Final @Conser...   \n","541727  #BorisJohnson plans to visit sites of his grea...   \n","\n","                       created_at tweet_location  retweets  replies   likes  \\\n","0       2022-03-30 23:56:24+00:00            NaN      48.0      0.0     0.0   \n","1       2022-03-30 23:56:01+00:00            NaN      44.0      0.0     0.0   \n","2       2022-03-30 23:50:10+00:00            NaN       4.0      0.0     0.0   \n","3       2022-03-30 23:48:39+00:00            NaN      58.0      0.0     0.0   \n","4       2022-03-30 23:46:14+00:00            NaN      34.0      0.0     0.0   \n","...                           ...            ...       ...      ...     ...   \n","541723  2022-09-01 00:38:56+00:00            NaN      55.0      0.0     0.0   \n","541724  2022-09-01 00:29:40+00:00            NaN       1.0      0.0     0.0   \n","541725  2022-09-01 00:28:15+00:00            NaN       0.0      0.0     0.0   \n","541726  2022-09-01 00:21:52+00:00            NaN       1.0      0.0     0.0   \n","541727  2022-09-01 00:02:29+00:00            NaN     502.0     20.0  1230.0   \n","\n","        quote_count                                     Cleaned_tweets  \\\n","0               0.0  cost living crisis political choice yet tory t...   \n","1               0.0  costoflivingcrisis stateimposedpoverty do quit...   \n","2               0.0  every non tory mp stand today call borisjohnso...   \n","3               0.0  ian blackford own show always tory care costof...   \n","4               0.0  serious question scottish power say energy gre...   \n","...             ...                                                ...   \n","541723          0.0    honestly think liztruss plan cost living crisis   \n","541724          0.0  every hour people die poverty uk rise costofli...   \n","541725          0.0  jesus billion excess profit yrs time take stre...   \n","541726          0.0  attend final leadership debate uk husting fell...   \n","541727         18.0     borisjohnson plan visit site great achievement   \n","\n","        Subjectivity  \n","0           0.300000  \n","1           0.625000  \n","2           0.000000  \n","3           1.000000  \n","4           0.483333  \n","...              ...  \n","541723      0.900000  \n","541724      0.666667  \n","541725      0.000000  \n","541726      1.000000  \n","541727      0.750000  \n","\n","[541512 rows x 12 columns]"],"text/html":["\n","  <div id=\"df-cf64e67b-782e-4dc1-a889-283b8fc0b94c\">\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>author_id</th>\n","      <th>username</th>\n","      <th>author_location</th>\n","      <th>text</th>\n","      <th>created_at</th>\n","      <th>tweet_location</th>\n","      <th>retweets</th>\n","      <th>replies</th>\n","      <th>likes</th>\n","      <th>quote_count</th>\n","      <th>Cleaned_tweets</th>\n","      <th>Subjectivity</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>712000889427521537</td>\n","      <td>community001500</td>\n","      <td>Bristol, England</td>\n","      <td>RT @StrikeMapUK: The Cost of Living Crisis is ...</td>\n","      <td>2022-03-30 23:56:24+00:00</td>\n","      <td>NaN</td>\n","      <td>48.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>cost living crisis political choice yet tory t...</td>\n","      <td>0.300000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1242068059088728065</td>\n","      <td>dmm251144</td>\n","      <td>South East, England</td>\n","      <td>RT @0Calamity: This is not a #CostOfLivingCris...</td>\n","      <td>2022-03-30 23:56:01+00:00</td>\n","      <td>NaN</td>\n","      <td>44.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>costoflivingcrisis stateimposedpoverty do quit...</td>\n","      <td>0.625000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>558636361</td>\n","      <td>lochend</td>\n","      <td>Cambridge, England</td>\n","      <td>RT @geoffh33: Every non-Tory MP should have st...</td>\n","      <td>2022-03-30 23:50:10+00:00</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every non tory mp stand today call borisjohnso...</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>25550559</td>\n","      <td>linda_whyman</td>\n","      <td>United Kingdom</td>\n","      <td>RT @hewitson10: Ian Blackford owned the show a...</td>\n","      <td>2022-03-30 23:48:39+00:00</td>\n","      <td>NaN</td>\n","      <td>58.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>ian blackford own show always tory care costof...</td>\n","      <td>1.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1136757030822305792</td>\n","      <td>Blueerryforest</td>\n","      <td>London, England</td>\n","      <td>RT @snowy2007: Serious question for Scottish P...</td>\n","      <td>2022-03-30 23:46:14+00:00</td>\n","      <td>NaN</td>\n","      <td>34.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>serious question scottish power say energy gre...</td>\n","      <td>0.483333</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>541723</th>\n","      <td>3155243418</td>\n","      <td>partyka_m</td>\n","      <td>south east England</td>\n","      <td>RT @SB_Sarah10: Do you honestly think #LizTrus...</td>\n","      <td>2022-09-01 00:38:56+00:00</td>\n","      <td>NaN</td>\n","      <td>55.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>honestly think liztruss plan cost living crisis</td>\n","      <td>0.900000</td>\n","    </tr>\n","    <tr>\n","      <th>541724</th>\n","      <td>1418314766729289729</td>\n","      <td>dree_kelly</td>\n","      <td>Scotland uk</td>\n","      <td>RT @michaelbartrum: Every hour, 10 people die ...</td>\n","      <td>2022-09-01 00:29:40+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every hour people die poverty uk rise costofli...</td>\n","      <td>0.666667</td>\n","    </tr>\n","    <tr>\n","      <th>541725</th>\n","      <td>545512624</td>\n","      <td>withthing2</td>\n","      <td>South West, England</td>\n","      <td>Jesus! £170 billion excess profits over 2 yrs!...</td>\n","      <td>2022-09-01 00:28:15+00:00</td>\n","      <td>NaN</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>jesus billion excess profit yrs time take stre...</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>541726</th>\n","      <td>206900588</td>\n","      <td>justalittlechat</td>\n","      <td>London, England</td>\n","      <td>RT @maxwellwoodger: Attended the Final @Conser...</td>\n","      <td>2022-09-01 00:21:52+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>attend final leadership debate uk husting fell...</td>\n","      <td>1.000000</td>\n","    </tr>\n","    <tr>\n","      <th>541727</th>\n","      <td>2942221013</td>\n","      <td>frogcrutches</td>\n","      <td>South Wales.</td>\n","      <td>#BorisJohnson plans to visit sites of his grea...</td>\n","      <td>2022-09-01 00:02:29+00:00</td>\n","      <td>NaN</td>\n","      <td>502.0</td>\n","      <td>20.0</td>\n","      <td>1230.0</td>\n","      <td>18.0</td>\n","      <td>borisjohnson plan visit site great achievement</td>\n","      <td>0.750000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>541512 rows × 12 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cf64e67b-782e-4dc1-a889-283b8fc0b94c')\"\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-cf64e67b-782e-4dc1-a889-283b8fc0b94c 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-cf64e67b-782e-4dc1-a889-283b8fc0b94c');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":11}]},{"cell_type":"code","source":["# function to calculate polarity\n","def getPolarity(tweet):\n","    return TextBlob(tweet).sentiment.polarity"],"metadata":{"id":"3NST5eey12J_","executionInfo":{"status":"ok","timestamp":1667904583772,"user_tz":0,"elapsed":243,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":12,"outputs":[]},{"cell_type":"code","source":["newdata['Polarity'] = newdata['Cleaned_tweets'].apply(getPolarity)\n","newdata"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":887},"id":"K5f2jSTZ2BGt","executionInfo":{"status":"ok","timestamp":1667904695095,"user_tz":0,"elapsed":109199,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}},"outputId":"17f8c667-591c-45c0-9784-1d6ff4b9a2c7"},"execution_count":13,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                  author_id         username      author_location  \\\n","0        712000889427521537  community001500     Bristol, England   \n","1       1242068059088728065        dmm251144  South East, England   \n","2                 558636361          lochend   Cambridge, England   \n","3                  25550559     linda_whyman       United Kingdom   \n","4       1136757030822305792   Blueerryforest      London, England   \n","...                     ...              ...                  ...   \n","541723           3155243418        partyka_m  south east England    \n","541724  1418314766729289729       dree_kelly          Scotland uk   \n","541725            545512624       withthing2  South West, England   \n","541726            206900588  justalittlechat      London, England   \n","541727           2942221013     frogcrutches         South Wales.   \n","\n","                                                     text  \\\n","0       RT @StrikeMapUK: The Cost of Living Crisis is ...   \n","1       RT @0Calamity: This is not a #CostOfLivingCris...   \n","2       RT @geoffh33: Every non-Tory MP should have st...   \n","3       RT @hewitson10: Ian Blackford owned the show a...   \n","4       RT @snowy2007: Serious question for Scottish P...   \n","...                                                   ...   \n","541723  RT @SB_Sarah10: Do you honestly think #LizTrus...   \n","541724  RT @michaelbartrum: Every hour, 10 people die ...   \n","541725  Jesus! £170 billion excess profits over 2 yrs!...   \n","541726  RT @maxwellwoodger: Attended the Final @Conser...   \n","541727  #BorisJohnson plans to visit sites of his grea...   \n","\n","                       created_at tweet_location  retweets  replies   likes  \\\n","0       2022-03-30 23:56:24+00:00            NaN      48.0      0.0     0.0   \n","1       2022-03-30 23:56:01+00:00            NaN      44.0      0.0     0.0   \n","2       2022-03-30 23:50:10+00:00            NaN       4.0      0.0     0.0   \n","3       2022-03-30 23:48:39+00:00            NaN      58.0      0.0     0.0   \n","4       2022-03-30 23:46:14+00:00            NaN      34.0      0.0     0.0   \n","...                           ...            ...       ...      ...     ...   \n","541723  2022-09-01 00:38:56+00:00            NaN      55.0      0.0     0.0   \n","541724  2022-09-01 00:29:40+00:00            NaN       1.0      0.0     0.0   \n","541725  2022-09-01 00:28:15+00:00            NaN       0.0      0.0     0.0   \n","541726  2022-09-01 00:21:52+00:00            NaN       1.0      0.0     0.0   \n","541727  2022-09-01 00:02:29+00:00            NaN     502.0     20.0  1230.0   \n","\n","        quote_count                                     Cleaned_tweets  \\\n","0               0.0  cost living crisis political choice yet tory t...   \n","1               0.0  costoflivingcrisis stateimposedpoverty do quit...   \n","2               0.0  every non tory mp stand today call borisjohnso...   \n","3               0.0  ian blackford own show always tory care costof...   \n","4               0.0  serious question scottish power say energy gre...   \n","...             ...                                                ...   \n","541723          0.0    honestly think liztruss plan cost living crisis   \n","541724          0.0  every hour people die poverty uk rise costofli...   \n","541725          0.0  jesus billion excess profit yrs time take stre...   \n","541726          0.0  attend final leadership debate uk husting fell...   \n","541727         18.0     borisjohnson plan visit site great achievement   \n","\n","        Subjectivity  Polarity  \n","0           0.300000 -0.125000  \n","1           0.625000  0.500000  \n","2           0.000000  0.000000  \n","3           1.000000  0.600000  \n","4           0.483333 -0.266667  \n","...              ...       ...  \n","541723      0.900000  0.600000  \n","541724      0.666667 -0.700000  \n","541725      0.000000  0.000000  \n","541726      1.000000  0.000000  \n","541727      0.750000  0.800000  \n","\n","[541512 rows x 13 columns]"],"text/html":["\n","  <div id=\"df-f64ce32c-1cf1-47f9-bea8-31d7450a0220\">\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>author_id</th>\n","      <th>username</th>\n","      <th>author_location</th>\n","      <th>text</th>\n","      <th>created_at</th>\n","      <th>tweet_location</th>\n","      <th>retweets</th>\n","      <th>replies</th>\n","      <th>likes</th>\n","      <th>quote_count</th>\n","      <th>Cleaned_tweets</th>\n","      <th>Subjectivity</th>\n","      <th>Polarity</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>712000889427521537</td>\n","      <td>community001500</td>\n","      <td>Bristol, England</td>\n","      <td>RT @StrikeMapUK: The Cost of Living Crisis is ...</td>\n","      <td>2022-03-30 23:56:24+00:00</td>\n","      <td>NaN</td>\n","      <td>48.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>cost living crisis political choice yet tory t...</td>\n","      <td>0.300000</td>\n","      <td>-0.125000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1242068059088728065</td>\n","      <td>dmm251144</td>\n","      <td>South East, England</td>\n","      <td>RT @0Calamity: This is not a #CostOfLivingCris...</td>\n","      <td>2022-03-30 23:56:01+00:00</td>\n","      <td>NaN</td>\n","      <td>44.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>costoflivingcrisis stateimposedpoverty do quit...</td>\n","      <td>0.625000</td>\n","      <td>0.500000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>558636361</td>\n","      <td>lochend</td>\n","      <td>Cambridge, England</td>\n","      <td>RT @geoffh33: Every non-Tory MP should have st...</td>\n","      <td>2022-03-30 23:50:10+00:00</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every non tory mp stand today call borisjohnso...</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>25550559</td>\n","      <td>linda_whyman</td>\n","      <td>United Kingdom</td>\n","      <td>RT @hewitson10: Ian Blackford owned the show a...</td>\n","      <td>2022-03-30 23:48:39+00:00</td>\n","      <td>NaN</td>\n","      <td>58.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>ian blackford own show always tory care costof...</td>\n","      <td>1.000000</td>\n","      <td>0.600000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1136757030822305792</td>\n","      <td>Blueerryforest</td>\n","      <td>London, England</td>\n","      <td>RT @snowy2007: Serious question for Scottish P...</td>\n","      <td>2022-03-30 23:46:14+00:00</td>\n","      <td>NaN</td>\n","      <td>34.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>serious question scottish power say energy gre...</td>\n","      <td>0.483333</td>\n","      <td>-0.266667</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>541723</th>\n","      <td>3155243418</td>\n","      <td>partyka_m</td>\n","      <td>south east England</td>\n","      <td>RT @SB_Sarah10: Do you honestly think #LizTrus...</td>\n","      <td>2022-09-01 00:38:56+00:00</td>\n","      <td>NaN</td>\n","      <td>55.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>honestly think liztruss plan cost living crisis</td>\n","      <td>0.900000</td>\n","      <td>0.600000</td>\n","    </tr>\n","    <tr>\n","      <th>541724</th>\n","      <td>1418314766729289729</td>\n","      <td>dree_kelly</td>\n","      <td>Scotland uk</td>\n","      <td>RT @michaelbartrum: Every hour, 10 people die ...</td>\n","      <td>2022-09-01 00:29:40+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every hour people die poverty uk rise costofli...</td>\n","      <td>0.666667</td>\n","      <td>-0.700000</td>\n","    </tr>\n","    <tr>\n","      <th>541725</th>\n","      <td>545512624</td>\n","      <td>withthing2</td>\n","      <td>South West, England</td>\n","      <td>Jesus! £170 billion excess profits over 2 yrs!...</td>\n","      <td>2022-09-01 00:28:15+00:00</td>\n","      <td>NaN</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>jesus billion excess profit yrs time take stre...</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>541726</th>\n","      <td>206900588</td>\n","      <td>justalittlechat</td>\n","      <td>London, England</td>\n","      <td>RT @maxwellwoodger: Attended the Final @Conser...</td>\n","      <td>2022-09-01 00:21:52+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>attend final leadership debate uk husting fell...</td>\n","      <td>1.000000</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>541727</th>\n","      <td>2942221013</td>\n","      <td>frogcrutches</td>\n","      <td>South Wales.</td>\n","      <td>#BorisJohnson plans to visit sites of his grea...</td>\n","      <td>2022-09-01 00:02:29+00:00</td>\n","      <td>NaN</td>\n","      <td>502.0</td>\n","      <td>20.0</td>\n","      <td>1230.0</td>\n","      <td>18.0</td>\n","      <td>borisjohnson plan visit site great achievement</td>\n","      <td>0.750000</td>\n","      <td>0.800000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>541512 rows × 13 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f64ce32c-1cf1-47f9-bea8-31d7450a0220')\"\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-f64ce32c-1cf1-47f9-bea8-31d7450a0220 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-f64ce32c-1cf1-47f9-bea8-31d7450a0220');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":13}]},{"cell_type":"code","source":["# function to analyze the reviews\n","def analysis(score):\n","    if score < 0:\n","        return 'Negative'\n","    elif score == 0:\n","        return 'Neutral'\n","    else:\n","        return 'Positive'"],"metadata":{"id":"KJcEuC_T1-Xr","executionInfo":{"status":"ok","timestamp":1667904710935,"user_tz":0,"elapsed":222,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":14,"outputs":[]},{"cell_type":"code","source":["newdata['Analysis'] = newdata['Polarity'].apply(analysis)\n","newdata"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":887},"id":"GRko0vfB-zJS","outputId":"86c941bb-0f27-4df5-968e-fd4e6fe29a4d","executionInfo":{"status":"ok","timestamp":1667904713892,"user_tz":0,"elapsed":254,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                  author_id         username      author_location  \\\n","0        712000889427521537  community001500     Bristol, England   \n","1       1242068059088728065        dmm251144  South East, England   \n","2                 558636361          lochend   Cambridge, England   \n","3                  25550559     linda_whyman       United Kingdom   \n","4       1136757030822305792   Blueerryforest      London, England   \n","...                     ...              ...                  ...   \n","541723           3155243418        partyka_m  south east England    \n","541724  1418314766729289729       dree_kelly          Scotland uk   \n","541725            545512624       withthing2  South West, England   \n","541726            206900588  justalittlechat      London, England   \n","541727           2942221013     frogcrutches         South Wales.   \n","\n","                                                     text  \\\n","0       RT @StrikeMapUK: The Cost of Living Crisis is ...   \n","1       RT @0Calamity: This is not a #CostOfLivingCris...   \n","2       RT @geoffh33: Every non-Tory MP should have st...   \n","3       RT @hewitson10: Ian Blackford owned the show a...   \n","4       RT @snowy2007: Serious question for Scottish P...   \n","...                                                   ...   \n","541723  RT @SB_Sarah10: Do you honestly think #LizTrus...   \n","541724  RT @michaelbartrum: Every hour, 10 people die ...   \n","541725  Jesus! £170 billion excess profits over 2 yrs!...   \n","541726  RT @maxwellwoodger: Attended the Final @Conser...   \n","541727  #BorisJohnson plans to visit sites of his grea...   \n","\n","                       created_at tweet_location  retweets  replies   likes  \\\n","0       2022-03-30 23:56:24+00:00            NaN      48.0      0.0     0.0   \n","1       2022-03-30 23:56:01+00:00            NaN      44.0      0.0     0.0   \n","2       2022-03-30 23:50:10+00:00            NaN       4.0      0.0     0.0   \n","3       2022-03-30 23:48:39+00:00            NaN      58.0      0.0     0.0   \n","4       2022-03-30 23:46:14+00:00            NaN      34.0      0.0     0.0   \n","...                           ...            ...       ...      ...     ...   \n","541723  2022-09-01 00:38:56+00:00            NaN      55.0      0.0     0.0   \n","541724  2022-09-01 00:29:40+00:00            NaN       1.0      0.0     0.0   \n","541725  2022-09-01 00:28:15+00:00            NaN       0.0      0.0     0.0   \n","541726  2022-09-01 00:21:52+00:00            NaN       1.0      0.0     0.0   \n","541727  2022-09-01 00:02:29+00:00            NaN     502.0     20.0  1230.0   \n","\n","        quote_count                                     Cleaned_tweets  \\\n","0               0.0  cost living crisis political choice yet tory t...   \n","1               0.0  costoflivingcrisis stateimposedpoverty do quit...   \n","2               0.0  every non tory mp stand today call borisjohnso...   \n","3               0.0  ian blackford own show always tory care costof...   \n","4               0.0  serious question scottish power say energy gre...   \n","...             ...                                                ...   \n","541723          0.0    honestly think liztruss plan cost living crisis   \n","541724          0.0  every hour people die poverty uk rise costofli...   \n","541725          0.0  jesus billion excess profit yrs time take stre...   \n","541726          0.0  attend final leadership debate uk husting fell...   \n","541727         18.0     borisjohnson plan visit site great achievement   \n","\n","        Subjectivity  Polarity  Analysis  \n","0           0.300000 -0.125000  Negative  \n","1           0.625000  0.500000  Positive  \n","2           0.000000  0.000000   Neutral  \n","3           1.000000  0.600000  Positive  \n","4           0.483333 -0.266667  Negative  \n","...              ...       ...       ...  \n","541723      0.900000  0.600000  Positive  \n","541724      0.666667 -0.700000  Negative  \n","541725      0.000000  0.000000   Neutral  \n","541726      1.000000  0.000000   Neutral  \n","541727      0.750000  0.800000  Positive  \n","\n","[541512 rows x 14 columns]"],"text/html":["\n","  <div id=\"df-67b7c8fb-d99b-466f-8252-ce870716ee6b\">\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>author_id</th>\n","      <th>username</th>\n","      <th>author_location</th>\n","      <th>text</th>\n","      <th>created_at</th>\n","      <th>tweet_location</th>\n","      <th>retweets</th>\n","      <th>replies</th>\n","      <th>likes</th>\n","      <th>quote_count</th>\n","      <th>Cleaned_tweets</th>\n","      <th>Subjectivity</th>\n","      <th>Polarity</th>\n","      <th>Analysis</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>712000889427521537</td>\n","      <td>community001500</td>\n","      <td>Bristol, England</td>\n","      <td>RT @StrikeMapUK: The Cost of Living Crisis is ...</td>\n","      <td>2022-03-30 23:56:24+00:00</td>\n","      <td>NaN</td>\n","      <td>48.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>cost living crisis political choice yet tory t...</td>\n","      <td>0.300000</td>\n","      <td>-0.125000</td>\n","      <td>Negative</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1242068059088728065</td>\n","      <td>dmm251144</td>\n","      <td>South East, England</td>\n","      <td>RT @0Calamity: This is not a #CostOfLivingCris...</td>\n","      <td>2022-03-30 23:56:01+00:00</td>\n","      <td>NaN</td>\n","      <td>44.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>costoflivingcrisis stateimposedpoverty do quit...</td>\n","      <td>0.625000</td>\n","      <td>0.500000</td>\n","      <td>Positive</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>558636361</td>\n","      <td>lochend</td>\n","      <td>Cambridge, England</td>\n","      <td>RT @geoffh33: Every non-Tory MP should have st...</td>\n","      <td>2022-03-30 23:50:10+00:00</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every non tory mp stand today call borisjohnso...</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>25550559</td>\n","      <td>linda_whyman</td>\n","      <td>United Kingdom</td>\n","      <td>RT @hewitson10: Ian Blackford owned the show a...</td>\n","      <td>2022-03-30 23:48:39+00:00</td>\n","      <td>NaN</td>\n","      <td>58.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>ian blackford own show always tory care costof...</td>\n","      <td>1.000000</td>\n","      <td>0.600000</td>\n","      <td>Positive</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1136757030822305792</td>\n","      <td>Blueerryforest</td>\n","      <td>London, England</td>\n","      <td>RT @snowy2007: Serious question for Scottish P...</td>\n","      <td>2022-03-30 23:46:14+00:00</td>\n","      <td>NaN</td>\n","      <td>34.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>serious question scottish power say energy gre...</td>\n","      <td>0.483333</td>\n","      <td>-0.266667</td>\n","      <td>Negative</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>541723</th>\n","      <td>3155243418</td>\n","      <td>partyka_m</td>\n","      <td>south east England</td>\n","      <td>RT @SB_Sarah10: Do you honestly think #LizTrus...</td>\n","      <td>2022-09-01 00:38:56+00:00</td>\n","      <td>NaN</td>\n","      <td>55.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>honestly think liztruss plan cost living crisis</td>\n","      <td>0.900000</td>\n","      <td>0.600000</td>\n","      <td>Positive</td>\n","    </tr>\n","    <tr>\n","      <th>541724</th>\n","      <td>1418314766729289729</td>\n","      <td>dree_kelly</td>\n","      <td>Scotland uk</td>\n","      <td>RT @michaelbartrum: Every hour, 10 people die ...</td>\n","      <td>2022-09-01 00:29:40+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every hour people die poverty uk rise costofli...</td>\n","      <td>0.666667</td>\n","      <td>-0.700000</td>\n","      <td>Negative</td>\n","    </tr>\n","    <tr>\n","      <th>541725</th>\n","      <td>545512624</td>\n","      <td>withthing2</td>\n","      <td>South West, England</td>\n","      <td>Jesus! £170 billion excess profits over 2 yrs!...</td>\n","      <td>2022-09-01 00:28:15+00:00</td>\n","      <td>NaN</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>jesus billion excess profit yrs time take stre...</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>541726</th>\n","      <td>206900588</td>\n","      <td>justalittlechat</td>\n","      <td>London, England</td>\n","      <td>RT @maxwellwoodger: Attended the Final @Conser...</td>\n","      <td>2022-09-01 00:21:52+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>attend final leadership debate uk husting fell...</td>\n","      <td>1.000000</td>\n","      <td>0.000000</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>541727</th>\n","      <td>2942221013</td>\n","      <td>frogcrutches</td>\n","      <td>South Wales.</td>\n","      <td>#BorisJohnson plans to visit sites of his grea...</td>\n","      <td>2022-09-01 00:02:29+00:00</td>\n","      <td>NaN</td>\n","      <td>502.0</td>\n","      <td>20.0</td>\n","      <td>1230.0</td>\n","      <td>18.0</td>\n","      <td>borisjohnson plan visit site great achievement</td>\n","      <td>0.750000</td>\n","      <td>0.800000</td>\n","      <td>Positive</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>541512 rows × 14 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-67b7c8fb-d99b-466f-8252-ce870716ee6b')\"\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-67b7c8fb-d99b-466f-8252-ce870716ee6b 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-67b7c8fb-d99b-466f-8252-ce870716ee6b');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":15}]},{"cell_type":"code","source":["tb_counts = newdata.Analysis.value_counts()\n","tb_counts"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"bTriRw-5AMwq","outputId":"7f0db014-8366-48fc-fb4f-863db84f3fb3","executionInfo":{"status":"ok","timestamp":1667904726665,"user_tz":0,"elapsed":248,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":16,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Neutral     237028\n","Positive    188494\n","Negative    115990\n","Name: Analysis, dtype: int64"]},"metadata":{},"execution_count":16}]},{"cell_type":"code","source":["tb_count= newdata.Analysis.value_counts()\n","plt.figure(figsize=(10, 7))\n","plt.pie(tb_counts.values, labels = tb_counts.index, explode = (0, 0, 0.25), autopct='%1.1f%%', shadow=False)\n","plt.savefig('TextBlobSent.png')\n","plt.legend()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":429},"id":"Yg-erid4ATVM","outputId":"f5678752-f01f-4ee7-e469-ca267116f45a","executionInfo":{"status":"ok","timestamp":1667904738380,"user_tz":0,"elapsed":1143,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":17,"outputs":[{"output_type":"execute_result","data":{"text/plain":["<matplotlib.legend.Legend at 0x7fb16aad3790>"]},"metadata":{},"execution_count":17},{"output_type":"display_data","data":{"text/plain":["<Figure size 720x504 with 1 Axes>"],"image/png":"iVBORw0KGgoAAAANSUhEUgAAAZoAAAGKCAYAAAA10If4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3dd5xU1f3/8dfZSluG3hQYEZC2FImoWGNU4neDKYKaaFijGCyJiS2OMTFjTHQtGOPXkqiJkvzU2OsYNfkaMYKC9KEK6grS6ywLy7a5vz/ugCsCy7Jz58ydeT8fj3no7s7c8x6F/cwp9xzjOA4iIiJeybEdQEREMpsKjYiIeEqFRkREPKVCIyIinlKhERERT6nQiIiIp1RoRETEUyo0IiLiKRUaERHxlAqNiIh4Ks92ABGRppo9e3aXvLy8R4Eh6ANzU8WBhXV1dRNHjhy5IRUNqtCIiO/k5eU92q1bt4GdO3fempOTow0bmyAej5uNGzcOWrdu3aPA2aloU58ERMSPhnTu3LlCRabpcnJynM6dO8dwe4OpaTNVDYmIJFGOisyhS/y3S9nvfxUaERHxlOZoRMT3gqHIyGRer7ysZHZjzzHGjJw4ceL6Rx555HOAm2++uWtlZWXuPffcs6ap7W3atCn30Ucf7RAKhTY29bWHHXZY8axZs5Z07969rqmvTRX1aEREDkFBQYHz+uuvt1+7dm2zP7Bv3rw59y9/+UuXff2stra2uZe3ToVGROQQ5ObmOhMmTNh42223dd37Z2vWrMkbM2bMkUOGDBk4ZMiQgW+99VZrgGuuuabHzTffvOf5/fr1G7xs2bKCa6+99vBVq1YVDhgwYNCkSZMOf+2114pGjhx51Gmnnda3X79+QwBOP/30IwcPHjywb9++g+++++5OqXunzaehMxGRQ3T99ddvKC4uHhwOh9c1/P6kSZN6XnPNNevHjBlTuXz58oIxY8b0++STTxbt7zqTJ0/+/Fvf+lbLpUuXLgZ47bXXihYvXtxq7ty5iwYMGFAD8MQTT5R37dq1vrKy0owYMWLQhRdeuLVbt2713r7D5FChERE5RB06dIiPHz9+c1lZWZeWLVvGd39/2rRpbZcvX95y99eVlZW5sVisSSNIQ4cO3bG7yADccccdXSORSDuAdevW5S9atKhFt27ddiTjfXhNhUZEpBluvPHG9UcfffSg888/f9Pu7zmOw5w5c5a0atXqS0uw8/LynHh8Tz2iurra7O+6rVq12vPE1157rWjq1KlFs2bNWlpUVBQfNWrUUVVVVb6Z+vBNUBGRdNS1a9f6sWPHbn3yySf3zJuceOKJFbfffvueyf3p06e3BAgGg9Xz5s1rDfDee++1Wr16dSFAIBCo37Fjx35/H2/bti03EAjUFxUVxefOndti/vz5rb17R8mnHo2I+N7BLEf20k033bRuypQpnXd//fDDD6+aOHFir/79+w+qr683xx577PbRo0evnDBhwtYnnniiY9++fQePGDFiR+/evXcBdOvWrX7kyJGV/fr1G3zaaafFxo4dG2t4/XPOOSf28MMPd+7Tp8/gPn367Bo2bJgvhsx2M46jm2tFxF/mz59fPmzYsE2NP1P2Z/78+Z2GDRsWTEVbGjoTERFPqdCIiIinVGhERMRTKjQiacoY4xhjJjf4+jpjTPgQr9XOGHPFIb623BjjqzvRJb2o0Iikr2rge0n6Jd8O2GehMcZo9al4SoVGJH3VAQ8DV+/9A2NMZ2PM88aYDxOPExLfDxtjrmvwvIXGmCBQBhxpjJlnjLnLGHOqMea/xphXgMWJ575kjJltjFlkjPlxCt6fZAl9khFJbw8AC4wxd+71/T8Cf3Ac5z1jTC/gTWDgAa4TAoY4jjMcwBhzKnB04nufJp5zseM4W4wxLYEPjTHPO46zOZlvxjPhQFKPCSAca/S+nNzc3JH9+vWrqq+vN3379q165plnyouKiuKNvW638vLy/Msuu6znG2+88cn06dNbrlq1quC8886LATzxxBOBRYsWtbztttvWNXYdP1CPRiSNOY5TAfwNuGqvH50O3G+MmQe8ArQ1xrRp4uVnNigyAFcZY+YDHwA9gX6HGDsrFBYWxpcuXbp4+fLli/Lz853Jkyd3bvxVXwgGg7VvvPHGJwCzZs1qFYlEArt/dsEFF8QypciACo2IH9wLXAI03HYkBzjOcZzhicdhjuNU4g63Nfx73eIA191zd3mih3M6cLzjOMOAuY28Vho48cQTK1esWFG4fv363NNPP/3I/v37Dxo2bNiAGTNmtASIRCJtBgwYMGjAgAGDBg4cOGjr1q05y5YtK+jXr9/gXbt2mdtvv73Hq6++2n7AgAGDHnnkkfb33XdfxwkTJvTavHlzbo8ePYrr691NmisqKnK6des2tLq62ixatKjwpJNO6jd48OCBI0eOPGru3Llp+/9LhUYkzTmOswV4BrfY7PYW8NPdXxhjhif+tRx3SAxjzNHAEYnvbweKDtBMANjqOM5OY8wA4LikhM8CtbW1vPnmm22Li4urfvGLX/QYNmzYzo8++mjxrbfeurq0tPQIgMmTJ3e77777Plu6dOniDz74YGmbNm32DLG1aNHCufHGG9eMHTt269KlSxdfeumlW3f/rGPHjvUDBw7c+frrrxcBPP3004FTTjklVlhY6EycOLH3gw8+uHLRokVL7rrrrs8vv/zyXql/9wdHhUbEHyYDDVefXQV8zRizwBizGLgs8f3ngQ7GmEXAT4CPABJzLdMSiwPu2sf13wDyjDFLcBcOfODR+8gY1dXVOQMGDBhUXFw86PDDD6/52c9+tmnmzJlFl1xyyWaAs88+e/u2bdvytmzZknPcccdVXnfddT1/97vfddm0aVNufn7+Qbczfvz4rU899VR7gGeeeabD+eefvzUWi+XMnTu3zfjx448cMGDAoCuuuKL3hg0bDv6iKabFACJpynGcNg3+fT3QqsHXm4Dz9vGaKuDM/VzvB3t9650GP6sGztrP64JNiJ01ds/RHMxzb7vttnXf+c53Yi+//HLgpJNOGhCJRJY3PAbgQL7//e9vu/XWWw9bv3597sKFC1uNHTu2oqKiIqeoqKjuYNu3TT0aEZEkOfbYY7c/9thjHcE9Q6Z9+/Z1HTp0iC9atKhw1KhRVb///e/XDR06dMfChQu/NJ/Stm3b+srKyn3+Pg4EAvGhQ4fumDRpUq9vfOMbsby8PDp06BA//PDDa/7617+2B4jH47z//vst9/X6dKAejYj430EsR06FO+64Y80FF1wQ7N+//6CWLVvGH3/88U8B7rzzzi7Tp09va4xxjjrqqKpx48bFVq5cuWeo66yzztp+9913dx8wYMCga6+9du3e1z333HO3XnzxxX1ee+21Zbu/99RTT31y6aWX9r7jjju619XVme9+97tbjj/++KrUvNOm0TEBIuI7Oiag+XRMgIiIZAwVGhER8ZQKjYiIeEqFRkREPKVVZ5KxgqGIAdoC7XG3yT/Qow1QD9QAtYl/NvaoAtYBnwOfl5eVxFL01kR8RYVGfCsYiuQAQaD/Xo8+QEfcIpOyXnswFNkOrCZReBKPVQ2/Li8r2ZKqPCLpQoVG0l4wFOnKV4tJf+BIoNBitL0VAQMSj30KhiKVwCJgfoPHgvKyku0pSZihiqcUJ/WYgGhptNH7cowxIydOnLj+kUce+Rzg5ptv7lpZWZl7zz33rElmllAo1K2srGzPTs4jRowYMHfu3KXJbMNrKjSSVoKhSD4wEjgp8RiN2zvJFG2AYxOP3ZxgKPIpMBuYmXjMKi8r2WkhnxykgoIC5/XXX2+/du3add27d6/zqp377ruve8NC47ciA1oMIJYFQ5HWwVDk9GAockswFHkb2Aa8D9wJjCWzisz+GNzhvvHAXcBUoCIYiswPhiIPB0ORHwVDkR5WE8pX5ObmOhMmTNh42223dd37Z2vWrMkbM2bMkUOGDBk4ZMiQgW+99Vbr3d8fPXp0v759+w4+77zzevfo0aN47dq1eQCnn376kYMHDx7Yt2/fwXfffXcngCuuuOKw3Zt3nn322UcAtGrVagTAt771rT7/+Mc/9pxhc8455wQfe+yx9nV1dUyaNOnwIUOGDOzfv/+gu+66KxlHgTeLejSSUsFQpBNwIl/0WEagP4f7kgsMTTwuBQiGIvOA1xOPD8rLSurtxROA66+/fkNxcfHgcDj8pUPKJk2a1POaa65ZP2bMmMrly5cXjBkzpt8nn3yyKBQK9TjllFO233777euee+65ts8888yeIvDEE0+Ud+3atb6ystKMGDFi0IUXXrj1wQcfXP3444932dfmmeeee+6WZ555pv35558f27Vrl5k2bVrbKVOmfHbvvfd2CgQC9QsXLlxSVVVljjnmmAFjx46tGDBgQE0q/pvsi/6Ci+eCociRuJ/Wx+GelWLsJvKt4YnHL4EtwVDkLSACvFFeVqLtWCzo0KFDfPz48ZvLysq6tGzZcs9uzNOmTWu7fPnyPZtcVlZW5sZisZyZM2e2eemll1YAjBs3rqJt27Z7PizccccdXSORSDuAdevW5S9atKhFt27ddrAf48aNi91www09q6qqzPPPPx8YNWrU9jZt2jj//ve/2y5durTVK6+80h5g+/btuYsXL26hQiMZJxiK9MMtLuNxfzlKcnUAzk884sFQ5EO+6O3MLi8r0SaGKXLjjTeuP/roowedf/75e4q94zjMmTNnSatWrQ7q/8Nrr71WNHXq1KJZs2YtLSoqio8aNeqoqqqqA05ttGrVyjnuuOO2v/DCC22ffvrp9ueff/6WRNtm8uTJK88555yK5r2z5NEcjSRNMBQ5KhiK/CoYiszHPXDr96jIpEIO7uKCW4APgbXBUOSBYCiS1JVYsm9du3atHzt27NYnn3xyzzDYiSeeWHH77bd32f319OnTWwIcc8wxlX//+987ALzwwgttKyoqcgG2bduWGwgE6ouKiuJz585tMX/+/D3Hdufl5TnV1dX7HAU477zztj7++OOdPvzww6LdheWMM86IPfTQQ513v2bBggWFFRUVVn/Xq0cjzRIMRQbyRc9liOU44uoKXAFckSj6fwGeyOR7eA5mObKXbrrppnVTpkzpvPvrhx9+eNXEiRN79e/ff1B9fb059thjt48ePXplWVnZmnHjxvXp169fx5EjR1Z26tSptl27dvXnnHNO7OGHH+7cp0+fwX369Nk1bNiwPUNmF1xwwcaBAwcOGjJkyM5XXnnl04btfve7362YNGnSEWeccca2Fi1aOABXX331pvLy8sLi4uKBjuOYDh061L7++usfp+6/xlfpmABpsmAo0gr4Ie4vs6GW48jBqQZexC06/+f3oTW/HhNQVVVl8vLynPz8fP7973+3/slPftLb1imZqTwmQD0aOWjBUCSIew79xbjbuoh/FPLFnM5nwVDkMeCx8rKSlXZjZZcVK1YUnHvuuUfG43Hy8/OdP//5z+W2M6WCejTSqGAochpwFe59LZrXyxxx4P9wezkvlZeVVFvOc9D82qNJJ+rRiHWJ4bELgZ+iuZdMlQOckXisDYYidwN/8smOBPF4PG5ycnL0SfkQxONxg/tBIyVUaORLgqFIb9zhsUvQ8Fg26Q5MBkLBUOQe4IE0339t4caNGwd17tw5pmLTNPF43GzcuDEALExVmxo6EwCCoUgx8BvgO7h3pUt22wL8EbivvKxkm+0we5s9e3aXvLy8R3F72xrObZo4sLCurm7iyJEjN6SiQRWaLBcMRfrj3n9xHrpjX74qBtwP/KG8rGSz7TDiTyo0WSqxguw3uMuU1YORxlQCfwLuLi8rWW87jPiLCk2WCYYinYGbgR8DBZbjiP9UAY8Avy8vK0nJsIv4nwpNlgiGIi2Aq4EQ7smTIs2xDfcDy4PaRVoao0KT4YKhiMEdHvsd0NNyHMk884Ery8tKptkOIulLhSaDBUOR0cD/4m7NL+IVB/g7cL2G02RfVGgyUDAUaQ3cDlyJln5K6sRwh9Me0HCaNKRCk2GCocjpuJO1QctRJHstwB1Oe892EEkPKjQZIhiKtMO9s/ti21lEEv4O/KK8rGRdo8+UjKZCkwGCoci3gYdwtxERSScVwHXlZSWP2A4i9qjQ+Fjinpj/xb2rXySdPQ9cWl5WstV2EEk9FRqfCoYiP8Ddi6pTY88VSROrgAvLy0retR1EUkuFxmeCoUg34GHcs2FE/CYO3AbcUl5WUmc7jKSGCo2PBEORk4BngG62s4g00/vAD8rLSsptBxHv6R4LnwiGIj8H3kZFRjLD8cC8YCjyfdtBxHvq0aS5xM2Xj+Ke9S6SiaYAPykvK6m0HUS8oUKTxoKhSD/gBXSUsmS+FcD3y8tKZtkOIsmnobM0FQxFzgY+REVGskNfYFowFLnQdhBJPvVo0kwwFMkBbgVuRCdeSnYKl5eV3GI7hCSPCk0aCYYiHYEngTNtZxGx7O/AxPKykhrbQaT5VGjSRDAUORp3Pqa37SwiaWIq8F3tJuB/KjRpIBiKfAN4CWhjO4tImlkG/E95WckntoPIodNiAMuCoch3gQgqMiL7chQwIxiKHG87iBw6FRqLgqFIKfAsUGg7i0ga6wS8HQxFzrUdRA6NCo0lwVDkZ8BjQK7tLCI+0AL4RzAUudF2EGk6zdFYEAxFfgv82nYOEZ96GLisvKxEv7x8QoUmhYKhiMHd2v+ntrOI+NwjwCQVG3/Isx0gWwRDkTzcoTLd+SzSfJcCtcCVtoNI49SjSYFgKNICd3t/nSEjklz3lpeVXG07hByYCo3HErsvvwacajmKSKa6q7ys5Be2Q8j+adWZh4KhSD7wHCoyIl66PhiK/N52CNk/FRqPJCb+/wJ803YWkSzwy2Ao8hvbIWTfVGi8cyfwQ9shRLJIWPfZpCfN0XggGIpcC9xtO4dIlrquvKxksu0Q8gUVmiRLHNz0N3SWjIhNPysvK7nPdghxqdAkUTAUGQO8CuTbziKS5RzgvPKykmdtBxEVmqQJhiLHAP8BWtvOIiIAVAGnlpeVzLQdJNup0CRBMBTpD7wHdLadRUS+ZB0wqrysZJXtINlMq86aKRiKdAfeREVGJB11A14LhiI678kiFZpmSGwtEwGClqOIyP4NBZ4KhiL6fWeJ/sM3z/3ACNshRKRR3wK0e4AlmqM5RInTMR+3nUNEmuRcrURLPRWaQxAMRYYAM4BWtrOISJPsAI4rLytZaDtINlGhaaLEpOKHwADbWSR1nHg9a6dcTV5RR7qM+w2bXv8jNeuWA5DfvgcdS64mp6Dll19TX8fmN+6jZt3HOPF62gw5jcDx51K/M8bGF35PvLqSdif9kFb9jwdgw/O30uHMK8gr6pjy95dlVgDHlJeVbLMdJFtojqbpHkZFJutsn/UK+R177vm6wzcupcfF99Pj4vvJbduZ7XNe+8prdi57D6eulh6XPED3i+5l+7w3qIutZ8fiqbQZcRbdJtxDxayX3eeumEFB1z4qMqnRF3hSiwNSR/+hmyAYilwOfN92DkmtuopNVH3yIW2GnbnnezmF7qip4zg4dTXse8chg1O7Cydej1NXg8nNwxS0wuTm4dRW49TXYXJycOL1bJ/1Mm2PPSc1b0gAzgJusB0iW2jo7CAFQ5GjgelAoe0sklobX7yNtsefi1Ozk4qZL9JlnLsb/abIvVR9Mov8Tj3pMu435OS3+NLrnPo6Nr02mV2fzcepq6b9aZdSNPybxKt3sOmVu6jfuY12p1xE7aaV5BS2ok3x6TbeXjarwb2Zc77tIJlOPZqDEAxF2gHPoiKTdXaumElO63YUduv7lZ91Kvk5h185hfyOPdm55L9f+Xn12o8gJ4fDr/wbh036CxUfvkjttnXkFLamy/gw3UvvpaBbX6pWzKTVUSew+Z/3sfHF26hevSQVb02gAPhbMBQpsB0k06nQHJzHgD62Q0jqVa9eTNXyGXz+0MVsfOVOdn22gE2vfnEChMnJpfXAk9n50fSvvHbH4qm0PGIkJjeP3NbtKDxsIDVrl3/pObFpTxEYfS47Fk+l8PDBdCy5hm3vPen5+5I9hgK32A6R6VRoGhEMRX4OfMd2DrGj/SkXcfiVUzj88r/S+exf0KL3UDp+61pqt64B3DmaquUzyO9w+Fdem9e2M7s+WwBAvGYXNWuWkd/xi+fVbllN/fbNtOg1FKeuGowBQ2LOR1Lo+mAoMtp2iEymOZoDCIYifYEo0KKx50rm27VyARUzX6TzOb9m/RM3EK/eCTjkdzmCjmdeSU5hK3Yun0HNuuW0O+lC4jVVbH79Xmo3rQIcWhefTqDBhP/Gl8pod/IPye9wGPU7trHxhd8Rr95J4KQLaH3UCdbeZ5ZaAQwvLyvZYTtIJlKhOYBgKPJ/wGm2c4hISjxUXlZyhe0QmUiFZj+CochFuHMzIpI9xpSXlbxlO0SmUaHZh2Ao0glYCujuOZHsshoYol0DkkuLAfbtD6jIiGSjw4AHbIfINOrR7CUYipwBqOsskt3Gl5eVPGc7RKZQoWkgGIq0BBaie2ZEst1aoH95WUml7SCZQENnXxZGRUZEoDvaCy1p1KNJCIYiw4BZQJ7tLCKSFqqAo8rLSlbZDuJ36tEAie3CH0FFRkS+0BK43XaITKBC47oSOMZ2CBFJOz8IhiKjbIfwu6wvNMFQpC3u3IyIyN4M7u0O0gxZX2iAa4AOtkOISNoaHQxFzrMdws+yejFAMBTpAHwKtLWdRUTS2mfAgPKykl22g/hRtvdobkBFRkQa1xu42nYIv8raHk0wFOkGfAy0sp1FRHxhO9CvvKxkve0gfpPNPZpfoiIjIgevCLjVdgg/ysoeTTAU6QUsxz0zXETkYMWBQeVlJctsB/GTbO3R/BoVGRFpuhzgWtsh/CbrejSJ45mXoF0AROTQVAO9NVdz8LKxRxNGRUZEDl0hcJXtEH6SVT2aYCgyGFhAdhZYEUmerUAvHSNwcLLtF+7NZN97FpHkaw9cYjuEX2RNjyYYivTE3QUg13YWEckInwF9y8tK6mwHSXfZ9On+SlRkRCR5egPjbYfwg6woNIkjmifaziEiGed62wH8ICsKDXAB0NF2CBHJOCOCocjptkOku2wpND+1HUBEMpZ6NY3I+ELzzq9PHn1cziLdNyMiXjkzGIoMsx0inWV8oTk1d/5P/lHw+0ELCy9e/PO85/7bguoq25lEJONcaTtAOsvs5c3hQEdgNe6dvADEHbZ9EB80P1xX2usjp+cR9sKJSAbZBnQrLyupth0kHWV6j6aUBkUGIMfQbnTu4lPeLLghOKvwsrkX5v7rg1zqtQ5eRJqjHVBiO0S6yvRC8+P9/cAYTCdTMeJ3+Y8d91Fh6cb78++b2o0t2iRPRA7VBbYDpKvMHToLB04A3mvKSxyHupVOl1m31f2g8M34qBEeJRORzFSNO3y2zXaQdJPJPZrzmvoCY8jrnbPhuD8X3DtiWeGET8J5j79bxI6YF+FEJOMUop0C9ikzezThgAE+B3o091KOw86FzhFzbqmd0HGWc9TA5ocTkQw2tbys5FTbIdJNphaak4B3k33Z7U7LRX+u+9a2R+pLRlZT0CLZ1xcR33NwD0VbZTtIOsnUoTNPuq9FpmrwdfnPnrCk8Ec7/5Z/+9Q+Zs1nXrQjIr5l0KKAr8i8Hk04kAOsIgnDZo1xHJyNtJs9uW5c/Nn6U0fGydHu0CKyqLysZIjtEOkkEwuNJ8Nmjalzcla/Gj9++e21Pxi8gfadU92+iKSV4eVlJfNth0gXmTh0dq6NRvNM/LDv5k47dUbhle3eLrh2+jdyZusPmUj2utB2gHSSWT0ad9jsc6C77SgAu5z8Ff+v/ow199Z9b3glrdraziMiKbOqvKykl+0Q6SLTCs3JwFTbMfbmOFTOc/rODddO6Drf6dvfdh4RSYmB5WUlS22HSAeZNnT2bdsB9sUY2ozIWXHSy4U3959fODE6KffV6fnU1djOJSKe+obtAOki0wpN2p90FzA7i2/Mf2r0ssLSir/m3zm1t1n3ue1MIuKJtP99lCqZM3QWDnQG1uOuY/cNxyG+jvaz76o9jxfjJ450yMm04i+SrbYBncrLSuptB7Etk36pfR2fFRkAY8jpbrYec0/Bn475qLB0zV15f5rakdgm27lEpNnaASNth0gHmVRofD8emm/qDx+f9+4pswovb/uvguunn5wzP2o7k4g0i4bPyKxCc5rtAMliDAX9claP/lvBHcVLCi/66Ia8p/7bmqpK27lEpMl8/wE4GTJjjiYc6AVk9L5jjkPFLKf/vHBtaY9FzhF9becRkYNSDbQvLyupsh3Epkzp0WT8pwZjaHtMzkcnRwpv6ju38MfzL8795/Q86mpt5xKRAyoETrQdwrZMKTQZM2x2MNqbymE35/999LLC0m0P509+p6fZsMZ2JhHZr4z/INyYTCk0Wfk/Mtc4nc/MnX3quwU/7/pe4VUzx+ZMnwWZMBYqklGyfkGA/+dowoEjgRW2Y6SLGif3s+frTy6/s+684q207WA7j4gQBzqXl5VssR3Elkzo0RxtO0A6KTD1vb+f959T5hRe1uqfBTdMG52zcJHtTCJZLgcYZTuETZlQaIbbDpCOjKHFwJxVJzxZcNvgRYU/WnJN3jPvtaR6p+1cIlkqqw9CU6HJAq1N9cCr8l46cXHhj2r/UXDru0eZlZ/aziSSZYptB7BJhSaLGEPguJwlJ79ZGDpiduGkuRNy3/ogl/o627lEskBW92j8vRjA3Uhzg+0YflbvmHVvxEct/X3tBUetoVNaHBgnkoF2Aa3Ly0ritoPY4PcezQjbAfwu1zjdSnJnnDqt8KrO7xb8/IOzcmbM1RJpkaRrAWTtjh5+LzQaNksSY8jrlbPhuIcK/jhiWWFp+W/zHpvalsqY7VwiGSRr52lUaOQrCk3dERPy/nXK/MIf579W8Mv/HmOWLrGdSSQDqND4lAqNh4yh1ZCc8pOeLfztwIWFFy++KveF91pQndWbA4o0Q9YuCPDvYoBwoADYCeTajpJN4g5bp8WHLAjXlQY/dg7rbTuPiI98VF5WcpTtEDb4udD0BZbbjpGtHAdnE4G599SNq326/utfi5Ojgi9yYL4A1GsAAB7qSURBVPVAm/Kykl22g6San4fO9GnaImMwnU3s6Nvz/3LsR4UTNvwx/3+ndmWLlpqL7F8uMMh2CBv8XGh62Q4grjwT7/7t3PdP+aDwJ+3/U3DN+6fnzJpvO5NImsrKBQF5tgM0gwpNmjGG/CPMuuMfLbiHXU7+x0/Wf2P1PXXjhlfSqq3tbCJpIit/b/m5R6OhszTWwtQeeXHeGydHCyfmvlzwq/8ONyuW2c4kkga62g5gg58LTVZ+MvAbY2g9LOeTk14qvPmoBYUTo5fnvjytgNpq27lELOliO4ANKjSSMm3NzuIb8p8+YWnhRZWP5d/xTtCsXWU7k0iKZWWh8efy5nDA4N5D08J2FDl0jkN8Pe3nTK4b7zxXf/JIhxw/f/ARORhLystKsm7lmV//YndBRcb3jCGnm9n6tbvyHz5meeGENZPzH3qnE9s22s4l4qGsnKPxa4/mGGCm7RiSfI5DzcdOj1m/q7uwzTvx4UNt5xFJMgcoKC8ryapzoPzao+lgO4B4wxgK+uasGf14wZ1DlxRetPzGvCfebU3Vdtu5RJLEAJ1th0g1vxaaItsBxHstTU2/SXmRkxcWXsLzBb95t9h8oi2HJBNk3YIAFRpJe8ZQNDJn+cmvFv6q37zCSxdMzI1Mz6euxnYukUOUdfM0fi00bWwHEDvamR1Df5X/xOhlhaWxR/PvntrTbFhtO5NIE2Vdj8avW9CoR5PlcozT+fTcOad8I2dOfA0dZ95Ve17OS/ETRoIxtrOJNCLrCo1fezQqNAK4S6QPM5tH3Vvw4NeWF05YdUfew1PbU7HFdi6RA1Ch8QkVGvmKfFPf67y8d06ZU3hZqzcLfjHtxJzoQtuZRPYh64b+/Tp0lnX/o+TgGUOLo8znJ/y/gtvZ6RQue6z+mxseqPv20Ttp0dp2NhH8+3v3kKlHIxmtlak+6sq8l09aVHhx3dMFv5060Hz2se1MkvVUaHxChUaaxBgCx+YsPeWfhTceOadw0rzS3Dfez6Ou1nYuyUpZd+y5XwtNge0A4l8dzPbht+T/7fhlhaVb/pT/h3cOY+Na25kkq2Rdj8avbzir9gkSb+Qap+s3cz/sOibnw/rPnc4zyuq+nxeJH3u0lkiLx/z6e/eQ+fUNa8hDksYYcnuajcc+UHAff3Dyysvqvv/fv9aftc52LslY820HSDW/7t78CjDWdgzJWC8Sjn3PdgiRTOHXORoNnYmXRtsOIJJJ/FpoNHQmXupKOHCk7RAimUKFRmTf1KsRSRIVGpF9O8F2AJFM4ddCozka8Zp6NCJJ4tdCox6NeG0w4UDAdgiRTODXQlNtO4BkvBzgeNshRDKBXwvNZtsBJCto+EwkCfxaaDbYDiBZQQsCRJJAhUZk/0YRDmTdTrsiyebXQrPedgDJCm2AYbZDiPidXwuNejSSKpqnEWkmFRqRA9M8jUgz+bPQhGPbgSrbMSQrqNCINJM/C41LvRpJhZ6EA4fbDiHiZyo0Io1Tr0akGfxcaLTyTFJFCwJEmsHPhWal7QCSNdSjEWkGPxea5bYDSNYYRjjQ2nYIEb9SoRFpXB4wynYIEb/yc6H5yHYAySoaPhM5RH4uNJ+iA9AkdbQgQOQQGcdxbGc4dOHAMqC/7RiSFbYBHQjHPPsLUzyl+HeooIl3/hgtjb5so+E8G40m0SJUaCQ12gGDcP/MeaUW+LqH15fs9oythv08dAaw0HYAySpez9NM9/j6kt2sTTX4vdB4+elSZG9eF5oPgHqP25DspUJziFRoJJU8nT+Jlka3o166eMfahxi/F5plwC7bISRr9CUc6OJxG9M8vr5kL/VoDkk4VgvMsh1DsorXq8I0TyNeqbXVsL8LjUt/MSWVvJ6nUY9GvLLVVsOZUGj0F1NSydNCEy2NlgNrvGxDspa1o1UyodCoRyOpdDThQKHHbejPtHhho62G/V9owrFNaN8zSZ1C4Gset6FeuiSbgwpNs+kToKSSFgSI32yJlka1vLmZ9BdTUsnrBQFzgSqP25DsYq03A5lTaDTUIKl0vJcXj5ZGa4EPvWxDso61hQCQOYVmCRaX7knW6UI40M/jNvThSZJJhabZ3K3b37MdQ7KK7qcRP1GhSZKI7QCSVbxeEPA+7kohkWTQHE2SvGY7gGQVr2/c3AIs9bINySrq0SRFOLYamGM7hmSNgYQD7T1uQ6spJVlUaJLoVdsBJGsYPF59huZpJHnW2WxchUbk0OnGTfGLJTYbz7RCMwdtSCip4/U8zTJgk5dtSFZYFy2NbrYZILMKjbvMWYsCJFVGEQ7kedyGejXSXNZPIs6sQuPS8JmkSitguMdtqNBIc1k/HjwTC82/gZ22Q0jW0I2bku5UaJIuHNsFvGE7hmQNrxcEzAJqPG5DMpuGzjzyN9sBJGt4vSBgF7o/TJpHhcYjESzfoCRZ4zDCgd4et6HhMzlUq6Kl0QrbITKz0IRjdcATtmNI1tD9NJKurM/PQKYWGtdjtgNI1tCCAElXKjSeCseiaGxbUsPTHk20NLoe+MTLNiRjWZ+fgUwuNK6s6NXsqnMY9Uglw/5UyeAHK/nNf3Z96edX/XMXbW7b9zBtbb1D6UtVFD9UycAHKrn9v9UAbNwR58S/7mDIg5W8tLR2z/O//Y+drNke9+7N+NNQwoE2HrehXo0cCvVoUuBJsmBpaGEuvF3amvmXtWHepNa88XEdH3xeB8CsNfVs3bX/Y02eXVxHdZ1D9PI2zP5xa/48u4bybXGeWljLZV/LZ+alrbn3A/c/4avLahnRLYceRZn+x6bJcoFjPW5D8zTSVLtQoUmBcGwL8IrtGF4zxtCmwABQG4faendr4fq4w/X/2sWdpxfu/7XAjlqoiztU1ToU5BraFhrycww7a6G6DnJz3J/fO6OGX5yw/2tlOc3TSLqZHi2NVtsOAZleaFyP2w6QCvVxh+F/qqTLXds5o08exx6ex/0zazi7fx7dD9ADGTcoj9b50H1yJb3ureS60QV0aGn4QXE+Ly+r44y/7+CXJxby4Ic1/HBoPq3yTQrfla94XWgWATGP25DM8rbtALtlQ6F5A/jUdgiv5eYY5l3Whs+vKWLmmnre/ayOZxfX8dNjCw74upmr68nNgTXXtOHTn7Vh8vs1fLI1TqCFIfKDVsz6cRuO7p7Lqx/VMW5QPpe+UsW4Z3by/qq6FL0z3ziOcMCzv0/R0mgc+MCr60tGUqFJmXCsHviD7Rip0q6F4evBPP7zaT0rtsTpe18lwXu3s7MW+t63/SvPfzJayzePzCM/19CldQ4n9Mxl1pr6Lz3n1neruemkQp6K1nJir1ymfKcl4alp0SNPJ22BIR63oeEzOVjbgQ9th9gt8wuN6y+A1fMYvLRxR5xtiQn/qlqHf31Sx8geOay7rojyn7uPVvmw4qqir7y2VyCHt8vdwrKjxuGDz+sZ0OmLPxbLN9fzeUWcU4N57Kx1yDFgDFTVfuVSohs3JX28Gy2Nps2wQ3YUmnBsJ/Cg7RheWVvp8PUpOxj6UCXHPLKDM/rk8a3++ft9/ivLark5sQT6ylEFVNY4DH7Qfe2PhucztGvunufe9HY1vz/NXQDw/eJ8HppVyzGP7OBnjQzJZSmv52lmAPWNPkskjYbNAIzj7H/pa0YJB7oAnwEtbEeRjPUp4VgfLxsonlI8BxjhZRuSEUZES6PzbIfYLTt6NADh2AZgiu0YktGOIBzo5nEbmqeRxmwG5tsO0VD2FBrXZEC3tYuXdD+N2PZOtDSaVkNV2VVowrHlwMu2Y0hG04IAsS2t5mcg2wqN6y7bASSjeX0Q2krgcy/bEN9TobEuHHsfeNd2DMlYIwgHvF5wol6N7M+qaGl0qe0Qe8u+QuO60XYAyVgFwDEet6F5Gtmfp20H2JfsLDTh2HTgJdsxJGN5vSBAPRrZn6dsB9iX7Cw0rhvRzW/iDa8XBMwDdnjchvjP0mhpNC0Pe8zeQhOOLcXdmkYk2bw+cbMOmOllG+JLadmbgWwuNK4wsNN2CMk4HQkHjvK4DQ2fyd5UaNJSOLYWuMd2DMlIunFTUmlWtDS63HaI/cnuQuO6E9hoO4RkHK8LzftAWt39LValbW8GVGggHNsO3Go7hmQcr+dptgGLvWxDfCMO/MN2iAPJsx0gTfwJuAroazuIZIyjCAc6Eo55eQ7SNGCwh9dPuprNNax+ZDV1Fe5RKe1PbU+nMzsRmxljw0sbqF5bzZE3H0nLI1ru9xpO3OHj8Mfkt8+n99W9AVj1p1Xs+nwXRcOL6DbO3dd0wysbaHFYC9qObOv9G7NrarQ0usZ2iANRjwYgHKsFLrcdQzKKAY73uA3fLQgwuYZu53ej32396PPrPmz5vy3sWr2LwsML6fXTXrTq36rRa2x+azOFPQr3fL1r1S5yCnLo97t+VH1aRf3Oemq31VL1cVU2FBlI82EzUKH5Qjj2b+BvtmNIRtGCgL3kt8unZdDtreS2zKWwRyF1W+to0aMFhd0LG3k11G6pZfv87bQ/uf0X38yFeE0cJ+7g1DmQAxte2ECX73bx6m2kkxrgOdshGqNC82XXAJtsh5CM4fU8zQpgg5dteKlmYw27PttFyyP3P0y2t7VPrqXbed3c/mJCix4tyCvK4+PffEzb4W2pWV+D4zh7ClqGi0RLo1tth2iMCk1D7nj6NbZjSMY4hnBg/2dqJ4fvhs8A6nfVs/L+lXT7QTdyW+Y2/gKgYl4FeW3z9llAul/Qnb639qXTWZ3Y8MIGun6vKxte2cDKB1ay5Z0tyY6fTv5oO8DBUKHZWzj2d+At2zEkI7QEjva4Dd8VGqfOYdX9q2h3fDsCXwsc9Ot2Lt9JxdwKll27jM8f+pzKJZWs+vOqLz2nYk4FLYItiFfHqdlYQ68re1Exq4J4dUaedzg7WhqdajvEwdCqs327DFgIND4zKXJgo4EZHl7fV/M0juOw+q+rKexeSKdvdmrSa7uN70a38e6KssollWx+YzM9J/X84tp1Dpvf2kzvq3tTvb76i+/vnrtpfArIb3xzs7l6NPsSjn0K3GI7hmQErxcEzAaqG31Wmti5fCfbpm+jckklK369ghW/XsH2+dupmF3B0quXUvVxFeV/KKf87nIAarfWUn5P+UFde/P/babdCe3IKcyhRc8WODUOy3+1nJbBluS2PrjhOR/5HHjGdoiDZRxHNxfvUziQB3wIDLcdRXxtLeFYDy8bKJ5SPA3vd4yW9HJDtDR6p+0QB0s9mv0Jx+qAS4Ba21HE17oTDhzhcRu+Gj6TZqsEHrYdoilUaA4kHJuDTuOU5vO6t+G7BQHSLH9NbEHkGyo0jbsHeN12CPE1nbgpyRIH7rUdoqlUaBoTjjnARUBa7yUkac3TQhMtjW4AVnjZhqSNF6Ol0U9th2gqFZqDEY5tBC7E/TQh0lRDCAe83nRL8zTZwTdLmhtSoTlY4dh/gNtsxxBfygGO87gNFZrM90G0NOrLYVIVmqYJA+/ZDiG+pAUB0ly/sx3gUKnQNEU4Vg/8AMjozZPEE14vCFgMpP3minLI/hMtjUZshzhUKjRNFY6tAi62HUN851jCAc9uT4+WRh3gA6+uL1Y5wHW2QzSHCs2hCMdeRsc/S9MUAcUet6F5msz0ZLQ0Osd2iOZQoTl0vwFesB1CfEX300hT7QJ+aTtEc6nQHCr3/poJwHzbUcQ3vF4QMAOo87gNSa37oqXRlbZDNJcKTXOEYzuAs/HxKYeSUl7fuLkTmOdlG5JSm8mQWypUaJorHFuJW2yqbEeRtNebcMDTnZzR8FkmuTVaGo3ZDpEMKjTJEI7NQDsHyMHxep5GCwIywwrgQdshkkWFJlnCsReA623HkLSnQiMH48ZoaTRjjihRoUmmcOwe4AHbMSStebogIFoaXQ34fvI4y70fLY0+ZztEMqnQJN9VwN9sh5C0NYJwoJXHbWiexr/iwM9th0g2FZpkC8fiuDsHPG07iqSlPOAYj9vQ8Jl/TY6WRmfaDpFs1guNMabeGDPPGLPQGPOsMaZJn/aMMT2MMc8l/n24MeZ/GvzsbGNMKNmZG+XuiXYh8GLK2xY/0DyN7MtS4GbbIbxgvdAAVY7jDHccZwhQA1zWlBc7jrPGcZxxiS+HA//T4GevOI5TlryoTRCO1QHnA77dCE8843WhWYB7rrz4Rxz4UbQ0ust2EC+kQ6Fp6L9AX2NMB2PMS8aYBcaYD4wxQwGMMackej/zjDFzjTFFxphgojdUAPwWOC/x8/OMMRcZY+43xgSMMZ8ZY3IS12ltjFlljMk3xhxpjHnDGDPbGPNfY8yApL2bcKwGOAd4K2nXlExwPOGA8eri0dJoPe4uAeIfk6Ol0YzdFDVtCo0xJg84C4gCtwBzHccZirvPz+7J9euAKx3HGQ6cRIObJB3HqcHtdj6d6CE93eBnMdw7pk9JfOtbwJuO49QCDwM/dRxnZOL6yV27Ho5VA98B/pPU64qftQcGetyGFgT4R8YOme2WDoWmpTFmHjALd1nmX4ATgb8DOI7zNtDRGNMWd+z5HmPMVUA7x3Gasq/T08B5iX8/H3jaGNMGd7nps4kMfwa6J+E9fVk4VgWMRYemyRe83vdM8zT+UA9clKlDZrulQ6HZPUcz3HGcnyZ6JvuUmG+ZCLQEpjVxmOsV4JvGmA7ASOBt3Pe/rUH7wx3H8eaTprsv2v8A73hyffEbr+dp3kc7VfjBPdHSaMYPc6ZDodmX/wIXABhjTgU2OY5TYYw50nGcqOM4dwAfAnsXmu245358heM4lYnX/BF4zXGcesdxKoBPjTHjE20ZY8wwT94RQDi2Hfgm8KxnbYhfeH3jZgWwyMs2pNkyfshst3QtNGFgpDFmAVAGlCa+//PExP8CoBb4516v+w8waPdigH1c92ncZccN73G5ALjEGDMf9y/mt5P3NvbBnbM5H/hfT9uRdNefcKCzx21o+Cx9ZcWQ2W7GcRzbGbJXOBACbrcdQ6z5TuK0Vk8UTyn+IdqlIl3dFS2N/sJ2iFRJ1x5NdgjHyoCL0GFV2UoLArLTLODXtkOkkgqNbeHYFNwVaTtsR5GU8/ogtE+AdV62IU22GRgXLY1W2w6SSio06SAcewP4OrDRdhRJqZGEAwUet6H7adJHHLggWhr9zHaQVFOhSRfh2IfA8bg3rEp2aIG71N5LGj5LH7dGS6Nv2g5hgwpNOgnHPgaOA560HUVSxuv7adSjSQ9v4G6RlZVUaNJNOLaTcOwC3HNtMuaEPdkvrxcEzAGyYgltGvsEd8gsa2+gVaFJV+HY/+LO26y1HUU85fWNmzW4q5zEju3A2dHS6BbbQWxSoUln4dg04GjgXdtRxDNdCQeO9LgNzdPYsXvyP+t3aFChSXfh2DrgG8AfbEcRz2ieJjP9KloafdV2iHSgQuMH4Vgd4dg1uLtPx2zHkaTzep5GhSb1noqWRrXrR4IKjZ+EY88AQ9BBapnG6xs3NwHLvGxDvmQqcLHtEOlEhcZvwrHPCcfG4B55reN6M8NgwoGAx22oV5MaM4Gxydgs0xjjGGMmN/j6OmNMuLnX3Uc7v9zr66T/WVGh8atw7M/AUNxPT+JvBvdmXS9pQYD3osA3o6XR7Um6XjXwPWNMpyRdb3++VGgcx0n6UK4KjZ+FY5/iLoH+OQ2OtRZf0oIAf1sOnBEtjW5N4jXrcI+av3rvHxhjOhtjnjfGfJh4nNDg+/8yxiwyxjxqjPlsd6EyxrxkjJmd+NmPE98rI3HKsTHmicT3KhP//IcxpqRBm48bY8YZY3KNMXcl2l1gjJnU2BtRofG7cMwhHPsjMBz3VEXxJ68XBCwFsvpeDg+tBE6PlkbXe3DtB4ALjDF7D63+EfiD4zjHAOcAjya+/xvgbcdxBgPPAb0avOZix3FGAl8DrjLGdHQcJ8QXpxxfsFcbTwPnAhhjCnBXv0aAS4BYou1jgEuNMUcc6E2o0GSKcOwj4CTgetybxMRfjiUcyPXq4tHSqIM+iHhhHW6RWenFxROnAP8Nd6eQhk4H7jfGzMM9pr6tMaYNcCLwj8Rr3wAa9rCuShzw+AHQE+jXSPP/BL5ujCkEzgLedRynCjgTmJBoewbQsbFrqdBkknCsnnDsbqA/MAXQqXb+0Rrw7hhxl+ZpkmsLcGa0NLrc43buxe1FtG7wvRzguERPZLjjOIcljqvfJ2PMqbjF6XjHcYYBc3E3dd0vx3F2Ae8AY3Bvrdh9MrEBftqg7SMcxzngSlgVmkwUjq0jHLsId4J5puU0cvC8nqdRoUme7cBZ0dKo57utO46zBXgGt9js9hbw091fGGOGJ/51Gl8Md50JtE98PwBsdRxnpzFmAO7mvbvVGmPy99P808CPcEdL3kh8703g8t2vMcb0N8a03s/rARWazBaOzcD9A1WK9kzzA68LzYdoo9ZkqMJdwpzKD3GTgYarz64CvpaYjF+Me7sDwC3AmcaYhcB43KG97bhFIs8YswQowx0+2+1hYMHuxQB7eQs4Bfi34zg1ie89CiwG5iTa+TOQd6DwxnE0upIVwoEi4CbcFSxeH7Ylh2YV4Vivxp926IqnFM8ARnnZRobbCXwvXc+VScyn1DuOU2eMOR54yHGc4Y29zmvq0WSLcGw74VgIGAy8ZDuO7FNPwoGeHrehZc6HbhNwWroWmYRewIeJSf/7gEst5wFUaLJPOLaCcOy7wAjgRbRgIN14vcxZ8zSH5lPghGhpdIbtIAfiOM5yx3FGOI4zzHGcYxzH+dB2JlChyV7h2DzCse/h3n/zHCo46UILAtLPHOD4aGn0I9tB/EqFJtuFYwsIx8YDxbgrTLL2FMA04fUGm2uBci/byDD/Ak716GbMrKFCI65wbBHh2Pm4czhPAPWWE2WroYQDB1wqmgTq1Ryc/weUJHHvsqylQiNfFo4tJRy7EBiIO5mo829SKw841uM2tCCgcXcCE6KlUS0HTwIVGtm3cGw54djPgB64K1fmWE6UTbQgwJ44cFW0NHpDYtseSYID3mQjQji2E/cGrUcJB44FLsfdjuKA21dIs3i9ICCKexNfkcft+E018MNoafRZ20EyjW7YlKYLBzrgbktxGdDXcppMtA3oQDjm2V/O4inFbwFneHV9H/oEODdaGp1tO0gm0tCZNF04toVwbDLu5p3fAP6C+8tRkqMd7qIML2n47AsvAEeryHhHQ2dy6NxP3G8DbxMOXIG7y+v3gbP58k6z0nQnAAs9vL4WBEAN8ItoafSPtoNkOhUaSY5wrAZ4FXiVcKAlbtH5HjAW9xO6NM1o3M0KvfIB7hJ2z87ASXPlwHkp3hgza2mORrwVDuTjHjd9Nu4w2wC7gXzjY8IxT+e/iqcUz8P7M3DS0cvAj5J87LIcgAqNpFY40B04DbfonAb0thsorXUlHNvg1cWLpxQ/AFzh1fXTUC0QipZG77EdJNto6ExSKxxbi7vzgHv2RTjQB7fg7H50tZYt/YwCXvPw+tPJnkKzEneo7INGnylJpx6NpJdw4CjgaNwhneGJRzYUn53AbNy5kxnADMKxz71ssHhKcRB3V+JM9yIwMVoa3WI7SLZSoZH0Fw5044uiMxy3CPXHn8vztwFLgKUN/rkU+IRwLOX7yxVPKV6Nu/tDJloN/DRaGn3RdpBsp0Ij/uSubOt1gEdPoNBCskpgA7A+8c9yGhaVcCytdgEunlL8LDDOdo4kiwMPAjdFS6MVtsOI5mjEr8KxKmBZ4rGPnwcM0AW36HQC2iQeRQf4ZwvcCePGHjXAZr4oJl/8092yx0+mkVmFZgHw43Q/oCzbqNBIZnJvJl2feMj+ZcqNm1XALcDkaGm0znYY+TIVGpHsNhf3l3RL20Ga4S3g8mhp9BPbQWTfNEcjkuWKpxRPBU62neMQbACujpZGn7QdRA7Mj6t2RCS5/LbBZg1wPzBARcYfNHQmIn4pNHXAFOC30dLoStth5OCp0IjI+4ADGNtB9iMO/AMIR0ujy22HkabTHI2IUDyleDEw0HaOfXgRuDlaGvXyyATxmHo0IgLuMud0KjRvAL/SYWSZQYVGRMCdp7nEdghgKm6Bec92EEkeFRoRAbs3btbj7lJ9X7Q0+rbFHOIRzdGICADFU4o34m7XkyrrgUeBP0dLo6tS2K6kmHo0IrLbdNyTUL32Hu6ml89HS6M1KWhPLFOhEZHdvCw0lbiH3T0YLY0u8KgNSVMqNCKymxc3bi4BHgKmaMv+7KVCIyK7zcLd3qWgmdf5DPf+l+e1ekxAiwFEpIHiKcXvA8cdwkuXAi8AL+jeF9mbejQi0tA0Dr7QzOGL4rLEu0jidyo0ItLQdODa/fwsnvj57uLyWcpSia+p0IhIQw0XBDhAFPdu/XeBqdHS6EYrqcTXNEcjIl9SPKX4JmAB8F60NLrVdh7xPxUaERHxlE7YFBERT6nQiIiIp1RoRETEUyo0IiLiKRUaERHxlAqNiIh4SoVGREQ8pUIjIiKeUqERERFPqdCIiIinVGhERMRTKjQiIuIpFRoREfGUCo2IiHhKhUZERDylQiMiIp5SoREREU+p0IiIiKdUaERExFMqNCIi4ikVGhER8ZQKjYiIeEqFRkREPKVCIyIinvr/sUs6Ay2uAFAAAAAASUVORK5CYII=\n"},"metadata":{}}]},{"cell_type":"code","source":[],"metadata":{"id":"HAbCUjsHAuA5"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":["### Vader Senitment"],"metadata":{"id":"MIPM-lussnLg"}},{"cell_type":"code","source":["\n","analyzer = SentimentIntensityAnalyzer()\n","# function to calculate vader sentiment  \n","def vadersentimentanalysis(tweet):\n","    vs = analyzer.polarity_scores(tweet)\n","    return vs['compound']\n","\n","newdata['Vader Sentiment'] = newdata['Cleaned_tweets'].apply(vadersentimentanalysis)"],"metadata":{"id":"0nWzkBv7Aupx","executionInfo":{"status":"ok","timestamp":1667904824860,"user_tz":0,"elapsed":53182,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":18,"outputs":[]},{"cell_type":"code","source":["# function to analyse \n","def vader_analysis(compound):\n","    if compound >= 0.5:\n","        return 'Positive'\n","    elif compound <= -0.5 :\n","        return 'Negative'\n","    else:\n","        return 'Neutral'\n","    \n","newdata['Vader Analysis'] = newdata['Vader Sentiment'].apply(vader_analysis)\n","newdata"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":904},"id":"qu3RHdsQA2ad","outputId":"d0c1834a-c71a-44ce-d627-fd35af88dd99","executionInfo":{"status":"ok","timestamp":1667904829237,"user_tz":0,"elapsed":239,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":19,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                  author_id         username      author_location  \\\n","0        712000889427521537  community001500     Bristol, England   \n","1       1242068059088728065        dmm251144  South East, England   \n","2                 558636361          lochend   Cambridge, England   \n","3                  25550559     linda_whyman       United Kingdom   \n","4       1136757030822305792   Blueerryforest      London, England   \n","...                     ...              ...                  ...   \n","541723           3155243418        partyka_m  south east England    \n","541724  1418314766729289729       dree_kelly          Scotland uk   \n","541725            545512624       withthing2  South West, England   \n","541726            206900588  justalittlechat      London, England   \n","541727           2942221013     frogcrutches         South Wales.   \n","\n","                                                     text  \\\n","0       RT @StrikeMapUK: The Cost of Living Crisis is ...   \n","1       RT @0Calamity: This is not a #CostOfLivingCris...   \n","2       RT @geoffh33: Every non-Tory MP should have st...   \n","3       RT @hewitson10: Ian Blackford owned the show a...   \n","4       RT @snowy2007: Serious question for Scottish P...   \n","...                                                   ...   \n","541723  RT @SB_Sarah10: Do you honestly think #LizTrus...   \n","541724  RT @michaelbartrum: Every hour, 10 people die ...   \n","541725  Jesus! £170 billion excess profits over 2 yrs!...   \n","541726  RT @maxwellwoodger: Attended the Final @Conser...   \n","541727  #BorisJohnson plans to visit sites of his grea...   \n","\n","                       created_at tweet_location  retweets  replies   likes  \\\n","0       2022-03-30 23:56:24+00:00            NaN      48.0      0.0     0.0   \n","1       2022-03-30 23:56:01+00:00            NaN      44.0      0.0     0.0   \n","2       2022-03-30 23:50:10+00:00            NaN       4.0      0.0     0.0   \n","3       2022-03-30 23:48:39+00:00            NaN      58.0      0.0     0.0   \n","4       2022-03-30 23:46:14+00:00            NaN      34.0      0.0     0.0   \n","...                           ...            ...       ...      ...     ...   \n","541723  2022-09-01 00:38:56+00:00            NaN      55.0      0.0     0.0   \n","541724  2022-09-01 00:29:40+00:00            NaN       1.0      0.0     0.0   \n","541725  2022-09-01 00:28:15+00:00            NaN       0.0      0.0     0.0   \n","541726  2022-09-01 00:21:52+00:00            NaN       1.0      0.0     0.0   \n","541727  2022-09-01 00:02:29+00:00            NaN     502.0     20.0  1230.0   \n","\n","        quote_count                                     Cleaned_tweets  \\\n","0               0.0  cost living crisis political choice yet tory t...   \n","1               0.0  costoflivingcrisis stateimposedpoverty do quit...   \n","2               0.0  every non tory mp stand today call borisjohnso...   \n","3               0.0  ian blackford own show always tory care costof...   \n","4               0.0  serious question scottish power say energy gre...   \n","...             ...                                                ...   \n","541723          0.0    honestly think liztruss plan cost living crisis   \n","541724          0.0  every hour people die poverty uk rise costofli...   \n","541725          0.0  jesus billion excess profit yrs time take stre...   \n","541726          0.0  attend final leadership debate uk husting fell...   \n","541727         18.0     borisjohnson plan visit site great achievement   \n","\n","        Subjectivity  Polarity  Analysis  Vader Sentiment Vader Analysis  \n","0           0.300000 -0.125000  Negative          -0.5106       Negative  \n","1           0.625000  0.500000  Positive           0.3744        Neutral  \n","2           0.000000  0.000000   Neutral          -0.5423       Negative  \n","3           1.000000  0.600000  Positive           0.1280        Neutral  \n","4           0.483333 -0.266667  Negative           0.2023        Neutral  \n","...              ...       ...       ...              ...            ...  \n","541723      0.900000  0.600000  Positive          -0.2732        Neutral  \n","541724      0.666667 -0.700000  Negative          -0.8934       Negative  \n","541725      0.000000  0.000000   Neutral           0.4404        Neutral  \n","541726      1.000000  0.000000   Neutral           0.0000        Neutral  \n","541727      0.750000  0.800000  Positive           0.6249       Positive  \n","\n","[541512 rows x 16 columns]"],"text/html":["\n","  <div id=\"df-9fe486ea-0ee8-4414-9c04-906ad1420336\">\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>author_id</th>\n","      <th>username</th>\n","      <th>author_location</th>\n","      <th>text</th>\n","      <th>created_at</th>\n","      <th>tweet_location</th>\n","      <th>retweets</th>\n","      <th>replies</th>\n","      <th>likes</th>\n","      <th>quote_count</th>\n","      <th>Cleaned_tweets</th>\n","      <th>Subjectivity</th>\n","      <th>Polarity</th>\n","      <th>Analysis</th>\n","      <th>Vader Sentiment</th>\n","      <th>Vader Analysis</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>712000889427521537</td>\n","      <td>community001500</td>\n","      <td>Bristol, England</td>\n","      <td>RT @StrikeMapUK: The Cost of Living Crisis is ...</td>\n","      <td>2022-03-30 23:56:24+00:00</td>\n","      <td>NaN</td>\n","      <td>48.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>cost living crisis political choice yet tory t...</td>\n","      <td>0.300000</td>\n","      <td>-0.125000</td>\n","      <td>Negative</td>\n","      <td>-0.5106</td>\n","      <td>Negative</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1242068059088728065</td>\n","      <td>dmm251144</td>\n","      <td>South East, England</td>\n","      <td>RT @0Calamity: This is not a #CostOfLivingCris...</td>\n","      <td>2022-03-30 23:56:01+00:00</td>\n","      <td>NaN</td>\n","      <td>44.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>costoflivingcrisis stateimposedpoverty do quit...</td>\n","      <td>0.625000</td>\n","      <td>0.500000</td>\n","      <td>Positive</td>\n","      <td>0.3744</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>558636361</td>\n","      <td>lochend</td>\n","      <td>Cambridge, England</td>\n","      <td>RT @geoffh33: Every non-Tory MP should have st...</td>\n","      <td>2022-03-30 23:50:10+00:00</td>\n","      <td>NaN</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every non tory mp stand today call borisjohnso...</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>Neutral</td>\n","      <td>-0.5423</td>\n","      <td>Negative</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>25550559</td>\n","      <td>linda_whyman</td>\n","      <td>United Kingdom</td>\n","      <td>RT @hewitson10: Ian Blackford owned the show a...</td>\n","      <td>2022-03-30 23:48:39+00:00</td>\n","      <td>NaN</td>\n","      <td>58.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>ian blackford own show always tory care costof...</td>\n","      <td>1.000000</td>\n","      <td>0.600000</td>\n","      <td>Positive</td>\n","      <td>0.1280</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1136757030822305792</td>\n","      <td>Blueerryforest</td>\n","      <td>London, England</td>\n","      <td>RT @snowy2007: Serious question for Scottish P...</td>\n","      <td>2022-03-30 23:46:14+00:00</td>\n","      <td>NaN</td>\n","      <td>34.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>serious question scottish power say energy gre...</td>\n","      <td>0.483333</td>\n","      <td>-0.266667</td>\n","      <td>Negative</td>\n","      <td>0.2023</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>541723</th>\n","      <td>3155243418</td>\n","      <td>partyka_m</td>\n","      <td>south east England</td>\n","      <td>RT @SB_Sarah10: Do you honestly think #LizTrus...</td>\n","      <td>2022-09-01 00:38:56+00:00</td>\n","      <td>NaN</td>\n","      <td>55.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>honestly think liztruss plan cost living crisis</td>\n","      <td>0.900000</td>\n","      <td>0.600000</td>\n","      <td>Positive</td>\n","      <td>-0.2732</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>541724</th>\n","      <td>1418314766729289729</td>\n","      <td>dree_kelly</td>\n","      <td>Scotland uk</td>\n","      <td>RT @michaelbartrum: Every hour, 10 people die ...</td>\n","      <td>2022-09-01 00:29:40+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>every hour people die poverty uk rise costofli...</td>\n","      <td>0.666667</td>\n","      <td>-0.700000</td>\n","      <td>Negative</td>\n","      <td>-0.8934</td>\n","      <td>Negative</td>\n","    </tr>\n","    <tr>\n","      <th>541725</th>\n","      <td>545512624</td>\n","      <td>withthing2</td>\n","      <td>South West, England</td>\n","      <td>Jesus! £170 billion excess profits over 2 yrs!...</td>\n","      <td>2022-09-01 00:28:15+00:00</td>\n","      <td>NaN</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>jesus billion excess profit yrs time take stre...</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>Neutral</td>\n","      <td>0.4404</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>541726</th>\n","      <td>206900588</td>\n","      <td>justalittlechat</td>\n","      <td>London, England</td>\n","      <td>RT @maxwellwoodger: Attended the Final @Conser...</td>\n","      <td>2022-09-01 00:21:52+00:00</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>attend final leadership debate uk husting fell...</td>\n","      <td>1.000000</td>\n","      <td>0.000000</td>\n","      <td>Neutral</td>\n","      <td>0.0000</td>\n","      <td>Neutral</td>\n","    </tr>\n","    <tr>\n","      <th>541727</th>\n","      <td>2942221013</td>\n","      <td>frogcrutches</td>\n","      <td>South Wales.</td>\n","      <td>#BorisJohnson plans to visit sites of his grea...</td>\n","      <td>2022-09-01 00:02:29+00:00</td>\n","      <td>NaN</td>\n","      <td>502.0</td>\n","      <td>20.0</td>\n","      <td>1230.0</td>\n","      <td>18.0</td>\n","      <td>borisjohnson plan visit site great achievement</td>\n","      <td>0.750000</td>\n","      <td>0.800000</td>\n","      <td>Positive</td>\n","      <td>0.6249</td>\n","      <td>Positive</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>541512 rows × 16 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9fe486ea-0ee8-4414-9c04-906ad1420336')\"\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-9fe486ea-0ee8-4414-9c04-906ad1420336 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-9fe486ea-0ee8-4414-9c04-906ad1420336');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":19}]},{"cell_type":"code","source":["vader_counts = newdata['Vader Analysis'].value_counts()\n","vader_counts"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"pNpVrJukA9xl","outputId":"47611354-017d-44fd-db52-ce7f2d4ec021","executionInfo":{"status":"ok","timestamp":1667904841615,"user_tz":0,"elapsed":246,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":20,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Neutral     367550\n","Positive     93444\n","Negative     80518\n","Name: Vader Analysis, dtype: int64"]},"metadata":{},"execution_count":20}]},{"cell_type":"code","source":["vader_counts= newdata['Vader Analysis'].value_counts()\n","plt.figure(figsize=(10, 7))\n","plt.pie(vader_counts.values, labels = vader_counts.index, explode = (0, 0, 0.25), autopct='%1.1f%%', shadow=False)\n","plt.savefig('VaderSent.jpg')\n","plt.legend()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":429},"id":"zPMJGBaQBAnT","outputId":"b9aa371d-fd8e-4e57-fed8-dccec041b4aa","executionInfo":{"status":"ok","timestamp":1667904850577,"user_tz":0,"elapsed":269,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":21,"outputs":[{"output_type":"execute_result","data":{"text/plain":["<matplotlib.legend.Legend at 0x7fb16ac9cb50>"]},"metadata":{},"execution_count":21},{"output_type":"display_data","data":{"text/plain":["<Figure size 720x504 with 1 Axes>"],"image/png":"iVBORw0KGgoAAAANSUhEUgAAAbEAAAGKCAYAAACCbX/fAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deXhU1eHG8e/JQtjCCLKJoCOyQwBFwbrU/qxL2xGtFRTrMq1isbbVti4da9VxH9daWjdcqXWBtlYtY621WqtYFxTwAqKgjqLsWyAQst7fH3dA9iTkTs7cmffzPHmQycyZNwh5c+899xzjui4iIiJBVGA7gIiIyJ5SiYmISGCpxEREJLBUYiIiElgqMRERCSyVmIiIBJZKTEREAkslJiIigaUSExGRwFKJiYhIYKnEREQksFRiIiISWCoxEREJLJWYiIgElkpMREQCSyUmIiKBpRITEZHAUomJiEhgqcRERCSwVGIiIhJYKjEREQkslZiIiASWSkxERAJLJSYiIoGlEhMRkcBSiYmISGCpxEREJLBUYiIiElgqMRERCSyVmIiIBJZKTEREAkslJiIigaUSExGRwFKJiYhIYKnEREQksFRiIiISWCoxEREJLJWYiIgElkpMREQCSyUmIiKBpRITEZHAUomJiEhgqcRERCSwimwHEMmkcCzZCegO7JP+tSPQDmi71UcJUJz+KEr/ClAJbNzuY/vH1gFLgC+BlalExG2Jr0tEPMZ19W9OgikcS7YHBqY/DmDbstoH6IZXUC2lGliMV2jbf3wOzEslImtbMI9IzlOJSdYLx5J7AYO2+hiY/rUXYCxG2xNfAHPSH07613mpRGST1VQiAaUSk6wSjiVbAyOBI9IfB+MdVeWyOuBjvEKbBbwOvJlKRCqtphIJAJWYWBWOJTvjldWR6Y+DgVZWQ2WHamAG8N/0x+upRGS93Ugi2UclJi0qHEt2AL4NHIdXWv3tJgqMOmA2XqG9CryaSkTW2I0kYp9KTDIuHEuGgZPSH1/nq9l/sudq8QrtGeCZVCKyyHIeEStUYg0wxrjAna7rXpL+/aVAe9d143sw1l7A913XvWcPXpsCDnFdd2VTX9vSwrGkwbuutbm4hthNlBfeBf6GV2hzbYcRaSkqsQYYYzbh3Qd0qOu6K5tZYmFgmuu6O3xTN8YUua5bu5vXpsjyEgvHkkcBZwOj8aa5ix0L8I7Q/oY3QUT/yCVnqcQaYIypAG7EK64rty4xY0wX4D5gv/TTf+667nRjTByocF339vQYc4ATgQRwMvAh8C8gCVwPrAEGuK7bzxjzDN7U8dbA71zXnZQeI0UWllg4luwJRIEfAH3sppGd+Bh4GHgklYgssR1GxG8qsQakS6wH8D4wDDifr0rsCeAe13VfN8bsB/zTdd2Buykx2OpIzBjzDbwiG+K67qfpxzq5rrvaGNMGeAc42nXdVdlUYulp8N8Ffggci5YvC4I64HngISCZSkR2edQvEiRadqoRXNddZ4z5I3AR3rJDmx0LDDJmy/22HYwx7Zs4/NubCyztImPMKen/7gX0BVbtQWzfhWPJkXjFNQ7Yy3IcaZpCvNO8o4Gl4VhyMvBgKhFZaDeWSPOoxBrvLuA94JGtHisADnNdd5vVFowxtWx7dNJ6N+Nu2Op138Arxq+5rrvRGPOfBl6bceFYshAYC1wKjLCZRXzTHfgV8KtwLPkq3inxP6cSkTq7sUSaTqeBGsl13dXAVOC8rR5+EfjZ5t8YY4an/zOFd9MuxpiD8db1A1gPlO7mbULAmnSBDQAO8yX8HgjHku3CseRFwELgSVRguepovP+/C8Kx5IXpU8UigaESa5o7gM5b/f4i4BBjzPvGmHnABenH/wp0MsbMBX4KfATguu4qYLoxZo4x5radjP8CUGSM+QBvEsibGfo6dikcS3YLx5I3AouA3wHhls4gVhwA3A18Fo4lr0yvVymS9TSxQwAIx5ID8E4ZnkXLrvwu2Wk9cD9wp2Y1SjZTieW5cCzZH+8Wgu8RvBXhJfOqgMeAW1OJyALbYUS2pxLLU+FYsgcQB87Fm7kmsjt1eJOarkklIotthxHZTCWWZ8KxZAhvZtrFeLsaizRFJd610lu0wadkA5VYngjHkiXAT4BfA3tbjiPBtxq4AfhDKhGpsR1G8pdKLMeFY8kCvMka1wH7W44juWcBcFkqEXnWdhDJTyqxHBaOJQ8B7gUOsZ1Fct7LwC9Sicj7toNIflGJ5aD0da8bgR+jewGl5dQCtwPXphKRTQ09WcQPKrEcE44lxwG/RVuhiD0LgPNTicirtoNI7lOJ5YhwLNkLbw2879jOIgK4wAPA5alEpNx2GMldKrGAS++ifCFwM7tfl1HEhsXAT1KJyDO2g0huUokFWDiW7A1MBo60nUWkAX8BfppKRJbZDiK5RRf9AyocS34fmIkKTIJhDPBBOJY8zXYQyS06EguYcCzZHvgDELWdRWQPTQIu1gxG8YNKLEDCseTBeHs/9bOdRaSZ3gdOTyUi820HkWBTiQVAevLGL/Amb7SyHEfELxuAC1OJyB9tB5HgUolluXAs2RV4FPi25SgimfJHvDLbYDuIBI9KLIuFY8mvA1PQjcuS++bjnV7UslXSJJqdmKXCseR5wEuowCQ/DADeCseS59gOIsGiI7Esk151/na8a2Ai+egm4DepRETfnKRBKrEsEo4lO+DNPtTSUZLv/gyco2n40hCVWJZIr77xd2CQ7SwiWeIt4GSt8iG7o2tiWSA9geMtVGAiWxuFd51siO0gkr1UYpaFY8lz8SZwdLadRSQL7Q9MD8eSJ9gOItlJJWZROJb8NfAQUGw7i0gW6wAkw7HkhbaDSPZRiVkSjiVvwtt9WUQaVgjcHY4lr7IdRLKLJna0sPQSUncBF9nOIhJQN6YSkd/YDiHZQSXWgtL3gE0CzrOdRSTgbk8lIpfZDiH2qcRaSDiWLAIeA8bZziKSI36Pt6WLvonlMZVYCwjHkiXAVOAk21lEcswk4AIVWf5SiWVYOJZsC/wNON52FpEc9ShwXioRqbcdRFqeSiyDwrFkMd4qHLrHRSSznsBbpqrOdhBpWZpinyHpWYiTUYGJtITv451alDyjEsucicAZtkOI5JFzw7Gk7r3MMyqxDAjHklcDP7WdQyQP/TocS+rfXh7RNTGfhWPJHwP32M4hksfq8XaJ/ovtIJJ5KjEfhWPJ0/EuMOsIV8SuKuBbqUTkP7aDSGapxHwSjiWPA6YBrWxnEREAyoGvpxKR920HkcxRifkgHEsOB14H2tnOIiLbWAJ8LZWIfGY7iGSGSqyZwrFkZ2AG3r5HIpJ9PgQOSyUia20HEf/p2k0zhGPJQmAKKjCRbNYfeCx976bkGJVY89wOHGM7hIg06ERAe5HlIJ1O3EPhWPIsvFXpRSQY6oHRqUTkedtBxD8qsT0QjiVH4E3kaG07i4g0yRrgkFQi8ontIOIPlVgThWPJLsC7QC/bWURkj7yPN2Nxo+0g0ny6JtYE6Y0t/4wKTCTIhqLFgnOGSqxpbgKOth1CRJrtzHAseZHtENJ8Op3YSOFY8hvAv1Hxi+SKGrwVPd60HUT2nEqsEcKxZAjvPPp+trOIiK8WAMN1fSy4dFTROHejAhPJRX2BW22HkD2nI7EGpFemf8p2DhHJGBc4PpWIvGQ7iDSdSmw3wrHkvoADdLSdRUQy6gtgSCoRKbcdRJpGpxN3Ib3O2qOowETyQU9gou0Q0nQqsV27CDjWdggRaTHnhGPJ79oOIU2j04k7EY4lBwAz0bJSIvlmBTA4lYissB1EGkdHYjt3DyowkXzUBbjfdghpPB2JbSccS54BPGE7Rzao31TBqn9MpHrl5wB0/s7FrJvxHDWrv0h/fgMFrdvR44e/3+G162Y8S8Xsf4IL7YedQIdDTwZgzX8eofKTd2nV9QA6n3gJABVzX6F+47otzxHJAqekEpFnbIeQhhXZDpBNwrFkKd4eYQKs/vckWvceQZdTfo1bV4NbU0WXk3/11edffpCCknY7vK56RYqK2f+k+zl3YgqLWT71atr0OZTCtiGql35Mj3P/4JXjihRFe+3DBudfdB17XUt+aSIN+V04lnxRN0FnP51O3Na1QA/bIbJBfdUGNi2aS/uhxwNgCospaN1+y+dd12Xj/NdpN/DrO7y2ZtUXtNqnPwXFrTEFhZT0GsLGj94ADG59La7rUl9ThSkoZN3bT1N68GhMoX6ekqyyH/Ab2yGkYSqxtHAsOQT4me0c2aJ27TIK23Zg1fN3sfiRi1j1j4nUV2/a8vmqL+ZS2G4vijvtu8NrW3Xen6ov5lJXuY76mk1UfjKDunUrKShpS5sDD2HJoxdR2L4jpqQd1Us+om2/r7XklybSWJeEY8n+tkPI7unH36/cg/48tnDr66he+jGdjr2Akh79Wf3S/ax788/s9fWzAdgw79WdHoUBFHfuRYdRY1g+5SpMcWtade0Nxvt5KTRqDKFRYwBY9Y+JhI48k/Wz/8mmT2dS3DXMXoePa5kvUKRhrfDuHTvBdhDZNR2JAeFY8mzgKNs5sklRaWcKSztT0sP7QbRt/yOoXvYx4BXcxo/+R9sBOy8xgNJhx7PPD35H9zNvoaB1+x2O2KqXfYzruhR36snG+a/T5bsxatcspWb1l5n7okSa7vhwLHmi7RCya3lfYukV6m+znSPbFLbvSFGHztSs8mYibvpsNsWdvTWQN6VmUbx3T4o6dN7l6+s2rAWgdt1yNn70P9oN2nYbtrWv/Ym9jjoL6mvBrfceNAa3tioDX41Is9wZjiWLbYeQndPpM7gK6GY7RDbqdOwFrJx2O25dLUV7dWfv7/wcgA0f/HeHU4m161ex6oWJdBt7LQArnrmJ+sr1UFBIp+Mu2GZSyMaP/ker7n0oKt0bgFZde7P4oZ9Q3DXsnXoUyS598VbwucN2ENlRXt8nFo4le+HtJ1RiO4uIZLVyoE8qEVlpO4hsK99PJ8ZRgYlIw0LAZbZDyI7y9kgsvT7iHKDQdhYRCYQNwAFaVzG75POR2A2owESk8dqho7Gsk5dHYuFYcjjwHmBsZxGRQNmIdzS23HYQ8eTrkdg1qMBEpOnaApfbDiFfybsjMR2FiUgzbQR6pxKRZbaDSH4eicVRgYnIntPRWBbJqyOxcCxZBrxvO4eIBF4l3tHYUttB8l2+HYldbDuAiOSENuhoLCvkzZFYOJbsDCwCWtvOIiI5YT2wbyoRWW87SD7LpyOxH6ECExH/lALn2A6R7/KixNIrUF9oO4eI5Jyf2A6Q7/KixIAxwI5bEIuINM/AcCx5rO0Q+SxfSkwTOkQkU35qO0A+y/mJHeFYchTwpu0cIpKz6oADU4nIZ7aD5KN8OBLTUZiIZFIh8GPbIfJVTh+JhWPJfYDPAG0tLiKZtBLolUpENtkOkm9y/Ujs+6jARCTzOgPjbIfIR7leYmfZDiAieeNc2wHyUc6eTgzHkoOAubZziEjecIH9U4nIIttB8kkuH4mdaTuAiOQVA5xuO0S+yckSC8eSBu96mIhIS9J1sRaWkyUGHAGEbYcQkbwzIhxL9rUdIp/kaonpVKKI2KKjsRaUcyWWXux3rO0cIpK3zrAdIJ/kXIkB3wL2th1CRPLWwHAsOdR2iHyRiyWmozARsU1HYy0kp0osPSvxW7ZziEje01T7FpJTJQaMALrYDiEiee+AcCzZ33aIfJBrJfZt2wFERNKOtx0gH+RaielUoohkC5VYC8iZtRPDsWRHYAXe3j4iIrZVAJ1SiUiN7SC5LJeOxI5DBSYi2aM9cLjtELkul0pM18NEJNvolGKG5USJpafWn2A7h4jIdlRiGZYTJQYMBfaxHUJEZDsHh2NJrSCUQblSYkfbDiAishMFwLG2Q+SyXCmxUbYDiIjswjG2A+SyXCmxkbYDiIjswqG2A+SywN8nFo4lOwGrbOcQEdmFGqA0lYhU2Q6Si3LhSExHYSKSzYqBYbZD5KpcKDFdDxORbDfCdoBclQslpiMxEcl2h9gOkKtUYiIimacSy5BAT+wIx5K9gY9t5xARaUAt0CGViFTaDpJrgn4kpqMwEQmCImC47RC5KOglNth2ABGRRtIpxQwIeon1tR1ARKSRNM0+A1RiIiIt40DbAXJR0Eusj+0AIiKN1Nt2gFwU2NmJ4ViyK7DMdg4RkUaqB9qkEpFq20FySZCPxHQqUUSCpAAI2w6Ra1RiIiItR9fFfKYSExFpObou5jOVmIhIy9GRmM+CXGKamSgiQaMjMZ8FucR62A4gItJEOhLzWZBLbG/bAUREmmg/2wFyTSBLLBxL7oW3oKaISJCUhmPJQtshckkgSwwdhYlIMBmgo+0QuSSoJdbZdgARkT2kEvORSkxEpGWpxHwU1BLT6UQRCSqVmI+CWmI6EhORoFKJ+UglJiLSslRiPgpqiel0oogElUrMR0EtsXa2A4iI7CGVmI+CWmJBzS0iErIdIJcEtQx0x7uIBJVWG/JRUEssqLlFRPRDuI+CWgb6SyAiQaXvXz4KaokFNbeIiErMR0E9N6u/BJIx/c2if3/o9nrPdg7JWbNtB8glKjGRrZSyofwfrX41rMBwOfFyFZlIlgvqabmg5pYsd13xozMLDJ2BKcRDpbbziMjuBbUMdCQmvmvLpg0nF7xRlv5tH+A+m3lEpGFBLbFa2wEk91xR9MSMAuNuvaTZ94mHzrMWSEQaFNQS22A7gOSWVtRUfb/w3/138qmJxEODWjyQiDRKUEuswnYAyS2/KPrLW4XG7b6TT7UFphIPtWnpTCLSMJWY5L1C6mrHFz5/wG6eMhj4XUvlEZHGC2qJ6XSi+GZC4bS3ik1drwaedj7x0LgWCSQijRbUEltnO4DkCte9uOjpnZ1G3JlJxEMHZjSOiDRJUEtsje0AkhvOLvzXWyWmprHFVIp3/1irTGYSkcYLaomtth1AckOs6Mmm7u00ArglE1lEpOmCWmI6EpNmO7lg+ox2pmrgHrz058RDo30PJCJNphKTvHVt8aPNOS34KPFQQ5NBRCTDglpiy20HkGA7puC92XuZDUObMUQn4AniIS2BJmJRUEvsS6DOdggJrkTxA34sXXYkcK0P44jIHgpkiaUSkRpgse0cEkwjzQfzupryET4NdwXx0Dd9GktEmiio+4kBpABdk5Amu6P43vU+DlcA/Il4aDjx8mU+jkvZ5LK+QHNOeYrszudO1HnHdojmCnqJHWU7hARLmflkQU+zcqTPw3YHHiMeOoF4uevjuKuA36If1iQzHgPOsR2iuQJ5OjEtZTuABM+dxfcsNwaTgaGPA2J+DuhEndXA99H1X8mMetsB/KASk7zR2yz+rI9ZfFgG3+I64qHD/RzQiTqvA9f4OaZIWk78cKQSk7xxV/HdnxuT0V3Bi4AniYc6+jzuzcBLPo8poiMxy1K2A0hw7MuKJWXm01Et8Fb7AY/4OaATdeqBswBfJ45I3ttkO4Afglxii8iRw2HJvDta3feRMbTUwr0nEw9d5OeATtRZBpwN+DlxRPJbue0AfghsiaXvFfvcdg7Jfp1Zu2KU+cDvGYkNuY146GA/B3Sizr+AhJ9jSl5TiWWBWbYDSPa7pfiBucbQpoXfthXeti2lPo97NTDd5zElP6nEssBM2wEku3WgovyYgpm+HhE1QR/gfj8HdKJOLXAG2o5Imk8llgVUYrJbNxQ/MtMYOliMcAbx0Hl+DuhEnUXAuX6OKXlJJZYF3rMdQLJXWzZtOLHgzWxYtmki8dAgPwd0os6zwEQ/x5S8oxKzLZWILEbbssgu/Lro8RkFxu1kOwfQFphKPOT3dbnLgHd9HlPyh0osS+iUouygFTVVZxS+PMB2jq0MxucjJyfqVAPjAD8XNJb8oRLLEjqlKDv4ZdGf3yo0bjfbObYznnhonJ8DOlFnITDBzzElL7jACtsh/JALJaYjMdlGIXW15xX+o7ftHLswiXjoQD8HdKLOk8BDfo4pOW9Z+kg+8FRiknMuKPz7m8WmrqftHLtQinf/mN+rh1wEzPV5TMldObNQRC6U2MfonhlJM9TXX1T0dA/bORowArjFzwGdqLMROB2o9HNcyVkqsWyRSkRc4BXbOSQ7nF34r7dKTG22nkrc2s+Jh0b7OaATdebiHZGJNEQllmX+bTuAZIdY0VPZMKW+sR4lHvJ112Yn6jwIPOXnmJKTVGJZRnstCacUvPZOW1PV33aOJugEPEE85PceZz8CFvo8puQWlVg2SSUiC/C2ZpE8Fi+e3Np2hj1wJHCtnwM6UWc93v1jOTH7TDJCJZaFdEoxjx1XMGNWyGwss51jD11BPHSsnwM6Uedd4HI/x5Sc8pntAH7JpRLTKcU8dnPxg0Hear0A+BPxkK83ZztR53fAc36OKTlhlRN1VtoO4ZdcKrGXbQcQOw4rmDu3s1lna7sVv3QDHiMeMj6P+0N0ql225dgO4KecKbFUIrIEmGc7h7S8O4rv22A7g0+OA2J+DuhEndV4+4/V+jmuBJpKLIvplGKeGWo+XtCDVYfazuGj64iHDvdzQCfqTAeu8XNMCbT3bQfwU66VWNJ2AGlZdxbfs8IY/D4FZ1MR8CTxkN/3uyXQD3ni0ZFYFnsZWGU7hLSMA82Xnx1oloyynSMD9gMe9nNAJ+rUA2cBy/wcVwLHBebYDuGnnCqxVCJSC/zNdg5pGXcV3/25Mfh9o3C2OJl4yNclpJyoswyvyII8k1Oa5xMn6uTKNWQgx0osbartAJJ5Pc2KxUNM6jDbOTLsNuIhX2ddOlHnJbxTi5KfcupUIuRmib0C5Mw9ELJzdxTfu8AYim3nyLBWeNu2lPo87tXAdJ/HlGDIqUkdkIMlplOKua8za1eMNPNH2s7RQvoA9/s5oBN16vCm3WsLo/yTcz+85FyJpemUYg67tXjSXGNoYztHCzqDeOg8Pwd0os4ivBuhJX/UAf+zHcJvuVpirwArbIcQ/4WoWPt/BbNG2M5hwUTioUF+DuhEneeA3/k5pmS1WenFoXNKTpZYKhGpA562nUP8d0Pxw7OMwe9rREHQFphKPOT3EejlwLs+jynZ6TXbATIhJ0ssbYrtAOKvdlRWRAreHGY7h0WDgYl+DuhEnWq8bVty7id02YFKLGD+gzYGzCm/KfrTuwWGjrZzWDaeeGicnwM6UWch3kaakttetx0gE4zrurYzZEw4lrwUuM12Dmm+Eqo3zSv54bpC43a1nSULrAcOIl7+sZ+Dlk0uewAY7+eYfvnioS9YP2s9RR2K6Htj320+t/IfK1k6ZSkDfj+AotKiHV67dOpS1s/2DjS7ntSV0KgQAIvuW8SmLzZROryU7mO6A7D8ueW03rc1HUZ0yPBX1OI+dKLOANshMiGXj8QAHgE22Q4hzXdJ0dS3VWBblOLdP9bK53EvAub6PKYvOh7ZkfAl4R0er15VTcXcCor33vktg+tnrafys0r6XNeHA68+kJUvrKSuso5NizZR0KqAvjf0pfLTSuo21lGztobKjytzscAgR08lQo6XWCoRWYWm2wdeIXW15xa+0Nt2jiwzArjVzwGdqFMJnA5U+jmuH9r1b0dhux1XGFv65FK6nbbrvUQ3Ld5Eu37tMIWGgpICSnqWUOFUQCHUV9fj1ru4tS4UwPKnl9P1lJz9OekV2wEyJadLLO1e2wGkeX5S+OybRaa+p+0cWehi4qGT/BzQiTpz8Y7Ist6699ZR3LGYNvvtesJm6/1aU+FUUF9VT+36WjbM30DNqhpa92hNUWkRH1/zMR2Gd6B6WTWu69ImnJO3H9YC/7AdIlNyvsRSicibwCzbOWTPGOrrf1r0zL62c2SxR4iHevk5oBN1HgSe9HNMv9VX1bNi2ooGj5xKh5TSfmh7PrnhExbdt4i2B7bd8l1vnzP3oc/1fej87c4sf3o53b7XjeXPLefzuz9n9X9yajGT6U7UWWM7RKbkfIml6WgsoKKFL77VytQeYDtHFusEPEE85Pdq/hPI4tm91curqV5RzcKrFvLhJR9Ss6aGj6/5mJq1NTs8t+tJXelzfR8OuMz7a1TSvWSbz697bx2tw62pr6qnekU1+/1kP9bNWEd9Vc4s9v932wEyKV9K7HFgne0Q0nSXF03xe3PIXHQkcJ2fA6ZXdhgHVPs5rl9a92rNwN8PpP8d/el/R3+KOxZz4LUHUrzXthM83HqX2opaADYt2sSmRZtoP6T9V5+vdVn14iq6fKcL9dX127zOrc2ZmdsqsaBLJSIbgMds55CmObXgv++0NVX9becIiBjx0LF+DuhEnXfxVvSwbtG9i/jkhk+oWlrF/F/MZ/Wruz7dV/lpJV8+/CXgldSnN33Kgl8v4MtHvqTnj3piCr/aCHzVv1ex1xF7UVBSQOterXGrXRb8ZgFtwm12OpEkgD5yos5HtkNkUk7fJ7a1cCzZB5gPObuJYs55v2S808FsLLOdI0CWAcOIl/u6e3PZ5LJngJP9HFNazB1O1LnUdohMyosjMYBUIrIQeMp2Dmmc4wvemakCa7JuwGPEQ6bBZzbNucAin8eUljHNdoBMy5sSS7sBbc0eCDcVP5Qfpwj8dxwQ83NAJ+qsxtt/rNbPcSXj1pCjS01tLa9KLJWIzAf+bDuH7N7hBXPmdjbrDradI8CuIx46ws8BnagzHbjGzzEl4/7sRJ2c/8Ejr0os7QZAP+VnsduK799gO0PAFQFPEg/5PbMzAfzL5zElc/5oO0BLyLsSSyUic4C/2c4hOzfMLPyoB6sOtZ0jB/QCHvZzQCfq1ANn400gkez2SfroOeflXYmlXYeOxrLSb4vvXWkMfk9MyFcnEw/5uoSUE3WWAWeha8vZLm9uKcrLEkslIrPJ8RsAg6ifWfTpAWbJYbZz5JjbiIdG+DmgE3Vewju1KNlLJZYHfF3hQJrvt8X3fGlMXv+dzIRWwFPEQ6U+j3s1eTDzLaDecKKOr3vNZbO8/YaRSkTeBZ62nUM8vczyLweZz0bZzpGj+gD3+zmgE3XqgO8DObVSbo7Im6MwyOMSS7sUqLIdQuDO4ns+Noad72wofjiDeOg8Pwd0os4i4Ad+jinNVgVMsR2iJeV1iaUSkU+B39rOke+6sXr5IeajkbZz5IGJxEOD/BzQiRC+yg0AACAASURBVDp/B37n55jSLH/N5W1XdiavSyztRmCJ7RD57NbiSfOMobXtHHmgLTCVeMjvnR8vB971eUzZM3n3A0Xel1gqEakAfm07R74KUbH26wXvH2I7Rx4ZDEz0c0An6lQDp6Ptjmx704k6b9sO0dLyvsTSJgPv2A6Rj24sfmiWMbRv+Jnio/HEQ+P8HDA9G26Cn2NKk+XdURioxABIJSIucLHtHPmmHZUV3yl4a5jtHHlqEvHQgX4O6ESdp4AH/RxTGu1L4C+2Q9igEktLJSL/A56wnSOfXFX02IwCQ0fbOfJUKTCFeKiVz+NeBMz1eUxp2L35sNjvzqjEtvUrYKPtEPmghOpNYwtf9XWmnDTZCOBWPwd0ok4l3vUx/TtqOZvw+T7AIFGJbSWViHyBtxKBZNhlRVPfLjRuV9s5hIuJh07yc0An6szFOyKTlvGEE3VW2g5hi0psR3cBeTfDpyUVUVvzg8IXfL0eI83yCPFQLz8HdKLOQ8CTfo4pO+UCd9oOYZNKbDupRKQObzv2attZctVPCp99q8jU72s7h2zRCW//sSKfx50ALPR5TNnW0+kj37ylEtuJVCIyF+8maPGZob7+J0XPqsCyzxHAtX4O6ESd9XjXx/QDYWa4wPW2Q9imEtu1m4GZtkPkmh8W/vPNVqb2ANs5ZKdixEPH+jmgE3XeAy7zc0zZ4jkn6sy2HcI2ldgupBKRGuActECwj1z3sqIpnW2nkF0qAP5EPNTNz0GdqDMReNbPMQUXn4+cg0olthupRGQOcJXtHLlibOGr77Qx1f1s59js3Gcr6XrbeobcU7HlsdP/spHh91Uw/L4KwnetZ/h9FTu8blOty8gHKhh2XwWD76ngmlc2bfncmU9vZOi9Ffz63189dsN/q3hmfk1mvxj/dAMeIx7ye3ftc4FFPo+Zz552oo7OFKESa4w70OZ/vri66LF2tjNs7QfDi3nhrLbbPDZlTFtmXdCeWRe059SBxXxv4I67w5QUwsvRdsy+oD2zJrTjhY9refOLWt5fVkebIsP7P27PO4vrKN/ksmR9PW99Wcd3BwRql5njgCv8HNCJOquBM4C8vCHXZ/XoVqAtVGINSCUi9XinFcttZwmybxW89V6pqRxsO8fWvr5/EZ3a7PyAw3Vdps6r4YwhO07YM8bQvpX3upp6qKkDAxQXQGWtS73rUlMHhQVw9StVXPuNkkx+GZlyHfHQEX4O6ESd6cA1fo6Zp550os685gxgjHGNMXds9ftLjTHxZifb8X1+vd3v3/D7PVRijZDedyyKdx5a9sCNxQ/7fXoqo177vI5u7Qx99y7c6efr6l2G31dB19vWc1zvIkb1LGJgl0K6tC3g4Ps3MLpfEQtX11PvwsH77HyMLFeIN+2+k8/j3gz8y+cx80kV/hyFVQHfM8Zk+hr1NiXmuu7hfr+BSqyRUonIs8BttnME0ZEFjrO3WX+Q7RxN8aRTwxlDdn0KsLDAMOuC9nzxy1LeXlzHnOV1ANz1rdbMuqA9lxxewlWvVHH9MSXc+N8qTvvzRh54N3AzzXsBD/s5oBN1XOBsYJmf4+aRO52o84kP49QCk4BfbP8JY0wXY8xfjTHvpD+O2Orxfxlj5hpjHjTGfLa5BI0xzxhj3k1/7kfpxxJAG2PMLGPM4+nHKtK/PmWMiWz1no8aY8YYYwqNMbel3/d9Y0yDOyOoxJrm18CrtkMEzW3F929q+FnZo7be5en5tZy+mxLbbK/Whv8LF/HCwm0v9Tw7v4YR+xRQUe3y8Zp6po5ty18+qGFjTeAO5k8mHvJ1hwcn6iwDzsK7tiONtxi4ycfx7gbONMaEtnv8d8BvXdc9FDiVr3YmuAZ42XXdwXgr5u+31WvOdV13BHAIcJExZm/XdWNApeu6w13XPXO795gCnAZgjGkFfBNIAucB5en3PhQ43xiz21tyVGJNkF7N43S0E3SjDTcLP9zHrD7Udo6meOmTOgZ0LqBnh53/81ixoZ61m7wyqqxx+dcntQzo/NVza+pc7nqrmsuPKKGyxrteBlBXD9V1mU6fEbcSD43wc0An6rwEJPwcMw/8yok6O06X3UOu664D/siO61weC/zBGDMLeA7oYIxpDxwJPJV+7QvAmq1ec5ExZjbwJt4RfN8G3v4fwP8ZY0qAbwP/dV23EjgeOCf93m8Bezc0lkqsiVKJyDK8ItMsq0a4s/ie1bYz7MoZf93I1x7awIer6ul553oees873ffUnB1PJS5eX893HvcWZl9S4fJ/kzcw9N4KDn1gA8f1LuLEfl89/+53qokOK6ZtsWFotwI21rqU3VvBiH0K2at1oC4NbtYKeIp4qNTnca9GM38b63/A4xkY9y68o5+tZw4XAIelj6CGu667r+u6uyxPY8w38Irva67rDsNbJKL17t7Udd1NwH+AE/C+n07ZPBzws63e+wDXdV/c3VjGdQN3eiMrhGPJS9E1st3qbz7/9IVWsf2N0Q9LOeJJ4uXf93PAssllvYBZeOs3ys65wCgn6vi2+7wxpsJ13fbp/74VGAc87Lpu3BjzBDDTdd3b0p8f7rruLGPM3cDnruveYow5Hvgn0AVvybLxruuONsYMwPv/+S3Xdf9jjFkDdHVdt2Yn7xsBxuOdgjzQdd3q9PW07wBjXdetMcb0A750XXfDrr4WfXPZQ6lE5Hbgads5stlvi+/5UgWWU84gHjrPzwGdqLMI+IGfY+agyX4W2E7cAWw9S/Ei4JD0xIp5wAXpx68FjjfGzAHGAkuB9cALQJEx5gO8U8RvbjXWJOD9zRM7tvMicDTwkuu6m2c9PQjMA95Lv8/9wG4XptaRWDOEY8kOeP/DBtrOkm32M8u+eLXVL7obs/u/gBI4G4GRxMt9XTm9bHLZXYCvE0hyxHqgnxN1ltoOkr5+Vee6bq0x5mvAva7rDredSz8lN0MqEVmHd1FSEz22c2fxvZ+owHJSW2AK8VAbn8e9HHjX5zFzwa+yocDS9gPeSU/gmAicbzkPoBJrtlQi8hneOdz1trNki26sXj7CfDTSdg7JmMF438R840SdarwL/Ov8HDfgXgHusx1iM9d1F7iue5DrusNc1z3Udd1MnuJsNJWYD1KJyCxgDBCYVV4z6bbi+z8wZvezkyTwxhMPjfNzQCfqfIy3kabABuC89M3hshsqMZ+kEpEXyZLDa5v2Yv2aowocX+8pkqw1iXioj58DOlHnKb66uTafXeFEnU9thwgClZiPUonIZPJ8dembih+abQztbeeQFlGKd/9YK5/HvQiY4/OYQfIa8AfbIYJCJeazVCJyPfCA7Rw2tKNy/bcK3rY+W0la1AjgVj8HdKJOJd71sY1+jhsQlcC5Oo3YeCqxzPgx3jpgeeWaosnvFhj2sp1DWtzFxEMn+TlgequR7ZdDygdXOlFnoe0QQaISy4D0GounAS/bztJSWlNVOabwtazaL0xa1CPEQ738HNCJOg8BT/o5ZpZ7FW/xXWkClViGpBKRjcCJwL9tZ2kJlxdNebvAuF1s5xBrOuHtP+b3vYETgHw4MlkBfN+JOlrZv4lUYhmUSkQqgdHk+CaARdTWnFP4YkOrVkvuOwJvaSLfOFFnPd71scBtxtYELnCWE3UW2w4SRCqxDEsX2Ul4i2XmpJ8V/e3NIlPfw3YOyQox4qFj/RzQiTrvAZf5OWaWudmJOrtdqV12TSXWAlKJyCbgZLw9dHJKAfV1Py58br+Gnyl5ogD4E/FQNz8HdaLOROBZP8fMEq+R57flNJdKrIWkEpEq4BRybNbiDwtfeKuVqdvfdg7JKt3wiszv7y8/BD73eUybVgJnOFEnmFulZgmVWAtKF9n3gGm2s/jDdS8tmqrJHLIzxwIxPwd0os4a4AxyY0NaFzjbiTpf2g4SdCqxFpZKRKqBU4EnbGdprtMK//NOG1OtCR2yK9cRDx3h54BO1HmD3Dj9dqMTdV6wHSIXqMQsSBfZWcCNtrM0x1VFf2rX8LMkjxXiTbv3e9fmBMGe8fsXcqOIs4JKzJJUIuKmEpHfAOcRwNMj3yl4671SU6mbm6UhvYBH/BwwvSTT2Xg7CwfNDOAcLSvlH5WYZalE5GG8jTXLbWdpihuKH9bfHWmsk4iHfN212Yk6y/DOZgTp5uAvgJPSa0OKT/SNKAukEpGXgCMJyMyrowredzqZ9VroV5riVuIhX7focaLOv4Gb/RwzgzYAo52oo13gfaYSyxKpRGQOcBjwnu0sDbmt+P5NtjNI4LTC27al1OdxrwFe93lMv9UDZzpRZ5btILlIJZZFUonIEuDrZPEU/IPNR/O7mzWH2s4hgdQHuN/PAdP3WJ0BrPJzXJ/FnKiTizdqZwWVWJZJJSIb8JapugrIupsg7yy+d43tDBJoZxAPjfdzQCfqfIF3I3Q2+oMTdW6zHSKXqcSyUHrm4g3AcWTRDKwB5vNP9jfLRtnOIYE3kXjI15mtTtT5O3CXn2P64FHyc0+0FqUSy2KpROQV4CDgFdtZAO4qvnuxMfo7I83WBphCPNTG53F/Bbzr85h76i/AeE2lzzx9Q8pyqURkKd4R2Q14S9VYETZLFvU3iw6z9f6Scwbj8waQTtSpxtu2ZZ2f4+6B5/H2Bsu6ywG5SCUWAKlEpC6ViFyFdz/ZShsZ7iy+91Nj8HvDQ8lfi8nArs1O1PkY+JHf4zbBf4BTnahTYzFDXlGJBUgqEfknMJwWnlK8D6uWHmQW6lqY+OVZYCjx8oycJneizhTggUyM3YC38O4F0y0oLUglFjCpRORL4BvA5UCL/GO5tfj+D42hpCXeS3LaJuAnxMu/S7w801PiLwbmZPg9tjYL+LYTdSpa8D0FMK6r645BFY4l+wEP4a32kREdWbf6vZILSoxBi/1Kc7wK/Ih4+Uct9YZlk8sGAe8AbTP8Vm8AESfqrM3w+8hO6EgswFKJyEfA0Xg/dW7IxHvcXPzQ+yowaYa1eNeo/q8lCwzAiTrzyPwU9xeB41Rg9uhILEeEY8kDgAeBY/wasz0b1zkl411jCPk1puSVvwI/JV5u9V7HsslljwPfz8DQT+PtzFydgbGlkXQkliNSicinqUTkm8AEfJpiHC/+43sqMNkDi4FTiJePsV1gaRcAC30e81HgNBWYfSqxHJNKRCbh3YPzt+aM05qqyu8VvKb9wqQpXOA+YCDx8mdsh9nMiTrr8e4f86twJgLn6j6w7KDTiTksHEt+A7gTb9WPJrmmaPKrPyz659G+h5JcNRvv1GHWrihfNrnsIpp/g/W1TtSJ+xBHfKISy3HhWLIAOAe4CdinMa8pprb6g5IfrCoy9Y16vuS1z/EWq/4T8fKs36CybHLZ34Dv7sFLq/CWkfqTz5GkmVRieSIcS7bDW1vuUry163bpkqKpr/2s6JmjWiSYBNVavA0pJxIvD8zNvWWTyzri3dO1XxNetgz4rhN13sxMKmkOlVieCceSPfG++ZwJmO0/X0B93Ycl0S+KTd3+LR5OgqAauBu4gXj5atth9kTZ5LLD8e5ba8wyarOBk5yoE4hd1/ORSixPhWPJkXinGL+59eM/Kpw2/dfFTxxhJ5VkMRd4CriSePmntsM0V9nksivw/v7vzjPAWU7Uycg9mOIPlVieC8eSh+Nt8X48uO78kh983NrU9LGdS7KGi7cqe5x4+QzbYfxSNrnMAC8Ax+/iKTcDV2orleynEhMAwrHkqNMKX/nhrcUPTLCdRbJCDd4q87cRL2/JNQhbTNnksq54pwu7b/XwBuBHTtR5wk4qaaoml9i7777btaio6EFgCLrPrKnqgTm1tbXjR4wYsdx2mJ2Kh4biTQA5HSi0nEZaXgUwCfgt8fIvbIfJtLLJZd/EWzqqAJgLjHWizgd2U0lTNLnEZs+e/Vz37t0HdunSZV1BQYEO45qgvr7erFixIrR06dJ5w4YNO8l2nt2Kh8LAJcC5ZH4BVbFvGd5NvPcQL8+rdQDLJpfdAPQELnSizkbbeaRp9mSTwyFdunRZowJruoKCArdLly7lS5cuHWI7S4Pi5SngZ8RDVwFn4y3imv25pak+xLshfjLx8irbYSy5Ste+gmtPSqxABbbn0n92wTkN6/1U/nvg98RDh+OV2Wk0cK+ZZLUK4M/Aw9m8wkZLUYEFm7abl8aLl78BvEE89HPgLLxCK7MbSppgOvAwMJV4uTZvlJzQ7BILx5Ij/AiyWSoRebeh5xhjRowfP37ZAw888AXA1Vdf3a2ioqLwzjvvXNzU91u5cmXhgw8+2CkWi61o6mv33XffshkzZnywzz771Db1tYHmHZ39AfgD8dBheGV2KtDBai7ZmSXAH/GOulp0Py+RlhCc01pbadWqlfv88893XLJkSbNLeNWqVYUPPfRQ1519rqamprnD5754+ZvEy88FugIn4v2kn+mt52X31gB/AkYDvYiXx1RgkqsCWWKFhYXuOeecs+Kmm27qtv3nFi9eXHTCCSccOGTIkIFDhgwZ+OKLL7YD+OUvf9nj6quv3vL8vn37Dv7www9bXXLJJT0XLVpUMmDAgEETJkzoOW3atNIRI0b0P+aYY/r07dt3CMCxxx574ODBgwf26dNn8O2339655b7SAImXVxEvTxIvPw/ohrcSyD14e0tJ5n0K3IW3KWpX4uVnEy+fRrxc24VITgvsNbHLLrtseVlZ2eB4PL7NpnsTJkzo9ctf/nLZCSecULFgwYJWJ5xwQt9PPvlk7q7GueOOO7448cQT28yfP38ewLRp00rnzZvXdubMmXMHDBhQDfD444+nunXrVldRUWEOOuigQWedddaa7t2765vDrnjfOF8GXiYe+inwNeB7wClAb5vRcogLzACeBZ4jXu5YziNiRWBLrFOnTvVjx45dlUgkurZp02bLFhDTp0/vsGDBgi0z5yoqKgrLy8ubdMQ5dOjQDZsLDOCWW27plkwm9wJYunRp8dy5c1t3795d66k1RrzcBd5If1xKPNQb+AZwdPrXpqwmnu8WA6/j/YDwd+LlOsqVvBfYEgO44oorlh188MGDxo0bt3LzY67r8t57733Qtm3bbabNFhUVufX1X213VFVVtcMK7pu1bdt2yxOnTZtW+uqrr5bOmDFjfmlpaf3IkSP7V1ZWBvI0bFaIl38CfIJ37QzioQPwyuwbeMWm1fM9LvABXml5Hzmw8K6I3wJdYt26dasbPXr0mieeeKLzGWecsQrgyCOPXHfzzTd3vf7665cBvPHGG20OP/zwynA4XPX888/vBfD666+3/fLLL0sAQqFQ3YYNG3ZZSmvXri0MhUJ1paWl9TNnzmw9e/bsdi3xteUN7xvzp8Aj3u9DYbwyOxhv+v5QYG9L6VrSBrx1/DaX1vSgbnUi0pKaXWKNmRKfSVdeeeXSyZMnd9n8+0mTJi0aP378fv369RtUV1dnRo0atf7www///Jxzzlnz+OOP792nT5/BBx100Ib9999/E0D37t3rRowYUdG3b9/BxxxzTPno0aPLtx7/1FNPLZ80aVKX3r17D+7du/emYcOG6TRiJnkrhaSAyV89FuqBV2abS20oMABo1eL5mq8c7whr3nYfn6dPvYpIE+zJ2ompYcOGrWz4mbIrs2fP7jxs2LCw7RyBFg8VA/3xJor03MnHvthZ87EO796sL7f6+JjNZRUv/9JCJpGcFejTiZLH4uU1wJz0xy6eE+rEV6W2N9Au/dF2F7+2wzu6qwaqtvp164/Nj20CVgMrgOXpX73/jpd/dfFVRDJKJSa5y7umtBp433YUEckMzbITEZHAUomJiEhgqcRERCSwVGIiIhJYzZ/YEQ/5uhUL8fIG7zsrLCwc0bdv38q6ujrTp0+fyqlTp6ZKS0sbPSMslUoVX3DBBb1eeOGFT9544402ixYtanX66aeXAzz++OOhuXPntrnpppuWNjSOiIjYFcgjsZKSkvr58+fPW7Bgwdzi4mL3jjvu6NLwq74SDodrXnjhhU8AZsyY0TaZTIY2f+7MM88sV4GJiARDIEtsa0ceeWTFwoULS5YtW1Z47LHHHtivX79Bw4YNG/DWW2+1AUgmk+0HDBgwaMCAAYMGDhw4aM2aNQUffvhhq759+w7etGmTufnmm3v8/e9/7zhgwIBBDzzwQMeJEyfufc455+y3atWqwh49epTV1XmL1a9bt66ge/fuQ6uqqszcuXNLjjrqqL6DBw8eOGLEiP4zZ85sbfUPQUQkTwW6xGpqavjnP//ZoaysrPLyyy/vMWzYsI0fffTRvOuvv/7LaDR6AMAdd9zRfeLEiZ/Nnz9/3ptvvjm/ffv2W047tm7d2r3iiisWjx49es38+fPnnX/++Ws2f27vvfeuGzhw4Mbnn3++FGDKlCmho48+urykpMQdP378/vfcc8/nc+fO/eC222774sc//rFWYhcRsSCQJVZVVVUwYMCAQWVlZYN69uxZffHFF698++23S88777xVACeddNL6tWvXFq1evbrgsMMOq7j00kt73XDDDV1XrlxZWFxc3Oj3GTt27Jonn3yyI8DUqVM7jRs3bk15eXnBzJkz248dO/bAAQMGDLrwwgv3X758eeMHFRER3wRyxY7N18Qa89ybbrpp6Xe/+93yZ599NnTUUUcNSCaTC7beamV3zjjjjLXXX3/9vsuWLSucM2dO29GjR69bt25dQWlpaW1j31/ykzGmDnDw/o19AERd193YhNf3ACa6rjvGGDMc6OG67vPpz50EDHJdN5GB6CKBEsgjsZ0ZNWrU+kceeWRv8PYA69ixY22nTp3q586dWzJy5MjKG2+8cenQoUM3zJkzZ5vrVx06dKirqKjY6Z9DKBSqHzp06IYJEybs981vfrO8qKiITp061ffs2bP64Ycf7ghQX1/P//73vzY7e73ktUrXdYe7rjsEb73FC5ryYtd1F7uuOyb92+HAd7b63HMqMBGPD1PsG54S3xJuueWWxWeeeWa4X79+g9q0aVP/6KOPfgpw6623dn3jjTc6GGPc/v37V44ZM6b8888/33L679vf/vb622+/fZ8BAwYMuuSSS5ZsP+5pp5225txzz+09bdq0Dzc/9uSTT35y/vnn73/LLbfsU1tba0455ZTVX/va1ypb5iuVAHoNGGqM6YS3GWhvYCPwI9d13zfGHA38Lv1cF/g63oLF0/D2VbsOaGOMORK4GWgDHAJcibcu5AGu69YbY9oB89Pj7wfcDXRJv9f5ruvOb4kvVqQlaSsWC7QVS+4zxlS4rtveGFME/BV4ARgErHRd91pjzDHAna7rDjfG/B1IuK473RjTHm+F/J7ANNd1hxhjfgAc4rruT9Njb/m9MeZZ4C7XdV8xxpwOHOe67nhjzL+BC1zXXWCMGQXc7LruMS38xyCScYG8JiYSAG2MMbPS//0a8BDwFnAqgOu6Lxtj9jbGdACmA3caYx4HnnZd9wtjTGPfZwpwOvAKMA64J12EhwN/3mqcEh++JpGsoxITyYxK13WHb/3ArorJdd2EMSaJd91rujHmBLyjscZ4DrgpfapyBPAy3r5oa7d/f5FclDMTO0QC4DXgTABjzDfwTi2uM8Yc6Lqu47ruLcA7wIDtXrceKN3ZgK7rVqRf8zu80491ruuuAz41xoxNv5cxxgzLyFckYplKTKTlxIERxpj3gQQQTT/+c2PMnPTjNcA/tnvdK8AgY8ys9HWv7U0Bzkr/utmZwHnGmNnAXOBk/74Mkeyh04kiGeC6bvudPLYa+O5OHv/ZToZIAUO2et2h233+0a1e/xdgm3OVrut+CnyribFFAkdHYiIiEljNPhIrm1zm61YsTtRp8L4zY8yI8ePHL3vggQe+ALj66qu7VVRUFN55552L/cwSi8W6JxKJLSvaH3TQQQNmzpype21ERLJEII/EWrVq5T7//PMdlyxZktHToRMnTtxn69+rwEREsksgS6ywsNA955xzVtx0003dtv/c4sWLi0444YQDhwwZMnDIkCEDX3zxxXabHz/88MP79unTZ/Dpp5++f48ePco2l+Cxxx574ODBgwf26dNn8O23394Z4MILL9x380LDJ5100gEAbdu2PQjgxBNP7P3UU09t2YPs1FNPDT/yyCMda2trmTBhQs8hQ4YM7Nev36Dbbrutc0v8eYiI5KtAlhjAZZddtvzpp5/utGrVqsKtH58wYUKvX/7yl8vmzJnzwd/+9rePL7jggjBALBbrcfTRR69fuHDh3LFjx65ZsmRJq82vefzxx1Nz5879YNasWfPuv//+bkuXLi285557vty80PBzzz336dbvcdppp62eOnVqR4BNmzaZ6dOndxg7duzau+66q3MoFKqbM2fOB7Nnz/5g8uTJXebPn98KERHJiMDOTuzUqVP92LFjVyUSia5t2rTZsir99OnTOyxYsGDLgrwVFRWF5eXlBW+//Xb7Z555ZiHAmDFj1nXo0KFu83NuueWWbslkci+ApUuXFs+dO7d19+7dN+zqvceMGVP+q1/9qldlZaX561//Gho5cuT69u3buy+99FKH+fPnt33uuec6Aqxfv75w3rx5rQcMGFCdiT8DEZF8F9gSA7jiiiuWHXzwwYPGjRu3ZS1H13V57733Pmjbtm2jFoWcNm1a6auvvlo6Y8aM+aWlpfUjR47sX1lZudsj1LZt27qHHXbY+qeffrrDlClTOo4bN251+r3NHXfc8fmpp566rnlfmYiINEZgTycCdOvWrW706NFrnnjiiS3Xno488sh1N998c9fNv3/jjTfaABx66KEVjz32WCeAp59+usO6desKAdauXVsYCoXqSktL62fOnNl69uzZ7Ta/tqioyK2qqtrpWkGnn376mkcffbTzO++8U7q5tI477rjye++9t8vm17z//vsl69atC/SfsYhINmv2kVhjpsRn0pVXXrl08uTJXTb/ftKkSYvGjx+/X79+/QbV1dWZUaNGrT/88MM/TyQSi8eMGdO7b9++e48YMaKiBxdlBwAAAVpJREFUc+fONXvttVfdqaeeWj5p0qQuvXv3Hty7d+9Nw4YN23Ia8cwzz1wxcODAQUOGDNm4/XWxU045Zd2ECRMOOO6449a2bt3aBfjFL36xMpVKlZSVlQ10Xdd06tSp5vnnn/+45f40RETyS95sxVJZWWmKiorc4uJiXnrppXY//elP97e1O7O2YhER8Uegr4k1xcKFC1uddtppB9bX11NcXOzef//9KduZRESkefKmxMrKyqo++OADK0deIiKSGXsy6aC+vr6+0Tv2ybbSf3b1DT5RREQatCclNmfFihUhFVnT1dfXmxUrVoSAObaziIjkgiafTqytrR2/dOnSB5cuXTqEgE/Rt6AemFNbWzvedhARkVzQ5NmJIiIi2UJHUiIiElgqMRERCSyVmIiIBJZKTEREAkslJiIigaUSExGRwFKJiYhIYKnEREQksFRiIiISWCoxEREJrP8HtOaa2EQS2sQAAAAASUVORK5CYII=\n"},"metadata":{}}]},{"cell_type":"code","source":["newdata.to_csv('MSc_Lexicon_Sentiment_new.csv')"],"metadata":{"id":"O0HnREdwB_OX","executionInfo":{"status":"ok","timestamp":1667904879652,"user_tz":0,"elapsed":9768,"user":{"displayName":"Frances Wireko","userId":"14106139935587129886"}}},"execution_count":22,"outputs":[]}]}