Final_Version_CANIS_Data_Visualization_Project_Notebook.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/khushil-sketch/CANIS-Data-Visualization-Foreign-Interference-Hackathon/blob/main/Final_Version_CANIS_Data_Visualization_Project_Notebook.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Install relevant libraries"
      ],
      "metadata": {
        "id": "Kgfh7gMY8Dco"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "XvpkaNHvuu2e",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "aea0f0f9-ac43-4e03-a379-5a1dbbbf1556"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: textblob in /usr/local/lib/python3.10/dist-packages (0.17.1)\n",
            "Requirement already satisfied: nltk>=3.1 in /usr/local/lib/python3.10/dist-packages (from textblob) (3.8.1)\n",
            "Requirement already satisfied: click in /usr/local/lib/python3.10/dist-packages (from nltk>=3.1->textblob) (8.1.7)\n",
            "Requirement already satisfied: joblib in /usr/local/lib/python3.10/dist-packages (from nltk>=3.1->textblob) (1.3.2)\n",
            "Requirement already satisfied: regex>=2021.8.3 in /usr/local/lib/python3.10/dist-packages (from nltk>=3.1->textblob) (2023.6.3)\n",
            "Requirement already satisfied: tqdm in /usr/local/lib/python3.10/dist-packages (from nltk>=3.1->textblob) (4.66.1)\n",
            "Requirement already satisfied: vaderSentiment in /usr/local/lib/python3.10/dist-packages (3.3.2)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.10/dist-packages (from vaderSentiment) (2.31.0)\n",
            "Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests->vaderSentiment) (3.3.2)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests->vaderSentiment) (3.4)\n",
            "Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from requests->vaderSentiment) (2.0.7)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests->vaderSentiment) (2023.7.22)\n",
            "Requirement already satisfied: deep_translator in /usr/local/lib/python3.10/dist-packages (1.11.4)\n",
            "Requirement already satisfied: beautifulsoup4<5.0.0,>=4.9.1 in /usr/local/lib/python3.10/dist-packages (from deep_translator) (4.11.2)\n",
            "Requirement already satisfied: requests<3.0.0,>=2.23.0 in /usr/local/lib/python3.10/dist-packages (from deep_translator) (2.31.0)\n",
            "Requirement already satisfied: soupsieve>1.2 in /usr/local/lib/python3.10/dist-packages (from beautifulsoup4<5.0.0,>=4.9.1->deep_translator) (2.5)\n",
            "Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep_translator) (3.3.2)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep_translator) (3.4)\n",
            "Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep_translator) (2.0.7)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep_translator) (2023.7.22)\n"
          ]
        }
      ],
      "source": [
        "!pip install textblob\n",
        "!pip install vaderSentiment\n",
        "!pip install deep_translator"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import re\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "from textblob import TextBlob\n",
        "from time import sleep\n",
        "import os\n",
        "import nltk\n",
        "from vaderSentiment.vaderSentiment import SentimentIntensityAnalyzer\n",
        "from deep_translator import GoogleTranslator\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns"
      ],
      "metadata": {
        "id": "thWR8t7eWkgd"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "iicsr56uMOik",
        "outputId": "b5b7b37a-09ec-4a53-9e1d-adc232771490"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Cleaning the CANIS Dataset"
      ],
      "metadata": {
        "id": "YwFoX1yJ8VJa"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Import the original dataset and show a few rows"
      ],
      "metadata": {
        "id": "afkLkuvN8YXJ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "original_file_path = \"/content/drive/My Drive/CANIS dataset.xlsx\"\n",
        "\n",
        "original_df = pd.read_excel(original_file_path)\n",
        "original_df.head()"
      ],
      "metadata": {
        "id": "HGhKQrZmZWZ7",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 620
        },
        "outputId": "be122916-a674-4cd4-91a1-8dcaf659fa8f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      Name (English) Name (Chinese) Region of Focus Language  \\\n",
              "0           Yang Xinmeng (Abby Yang)            杨欣萌     Anglosphere  English   \n",
              "1               CGTN Culture Express            NaN     Anglosphere  English   \n",
              "2     All-China Students' Federation         中华全国学联           China  Chinese   \n",
              "3  Chen Zhong (Dechinghutay / Ghoti)             陈重     Afghanistan   Pashto   \n",
              "4                         Yang Sheng            NaN     Anglosphere  English   \n",
              "\n",
              "           Entity owner (English) Entity owner (Chinese)  \\\n",
              "0         China Media Group (CMG)               中央广播电视总台   \n",
              "1         China Media Group (CMG)               中央广播电视总台   \n",
              "2  All-China Students' Federation              中华全国学生联合会   \n",
              "3         China Media Group (CMG)               中央广播电视总台   \n",
              "4            People's Daily Press                  人民日报社   \n",
              "\n",
              "                            Parent entity (English) Parent entity (Chinese)  \\\n",
              "0                      Central Publicity Department                 中共中央宣传部   \n",
              "1                      Central Publicity Department                 中共中央宣传部   \n",
              "2   Central Committee of the Communist Youth League                   共青团中央   \n",
              "3                      Central Publicity Department                 中共中央宣传部   \n",
              "4  Central Committee of the Chinese Communist Party              中国共产党中央委员会   \n",
              "\n",
              "  X (Twitter) handle                      X (Twitter) URL  ...  \\\n",
              "0       _bubblyabby_     https://twitter.com/_bubblyabby_  ...   \n",
              "1    _cultureexpress  https://twitter.com/_cultureexpress  ...   \n",
              "2           ACSF1919         https://twitter.com/ACSF1919  ...   \n",
              "3        afghanchina      https://twitter.com/afghanchina  ...   \n",
              "4       AlexYsalex17     https://twitter.com/AlexYsalex17  ...   \n",
              "\n",
              "   Instagram Follower # Threads account  \\\n",
              "0                9507.0    _bubblyabby_   \n",
              "1                 635.0             NaN   \n",
              "2                   NaN             NaN   \n",
              "3                   NaN             NaN   \n",
              "4                   NaN             NaN   \n",
              "\n",
              "                             Threads URL  Threads Follower # YouTube account  \\\n",
              "0  https://www.threads.net/@_bubblyabby_               197.0         itsAbby   \n",
              "1                                    NaN                 NaN             NaN   \n",
              "2                                    NaN                 NaN             NaN   \n",
              "3                                    NaN                 NaN    dechinghutay   \n",
              "4                                    NaN                 NaN             NaN   \n",
              "\n",
              "                                         YouTube URL  YouTube Subscriber #  \\\n",
              "0                    https://www.youtube.com/itsAbby                4680.0   \n",
              "1                                                NaN                   NaN   \n",
              "2                                                NaN                   NaN   \n",
              "3  https://www.youtube.com/channel/UCXl9X2fi65wKf...                 695.0   \n",
              "4                                                NaN                   NaN   \n",
              "\n",
              "  TikTok account                            TikTok URL  TikTok Subscriber #  \n",
              "0   _bubblyabby_  https://www.tiktok.com/@_bubblyabby_                660.0  \n",
              "1            NaN                                   NaN                  NaN  \n",
              "2            NaN                                   NaN                  NaN  \n",
              "3   dechinghutay  https://www.tiktok.com/@dechinghutay             326100.0  \n",
              "4            NaN                                   NaN                  NaN  \n",
              "\n",
              "[5 rows x 26 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1f974f02-9191-4968-9b07-2545efbf62d2\" 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>Name (English)</th>\n",
              "      <th>Name (Chinese)</th>\n",
              "      <th>Region of Focus</th>\n",
              "      <th>Language</th>\n",
              "      <th>Entity owner (English)</th>\n",
              "      <th>Entity owner (Chinese)</th>\n",
              "      <th>Parent entity (English)</th>\n",
              "      <th>Parent entity (Chinese)</th>\n",
              "      <th>X (Twitter) handle</th>\n",
              "      <th>X (Twitter) URL</th>\n",
              "      <th>...</th>\n",
              "      <th>Instagram Follower #</th>\n",
              "      <th>Threads account</th>\n",
              "      <th>Threads URL</th>\n",
              "      <th>Threads Follower #</th>\n",
              "      <th>YouTube account</th>\n",
              "      <th>YouTube URL</th>\n",
              "      <th>YouTube Subscriber #</th>\n",
              "      <th>TikTok account</th>\n",
              "      <th>TikTok URL</th>\n",
              "      <th>TikTok Subscriber #</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Yang Xinmeng (Abby Yang)</td>\n",
              "      <td>杨欣萌</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>中央广播电视总台</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>中共中央宣传部</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://twitter.com/_bubblyabby_</td>\n",
              "      <td>...</td>\n",
              "      <td>9507.0</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://www.threads.net/@_bubblyabby_</td>\n",
              "      <td>197.0</td>\n",
              "      <td>itsAbby</td>\n",
              "      <td>https://www.youtube.com/itsAbby</td>\n",
              "      <td>4680.0</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://www.tiktok.com/@_bubblyabby_</td>\n",
              "      <td>660.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>CGTN Culture Express</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>中央广播电视总台</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>中共中央宣传部</td>\n",
              "      <td>_cultureexpress</td>\n",
              "      <td>https://twitter.com/_cultureexpress</td>\n",
              "      <td>...</td>\n",
              "      <td>635.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>All-China Students' Federation</td>\n",
              "      <td>中华全国学联</td>\n",
              "      <td>China</td>\n",
              "      <td>Chinese</td>\n",
              "      <td>All-China Students' Federation</td>\n",
              "      <td>中华全国学生联合会</td>\n",
              "      <td>Central Committee of the Communist Youth League</td>\n",
              "      <td>共青团中央</td>\n",
              "      <td>ACSF1919</td>\n",
              "      <td>https://twitter.com/ACSF1919</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Chen Zhong (Dechinghutay / Ghoti)</td>\n",
              "      <td>陈重</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>Pashto</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>中央广播电视总台</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>中共中央宣传部</td>\n",
              "      <td>afghanchina</td>\n",
              "      <td>https://twitter.com/afghanchina</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.youtube.com/channel/UCXl9X2fi65wKf...</td>\n",
              "      <td>695.0</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.tiktok.com/@dechinghutay</td>\n",
              "      <td>326100.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Yang Sheng</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>People's Daily Press</td>\n",
              "      <td>人民日报社</td>\n",
              "      <td>Central Committee of the Chinese Communist Party</td>\n",
              "      <td>中国共产党中央委员会</td>\n",
              "      <td>AlexYsalex17</td>\n",
              "      <td>https://twitter.com/AlexYsalex17</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 26 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1f974f02-9191-4968-9b07-2545efbf62d2')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-1f974f02-9191-4968-9b07-2545efbf62d2 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-1f974f02-9191-4968-9b07-2545efbf62d2');\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",
              "\n",
              "\n",
              "<div id=\"df-60b2a0a5-be18-489c-9744-288a4038ce8e\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-60b2a0a5-be18-489c-9744-288a4038ce8e')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-60b2a0a5-be18-489c-9744-288a4038ce8e button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Remove columns with names in Chinese and show a few rows"
      ],
      "metadata": {
        "id": "TsGAJ4_V8tp9"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "original_df = original_df.drop(['Name (Chinese)', 'Parent entity (Chinese)', 'Entity owner (Chinese)', 'Parent entity (Chinese)' ], axis=1)\n",
        "original_df.head()\n"
      ],
      "metadata": {
        "id": "PJSobSnpm8K9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 637
        },
        "outputId": "46607c3b-aea2-475b-8924-4432cdcbeb8d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      Name (English) Region of Focus Language  \\\n",
              "0           Yang Xinmeng (Abby Yang)     Anglosphere  English   \n",
              "1               CGTN Culture Express     Anglosphere  English   \n",
              "2     All-China Students' Federation           China  Chinese   \n",
              "3  Chen Zhong (Dechinghutay / Ghoti)     Afghanistan   Pashto   \n",
              "4                         Yang Sheng     Anglosphere  English   \n",
              "\n",
              "           Entity owner (English)  \\\n",
              "0         China Media Group (CMG)   \n",
              "1         China Media Group (CMG)   \n",
              "2  All-China Students' Federation   \n",
              "3         China Media Group (CMG)   \n",
              "4            People's Daily Press   \n",
              "\n",
              "                            Parent entity (English) X (Twitter) handle  \\\n",
              "0                      Central Publicity Department       _bubblyabby_   \n",
              "1                      Central Publicity Department    _cultureexpress   \n",
              "2   Central Committee of the Communist Youth League           ACSF1919   \n",
              "3                      Central Publicity Department        afghanchina   \n",
              "4  Central Committee of the Chinese Communist Party       AlexYsalex17   \n",
              "\n",
              "                       X (Twitter) URL  X (Twitter) Follower #  \\\n",
              "0     https://twitter.com/_bubblyabby_                  1678.0   \n",
              "1  https://twitter.com/_cultureexpress                  2488.0   \n",
              "2         https://twitter.com/ACSF1919                  5136.0   \n",
              "3      https://twitter.com/afghanchina                  1800.0   \n",
              "4     https://twitter.com/AlexYsalex17                  2821.0   \n",
              "\n",
              "             Facebook page                                      Facebook URL  \\\n",
              "0  itsAbby-103043374799622  https://www.facebook.com/itsAbby-103043374799622   \n",
              "1                      NaN                                               NaN   \n",
              "2                      NaN                                               NaN   \n",
              "3             dechinghutay            https://www.facebook.com/dechinghutay/   \n",
              "4                      NaN                                               NaN   \n",
              "\n",
              "   ...  Instagram Follower # Threads account  \\\n",
              "0  ...                9507.0    _bubblyabby_   \n",
              "1  ...                 635.0             NaN   \n",
              "2  ...                   NaN             NaN   \n",
              "3  ...                   NaN             NaN   \n",
              "4  ...                   NaN             NaN   \n",
              "\n",
              "                             Threads URL  Threads Follower # YouTube account  \\\n",
              "0  https://www.threads.net/@_bubblyabby_               197.0         itsAbby   \n",
              "1                                    NaN                 NaN             NaN   \n",
              "2                                    NaN                 NaN             NaN   \n",
              "3                                    NaN                 NaN    dechinghutay   \n",
              "4                                    NaN                 NaN             NaN   \n",
              "\n",
              "                                         YouTube URL  YouTube Subscriber #  \\\n",
              "0                    https://www.youtube.com/itsAbby                4680.0   \n",
              "1                                                NaN                   NaN   \n",
              "2                                                NaN                   NaN   \n",
              "3  https://www.youtube.com/channel/UCXl9X2fi65wKf...                 695.0   \n",
              "4                                                NaN                   NaN   \n",
              "\n",
              "  TikTok account                            TikTok URL  TikTok Subscriber #  \n",
              "0   _bubblyabby_  https://www.tiktok.com/@_bubblyabby_                660.0  \n",
              "1            NaN                                   NaN                  NaN  \n",
              "2            NaN                                   NaN                  NaN  \n",
              "3   dechinghutay  https://www.tiktok.com/@dechinghutay             326100.0  \n",
              "4            NaN                                   NaN                  NaN  \n",
              "\n",
              "[5 rows x 23 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5aeea2e9-f0c6-4b82-9cf4-136b626308bb\" 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>Name (English)</th>\n",
              "      <th>Region of Focus</th>\n",
              "      <th>Language</th>\n",
              "      <th>Entity owner (English)</th>\n",
              "      <th>Parent entity (English)</th>\n",
              "      <th>X (Twitter) handle</th>\n",
              "      <th>X (Twitter) URL</th>\n",
              "      <th>X (Twitter) Follower #</th>\n",
              "      <th>Facebook page</th>\n",
              "      <th>Facebook URL</th>\n",
              "      <th>...</th>\n",
              "      <th>Instagram Follower #</th>\n",
              "      <th>Threads account</th>\n",
              "      <th>Threads URL</th>\n",
              "      <th>Threads Follower #</th>\n",
              "      <th>YouTube account</th>\n",
              "      <th>YouTube URL</th>\n",
              "      <th>YouTube Subscriber #</th>\n",
              "      <th>TikTok account</th>\n",
              "      <th>TikTok URL</th>\n",
              "      <th>TikTok Subscriber #</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Yang Xinmeng (Abby Yang)</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://twitter.com/_bubblyabby_</td>\n",
              "      <td>1678.0</td>\n",
              "      <td>itsAbby-103043374799622</td>\n",
              "      <td>https://www.facebook.com/itsAbby-103043374799622</td>\n",
              "      <td>...</td>\n",
              "      <td>9507.0</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://www.threads.net/@_bubblyabby_</td>\n",
              "      <td>197.0</td>\n",
              "      <td>itsAbby</td>\n",
              "      <td>https://www.youtube.com/itsAbby</td>\n",
              "      <td>4680.0</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://www.tiktok.com/@_bubblyabby_</td>\n",
              "      <td>660.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>CGTN Culture Express</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>_cultureexpress</td>\n",
              "      <td>https://twitter.com/_cultureexpress</td>\n",
              "      <td>2488.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>635.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>All-China Students' Federation</td>\n",
              "      <td>China</td>\n",
              "      <td>Chinese</td>\n",
              "      <td>All-China Students' Federation</td>\n",
              "      <td>Central Committee of the Communist Youth League</td>\n",
              "      <td>ACSF1919</td>\n",
              "      <td>https://twitter.com/ACSF1919</td>\n",
              "      <td>5136.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Chen Zhong (Dechinghutay / Ghoti)</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>Pashto</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>afghanchina</td>\n",
              "      <td>https://twitter.com/afghanchina</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.facebook.com/dechinghutay/</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.youtube.com/channel/UCXl9X2fi65wKf...</td>\n",
              "      <td>695.0</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.tiktok.com/@dechinghutay</td>\n",
              "      <td>326100.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Yang Sheng</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>People's Daily Press</td>\n",
              "      <td>Central Committee of the Chinese Communist Party</td>\n",
              "      <td>AlexYsalex17</td>\n",
              "      <td>https://twitter.com/AlexYsalex17</td>\n",
              "      <td>2821.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 23 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5aeea2e9-f0c6-4b82-9cf4-136b626308bb')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-5aeea2e9-f0c6-4b82-9cf4-136b626308bb 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-5aeea2e9-f0c6-4b82-9cf4-136b626308bb');\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",
              "\n",
              "\n",
              "<div id=\"df-3b0d8533-b196-4138-bb74-53ae484bfc6c\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3b0d8533-b196-4138-bb74-53ae484bfc6c')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-3b0d8533-b196-4138-bb74-53ae484bfc6c button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Group countries into \"Western\" or \"non-Western\" on the basis of being US allies in NATO or the EU, including Switzerland, Japan, South Korea, New Zealand, Australia, Taiwan, Israel, and Singapore"
      ],
      "metadata": {
        "id": "lzpSOr9L9GhX"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Understanding which regions have a high amount of Chinese social media presence\n",
        "western_countries = ['Switzerland', 'Austria', 'EU', 'France', 'Cyprus',\n",
        "                     'Italy', 'USA', 'Bulgaria', 'Japan', 'South Korea', 'Poland', 'UK',\n",
        "                     'Finland', 'Spain', 'Netherlands', 'Belgium', 'New Zealand',\n",
        "                     'Germany', 'Canada', 'Türkiye', 'Australia', 'Greece', 'Albania', 'Croatia',\n",
        "                     'Ireland', 'Malta', 'Portugal', 'Slovakia', 'Slovenia', 'Denmark', 'Hungary',\n",
        "                     'Montenegro', 'Estonia', 'Iceland', 'Lithuania', 'Czech Rep.', 'Israel',\n",
        "                     'Norway', 'Latvia', 'Taiwan', 'Romania', 'North Macedonia', 'Singapore']\n",
        "\n",
        "original_df['Western'] = original_df['Region of Focus'].apply(lambda x: \"yes\" if x in western_countries else \"no\")\n",
        "\n",
        "original_df.head(20)\n",
        "\n"
      ],
      "metadata": {
        "id": "MoHDJblrpxv7",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "c056ba36-7975-4256-85ed-597cd1fa703f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                       Name (English) Region of Focus          Language  \\\n",
              "0            Yang Xinmeng (Abby Yang)     Anglosphere           English   \n",
              "1                CGTN Culture Express     Anglosphere           English   \n",
              "2      All-China Students' Federation           China           Chinese   \n",
              "3   Chen Zhong (Dechinghutay / Ghoti)     Afghanistan            Pashto   \n",
              "4                          Yang Sheng     Anglosphere           English   \n",
              "5                      Yunnan Gateway          Yunnan           Chinese   \n",
              "6                             Chen Xu     Switzerland            German   \n",
              "7                             Li Song         Austria            German   \n",
              "8                             Lu Kang       Indonesia  Bahasa Indonesia   \n",
              "9                        Zhang Yiming             UAE            Arabic   \n",
              "10                           Zhu Jing              EU           English   \n",
              "11          Chinese Embassy in France          France            French   \n",
              "12                           Liu Yuxi   African Union           English   \n",
              "13                     Huang Xingyuan          Cyprus           English   \n",
              "14                        Lei Kezhong         Lesotho           English   \n",
              "15                          Chang Hua            Iran           Persian   \n",
              "16                            Chen Bo          Serbia           Serbian   \n",
              "17                       Chen Weiqing    Saudi Arabia            Arabic   \n",
              "18         Chinese Embassy in Burundi         Burundi            French   \n",
              "19        Chinese Embassy in Cameroon        Cameroon            French   \n",
              "\n",
              "            Entity owner (English)  \\\n",
              "0          China Media Group (CMG)   \n",
              "1          China Media Group (CMG)   \n",
              "2   All-China Students' Federation   \n",
              "3          China Media Group (CMG)   \n",
              "4             People's Daily Press   \n",
              "5         Yunnan Daily Press Group   \n",
              "6      Ministry of Foreign Affairs   \n",
              "7      Ministry of Foreign Affairs   \n",
              "8      Ministry of Foreign Affairs   \n",
              "9      Ministry of Foreign Affairs   \n",
              "10     Ministry of Foreign Affairs   \n",
              "11     Ministry of Foreign Affairs   \n",
              "12     Ministry of Foreign Affairs   \n",
              "13     Ministry of Foreign Affairs   \n",
              "14     Ministry of Foreign Affairs   \n",
              "15     Ministry of Foreign Affairs   \n",
              "16     Ministry of Foreign Affairs   \n",
              "17     Ministry of Foreign Affairs   \n",
              "18     Ministry of Foreign Affairs   \n",
              "19     Ministry of Foreign Affairs   \n",
              "\n",
              "                             Parent entity (English) X (Twitter) handle  \\\n",
              "0                       Central Publicity Department       _bubblyabby_   \n",
              "1                       Central Publicity Department    _cultureexpress   \n",
              "2    Central Committee of the Communist Youth League           ACSF1919   \n",
              "3                       Central Publicity Department        afghanchina   \n",
              "4   Central Committee of the Chinese Communist Party       AlexYsalex17   \n",
              "5            State Council Information Office (SCIO)     Amazing_Yunnan   \n",
              "6                        Ministry of Foreign Affairs         Amb_ChenXu   \n",
              "7                        Ministry of Foreign Affairs         Amb_LiSong   \n",
              "8                        Ministry of Foreign Affairs         Amb_LuKang   \n",
              "9                        Ministry of Foreign Affairs         Amb_Yiming   \n",
              "10                       Ministry of Foreign Affairs        Amb_ZhuJing   \n",
              "11                       Ministry of Foreign Affairs     AmbassadeChine   \n",
              "12                       Ministry of Foreign Affairs     Ambassador_Liu   \n",
              "13                       Ministry of Foreign Affairs    AmbassadorHuang   \n",
              "14                       Ministry of Foreign Affairs      AmbassadorLei   \n",
              "15                       Ministry of Foreign Affairs        AmbChangHua   \n",
              "16                       Ministry of Foreign Affairs          AmbChenBo   \n",
              "17                       Ministry of Foreign Affairs     AmbChenWeiqing   \n",
              "18                       Ministry of Foreign Affairs    AmbChineBurundi   \n",
              "19                       Ministry of Foreign Affairs        AmbChineCmr   \n",
              "\n",
              "                        X (Twitter) URL  X (Twitter) Follower #  \\\n",
              "0      https://twitter.com/_bubblyabby_                  1678.0   \n",
              "1   https://twitter.com/_cultureexpress                  2488.0   \n",
              "2          https://twitter.com/ACSF1919                  5136.0   \n",
              "3       https://twitter.com/afghanchina                  1800.0   \n",
              "4      https://twitter.com/AlexYsalex17                  2821.0   \n",
              "5    https://twitter.com/Amazing_Yunnan                 12400.0   \n",
              "6        https://twitter.com/Amb_ChenXu                 12600.0   \n",
              "7        https://twitter.com/Amb_LiSong                  5972.0   \n",
              "8        https://twitter.com/Amb_LuKang                 40600.0   \n",
              "9        https://twitter.com/Amb_Yiming                 20300.0   \n",
              "10      https://twitter.com/Amb_ZhuJing                 18500.0   \n",
              "11   https://twitter.com/AmbassadeChine                 63800.0   \n",
              "12   https://twitter.com/Ambassador_Liu                 11200.0   \n",
              "13  https://twitter.com/AmbassadorHuang                  2534.0   \n",
              "14    https://twitter.com/AmbassadorLei                  1470.0   \n",
              "15      https://twitter.com/AmbChangHua                 26400.0   \n",
              "16        https://twitter.com/AmbChenBo                 12900.0   \n",
              "17   https://twitter.com/AmbChenWeiqing                 83700.0   \n",
              "18  https://twitter.com/AmbChineBurundi                  4651.0   \n",
              "19      https://twitter.com/AmbChineCmr                  3147.0   \n",
              "\n",
              "              Facebook page                                      Facebook URL  \\\n",
              "0   itsAbby-103043374799622  https://www.facebook.com/itsAbby-103043374799622   \n",
              "1                       NaN                                               NaN   \n",
              "2                       NaN                                               NaN   \n",
              "3              dechinghutay            https://www.facebook.com/dechinghutay/   \n",
              "4                       NaN                                               NaN   \n",
              "5                       NaN                                               NaN   \n",
              "6                       NaN                                               NaN   \n",
              "7                       NaN                                               NaN   \n",
              "8                       NaN                                               NaN   \n",
              "9                       NaN                                               NaN   \n",
              "10                      NaN                                               NaN   \n",
              "11           AmbassadeChine           https://www.facebook.com/AmbassadeChine   \n",
              "12                      NaN                                               NaN   \n",
              "13                      NaN                                               NaN   \n",
              "14                      NaN                                               NaN   \n",
              "15                      NaN                                               NaN   \n",
              "16                      NaN                                               NaN   \n",
              "17                      NaN                                               NaN   \n",
              "18                      NaN                                               NaN   \n",
              "19                      NaN                                               NaN   \n",
              "\n",
              "    ...  Threads account                            Threads URL  \\\n",
              "0   ...     _bubblyabby_  https://www.threads.net/@_bubblyabby_   \n",
              "1   ...              NaN                                    NaN   \n",
              "2   ...              NaN                                    NaN   \n",
              "3   ...              NaN                                    NaN   \n",
              "4   ...              NaN                                    NaN   \n",
              "5   ...              NaN                                    NaN   \n",
              "6   ...              NaN                                    NaN   \n",
              "7   ...              NaN                                    NaN   \n",
              "8   ...              NaN                                    NaN   \n",
              "9   ...              NaN                                    NaN   \n",
              "10  ...              NaN                                    NaN   \n",
              "11  ...              NaN                                    NaN   \n",
              "12  ...              NaN                                    NaN   \n",
              "13  ...              NaN                                    NaN   \n",
              "14  ...              NaN                                    NaN   \n",
              "15  ...              NaN                                    NaN   \n",
              "16  ...              NaN                                    NaN   \n",
              "17  ...              NaN                                    NaN   \n",
              "18  ...              NaN                                    NaN   \n",
              "19  ...              NaN                                    NaN   \n",
              "\n",
              "   Threads Follower #                YouTube account  \\\n",
              "0               197.0                        itsAbby   \n",
              "1                 NaN                            NaN   \n",
              "2                 NaN                            NaN   \n",
              "3                 NaN                   dechinghutay   \n",
              "4                 NaN                            NaN   \n",
              "5                 NaN                            NaN   \n",
              "6                 NaN                            NaN   \n",
              "7                 NaN                            NaN   \n",
              "8                 NaN                            NaN   \n",
              "9                 NaN                            NaN   \n",
              "10                NaN                            NaN   \n",
              "11                NaN                            NaN   \n",
              "12                NaN                            NaN   \n",
              "13                NaN                            NaN   \n",
              "14                NaN                            NaN   \n",
              "15                NaN                            NaN   \n",
              "16                NaN                            NaN   \n",
              "17                NaN                            NaN   \n",
              "18                NaN  ambassadedechineauburundi9155   \n",
              "19                NaN                            NaN   \n",
              "\n",
              "                                          YouTube URL YouTube Subscriber #  \\\n",
              "0                     https://www.youtube.com/itsAbby               4680.0   \n",
              "1                                                 NaN                  NaN   \n",
              "2                                                 NaN                  NaN   \n",
              "3   https://www.youtube.com/channel/UCXl9X2fi65wKf...                695.0   \n",
              "4                                                 NaN                  NaN   \n",
              "5                                                 NaN                  NaN   \n",
              "6                                                 NaN                  NaN   \n",
              "7                                                 NaN                  NaN   \n",
              "8                                                 NaN                  NaN   \n",
              "9                                                 NaN                  NaN   \n",
              "10                                                NaN                  NaN   \n",
              "11                                                NaN                  NaN   \n",
              "12                                                NaN                  NaN   \n",
              "13                                                NaN                  NaN   \n",
              "14                                                NaN                  NaN   \n",
              "15                                                NaN                  NaN   \n",
              "16                                                NaN                  NaN   \n",
              "17                                                NaN                  NaN   \n",
              "18  https://www.youtube.com/@ambassadedechineaubur...                 71.0   \n",
              "19                                                NaN                  NaN   \n",
              "\n",
              "      TikTok account                                TikTok URL  \\\n",
              "0       _bubblyabby_      https://www.tiktok.com/@_bubblyabby_   \n",
              "1                NaN                                       NaN   \n",
              "2                NaN                                       NaN   \n",
              "3       dechinghutay      https://www.tiktok.com/@dechinghutay   \n",
              "4                NaN                                       NaN   \n",
              "5                NaN                                       NaN   \n",
              "6                NaN                                       NaN   \n",
              "7                NaN                                       NaN   \n",
              "8                NaN                                       NaN   \n",
              "9                NaN                                       NaN   \n",
              "10               NaN                                       NaN   \n",
              "11  ambassadedechine  https://www.tiktok.com/@ambassadedechine   \n",
              "12               NaN                                       NaN   \n",
              "13               NaN                                       NaN   \n",
              "14               NaN                                       NaN   \n",
              "15               NaN                                       NaN   \n",
              "16               NaN                                       NaN   \n",
              "17               NaN                                       NaN   \n",
              "18               NaN                                       NaN   \n",
              "19               NaN                                       NaN   \n",
              "\n",
              "   TikTok Subscriber #  Western  \n",
              "0                660.0       no  \n",
              "1                  NaN       no  \n",
              "2                  NaN       no  \n",
              "3             326100.0       no  \n",
              "4                  NaN       no  \n",
              "5                  NaN       no  \n",
              "6                  NaN      yes  \n",
              "7                  NaN      yes  \n",
              "8                  NaN       no  \n",
              "9                  NaN       no  \n",
              "10                 NaN      yes  \n",
              "11            168600.0      yes  \n",
              "12                 NaN       no  \n",
              "13                 NaN      yes  \n",
              "14                 NaN       no  \n",
              "15                 NaN       no  \n",
              "16                 NaN       no  \n",
              "17                 NaN       no  \n",
              "18                 NaN       no  \n",
              "19                 NaN       no  \n",
              "\n",
              "[20 rows x 24 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-11637f38-ce13-49c5-a7cd-c906a4138758\" 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>Name (English)</th>\n",
              "      <th>Region of Focus</th>\n",
              "      <th>Language</th>\n",
              "      <th>Entity owner (English)</th>\n",
              "      <th>Parent entity (English)</th>\n",
              "      <th>X (Twitter) handle</th>\n",
              "      <th>X (Twitter) URL</th>\n",
              "      <th>X (Twitter) Follower #</th>\n",
              "      <th>Facebook page</th>\n",
              "      <th>Facebook URL</th>\n",
              "      <th>...</th>\n",
              "      <th>Threads account</th>\n",
              "      <th>Threads URL</th>\n",
              "      <th>Threads Follower #</th>\n",
              "      <th>YouTube account</th>\n",
              "      <th>YouTube URL</th>\n",
              "      <th>YouTube Subscriber #</th>\n",
              "      <th>TikTok account</th>\n",
              "      <th>TikTok URL</th>\n",
              "      <th>TikTok Subscriber #</th>\n",
              "      <th>Western</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Yang Xinmeng (Abby Yang)</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://twitter.com/_bubblyabby_</td>\n",
              "      <td>1678.0</td>\n",
              "      <td>itsAbby-103043374799622</td>\n",
              "      <td>https://www.facebook.com/itsAbby-103043374799622</td>\n",
              "      <td>...</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://www.threads.net/@_bubblyabby_</td>\n",
              "      <td>197.0</td>\n",
              "      <td>itsAbby</td>\n",
              "      <td>https://www.youtube.com/itsAbby</td>\n",
              "      <td>4680.0</td>\n",
              "      <td>_bubblyabby_</td>\n",
              "      <td>https://www.tiktok.com/@_bubblyabby_</td>\n",
              "      <td>660.0</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>CGTN Culture Express</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>_cultureexpress</td>\n",
              "      <td>https://twitter.com/_cultureexpress</td>\n",
              "      <td>2488.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>All-China Students' Federation</td>\n",
              "      <td>China</td>\n",
              "      <td>Chinese</td>\n",
              "      <td>All-China Students' Federation</td>\n",
              "      <td>Central Committee of the Communist Youth League</td>\n",
              "      <td>ACSF1919</td>\n",
              "      <td>https://twitter.com/ACSF1919</td>\n",
              "      <td>5136.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Chen Zhong (Dechinghutay / Ghoti)</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>Pashto</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>afghanchina</td>\n",
              "      <td>https://twitter.com/afghanchina</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.facebook.com/dechinghutay/</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.youtube.com/channel/UCXl9X2fi65wKf...</td>\n",
              "      <td>695.0</td>\n",
              "      <td>dechinghutay</td>\n",
              "      <td>https://www.tiktok.com/@dechinghutay</td>\n",
              "      <td>326100.0</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Yang Sheng</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>People's Daily Press</td>\n",
              "      <td>Central Committee of the Chinese Communist Party</td>\n",
              "      <td>AlexYsalex17</td>\n",
              "      <td>https://twitter.com/AlexYsalex17</td>\n",
              "      <td>2821.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Yunnan Gateway</td>\n",
              "      <td>Yunnan</td>\n",
              "      <td>Chinese</td>\n",
              "      <td>Yunnan Daily Press Group</td>\n",
              "      <td>State Council Information Office (SCIO)</td>\n",
              "      <td>Amazing_Yunnan</td>\n",
              "      <td>https://twitter.com/Amazing_Yunnan</td>\n",
              "      <td>12400.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Chen Xu</td>\n",
              "      <td>Switzerland</td>\n",
              "      <td>German</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Amb_ChenXu</td>\n",
              "      <td>https://twitter.com/Amb_ChenXu</td>\n",
              "      <td>12600.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Li Song</td>\n",
              "      <td>Austria</td>\n",
              "      <td>German</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Amb_LiSong</td>\n",
              "      <td>https://twitter.com/Amb_LiSong</td>\n",
              "      <td>5972.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Lu Kang</td>\n",
              "      <td>Indonesia</td>\n",
              "      <td>Bahasa Indonesia</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Amb_LuKang</td>\n",
              "      <td>https://twitter.com/Amb_LuKang</td>\n",
              "      <td>40600.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Zhang Yiming</td>\n",
              "      <td>UAE</td>\n",
              "      <td>Arabic</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Amb_Yiming</td>\n",
              "      <td>https://twitter.com/Amb_Yiming</td>\n",
              "      <td>20300.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Zhu Jing</td>\n",
              "      <td>EU</td>\n",
              "      <td>English</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Amb_ZhuJing</td>\n",
              "      <td>https://twitter.com/Amb_ZhuJing</td>\n",
              "      <td>18500.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Chinese Embassy in France</td>\n",
              "      <td>France</td>\n",
              "      <td>French</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbassadeChine</td>\n",
              "      <td>https://twitter.com/AmbassadeChine</td>\n",
              "      <td>63800.0</td>\n",
              "      <td>AmbassadeChine</td>\n",
              "      <td>https://www.facebook.com/AmbassadeChine</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ambassadedechine</td>\n",
              "      <td>https://www.tiktok.com/@ambassadedechine</td>\n",
              "      <td>168600.0</td>\n",
              "      <td>yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Liu Yuxi</td>\n",
              "      <td>African Union</td>\n",
              "      <td>English</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ambassador_Liu</td>\n",
              "      <td>https://twitter.com/Ambassador_Liu</td>\n",
              "      <td>11200.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Huang Xingyuan</td>\n",
              "      <td>Cyprus</td>\n",
              "      <td>English</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbassadorHuang</td>\n",
              "      <td>https://twitter.com/AmbassadorHuang</td>\n",
              "      <td>2534.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Lei Kezhong</td>\n",
              "      <td>Lesotho</td>\n",
              "      <td>English</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbassadorLei</td>\n",
              "      <td>https://twitter.com/AmbassadorLei</td>\n",
              "      <td>1470.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Chang Hua</td>\n",
              "      <td>Iran</td>\n",
              "      <td>Persian</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbChangHua</td>\n",
              "      <td>https://twitter.com/AmbChangHua</td>\n",
              "      <td>26400.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Chen Bo</td>\n",
              "      <td>Serbia</td>\n",
              "      <td>Serbian</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbChenBo</td>\n",
              "      <td>https://twitter.com/AmbChenBo</td>\n",
              "      <td>12900.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Chen Weiqing</td>\n",
              "      <td>Saudi Arabia</td>\n",
              "      <td>Arabic</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbChenWeiqing</td>\n",
              "      <td>https://twitter.com/AmbChenWeiqing</td>\n",
              "      <td>83700.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Chinese Embassy in Burundi</td>\n",
              "      <td>Burundi</td>\n",
              "      <td>French</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbChineBurundi</td>\n",
              "      <td>https://twitter.com/AmbChineBurundi</td>\n",
              "      <td>4651.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ambassadedechineauburundi9155</td>\n",
              "      <td>https://www.youtube.com/@ambassadedechineaubur...</td>\n",
              "      <td>71.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Chinese Embassy in Cameroon</td>\n",
              "      <td>Cameroon</td>\n",
              "      <td>French</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>AmbChineCmr</td>\n",
              "      <td>https://twitter.com/AmbChineCmr</td>\n",
              "      <td>3147.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>20 rows × 24 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-11637f38-ce13-49c5-a7cd-c906a4138758')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-11637f38-ce13-49c5-a7cd-c906a4138758 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-11637f38-ce13-49c5-a7cd-c906a4138758');\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",
              "\n",
              "\n",
              "<div id=\"df-075f342b-e1d4-41fc-9aea-62266adeaa61\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-075f342b-e1d4-41fc-9aea-62266adeaa61')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-075f342b-e1d4-41fc-9aea-62266adeaa61 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "original_df.to_csv('original_df.csv')"
      ],
      "metadata": {
        "id": "eI9mNxhOInfj"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "Visualize frequencies of which social media platform is most prevalent among the 6 we are given"
      ],
      "metadata": {
        "id": "UW8gGqth92C4"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# set plot style: grey grid in the background:\n",
        "sns.set(style=\"darkgrid\")\n",
        "\n",
        "# load dataset\n",
        "tips = sns.load_dataset(\"tips\")\n",
        "\n",
        "# Set the figure size\n",
        "plt.figure(figsize=(10, 7))\n",
        "\n",
        "# plot a bar chart\n",
        "sns.barplot(\n",
        "    x=\"Post Frequency\",\n",
        "    y=\"Day\",\n",
        "    data=tips,\n",
        "    estimator=sum,\n",
        "    ci=None,\n",
        "    color='#69b3a2');"
      ],
      "metadata": {
        "id": "wyH6FIjuI2Ij",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 245
        },
        "outputId": "c29b6867-b283-4e3f-ac90-7799ab6f6098"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "error",
          "ename": "NameError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-1-467011050e8e>\u001b[0m in \u001b[0;36m<cell line: 2>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;31m# set plot style: grey grid in the background:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0msns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mset\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mstyle\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"darkgrid\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0;31m# load dataset\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0mtips\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mload_dataset\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"tips\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mNameError\u001b[0m: name 'sns' is not defined"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "twitter_count = original_df[original_df['X (Twitter) URL'].notna()].shape[0]\n",
        "facebook_count = original_df[original_df['Facebook URL'].notna()].shape[0]\n",
        "instagram_count = original_df[original_df['Instagram URL'].notna()].shape[0]\n",
        "threads_count = original_df[original_df['Threads URL'].notna()].shape[0]\n",
        "youtube_count = original_df[original_df['YouTube URL'].notna()].shape[0]\n",
        "tiktok_count = original_df[original_df['TikTok URL'].notna()].shape[0]\n",
        "\n",
        "# fig, ax = plt.subplots()\n",
        "\n",
        "# accounts = ['Twitter', 'Facebook', 'Instagram', 'Threads', 'YouTube', 'TikTok']\n",
        "# counts = [twitter_count, facebook_count, instagram_count, threads_count, youtube_count, tiktok_count]\n",
        "\n",
        "# Preparing data for seaborn bar plot\n",
        "counts_data = {\n",
        "    'Platform': ['Twitter', 'Facebook', 'Instagram', 'Threads', 'YouTube', 'TikTok'],\n",
        "    'Number of Accounts': [twitter_count, facebook_count, instagram_count, threads_count, youtube_count, tiktok_count]\n",
        "}\n",
        "df = pd.DataFrame(counts_data)\n",
        "\n",
        "palette_colors = sns.color_palette(\"hls\", 6)\n",
        "\n",
        "# Set the figure size\n",
        "plt.figure(figsize=(10, 7))\n",
        "\n",
        "sns.set_palette(sns.color_palette(\"hls\", 6))\n",
        "\n",
        "# plot a bar chart\n",
        "sns.barplot(\n",
        "    x= 'Platform',\n",
        "    y='Number of Accounts',\n",
        "    data=df,\n",
        "    estimator=sum,\n",
        "    errorbar=None).set(title='Accounts per Platform')\n",
        "\n",
        "plt.xlabel('Platform', fontsize=18)\n",
        "plt.ylabel('Number of Accounts', fontsize=18)\n",
        "\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 673
        },
        "id": "S1DQHnCx-EFN",
        "outputId": "2e83eae8-9791-4fb7-c8a1-9992df0232db"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Text(0, 0.5, 'Number of Accounts')"
            ]
          },
          "metadata": {},
          "execution_count": 30
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 1000x700 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA2IAAAJ/CAYAAAAakGBjAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAABwoElEQVR4nO3dd3gUVf/+8Xs3BUJIIESKVBM0oYUQCIQSQDoEFDsqRYo0KYKgFAVFQRTwAUnoUgREfCiiCFItCAZEHxBRFCSo9E4KBNLm9we/7Jc1AcImmZDN+3VdXLAzZ+Z8dney2Zs5c8ZiGIYhAAAAAIBprHldAAAAAAAUNAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAJzI6tWrFRgYqGPHjuXofs+dO6fBgwcrLCxMgYGBWrRoUY7uHwAKGoIYABQgH330kQIDA/Xkk0/mdSm5avbs2dqyZUtel5GjIiMjFRgYaPsTHBysiIgITZ06VQkJCTnSx9q1a28asCZOnKjvvvtOffr00aRJk9S4ceMc6RMACirXvC4AAGCetWvXqly5ctq3b5/+/vtvVapUKa9LyhVz5sxRmzZt1LJly7wuJce98cYbKlKkiK5cuaIdO3Zo9uzZ2rVrlz7++GNZLJZs7fuLL77QoUOH1L179wzrdu7cqRYtWqhXr17Z6gMAcB1nxACggDh69Kj27NmjUaNGqUSJElq7dm1el4R/SUxMvG2bNm3aqGPHjnrmmWcUFRWl1q1ba8+ePdq7d2+u1nb+/Hl5e3vn2P6uXbumtLS0HNsfAOQ3BDEAKCDWrl2rYsWKqWnTpmrTps1Ng1hcXJzefvttNW/eXDVq1FCTJk30yiuv6MKFC7Y2165dU2RkpNq0aaOgoCCFh4dr4MCB+ueff2xtrly5onfeeUdNmzZVjRo11KZNG82fP1+GYdjaHDt2TIGBgVq9enWGOgIDAxUZGWl7nD407++//9bIkSMVGhqqOnXqaNSoUXYBJjAwUFeuXNGnn35qG8Y3cuRISVJCQoImTJhge24NGjRQjx499Ouvv97ytUvv+/Dhw3rxxRdVu3ZthYWFafz48bp27VqG9p999pkee+wx1axZU/Xq1dPQoUN18uRJuzZdu3ZVhw4dtH//fnXu3FnBwcH6z3/+c8s6MlO/fn1JuuU1YVu2bFGfPn0UHh6uGjVqqGXLlpoxY4ZSU1Pt6vnmm290/Phx2+vWvHlz2zVnhmHYhrYGBgbatjt69KgGDx6sevXqKTg4WE899ZS++eYbu/537dqlwMBArVu3TlOnTlXjxo0VHByshIQEjRw5UiEhITpx4oT69u2rkJAQNW7cWB999JEk6Y8//lC3bt1Uq1YtNWvWjP9AAOA0GJoIAAXE2rVr1apVK7m7u6tDhw76+OOPtW/fPtWsWdPW5vLly+rcubMOHz6sxx9/XNWqVdPFixf11Vdf6fTp0ypRooRSU1PVt29fRUdHq3379urWrZsuX76sHTt26ODBg6pYsaIMw1D//v21a9cuPfHEE6pataq+++47TZo0SadPn9bo0aMdfh5DhgxR+fLl9dJLL+m3337TihUrVKJECb388suSpEmTJum1115TzZo19dRTT0mSKlasKEl6/fXXtXHjRnXp0kWVK1fWpUuX9NNPP+nw4cOqXr16lvouV66chg0bpr1792rJkiWKi4vTpEmTbG1mzZql999/X+3atdMTTzyhCxcuaOnSpercubPWrFljd1bp0qVL6t27t9q3b6+HH35Yvr6+d/x6pIff4sWL37TNp59+qiJFiqhHjx4qUqSIdu7cqenTpyshIUEjRoyQJPXr10/x8fE6deqURo0aJUny9PRUYGCgJk2apFdeeUWNGjVSx44dbfs9d+6cnn76aSUmJqpr167y8fHRp59+qv79+2v69Olq1aqVXR0zZ86Um5ubevXqpaSkJLm5uUmSUlNT1bt3b4WGhmr48OFau3at3nzzTXl4eGjq1Kl66KGH1Lp1ay1fvlwjRoxQrVq1VKFChTt+rQDgrmIAAJzeL7/8YgQEBBg7duwwDMMw0tLSjCZNmhjjx4+3a/f+++8bAQEBxqZNmzLsIy0tzTAMw1i5cqUREBBgLFy48KZtNm/ebAQEBBgzZ860Wz9o0CAjMDDQ+Pvvvw3DMIyjR48aAQEBxqpVqzLsKyAgwJg+fbrt8fTp042AgABj1KhRdu0GDBhg1KtXz25ZrVq1jBEjRmTYZ506dYxx48ZlWH476X3369fPbvkbb7xhBAQEGAcOHDAMwzCOHTtmVK1a1Zg1a5Zduz/++MOoVq2a3fIuXboYAQEBxscff3xHNcTExBjnz583jh49aixfvtyoUaOG0bBhQ+PKlSuGYRjGqlWrjICAAOPo0aO2bRMTEzPsb8yYMUZwcLBx7do127I+ffoYzZo1y7T/gICADK/dhAkTjICAAGP37t22ZQkJCUbz5s2NZs2aGampqYZhGMbOnTuNgIAAo0WLFhlqGTFihBEQEGDMnj3btiw2NtaoWbOmERgYaKxbt862/PDhwxmOCwDIrxiaCAAFwNq1a3XPPfcoLCxMkmSxWBQREaH169fbDU/btGmTqlSpkuFMRvo26W18fHzUpUuXm7bZtm2bXFxc1LVrV7v1PXv2lGEY2rZtm8PP5emnn7Z7HBoaqkuXLmVp5kBvb2/9/PPPOn36tEN9d+7c2e5x+muQ/nw2b96stLQ0tWvXThcuXLD9ueeee1SpUiXt2rXLbnt3d3c99thjd1RD27Zt1aBBA7Vo0UJjx45VpUqVNGfOHHl4eNx0m8KFC9v+nZCQoAsXLig0NFSJiYmKiYm5o/5v9O2336pmzZoKDQ21LfP09FSnTp10/Phx/fnnn3btH3nkEbtabnTjTJ7e3t7y8/OTh4eH2rVrZ1vu7+8vb29vHT161OGaAeBuwdBEAHByqampWrduncLCwuyuI6pZs6YWLFig6OhohYeHS7o+zK1169a33N8///wjPz8/ubre/FfI8ePHVapUKRUtWtRueeXKlW3rHVW2bFm7x+lD/WJjYzP092/Dhw/XyJEj9eCDD6p69epq2rSpHnnkkSwPc/v3LJMVK1aU1Wq1va5//fWXDMO46Wv479esdOnScnd3z1Lf6SIjI1W0aFG5urqqTJkytmGXt3Lo0CFNmzZNO3fuzBBY4+Pj76j/G504cULBwcEZlvv7+9vWBwQE2JaXL18+0/0UKlRIJUqUsFvm5eWlMmXKZJgJ0svLS3FxcQ7XDAB3C4IYADi5nTt36uzZs1q3bp3WrVuXYf3atWttQcxsN5tu/cazdP9mtWY+mMO4YRKQm4mIiFBoaKg2b96sHTt2aP78+Zo3b54iIyPVtGnTrBV9g3/Xn5aWJovFonnz5snFxSVD+yJFitg9vtnZoVsJDQ3NEFpuJS4uTl26dFHRokU1ePBgVaxYUYUKFdKvv/6qKVOmmDpz4c2eb2av1a2WZ+W9BoC7HUEMAJzc2rVr5evrq7Fjx2ZYt3nzZm3evFnjxo1T4cKFVbFiRR06dOiW+6tYsaJ+/vlnJScn2yZb+Ldy5copOjpaCQkJdmep0ofBlStXTpJUrFgxScpwhuPEiRNZf4J3qFSpUurcubM6d+6s8+fP69FHH9Xs2bOzFMT+/vtvu7Nnf//9t9LS0mxnetInKilfvrz8/Pxy7TnciR9++EGXLl1SVFSU6tata1ue2SyLd3ofsrJly+rIkSMZlqe/z/8+ewkA+D9cIwYATuzq1avatGmTHnzwQbVt2zbDn86dO+vy5cv66quvJEmtW7fW77//rs2bN2fYV/pZiNatW+vixYu26cUza9OkSROlpqZmaLNo0SJZLBY1adJEklS0aFH5+Pjoxx9/tGu3bNmybD3vIkWKZAh3qampGYbh+fr6qlSpUkpKSsrSfv/9fJYuXSpJtufTunVrubi4KCoqKsNZG8MwdPHixTt6Hjkh/QzijfUkJSVl+hp7eHjc0VDFpk2bat++fdqzZ49t2ZUrV/Tf//5X5cqV0/3335+NygHAuXFGDACc2FdffaXLly+refPmma6vVauWSpQooc8//1wRERHq1auXNm7cqBdffFGPP/64qlevrtjYWH311VcaN26cqlSpokceeURr1qzRxIkTtW/fPtWpU0eJiYmKjo7WM888o5YtW6p58+YKCwvT1KlTbfel2rFjh7Zu3arnnnvO7rqmJ598UnPnztWrr76qGjVq6Mcff8z0LMudqF69uqKjo7Vw4UKVKlXKdoYq/R5qVapUUZEiRfT999/rl19+sd1n7HaOHTumfv36qXHjxtq7d68+//xzdejQQVWqVJF0/YzYkCFD9N577+n48eNq2bKlPD09dezYMW3ZskVPPfWUevXqla3ndqdCQkJUrFgxjRw5Ul27dpXFYtFnn32W6fC+6tWra/369Zo4caKCgoJUpEiRmx47ktSnTx+tW7dOvXv3VteuXVWsWDGtWbNGx44dU2Rk5E2HkQIACGIA4NQ+//xzFSpUSI0aNcp0vdVq1YMPPqi1a9fq4sWL8vHx0UcffaTIyEht3rxZn376qXx9fdWgQQOVLl1a0vXrdubNm6dZs2bpiy++0KZNm1S8eHHVrl3bdqNfq9WqWbNmafr06Vq/fr1Wr16tcuXK6ZVXXlHPnj3tahgwYIAuXLigjRs36ssvv1STJk30wQcfqEGDBg4/75EjR2rs2LGaNm2arl69qkcffVRvvvmmnnnmGe3YsUObNm2SYRiqWLGiXn/9dT377LNZ2u+0adP0/vvv67333pOrq6u6dOmiV155xa5Nnz59dN9992nRokWaMWOGJKlMmTJq1KjRLUNNbvHx8dHs2bP17rvvatq0afL29tbDDz+sBg0aZAiFzz77rA4cOKDVq1dr0aJFKleu3C1rvueee7R8+XJNnjxZS5cu1bVr1xQYGKjZs2frwQcfzOVnBgD5m8XgilcAAG4pMjJSUVFRio6OvqOJMgAAuBnGDAAAAACAyQhiAAAAAGAyghgAAAAAmCxfXSP26aef6sMPP9Thw4dVpEgRBQUFKSoqynaDyK+++krTpk3TkSNHVLZsWfXp00ePP/643T6SkpI0depUff7557p8+bJCQkI0ZswY+fv758VTAgAAAFAA5ZszYrNmzdJbb72liIgIzZ8/X2+++abKly+v1NRUSdKPP/6ogQMHqlatWpo3b57atWunV199VRs2bLDbz/jx47VixQoNHTpUkZGRSkpKUvfu3e/ovikAAAAAkB354oxYTEyMHnroIc2cOVNNmzbNtE2vXr10+fJlLV++3LZs2LBhOnDggNavXy9JOnXqlJo3b67XX39dnTp1kiRdunRJzZo10wsvvKDevXvn/pMBAAAAUODlizNiq1evVvny5W8awpKSkrRr1y61bdvWbnlERIQOHz6sY8eOSZK2b9+utLQ0u3bFixdXo0aNtG3bttx7AgAAAABwg3xxQ+eff/5ZAQEBmjlzppYsWaL4+HjVqFFDo0aNUnBwsP755x8lJydnuM6rcuXKkq6fUStfvrxiYmLk6+urYsWKZWi3cuXKbNVoGIbS0u76k4sAAAAAcpHVapHFYrltu3wRxM6ePav9+/fr4MGDev311+Xh4aHZs2erZ8+e2rRpk2JjYyVJ3t7edtulP05fHxcXJy8vrwz79/b2trVxVFqaobi4xGztAwAAAED+5u3tIRcXJwlihmHoypUrev/991WlShVJUnBwsJo3b66lS5cqPDw8jyu8nnx9fDzzugwAAAAA+UC+CGLe3t4qXry4LYRJ16/tqlatmv7880+1b99ekjLMfBgXFydJtqGI3t7eSkhIyLD/uLi4DMMV79T1M2JXsrUPAAAAAPnb9TNit5+KI18Esfvvv1///PNPpuuuXbumihUrys3NTTExMWrcuLFtXUxMjCTZrh3z9/fXuXPnFBsbaxe8YmJicuQ+YikpadneBwAAAADnly9mTWzWrJkuXbqkAwcO2JZdvHhRv/76q6pXry53d3eFhYVp48aNdtutX79elStXVvny5SVJ4eHhslqt2rRpk61NbGystm/friZNmpjzZAAAAAAUePnijFjLli0VFBSkwYMHa+jQoSpUqJDmzp0rd3d3Pfvss5Kk/v37q1u3bnrjjTfUrl077dq1S1988YWmTp1q20+ZMmX0xBNPaNKkSbJarSpdurTmzJkjLy8vPf3003n19AAAAAAUMPnihs6SdOHCBU2cOFFff/21kpOTFRoaqlGjRun++++3tdm6daumTZumI0eOqGzZsurTp4+eeOIJu/0kJSVp6tSp+uyzz3T58mXVrl1br732mm2qe0elpqbpwoXL2doHAAAAgPytRAnPLF0jlm+C2N2OIAYAAAAgq0EsX1wjBgAAAADOhCAGAAAAACYjiAEAAACAyQhiAAAAAGAyghgAAAAAmIwgBgAAAAAmI4gBAAAAgMkIYgAAAABgMoIYAAAAAJiMIAYAAAAAJiOIAQAAAIDJCGIAAAAAYDKCGAAAAACYjCAGAAAAACYjiAEAAACAyQhiAAAAAGAy17wuoCCzWi2yWi15XQYykZZmKC3NyOsyAAAA4KQIYnnEarXIp7iHrC4ueV0KMpGWmqqLlxIJYwAAAMgVBLE8YrVaZHVxUcziBbp66mRel4MbFC5zr/y79ZTVaiGIAQAAIFcQxPLY1VMndeXY0bwuAwAAAICJmKwDAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADBZvghiq1evVmBgYIY/U6ZMsWu3YsUKtWnTRkFBQXr44Yf19ddfZ9hXfHy8Ro8erXr16ikkJESDBw/WmTNnzHoqAAAAACDXvC7gTnzwwQfy8vKyPS5durTt3+vWrdOYMWPUr18/1a9fX+vXr9fAgQP10UcfqVatWrZ2Q4YM0Z9//qk33nhDhQoV0rRp09S7d2+tWrVKrq756uUAAAAAkE/lq+RRvXp1lShRItN106dPV/v27TVkyBBJUv369XXw4EHNmDFD8+bNkyTt2bNH27dv1/z58xUeHi5J8vPzU0REhDZt2qSIiAhTngcAAACAgi1fDE28naNHj+qvv/5Su3bt7JZHREQoOjpaSUlJkqRt27bJ29tbjRo1srXx9/dX1apVtW3bNlNrBgAAAFBw5asg1qFDB1WtWlUtWrTQnDlzlJqaKkmKiYmRdP3s1o0qV66s5ORkHT161NbOz89PFovFrp2/v79tHwAAAACQ2/LF0MSSJUtq0KBBCg4OlsVi0VdffaVp06bp9OnTGjt2rGJjYyVJ3t7edtulP05fHxcXZ3eNWbpixYpp//792a7T1TXrudbFJV9l4AKJ9wgAAAC5JV8EscaNG6tx48a2x+Hh4SpUqJA+/PBD9evXLw8r+z9Wq0U+Pp55XQZykLe3R16XAAAAACeVL4JYZtq1a6cFCxbowIEDKlasmKTrU9OXLFnS1iYuLk6SbOu9vb116tSpDPuKjY21tXFUWpqhuLgrWW7v4mLli/5dLi4uUampaXldBgAAAPIRb2+PLI2syrdB7Eb+/v6Srl8Dlv7v9Mdubm6qUKGCrV10dLQMw7C7TuzIkSMKCAjIdh0pKXxpdyapqWm8pwAAAMgV+fYimPXr18vFxUXVqlVThQoVdN9992nDhg0Z2jRo0EDu7u6SpCZNmig2NlbR0dG2NkeOHNFvv/2mJk2amFo/AAAAgIIrX5wR69Wrl8LCwhQYGChJ2rp1q/773/+qW7dutqGIgwYN0vDhw1WxYkWFhYVp/fr12rdvn5YuXWrbT0hIiMLDwzV69GiNGDFChQoV0tSpUxUYGKjWrVvnyXMDAAAAUPDkiyDm5+enVatW6dSpU0pLS9N9992n0aNHq2vXrrY2HTp0UGJioubNm6e5c+fKz89PUVFRCgkJsdvXtGnTNHHiRI0dO1YpKSkKDw/Xa6+9JlfXfPFSAAAAAHACFsMwjLwuwhmkpqbpwoXLWW7v6mqVj4+nfps0QVeOHc3FynCnipSvoGqvvKqLFy9zjRgAAADuSIkSnlmarCPfXiMGAAAAAPkVQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABM5ppbO/7jjz8UHR0ti8Wi8PBwVa5cObe6AgAAAIB8xeEgFh0drVmzZqlWrVp66aWX7NYtXLhQkydPlmEYkiSr1aqRI0eqa9eu2asWAAAAAJyAw0MTN2zYoN27d6tcuXJ2y48cOaIpU6YoLS1Nbm5uKly4sFJTUzVx4kT99ttv2S4YAAAAAPI7h4PYnj17JElNmjSxW75ixQqlpqaqbt262rlzp3744Qe1adNGaWlpWrZsWfaqBQAAAAAn4HAQu3DhglxcXFSmTBm75d99950sFosGDBigIkWKyM3NTcOGDZMk7d69O3vVAgAAAIATcDiIXbp0SZ6enrJYLLZlCQkJ+vPPP+Xh4aF69erZllesWFGFChXS6dOns1ctAAAAADgBh4NYoUKFlJCQYJuQQ7o+XNEwDAUHB8tqtd914cKFHa8SAAAAAJyIw0GsUqVKSktL0w8//GBbtnnzZlksFtWpU8eubVJSkuLj4+Xr6+t4pQAAAADgJBwOYk2bNpVhGHr11Ve1fv16LVq0SKtXr5YktWrVyq7tgQMHlJaWprJly2avWgAAAABwAg7fR6xHjx5as2aNjh07ZpuMwzAMRUREKDAw0K7t1q1bZbFYVLt27exVCwAAAABOwOEg5u3treXLl2v69Onau3evvLy81KxZM/Xq1cuuXVJSklatWiXDMFS/fv1sFwwAAAAA+Z3DQUySSpcurQkTJtyyjbu7u3bs2JGdbgAAAADAqTh8jRgAAAAAwDEOB7EqVaqocePGWW7fvHlzVatWzdHuAAAAAMBpZOuM2I33EMuN9gAAAADgjEwbmpicnJzhJs8AAAAAUBCZkozi4uJ04cIFeXt7m9EdAAAAANzVsjxr4u+//67ff//dbtm1a9e0Zs2am25jGIbi4uK0ceNGpaWlcY0YAAAAAOgOgtiWLVs0Y8YMu2UJCQkaNWrUbbc1DEMWi0Xdu3e/4wIBAAAAwNlkOYh5eXnp3nvvtT0+ceKErFarSpcufdNtrFarihYtqgceeECdOnVSaGho9qoFAAAAACeQ5SD23HPP6bnnnrM9rlKlinx8fPTVV1/lSmEAAAAA4KyyHMT+beDAgSpSpEhO1gIAAAAABUK2ghgAAAAA4M5xYy8AAAAAMJnDZ8TS/fPPP/ryyy/1xx9/KDY2VsnJyTdta7FY9OGHH2a3SwAAAADI17IVxKKiojRr1iylpaXJMIzbtrdYLNnpDgAAAACcgsNB7PPPP1dUVJQkqVSpUgoPD1epUqXk6prtk2wAAAAA4NQcTk3Lli2TJDVv3lzTpk2Tu7t7jhUFAAAAAM7M4ck6Dh48KIvFotdff50QBgAAAAB3wOEgZrFYVLRoUZUuXTon6wEAAAAAp+dwEPP391diYqKSkpJysh4AAAAAcHoOB7Enn3xSKSkp+vLLL3Oyntu6fPmymjRposDAQP3yyy9261asWKE2bdooKChIDz/8sL7++usM28fHx2v06NGqV6+eQkJCNHjwYJ05c8as8gEAAADA8SD21FNPqXnz5powYYJ2796dkzXd0syZM5Wampph+bp16zRmzBi1a9dO8+bNU61atTRw4EDt3bvXrt2QIUO0Y8cOvfHGG5oyZYqOHDmi3r17KyUlxaRnAAAAAKCgc3jWxKioKFWpUkU//fSTunXrptq1a6tmzZry9PS85XYDBw50tEsdPnxYy5Yt04gRI/T666/brZs+fbrat2+vIUOGSJLq16+vgwcPasaMGZo3b54kac+ePdq+fbvmz5+v8PBwSZKfn58iIiK0adMmRUREOFwbAAAAAGRVtoJY+g2aDcPQTz/9pP/973+33S47QWz8+PF6+umn5efnZ7f86NGj+uuvv/Tyyy/bLY+IiNCkSZOUlJQkd3d3bdu2Td7e3mrUqJGtjb+/v6pWrapt27YRxAAAAACYwuEgVrdu3Zys47Y2bNiggwcPKjIyUr/++qvdupiYGEnKENAqV66s5ORkHT16VJUrV1ZMTIz8/PxsATKdv7+/bR8AAAAAkNscDmJLlizJyTpuKTExUe+8846GDh2qokWLZlgfGxsrSfL29rZbnv44fX1cXJy8vLwybF+sWDHt378/23W6umb9kjsXF4cvz4NJeI8AAACQWxwOYmaaNWuWfH199fjjj+d1KTdltVrk43Pr6+OQv3h7e+R1CQAAAHBSd30QO378uBYsWKAZM2YoPj5eknTlyhXb35cvX1axYsUkXZ+avmTJkrZt4+LiJMm23tvbW6dOncrQR2xsrK2No9LSDMXFXclyexcXK1/073JxcYlKTU3L6zIAAACQj3h7e2RpZNVdH8SOHTum5ORk9enTJ8O6bt26KTg4WO+9956k69eK+fv729bHxMTIzc1NFSpUkHT9WrDo6GgZhmF3ndiRI0cUEBCQ7VpTUvjS7kxSU9N4TwEAAJArHA5i3bp1u+NtLBaLPvzwwzvapmrVqlq8eLHdsgMHDmjixIkaN26cgoKCVKFCBd13333asGGDWrZsaWu3fv16NWjQQO7u7pKkJk2aaObMmYqOjlbDhg0lXQ9hv/32m55//vk7fj4AAAAA4AiHg9gPP/yQpXY3TnH/79kKs8Lb21thYWGZrqtevbqqV68uSRo0aJCGDx+uihUrKiwsTOvXr9e+ffu0dOlSW/uQkBCFh4dr9OjRGjFihAoVKqSpU6cqMDBQrVu3vuPaAAAAAMARDgex290PLD4+Xj///LP27t2r4sWL65lnnpGLi4uj3d1Whw4dlJiYqHnz5mnu3Lny8/NTVFSUQkJC7NpNmzZNEydO1NixY5WSkqLw8HC99tprcnW960dpAgAAAHASFsMwjNzsIDo6WoMGDVLDhg01ffr03OwqT6WmpunChctZbu/qapWPj6d+mzRBV44dzcXKcKeKlK+gaq+8qosXL3ONGAAAAO5IiRKeWZqsI9dvlNSgQQO9+uqr2rx5s1asWJHb3QEAAADAXc+UO9ZGRETIxcWFIAYAAAAAMimIFSpUSB4eHjp8+LAZ3QEAAADAXc2UIHb69GnFx8crly9HAwAAAIB8IdeD2NWrV/XGG29IUo7cNBkAAAAA8juH52yPioq65fqkpCSdPHlS27dv16VLl2SxWNS5c2dHuwMAAAAAp5GtIJaVGzQbhiGr1ar+/fvroYcecrQ7AAAAAHAaDgexunXr3nrHrq7y9vZWlSpV1K5dO913332OdgUAAAAATsXhILZkyZKcrAMAAAAACgxTZk0EAAAAAPwfghgAAAAAmMzhoYk3OnfunDZu3Kj9+/fr/PnzkiRfX1/VqFFDbdq00T333JMT3QAAAACAU8hWEEtNTdX777+vhQsXKiUlRZJsN222WCxas2aN3nnnHfXs2VODBw+Wi4tL9isGAAAAgHwuW0HslVde0fr162UYhtzd3VWjRg2VKVNGknTq1Cnt379fSUlJmjt3rk6cOKHJkyfnSNEAAAAAkJ85HMS2bNmidevWSZJ69Oih/v37y9vb265NfHy8Zs2apQULFuiLL75Q27Zt1aJFi+xVDAAAAAD5nMOTdaxcuVIWi0X9+vXTiBEjMoQwSfLy8tIrr7yifv36yTAMrVixIlvFAgAAAIAzcDiI/fLLL7JarerVq9dt2/bq1UtWq1W//PKLo90BAAAAgNNwOIjFxsaqaNGi8vLyum1bLy8veXl5KTY21tHuAAAAAMBpOBzEihUrpoSEBCUkJNy2bXx8vOLj41WsWDFHuwMAAAAAp+FwEAsKClJaWpoWLVp027aLFi1SWlqaatSo4Wh3AAAAAOA0HA5ijz32mAzD0MyZMzVt2jRdvnw5Q5uEhARNnTpVM2fOlMVi0RNPPJGtYgEAAADAGTg8fX3r1q3Vrl07ffnll5ozZ44WLVqkoKAglSpVSpJ0+vRp7d+/X9euXZNhGIqIiFCrVq1yrHAAAAAAyK+ydUPnSZMmqUyZMlqyZImuXr2q3bt3y2KxSJIMw7jegaurunbtqpdeein71QIAAACAE8hWEHNzc9OIESPUvXt3bdq0Sfv379f58+clSb6+vqpRo4Zat26t0qVL50ixAAAAAOAMshXE0pUuXVpdu3bNiV0BAAAAgNNzeLIOAAAAAIBjHD4jlpCQoF27dsnT01P169e/Zdvo6GhduXJF9evXl6enp6NdAgAAAIBTcPiM2Nq1azVw4EBt27bttm03bNiggQMHav369Y52BwAAAABOw+EgtmXLFklShw4dbtv28ccfl2EY2rRpk6PdAQAAAIDTcDiIHTlyRK6urqpatept29aoUUOurq46cuSIo90BAAAAgNNwOIidO3dORYsWtd037JadWK0qWrSozp0752h3AAAAAOA0HA5iHh4eio+PV2pq6m3bpqSkKCEhQW5ubo52BwAAAABOw+EgVqlSJaWmpio6Ovq2baOjo5WSkqIKFSo42h0AAAAAOA2Hg1iTJk1kGIYmTZqkhISEm7a7fPmyJk2aJIvFoqZNmzraHQAAAAA4DYeDWJcuXVSsWDEdOnRITzzxhDZv3qyrV6/a1l+9elWbNm3S448/rkOHDsnLy0vdunXLkaIBAAAAID9z+IbOxYsX13vvvacBAwbor7/+0uDBg+Xi4qLixYtLki5duqTU1FQZhqFChQpp2rRp8vHxyam6AQAAACDfcviMmCSFh4fr448/Vu3atWUYhlJSUnTu3DmdO3dOKSkpMgxDdevW1SeffKKGDRvmVM0AAAAAkK85fEYsXbVq1bRs2TL9/fff2rNnj86ePSuLxaJ77rlHtWvXVsWKFXOiTgAAAABwGtkOYukqVaqkSpUq5dTuAAAAAMBpZWtoIgAAAADgzjl8RuzYsWNasmSJypYtq+eee+6WbRcsWKDTp0+re/fuuvfeex3tEgAAAACcgsNnxD777DMtXrxYhmHctm1iYqIWL16szz//3NHuAAAAAMBpOBzEvvvuO0lSy5Ytb9v24YcflmEY+uabbxztDgAAAACchsNB7NixYypcuLDKly9/27YVKlSQh4eHTpw44Wh3AAAAAOA0HA5isbGxcnd3z3J7d3d3XbhwwdHuAAAAAMBpOBzEvL29FR8fr4SEhNu2TUhIUHx8vIoWLepodwAAAADgNBwOYlWrVpVhGNqwYcNt23755ZdKS0tTQECAo90BAAAAgNNwOIi1adNGhmFo8uTJ+v3332/a7vfff9eUKVNksVjUrl07R7sDAAAAAKfh8H3EHnnkES1evFiHDh1Sp06d9OSTT6pZs2YqW7asJOnEiRP6+uuvtWLFCl27dk0PPPCAnnjiiRwrHAAAAADyK4eDmJubm2bOnKnnn39ef//9tz766CN99NFHGdoZhqFKlSpp1qxZcnV1uDsAAAAAcBoOD02Urk9Lv2rVKvXr108lS5aUYRh2f0qVKqUBAwZo9erVWZrmHgAAAAAKgmyfoipatKiGDBmiIUOG6MSJEzp37pwkqWTJkrr33nuzXSAAAAAAOJscHStYtmxZ2zVi/3bx4kV99tln6t69e052CQAAAAD5Tq5etGUYhr777jutXLlSX3/9tVJTUwliAAAAAAq8XAliR48e1apVq7RmzRqdPn1a0vVQ5uLikhvdAQAAAEC+kmNBLCkpSRs2bNCqVau0e/du24QdVqtVtWvXVtu2bdWmTZuc6g4AAAAA8q1sB7H9+/dr1apVWrduneLj42UYhiTJYrFo5MiRioiIUKlSpbJdKAAAAAA4C4eCWGxsrD7//HOtXLlSBw8elHR96GHp0qXVsWNHzZ07V5LUqVMneXh45Fy1AAAAAOAE7iiI7dixQytXrtTWrVuVnJwswzDk4eGhli1b6tFHH1WDBg1ksVhsQQzArVmtFlmtlrwuA5lISzOUlmbkdRkAAMBJZTmINW/eXCdPnpRhGLJYLAoNDdWjjz6qNm3ayNPTMzdrBJyS1WqRj4+HrFYmsbkbpaWl6uLFRMIYAADIFVkOYidOnJDFYtGzzz6r559//qb3CwOQNdfPhrnoYMwCJV49mdfl4AYehe9VgH9PWa0WghgAAMgVd3yN2H//+18dP35cjzzyiFq0aCF3d/fcqAsoMBKvntTlK0fzugwAAACYyJrVhnPnzlWrVq0kSd9++61eeuklNWrUSGPHjtVPP/2UawUCAAAAgLPJ8hmxJk2aqEmTJrpw4YI+++wzrVy5UocPH9Z///tfrVixQuXLl1fHjh3VsWPH3KwXAAAAAPK9LJ8RS1eiRAn16NFD69at0yeffKInnnhCRYoU0dGjRzVjxgy1bt3a1jYhISFHiwUAAAAAZ3DHQexGwcHBGj9+vLZv364JEyYoJCTEdkNn6fpMi3369NGnn36q+Pj4bBcLAAAAAM4gW0EsnYeHhx5//HEtW7ZMX375pXr16iVfX18lJydr27ZtGj16tBo2bKh+/frlRHcAAAAAkK/lSBC7kZ+fn15++WV9++23mjFjhh588EFZrVYlJyfr22+/zenuAAAAACDfuePp67PKxcVFLVq0UIsWLXT27Fl9+umnWrVqVW51BwAAAAD5Ro6fEctMyZIl1adPH23cuNGM7gAAAADgrmZKEAMAAAAA/B+CGAAAAACYjCAGAAAAACYjiAEAAACAyQhiAAAAAGAyghgAAAAAmCxLQez333/X4cOHc7sWAAAAACgQshTEHnnkEXXv3t1u2ahRozRx4sTcqCmDb7/9Vl26dFH9+vVVo0YNtWjRQhMnTlR8fLxdu6+++koPP/ywgoKC1KZNm0xvIJ2UlKR3331XjRo1Uq1atdSjRw/FxMSY8jwAAAAAQLqDoYmGYdg9/vTTT7Vu3bocLygzly5dUs2aNTVu3DjNnz9fPXr00Jo1a/Tiiy/a2vz4448aOHCgatWqpXnz5qldu3Z69dVXtWHDBrt9jR8/XitWrNDQoUMVGRmppKQkde/ePUOoAwAAAIDc4pqVRoUKFdLly5dzu5ab6tixo93jsLAwubu7a8yYMTp9+rRKly6tWbNmqWbNmnrzzTclSfXr19fRo0c1ffp0tW3bVpJ06tQprVy5Uq+//rqeeOIJSVJQUJCaNWum5cuXq3fv3uY+MQAAAAAFUpbOiJUrV05Xr17Vxo0bc7ueLCtevLgkKTk5WUlJSdq1a5ctcKWLiIjQ4cOHdezYMUnS9u3blZaWZteuePHiatSokbZt22Za7QAAAAAKtiydEWvdurVmz56tIUOGqHjx4ipSpIgk6eLFi2rRokWWO7NYLNqyZYtjlUpKTU1VSkqK/vzzT82YMUPNmzdX+fLl9eeffyo5OVn+/v527StXrixJiomJUfny5RUTEyNfX18VK1YsQ7uVK1c6XFc6V9esT0Lp4sKElXe73H6POAbufrxHAAAgt2QpiPXr10+///67vvnmG128eFEXL16UdD0YHT9+PMudWSwWx6r8/5o1a6bTp09Lkho3bqz33ntPkhQbGytJ8vb2tmuf/jh9fVxcnLy8vDLs19vb29bGUVarRT4+ntnaB+4u3t4eeV0C8hjHAAAAyC1ZCmKFCxfW7NmzFRMTo4MHDyoxMVGjRo2Sl5eXRo8ends12sydO1eJiYn6888/NWvWLPXr108LFy40rf9bSUszFBd3JcvtXVysfMm7y8XFJSo1NS3X9s8xcPfL7WMAAAA4H29vjyyNqslSEEvn7+9vG/43atQoFSpUSI8++qhjFTqgSpUqkqSQkBAFBQWpY8eO2rx5s+6//35JyjDzYVxcnCTZhiJ6e3srISEhw37j4uIyDFd0REoKX9icSWpqGu9pAccxAAAAcovDF0AMHDhQPXv2zMla7khgYKDc3Nz0zz//qGLFinJzc8twP7D0x+nh0d/fX+fOncswDDEmJibD9WUAAAAAkFvybRD7+eeflZycrPLly8vd3V1hYWEZZnVcv369KleurPLly0uSwsPDZbVatWnTJlub2NhYbd++XU2aNDG1fgAAAAAF1x0NTbyVQ4cOaf/+/Tp//rwkydfXV0FBQbZhg9kxcOBA1ahRQ4GBgSpcuLB+//13zZ8/X4GBgWrZsqUkqX///urWrZveeOMNtWvXTrt27dIXX3yhqVOn2vZTpkwZPfHEE5o0aZKsVqtKly6tOXPmyMvLS08//XS26wQAAACArMh2EPvuu+80efJkHTp0KNP1AQEBevnllxUeHu5wHzVr1tT69es1d+5cGYahcuXK6cknn1SvXr3k7u4uSQoNDVVkZKSmTZumlStXqmzZsho/frzatWtnt6/XXntNnp6eeu+993T58mXVrl1bCxcuzHQ2RQAAAADIDRbDMAxHN166dKnefvttGYYhwzDk4uIiHx8fSdKlS5eUkpJyvROLRa+99po6d+6cM1XfhVJT03ThwuUst3d1tcrHx1O/TZqgK8eO5mJluFNFyldQtVde1cWLl3N1oob0Y+Dn3ybo8hWOgbuJZ5EKCq6W+8cAAABwPiVKeOb8rIk3+v333/X2228rLS1NwcHBGjBggOrXr287Q5WUlKSdO3dq5syZ2rt3r95++23VqVPHNvMhAAAAABRUDk/WsXDhQqWlpalZs2ZatmyZmjRpYgthkuTu7q4mTZroo48+UrNmzZSamqoPP/wwR4oGAAAAgPzM4SC2e/duWSwWvfrqq3JxcblpOxcXF9tNn3ft2uVodwAAAADgNBwOYufOnZOXl5dtavhbqVChgry9vXXu3DlHuwMAAAAAp+FwECtcuLASExNtE3LcSkpKihITE1W4cGFHuwMAAAAAp+FwEPP391dKSkqGmyhnZsOGDUpOTpa/v7+j3QEAAACA03A4iLVt21aGYWjcuHGKjo6+abvvv/9e48aNk8ViyXBPLwAAAAAoiByevv7ZZ5/VqlWrdOjQIfXs2VO1atVSw4YNVbp0aUnSqVOnFB0drb1798owDD3wwAN65plncqxwAAAAAMivHA5i7u7u+uCDDzRo0CDt27dPe/bs0d69e+3apN8rOjg4WNOnT7eb3h4AAAAACiqHg5gklS5dWsuXL9eGDRv05Zdfav/+/Tp//rwkydfXVzVq1FBERITatGkjq9XhUZAAAAAA4FSyFcQkyWq1KiIiQhERETlRDwAAAAA4PU5TAQAAAIDJCGIAAAAAYDKCGAAAAACYjCAGAAAAACYjiAEAAACAyQhiAAAAAGAyghgAAAAAmIwgBgAAAAAmc/iGzlFRUZKkxx9/XPfee2+OFQQAAAAAzs7hIDZjxgy5uLiob9++OVkPAAAAADg9h4OYj4+PUlNT5ebmlpP1AAAAAIDTc/gasSpVqig+Pl4XL17MyXoAAAAAwOk5HMQ6deqktLQ0LVq0KAfLAQAAAADn5/DQxDZt2qhHjx6aO3eukpOT9fzzz6tEiRI5WRsAAAAAOCWHg1i3bt0kSR4eHlq4cKE+/PBDVaxYUb6+vrJaMz/RZrFY9OGHHzraJQAAAAA4BYeD2A8//GD3ODU1VUeOHNGRI0duuo3FYnG0OwAAAABwGg4HsYEDB+ZkHQAAAABQYBDEAAAAAMBkDs+aCAAAAABwDEEMAAAAAEzm8NDEdImJiVqxYoW2b9+uEydO6OrVq9qyZYttfXx8vL755htZLBZ16NAhu90BAAAAQL6XrSB24MABvfDCCzp16pQMw5CUcWbEokWLatasWTpy5Ih8fX3VoEGD7HQJAAAAAPmew0MTL168qD59+ujkyZOqVq2aRowYoaJFi2ZoZ7FY9MQTT8gwDH311VfZKhYAAAAAnIHDQWzRokU6e/asGjRooBUrVqhHjx4qXLhwpm2bNm0qSdq7d6+j3QEAAACA03A4iH399deyWCx6+eWXZbXeejf+/v5ydXXVP//842h3AAAAAOA0HA5iR48elZubm6pWrXrbthaLRUWLFtXly5cd7Q4AAAAAnIbDQcwwDLm4uGSYnONmba9cuSIPDw9HuwMAAAAAp+FwECtdurSuXr2q8+fP37btL7/8oqSkJJUvX97R7gAAAADAaTgcxOrVqydJWrVq1W3bRkVFyWKxqGHDho52BwAAAABOw+Eg1q1bN1ksFs2ZM0fff/99pm3OnTunYcOGadu2bXJzc1Pnzp0dLhQAAAAAnIXDN3R+4IEHNHToUL333nvq1auXqlatqvj4eEnSsGHDdPz4cf36669KSUmRJL366qsqW7ZszlQNAAAAAPmYw0FMknr37q3ixYtr0qRJ+u2332zL169fL8MwJEne3t4aPXq0HnnkkWwVCgAAAADOIltBTJKefPJJRUREaNOmTfrf//6nM2fOKDU1VSVLllTt2rXVtm1beXl55UStAAAAAOAUsh3EJMnT01OPPvqoHn300ZzYHQAAAAA4NYcn6wAAAAAAOCZHzohJ0qFDh7R//37bfcV8fX1Vo0YNPfDAAznVBQAAAAA4hWwHsa+//lr/+c9/9Oeff2a6/v7779eQIUPUokWL7HYFAAAAAE4hW0MTo6Ki9MILL+jQoUMyDEMuLi7y9fWVr6+vXFxcZBiGDh06pIEDByoyMjKnagYAAACAfM3hM2Lbtm1TVFSUJKlu3brq37+/QkND5e7uLklKSkrSjz/+qNmzZ+uHH37QzJkzVatWLTVu3DhnKgcAAACAfMrhM2KLFi2SJLVt21aLFy9Ww4YNbSFMktzd3dWwYUN9+OGHatu2rQzDsG0DAAAAAAWZw0Fs//79slgsGjVqlCwWy03bWSwWjRw5UpL0yy+/ONodAAAAADgNh4NYcnKyvL29Vbp06du2LVOmjIoVK6bk5GRHuwMAAAAAp+FwECtfvrwuX76spKSk27ZNSkrS5cuXVaFCBUe7AwAAAACn4XAQe+ihh5SSkqLPPvvstm0/++wzpaSkqEOHDo52BwAAAABOw+Eg1qNHD9WpU0fjx4/Xp59+etN2a9as0fjx4xUaGqqePXs62h0AAAAAOI0sTV+fPk39v4WGhurgwYMaPXq0IiMjVa9ePds1Y6dPn9YPP/ygkydPysvLS3Xq1NHs2bM1cODAnKseAAAAAPKhLAexW82MaBiGTpw4kWGYomEYkqT4+HjNnTtXkghiAAAAAAq8LAWxunXr5nYdAAAAAFBgZCmILVmyJLfrAAAAAIACw+HJOgAAAAAAjiGIAQAAAIDJCGIAAAAAYLIsXSN2K9HR0Vq/fr3++OMPxcbGKiUl5aZtLRaLtmzZkt0uAQAAACBfcziIpaSkaMSIEVq/fr2k/5uq/lZuNQU+AAAAABQUDgexefPmad26dZKu39g5PDxcvr6+cnXN9kk2AAAAAHBqDqemNWvWyGKxqF+/fnrxxRdzsiYAAAAAcGoOT9Zx8uRJWSwW9enTJyfrAQAAAACn5/AZsRIlSujKlSvy8PDIyXoAAAAAwOk5fEYsNDRU8fHxOnXqVE7WAwAAAABOz+Eg1qdPHxUuXFiTJ0/OyXoAAAAAwOk5HMQCAgI0depUbdu2Tc8//7x27dqlK1eu5GRtAAAAAOCUsjXXfOPGjdWlSxfNmjVLO3bsuG17i8Wi3377LTtdAgAAAEC+53AQS0xMVJ8+ffTjjz9KytoNnQEAAAAA2Qhic+bM0e7du+Xi4qIOHTooPDxc99xzj1xcXHKyPgAAAABwOg4HsXXr1slisWj06NHq3LlzTtYEAAAAAE7N4ck6Tp8+LRcXFz355JM5WU+mvvzyS/Xv319NmjRRrVq11LFjR61cuTLDcMgVK1aoTZs2CgoK0sMPP6yvv/46w77i4+M1evRo1atXTyEhIRo8eLDOnDmT688BAAAAANI5HMR8fX3l4eEhd3f3nKwnU4sWLZKHh4dGjhypWbNmqUmTJhozZoxmzJhha7Nu3TqNGTNG7dq107x581SrVi0NHDhQe/futdvXkCFDtGPHDr3xxhuaMmWKjhw5ot69eyslJSXXnwcAAAAASNkYmtioUSOtWrVKMTEx8vf3z8maMpg1a5ZKlChhe9ygQQNdunRJCxcu1AsvvCCr1arp06erffv2GjJkiCSpfv36OnjwoGbMmKF58+ZJkvbs2aPt27dr/vz5Cg8PlyT5+fkpIiJCmzZtUkRERK4+DwAAAACQsnFG7IUXXpCXl5cmTJig5OTknKwpgxtDWLqqVasqISFBV65c0dGjR/XXX3+pXbt2dm0iIiIUHR2tpKQkSdK2bdvk7e2tRo0a2dr4+/uratWq2rZtW64+BwAAAABIl637iE2YMEGvvvqqHnvsMfXo0UNBQUHy9PS85TZly5bNTpc2P/30k0qXLq2iRYvqp59+knT97NaNKleurOTkZB09elSVK1dWTEyM/Pz8ZLFY7Nr5+/srJiYmR+oCAAAAgNtxOIi1aNHC9u/4+Hi9+uqrt90mp27o/OOPP2r9+vUaMWKEJCk2NlaS5O3tbdcu/XH6+ri4OHl5eWXYX7FixbR///5s1+XqmvUTjC4uDp+MhEly+z3iGLj78R4BAIDc4nAQc+QGzjlx0+dTp05p6NChCgsLU7du3bK9v5xitVrk43Prs4HIX7y9PfK6BOQxjgEAAJBbHA5iW7duzck6siQuLk69e/dW8eLFFRkZKav1+v9WFytWTNL1M3MlS5a0a3/jem9vb506dSrDfmNjY21tHJWWZigu7kqW27u4WPmSd5eLi0tUamparu2fY+Dul9vHAAAAcD7e3h5ZGlXjcBArV66co5s65OrVq+rbt6/i4+P1ySef2A0xTJ+18d8zOMbExMjNzU0VKlSwtYuOjpZhGHbXiR05ckQBAQHZrjElhS9sziQ1NY33tIDjGAAAALklX1wAkZKSoiFDhigmJkYffPCBSpcubbe+QoUKuu+++7Rhwwa75evXr1eDBg1s9zpr0qSJYmNjFR0dbWtz5MgR/fbbb2rSpEnuPxEAAAAAUDZnTTTLuHHj9PXXX2vkyJFKSEiwu0lztWrV5O7urkGDBmn48OGqWLGiwsLCtH79eu3bt09Lly61tQ0JCVF4eLhGjx6tESNGqFChQpo6daoCAwPVunXrPHhmAAAAAAoih4PYmjVrHNrukUceueNtduzYIUl65513MqzbunWrypcvrw4dOigxMVHz5s3T3Llz5efnp6ioKIWEhNi1nzZtmiZOnKixY8cqJSVF4eHheu211+Tqmi8yKQAAAAAnYDEcnMqwSpUqGe7HddvOcmj6+rtRamqaLly4nOX2rq5W+fh46rdJE3Tl2NFcrAx3qkj5Cqr2yqu6ePFyrl4flH4M/PzbBF2+wjFwN/EsUkHB1XL/GAAAAM6nRAnP3J2s43Y3Zk5ISLDNWujh4SEfHx9HuwIAAAAAp+JwEPvqq69u2+avv/7SrFmztGHDBg0fPlwRERGOdgcAAAAATiNXL4y677779O6778rV1VUjRoyQn5+fqlatmptdAgAAAMBdz5Tp6wcNGqTk5GTNmTPHjO4AAAAA4K5mShArU6aMvL29tXv3bjO6AwAAAIC7milztl+7dk0JCQlMEQ8AAAAAMumM2KpVq5SWlqbSpUub0R0AAAAA3NUcPkV14sSJW66/du2aTp06pY0bN2rVqlWyWCxq2bKlo90BAAAAgNNwOIi1aNEiy20Nw9ADDzygF154wdHuAAAAAMBpOBzEDMPIUruKFSuqffv26t27t4oUKeJodwAAAADgNBwOYlu3br31jl1d5e3tLQ8PD0e7AAAAAACn5HAQK1euXE7WAQAAAAAFhimzJgIAAAAA/g9BDAAAAABMluWhibt3786RDuvWrZsj+wEAAACA/CrLQaxr166yWCzZ6sxisei3337L1j4AAAAAIL+7o8k6sjplPQAAAADg5rIcxG43XX1mLly4oJkzZ+qbb74hxAEAAADA/5flIHYn09UnJiZqwYIFWrhwoS5fvizDMOTv76+XXnrJoSIBAAAAwJk4fB+xzKSmpmr58uWaNWuWzp8/L8MwVKZMGQ0cOFCPPfaYrFYmaQQAAACAHAti69at0/vvv6+jR4/KMAwVK1ZMvXv3VteuXVWoUKGc6gYAAAAA8r1sB7Ht27frP//5jw4cOCDDMFS4cGF16dJFffr0kbe3d07UCAAAAABOxeEg9ssvv+i9997Trl27ZBiGXFxc9Nhjj2ngwIEqXbp0TtYIAAAAAE7ljoPY33//rf/85z/atGmTbSbEVq1aaejQofL398/xAgEAAADA2WQ5iJ09e1ZRUVFatWqVUlJSJEl169bV8OHDFRwcnGsFAgAAAICzyXIQa9Wqla5duybDMFSlShW99NJLatKkSW7WBgAAAABOKctB7OrVq7JYLLJYLIqLi9O4cePuuDOLxaItW7bc8XYAAAAA4Ezu6Bqx9GvCTpw44VBnFovFoe0AAAAAwJlkOYgNHDgwN+sAAAAAgAKDIAYAAJCHrFaLrFZGDd2t0tIMpaUZeV0GnFC2b+gMAAAAx1itFhUv7ikXF4LY3So11dClS5cJY8hxBDEAAIA8YrVa5OJi0eIFMTp18mpel4N/KXNvYXXr6S+r1UIQQ44jiAEAAOSxUyev6tjRK3ldBgATWfO6AAAAAAAoaAhiAAAAAGAyghgAAAAAmIwgBgAAAAAmI4gBAAAAgMkIYgAAAABgMoIYAAAAAJiMIAYAAAAAJiOIAQAAAIDJCGIAAAAAYDKCGAAAAACYjCAGAAAAACYjiAEAAACAyQhiAAAAAGAy17wuAAAKMqvVIqvVktdlIBNpaYbS0oy8LgMA4KQIYgCQR6xWi4r7eMjF6pLXpSATqWmpunQxkTAGAMgVBDEAyCNWq0UuVhctiFmsk1dP5XU5uMG9hcuop383Wa0WghgAIFcQxAAgj528ekpHrxzL6zIAAICJmKwDAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwmWteFwAAAAAUdFarRVarJa/LQCbS0gylpRk5vl+CGAAAAJCHrFaLfIoXkdWFwWp3o7TUNF28dCXHwxhBDAAAAMhDVqtFVherYhYc1NWTiXldDm5Q+F4P+fcMkNVqIYgBAAAAzujqyURdOXo5r8uASTj/CQAAAAAmI4gBAAAAgMkIYgAAAABgMoIYAAAAAJiMIAYAAAAAJiOIAQAAAIDJCGIAAAAAYDKCGAAAAACYjCAGAAAAACYjiAEAAACAyfJFEPv77781duxYdezYUdWqVVOHDh0ybbdixQq1adNGQUFBevjhh/X1119naBMfH6/Ro0erXr16CgkJ0eDBg3XmzJncfgoAAAAAYJMvgtihQ4f07bffqlKlSqpcuXKmbdatW6cxY8aoXbt2mjdvnmrVqqWBAwdq7969du2GDBmiHTt26I033tCUKVN05MgR9e7dWykpKSY8EwAAAACQXPO6gKxo3ry5WrZsKUkaOXKk9u/fn6HN9OnT1b59ew0ZMkSSVL9+fR08eFAzZszQvHnzJEl79uzR9u3bNX/+fIWHh0uS/Pz8FBERoU2bNikiIsKcJwQAAACgQMsXZ8Ss1luXefToUf31119q166d3fKIiAhFR0crKSlJkrRt2zZ5e3urUaNGtjb+/v6qWrWqtm3blvOFAwAAAEAm8kUQu52YmBhJ189u3ahy5cpKTk7W0aNHbe38/PxksVjs2vn7+9v2AQAAAAC5LV8MTbyd2NhYSZK3t7fd8vTH6evj4uLk5eWVYftixYplOtzxTrm6Zj3Xurg4RQZ2arn9HnEM3P04BsB7hNzGMZY/8PsAufEeOUUQuxtYrRb5+HjmdRnIQd7eHnldAvIYxwA4BgBIfBYgd44BpwhixYoVk3R9avqSJUvalsfFxdmt9/b21qlTpzJsHxsba2vjqLQ0Q3FxV7Lc3sXFyg/1XS4uLlGpqWm5tn+OgbsfxwBy+xgA+BzIH/h9gDs5Bry9PbJ0Bs0pgpi/v7+k69eApf87/bGbm5sqVKhgaxcdHS3DMOyuEzty5IgCAgKyXUdKCr+snUlqahrvaQHHMQCOAQASnwXInWPAKQakVqhQQffdd582bNhgt3z9+vVq0KCB3N3dJUlNmjRRbGysoqOjbW2OHDmi3377TU2aNDG1ZgAAAAAFV744I5aYmKhvv/1WknT8+HElJCTYQle9evVUokQJDRo0SMOHD1fFihUVFham9evXa9++fVq6dKltPyEhIQoPD9fo0aM1YsQIFSpUSFOnTlVgYKBat26dJ88NAAAAQMGTL4LY+fPn9eKLL9otS3+8ePFihYWFqUOHDkpMTNS8efM0d+5c+fn5KSoqSiEhIXbbTZs2TRMnTtTYsWOVkpKi8PBwvfbaa3J1zRcvBQAAAAAnkC/SR/ny5fXHH3/ctt2TTz6pJ5988pZtvLy89Pbbb+vtt9/OqfIAAAAA4I44xTViAAAAAJCfEMQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGSueV0AAAAFmdVqkdVqyesycBNpaYbS0oy8LgOAEyKIAQCQR6xWi4r7eMqFIHbXSk0zdOniZcIYgBxHEAMAII9YrRa5WC1acDBGJxOv5nU5+Jd7PQqrZ4C/rFYLQQxAjiOIAQCQx04mXtXRy1fyugwAgImYrAMAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMVyCB2+PBh9ejRQ7Vq1VKjRo00adIkJSUl5XVZAAAAAAoI17wuwGyxsbF67rnndN999ykyMlKnT5/WO++8o6tXr2rs2LF5XR4AAACAAqDABbHly5fr8uXLioqKUvHixSVJqampGjdunPr27avSpUvnbYEAAAAAnF6BG5q4bds2NWjQwBbCJKldu3ZKS0vTjh078q4wAAAAAAVGgQtiMTEx8vf3t1vm7e2tkiVLKiYmJo+qAgAAAFCQFLihiXFxcfL29s6wvFixYoqNjXV4v1arRSVKeGa5vcVy/e8H+g+WkZricL/IeRaX6z8WxYp5yDBysZ//fwxUfWCwDINj4G5isZh7DAx+oL9SjNTc6wh3zNXiIsnEY6DqA0rJzY7gENf//wbl5nGQfgz0H/yAUlM4Bu42Lq65fwxIN3wvHFxVBsfBXcXiwDFgtVqy1K7ABbHcYrFY5OKStRf9Rm5eXrlQDXKC1WrOCWN3N46Bu5VZx4AXx8Bdy7RjwN3NlH7gGDOOAy8vjoG7mVmfBW5e7qb0gzuXG8dAgRua6O3trfj4+AzLY2NjVaxYsTyoCAAAAEBBU+CCmL+/f4ZrweLj43X27NkM144BAAAAQG4ocEGsSZMm+v777xUXF2dbtmHDBlmtVjVq1CgPKwMAAABQUFgMo2BdHRwbG6v27dvLz89Pffv2td3Q+aGHHuKGzgAAAABMUeCCmCQdPnxYb731lvbs2SNPT0917NhRQ4cOlbs7F0gCAAAAyH0FMogBAAAAQF4qcNeIAQAAAEBeI4gBAAAAgMkIYgAAAABgMoIYAAAAAJiMIAYAAAAAJiOIAQAAAIDJCGIAAAAAYDLXvC4AuS8wMPC2bSZOnKjHHnssS/vbtWuXunXrppUrVyooKEiSFBkZqUaNGql27dp2bW+2HDknMjJSUVFRGZY/8MAD+uKLL0yro3nz5nrwwQc1duxYU/pbvXq1Ro0apejoaJUoUcKUPu8mkZGRWrBggfbs2ZNj+9y1a5f27Nmjfv365dg+kTey+rlfrly5DJ/nd5MDBw7okUce0eLFixUWFpbX5eQ7Xbt21blz5/TZZ5/J3d3dbt3gwYP1888/a/369fL09MxWHz/88MMt2zz66KN65513brufIkWKaM6cOQ7XgjuT1c+JTz/91O69ud3vn5z43pkbv+PuRgSxAuCTTz6xe9ypUyd17dpVHTp0sC2rWLFilvdXvXp1ffLJJ6pcubJtWVRUlIoUKZIhcN1sOXJW4cKF9eGHH2ZYBtyJH374QQsWLCCIOYGsfu4fOnTI7NJgonHjxqljx4764IMP9MILL9iWb9u2TRs3btSMGTOyFcIk6fXXX1dCQoJdn4ULF9aIESNsywrif5blB1n9nKhZs6as1qwPosvp753OjCBWANSqVSvDsnvvvTfT5VlRtGhRh7fNrqtXrxIwMmG1WvPsPQGyi5/rnJfTn/v/ZhiGkpOTM5xlwd3F399fffv21ezZs/XQQw+pQoUKunbtmt566y21aNFCLVu2zHYf999/v93jokWLqkiRIvxOygey+jlxp0E6tz9/nAnXiBVwa9asUY0aNXT16lXbsoceekjVqlWz+x+uTp06ady4cZKuD18KDAzUL7/8Iun/TkFPmjRJgYGBCgwMtLXJbLl0/Zf4/Pnz1aZNG9WoUUMtWrTQokWL7GqLjIxUSEiI9u3bp06dOikoKEgfffRRrr0WzubKlSt688031aZNGwUHB6t58+YaO3as4uPjM7Rds2aNHnnkEQUFBSksLEy9e/fW8ePHbetPnTql4cOHKywsTDVr1lTnzp21f//+TPv94IMP1LhxYwUHB6t///46c+aM3fpLly5p1KhRtn09/fTT2r17d4b9LF++3HZ8NG/eXDNnzlRaWtotn/OqVatUo0YNrVixIisvkdM4duyYAgMD9dlnn+nNN99U3bp1FR4ernfffVcpKSm2dqdOndKLL76ohg0bKigoSM2bN9fbb78t6f+GuF65csX289q1a1dJ0uHDhzV06FA1bdpUwcHBioiI0IIFCzK8H6dOnVLfvn0VHByspk2batGiRZowYYKaN29ua7N69WoFBgZqz5496tGjh2rVqqVJkyZJkhYsWKDHH39cderUUYMGDdS3b18dOXLEro+RI0eqQ4cO+v777/XQQw+pZs2a6tKli44dO6ZLly7pxRdfVO3atdWyZUutX78+V15vZxQXF6dhw4YpJCREzZo107x58+zWp7/u3377rR5++GEFBQXpq6++kiTt2bNH3bp1U61atVSnTh0NGzZM58+ft9t+ypQpeuihhxQSEqLGjRvrpZdeyvDZIEkzZ85Uo0aNFBISooEDB2bYjyStXLlS7du3V82aNRUWFqZnnnlG+/bty8FXw7n06dNHZcuWtf0Onz17ts6dO6exY8fqjz/+UK9evWzv3eDBg3XixAnbtumfLRs2bLDb579/rm8l/Xf5v4WGhioyMjLD8jVr1qhly5aqWbOmunbtqpiYGLv1Wfn+gJzVtWtX9e3b95ZtoqKiFBwcrG+//fa2+0tLS9PMmTPVvHlz1ahRQ23bttXy5ctvu92d9JFfcEasgKtbt66Sk5O1d+9e1a9fXxcvXtShQ4fk7u6un376SU2bNlViYqJ+/fVXPffcc5nu45NPPslw2vn++++/6XLp+of4ihUr1K9fPwUHB+t///ufpkyZokKFCumZZ56x7Ts5OVnDhg1T9+7dNXToUBUvXjx3X5B87MYv3NL1swypqakaOnSoSpQooZMnT2r27Nl64YUXtGTJElu7Dz74QJMnT9YTTzyhoUOHKjk5WTt37tSFCxdUrlw5xcbG6tlnn1WRIkU0ZswYeXl5acmSJXruuee0adMm+fr62va1efNmlStXTm+88Ybi4uI0ZcoUDRo0yDZMITU1Vb1799bRo0c1fPhw3XPPPVqyZIl69Oih5cuXq0aNGpKkJUuWaPz48eratasefPBB7dmzR1FRUYqPj7cb7nKjJUuW6N1339W7776r9u3b5/TLmy9MmzZNLVq00LRp07Rnzx5FRkaqYsWKtp+pV155RWfOnNFrr70mX19fnTx50haon3zySZ06dUpffPGFbZhr0aJFJUlnzpyRn5+fHnroIXl6eurAgQOKjIzUlStXNHDgQEnXvxy98MILOnfunMaNGycvLy/Nnz9fJ06cyHRIy7Bhw9SpUyf17dtXHh4ekq4HuS5duqhs2bJKSEjQ8uXL9fTTT2vjxo12P/tnz57VO++8o/79+8vV1VXjx4/X8OHD5eHhodDQUD311FP673//q5dfflnBwcEqV65crr3mzuL1119Xx44dNWPGDG3ZskVTpkxRYGCgmjRpYmtz5swZjR8/Xv3799e9996rsmXLas+ePeratauaNm2qqVOnKjExUdOmTdMLL7xgNzzp/Pnz6tu3r0qVKqULFy5o4cKF6tq1q9atWydX1+tfRZYuXar3339fPXv2VMOGDfX999/r1Vdftatz9+7devXVV9WzZ081bdpUV69e1b59+zL9DyZc5+7urjfffFNdu3bVzJkz9cEHH2jYsGEyDENdunRRhQoVNHnyZF27dk1Tp05Vly5d9Pnnn9t+/s3066+/6p9//tGwYcMkXf9Me/7557Vhwwbb2desfn+Aed59910tX75cc+fOzdK1nJMmTdLixYvVv39/hYSE6JtvvtHrr7+ulJQUdenSJUf6yDcMFDgBAQHGBx98YHv84IMPGpGRkYZhGMbmzZuNxo0bGwMGDDAmT55sGIZh7NixwwgICDBOnz5tGIZh7Ny50wgICDD27dt3033eavnff/9tBAYGGsuXL7dbPnnyZKNRo0ZGamqqYRiGMX36dCMgIMBYt25dDjxr55X+Ov37z5o1a+zaJScnGz/++KMREBBgxMTEGIZhGHFxcUZwcLAxZsyYm+7//fffN+rUqWOcO3fOtuzatWvGgw8+aLz77ru2Zc2aNTNCQkKMuLg427Lvv//eCAgIMLZt22YYhmFs2bLF7rFhGEZSUpLx4IMPGgMHDjQMwzBSUlKMsLAwY+jQoXZ1vPfee0b16tWNCxcuGIZhGKtWrTICAgKM8+fPG7NnzzZq1KhhbNmy5Y5eu/xs+vTpRq1atQzDMIyjR48aAQEBxuDBg+3adOnSxXjuuedsj2vVqmUsXrw4S/u8mbS0NCM5OdmYNWuW0ahRI9vyb775xggICDB2795tW5aQkGDUqVPHaNasmW1Z+vs2Z86cW/aTkpJiJCYmGrVq1bL7rBgxYoQRGBhoHDx40LZsyZIlRkBAgO0zyzAMIzY21qhataqxaNGiW/ZTUNzsMzr98/zGn+W0tDSjWbNmxujRo23LRowYYQQEBBh79+61275z585Gp06djLS0NNuyQ4cOGYGBgcY333yTaS0pKSnGqVOnjICAAOO7776zLQsPDzdefvllu7Yvv/yyERAQYOzcudMwDMP44IMPjHr16t3hs4dhGMbIkSONgIAA49FHHzVSUlKMt99+26hVq5Zx8eJFW5s///zTCAwMtH1OpH+2fPnll3b7Gj9+vN3P9Y26dOli9OnTx/b4Zp8rderUMaZPn263XZUqVYwjR47Ylv31119GlSpVjI8//tgwjKx/f4BjbvY5cbP3NC0tzRg7dqxRt27dDJ8NN9vv+fPnjerVqxtTpkyxa/PSSy8Z9evXN1JSUhzqI79iaCIUGhpqGxq2e/du1a1bV3Xr1rVbVqlSJZUqVSpH+vv+++8lSa1bt1ZKSortT8OGDXX27FmdPHnSrn3Tpk1zpF9nVrhwYa1cudLuT9OmTW1DDkNCQlS9enU9++yzkqS//vpL0vUhRYmJiXriiSduuu8dO3YoLCxMxYoVs71XVqtVdevWtQ1PTRcWFiYvLy/b4wYNGqh48eL6+eefJUk//vijihYtqsaNG9vauLm5qVWrVvrpp58kSTExMbp48aLatm1rt++IiAglJydnGII0bdo0zZ49W3PmzFGLFi3u8JVzLuHh4XaPK1eurFOnTtkeV6tWTQsWLNCyZcv0999/Z3m/165d0/Tp09WqVSsFBQWpevXqmjp1qs6ePavLly9Lkn755Rd5e3srNDTUtp2np6caNGiQ6T4ffPDBDMv27t2rHj16KCwsTNWqVVNwcLCuXLliO17TlSpVSg888IDt8X333SdJatiwoW2Zt7e3SpQoYff8cXM3HjsWiyXDsSNJxYsXV3BwsO1xYmKi/ve//6lt27ZKTU21fT7cd999uvfee+0+H7799ls9/fTTqlOnjqpVq2Y705b+3p46dUpnzpxRq1at7Pps06aN3eNq1arp0qVLGjlypHbs2KHExMQcef4FQZ8+fSRJPXr0kIuLi3788UeFhYXZnW2uXLmyqlSpYvs8NtsDDzxg+3mWpEqVKqlKlSq23yF3+v0BuccwDL3yyivavHmzFi9ebPfZcCv79u1TcnJyht/x7dq104ULF+w+7x3tIz9haCJUr149TZgwQcnJydq9e7eefPJJBQcHa/LkyUpMTNSPP/5o9+Uquy5evCjDMFS/fv1M1588edI2lMjDwyPbMzoVBFarNcPU05s3b9aIESPUqVMn27DOs2fPasCAAbp27Zqk69drSbplyL548aL27t2r6tWrZ1j371mPbhymmK5EiRI6e/aspOvXoWTW5p577lFsbKwk2f7+d7v0x+nr023cuFEBAQGqU6fOTZ9DQXFjCJauh9ykpCTb46lTp2rq1KmaNm2axo0bJz8/P7300ktq3br1Lfc7efJkrVixQgMGDFCNGjXk5eWlrVu3atasWbp27Zo8PT115syZTC/ovtlF3vfcc4/d4xMnTqhnz56qUaOGxo0bp1KlSsnNzU19+/a1Ha/pvL29MzzPzJ6/u7t7hm2RucyOnX8P9/v3exYXF6fU1FRNnDhREydOzLDP9C/F+/bt0wsvvKAWLVqod+/e8vX1lcVi0VNPPWV7f9I/I/59vPy7zwYNGtiGNfXq1UuFChVSmzZtNHr0aIau30b6z0n633FxcapatWqGdr6+vhk+Z82S2e8HX19f2/FxJ98fkLuSk5P11VdfqWHDhgoICMjydunH1r9/ttMfp38vyU4f+QlBDAoNDVViYqJ27dql33//XXXr1pW/v78KFy6sXbt26eeff9ajjz6aY/0VK1ZMFotFy5Yts/1CuJGfn5/t3xaLJcf6LWg2bNigqlWr6s0337Qt+/e9XtK/uJw5c0ZlypTJdD/FihVT48aN9eKLL2ZY9+8Z0zK7sP7ChQsqWbKkbV+ZtTl37pyKFStmV9OFCxcy3Xd6u3QzZ87UoEGDNGjQIM2YMSPTYwrXlSpVShMnTlRaWpr279+vWbNmaejQodqwYYMqVKhw0+02bNigTp062f5HXVKGi6XTr/35t8yWZea7777TlStXFBUVZQtaKSkpefaFEBn9+/PYy8tLFotFffv2zXT2PR8fH0nSli1bVLRoUU2bNs12veCNkwFJsn1G/Pt4OXfuXIb9duzYUR07dtSFCxe0detWTZw4Ua6urraJZ5A1N/s8Pn/+vO2sVKFChSRd/0J8o7i4uCz3U6hQoQzbJycn68qVK5n2ndmyKlWq2GrO6vcH5C53d3fNmTNHvXv31htvvGH3XeNW0n/Hnz9/XqVLl7YtT/9Zv/E/VBztIz9haCLk5+enkiVLas6cOSpWrJjuv/9+Wa1W1alTR/Pnz9e1a9dUt27dW+7Dzc0t0/95zmx5+lClS5cuKSgoKMOfvLhA2BldvXo1wy+qtWvX2j0OCQmRh4eHVq1addP9NGzYUIcPH1blypUzvFf/vmnjrl277P4XPTo6WpcuXbINJ6hTp44SEhK0fft2W5uUlBRt2bLFdkbLz89PJUqUyDBL15dffik3NzfVrFnTbrmfn58WLlyon3/+WcOGDVNqaurtXpoCz2q1qmbNmhoyZIhSUlJswxT/fQYt3bVr1+yOpdTUVK1bt86uTVBQkOLi4uxmwLx8+bKio6OzVNPVq1dlsVhsEzdI19/zf09Cg7tH+hTlMTExmX6Wly9fXtL/fRbdGOT+/VlUpkwZlSxZUps3b7ZbvnHjxpv2X6JECT355JNq1KhRhpn1cHt16tTRzp077f6zIyYmRn/88Yft89jX11dubm46fPiwrU1SUlKmM93eTOnSpZWcnKx//vnHtmznzp2ZflYfOnTIbtj033//rd9//932O4TvD3eX0NBQzZw5U2vWrNGECROytE1QUJDc3Nwy/R3v6+trNzTV0T7yE86IQdL1D+QNGzbYDVEKDQ3VlClTVKZMmVv+b7l0/V4lW7duVWhoqDw8POTn56eiRYtmutzPz0+dO3fWK6+8ol69eik4OFjJycn666+/tGvXLs2cOTO3n26B0LBhQ7355puaMWOGQkJC9O2332b4Uuzl5aUBAwZoypQpMgxDLVq0UFpamnbt2qX27dsrKChI3bt319q1a9WlSxd169ZNZcuW1YULF/Tzzz+rdOnS6t69u21/np6e6t27t3r37q34+HhNmTJFNWvWtF0T9uCDD6pmzZp6+eWXNWzYMNusiWfOnNH06dMlSS4uLnrhhRc0fvx4lShRQk2bNtXevXs1b948Pffcc7b/Zb9RYGCgFixYoOeee04jRozQpEmT7ujmkwVBfHy8evXqpY4dO8rPz0/JyclasmSJvL29Va1aNUnXrw9JSUnRhx9+qJCQENvPcMOGDbVixQrdf//98vHx0bJlyzIEtiZNmqh69eoaNmyYXnrpJXl7e+uDDz6Qp6dnls5spw81GjVqlJ5++mkdOnRICxcuzDAMEXeXV155Rc8995yGDBmi9u3by9vbW6dOndL333+vxx57TGFhYWrUqJE+/PBDvfXWW2rVqpX27Nmjzz77zG4/Li4u6tOnjyZMmCBfX181atRIO3bssN3yJN306dN16dIl1atXT76+vjp48KC+++47u88hZE337t21evVq9ezZU/3799e1a9c0bdo03XvvvbZRMFarVa1atdJHH32kSpUqycfHR0uXLpVhGFkesdKkSRMVKVJEr732mnr37q1Tp05p8eLFtrNtN/L19VW/fv00ePBgSdL777+v0qVL67HHHpMkvj/chRo0aKDIyEgNGDBAHh4eeumll27ZvkSJEurSpYvmz58vd3d31apVS99++62++OILjRkzRi4uLtnuIz8hiEHS9evENmzYYHctWL169SQpS9eHjR07Vm+//bZ69+6tq1evavHixQoLC7vp8tdee01+fn765JNPNGPGDHl6esrPzy/DxZtw3NNPP61jx45p6dKlmj9/vsLDw/Xee+/pqaeesmvXu3dvlShRQosWLdLq1avl6empkJAQ21h9Hx8fffLJJ5o2bZqmTJmiS5cuydfXV8HBwRkurG/VqpXKlCmj119/XXFxcWrYsKHt3jXS9S9bc+fO1aRJkzR58mRduXJF1atX14IFC2xT10vX71ni6uqqRYsW6eOPP1bJkiU1cOBA9evX76bPt3r16vrggw/Uo0cPjR07Vm+99RZDW29QqFAhBQQEaMmSJTp58qQKFy6sGjVqaP78+bbrcpo1a6Znn31Wc+fO1fnz51W3bl0tWbJEY8aM0euvv6633npLHh4eevTRR9WqVSu99tprtv1bLBbNnDlTY8eO1dixY+Xt7a1u3brpyJEjOnDgwG3rCwwM1MSJExUVFaW+ffuqatWqev/99zVkyJDcekmQA2rXrq1ly5YpMjJSo0aNUnJyssqUKaP69eurUqVKkq5PuDR8+HAtXbpUq1evVu3atTVnzpwME3F07dpVcXFxWrZsmT7++GM1aNBA48eP1/PPP29rExQUpA8//FBffvmlEhISVKZMGfXq1Uv9+/c39Xk7g3vvvVdLlizRpEmTNHz4cFmtVjVq1EgjR460O7M0ZswYjRkzRuPHj5enp6d69eolPz8/bd26NUv9+Pj4aPr06Xr33Xc1YMAAVa1aVZMmTbLdp/BG1atXV+vWrTV58mSdPXtWwcHBGjdunN0weL4/3H2aNm2qadOm6cUXX1ShQoU0YMCAW7Z/5ZVX5OXlpZUrV2r27NkqV66cxo0bp6effjrH+sgvLIZhGHldBADA+SQlJal9+/YKDQ3NdDIHAAAKMs6IAQByxCeffKK0tDT5+fkpLi5OH3/8sY4fP67//Oc/eV0aAAB3HYIYACBHFCpUSHPnzrXNiFelShXNmTMnw60VAAAAQxMBAAAAwHRMKwYAAAAAJiOIAQAAAIDJCGIAAAAAYDKCGAAAAACYjCAGAMi3IiMjFRgYmOnNYc20atUqderUSbVr11ZgYKACAwO1aNGiPK0JAHB3Y/p6AECei4yMVFRUVIbl7u7u8vHxUbVq1fTwww+rXbt2slgsuV7PgQMHtGXLFnl5eal79+63bLtgwQK9++67kiRXV1f5+vrKYrGoSJEiuV4nACD/IogBAO4q99xzj+3f8fHxOn36tE6fPq2vv/5an376qWbMmCF3d/dcreHAgQOKiopSuXLlbhvE5s+fL0nq2rWrRowYITc3t1ytDQDgHBiaCAC4q+zYscP2Z+/evfriiy/UqFEjSdK2bds0derUPK7w/1y4cEHnzp2TJD311FOEMABAlhHEAAB3LavVqgceeECzZs1SpUqVJEmffPKJUlJS8riy6xITE23/ZigiAOBOMDQRAHDXK1SokNq2bas5c+bo8uXLiomJUUBAwC23SUxM1NatW7Vt2zb98ccfOn36tBISElS8eHHVrFlTnTp1UtOmTTNsFxgYaPv38ePH7R5L0sCBA1WvXj1169bNbnmLFi1s/y5Xrpy++uoru/W7du3SRx99pD179ujixYvy9PRUlSpV9PDDD+uRRx6Ri4tLhlrSr52rV6+elixZoo0bN+qTTz7RgQMHdPHiRQ0YMECDBg3SyJEj9emnn+rRRx/VO++8o9WrV+uTTz7Rn3/+KavVqurVq2vAgAGqW7euJCklJUUff/yxPv30U/3111+yWCyqXbu2hgwZourVq9/ydQUA5AyCGAAgXyhdurTt3wkJCbdt/+WXX2rUqFGSJIvFoqJFi8rV1VVnz57V1q1btXXrVvXs2VMjRoyw2+6ee+7R1atXlZCQIKvVqhIlStitL1KkiNzc3HTPPfcoNTVVFy9elCT5+PjYwpSPj4/dNhMnTrTNomixWOTl5aX4+Hjt3LlTO3fu1Oeff64ZM2aoaNGiN30+77zzjhYuXCiLxSJvb29ZrZkPakkPZa6uripUqJDi4uIUHR2t3bt3KyoqSo0aNVL//v21fft2ubm5yc3NTZcvX9a2bdu0e/duLV26VDVq1Ljt6wsAyB6CGAAgXzh+/Ljt38WKFbtte29vb/Xs2VMtW7ZUtWrV5OHhIUk6c+aM/vvf/2r27NlasGCBQkND7c5m7dixQ6tXr9aoUaN07733ZjizdWO7Y8eO2bZduXKlypcvn6Hd0qVLbSGsU6dOGjRokEqWLKkrV67ov//9ryZPnqydO3dqzJgxN73+bf/+/frhhx/Uu3dv9ezZUyVKlFBSUpLOnj1r127r1q1KSkrSm2++qY4dO6pw4cKKiYnR8OHD9euvv+qtt95Ss2bNtH//fk2bNk0tW7aUq6urfv31Vw0dOlT//POPJkyYoI8//vi2ry8AIHu4RgwAcNdLSEjQ2rVrJUnFixeXn5/fbbdp2bKlRowYoTp16thCmCSVKlVKAwcO1NChQyVJS5YsyZ2iJV29elWRkZGSpA4dOujNN99UyZIlJV0/s9a9e3eNHDlSkrR+/Xrt378/0/1cuXJFPXr00PDhw21n6Nzd3VWuXDm7dnFxcXrrrbfUqVMnFS5cWJLk7++vadOmSboeZpcuXaoZM2aoXbt2cnNzk8ViUY0aNfTmm29Kkv73v//p1KlTOftCAAAyIIgBAO5a6cPqunXrpjNnzki6Pk38zYbl3YkHH3xQkrR3716lpqZme3+Z2bFjhy5duiTp+rVlmXn22Wdt4eyLL77ItI3ValXv3r1v21/ZsmX10EMPZVhesWJF22QnoaGhCg0NzdCmXr16ttsC/PHHH7ftCwCQPQxNBADcVf49OcaNHn74YfXv3z/L+zp37pyWLVumHTt26K+//lJ8fHyG0JWYmKjY2NgM14LlhPQzXPfee+9Nz+K5uLiofv36Wrt27U3PiFWsWFG+vr637a9GjRo3veG1r6+v/v77bwUFBd20Dh8fH50+fVqxsbG37QsAkD0EMQDAXeXGGzq7u7vLx8dHVatW1UMPPaT69etneT979uxRnz59FBcXZ1tWpEgReXh4yGKx2E20ceM09Dnp/PnzkuwnGslMmTJl7Nr/W1ZCmCR5enredJ2rq2uW29wttwcAAGdGEAMA3FV27NiR7X2kpKRo2LBhiouLU9WqVTV06FDVqVPHblbCf/75R61atZIkGYaR7T5zU2ZT2wMA8jeCGADA6ezdu1fHjx+Xi4uL5syZk+kZqX/POJgb0s9k3W7yi/T1WT3zBQDI/5isAwDgdE6ePClJKlGixE2HBUZHR990+/TJQLJ7piz9flynTp3SkSNHMm2TmpqqXbt2SdJNr98CADgfghgAwOl4eXlJuj5Zx7lz5zKsP3Xq1C2nrU8fwnjj9WWOaNSokYoXLy5JioqKyrTN8uXLbTNCtm/fPlv9AQDyD4IYAMDp1KlTR0WKFJFhGBoyZIjtbFRqaqq+++47de3a9ZbbP/DAA5Ku379s/fr1DtdRuHBhDRo0SNL1qenHjh1rC4aJiYlavHixJk6cKEmKiIiwnUEDADg/ghgAwOl4eXnplVdekSTt3r1bbdu2VUhIiEJCQvT8888rPj7eFoAyU6lSJTVo0ECSNHToUNWuXVvNmzdX8+bNtWjRojuqpUuXLurevbsk6ZNPPlF4eLjq1aun0NBQTZgwQcnJyQoLC9Nbb73l0HMFAORPTNYBAHBKzzzzjMqWLasPPvhA+/fvV2pqqkqXLq2mTZuqd+/eSk5OvuX206dP14wZM/TNN9/o5MmTOn78uCQpPj7+jmsZNWqUmjVrpmXLlul///ufLl26JE9PT1WpUkUdO3bUI488wsyIAFDAWIy7fc5eAAAAAHAyDE0EAAAAAJMRxAAAAADAZAQxAAAAADAZQQwAAAAATEYQAwAAAACTEcQAAAAAwGQEMQAAAAAwGUEMAAAAAExGEAMAAAAAkxHEAAAAAMBkBDEAAAAAMBlBDAAAAABMRhADAAAAAJMRxAAAAADAZP8P6eGmj+9t8bkAAAAASUVORK5CYII=\n"
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Given that Twitter appears to be the main social media platform being used, as almost 600 out of the approximately 750 state actors in the dataset are on it, we will focus our anlysis on Twitter only.\n",
        "\n",
        "Filter out state actors that are on Twitter (i.e. drop rows that don't have Twitter Account URLs)"
      ],
      "metadata": {
        "id": "dNB8swse-SUT"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "twitter_df = original_df[original_df['X (Twitter) URL'].notna() & (original_df['X (Twitter) URL'] != '')]\n",
        "\n",
        "twitter_df = twitter_df.sort_values(by='X (Twitter) Follower #', ascending=False)\n",
        "\n",
        "## Dropping the rest of the social media accounts\n",
        "twitter_df = twitter_df.drop(['Facebook page', 'Facebook URL', 'Facebook Follower #',\n",
        "                              'Instragram page', 'Instagram URL', 'Instagram Follower #',\n",
        "                              'Threads account', 'Threads URL', 'Threads Follower #',\n",
        "                              'YouTube account', 'YouTube URL', 'YouTube Subscriber #',\n",
        "                              'TikTok account', 'TikTok URL', 'TikTok Subscriber #'], axis=1)\n",
        "\n",
        "twitter_df.head()"
      ],
      "metadata": {
        "id": "oVyHGhyHaF66",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "3b758bb8-93a6-47f8-ac5b-80f9b39dae90"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         Name (English) Region of Focus Language       Entity owner (English)  \\\n",
              "89                 CGTN     Anglosphere  English      China Media Group (CMG)   \n",
              "516  Xinhua News Agency           China  Chinese           Xinhua News Agency   \n",
              "416      People's Daily           China  Chinese         People's Daily Press   \n",
              "137         China Daily     Anglosphere  English            China Daily Press   \n",
              "461        Hua Chunying     Anglosphere  English  Ministry of Foreign Affairs   \n",
              "\n",
              "                              Parent entity (English) X (Twitter) handle  \\\n",
              "89                       Central Publicity Department       CGTNOfficial   \n",
              "516                                     State Council             XHNews   \n",
              "416  Central Committee of the Chinese Communist Party            PDChina   \n",
              "137                      Central Publicity Department         ChinaDaily   \n",
              "461                       Ministry of Foreign Affairs    SpokespersonCHN   \n",
              "\n",
              "                         X (Twitter) URL  X (Twitter) Follower # Western  \n",
              "89      https://twitter.com/CGTNOfficial              13000000.0      no  \n",
              "516           https://twitter.com/XHNews              11900000.0      no  \n",
              "416          https://twitter.com/PDChina               6600000.0      no  \n",
              "137       https://twitter.com/ChinaDaily               4100000.0      no  \n",
              "461  https://twitter.com/SpokespersonCHN               2200000.0      no  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a93d0a02-64c0-4fb9-80f6-62a6a7baae13\" 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>Name (English)</th>\n",
              "      <th>Region of Focus</th>\n",
              "      <th>Language</th>\n",
              "      <th>Entity owner (English)</th>\n",
              "      <th>Parent entity (English)</th>\n",
              "      <th>X (Twitter) handle</th>\n",
              "      <th>X (Twitter) URL</th>\n",
              "      <th>X (Twitter) Follower #</th>\n",
              "      <th>Western</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>89</th>\n",
              "      <td>CGTN</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Media Group (CMG)</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>CGTNOfficial</td>\n",
              "      <td>https://twitter.com/CGTNOfficial</td>\n",
              "      <td>13000000.0</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>516</th>\n",
              "      <td>Xinhua News Agency</td>\n",
              "      <td>China</td>\n",
              "      <td>Chinese</td>\n",
              "      <td>Xinhua News Agency</td>\n",
              "      <td>State Council</td>\n",
              "      <td>XHNews</td>\n",
              "      <td>https://twitter.com/XHNews</td>\n",
              "      <td>11900000.0</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>416</th>\n",
              "      <td>People's Daily</td>\n",
              "      <td>China</td>\n",
              "      <td>Chinese</td>\n",
              "      <td>People's Daily Press</td>\n",
              "      <td>Central Committee of the Chinese Communist Party</td>\n",
              "      <td>PDChina</td>\n",
              "      <td>https://twitter.com/PDChina</td>\n",
              "      <td>6600000.0</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>137</th>\n",
              "      <td>China Daily</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>China Daily Press</td>\n",
              "      <td>Central Publicity Department</td>\n",
              "      <td>ChinaDaily</td>\n",
              "      <td>https://twitter.com/ChinaDaily</td>\n",
              "      <td>4100000.0</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>461</th>\n",
              "      <td>Hua Chunying</td>\n",
              "      <td>Anglosphere</td>\n",
              "      <td>English</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>Ministry of Foreign Affairs</td>\n",
              "      <td>SpokespersonCHN</td>\n",
              "      <td>https://twitter.com/SpokespersonCHN</td>\n",
              "      <td>2200000.0</td>\n",
              "      <td>no</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a93d0a02-64c0-4fb9-80f6-62a6a7baae13')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-a93d0a02-64c0-4fb9-80f6-62a6a7baae13 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-a93d0a02-64c0-4fb9-80f6-62a6a7baae13');\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",
              "\n",
              "\n",
              "<div id=\"df-6ea60b5c-c20d-4ab6-9f99-408750aaf82d\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-6ea60b5c-c20d-4ab6-9f99-408750aaf82d')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-6ea60b5c-c20d-4ab6-9f99-408750aaf82d button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Data Wrangling with the Twitter DataSet"
      ],
      "metadata": {
        "id": "H7fXhxiK8uAj"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "After scraping tweets 10 days worth of tweets from about 150 of the available Twitter accounts using OctoParse, load the tweets, translate them if they are not in English, and perform sentiment analysis on them"
      ],
      "metadata": {
        "id": "I-avR3CR_TOj"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Download the VADER lexicon for sentiment analysis\n",
        "nltk.download('vader_lexicon')\n",
        "\n",
        "# Define functions for translating non-English tweets and calculating polarity and subjectivity\n",
        "def analyze_sentiment(text):\n",
        "    sia = SentimentIntensityAnalyzer()\n",
        "    if isinstance(text, str):\n",
        "        sentiment_score = sia.polarity_scores(text)['compound']\n",
        "        return sentiment_score\n",
        "    else:\n",
        "        return None\n",
        "    return sentiment_score\n",
        "\n",
        "def analyze_subjectivity(text):\n",
        "    # Check if the text is not NaN (not a float)\n",
        "    if isinstance(text, str):\n",
        "        blob = TextBlob(text)\n",
        "        subjectivity_score = blob.sentiment.subjectivity\n",
        "        return subjectivity_score\n",
        "    else:\n",
        "        return None\n",
        "\n",
        "def translate_tweets(text):\n",
        "  translator = GoogleTranslator(source='auto', target='en')\n",
        "  if isinstance(text, str):\n",
        "    return translator.translate(text)\n",
        "  else:\n",
        "    return None\n",
        "\n",
        "# Load the CSV file into a pandas DataFrame\n",
        "csv_file_path = 'tweets.csv'\n",
        "tweets_df = pd.read_csv(csv_file_path)\n",
        "\n",
        "# Translate the non-English tweets into English\n",
        "tweets_df['Content'] = tweets_df['Content'].apply(translate_tweets)\n",
        "\n",
        "# Perform sentiment analysis on tweets and add new columns with sentiment scores\n",
        "tweets_df['SentimentScore'] = tweets_df['Content'].apply(analyze_sentiment)\n",
        "tweets_df['SubjectivityScore'] = tweets_df['Content'].apply(analyze_subjectivity)\n",
        "\n",
        "tweets_df.to_csv(\"tweets_final.csv\", index=False)"
      ],
      "metadata": {
        "id": "T8Bu4G4w_jQH",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 425
        },
        "outputId": "5689562a-b2c7-4978-a1d8-07a4c433b1e8"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "[nltk_data] Downloading package vader_lexicon to /root/nltk_data...\n",
            "[nltk_data]   Package vader_lexicon is already up-to-date!\n"
          ]
        },
        {
          "output_type": "error",
          "ename": "FileNotFoundError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-33-2328c3240bec>\u001b[0m in \u001b[0;36m<cell line: 32>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     30\u001b[0m \u001b[0;31m# Load the CSV file into a pandas DataFrame\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     31\u001b[0m \u001b[0mcsv_file_path\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m'tweets.csv'\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 32\u001b[0;31m \u001b[0mtweets_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcsv_file_path\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     33\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     34\u001b[0m \u001b[0;31m# Translate the non-English tweets into English\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    209\u001b[0m                 \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    210\u001b[0m                     \u001b[0mkwargs\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mnew_arg_name\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnew_arg_value\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 211\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    212\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    213\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mcast\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mF\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mwrapper\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    329\u001b[0m                     \u001b[0mstacklevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mfind_stack_level\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    330\u001b[0m                 )\n\u001b[0;32m--> 331\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    332\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    333\u001b[0m         \u001b[0;31m# error: \"Callable[[VarArg(Any), KwArg(Any)], Any]\" has no\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36mread_csv\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, encoding_errors, dialect, error_bad_lines, warn_bad_lines, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options)\u001b[0m\n\u001b[1;32m    948\u001b[0m     \u001b[0mkwds\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mupdate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkwds_defaults\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    949\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 950\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    951\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    952\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    603\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    604\u001b[0m     \u001b[0;31m# Create the parser.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 605\u001b[0;31m     \u001b[0mparser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    606\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    607\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[1;32m   1440\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1441\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhandles\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mIOHandles\u001b[0m \u001b[0;34m|\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1442\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1443\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1444\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m->\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[0;34m(self, f, engine)\u001b[0m\n\u001b[1;32m   1733\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0;34m\"b\"\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mmode\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1734\u001b[0m                     \u001b[0mmode\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0;34m\"b\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1735\u001b[0;31m             self.handles = get_handle(\n\u001b[0m\u001b[1;32m   1736\u001b[0m                 \u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1737\u001b[0m                 \u001b[0mmode\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/common.py\u001b[0m in \u001b[0;36mget_handle\u001b[0;34m(path_or_buf, mode, encoding, compression, memory_map, is_text, errors, storage_options)\u001b[0m\n\u001b[1;32m    854\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mencoding\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0;34m\"b\"\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmode\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    855\u001b[0m             \u001b[0;31m# Encoding\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 856\u001b[0;31m             handle = open(\n\u001b[0m\u001b[1;32m    857\u001b[0m                 \u001b[0mhandle\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    858\u001b[0m                 \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmode\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: 'tweets.csv'"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "After getting all the sentiment scores, clean up the new dataset in preparation for analysis"
      ],
      "metadata": {
        "id": "39abiFud_-5a"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "csv_file_path = 'tweets_final.csv'\n",
        "tweets_final_df = pd.read_csv(csv_file_path)\n",
        "\n",
        "# Get rid of random unnamed columns\n",
        "tweets_final_df = tweets_final_df.drop(['Unnamed: 12', 'Unnamed: 13', 'Unnamed: 14',\n",
        "                                        'Unnamed: 15', 'Unnamed: 16', 'Unnamed: 17',\n",
        "                                        'Unnamed: 18', 'Unnamed: 19', 'Unnamed: 20'], axis=1)\n",
        "\n",
        "# Replacing NaN with 0 in certain columns\n",
        "columns_to_replace = ['Review', 'RetweetNum', 'LikeNum', 'LookNum']\n",
        "tweets_final_df[columns_to_replace] = tweets_final_df[columns_to_replace].fillna(0)\n",
        "\n",
        "# Removing the K\n",
        "def remove_k(x):\n",
        "    if isinstance(x, str):\n",
        "        if 'K' in x:\n",
        "            return float(x.replace('K', '')) * 1000\n",
        "    return float(x)  # Return as is if no special format\n",
        "\n",
        "tweets_final_df['LikeNum'] = tweets_final_df['LikeNum'].apply(remove_k)\n",
        "tweets_final_df['LookNum'] = tweets_final_df['LookNum'].apply(remove_k)"
      ],
      "metadata": {
        "id": "3Aws0hj1_-MY",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 390
        },
        "outputId": "b70a0981-2454-4e97-8ac6-8edb0dfb35ff"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "error",
          "ename": "FileNotFoundError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-34-fb938345b83a>\u001b[0m in \u001b[0;36m<cell line: 2>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0mcsv_file_path\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m'tweets_final.csv'\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0mtweets_final_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcsv_file_path\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0;31m# Get rid of random unnamed columns\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m tweets_final_df = tweets_final_df.drop(['Unnamed: 12', 'Unnamed: 13', 'Unnamed: 14',\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    209\u001b[0m                 \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    210\u001b[0m                     \u001b[0mkwargs\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mnew_arg_name\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnew_arg_value\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 211\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    212\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    213\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mcast\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mF\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mwrapper\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    329\u001b[0m                     \u001b[0mstacklevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mfind_stack_level\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    330\u001b[0m                 )\n\u001b[0;32m--> 331\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    332\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    333\u001b[0m         \u001b[0;31m# error: \"Callable[[VarArg(Any), KwArg(Any)], Any]\" has no\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36mread_csv\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, encoding_errors, dialect, error_bad_lines, warn_bad_lines, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options)\u001b[0m\n\u001b[1;32m    948\u001b[0m     \u001b[0mkwds\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mupdate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkwds_defaults\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    949\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 950\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    951\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    952\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    603\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    604\u001b[0m     \u001b[0;31m# Create the parser.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 605\u001b[0;31m     \u001b[0mparser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    606\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    607\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[1;32m   1440\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1441\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhandles\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mIOHandles\u001b[0m \u001b[0;34m|\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1442\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1443\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1444\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m->\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[0;34m(self, f, engine)\u001b[0m\n\u001b[1;32m   1733\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0;34m\"b\"\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mmode\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1734\u001b[0m                     \u001b[0mmode\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0;34m\"b\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1735\u001b[0;31m             self.handles = get_handle(\n\u001b[0m\u001b[1;32m   1736\u001b[0m                 \u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1737\u001b[0m                 \u001b[0mmode\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/common.py\u001b[0m in \u001b[0;36mget_handle\u001b[0;34m(path_or_buf, mode, encoding, compression, memory_map, is_text, errors, storage_options)\u001b[0m\n\u001b[1;32m    854\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mencoding\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0;34m\"b\"\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmode\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    855\u001b[0m             \u001b[0;31m# Encoding\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 856\u001b[0;31m             handle = open(\n\u001b[0m\u001b[1;32m    857\u001b[0m                 \u001b[0mhandle\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    858\u001b[0m                 \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmode\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: 'tweets_final.csv'"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Now that the datasets are prepared, run analyses"
      ],
      "metadata": {
        "id": "zMlawU8hBb0P"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Group by user to get their tweet metrics"
      ],
      "metadata": {
        "id": "pDreYI6GcmtN"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "original_df = pd.read_csv('Original_Twitter_Region.csv')\n",
        "result_df = original_df.groupby('UserUrl').mean()\n",
        "result_df.head()\n",
        "merged_df = pd.merge(original_df, result_df, left_on='TwitterURL', right_on='UserUrl', how='inner')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 373
        },
        "id": "izQd2O0kclp2",
        "outputId": "bdc16907-dad4-4a53-850e-e195c99b3dd6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "error",
          "ename": "FileNotFoundError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-35-fa80d63564f1>\u001b[0m in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0moriginal_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'Original_Twitter_Region.csv'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0mresult_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0moriginal_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgroupby\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'UserUrl'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmean\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0mresult_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0mmerged_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmerge\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0moriginal_df\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mresult_df\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mleft_on\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'TwitterURL'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mright_on\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'UserUrl'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mhow\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'inner'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    209\u001b[0m                 \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    210\u001b[0m                     \u001b[0mkwargs\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mnew_arg_name\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnew_arg_value\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 211\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    212\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    213\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mcast\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mF\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mwrapper\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    329\u001b[0m                     \u001b[0mstacklevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mfind_stack_level\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    330\u001b[0m                 )\n\u001b[0;32m--> 331\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    332\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    333\u001b[0m         \u001b[0;31m# error: \"Callable[[VarArg(Any), KwArg(Any)], Any]\" has no\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36mread_csv\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, encoding_errors, dialect, error_bad_lines, warn_bad_lines, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options)\u001b[0m\n\u001b[1;32m    948\u001b[0m     \u001b[0mkwds\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mupdate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkwds_defaults\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    949\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 950\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    951\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    952\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    603\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    604\u001b[0m     \u001b[0;31m# Create the parser.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 605\u001b[0;31m     \u001b[0mparser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    606\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    607\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[1;32m   1440\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1441\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhandles\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mIOHandles\u001b[0m \u001b[0;34m|\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1442\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1443\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1444\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m->\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[0;34m(self, f, engine)\u001b[0m\n\u001b[1;32m   1733\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0;34m\"b\"\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mmode\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1734\u001b[0m                     \u001b[0mmode\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0;34m\"b\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1735\u001b[0;31m             self.handles = get_handle(\n\u001b[0m\u001b[1;32m   1736\u001b[0m                 \u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1737\u001b[0m                 \u001b[0mmode\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/common.py\u001b[0m in \u001b[0;36mget_handle\u001b[0;34m(path_or_buf, mode, encoding, compression, memory_map, is_text, errors, storage_options)\u001b[0m\n\u001b[1;32m    854\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mencoding\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0;34m\"b\"\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmode\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    855\u001b[0m             \u001b[0;31m# Encoding\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 856\u001b[0;31m             handle = open(\n\u001b[0m\u001b[1;32m    857\u001b[0m                 \u001b[0mhandle\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    858\u001b[0m                 \u001b[0mioargs\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmode\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: 'Original_Twitter_Region.csv'"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "merged_df\n",
        "merged_df.to_csv(\"AccountRegion.csv\")"
      ],
      "metadata": {
        "id": "Kw_I3rAElVif"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "merged_df\n"
      ],
      "metadata": {
        "id": "XdrhCMeHrqgs"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "original_followers_df = pd.read_csv('CANIS_original_data.csv')\n",
        "# original_followers_df\n",
        "merged_df = pd.merge(original_followers_df, result_df, left_on='X (Twitter) URL', right_on='UserUrl', how='inner')"
      ],
      "metadata": {
        "id": "_H7YrcIMfEQ_"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "merged_df.to_csv('Original_and_tweets.csv')mb"
      ],
      "metadata": {
        "id": "iTRRNgC5riJX"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Visualizations!!\n"
      ],
      "metadata": {
        "id": "85JIDdybWDh8"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "## Reference code\n",
        "\n",
        "# Create an array with the colors you want to use\n",
        "colors = [\"#69b3a2\", \"#4374B3\"]\n",
        "sns.set_palette(sns.color_palette(colors))\n",
        "\n",
        "# Set the figure size\n",
        "plt.figure(figsize=(10, 10))\n",
        "\n",
        "# grouped barplot\n",
        "ax = sns.barplot(\n",
        "    x=\"day\",\n",
        "    y=\"total_bill\",\n",
        "    hue=\"smoker\",\n",
        "    data=tips,\n",
        "    ci=None\n",
        "    )\n",
        "\n",
        "# Customize the axes and title\n",
        "ax.set_title(\"Smokers have bigger bills\")\n",
        "ax.set_ylabel(\"Bill value\")\n",
        "\n",
        "# Remove top and right borders\n",
        "ax.spines['top'].set_visible(False)\n",
        "ax.spines['right'].set_visible(False)"
      ],
      "metadata": {
        "id": "C5Gr32gsWCWq"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "## Previous code from previous bar charts\n",
        "twitter_count = original_df[original_df['X (Twitter) URL'].notna()].shape[0]\n",
        "facebook_count = original_df[original_df['Facebook URL'].notna()].shape[0]\n",
        "instagram_count = original_df[original_df['Instagram URL'].notna()].shape[0]\n",
        "threads_count = original_df[original_df['Threads URL'].notna()].shape[0]\n",
        "youtube_count = original_df[original_df['YouTube URL'].notna()].shape[0]\n",
        "tiktok_count = original_df[original_df['TikTok URL'].notna()].shape[0]\n",
        "\n",
        "# fig, ax = plt.subplots()\n",
        "\n",
        "# accounts = ['Twitter', 'Facebook', 'Instagram', 'Threads', 'YouTube', 'TikTok']\n",
        "# counts = [twitter_count, facebook_count, instagram_count, threads_count, youtube_count, tiktok_count]\n",
        "\n",
        "# Preparing data for seaborn bar plot\n",
        "counts_data = {\n",
        "    'Platform': ['Twitter', 'Facebook', 'Instagram', 'Threads', 'YouTube', 'TikTok'],\n",
        "    'Number of Accounts': [twitter_count, facebook_count, instagram_count, threads_count, youtube_count, tiktok_count]\n",
        "}\n",
        "df = pd.DataFrame(counts_data)\n",
        "\n",
        "palette_colors = sns.color_palette(\"hls\", 6)\n",
        "\n",
        "# Set the figure size\n",
        "plt.figure(figsize=(10, 7))\n",
        "\n",
        "sns.set_palette(sns.color_palette(\"hls\", 6))\n",
        "\n",
        "# plot a bar chart\n",
        "sns.barplot(\n",
        "    x= 'Platform',\n",
        "    y='Number of Accounts',\n",
        "    data=df,\n",
        "    estimator=sum,\n",
        "    errorbar=None).set(title='Accounts per Platform')\n",
        "\n",
        "plt.xlabel('Platform', fontsize=18)\n",
        "plt.ylabel('Number of Accounts', fontsize=18)\n",
        "\n"
      ],
      "metadata": {
        "id": "SRY6pErqWIN9"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}