preprocess.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import json\n",
    "import geopandas as gpd\n",
    "import utils\n",
    "from utils import util_functions, visualizer_func"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\src\\jupyter_codes\\foreign-affairs\\utils\\util_functions.py:26: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
      "  country_list = df['focus countries'][idx]\n"
     ]
    }
   ],
   "source": [
    "df, twi_df = util_functions.get_processed_merged_data()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Region of Focus', 'Language', 'Entity owner (English)',\n",
       "       'Parent entity (English)', 'X (Twitter) handle', 'X (Twitter) URL',\n",
       "       'X (Twitter) Follower #', 'Facebook page', 'Facebook URL',\n",
       "       'Facebook Follower #', 'Instragram page', 'Instagram URL',\n",
       "       'Instagram Follower #', 'Threads account', 'Threads URL',\n",
       "       'Threads Follower #', 'YouTube account', 'YouTube URL',\n",
       "       'YouTube Subscriber #', 'TikTok account', 'TikTok URL',\n",
       "       'TikTok Subscriber #', 'Name (English)', 'focus countries',\n",
       "       'Account Name', 'is_blue_verified', 'created_at', 'followers_count',\n",
       "       'following_count', 'tweet_num', 'followers_following_ratio',\n",
       "       'formatted_created_at', 'type'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2008"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp_series[0].year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>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>Facebook Follower #</th>\n",
       "      <th>...</th>\n",
       "      <th>focus countries</th>\n",
       "      <th>Account Name</th>\n",
       "      <th>is_blue_verified</th>\n",
       "      <th>created_at</th>\n",
       "      <th>followers_count</th>\n",
       "      <th>following_count</th>\n",
       "      <th>tweet_num</th>\n",
       "      <th>followers_following_ratio</th>\n",
       "      <th>formatted_created_at</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\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>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Switzerland]</td>\n",
       "      <td>Chen Xu</td>\n",
       "      <td>False</td>\n",
       "      <td>2019-12-31 18:35:01</td>\n",
       "      <td>12624.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1260.0</td>\n",
       "      <td>1.262400e+12</td>\n",
       "      <td>2019-12-31</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\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>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Austria]</td>\n",
       "      <td>Li Song</td>\n",
       "      <td>False</td>\n",
       "      <td>2020-06-17 20:37:31</td>\n",
       "      <td>6067.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>1537.0</td>\n",
       "      <td>2.959512e+01</td>\n",
       "      <td>2020-06-17</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>CGChinaInZurich</td>\n",
       "      <td>https://twitter.com/CGChinaInZurich</td>\n",
       "      <td>8972.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Switzerland]</td>\n",
       "      <td>Chinese Consulate General in Zurich</td>\n",
       "      <td>False</td>\n",
       "      <td>2020-02-02 15:02:48</td>\n",
       "      <td>8827.0</td>\n",
       "      <td>538.0</td>\n",
       "      <td>1726.0</td>\n",
       "      <td>1.640706e+01</td>\n",
       "      <td>2020-02-02</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>ChinaCG_Ffm</td>\n",
       "      <td>https://twitter.com/ChinaCG_Ffm</td>\n",
       "      <td>2908.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>Chinese Consulate General in Frankfurt am Main</td>\n",
       "      <td>False</td>\n",
       "      <td>2021-11-22 07:57:25</td>\n",
       "      <td>3044.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>1.189062e+01</td>\n",
       "      <td>2021-11-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>ChinaCG_Muc</td>\n",
       "      <td>https://twitter.com/ChinaCG_Muc</td>\n",
       "      <td>3038.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>Chinese Consulate General in Munich</td>\n",
       "      <td>False</td>\n",
       "      <td>2021-10-07 09:24:30</td>\n",
       "      <td>3097.0</td>\n",
       "      <td>445.0</td>\n",
       "      <td>2306.0</td>\n",
       "      <td>6.959551e+00</td>\n",
       "      <td>2021-10-07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>Austria</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>chinaembaustria</td>\n",
       "      <td>https://twitter.com/chinaembaustria</td>\n",
       "      <td>6804.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Austria]</td>\n",
       "      <td>Chinese Embassy in Austria</td>\n",
       "      <td>False</td>\n",
       "      <td>2020-01-30 16:48:21</td>\n",
       "      <td>6829.0</td>\n",
       "      <td>704.0</td>\n",
       "      <td>6777.0</td>\n",
       "      <td>9.700284e+00</td>\n",
       "      <td>2020-01-30</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>ChinaEmbGermany</td>\n",
       "      <td>https://twitter.com/ChinaEmbGermany</td>\n",
       "      <td>7946.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>Chinese Embassy in Germany</td>\n",
       "      <td>False</td>\n",
       "      <td>2019-12-20 09:43:27</td>\n",
       "      <td>8724.0</td>\n",
       "      <td>265.0</td>\n",
       "      <td>4354.0</td>\n",
       "      <td>3.292075e+01</td>\n",
       "      <td>2019-12-20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "      <td>CRIGerman1</td>\n",
       "      <td>https://twitter.com/CRIGerman1</td>\n",
       "      <td>54.0</td>\n",
       "      <td>CRIGerman</td>\n",
       "      <td>https://www.facebook.com/CRIGerman</td>\n",
       "      <td>897000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>CRI German</td>\n",
       "      <td>False</td>\n",
       "      <td>2021-02-18 08:02:38</td>\n",
       "      <td>59.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1686.0</td>\n",
       "      <td>1.735294e+00</td>\n",
       "      <td>2021-02-18</td>\n",
       "      <td>Media &amp; News Company</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>Austria</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>EmbQiMei</td>\n",
       "      <td>https://twitter.com/EmbQiMei</td>\n",
       "      <td>2122.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Austria]</td>\n",
       "      <td>Qi Mei</td>\n",
       "      <td>False</td>\n",
       "      <td>2022-03-18 20:18:42</td>\n",
       "      <td>2197.0</td>\n",
       "      <td>303.0</td>\n",
       "      <td>987.0</td>\n",
       "      <td>7.250825e+00</td>\n",
       "      <td>2022-03-18</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>GeneralkonsulDu</td>\n",
       "      <td>https://twitter.com/GeneralkonsulDu</td>\n",
       "      <td>1601.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>Du Xiaohui</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>588</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</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>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>Chinese Consulate General in Hamburg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>637</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mama-Yu-346605806384616</td>\n",
       "      <td>https://www.facebook.com/Mama-Yu-346605806384616</td>\n",
       "      <td>42000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>Yu Mama (Mama Yu)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>638</th>\n",
       "      <td>Germany</td>\n",
       "      <td>German</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MengyuChina</td>\n",
       "      <td>https://www.facebook.com/MengyuChina</td>\n",
       "      <td>133000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Germany]</td>\n",
       "      <td>Mengyu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>13 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Region of Focus Language       Entity owner (English)  \\\n",
       "6       Switzerland   German  Ministry of Foreign Affairs   \n",
       "7           Austria   German  Ministry of Foreign Affairs   \n",
       "69      Switzerland   German  Ministry of Foreign Affairs   \n",
       "126         Germany   German  Ministry of Foreign Affairs   \n",
       "127         Germany   German  Ministry of Foreign Affairs   \n",
       "156         Austria   German  Ministry of Foreign Affairs   \n",
       "163         Germany   German  Ministry of Foreign Affairs   \n",
       "256         Germany   German      China Media Group (CMG)   \n",
       "297         Austria   German  Ministry of Foreign Affairs   \n",
       "313         Germany   German  Ministry of Foreign Affairs   \n",
       "588         Germany   German  Ministry of Foreign Affairs   \n",
       "637         Germany   German      China Media Group (CMG)   \n",
       "638         Germany   German      China Media Group (CMG)   \n",
       "\n",
       "          Parent entity (English) X (Twitter) handle  \\\n",
       "6     Ministry of Foreign Affairs         Amb_ChenXu   \n",
       "7     Ministry of Foreign Affairs         Amb_LiSong   \n",
       "69    Ministry of Foreign Affairs    CGChinaInZurich   \n",
       "126   Ministry of Foreign Affairs        ChinaCG_Ffm   \n",
       "127   Ministry of Foreign Affairs        ChinaCG_Muc   \n",
       "156   Ministry of Foreign Affairs    chinaembaustria   \n",
       "163   Ministry of Foreign Affairs    ChinaEmbGermany   \n",
       "256  Central Publicity Department         CRIGerman1   \n",
       "297   Ministry of Foreign Affairs           EmbQiMei   \n",
       "313   Ministry of Foreign Affairs    GeneralkonsulDu   \n",
       "588   Ministry of Foreign Affairs                NaN   \n",
       "637  Central Publicity Department                NaN   \n",
       "638  Central Publicity Department                NaN   \n",
       "\n",
       "                         X (Twitter) URL  X (Twitter) Follower #  \\\n",
       "6         https://twitter.com/Amb_ChenXu                 12600.0   \n",
       "7         https://twitter.com/Amb_LiSong                  5972.0   \n",
       "69   https://twitter.com/CGChinaInZurich                  8972.0   \n",
       "126      https://twitter.com/ChinaCG_Ffm                  2908.0   \n",
       "127      https://twitter.com/ChinaCG_Muc                  3038.0   \n",
       "156  https://twitter.com/chinaembaustria                  6804.0   \n",
       "163  https://twitter.com/ChinaEmbGermany                  7946.0   \n",
       "256       https://twitter.com/CRIGerman1                    54.0   \n",
       "297         https://twitter.com/EmbQiMei                  2122.0   \n",
       "313  https://twitter.com/GeneralkonsulDu                  1601.0   \n",
       "588                                  NaN                     NaN   \n",
       "637                                  NaN                     NaN   \n",
       "638                                  NaN                     NaN   \n",
       "\n",
       "               Facebook page  \\\n",
       "6                        NaN   \n",
       "7                        NaN   \n",
       "69                       NaN   \n",
       "126                      NaN   \n",
       "127                      NaN   \n",
       "156                      NaN   \n",
       "163                      NaN   \n",
       "256                CRIGerman   \n",
       "297                      NaN   \n",
       "313                      NaN   \n",
       "588                      NaN   \n",
       "637  Mama-Yu-346605806384616   \n",
       "638              MengyuChina   \n",
       "\n",
       "                                         Facebook URL  Facebook Follower #  \\\n",
       "6                                                 NaN                  NaN   \n",
       "7                                                 NaN                  NaN   \n",
       "69                                                NaN                  NaN   \n",
       "126                                               NaN                  NaN   \n",
       "127                                               NaN                  NaN   \n",
       "156                                               NaN                  NaN   \n",
       "163                                               NaN                  NaN   \n",
       "256                https://www.facebook.com/CRIGerman             897000.0   \n",
       "297                                               NaN                  NaN   \n",
       "313                                               NaN                  NaN   \n",
       "588                                               NaN                  NaN   \n",
       "637  https://www.facebook.com/Mama-Yu-346605806384616              42000.0   \n",
       "638              https://www.facebook.com/MengyuChina             133000.0   \n",
       "\n",
       "     ... focus countries                                    Account Name  \\\n",
       "6    ...   [Switzerland]                                         Chen Xu   \n",
       "7    ...       [Austria]                                         Li Song   \n",
       "69   ...   [Switzerland]             Chinese Consulate General in Zurich   \n",
       "126  ...       [Germany]  Chinese Consulate General in Frankfurt am Main   \n",
       "127  ...       [Germany]             Chinese Consulate General in Munich   \n",
       "156  ...       [Austria]                      Chinese Embassy in Austria   \n",
       "163  ...       [Germany]                      Chinese Embassy in Germany   \n",
       "256  ...       [Germany]                                      CRI German   \n",
       "297  ...       [Austria]                                          Qi Mei   \n",
       "313  ...       [Germany]                                      Du Xiaohui   \n",
       "588  ...       [Germany]            Chinese Consulate General in Hamburg   \n",
       "637  ...       [Germany]                               Yu Mama (Mama Yu)   \n",
       "638  ...       [Germany]                                          Mengyu   \n",
       "\n",
       "     is_blue_verified          created_at followers_count  following_count  \\\n",
       "6               False 2019-12-31 18:35:01         12624.0              0.0   \n",
       "7               False 2020-06-17 20:37:31          6067.0            205.0   \n",
       "69              False 2020-02-02 15:02:48          8827.0            538.0   \n",
       "126             False 2021-11-22 07:57:25          3044.0            256.0   \n",
       "127             False 2021-10-07 09:24:30          3097.0            445.0   \n",
       "156             False 2020-01-30 16:48:21          6829.0            704.0   \n",
       "163             False 2019-12-20 09:43:27          8724.0            265.0   \n",
       "256             False 2021-02-18 08:02:38            59.0             34.0   \n",
       "297             False 2022-03-18 20:18:42          2197.0            303.0   \n",
       "313               NaN                 NaT             NaN              NaN   \n",
       "588               NaN                 NaT             NaN              NaN   \n",
       "637               NaN                 NaT             NaN              NaN   \n",
       "638               NaN                 NaT             NaN              NaN   \n",
       "\n",
       "    tweet_num followers_following_ratio  formatted_created_at  \\\n",
       "6      1260.0              1.262400e+12            2019-12-31   \n",
       "7      1537.0              2.959512e+01            2020-06-17   \n",
       "69     1726.0              1.640706e+01            2020-02-02   \n",
       "126     735.0              1.189062e+01            2021-11-22   \n",
       "127    2306.0              6.959551e+00            2021-10-07   \n",
       "156    6777.0              9.700284e+00            2020-01-30   \n",
       "163    4354.0              3.292075e+01            2019-12-20   \n",
       "256    1686.0              1.735294e+00            2021-02-18   \n",
       "297     987.0              7.250825e+00            2022-03-18   \n",
       "313       NaN                       NaN                   NaN   \n",
       "588       NaN                       NaN                   NaN   \n",
       "637       NaN                       NaN                   NaN   \n",
       "638       NaN                       NaN                   NaN   \n",
       "\n",
       "                     type  \n",
       "6                     NaN  \n",
       "7                     NaN  \n",
       "69                    NaN  \n",
       "126                   NaN  \n",
       "127                   NaN  \n",
       "156                   NaN  \n",
       "163                   NaN  \n",
       "256  Media & News Company  \n",
       "297                   NaN  \n",
       "313                   NaN  \n",
       "588                   NaN  \n",
       "637                   NaN  \n",
       "638                   NaN  \n",
       "\n",
       "[13 rows x 33 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Language'] == 'German']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "util_functions.generate_corps_data(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "account_country_dict = util_functions.load_file('findings/platform_accounts_per_country.json')\n",
    "followers_country_dict = util_functions.load_file('findings/follower_country.json')\n",
    "corps_data = util_functions.load_file('findings/corp_data.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Australia': {'twitter': 196,\n",
       "  'facebook': 114,\n",
       "  'instagram': 52,\n",
       "  'youtube': 48,\n",
       "  'tiktok': 44,\n",
       "  'threads': 20,\n",
       "  'total': 474},\n",
       " 'Canada': {'twitter': 207,\n",
       "  'facebook': 125,\n",
       "  'instagram': 61,\n",
       "  'youtube': 56,\n",
       "  'tiktok': 49,\n",
       "  'threads': 20,\n",
       "  'total': 518},\n",
       " 'New Zealand': {'twitter': 195,\n",
       "  'facebook': 113,\n",
       "  'instagram': 51,\n",
       "  'youtube': 47,\n",
       "  'tiktok': 44,\n",
       "  'threads': 20,\n",
       "  'total': 470},\n",
       " 'United Kingdom': {'twitter': 203,\n",
       "  'facebook': 112,\n",
       "  'instagram': 52,\n",
       "  'youtube': 49,\n",
       "  'tiktok': 48,\n",
       "  'threads': 20,\n",
       "  'total': 484},\n",
       " 'United States of America': {'twitter': 214,\n",
       "  'facebook': 119,\n",
       "  'instagram': 56,\n",
       "  'youtube': 50,\n",
       "  'tiktok': 48,\n",
       "  'threads': 22,\n",
       "  'total': 509},\n",
       " 'Ireland': {'twitter': 200,\n",
       "  'facebook': 115,\n",
       "  'instagram': 52,\n",
       "  'youtube': 50,\n",
       "  'tiktok': 45,\n",
       "  'threads': 20,\n",
       "  'total': 482},\n",
       " 'China': {'twitter': 76,\n",
       "  'facebook': 49,\n",
       "  'instagram': 25,\n",
       "  'youtube': 45,\n",
       "  'tiktok': 29,\n",
       "  'threads': 9,\n",
       "  'total': 233},\n",
       " 'Afghanistan': {'twitter': 4,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 8},\n",
       " 'Switzerland': {'twitter': 15,\n",
       "  'facebook': 13,\n",
       "  'instagram': 10,\n",
       "  'youtube': 9,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 51},\n",
       " 'Austria': {'twitter': 10,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 18},\n",
       " 'Indonesia': {'twitter': 3,\n",
       "  'facebook': 1,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'United Arab Emirates': {'twitter': 8,\n",
       "  'facebook': 7,\n",
       "  'instagram': 7,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 32},\n",
       " 'Belgium': {'twitter': 19,\n",
       "  'facebook': 16,\n",
       "  'instagram': 11,\n",
       "  'youtube': 12,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 62},\n",
       " 'Bulgaria': {'twitter': 7,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Croatia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Cyprus': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Czechia': {'twitter': 7,\n",
       "  'facebook': 4,\n",
       "  'instagram': 2,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 18},\n",
       " 'Denmark': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Estonia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Finland': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'France': {'twitter': 22,\n",
       "  'facebook': 17,\n",
       "  'instagram': 12,\n",
       "  'youtube': 12,\n",
       "  'tiktok': 5,\n",
       "  'threads': 0,\n",
       "  'total': 68},\n",
       " 'Germany': {'twitter': 11,\n",
       "  'facebook': 6,\n",
       "  'instagram': 3,\n",
       "  'youtube': 5,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 26},\n",
       " 'Greece': {'twitter': 8,\n",
       "  'facebook': 5,\n",
       "  'instagram': 2,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 19},\n",
       " 'Hungary': {'twitter': 7,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Italy': {'twitter': 9,\n",
       "  'facebook': 5,\n",
       "  'instagram': 2,\n",
       "  'youtube': 4,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 22},\n",
       " 'Latvia': {'twitter': 6,\n",
       "  'facebook': 3,\n",
       "  'instagram': 2,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Lithuania': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Luxembourg': {'twitter': 6,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 14},\n",
       " 'Malta': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Netherlands': {'twitter': 11,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 20},\n",
       " 'Poland': {'twitter': 9,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 4,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 19},\n",
       " 'Portugal': {'twitter': 8,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 17},\n",
       " 'Romania': {'twitter': 6,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Slovakia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Slovenia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Spain': {'twitter': 13,\n",
       "  'facebook': 11,\n",
       "  'instagram': 5,\n",
       "  'youtube': 9,\n",
       "  'tiktok': 5,\n",
       "  'threads': 0,\n",
       "  'total': 43},\n",
       " 'Sweden': {'twitter': 6,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 14},\n",
       " 'Nigeria': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 13},\n",
       " 'Egypt': {'twitter': 15,\n",
       "  'facebook': 13,\n",
       "  'instagram': 9,\n",
       "  'youtube': 9,\n",
       "  'tiktok': 4,\n",
       "  'threads': 1,\n",
       "  'total': 51},\n",
       " 'South Africa': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Algeria': {'twitter': 16,\n",
       "  'facebook': 9,\n",
       "  'instagram': 7,\n",
       "  'youtube': 8,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 43},\n",
       " 'Morocco': {'twitter': 13,\n",
       "  'facebook': 9,\n",
       "  'instagram': 7,\n",
       "  'youtube': 8,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 40},\n",
       " 'Lesotho': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Iran': {'twitter': 7,\n",
       "  'facebook': 9,\n",
       "  'instagram': 9,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 35},\n",
       " 'Serbia': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Saudi Arabia': {'twitter': 9,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 32},\n",
       " 'Burundi': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 4},\n",
       " 'Cameroon': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Democratic Rep. Congo': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Chad': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Trinidad and Tobago': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Japan': {'twitter': 16,\n",
       "  'facebook': 5,\n",
       "  'instagram': 1,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 5,\n",
       "  'threads': 0,\n",
       "  'total': 34},\n",
       " 'Suriname': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'South Korea': {'twitter': 3,\n",
       "  'facebook': 3,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 11},\n",
       " 'Pakistan': {'twitter': 8,\n",
       "  'facebook': 9,\n",
       "  'instagram': 1,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 22},\n",
       " 'Qatar': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Bahrain': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Iraq': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Jordan': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Kuwait': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Lebanon': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Libya': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Oman': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Sudan': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Syria': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Tunisia': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Yemen': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Russia': {'twitter': 7,\n",
       "  'facebook': 2,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Kenya': {'twitter': 4,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 8},\n",
       " 'Tanzania': {'twitter': 4,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Somalia': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'India': {'twitter': 5,\n",
       "  'facebook': 7,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 1,\n",
       "  'total': 15},\n",
       " 'Maldives': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Zimbabwe': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Colombia': {'twitter': 6,\n",
       "  'facebook': 8,\n",
       "  'instagram': 4,\n",
       "  'youtube': 6,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 28},\n",
       " 'Ukraine': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Brunei': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Cambodia': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Laos': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 4},\n",
       " 'Malaysia': {'twitter': 1,\n",
       "  'facebook': 4,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Myanmar (Burma)': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Philippines': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Singapore': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Thailand': {'twitter': 3,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 7},\n",
       " 'Vietnam': {'twitter': 1,\n",
       "  'facebook': 8,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 10},\n",
       " 'Samoa': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Kazakhstan': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 2,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 4},\n",
       " 'Turkey': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 0,\n",
       "  'threads': 1,\n",
       "  'total': 8},\n",
       " 'South Sudan': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Ethiopia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Chile': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Dominican Republic': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Angola': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Antigua and Barbuda': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Argentina': {'twitter': 5,\n",
       "  'facebook': 8,\n",
       "  'instagram': 4,\n",
       "  'youtube': 6,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 27},\n",
       " 'Malawi': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Albania': {'twitter': 2,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Eritrea': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Grenada': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Ghana': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Mauritania': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Rwanda': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Namibia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Peru': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Sri Lanka': {'twitter': 3,\n",
       "  'facebook': 4,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 9},\n",
       " 'Mali': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Guinea': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Senegal': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Djibouti': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Gambia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Fiji': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Papua New Guinea': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Uganda': {'twitter': 4,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 6},\n",
       " 'Montenegro': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Liberia': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Brazil': {'twitter': 8,\n",
       "  'facebook': 1,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 1,\n",
       "  'threads': 1,\n",
       "  'total': 15},\n",
       " 'Mongolia': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Botswana': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Ecuador': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'El Salvador': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Uruguay': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Tonga': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Cuba': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Equatorial Guinea': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Mexico': {'twitter': 7,\n",
       "  'facebook': 9,\n",
       "  'instagram': 4,\n",
       "  'youtube': 6,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Panama': {'twitter': 7,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 7},\n",
       " 'Venezuela': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Iceland': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'São Tomé and Príncipe': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Mauritius': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Costa Rica': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Myanmar': {'twitter': 3,\n",
       "  'facebook': 4,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 11},\n",
       " 'Cape Verde': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Guinea-Bissau': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Mozambique': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Nepal': {'twitter': 2,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Israel': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 7},\n",
       " 'Bolivia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Norway': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Barbados': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Belarus': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Kyrgyzstan': {'twitter': 0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Taiwan': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Bangladesh': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Guyana': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'North Macedonia': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Sierra Leone': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1}}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "account_country_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Australia': {'twitter': 196,\n",
       "  'facebook': 114,\n",
       "  'instagram': 52,\n",
       "  'youtube': 48,\n",
       "  'tiktok': 44,\n",
       "  'threads': 20,\n",
       "  'total': 474},\n",
       " 'Canada': {'twitter': 207,\n",
       "  'facebook': 125,\n",
       "  'instagram': 61,\n",
       "  'youtube': 56,\n",
       "  'tiktok': 49,\n",
       "  'threads': 20,\n",
       "  'total': 518},\n",
       " 'New Zealand': {'twitter': 195,\n",
       "  'facebook': 113,\n",
       "  'instagram': 51,\n",
       "  'youtube': 47,\n",
       "  'tiktok': 44,\n",
       "  'threads': 20,\n",
       "  'total': 470},\n",
       " 'United Kingdom': {'twitter': 203,\n",
       "  'facebook': 112,\n",
       "  'instagram': 52,\n",
       "  'youtube': 49,\n",
       "  'tiktok': 48,\n",
       "  'threads': 20,\n",
       "  'total': 484},\n",
       " 'United States of America': {'twitter': 214,\n",
       "  'facebook': 119,\n",
       "  'instagram': 56,\n",
       "  'youtube': 50,\n",
       "  'tiktok': 48,\n",
       "  'threads': 22,\n",
       "  'total': 509},\n",
       " 'Ireland': {'twitter': 200,\n",
       "  'facebook': 115,\n",
       "  'instagram': 52,\n",
       "  'youtube': 50,\n",
       "  'tiktok': 45,\n",
       "  'threads': 20,\n",
       "  'total': 482},\n",
       " 'China': {'twitter': 76,\n",
       "  'facebook': 49,\n",
       "  'instagram': 25,\n",
       "  'youtube': 45,\n",
       "  'tiktok': 29,\n",
       "  'threads': 9,\n",
       "  'total': 233},\n",
       " 'Afghanistan': {'twitter': 4,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 8},\n",
       " 'Switzerland': {'twitter': 15,\n",
       "  'facebook': 13,\n",
       "  'instagram': 10,\n",
       "  'youtube': 9,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 51},\n",
       " 'Austria': {'twitter': 10,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 18},\n",
       " 'Indonesia': {'twitter': 3,\n",
       "  'facebook': 1,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'United Arab Emirates': {'twitter': 8,\n",
       "  'facebook': 7,\n",
       "  'instagram': 7,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 32},\n",
       " 'Belgium': {'twitter': 19,\n",
       "  'facebook': 16,\n",
       "  'instagram': 11,\n",
       "  'youtube': 12,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 62},\n",
       " 'Bulgaria': {'twitter': 7,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Croatia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Cyprus': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Czechia': {'twitter': 7,\n",
       "  'facebook': 4,\n",
       "  'instagram': 2,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 18},\n",
       " 'Denmark': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Estonia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Finland': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'France': {'twitter': 22,\n",
       "  'facebook': 17,\n",
       "  'instagram': 12,\n",
       "  'youtube': 12,\n",
       "  'tiktok': 5,\n",
       "  'threads': 0,\n",
       "  'total': 68},\n",
       " 'Germany': {'twitter': 11,\n",
       "  'facebook': 6,\n",
       "  'instagram': 3,\n",
       "  'youtube': 5,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 26},\n",
       " 'Greece': {'twitter': 8,\n",
       "  'facebook': 5,\n",
       "  'instagram': 2,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 19},\n",
       " 'Hungary': {'twitter': 7,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Italy': {'twitter': 9,\n",
       "  'facebook': 5,\n",
       "  'instagram': 2,\n",
       "  'youtube': 4,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 22},\n",
       " 'Latvia': {'twitter': 6,\n",
       "  'facebook': 3,\n",
       "  'instagram': 2,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Lithuania': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Luxembourg': {'twitter': 6,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 14},\n",
       " 'Malta': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 16},\n",
       " 'Netherlands': {'twitter': 11,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 20},\n",
       " 'Poland': {'twitter': 9,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 4,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 19},\n",
       " 'Portugal': {'twitter': 8,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 17},\n",
       " 'Romania': {'twitter': 6,\n",
       "  'facebook': 4,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Slovakia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Slovenia': {'twitter': 7,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Spain': {'twitter': 13,\n",
       "  'facebook': 11,\n",
       "  'instagram': 5,\n",
       "  'youtube': 9,\n",
       "  'tiktok': 5,\n",
       "  'threads': 0,\n",
       "  'total': 43},\n",
       " 'Sweden': {'twitter': 6,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 14},\n",
       " 'Nigeria': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 13},\n",
       " 'Egypt': {'twitter': 15,\n",
       "  'facebook': 13,\n",
       "  'instagram': 9,\n",
       "  'youtube': 9,\n",
       "  'tiktok': 4,\n",
       "  'threads': 1,\n",
       "  'total': 51},\n",
       " 'South Africa': {'twitter': 8,\n",
       "  'facebook': 3,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Algeria': {'twitter': 16,\n",
       "  'facebook': 9,\n",
       "  'instagram': 7,\n",
       "  'youtube': 8,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 43},\n",
       " 'Morocco': {'twitter': 13,\n",
       "  'facebook': 9,\n",
       "  'instagram': 7,\n",
       "  'youtube': 8,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 40},\n",
       " 'Lesotho': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Iran': {'twitter': 7,\n",
       "  'facebook': 9,\n",
       "  'instagram': 9,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 35},\n",
       " 'Serbia': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Saudi Arabia': {'twitter': 9,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 32},\n",
       " 'Burundi': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 4},\n",
       " 'Cameroon': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Democratic Rep. Congo': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Chad': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Trinidad and Tobago': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Japan': {'twitter': 16,\n",
       "  'facebook': 5,\n",
       "  'instagram': 1,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 5,\n",
       "  'threads': 0,\n",
       "  'total': 34},\n",
       " 'Suriname': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'South Korea': {'twitter': 3,\n",
       "  'facebook': 3,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 11},\n",
       " 'Pakistan': {'twitter': 8,\n",
       "  'facebook': 9,\n",
       "  'instagram': 1,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 22},\n",
       " 'Qatar': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Bahrain': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Iraq': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Jordan': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Kuwait': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Lebanon': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Libya': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Oman': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Sudan': {'twitter': 7,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Syria': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Tunisia': {'twitter': 6,\n",
       "  'facebook': 7,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 29},\n",
       " 'Yemen': {'twitter': 7,\n",
       "  'facebook': 8,\n",
       "  'instagram': 6,\n",
       "  'youtube': 7,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 31},\n",
       " 'Russia': {'twitter': 7,\n",
       "  'facebook': 2,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 15},\n",
       " 'Kenya': {'twitter': 4,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 8},\n",
       " 'Tanzania': {'twitter': 4,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Somalia': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'India': {'twitter': 5,\n",
       "  'facebook': 7,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 1,\n",
       "  'total': 15},\n",
       " 'Maldives': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Zimbabwe': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Colombia': {'twitter': 6,\n",
       "  'facebook': 8,\n",
       "  'instagram': 4,\n",
       "  'youtube': 6,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 28},\n",
       " 'Ukraine': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Brunei': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Cambodia': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Laos': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 4},\n",
       " 'Malaysia': {'twitter': 1,\n",
       "  'facebook': 4,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Myanmar (Burma)': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Philippines': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Singapore': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Thailand': {'twitter': 3,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 2,\n",
       "  'threads': 0,\n",
       "  'total': 7},\n",
       " 'Vietnam': {'twitter': 1,\n",
       "  'facebook': 8,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 10},\n",
       " 'Samoa': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Kazakhstan': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 2,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 4},\n",
       " 'Turkey': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 0,\n",
       "  'threads': 1,\n",
       "  'total': 8},\n",
       " 'South Sudan': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Ethiopia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Chile': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Dominican Republic': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Angola': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Antigua and Barbuda': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Argentina': {'twitter': 5,\n",
       "  'facebook': 8,\n",
       "  'instagram': 4,\n",
       "  'youtube': 6,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 27},\n",
       " 'Malawi': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Albania': {'twitter': 2,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Eritrea': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Grenada': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Ghana': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Mauritania': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Rwanda': {'twitter': 2,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Namibia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Peru': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Sri Lanka': {'twitter': 3,\n",
       "  'facebook': 4,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 1,\n",
       "  'threads': 0,\n",
       "  'total': 9},\n",
       " 'Mali': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Guinea': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Senegal': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Djibouti': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Gambia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Fiji': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Papua New Guinea': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Uganda': {'twitter': 4,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 6},\n",
       " 'Montenegro': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Liberia': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Brazil': {'twitter': 8,\n",
       "  'facebook': 1,\n",
       "  'instagram': 2,\n",
       "  'youtube': 2,\n",
       "  'tiktok': 1,\n",
       "  'threads': 1,\n",
       "  'total': 15},\n",
       " 'Mongolia': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Botswana': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Ecuador': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'El Salvador': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Uruguay': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Tonga': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Cuba': {'twitter': 3,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 3},\n",
       " 'Equatorial Guinea': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Mexico': {'twitter': 7,\n",
       "  'facebook': 9,\n",
       "  'instagram': 4,\n",
       "  'youtube': 6,\n",
       "  'tiktok': 4,\n",
       "  'threads': 0,\n",
       "  'total': 30},\n",
       " 'Panama': {'twitter': 7,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 7},\n",
       " 'Venezuela': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Iceland': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'São Tomé and Príncipe': {'twitter': 2,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Mauritius': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Costa Rica': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Myanmar': {'twitter': 3,\n",
       "  'facebook': 4,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 3,\n",
       "  'threads': 0,\n",
       "  'total': 11},\n",
       " 'Cape Verde': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Guinea-Bissau': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Mozambique': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Nepal': {'twitter': 2,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 5},\n",
       " 'Israel': {'twitter': 1,\n",
       "  'facebook': 2,\n",
       "  'instagram': 1,\n",
       "  'youtube': 3,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 7},\n",
       " 'Bolivia': {'twitter': 1,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Norway': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Barbados': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Belarus': {'twitter': 1,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Kyrgyzstan': {'twitter': 0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 1,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Taiwan': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 1,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 2},\n",
       " 'Bangladesh': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Guyana': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'North Macedonia': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1},\n",
       " 'Sierra Leone': {'twitter': 0,\n",
       "  'facebook': 1,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0,\n",
       "  'total': 1}}"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "account_country_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_dic = util_functions.load_file('findings/follower_country.json')\n",
    "temp_df = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>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>Facebook Follower #</th>\n",
       "      <th>...</th>\n",
       "      <th>focus countries</th>\n",
       "      <th>Account Name</th>\n",
       "      <th>is_blue_verified</th>\n",
       "      <th>created_at</th>\n",
       "      <th>followers_count</th>\n",
       "      <th>following_count</th>\n",
       "      <th>tweet_num</th>\n",
       "      <th>followers_following_ratio</th>\n",
       "      <th>formatted_created_at</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>1387432.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>Yang Xinmeng (Abby Yang)</td>\n",
       "      <td>True</td>\n",
       "      <td>2014-07-10 02:05:08</td>\n",
       "      <td>2799.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>851.0</td>\n",
       "      <td>17.385093</td>\n",
       "      <td>2014-07-10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\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>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>CGTN Culture Express</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-05-22 10:49:21</td>\n",
       "      <td>2483.0</td>\n",
       "      <td>152.0</td>\n",
       "      <td>1601.0</td>\n",
       "      <td>16.335526</td>\n",
       "      <td>2017-05-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Region of Focus Language   Entity owner (English)  \\\n",
       "0     Anglosphere  English  China Media Group (CMG)   \n",
       "1     Anglosphere  English  China Media Group (CMG)   \n",
       "\n",
       "        Parent entity (English) X (Twitter) handle  \\\n",
       "0  Central Publicity Department       _bubblyabby_   \n",
       "1  Central Publicity Department    _cultureexpress   \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",
       "\n",
       "             Facebook page                                      Facebook URL  \\\n",
       "0  itsAbby-103043374799622  https://www.facebook.com/itsAbby-103043374799622   \n",
       "1                      NaN                                               NaN   \n",
       "\n",
       "   Facebook Follower #  ...  \\\n",
       "0            1387432.0  ...   \n",
       "1                  NaN  ...   \n",
       "\n",
       "                                     focus countries  \\\n",
       "0  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "1  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "\n",
       "               Account Name  is_blue_verified          created_at  \\\n",
       "0  Yang Xinmeng (Abby Yang)              True 2014-07-10 02:05:08   \n",
       "1      CGTN Culture Express             False 2017-05-22 10:49:21   \n",
       "\n",
       "  followers_count  following_count tweet_num followers_following_ratio  \\\n",
       "0          2799.0            161.0     851.0                 17.385093   \n",
       "1          2483.0            152.0    1601.0                 16.335526   \n",
       "\n",
       "   formatted_created_at type  \n",
       "0            2014-07-10  NaN  \n",
       "1            2017-05-22  NaN  \n",
       "\n",
       "[2 rows x 33 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('findings/country_corps.json', 'r') as file:\n",
    "    country_info_dict = json.load(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "239"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(country_info_dict['Australia']['name'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "me = visualizer_func.plot_filtered_language_follower_bar(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "util_functions.create_country_to_name_owner_parent_data(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "32"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open('findings/country_corps.json', 'r') as file:\n",
    "    country_info_dict = json.load(file)\n",
    "len(country_info_dict['Australia']['owner'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('findings/country_corps.json', 'r') as file:\n",
    "    country_info_dict = json.load(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "['Name (English)', 'Entity owner (English)', 'Parent entity (English)', 'focus countries']\n",
    "color_code = {\n",
    "    'Name (English)': '#04c0b1',\n",
    "    'Entity owner (English)': '#274d4a',\n",
    "    'Parent entity (English)': '#088fbc',\n",
    "    'focus countries': '#e87551'\n",
    "}\n",
    "def check_selected(selected_options, my_dict):\n",
    "    opt1 = selected_options[0]\n",
    "    opt2 = selected_options[1]\n",
    "    \n",
    "    if my_dict[opt1] == 'focus':\n",
    "        return opt1, opt2\n",
    "    else:\n",
    "        return opt2, opt1\n",
    "    \n",
    "def find_priority(selected_options, my_dict):\n",
    "    opt1 = selected_options[0]\n",
    "    opt2 = selected_options[1]\n",
    "    if my_dict[opt1] == 'name':\n",
    "        return opt2, opt1\n",
    "    elif my_dict[opt2] == 'name':\n",
    "        return opt1, opt2\n",
    "    elif my_dict[opt1] == 'owner':\n",
    "        return opt2, opt1\n",
    "    elif my_dict[opt2] == 'owner':\n",
    "        return opt1, opt2\n",
    "    else:\n",
    "        return opt1, opt2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "temp_df = df[['Name (English)', 'Entity owner (English)', 'Parent entity (English)']]\n",
    "temp_df[temp_df['Entity owner (English)'] == 'China Media Group (CMG)']['Name (English)'].values\n",
    "print('')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Entity owner (English)</th>\n",
       "      <th>Parent entity (English)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CGTN Culture Express</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Name (English)   Entity owner (English)       Parent entity (English)\n",
       "1  CGTN Culture Express  China Media Group (CMG)  Central Publicity Department"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp_df[temp_df['Name (English)'] == 'CGTN Culture Express']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_df[temp_df['Entity owner (English)'] == 'China Media Group (CMG)']['Name (English)'].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Region of Focus', 'Language', 'Entity owner (English)',\n",
       "       'Parent entity (English)', 'X (Twitter) handle', 'X (Twitter) URL',\n",
       "       'X (Twitter) Follower #', 'Facebook page', 'Facebook URL',\n",
       "       'Facebook Follower #', 'Instragram page', 'Instagram URL',\n",
       "       'Instagram Follower #', 'Threads account', 'Threads URL',\n",
       "       'Threads Follower #', 'YouTube account', 'YouTube URL',\n",
       "       'YouTube Subscriber #', 'TikTok account', 'TikTok URL',\n",
       "       'TikTok Subscriber #', 'Name (English)', 'focus countries',\n",
       "       'Account Name', 'is_blue_verified', 'created_at', 'followers_count',\n",
       "       'following_count', 'tweet_num', 'followers_following_ratio',\n",
       "       'formatted_created_at', 'type'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'_bubblyabby_'"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Instragram page'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "must be real number, not str",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32mc:\\src\\jupyter_codes\\foreign-affairs\\preprocess.ipynb Cell 17\u001b[0m line \u001b[0;36m2\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/src/jupyter_codes/foreign-affairs/preprocess.ipynb#Y105sZmlsZQ%3D%3D?line=0'>1</a>\u001b[0m \u001b[39mimport\u001b[39;00m \u001b[39mmath\u001b[39;00m\n\u001b[1;32m----> <a href='vscode-notebook-cell:/c%3A/src/jupyter_codes/foreign-affairs/preprocess.ipynb#Y105sZmlsZQ%3D%3D?line=1'>2</a>\u001b[0m math\u001b[39m.\u001b[39;49misnan(\u001b[39m'\u001b[39;49m\u001b[39mme\u001b[39;49m\u001b[39m'\u001b[39;49m)\n",
      "\u001b[1;31mTypeError\u001b[0m: must be real number, not str"
     ]
    }
   ],
   "source": [
    "try:\n",
    "\n",
    "except ValueError:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def check_value(value):\n",
    "    try:\n",
    "        return 0 if np.isnan(value) else 1\n",
    "    except:\n",
    "        return 1\n",
    "\n",
    "check_value(df['Instragram page'][1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calculate_accounts_num_in_each_platform_per_country(df):\n",
    "    def check_value(value):\n",
    "        try:\n",
    "            return 0 if np.isnan(value) else 1\n",
    "        except:\n",
    "            return 1\n",
    "\n",
    "    temp_df = df[['X (Twitter) handle', 'Facebook page', 'Instragram page', 'Threads account', 'YouTube account', 'TikTok account', 'focus countries']]\n",
    "    temp_dic = {}\n",
    "    for twitter, facebook, instagram, threads, youtube, tiktok, country_list in temp_df.values:\n",
    "        for country in country_list:\n",
    "            if country not in list(temp_dic.keys()):\n",
    "                temp_dic[country] = {\n",
    "                        'twitter': check_value(twitter),\n",
    "                        'facebook': check_value(facebook),\n",
    "                        'instagram': check_value(instagram),\n",
    "                        'youtube': check_value(youtube),\n",
    "                        'tiktok': check_value(tiktok),\n",
    "                        'threads': check_value(threads),\n",
    "                        'total': check_value(twitter) + check_value(facebook) + check_value(instagram) \n",
    "                                + check_value(youtube) + check_value(tiktok) + check_value(threads)\n",
    "                    }\n",
    "            else:\n",
    "                temp_dic[country] = {\n",
    "                        'twitter': temp_dic[country]['twitter'] + check_value(twitter),\n",
    "                        'facebook': temp_dic[country]['facebook'] + check_value(facebook),\n",
    "                        'instagram': temp_dic[country]['instagram'] + check_value(instagram),\n",
    "                        'youtube': temp_dic[country]['youtube'] + check_value(youtube),\n",
    "                        'tiktok': temp_dic[country]['tiktok'] + check_value(tiktok),\n",
    "                        'threads': temp_dic[country]['threads'] + check_value(threads),\n",
    "                        'total': temp_dic[country]['total'] + check_value(twitter) + check_value(facebook) + check_value(instagram) \n",
    "                                + check_value(youtube) + check_value(tiktok) + check_value(threads)\n",
    "                    }\n",
    "    util_functions.save_file('findings/platform_accounts_per_country.json', temp_dic)  \n",
    "calculate_accounts_num_in_each_platform_per_country(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>37.760351</td>\n",
       "      <td>-122.408804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>37.742570</td>\n",
       "      <td>-122.442880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37.782312</td>\n",
       "      <td>-122.414677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>37.758022</td>\n",
       "      <td>-122.429864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>37.734436</td>\n",
       "      <td>-122.401977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>37.783346</td>\n",
       "      <td>-122.387878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>37.735048</td>\n",
       "      <td>-122.409797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>37.760410</td>\n",
       "      <td>-122.412200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>37.777346</td>\n",
       "      <td>-122.411560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>37.774905</td>\n",
       "      <td>-122.348657</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           lat         lon\n",
       "0    37.760351 -122.408804\n",
       "1    37.742570 -122.442880\n",
       "2    37.782312 -122.414677\n",
       "3    37.758022 -122.429864\n",
       "4    37.734436 -122.401977\n",
       "..         ...         ...\n",
       "995  37.783346 -122.387878\n",
       "996  37.735048 -122.409797\n",
       "997  37.760410 -122.412200\n",
       "998  37.777346 -122.411560\n",
       "999  37.774905 -122.348657\n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chart_data = pd.DataFrame(\n",
    "    np.random.randn(1000, 2) / [50, 50] + [37.76, -122.4],\n",
    "    columns=['lat', 'lon'])\n",
    "\n",
    "chart_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def create_no_accounts_of_each_platform_for_each_country(df):\n",
    "    temp_df = df[['X (Twitter) Follower #', 'Facebook Follower #', 'Instagram Follower #', 'YouTube Subscriber #', 'TikTok Subscriber #', 'Threads Follower #', 'focus countries']]\n",
    "    def check_value(value):\n",
    "        return 0 if np.isnan(value) else value\n",
    "    temp_dic = {}\n",
    "    for twitter_fol, facebook_fol, instagram_fol, youtube_fol, tiktok_fol, threads_fol, country_list in temp_df.values:\n",
    "        for country in country_list:\n",
    "            if country not in list(temp_dic.keys()):\n",
    "                temp_dic[country] = {\n",
    "                    'twitter': check_value(twitter_fol),\n",
    "                    'facebook': check_value(facebook_fol),\n",
    "                    'instagram': check_value(instagram_fol),\n",
    "                    'youtube': check_value(youtube_fol),\n",
    "                    'tiktok': check_value(tiktok_fol),\n",
    "                    'threads': check_value(threads_fol),\n",
    "                }\n",
    "            else:\n",
    "                temp_dic[country] = {\n",
    "                    'twitter': temp_dic[country]['twitter'] + check_value(twitter_fol),\n",
    "                    'facebook': temp_dic[country]['facebook'] + check_value(facebook_fol),\n",
    "                    'instagram': temp_dic[country]['instagram'] + check_value(instagram_fol),\n",
    "                    'youtube': temp_dic[country]['youtube'] + check_value(youtube_fol),\n",
    "                    'tiktok': temp_dic[country]['tiktok'] + check_value(tiktok_fol),\n",
    "                    'threads': temp_dic[country]['threads'] + check_value(threads_fol),\n",
    "                }\n",
    "    # util_functions.save_file('findings/follower_country.json', temp_dic)\n",
    "    return temp_dic\n",
    "temp_dic = create_followers_num_for_country(df)\n",
    "temp_dic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Parent entity (English) Entity owner (English)\n"
     ]
    }
   ],
   "source": [
    "options = ['Name (English)', 'Entity owner (English)', 'Parent entity (English)', 'focus countries']\n",
    "selected_options = ['Parent entity (English)', 'Entity owner (English)']\n",
    "\n",
    "\n",
    "temp_df = df[['Name (English)', 'Entity owner (English)', 'Parent entity (English)']]\n",
    "\n",
    "def generate_graph(selected_options):\n",
    "    color_code = {\n",
    "        'Name (English)': '#04c0b1',\n",
    "        'Entity owner (English)': '#274d4a',\n",
    "        'Parent entity (English)': '#088fbc',\n",
    "        'focus countries': '#e87551'\n",
    "    }\n",
    "    temp_my_dict = {\n",
    "        'Name (English)': 'name',\n",
    "        'Entity owner (English)': 'owner',\n",
    "        'Parent entity (English)': 'parent',\n",
    "        'focus countries': 'focus',\n",
    "    }\n",
    "\n",
    "    nodes = []\n",
    "    edges = []\n",
    "    node_colors = {}\n",
    "    if 'focus countries' not in selected_options:\n",
    "        to_node_name, from_node_name = find_priority(selected_options, temp_my_dict)\n",
    "        color_1 = color_code[to_node_name]\n",
    "        color_2 = color_code[from_node_name]\n",
    "        temp_df = df[['Name (English)', 'Entity owner (English)', 'Parent entity (English)']]\n",
    "        to_nodes_list = list(df[to_node_name].values)\n",
    "        for to_node in to_nodes_list:\n",
    "            from_node_list = list(temp_df[temp_df[to_node_name] == to_node][from_node_name].values)\n",
    "            for from_node in from_node_list:    \n",
    "                if to_node not in nodes:\n",
    "                    nodes.append(to_node)\n",
    "                    node_colors[to_node] = color_1\n",
    "                if from_node not in nodes:\n",
    "                    nodes.append(from_node)\n",
    "                    node_colors[from_node] = color_2\n",
    "                edge = [from_node, to_node]\n",
    "                if edge not in edges:\n",
    "                    edges.append(edge)\n",
    "\n",
    "    else:\n",
    "        opt1, opt2 = check_selected(selected_options, temp_my_dict)\n",
    "        color_1 = color_code[opt1]\n",
    "        color_2 = color_code[opt2]\n",
    "        for country in list(country_info_dict.keys()):\n",
    "            to_node = country\n",
    "            items_list = country_info_dict[country][temp_my_dict[opt2]]\n",
    "            if to_node not in nodes:\n",
    "                nodes.append(to_node)\n",
    "                node_colors[to_node] = color_1\n",
    "            for each in items_list:\n",
    "                from_node = each\n",
    "                if from_node not in nodes:\n",
    "                    nodes.append(from_node)\n",
    "                    node_colors[from_node] = color_2\n",
    "                edge = [from_node, to_node]\n",
    "                if edge not in edges:\n",
    "                    edges.append(edge)\n",
    "                    \n",
    "    return nodes, edges, node_colors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "country_info = country_info_dict[selected_country_name]\n",
    "\n",
    "# Ensure that all lists have the same length\n",
    "min_length = min(map(len, country_info.values()))\n",
    "country_info = {key: value[:min_length] for key, value in country_info.items()}\n",
    "\n",
    "# Create a DataFrame from the country_info dictionary\n",
    "country_df = pd.DataFrame(country_info)\n",
    "\n",
    "# Display the scrollable table\n",
    "st.dataframe(country_df.style.set_properties(**{'max-height': '400px', 'overflow-y': 'auto'}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "selected_language = 'Australia'\n",
    "selected_column = 'X (Twitter) Follower #'\n",
    "\n",
    "filtered_df = df[df['Language'] == selected_language]\n",
    "filtered_df = filtered_df[filtered_df[selected_column].notna()]\n",
    "filtered_df = filtered_df.set_index('Account Name')\n",
    "filtered_df = filtered_df.sort_values(selected_column, ascending=False)\n",
    "filtered_df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Region of Focus', 'Language', 'Entity owner (English)',\n",
       "       'Parent entity (English)', 'X (Twitter) handle', 'X (Twitter) URL',\n",
       "       'X (Twitter) Follower #', 'Facebook page', 'Facebook URL',\n",
       "       'Facebook Follower #', 'Instragram page', 'Instagram URL',\n",
       "       'Instagram Follower #', 'Threads account', 'Threads URL',\n",
       "       'Threads Follower #', 'YouTube account', 'YouTube URL',\n",
       "       'YouTube Subscriber #', 'TikTok account', 'TikTok URL',\n",
       "       'TikTok Subscriber #', 'Name (English)', 'focus countries',\n",
       "       'Account Name', 'is_blue_verified', 'created_at', 'followers_count',\n",
       "       'following_count', 'tweet_num', 'followers_following_ratio',\n",
       "       'formatted_created_at', 'type'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "0 if np.isnan(temp_df.iloc[100].values[3]) else temp_df.iloc[0].values[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Australia': {'twitter': 38020015.0,\n",
       "  'facebook': 593967165.0,\n",
       "  'instagram': 6985631.0,\n",
       "  'youtube': 6531766.0,\n",
       "  'tiktok': 10259284.0,\n",
       "  'threads': 260707.0},\n",
       " 'Canada': {'twitter': 39095655.0,\n",
       "  'facebook': 619828195.0,\n",
       "  'instagram': 7257268.0,\n",
       "  'youtube': 6947234.0,\n",
       "  'tiktok': 10420258.0,\n",
       "  'threads': 260707.0},\n",
       " 'New Zealand': {'twitter': 37998503.0,\n",
       "  'facebook': 592463965.0,\n",
       "  'instagram': 6985510.0,\n",
       "  'youtube': 6372766.0,\n",
       "  'tiktok': 10259284.0,\n",
       "  'threads': 260707.0},\n",
       " 'United Kingdom': {'twitter': 38429756.0,\n",
       "  'facebook': 592461865.0,\n",
       "  'instagram': 6985560.0,\n",
       "  'youtube': 6373069.0,\n",
       "  'tiktok': 10333010.0,\n",
       "  'threads': 260707.0},\n",
       " 'United States of America': {'twitter': 39145466.0,\n",
       "  'facebook': 597511350.0,\n",
       "  'instagram': 7379416.0,\n",
       "  'youtube': 7072782.0,\n",
       "  'tiktok': 10378269.0,\n",
       "  'threads': 273077.0},\n",
       " 'Ireland': {'twitter': 38075865.0,\n",
       "  'facebook': 594953865.0,\n",
       "  'instagram': 7015510.0,\n",
       "  'youtube': 6630116.0,\n",
       "  'tiktok': 10485084.0,\n",
       "  'threads': 260707.0},\n",
       " 'China': {'twitter': 24541465.0,\n",
       "  'facebook': 288357055.0,\n",
       "  'instagram': 6195647.0,\n",
       "  'youtube': 16055173.0,\n",
       "  'tiktok': 5118738.0,\n",
       "  'threads': 156686.0},\n",
       " 'Afghanistan': {'twitter': 32136.0,\n",
       "  'facebook': 4800000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 695.0,\n",
       "  'tiktok': 326100.0,\n",
       "  'threads': 0},\n",
       " 'Switzerland': {'twitter': 1114733.0,\n",
       "  'facebook': 27366330.0,\n",
       "  'instagram': 271758.0,\n",
       "  'youtube': 574468.0,\n",
       "  'tiktok': 183174.0,\n",
       "  'threads': 0},\n",
       " 'Austria': {'twitter': 138614.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Indonesia': {'twitter': 148301.0,\n",
       "  'facebook': 303000.0,\n",
       "  'instagram': 74900.0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'United Arab Emirates': {'twitter': 862910.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310864.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Belgium': {'twitter': 1178555.0,\n",
       "  'facebook': 29858330.0,\n",
       "  'instagram': 301758.0,\n",
       "  'youtube': 831818.0,\n",
       "  'tiktok': 368074.0,\n",
       "  'threads': 0},\n",
       " 'Bulgaria': {'twitter': 84909.0,\n",
       "  'facebook': 2493600.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Croatia': {'twitter': 77541.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Cyprus': {'twitter': 78450.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Czechia': {'twitter': 76037.0,\n",
       "  'facebook': 2526000.0,\n",
       "  'instagram': 30183.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225824.0,\n",
       "  'threads': 0},\n",
       " 'Denmark': {'twitter': 78044.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Estonia': {'twitter': 77325.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Finland': {'twitter': 76652.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'France': {'twitter': 1434584.0,\n",
       "  'facebook': 29919330.0,\n",
       "  'instagram': 304351.0,\n",
       "  'youtube': 831818.0,\n",
       "  'tiktok': 536674.0,\n",
       "  'threads': 0},\n",
       " 'Germany': {'twitter': 91463.0,\n",
       "  'facebook': 3564000.0,\n",
       "  'instagram': 30761.0,\n",
       "  'youtube': 265812.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Greece': {'twitter': 80080.0,\n",
       "  'facebook': 2648000.0,\n",
       "  'instagram': 31387.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Hungary': {'twitter': 82283.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Italy': {'twitter': 133822.0,\n",
       "  'facebook': 3448700.0,\n",
       "  'instagram': 32175.0,\n",
       "  'youtube': 261270.0,\n",
       "  'tiktok': 233789.0,\n",
       "  'threads': 0},\n",
       " 'Latvia': {'twitter': 75916.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30007.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Lithuania': {'twitter': 93555.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Luxembourg': {'twitter': 75916.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Malta': {'twitter': 98372.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Netherlands': {'twitter': 92827.0,\n",
       "  'facebook': 2592000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Poland': {'twitter': 88947.0,\n",
       "  'facebook': 2880000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 258246.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Portugal': {'twitter': 85531.0,\n",
       "  'facebook': 3492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Romania': {'twitter': 75916.0,\n",
       "  'facebook': 2988000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Slovakia': {'twitter': 81355.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Slovenia': {'twitter': 80974.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Spain': {'twitter': 122876.0,\n",
       "  'facebook': 12776967.0,\n",
       "  'instagram': 128452.0,\n",
       "  'youtube': 831569.0,\n",
       "  'tiktok': 397034.0,\n",
       "  'threads': 0},\n",
       " 'Sweden': {'twitter': 75916.0,\n",
       "  'facebook': 2492000.0,\n",
       "  'instagram': 30000.0,\n",
       "  'youtube': 257350.0,\n",
       "  'tiktok': 225800.0,\n",
       "  'threads': 0},\n",
       " 'Nigeria': {'twitter': 230712.0,\n",
       "  'facebook': 7187965.0,\n",
       "  'instagram': 41500.0,\n",
       "  'youtube': 824000.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Egypt': {'twitter': 1089964.0,\n",
       "  'facebook': 19021599.0,\n",
       "  'instagram': 368502.0,\n",
       "  'youtube': 4284558.0,\n",
       "  'tiktok': 1083166.0,\n",
       "  'threads': 21.0},\n",
       " 'South Africa': {'twitter': 279423.0,\n",
       "  'facebook': 5468965.0,\n",
       "  'instagram': 41500.0,\n",
       "  'youtube': 824000.0,\n",
       "  'tiktok': 56.0,\n",
       "  'threads': 0},\n",
       " 'Algeria': {'twitter': 1089782.0,\n",
       "  'facebook': 15894299.0,\n",
       "  'instagram': 352345.0,\n",
       "  'youtube': 4237158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Morocco': {'twitter': 1067176.0,\n",
       "  'facebook': 15863399.0,\n",
       "  'instagram': 352345.0,\n",
       "  'youtube': 4237158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Lesotho': {'twitter': 2710.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Iran': {'twitter': 865017.0,\n",
       "  'facebook': 13574334.0,\n",
       "  'instagram': 419637.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Serbia': {'twitter': 17497.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Saudi Arabia': {'twitter': 942585.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Burundi': {'twitter': 4693.0,\n",
       "  'facebook': 2200000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 71.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Cameroon': {'twitter': 3147.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Democratic Rep. Congo': {'twitter': 20561.0,\n",
       "  'facebook': 132.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 454.0,\n",
       "  'tiktok': 35.0,\n",
       "  'threads': 0},\n",
       " 'Chad': {'twitter': 5478.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Trinidad and Tobago': {'twitter': 1809.0,\n",
       "  'facebook': 5600.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Japan': {'twitter': 338003.0,\n",
       "  'facebook': 7960089.0,\n",
       "  'instagram': 70.0,\n",
       "  'youtube': 11209.0,\n",
       "  'tiktok': 529297.0,\n",
       "  'threads': 0},\n",
       " 'Suriname': {'twitter': 14961.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'South Korea': {'twitter': 332926.0,\n",
       "  'facebook': 1395500.0,\n",
       "  'instagram': 14988.0,\n",
       "  'youtube': 1474.0,\n",
       "  'tiktok': 323.0,\n",
       "  'threads': 0},\n",
       " 'Pakistan': {'twitter': 689475.0,\n",
       "  'facebook': 15351600.0,\n",
       "  'instagram': 159.0,\n",
       "  'youtube': 3961.0,\n",
       "  'tiktok': 16776.0,\n",
       "  'threads': 0},\n",
       " 'Qatar': {'twitter': 845299.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Bahrain': {'twitter': 840118.0,\n",
       "  'facebook': 12374334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Iraq': {'twitter': 851817.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Jordan': {'twitter': 843982.0,\n",
       "  'facebook': 11279234.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Kuwait': {'twitter': 842268.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Lebanon': {'twitter': 851317.0,\n",
       "  'facebook': 11278334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Libya': {'twitter': 838617.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Oman': {'twitter': 838617.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Sudan': {'twitter': 844715.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Syria': {'twitter': 838617.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Tunisia': {'twitter': 838617.0,\n",
       "  'facebook': 11274334.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Yemen': {'twitter': 901317.0,\n",
       "  'facebook': 11281134.0,\n",
       "  'instagram': 310845.0,\n",
       "  'youtube': 3413158.0,\n",
       "  'tiktok': 661366.0,\n",
       "  'threads': 0},\n",
       " 'Russia': {'twitter': 334541.0,\n",
       "  'facebook': 367000.0,\n",
       "  'instagram': 1478.0,\n",
       "  'youtube': 263685.0,\n",
       "  'tiktok': 677.0,\n",
       "  'threads': 0},\n",
       " 'Kenya': {'twitter': 18511.0,\n",
       "  'facebook': 2288000.0,\n",
       "  'instagram': 1919.0,\n",
       "  'youtube': 22.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Tanzania': {'twitter': 33550.0,\n",
       "  'facebook': 2200000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Somalia': {'twitter': 12441.0,\n",
       "  'facebook': 75000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'India': {'twitter': 136625.0,\n",
       "  'facebook': 30617045.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 692000.0,\n",
       "  'tiktok': 2548.0,\n",
       "  'threads': 62.0},\n",
       " 'Maldives': {'twitter': 23321.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Zimbabwe': {'twitter': 33600.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Colombia': {'twitter': 24991.0,\n",
       "  'facebook': 10284967.0,\n",
       "  'instagram': 98452.0,\n",
       "  'youtube': 574219.0,\n",
       "  'tiktok': 171234.0,\n",
       "  'threads': 0},\n",
       " 'Ukraine': {'twitter': 882.0,\n",
       "  'facebook': 333500.0,\n",
       "  'instagram': 1868.0,\n",
       "  'youtube': 43.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Brunei': {'twitter': 107600.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Cambodia': {'twitter': 107600.0,\n",
       "  'facebook': 78000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Laos': {'twitter': 107600.0,\n",
       "  'facebook': 3100000.0,\n",
       "  'instagram': 9392.0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Malaysia': {'twitter': 107600.0,\n",
       "  'facebook': 1516605.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Myanmar (Burma)': {'twitter': 107600.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Philippines': {'twitter': 122200.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Singapore': {'twitter': 107600.0,\n",
       "  'facebook': 102700.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Thailand': {'twitter': 119877.0,\n",
       "  'facebook': 3076000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 22800.0,\n",
       "  'threads': 0},\n",
       " 'Vietnam': {'twitter': 107600.0,\n",
       "  'facebook': 3148664.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 20600.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Samoa': {'twitter': 5368.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Kazakhstan': {'twitter': 7354.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 5197.0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Turkey': {'twitter': 94527.0,\n",
       "  'facebook': 116000.0,\n",
       "  'instagram': 61307.0,\n",
       "  'youtube': 45009.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 493.0},\n",
       " 'South Sudan': {'twitter': 1318.0,\n",
       "  'facebook': 2200000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Ethiopia': {'twitter': 17200.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Chile': {'twitter': 2479.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Dominican Republic': {'twitter': 8233.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 6713.0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Angola': {'twitter': 10879.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Antigua and Barbuda': {'twitter': 1779.0,\n",
       "  'facebook': 113.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Argentina': {'twitter': 16732.0,\n",
       "  'facebook': 10284967.0,\n",
       "  'instagram': 98452.0,\n",
       "  'youtube': 574219.0,\n",
       "  'tiktok': 171234.0,\n",
       "  'threads': 0},\n",
       " 'Malawi': {'twitter': 6419.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Albania': {'twitter': 9666.0,\n",
       "  'facebook': 1100011.0,\n",
       "  'instagram': 1714.0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Eritrea': {'twitter': 5816.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Grenada': {'twitter': 11667.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Ghana': {'twitter': 5437.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Mauritania': {'twitter': 3033.0,\n",
       "  'facebook': 4200.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Rwanda': {'twitter': 2358.0,\n",
       "  'facebook': 2200000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Namibia': {'twitter': 1890.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Peru': {'twitter': 11900.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Sri Lanka': {'twitter': 26066.0,\n",
       "  'facebook': 3473000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 36.0,\n",
       "  'tiktok': 43500.0,\n",
       "  'threads': 0},\n",
       " 'Mali': {'twitter': 4741.0,\n",
       "  'facebook': 3900.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Guinea': {'twitter': 5545.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Senegal': {'twitter': 1481.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Djibouti': {'twitter': 3205.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Gambia': {'twitter': 1617.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Fiji': {'twitter': 3216.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Papua New Guinea': {'twitter': 6257.0,\n",
       "  'facebook': 2100.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Uganda': {'twitter': 18428.0,\n",
       "  'facebook': 2201500.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Montenegro': {'twitter': 1514.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Liberia': {'twitter': 6373.0,\n",
       "  'facebook': 595.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Brazil': {'twitter': 231647.0,\n",
       "  'facebook': 1700000.0,\n",
       "  'instagram': 141300.0,\n",
       "  'youtube': 29610.0,\n",
       "  'tiktok': 225900.0,\n",
       "  'threads': 1035.0},\n",
       " 'Mongolia': {'twitter': 0.0,\n",
       "  'facebook': 9800.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Botswana': {'twitter': 2733.0,\n",
       "  'facebook': 41000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Ecuador': {'twitter': 8261.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'El Salvador': {'twitter': 40600.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Uruguay': {'twitter': 4711.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Tonga': {'twitter': 2533.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Cuba': {'twitter': 66054.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Equatorial Guinea': {'twitter': 4656.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Mexico': {'twitter': 97445.0,\n",
       "  'facebook': 10419967.0,\n",
       "  'instagram': 98452.0,\n",
       "  'youtube': 574219.0,\n",
       "  'tiktok': 171234.0,\n",
       "  'threads': 0},\n",
       " 'Panama': {'twitter': 42666.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Venezuela': {'twitter': 9878.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Iceland': {'twitter': 6747.0,\n",
       "  'facebook': 989.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'São Tomé and Príncipe': {'twitter': 8830.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Mauritius': {'twitter': 7800.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Costa Rica': {'twitter': 2236.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Myanmar': {'twitter': 12692.0,\n",
       "  'facebook': 5081000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 39600.0,\n",
       "  'tiktok': 1632982.0,\n",
       "  'threads': 0},\n",
       " 'Cape Verde': {'twitter': 6719.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Guinea-Bissau': {'twitter': 6719.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Mozambique': {'twitter': 6719.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Nepal': {'twitter': 74080.0,\n",
       "  'facebook': 3122000.0,\n",
       "  'instagram': 4120.0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Israel': {'twitter': 9.0,\n",
       "  'facebook': 86922.0,\n",
       "  'instagram': 158.0,\n",
       "  'youtube': 45431.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Bolivia': {'twitter': 5011.0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Norway': {'twitter': 1555.0,\n",
       "  'facebook': 5100.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Barbados': {'twitter': 8723.0,\n",
       "  'facebook': 491.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Belarus': {'twitter': 7403.0,\n",
       "  'facebook': 971.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Kyrgyzstan': {'twitter': 0,\n",
       "  'facebook': 0,\n",
       "  'instagram': 2082.0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Taiwan': {'twitter': 0,\n",
       "  'facebook': 432000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 41000.0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Bangladesh': {'twitter': 0,\n",
       "  'facebook': 240000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Guyana': {'twitter': 0,\n",
       "  'facebook': 2400.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'North Macedonia': {'twitter': 0,\n",
       "  'facebook': 4300.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0},\n",
       " 'Sierra Leone': {'twitter': 0,\n",
       "  'facebook': 12000.0,\n",
       "  'instagram': 0,\n",
       "  'youtube': 0,\n",
       "  'tiktok': 0,\n",
       "  'threads': 0}}"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def create_followers_num_for_country(df):\n",
    "    temp_df = df[['X (Twitter) Follower #', 'Facebook Follower #', 'Instagram Follower #', 'YouTube Subscriber #', 'TikTok Subscriber #', 'Threads Follower #', 'focus countries']]\n",
    "    def check_value(value):\n",
    "        return 0 if np.isnan(value) else value\n",
    "    temp_dic = {}\n",
    "    for twitter_fol, facebook_fol, instagram_fol, youtube_fol, tiktok_fol, threads_fol, country_list in temp_df.values:\n",
    "        for country in country_list:\n",
    "            if country not in list(temp_dic.keys()):\n",
    "                temp_dic[country] = {\n",
    "                    'twitter': check_value(twitter_fol),\n",
    "                    'facebook': check_value(facebook_fol),\n",
    "                    'instagram': check_value(instagram_fol),\n",
    "                    'youtube': check_value(youtube_fol),\n",
    "                    'tiktok': check_value(tiktok_fol),\n",
    "                    'threads': check_value(threads_fol),\n",
    "                }\n",
    "            else:\n",
    "                temp_dic[country] = {\n",
    "                    'twitter': temp_dic[country]['twitter'] + check_value(twitter_fol),\n",
    "                    'facebook': temp_dic[country]['facebook'] + check_value(facebook_fol),\n",
    "                    'instagram': temp_dic[country]['instagram'] + check_value(instagram_fol),\n",
    "                    'youtube': temp_dic[country]['youtube'] + check_value(youtube_fol),\n",
    "                    'tiktok': temp_dic[country]['tiktok'] + check_value(tiktok_fol),\n",
    "                    'threads': temp_dic[country]['threads'] + check_value(threads_fol),\n",
    "                }\n",
    "    util_functions.save_file('findings/follower_country.json', temp_dic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "# filtered_df[filtered_df[selected_column].notna()].set_index('Account Name', inplace=True)\n",
    "# filtered_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>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>Facebook Follower #</th>\n",
       "      <th>...</th>\n",
       "      <th>Name (English)</th>\n",
       "      <th>focus group</th>\n",
       "      <th>is_blue_verified</th>\n",
       "      <th>created_at</th>\n",
       "      <th>followers_count</th>\n",
       "      <th>following_count</th>\n",
       "      <th>tweet_num</th>\n",
       "      <th>followers_following_ratio</th>\n",
       "      <th>formatted_created_at</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Account Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CGTN</th>\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>ChinaGlobalTVNetwork</td>\n",
       "      <td>https://www.facebook.com/ChinaGlobalTVNetwork</td>\n",
       "      <td>116450496.0</td>\n",
       "      <td>...</td>\n",
       "      <td>CGTN</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>True</td>\n",
       "      <td>2013-01-24 03:18:59</td>\n",
       "      <td>12997461.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>287284.0</td>\n",
       "      <td>171019.223662</td>\n",
       "      <td>2013-01-24</td>\n",
       "      <td>Media &amp; News Company</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>China Daily</th>\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>chinadaily</td>\n",
       "      <td>https://www.facebook.com/chinadaily</td>\n",
       "      <td>104613175.0</td>\n",
       "      <td>...</td>\n",
       "      <td>China Daily</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>True</td>\n",
       "      <td>2009-11-05 20:30:10</td>\n",
       "      <td>4164585.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>211333.0</td>\n",
       "      <td>26526.019107</td>\n",
       "      <td>2009-11-05</td>\n",
       "      <td>Media &amp; News Company</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hua Chunying</th>\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>profile.php?id=100092522612975</td>\n",
       "      <td>https://www.facebook.com/profile.php?id=100092...</td>\n",
       "      <td>744.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Hua Chunying</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>True</td>\n",
       "      <td>2019-10-14 10:56:54</td>\n",
       "      <td>2321222.0</td>\n",
       "      <td>218.0</td>\n",
       "      <td>11310.0</td>\n",
       "      <td>10647.807339</td>\n",
       "      <td>2019-10-14</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>People's Daily China Science</th>\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>ChinaScience</td>\n",
       "      <td>https://twitter.com/ChinaScience</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>PDChinaScience/</td>\n",
       "      <td>https://www.facebook.com/PDChinaScience/</td>\n",
       "      <td>5800000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>People's Daily China Science</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>True</td>\n",
       "      <td>2019-08-23 16:40:11</td>\n",
       "      <td>2036766.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10007.0</td>\n",
       "      <td>203676.599796</td>\n",
       "      <td>2019-08-23</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhao Lijian</th>\n",
       "      <td>Anglosphere</td>\n",
       "      <td>English</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>zlj517</td>\n",
       "      <td>https://twitter.com/zlj517</td>\n",
       "      <td>1900000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Zhao Lijian</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>True</td>\n",
       "      <td>2010-05-08 15:38:36</td>\n",
       "      <td>1924909.0</td>\n",
       "      <td>169385.0</td>\n",
       "      <td>71656.0</td>\n",
       "      <td>11.364105</td>\n",
       "      <td>2010-05-08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wang Tianyu (Evan Wang)</th>\n",
       "      <td>Anglosphere</td>\n",
       "      <td>English</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "      <td>wty510</td>\n",
       "      <td>https://twitter.com/wty510</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Wang Tianyu (Evan Wang)</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>False</td>\n",
       "      <td>2014-09-02 06:50:49</td>\n",
       "      <td>9.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.082569</td>\n",
       "      <td>2014-09-02</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zheng Chenlei (Blair Zheng)</th>\n",
       "      <td>Anglosphere</td>\n",
       "      <td>English</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "      <td>BlairZheng1</td>\n",
       "      <td>https://twitter.com/BlairZheng1</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Zheng Chenlei (Blair Zheng)</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>False</td>\n",
       "      <td>2012-11-07 05:04:27</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>2012-11-07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zhang Lin (Melody Zhang)</th>\n",
       "      <td>Anglosphere</td>\n",
       "      <td>English</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "      <td>MelodyZ77141898</td>\n",
       "      <td>https://twitter.com/MelodyZ77141898</td>\n",
       "      <td>3.0</td>\n",
       "      <td>profile.php?id=100060124341866</td>\n",
       "      <td>https://www.facebook.com/Money-Honey-with-Melo...</td>\n",
       "      <td>962000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Zhang Lin (Melody Zhang)</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>False</td>\n",
       "      <td>2021-02-08 12:39:16</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.148148</td>\n",
       "      <td>2021-02-08</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ji Yuqiao</th>\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>yuqiaoji</td>\n",
       "      <td>https://twitter.com/yuqiaoji</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Ji Yuqiao</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-08-29 03:44:16</td>\n",
       "      <td>5.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>522.0</td>\n",
       "      <td>0.128205</td>\n",
       "      <td>2016-08-29</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CGTN Inheritors</th>\n",
       "      <td>Anglosphere</td>\n",
       "      <td>English</td>\n",
       "      <td>China Media Group (CMG)</td>\n",
       "      <td>Central Publicity Department</td>\n",
       "      <td>cgtn_inheritors</td>\n",
       "      <td>https://twitter.com/cgtn_inheritors</td>\n",
       "      <td>0.0</td>\n",
       "      <td>cgtn.inheritors</td>\n",
       "      <td>https://www.facebook.com/cgtn.inheritors/</td>\n",
       "      <td>204000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>CGTN Inheritors</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>370 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Region of Focus Language  \\\n",
       "Account Name                                            \n",
       "CGTN                             Anglosphere  English   \n",
       "China Daily                      Anglosphere  English   \n",
       "Hua Chunying                     Anglosphere  English   \n",
       "People's Daily China Science     Anglosphere  English   \n",
       "Zhao Lijian                      Anglosphere  English   \n",
       "...                                      ...      ...   \n",
       "Wang Tianyu (Evan Wang)          Anglosphere  English   \n",
       "Zheng Chenlei (Blair Zheng)      Anglosphere  English   \n",
       "Zhang Lin (Melody Zhang)         Anglosphere  English   \n",
       "Ji Yuqiao                        Anglosphere  English   \n",
       "CGTN Inheritors                  Anglosphere  English   \n",
       "\n",
       "                                   Entity owner (English)  \\\n",
       "Account Name                                                \n",
       "CGTN                              China Media Group (CMG)   \n",
       "China Daily                             China Daily Press   \n",
       "Hua Chunying                  Ministry of Foreign Affairs   \n",
       "People's Daily China Science         People's Daily Press   \n",
       "Zhao Lijian                   Ministry of Foreign Affairs   \n",
       "...                                                   ...   \n",
       "Wang Tianyu (Evan Wang)           China Media Group (CMG)   \n",
       "Zheng Chenlei (Blair Zheng)       China Media Group (CMG)   \n",
       "Zhang Lin (Melody Zhang)          China Media Group (CMG)   \n",
       "Ji Yuqiao                            People's Daily Press   \n",
       "CGTN Inheritors                   China Media Group (CMG)   \n",
       "\n",
       "                                                       Parent entity (English)  \\\n",
       "Account Name                                                                     \n",
       "CGTN                                              Central Publicity Department   \n",
       "China Daily                                       Central Publicity Department   \n",
       "Hua Chunying                                       Ministry of Foreign Affairs   \n",
       "People's Daily China Science  Central Committee of the Chinese Communist Party   \n",
       "Zhao Lijian                                        Ministry of Foreign Affairs   \n",
       "...                                                                        ...   \n",
       "Wang Tianyu (Evan Wang)                           Central Publicity Department   \n",
       "Zheng Chenlei (Blair Zheng)                       Central Publicity Department   \n",
       "Zhang Lin (Melody Zhang)                          Central Publicity Department   \n",
       "Ji Yuqiao                     Central Committee of the Chinese Communist Party   \n",
       "CGTN Inheritors                                   Central Publicity Department   \n",
       "\n",
       "                             X (Twitter) handle  \\\n",
       "Account Name                                      \n",
       "CGTN                               CGTNOfficial   \n",
       "China Daily                          ChinaDaily   \n",
       "Hua Chunying                    SpokespersonCHN   \n",
       "People's Daily China Science       ChinaScience   \n",
       "Zhao Lijian                              zlj517   \n",
       "...                                         ...   \n",
       "Wang Tianyu (Evan Wang)                  wty510   \n",
       "Zheng Chenlei (Blair Zheng)         BlairZheng1   \n",
       "Zhang Lin (Melody Zhang)        MelodyZ77141898   \n",
       "Ji Yuqiao                              yuqiaoji   \n",
       "CGTN Inheritors                 cgtn_inheritors   \n",
       "\n",
       "                                                  X (Twitter) URL  \\\n",
       "Account Name                                                        \n",
       "CGTN                             https://twitter.com/CGTNOfficial   \n",
       "China Daily                        https://twitter.com/ChinaDaily   \n",
       "Hua Chunying                  https://twitter.com/SpokespersonCHN   \n",
       "People's Daily China Science     https://twitter.com/ChinaScience   \n",
       "Zhao Lijian                            https://twitter.com/zlj517   \n",
       "...                                                           ...   \n",
       "Wang Tianyu (Evan Wang)                https://twitter.com/wty510   \n",
       "Zheng Chenlei (Blair Zheng)       https://twitter.com/BlairZheng1   \n",
       "Zhang Lin (Melody Zhang)      https://twitter.com/MelodyZ77141898   \n",
       "Ji Yuqiao                            https://twitter.com/yuqiaoji   \n",
       "CGTN Inheritors               https://twitter.com/cgtn_inheritors   \n",
       "\n",
       "                              X (Twitter) Follower #  \\\n",
       "Account Name                                           \n",
       "CGTN                                      13000000.0   \n",
       "China Daily                                4100000.0   \n",
       "Hua Chunying                               2200000.0   \n",
       "People's Daily China Science               2000000.0   \n",
       "Zhao Lijian                                1900000.0   \n",
       "...                                              ...   \n",
       "Wang Tianyu (Evan Wang)                          7.0   \n",
       "Zheng Chenlei (Blair Zheng)                      7.0   \n",
       "Zhang Lin (Melody Zhang)                         3.0   \n",
       "Ji Yuqiao                                        3.0   \n",
       "CGTN Inheritors                                  0.0   \n",
       "\n",
       "                                               Facebook page  \\\n",
       "Account Name                                                   \n",
       "CGTN                                    ChinaGlobalTVNetwork   \n",
       "China Daily                                       chinadaily   \n",
       "Hua Chunying                  profile.php?id=100092522612975   \n",
       "People's Daily China Science                 PDChinaScience/   \n",
       "Zhao Lijian                                              NaN   \n",
       "...                                                      ...   \n",
       "Wang Tianyu (Evan Wang)                                  NaN   \n",
       "Zheng Chenlei (Blair Zheng)                              NaN   \n",
       "Zhang Lin (Melody Zhang)      profile.php?id=100060124341866   \n",
       "Ji Yuqiao                                                NaN   \n",
       "CGTN Inheritors                              cgtn.inheritors   \n",
       "\n",
       "                                                                   Facebook URL  \\\n",
       "Account Name                                                                      \n",
       "CGTN                              https://www.facebook.com/ChinaGlobalTVNetwork   \n",
       "China Daily                                 https://www.facebook.com/chinadaily   \n",
       "Hua Chunying                  https://www.facebook.com/profile.php?id=100092...   \n",
       "People's Daily China Science           https://www.facebook.com/PDChinaScience/   \n",
       "Zhao Lijian                                                                 NaN   \n",
       "...                                                                         ...   \n",
       "Wang Tianyu (Evan Wang)                                                     NaN   \n",
       "Zheng Chenlei (Blair Zheng)                                                 NaN   \n",
       "Zhang Lin (Melody Zhang)      https://www.facebook.com/Money-Honey-with-Melo...   \n",
       "Ji Yuqiao                                                                   NaN   \n",
       "CGTN Inheritors                       https://www.facebook.com/cgtn.inheritors/   \n",
       "\n",
       "                              Facebook Follower #  ...  \\\n",
       "Account Name                                       ...   \n",
       "CGTN                                  116450496.0  ...   \n",
       "China Daily                           104613175.0  ...   \n",
       "Hua Chunying                                744.0  ...   \n",
       "People's Daily China Science            5800000.0  ...   \n",
       "Zhao Lijian                                   NaN  ...   \n",
       "...                                           ...  ...   \n",
       "Wang Tianyu (Evan Wang)                       NaN  ...   \n",
       "Zheng Chenlei (Blair Zheng)                   NaN  ...   \n",
       "Zhang Lin (Melody Zhang)                 962000.0  ...   \n",
       "Ji Yuqiao                                     NaN  ...   \n",
       "CGTN Inheritors                          204000.0  ...   \n",
       "\n",
       "                                            Name (English)  \\\n",
       "Account Name                                                 \n",
       "CGTN                                                  CGTN   \n",
       "China Daily                                    China Daily   \n",
       "Hua Chunying                                  Hua Chunying   \n",
       "People's Daily China Science  People's Daily China Science   \n",
       "Zhao Lijian                                    Zhao Lijian   \n",
       "...                                                    ...   \n",
       "Wang Tianyu (Evan Wang)            Wang Tianyu (Evan Wang)   \n",
       "Zheng Chenlei (Blair Zheng)    Zheng Chenlei (Blair Zheng)   \n",
       "Zhang Lin (Melody Zhang)          Zhang Lin (Melody Zhang)   \n",
       "Ji Yuqiao                                        Ji Yuqiao   \n",
       "CGTN Inheritors                            CGTN Inheritors   \n",
       "\n",
       "                                                                    focus group  \\\n",
       "Account Name                                                                      \n",
       "CGTN                          [Australia, Canada, New Zealand, United Kingdo...   \n",
       "China Daily                   [Australia, Canada, New Zealand, United Kingdo...   \n",
       "Hua Chunying                  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "People's Daily China Science  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "Zhao Lijian                   [Australia, Canada, New Zealand, United Kingdo...   \n",
       "...                                                                         ...   \n",
       "Wang Tianyu (Evan Wang)       [Australia, Canada, New Zealand, United Kingdo...   \n",
       "Zheng Chenlei (Blair Zheng)   [Australia, Canada, New Zealand, United Kingdo...   \n",
       "Zhang Lin (Melody Zhang)      [Australia, Canada, New Zealand, United Kingdo...   \n",
       "Ji Yuqiao                     [Australia, Canada, New Zealand, United Kingdo...   \n",
       "CGTN Inheritors               [Australia, Canada, New Zealand, United Kingdo...   \n",
       "\n",
       "                              is_blue_verified          created_at  \\\n",
       "Account Name                                                         \n",
       "CGTN                                      True 2013-01-24 03:18:59   \n",
       "China Daily                               True 2009-11-05 20:30:10   \n",
       "Hua Chunying                              True 2019-10-14 10:56:54   \n",
       "People's Daily China Science              True 2019-08-23 16:40:11   \n",
       "Zhao Lijian                               True 2010-05-08 15:38:36   \n",
       "...                                        ...                 ...   \n",
       "Wang Tianyu (Evan Wang)                  False 2014-09-02 06:50:49   \n",
       "Zheng Chenlei (Blair Zheng)              False 2012-11-07 05:04:27   \n",
       "Zhang Lin (Melody Zhang)                 False 2021-02-08 12:39:16   \n",
       "Ji Yuqiao                                False 2016-08-29 03:44:16   \n",
       "CGTN Inheritors                            NaN                 NaT   \n",
       "\n",
       "                             followers_count  following_count tweet_num  \\\n",
       "Account Name                                                              \n",
       "CGTN                              12997461.0             76.0  287284.0   \n",
       "China Daily                        4164585.0            157.0  211333.0   \n",
       "Hua Chunying                       2321222.0            218.0   11310.0   \n",
       "People's Daily China Science       2036766.0             10.0   10007.0   \n",
       "Zhao Lijian                        1924909.0         169385.0   71656.0   \n",
       "...                                      ...              ...       ...   \n",
       "Wang Tianyu (Evan Wang)                  9.0            109.0      19.0   \n",
       "Zheng Chenlei (Blair Zheng)              8.0             12.0      27.0   \n",
       "Zhang Lin (Melody Zhang)                 4.0             27.0      13.0   \n",
       "Ji Yuqiao                                5.0             39.0     522.0   \n",
       "CGTN Inheritors                          NaN              NaN       NaN   \n",
       "\n",
       "                             followers_following_ratio  formatted_created_at  \\\n",
       "Account Name                                                                   \n",
       "CGTN                                     171019.223662            2013-01-24   \n",
       "China Daily                               26526.019107            2009-11-05   \n",
       "Hua Chunying                              10647.807339            2019-10-14   \n",
       "People's Daily China Science             203676.599796            2019-08-23   \n",
       "Zhao Lijian                                  11.364105            2010-05-08   \n",
       "...                                                ...                   ...   \n",
       "Wang Tianyu (Evan Wang)                       0.082569            2014-09-02   \n",
       "Zheng Chenlei (Blair Zheng)                   0.666667            2012-11-07   \n",
       "Zhang Lin (Melody Zhang)                      0.148148            2021-02-08   \n",
       "Ji Yuqiao                                     0.128205            2016-08-29   \n",
       "CGTN Inheritors                                    NaN                   NaN   \n",
       "\n",
       "                                              type  \n",
       "Account Name                                        \n",
       "CGTN                          Media & News Company  \n",
       "China Daily                   Media & News Company  \n",
       "Hua Chunying                                   NaN  \n",
       "People's Daily China Science                   NaN  \n",
       "Zhao Lijian                                    NaN  \n",
       "...                                            ...  \n",
       "Wang Tianyu (Evan Wang)                        NaN  \n",
       "Zheng Chenlei (Blair Zheng)                    NaN  \n",
       "Zhang Lin (Melody Zhang)                       NaN  \n",
       "Ji Yuqiao                                      NaN  \n",
       "CGTN Inheritors                                NaN  \n",
       "\n",
       "[370 rows x 32 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'X (Twitter) Follower #'"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>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>Facebook Follower #</th>\n",
       "      <th>...</th>\n",
       "      <th>focus group</th>\n",
       "      <th>Account Name</th>\n",
       "      <th>is_blue_verified</th>\n",
       "      <th>created_at</th>\n",
       "      <th>followers_count</th>\n",
       "      <th>following_count</th>\n",
       "      <th>tweet_num</th>\n",
       "      <th>followers_following_ratio</th>\n",
       "      <th>formatted_created_at</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>1387432.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>Yang Xinmeng (Abby Yang)</td>\n",
       "      <td>True</td>\n",
       "      <td>2014-07-10 02:05:08</td>\n",
       "      <td>2799.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>851.0</td>\n",
       "      <td>17.385093</td>\n",
       "      <td>2014-07-10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\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>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>CGTN Culture Express</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-05-22 10:49:21</td>\n",
       "      <td>2483.0</td>\n",
       "      <td>152.0</td>\n",
       "      <td>1601.0</td>\n",
       "      <td>16.335526</td>\n",
       "      <td>2017-05-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>Yang Sheng</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-08-10 09:15:01</td>\n",
       "      <td>2839.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>379.0</td>\n",
       "      <td>36.397436</td>\n",
       "      <td>2016-08-10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\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>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Austria, Belgium, Bulgaria, Croatia, Cyprus, ...</td>\n",
       "      <td>Zhu Jing</td>\n",
       "      <td>False</td>\n",
       "      <td>2020-01-09 10:28:54</td>\n",
       "      <td>18853.0</td>\n",
       "      <td>542.0</td>\n",
       "      <td>2370.0</td>\n",
       "      <td>34.784133</td>\n",
       "      <td>2020-01-09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\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>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[Nigeria, Egypt, South Africa, Algeria, Morocco]</td>\n",
       "      <td>Liu Yuxi</td>\n",
       "      <td>False</td>\n",
       "      <td>2019-10-22 08:14:29</td>\n",
       "      <td>11237.0</td>\n",
       "      <td>502.0</td>\n",
       "      <td>9953.0</td>\n",
       "      <td>22.384462</td>\n",
       "      <td>2019-10-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>Singapore</td>\n",
       "      <td>English</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chinaemb.SG</td>\n",
       "      <td>https://www.facebook.com/Chinaemb.SG</td>\n",
       "      <td>101000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Singapore]</td>\n",
       "      <td>Chinese Embassy in Singapore</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>750</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>English</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>chinainsa</td>\n",
       "      <td>https://www.facebook.com/chinainsa</td>\n",
       "      <td>76000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[South Africa]</td>\n",
       "      <td>Chinese Embassy in South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>751</th>\n",
       "      <td>Trinidad and Tobago</td>\n",
       "      <td>English</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ChineseEmbinTT</td>\n",
       "      <td>https://www.facebook.com/ChineseEmbinTT</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Trinidad and Tobago]</td>\n",
       "      <td>Chinese Embassy in Trinidad and Tobago</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>753</th>\n",
       "      <td>Greece</td>\n",
       "      <td>English</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>Ministry of Foreign Affairs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>profile.php?id=100076260574528</td>\n",
       "      <td>https://www.facebook.com/profile.php?id=100076...</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Greece]</td>\n",
       "      <td>Xiao Junzheng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>757</th>\n",
       "      <td>Anglosphere</td>\n",
       "      <td>English</td>\n",
       "      <td>Xinhua News Agency</td>\n",
       "      <td>State Council</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>marcopolo.beijing/</td>\n",
       "      <td>https://www.facebook.com/marcopolo.beijing/</td>\n",
       "      <td>2300000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>New Marco Polo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaT</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>442 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Region of Focus Language       Entity owner (English)  \\\n",
       "0            Anglosphere  English      China Media Group (CMG)   \n",
       "1            Anglosphere  English      China Media Group (CMG)   \n",
       "4            Anglosphere  English         People's Daily Press   \n",
       "10                    EU  English  Ministry of Foreign Affairs   \n",
       "12         African Union  English  Ministry of Foreign Affairs   \n",
       "..                   ...      ...                          ...   \n",
       "749            Singapore  English  Ministry of Foreign Affairs   \n",
       "750         South Africa  English  Ministry of Foreign Affairs   \n",
       "751  Trinidad and Tobago  English  Ministry of Foreign Affairs   \n",
       "753               Greece  English  Ministry of Foreign Affairs   \n",
       "757          Anglosphere  English           Xinhua News Agency   \n",
       "\n",
       "                              Parent entity (English) X (Twitter) handle  \\\n",
       "0                        Central Publicity Department       _bubblyabby_   \n",
       "1                        Central Publicity Department    _cultureexpress   \n",
       "4    Central Committee of the Chinese Communist Party       AlexYsalex17   \n",
       "10                        Ministry of Foreign Affairs        Amb_ZhuJing   \n",
       "12                        Ministry of Foreign Affairs     Ambassador_Liu   \n",
       "..                                                ...                ...   \n",
       "749                       Ministry of Foreign Affairs                NaN   \n",
       "750                       Ministry of Foreign Affairs                NaN   \n",
       "751                       Ministry of Foreign Affairs                NaN   \n",
       "753                       Ministry of Foreign Affairs                NaN   \n",
       "757                                     State Council                NaN   \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",
       "4       https://twitter.com/AlexYsalex17                  2821.0   \n",
       "10       https://twitter.com/Amb_ZhuJing                 18500.0   \n",
       "12    https://twitter.com/Ambassador_Liu                 11200.0   \n",
       "..                                   ...                     ...   \n",
       "749                                  NaN                     NaN   \n",
       "750                                  NaN                     NaN   \n",
       "751                                  NaN                     NaN   \n",
       "753                                  NaN                     NaN   \n",
       "757                                  NaN                     NaN   \n",
       "\n",
       "                      Facebook page  \\\n",
       "0           itsAbby-103043374799622   \n",
       "1                               NaN   \n",
       "4                               NaN   \n",
       "10                              NaN   \n",
       "12                              NaN   \n",
       "..                              ...   \n",
       "749                     Chinaemb.SG   \n",
       "750                       chinainsa   \n",
       "751                  ChineseEmbinTT   \n",
       "753  profile.php?id=100076260574528   \n",
       "757              marcopolo.beijing/   \n",
       "\n",
       "                                          Facebook URL  Facebook Follower #  \\\n",
       "0     https://www.facebook.com/itsAbby-103043374799622            1387432.0   \n",
       "1                                                  NaN                  NaN   \n",
       "4                                                  NaN                  NaN   \n",
       "10                                                 NaN                  NaN   \n",
       "12                                                 NaN                  NaN   \n",
       "..                                                 ...                  ...   \n",
       "749               https://www.facebook.com/Chinaemb.SG             101000.0   \n",
       "750                 https://www.facebook.com/chinainsa              76000.0   \n",
       "751            https://www.facebook.com/ChineseEmbinTT               1100.0   \n",
       "753  https://www.facebook.com/profile.php?id=100076...               1000.0   \n",
       "757        https://www.facebook.com/marcopolo.beijing/            2300000.0   \n",
       "\n",
       "     ...                                        focus group  \\\n",
       "0    ...  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "1    ...  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "4    ...  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "10   ...  [Austria, Belgium, Bulgaria, Croatia, Cyprus, ...   \n",
       "12   ...   [Nigeria, Egypt, South Africa, Algeria, Morocco]   \n",
       "..   ...                                                ...   \n",
       "749  ...                                        [Singapore]   \n",
       "750  ...                                     [South Africa]   \n",
       "751  ...                              [Trinidad and Tobago]   \n",
       "753  ...                                           [Greece]   \n",
       "757  ...  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "\n",
       "                               Account Name  is_blue_verified  \\\n",
       "0                  Yang Xinmeng (Abby Yang)              True   \n",
       "1                      CGTN Culture Express             False   \n",
       "4                                Yang Sheng             False   \n",
       "10                                 Zhu Jing             False   \n",
       "12                                 Liu Yuxi             False   \n",
       "..                                      ...               ...   \n",
       "749            Chinese Embassy in Singapore               NaN   \n",
       "750         Chinese Embassy in South Africa               NaN   \n",
       "751  Chinese Embassy in Trinidad and Tobago               NaN   \n",
       "753                           Xiao Junzheng               NaN   \n",
       "757                          New Marco Polo               NaN   \n",
       "\n",
       "             created_at followers_count  following_count tweet_num  \\\n",
       "0   2014-07-10 02:05:08          2799.0            161.0     851.0   \n",
       "1   2017-05-22 10:49:21          2483.0            152.0    1601.0   \n",
       "4   2016-08-10 09:15:01          2839.0             78.0     379.0   \n",
       "10  2020-01-09 10:28:54         18853.0            542.0    2370.0   \n",
       "12  2019-10-22 08:14:29         11237.0            502.0    9953.0   \n",
       "..                  ...             ...              ...       ...   \n",
       "749                 NaT             NaN              NaN       NaN   \n",
       "750                 NaT             NaN              NaN       NaN   \n",
       "751                 NaT             NaN              NaN       NaN   \n",
       "753                 NaT             NaN              NaN       NaN   \n",
       "757                 NaT             NaN              NaN       NaN   \n",
       "\n",
       "    followers_following_ratio  formatted_created_at type  \n",
       "0                   17.385093            2014-07-10  NaN  \n",
       "1                   16.335526            2017-05-22  NaN  \n",
       "4                   36.397436            2016-08-10  NaN  \n",
       "10                  34.784133            2020-01-09  NaN  \n",
       "12                  22.384462            2019-10-22  NaN  \n",
       "..                        ...                   ...  ...  \n",
       "749                       NaN                   NaN  NaN  \n",
       "750                       NaN                   NaN  NaN  \n",
       "751                       NaN                   NaN  NaN  \n",
       "753                       NaN                   NaN  NaN  \n",
       "757                       NaN                   NaN  NaN  \n",
       "\n",
       "[442 rows x 33 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_column_series = filtered_df[selected_column]\n",
    "# selected_column_series = selected_column_series.dropna()\n",
    "# selected_column_series.sort_values(ascending=False, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "89     13000000.0\n",
       "137     4100000.0\n",
       "461     2200000.0\n",
       "197     2000000.0\n",
       "419     1900000.0\n",
       "          ...    \n",
       "507           7.0\n",
       "52            7.0\n",
       "398           3.0\n",
       "551           3.0\n",
       "75            0.0\n",
       "Name: X (Twitter) Follower #, Length: 370, dtype: float64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_column_series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "89     13000000.0\n",
       "137     4100000.0\n",
       "461     2200000.0\n",
       "197     2000000.0\n",
       "419     1900000.0\n",
       "          ...    \n",
       "507           7.0\n",
       "52            7.0\n",
       "398           3.0\n",
       "551           3.0\n",
       "75            0.0\n",
       "Name: X (Twitter) Follower #, Length: 370, dtype: float64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_column_series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.05 B\n",
      "70.34 M\n"
     ]
    }
   ],
   "source": [
    "def generate_visual_numbers(num):\n",
    "    if int(num /1000000000) > 0:\n",
    "        bil = num /1000000000\n",
    "        print(f'{bil:.2f} B')\n",
    "    else:\n",
    "        mil = num/1000000\n",
    "        print(f'{mil:.2f} M')\n",
    "generate_visual_numbers(1047829628)\n",
    "generate_visual_numbers(70344703)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "util_functions.generate_corps_data(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Region of Focus', 'Language', 'Entity owner (English)',\n",
       "       'Parent entity (English)', 'X (Twitter) handle', 'X (Twitter) URL',\n",
       "       'X (Twitter) Follower #', 'Facebook page', 'Facebook URL',\n",
       "       'Facebook Follower #', 'Instragram page', 'Instagram URL',\n",
       "       'Instagram Follower #', 'Threads account', 'Threads URL',\n",
       "       'Threads Follower #', 'YouTube account', 'YouTube URL',\n",
       "       'YouTube Subscriber #', 'TikTok account', 'TikTok URL',\n",
       "       'TikTok Subscriber #', 'Name (English)', 'focus countries',\n",
       "       'Account Name', 'is_blue_verified', 'created_at', 'followers_count',\n",
       "       'following_count', 'tweet_num', 'followers_following_ratio',\n",
       "       'formatted_created_at', 'type'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'name': 758,\n",
       " 'owner': 87,\n",
       " 'parent': 69,\n",
       " 'twitter': 574,\n",
       " 'twitter_fol': 70344703,\n",
       " 'tiktok': 121,\n",
       " 'tiktok_fol': 20230414,\n",
       " 'instagram': 140,\n",
       " 'instagram_fol': 14787228,\n",
       " 'youtube': 158,\n",
       " 'youtube_fol': 30186031,\n",
       " 'facebook': 325,\n",
       " 'facebook_fol': 1047829628,\n",
       " 'total': 759}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "corp_dict = util_functions.load_file('findings/corp_data.json')\n",
    "corp_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Rest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>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>Facebook Follower #</th>\n",
       "      <th>...</th>\n",
       "      <th>focus group</th>\n",
       "      <th>Account Name</th>\n",
       "      <th>is_blue_verified</th>\n",
       "      <th>created_at</th>\n",
       "      <th>followers_count</th>\n",
       "      <th>following_count</th>\n",
       "      <th>tweet_num</th>\n",
       "      <th>followers_following_ratio</th>\n",
       "      <th>formatted_created_at</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>1387432.0</td>\n",
       "      <td>...</td>\n",
       "      <td>[Australia, Canada, New Zealand, United Kingdo...</td>\n",
       "      <td>Yang Xinmeng (Abby Yang)</td>\n",
       "      <td>True</td>\n",
       "      <td>2014-07-10 02:05:08</td>\n",
       "      <td>2799.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>851.0</td>\n",
       "      <td>17.385093</td>\n",
       "      <td>2014-07-10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Region of Focus Language   Entity owner (English)  \\\n",
       "0     Anglosphere  English  China Media Group (CMG)   \n",
       "\n",
       "        Parent entity (English) X (Twitter) handle  \\\n",
       "0  Central Publicity Department       _bubblyabby_   \n",
       "\n",
       "                    X (Twitter) URL  X (Twitter) Follower #  \\\n",
       "0  https://twitter.com/_bubblyabby_                  1678.0   \n",
       "\n",
       "             Facebook page                                      Facebook URL  \\\n",
       "0  itsAbby-103043374799622  https://www.facebook.com/itsAbby-103043374799622   \n",
       "\n",
       "   Facebook Follower #  ...  \\\n",
       "0            1387432.0  ...   \n",
       "\n",
       "                                         focus group  \\\n",
       "0  [Australia, Canada, New Zealand, United Kingdo...   \n",
       "\n",
       "               Account Name  is_blue_verified          created_at  \\\n",
       "0  Yang Xinmeng (Abby Yang)              True 2014-07-10 02:05:08   \n",
       "\n",
       "  followers_count  following_count tweet_num followers_following_ratio  \\\n",
       "0          2799.0            161.0     851.0                 17.385093   \n",
       "\n",
       "   formatted_created_at type  \n",
       "0            2014-07-10  NaN  \n",
       "\n",
       "[1 rows x 33 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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</th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Is Verified</td>\n",
       "      <td>443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Is Not Verified</td>\n",
       "      <td>204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>N/A</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Name  Value\n",
       "0      Is Verified    443\n",
       "1  Is Not Verified    204\n",
       "2              N/A    111"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp_series = df['is_blue_verified'].value_counts(dropna=False)\n",
    "temp_df = pd.DataFrame({'Name': [\"Is Verified\", \"Is Not Verified\", \"N/A\"], 'Value': list(temp_series.values)})\n",
    "temp_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[False, nan, True]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(temp_series.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_df = pd.DataFrame({'Name': [], 'Value': []})"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Preprocessing of the location dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>username</th>\n",
       "      <th>location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>_bubblyabby_</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>_cultureexpress</td>\n",
       "      <td>Beijing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ACSF1919</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>afghanchina</td>\n",
       "      <td>China_Bijjing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AlexYsalex17</td>\n",
       "      <td>北京, 中华人民共和国</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          username       location\n",
       "0     _bubblyabby_            NaN\n",
       "1  _cultureexpress        Beijing\n",
       "2         ACSF1919            NaN\n",
       "3      afghanchina  China_Bijjing\n",
       "4     AlexYsalex17    北京, 中华人民共和国"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('dataset/user locations (twitter).csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "user_location = []\n",
    "for i in df.values:\n",
    "    if not type(i[1]) == float:\n",
    "        username = i[0]\n",
    "        location = str(i[1]).lower()\n",
    "        user_location.append([username, location])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# all twitter users: 574\n",
    "# users with location: 337\n",
    "# location of users from china in twitter: 174"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['_cultureexpress', 'beijing'],\n",
       " ['afghanchina', 'china_bijjing'],\n",
       " ['AlexYsalex17', '北京, 中华人民共和国'],\n",
       " ['Amazing_Yunnan', 'kunming, china'],\n",
       " ['Amb_LiSong', 'austria'],\n",
       " ['Amb_LuKang', 'jakarta, indonesia'],\n",
       " ['Amb_Yiming', 'abu dhabi'],\n",
       " ['AmbassadeChine', '20 rue monsieur 75007 paris'],\n",
       " ['Ambassador_Liu', 'beijing china 北京, 中国'],\n",
       " ['AmbassadorHuang', 'nicosia'],\n",
       " ['AmbassadorLei', 'maseru, lesotho'],\n",
       " ['AmbChenBo', 'užička 25, 11040 beograd'],\n",
       " ['AmbChineBurundi', 'burundi'],\n",
       " ['AmbChineCmr', 'yaoundé'],\n",
       " ['AmbCHINEenRDC', 'kinshasa '],\n",
       " ['ambchinetchad', \" rue no.1021, n'djaména, tchad\"],\n",
       " ['AmbCina', 'rome, lazio'],\n",
       " ['AmbCuiTiankai', 'washington, dc'],\n",
       " ['AmbLiaoLiqiang', 'cairo'],\n",
       " ['AmbLiuXiaoMing', 'beijing，china'],\n",
       " ['AmbNong', 'islamabad'],\n",
       " ['AmbZhengZeguang', 'london'],\n",
       " ['AmbZhouJian', 'doha, qatar'],\n",
       " ['AndyBxxx', \"people's republic of china\"],\n",
       " ['anosiwang', 'beijing'],\n",
       " ['are_china', 'beijing'],\n",
       " ['assignasia', 'beijing'],\n",
       " ['ayishaelseenya', 'الصين'],\n",
       " ['back_XiaoDiDi', '香港'],\n",
       " ['BeautyJiangxi', \"east china's jiangxi\"],\n",
       " ['BeijingDiscover', 'beijing'],\n",
       " ['BeijingReview', 'worldwide'],\n",
       " ['beltroadnews', 'silk road'],\n",
       " ['bjd_review', 'beijing, china'],\n",
       " ['BlairZheng1', 'macau'],\n",
       " ['Bossebosse84', 'beijing, china'],\n",
       " ['bycongwang', 'beijing, china'],\n",
       " ['Cao_Li_CHN', 'beijing'],\n",
       " ['CaoYi_MFA', 'beijing, china'],\n",
       " ['CathayPak', 'اسلام آباد, پاکستان'],\n",
       " ['CCGBelfast', '75-77 malone road, belfast'],\n",
       " ['CCGJeddah', 'jeddah'],\n",
       " ['CCTV_Plus', 'beijing, china'],\n",
       " ['cctvxinwen', 'beijing.china'],\n",
       " ['CDAfricaNews', 'nairobi, kenya'],\n",
       " ['CDHKedition', 'hong kong '],\n",
       " ['CenJasmine', \"beijing, people's republic of china\"],\n",
       " ['CGHuangPingNY', 'new york'],\n",
       " ['CGMeifangZhang', '75-77 malone road, belfast'],\n",
       " ['CGPRCinDubai', 'dubai, uae'],\n",
       " ['CGTN_Culture', 'beijing, china'],\n",
       " ['CGTN_Dialogue', 'beijing'],\n",
       " ['CGTN_Style', 'beijing'],\n",
       " ['cgtnafrica', 'africa'],\n",
       " ['cgtnamerica', 'washington, dc'],\n",
       " ['CGTNBusiness', 'beijing, china'],\n",
       " ['CGTNDCproducers', 'washington, dc'],\n",
       " ['CGTNEurope', 'europe'],\n",
       " ['CGTNEuropebreak', 'europe'],\n",
       " ['CGTNFood', 'beijing, china'],\n",
       " ['CGTNFrancais', 'chine'],\n",
       " ['CGTNGlobalBiz', 'beijing'],\n",
       " ['CGTNGraphics', 'beijing, china'],\n",
       " ['CGTNMovies', 'beijing, china'],\n",
       " ['CGTNOfficial', 'beijing, china'],\n",
       " ['cgtnradio', 'beijing, china'],\n",
       " ['CGTNSports', 'beijing, china'],\n",
       " ['CGTNSportsScene', '北京, 中华人民共和国'],\n",
       " ['CGTNStories', 'beijing, china'],\n",
       " ['CGTNTech', 'beijing, china'],\n",
       " ['cgtntravelogue', 'beijing, china'],\n",
       " ['Chen1126', 'beijing, china'],\n",
       " ['chenhuixin', 'helsinki'],\n",
       " ['Chenjuan', 'shanghai'],\n",
       " ['ChenMingjian_CN', 'dar es salaam, tanzania'],\n",
       " ['chenweihua', 'brussels, belgium'],\n",
       " ['CHENWendi11', 'mogadishu, somalia'],\n",
       " ['China__Focus', 'beijing, china'],\n",
       " ['China_Amb_India', '50-d, shantipath, chanakyapuri'],\n",
       " ['China_Amb_Zim', 'harare, zimbabwe'],\n",
       " ['china_emb_ng', '302 diplomatic drive, abuja'],\n",
       " ['china_embajada', 'calle72#2a-41, bogotá'],\n",
       " ['China_Lyon', '69 rue duquesne 69006 lyon'],\n",
       " ['China_Ukraine_', 'ukraine'],\n",
       " ['china_xiamen', 'xiamen,china'],\n",
       " ['China24Official', 'beijing'],\n",
       " ['China2ASEAN', 'jakarta, indonesia'],\n",
       " ['ChinaAmbBelgium', 'bruxelles, belgique'],\n",
       " ['ChinaAmbSA', 'pretoria'],\n",
       " ['ChinaAmbUN', 'new york'],\n",
       " ['ChinaCG_Muc', 'munich'],\n",
       " ['chinacgedi', '55 corstorphine rd, edinburgh'],\n",
       " ['ChinaCGMTL', '2100 rue ste-catherine o'],\n",
       " ['ChinaConsulate', 'chicago, il'],\n",
       " ['chinaconsulist', 'i̇stanbul, türkiye'],\n",
       " ['ChinaConSydney', 'sydney, australia'],\n",
       " ['Chinacultureorg', 'beijing'],\n",
       " ['ChinaDaily', 'beijing, china'],\n",
       " ['ChinaDailyAsia', 'hong kong'],\n",
       " ['ChinaDailyEU', 'london'],\n",
       " ['Chinaemb_Hellas', 'dimokratias10,p.psychico,15452'],\n",
       " ['ChinaEmbAddis', 'addis ababa'],\n",
       " ['ChinaEmbajada', 'chile'],\n",
       " ['ChinaEmbajadaRD', 'national district'],\n",
       " ['ChinaEmbAngola', 'angola'],\n",
       " ['ChinaEmbAntigua', 'st. johns, antigua'],\n",
       " ['ChinaEmbArg', 'crisólogo larralde 5349'],\n",
       " ['ChinaEmbassy_MW', 'lilongwe'],\n",
       " ['ChinaembassyT', 'albania'],\n",
       " ['ChinaEmbBahrain', 'building 1109，road 2819，manama'],\n",
       " ['chinaembcongobz', 'avenue auxence ickonga bp 1178'],\n",
       " ['ChinaEmBE', '443-445 ave. de tervuren, 1150'],\n",
       " ['ChinaEmbEritrea', 'asmara'],\n",
       " ['ChinaEmbEsp', 'madrid, españa'],\n",
       " ['ChinaEmbGrenada', 'st. georges'],\n",
       " ['ChinaEmbinCH', 'bern, switzerland'],\n",
       " ['ChinaEmbinGH', 'accra'],\n",
       " ['ChinaEmbinRW', 'kigali, rwanda'],\n",
       " ['ChinaEmbIreland', 'dublin, éire'],\n",
       " ['ChinaEmbKabul', 'afghanistan'],\n",
       " ['ChinaEmbKazakh', 'нур-султан'],\n",
       " ['ChinaEmbKuwait', 'kuwait'],\n",
       " ['ChinaEmbLesotho', 'maseru, lesotho'],\n",
       " ['Chinaembmanila', 'metro manila, the philippines'],\n",
       " ['ChinaEmbOttawa', '515 st. patrick street, ottawa'],\n",
       " ['ChinaEmbPeru', 'lima, perú'],\n",
       " ['ChinaEmbPoland', 'ul. bonifraterska 1, warszawa'],\n",
       " ['ChinaEmbPt', 'lisbon, portugal'],\n",
       " ['ChinaEmbSL', 'sri lanka'],\n",
       " ['ChinaEmbSVK', 'bratislava, slovak republic'],\n",
       " ['ChinaEmSlovenia', 'koblarjeva 3, 1000 ljubljana, republic of slovenia.'],\n",
       " ['ChinaEUMission', 'brussels, belgium'],\n",
       " ['chinafrance', 'beijing china'],\n",
       " ['ChinaInDenmark', 'copenhagen, denmark'],\n",
       " ['ChinainLebanon', 'beirut'],\n",
       " ['ChinainVan', 'vancouver bc canada'],\n",
       " ['ChinaIraq', 'baghdad'],\n",
       " ['Chinamission2un', 'new york, ny'],\n",
       " ['ChinaMissionGva', 'geneva, switzerland'],\n",
       " ['chinaorgcn', 'beijing, china'],\n",
       " ['ChinaScience', 'beijing, china'],\n",
       " ['chinascio', 'beijing'],\n",
       " ['ChinaSpox_India', 'chinese embassy in india'],\n",
       " ['chinatoday_com', 'canada'],\n",
       " ['Chine_au_Mali', 'mali'],\n",
       " ['chine_guinee', 'guinea'],\n",
       " ['ChineAmbassade', '达喀尔 dakar'],\n",
       " ['ChineAmbDjibout', 'djibouti'],\n",
       " ['ChineAmbMaroc', '16,avenue ahmed balafrej,rabat'],\n",
       " ['ChineseAmb_GM', 'banjul, the gambia'],\n",
       " ['ChineseCon_Mel', 'melbourne, victoria, australia'],\n",
       " ['ChineseEmb_FJ', 'suva, fiji'],\n",
       " ['ChineseEmb_PNG', 'papua new guinea'],\n",
       " ['ChineseEmb_Uga', 'plot 37, malcolm x avenue, kol'],\n",
       " ['ChineseembassyJ', 'no.9 jakarta street, d.rabyeh '],\n",
       " ['ChineseEmbinHU', 'budapest, hungary'],\n",
       " ['ChineseEmbinMNE', 'chinaemb_me@hotmail.com'],\n",
       " ['ChineseEmbinRus', 'moscow'],\n",
       " ['ChineseEmbinUS', 'washington, dc'],\n",
       " ['ChineseEmbKenya', 'woodlands road, nairobi, kenya'],\n",
       " ['ChineseEmbtoYEM', 'riyadh saudi arabia'],\n",
       " ['ChineseEmbTZ', 'dar es salaam'],\n",
       " ['ChineseLiberia', 'oldest congo town, monrovia'],\n",
       " ['ChineseSomalia', 'mogadishu, somalia'],\n",
       " ['ChineseZimbabwe', 'harare, zimbabwe'],\n",
       " ['chloezhou21', 'beijing'],\n",
       " ['CHN_EGY', 'cairo, egypt'],\n",
       " ['ChnConsul_osaka', '大阪府大阪市西区靱本町3-9-2'],\n",
       " ['ChnConsulateFuk', '福岡市中央区地行浜1-3-3'],\n",
       " ['ChnConsulateJhb', '25 cleverland rd, sandton,jhb'],\n",
       " ['ChnConsulateNgt', 'niigata-shi chuo-ku, niigata'],\n",
       " ['ChnEmbassy_jp', 'japan'],\n",
       " ['CHNembinSudan', 'khartoum, sudan'],\n",
       " ['CHNEmbSuriname', 'paramaribo, suriname'],\n",
       " ['ChnMission', 'geneva'],\n",
       " ['cidcaofficial', 'beijing'],\n",
       " ['closertochina', 'beijing'],\n",
       " ['CNContentCenter', 'shanghai'],\n",
       " ['consulat_de', '35 rue bautain 67000strasbourg'],\n",
       " ['ConsulChinaBcn', 'av. tibidabo, 34, barcelona'],\n",
       " ['ConsulChinaRJ', 'rio de janeiro, rj, brasil'],\n",
       " ['cri_hindi', 'beijing'],\n",
       " ['CRIbrk', 'anywhere'],\n",
       " ['CriFrancais', '北京, 中华人民共和国'],\n",
       " ['CRIGerman1', 'beijing, china'],\n",
       " ['crigreek', 'beijing, prc'],\n",
       " ['CRIHausaRadio', 'shijingshan rd beijing, china'],\n",
       " ['CRIjpn', '中国北京市石景山甲16号'],\n",
       " ['CRIsinhala', 'beijing china'],\n",
       " ['CSCECNEWS', 'global'],\n",
       " ['Danni_Zhu131', 'beijing, china '],\n",
       " ['DIOC_MFA_China', 'beijing, china'],\n",
       " ['DiscoverGuangxi', 'guangxi'],\n",
       " ['DiscoverJilin', 'jilin, china'],\n",
       " ['DiscoverNanjing', 'nanjing,china'],\n",
       " ['Dongning', 'beijing'],\n",
       " ['dragontv', '上海'],\n",
       " ['DrZhaoyongchen', 'beijing'],\n",
       " ['dupingCHN', 'beijing,china'],\n",
       " ['Echinanews', 'beijing'],\n",
       " ['EconomicMalawi', 'lilongwe'],\n",
       " ['EDNewsChina', 'beijing'],\n",
       " ['EmbaixadaChina', 'brasília, brasil'],\n",
       " ['EmbajadaChinaEc', 'quito'],\n",
       " ['EmbajadaChinaSV', 'san salvador'],\n",
       " ['embajadorcn_uy', 'montevideo'],\n",
       " ['embassy_chinese', 'tonga'],\n",
       " ['EmbChina_RS', 'užička 25, beograd 11000'],\n",
       " ['EmbChinaCuba', 'cuba'],\n",
       " ['EmbChinaGE', '赤道几内亚 guinea ecuatorial'],\n",
       " ['EmbChinaMex', 'av.rio magdalena 172'],\n",
       " ['EmbChinaVen', 'venezuela'],\n",
       " ['EmbQiMei', 'vienna, austria'],\n",
       " ['EmbZhangRun', 'distrito federal, méxico'],\n",
       " ['evawcheng', 'beijing via missouri, d.c., bc'],\n",
       " ['ExploreGansu', 'gansu province, china'],\n",
       " ['FangYi85320692', 'kampala, uganda'],\n",
       " ['fayhaaChina', 'beijing'],\n",
       " ['flyoverchina', 'beijing, china'],\n",
       " ['FuCong17', 'brussels,\\xa0belgium'],\n",
       " ['FuzhouCity', 'fuzhou, china'],\n",
       " ['gabriekestabem', 'são paulo,brasil pequim, china'],\n",
       " ['gabrielyin', 'brasil'],\n",
       " ['GlobalTimesBiz', 'beijing china '],\n",
       " ['GlobalTimesLife', 'beijing'],\n",
       " ['globaltimesnews', 'beijing, china'],\n",
       " ['GoJiangsu', 'west beijing road, nanjing'],\n",
       " ['GtOpinion', '北京, 中华人民共和国'],\n",
       " ['Guangming_Daily', 'beijing, china'],\n",
       " ['Gwadar_Pro', 'gwadar, pakistan'],\n",
       " ['gz1988', 'beijing'],\n",
       " ['haiwainet', 'beijing, china'],\n",
       " ['haiwaiwangUS', 'los angeles, ca'],\n",
       " ['Hakimyu2', 'alger                         '],\n",
       " ['Henan_TV', 'california, usa'],\n",
       " ['HeRulong', 'iceland'],\n",
       " ['heweiwei_', '中华人民共和国'],\n",
       " ['HU_Bin_CHN', 'são tomé and príncipe'],\n",
       " ['huang_jiyuan', 'china'],\n",
       " ['huanxinzhao', 'washington, dc'],\n",
       " ['hui48298914', 'jakarta, indonesia'],\n",
       " ['HunanTimes', 'changsha, hunan, china'],\n",
       " ['HuXijin_GT', 'china'],\n",
       " ['iChangzhou', 'changzhou, china'],\n",
       " ['iChongqing_CIMC', 'chongqing'],\n",
       " ['InQingdao', 'shandong, china'],\n",
       " ['InsightNingbo', \"people's republic of china\"],\n",
       " ['IXiangshan', 'xiangshan,china'],\n",
       " ['izhejiang', 'zhejiang, china'],\n",
       " ['jejuZLG', '제주시청사로1길10'],\n",
       " ['JessicaZ1018', \"beijing, people's republic of china\"],\n",
       " ['JiangJiang43', 'beijing'],\n",
       " ['JianhuaLi4', 'london, england'],\n",
       " ['JilinChina', 'jilin, china'],\n",
       " ['Jingjing_Li', 'beijing, china'],\n",
       " ['juliojiangwei', 'panama'],\n",
       " ['katekuibeijing', 'beijing'],\n",
       " ['KatieMi17', 'beijing'],\n",
       " ['kimnaying', 'china'],\n",
       " ['kooricuc', '北京, 中华人民共和国'],\n",
       " ['KunkunkunLiu', 'beijing'],\n",
       " ['learnchineese', 'globally'],\n",
       " ['lena90830', 'beijing'],\n",
       " ['Leona_BJ', 'beijing,china'],\n",
       " ['Li_Baorong', 'caracas, venezuela'],\n",
       " ['LinHao_BKK', 'bangkok'],\n",
       " ['LiuHongyang4', 'malawi'],\n",
       " ['LiuXininBeijing', 'details'],\n",
       " ['LiuYanCHN', 'the hague, the netherlands'],\n",
       " ['luisxu9', 'san jose, costa rica'],\n",
       " ['luowill1978', \"people's republic of china\"],\n",
       " ['MahuiChina', 'havana,cuba'],\n",
       " ['MAKSIMYQY', 'saint petersburg, russia'],\n",
       " ['MarthayTao', 'beijing, china'],\n",
       " ['martinaglobal', 'london, united kingdom'],\n",
       " ['MFA_China', '中国，北京 beijing prc'],\n",
       " ['MiaoXiaojuan', 'beijing'],\n",
       " ['MingjieReporter', 'london, england'],\n",
       " ['MissWow66', 'beijjng china'],\n",
       " ['mmMonicaZhang', 'beijing '],\n",
       " ['ModernExpressEN', 'nanjing, china'],\n",
       " ['mundo_china', 'são paulo, brasil'],\n",
       " ['muyi_dima', 'beijing'],\n",
       " ['PandaoramaLink', 'washington, dc'],\n",
       " ['PatrickZhengCHN', 'beijing'],\n",
       " ['pd_northamerica', 'washington dc'],\n",
       " ['PDChina', 'beijing, china'],\n",
       " ['PDChinaBusiness', 'beijing, china'],\n",
       " ['PDChinaLife', 'beijing, china'],\n",
       " ['PDChinese', '中國  北京'],\n",
       " ['PDOAUS', '8 clarke street, crows nest'],\n",
       " ['peijin_zhang', 'beijing'],\n",
       " ['PeoplesDailyapp', 'beijing'],\n",
       " ['PhoenixTV_News', 'hong kong'],\n",
       " ['PRC_Amb_Uganda', 'kampala, uganda'],\n",
       " ['PRCAmbNepal', 'nepal'],\n",
       " ['PRCAmbNL', 'the hague, the netherlands'],\n",
       " ['prcembassyprg', 'pelléova 1116/18a, prague'],\n",
       " ['PRCSpoxNepal', 'kathmandu'],\n",
       " ['promisingzhuang', '巴西圣保罗 são paulo'],\n",
       " ['qianwen_gu', 'china'],\n",
       " ['qingqingparis', 'beijing'],\n",
       " ['QiushiJournal', 'beijing, china'],\n",
       " ['QuanQuan_1231', 'alger                         '],\n",
       " ['RadioEjani', 'beijing'],\n",
       " ['realGuancha', '上海shanghai'],\n",
       " ['RenKeNews', 'beijing, china'],\n",
       " ['reporterCHN', 'beijing,china'],\n",
       " ['RibiaoChen', 'jung-gu, republic of korea'],\n",
       " ['RitaBai', '北京, 中华人民共和国'],\n",
       " ['Sabrina_Zhao', 'beijing'],\n",
       " ['salahzhang', 'zanzibar, tanzania'],\n",
       " ['SanyaofChina', 'sanya, hainan, china'],\n",
       " ['SceneryofChina', 'huixin dongjie, beijing, china'],\n",
       " ['ShaanxiMoments', 'shaanxi, china'],\n",
       " ['Shalevetyah', 'israel'],\n",
       " ['shanghaidaily', 'shanghai'],\n",
       " ['Shanhui_Jacky', 'beijing'],\n",
       " ['ShannonZ666', 'beijing'],\n",
       " ['shao_zheng', 'china'],\n",
       " ['ShaoxingCity', 'shaoxing, zhejiang, china'],\n",
       " ['shen_shiwei', 'beijing, china '],\n",
       " ['shenqihaodianzi', '北京, 中华人民共和国'],\n",
       " ['SichuanDaily', 'chengdu, sichuan, china'],\n",
       " ['SixthTone', 'shanghai'],\n",
       " ['SMGKankanews', 'shanghai, china'],\n",
       " ['SpokespersonCHN', '中国，北京 beijing prc'],\n",
       " ['SpokespersonHZM', 'beijing'],\n",
       " ['SpoxCHNinUS', 'washington d.c.'],\n",
       " ['stuartyueh', 'beijing'],\n",
       " ['suadye', 'بكين، الصين'],\n",
       " ['SuYuting8', 'beijing'],\n",
       " ['SuzhouWuzhong', 'wuzhong district, suzhou'],\n",
       " ['TakungNews', 'hong kong'],\n",
       " ['takungwenwei_hk', '香港'],\n",
       " ['thepapercn', 'shanghai, china'],\n",
       " ['thepoint_CGTN', 'beijing']]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "china_bijjing\n",
      "kunming, china\n",
      "beijing china 北京, 中国\n",
      "beijing，china\n",
      "people's republic of china\n",
      "east china's jiangxi\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing.china\n",
      "beijing, people's republic of china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "xiamen,china\n",
      "beijing, china\n",
      "beijing china\n",
      "beijing, china\n",
      "beijing, china\n",
      "chinaemb_me@hotmail.com\n",
      "beijing, china\n",
      "shijingshan rd beijing, china\n",
      "beijing china\n",
      "beijing, china \n",
      "beijing, china\n",
      "jilin, china\n",
      "nanjing,china\n",
      "beijing,china\n",
      "gansu province, china\n",
      "beijing, china\n",
      "fuzhou, china\n",
      "são paulo,brasil pequim, china\n",
      "beijing china \n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "china\n",
      "changsha, hunan, china\n",
      "china\n",
      "changzhou, china\n",
      "shandong, china\n",
      "people's republic of china\n",
      "xiangshan,china\n",
      "zhejiang, china\n",
      "beijing, people's republic of china\n",
      "jilin, china\n",
      "beijing, china\n",
      "china\n",
      "beijing,china\n",
      "people's republic of china\n",
      "beijing, china\n",
      "beijjng china\n",
      "nanjing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing, china\n",
      "china\n",
      "beijing, china\n",
      "beijing, china\n",
      "beijing,china\n",
      "sanya, hainan, china\n",
      "huixin dongjie, beijing, china\n",
      "shaanxi, china\n",
      "china\n",
      "shaoxing, zhejiang, china\n",
      "beijing, china \n",
      "chengdu, sichuan, china\n",
      "shanghai, china\n",
      "shanghai, china\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "81"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a = 0\n",
    "china = ['china', 'beijing', 'zhejiang', 'shaoxing',\n",
    "         'sichuan', 'chengdu', 'hong kong', '上海shanghai', '中华人民共和国', '北京', '中华人民共和国', '上海']\n",
    "for i in user_location:\n",
    "    if 'china' in i[1]:\n",
    "        print(i[1])\n",
    "        a+=1\n",
    "a"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "from collections import Counter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "a = []\n",
    "for i in user_location:\n",
    "    a.append(i[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Counter({'beijing': 42,\n",
       "         'china_bijjing': 1,\n",
       "         '北京, 中华人民共和国': 7,\n",
       "         'kunming, china': 1,\n",
       "         'austria': 1,\n",
       "         'jakarta, indonesia': 3,\n",
       "         'abu dhabi': 1,\n",
       "         '20 rue monsieur 75007 paris': 1,\n",
       "         'beijing china 北京, 中国': 1,\n",
       "         'nicosia': 1,\n",
       "         'maseru, lesotho': 2,\n",
       "         'užička 25, 11040 beograd': 1,\n",
       "         'burundi': 1,\n",
       "         'yaoundé': 1,\n",
       "         'kinshasa ': 1,\n",
       "         \" rue no.1021, n'djaména, tchad\": 1,\n",
       "         'rome, lazio': 1,\n",
       "         'washington, dc': 6,\n",
       "         'cairo': 1,\n",
       "         'beijing，china': 1,\n",
       "         'islamabad': 1,\n",
       "         'london': 2,\n",
       "         'doha, qatar': 1,\n",
       "         \"people's republic of china\": 3,\n",
       "         'الصين': 1,\n",
       "         '香港': 2,\n",
       "         \"east china's jiangxi\": 1,\n",
       "         'worldwide': 1,\n",
       "         'silk road': 1,\n",
       "         'beijing, china': 34,\n",
       "         'macau': 1,\n",
       "         'اسلام آباد, پاکستان': 1,\n",
       "         '75-77 malone road, belfast': 2,\n",
       "         'jeddah': 1,\n",
       "         'beijing.china': 1,\n",
       "         'nairobi, kenya': 1,\n",
       "         'hong kong ': 1,\n",
       "         \"beijing, people's republic of china\": 2,\n",
       "         'new york': 2,\n",
       "         'dubai, uae': 1,\n",
       "         'africa': 1,\n",
       "         'europe': 2,\n",
       "         'chine': 1,\n",
       "         'helsinki': 1,\n",
       "         'shanghai': 4,\n",
       "         'dar es salaam, tanzania': 1,\n",
       "         'brussels, belgium': 2,\n",
       "         'mogadishu, somalia': 2,\n",
       "         '50-d, shantipath, chanakyapuri': 1,\n",
       "         'harare, zimbabwe': 2,\n",
       "         '302 diplomatic drive, abuja': 1,\n",
       "         'calle72#2a-41, bogotá': 1,\n",
       "         '69 rue duquesne 69006 lyon': 1,\n",
       "         'ukraine': 1,\n",
       "         'xiamen,china': 1,\n",
       "         'bruxelles, belgique': 1,\n",
       "         'pretoria': 1,\n",
       "         'munich': 1,\n",
       "         '55 corstorphine rd, edinburgh': 1,\n",
       "         '2100 rue ste-catherine o': 1,\n",
       "         'chicago, il': 1,\n",
       "         'i̇stanbul, türkiye': 1,\n",
       "         'sydney, australia': 1,\n",
       "         'hong kong': 3,\n",
       "         'dimokratias10,p.psychico,15452': 1,\n",
       "         'addis ababa': 1,\n",
       "         'chile': 1,\n",
       "         'national district': 1,\n",
       "         'angola': 1,\n",
       "         'st. johns, antigua': 1,\n",
       "         'crisólogo larralde 5349': 1,\n",
       "         'lilongwe': 2,\n",
       "         'albania': 1,\n",
       "         'building 1109，road 2819，manama': 1,\n",
       "         'avenue auxence ickonga bp 1178': 1,\n",
       "         '443-445 ave. de tervuren, 1150': 1,\n",
       "         'asmara': 1,\n",
       "         'madrid, españa': 1,\n",
       "         'st. georges': 1,\n",
       "         'bern, switzerland': 1,\n",
       "         'accra': 1,\n",
       "         'kigali, rwanda': 1,\n",
       "         'dublin, éire': 1,\n",
       "         'afghanistan': 1,\n",
       "         'нур-султан': 1,\n",
       "         'kuwait': 1,\n",
       "         'metro manila, the philippines': 1,\n",
       "         '515 st. patrick street, ottawa': 1,\n",
       "         'lima, perú': 1,\n",
       "         'ul. bonifraterska 1, warszawa': 1,\n",
       "         'lisbon, portugal': 1,\n",
       "         'sri lanka': 1,\n",
       "         'bratislava, slovak republic': 1,\n",
       "         'koblarjeva 3, 1000 ljubljana, republic of slovenia.': 1,\n",
       "         'beijing china': 2,\n",
       "         'copenhagen, denmark': 1,\n",
       "         'beirut': 1,\n",
       "         'vancouver bc canada': 1,\n",
       "         'baghdad': 1,\n",
       "         'new york, ny': 1,\n",
       "         'geneva, switzerland': 1,\n",
       "         'chinese embassy in india': 1,\n",
       "         'canada': 1,\n",
       "         'mali': 1,\n",
       "         'guinea': 1,\n",
       "         '达喀尔 dakar': 1,\n",
       "         'djibouti': 1,\n",
       "         '16,avenue ahmed balafrej,rabat': 1,\n",
       "         'banjul, the gambia': 1,\n",
       "         'melbourne, victoria, australia': 1,\n",
       "         'suva, fiji': 1,\n",
       "         'papua new guinea': 1,\n",
       "         'plot 37, malcolm x avenue, kol': 1,\n",
       "         'no.9 jakarta street, d.rabyeh ': 1,\n",
       "         'budapest, hungary': 1,\n",
       "         'chinaemb_me@hotmail.com': 1,\n",
       "         'moscow': 1,\n",
       "         'woodlands road, nairobi, kenya': 1,\n",
       "         'riyadh saudi arabia': 1,\n",
       "         'dar es salaam': 1,\n",
       "         'oldest congo town, monrovia': 1,\n",
       "         'cairo, egypt': 1,\n",
       "         '大阪府大阪市西区靱本町3-9-2': 1,\n",
       "         '福岡市中央区地行浜1-3-3': 1,\n",
       "         '25 cleverland rd, sandton,jhb': 1,\n",
       "         'niigata-shi chuo-ku, niigata': 1,\n",
       "         'japan': 1,\n",
       "         'khartoum, sudan': 1,\n",
       "         'paramaribo, suriname': 1,\n",
       "         'geneva': 1,\n",
       "         '35 rue bautain 67000strasbourg': 1,\n",
       "         'av. tibidabo, 34, barcelona': 1,\n",
       "         'rio de janeiro, rj, brasil': 1,\n",
       "         'anywhere': 1,\n",
       "         'beijing, prc': 1,\n",
       "         'shijingshan rd beijing, china': 1,\n",
       "         '中国北京市石景山甲16号': 1,\n",
       "         'global': 1,\n",
       "         'beijing, china ': 2,\n",
       "         'guangxi': 1,\n",
       "         'jilin, china': 2,\n",
       "         'nanjing,china': 1,\n",
       "         '上海': 1,\n",
       "         'beijing,china': 3,\n",
       "         'brasília, brasil': 1,\n",
       "         'quito': 1,\n",
       "         'san salvador': 1,\n",
       "         'montevideo': 1,\n",
       "         'tonga': 1,\n",
       "         'užička 25, beograd 11000': 1,\n",
       "         'cuba': 1,\n",
       "         '赤道几内亚 guinea ecuatorial': 1,\n",
       "         'av.rio magdalena 172': 1,\n",
       "         'venezuela': 1,\n",
       "         'vienna, austria': 1,\n",
       "         'distrito federal, méxico': 1,\n",
       "         'beijing via missouri, d.c., bc': 1,\n",
       "         'gansu province, china': 1,\n",
       "         'kampala, uganda': 2,\n",
       "         'brussels,\\xa0belgium': 1,\n",
       "         'fuzhou, china': 1,\n",
       "         'são paulo,brasil pequim, china': 1,\n",
       "         'brasil': 1,\n",
       "         'beijing china ': 1,\n",
       "         'west beijing road, nanjing': 1,\n",
       "         'gwadar, pakistan': 1,\n",
       "         'los angeles, ca': 1,\n",
       "         'alger                         ': 2,\n",
       "         'california, usa': 1,\n",
       "         'iceland': 1,\n",
       "         '中华人民共和国': 1,\n",
       "         'são tomé and príncipe': 1,\n",
       "         'china': 5,\n",
       "         'changsha, hunan, china': 1,\n",
       "         'changzhou, china': 1,\n",
       "         'chongqing': 1,\n",
       "         'shandong, china': 1,\n",
       "         'xiangshan,china': 1,\n",
       "         'zhejiang, china': 1,\n",
       "         '제주시청사로1길10': 1,\n",
       "         'london, england': 2,\n",
       "         'panama': 1,\n",
       "         'globally': 1,\n",
       "         'caracas, venezuela': 1,\n",
       "         'bangkok': 1,\n",
       "         'malawi': 1,\n",
       "         'details': 1,\n",
       "         'the hague, the netherlands': 2,\n",
       "         'san jose, costa rica': 1,\n",
       "         'havana,cuba': 1,\n",
       "         'saint petersburg, russia': 1,\n",
       "         'london, united kingdom': 1,\n",
       "         '中国，北京 beijing prc': 2,\n",
       "         'beijjng china': 1,\n",
       "         'beijing ': 1,\n",
       "         'nanjing, china': 1,\n",
       "         'são paulo, brasil': 1,\n",
       "         'washington dc': 1,\n",
       "         '中國  北京': 1,\n",
       "         '8 clarke street, crows nest': 1,\n",
       "         'nepal': 1,\n",
       "         'pelléova 1116/18a, prague': 1,\n",
       "         'kathmandu': 1,\n",
       "         '巴西圣保罗 são paulo': 1,\n",
       "         '上海shanghai': 1,\n",
       "         'jung-gu, republic of korea': 1,\n",
       "         'zanzibar, tanzania': 1,\n",
       "         'sanya, hainan, china': 1,\n",
       "         'huixin dongjie, beijing, china': 1,\n",
       "         'shaanxi, china': 1,\n",
       "         'israel': 1,\n",
       "         'shaoxing, zhejiang, china': 1,\n",
       "         'chengdu, sichuan, china': 1,\n",
       "         'shanghai, china': 2,\n",
       "         'washington d.c.': 1,\n",
       "         'بكين، الصين': 1,\n",
       "         'wuzhong district, suzhou': 1})"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Counter(a)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}