map.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel('Merged_Final.xlsx') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_rows', None)\n",
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>text</th>\n",
       "      <th>user_id</th>\n",
       "      <th>user_name</th>\n",
       "      <th>user_description</th>\n",
       "      <th>user_default_profile_image</th>\n",
       "      <th>user_favourites_count</th>\n",
       "      <th>user_followers_count</th>\n",
       "      <th>user_friends_count</th>\n",
       "      <th>user_listed_count</th>\n",
       "      <th>user_screen_name</th>\n",
       "      <th>user_statuses_count</th>\n",
       "      <th>user_time_zone</th>\n",
       "      <th>user_urls</th>\n",
       "      <th>user_verified</th>\n",
       "      <th>user_location</th>\n",
       "      <th>Gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.462744e+18</td>\n",
       "      <td>FoSTaC: Advance Catering - Food Safety Supervi...</td>\n",
       "      <td>68736735</td>\n",
       "      <td>Food Safety Works</td>\n",
       "      <td>We are a food safety solution company helping ...</td>\n",
       "      <td>False</td>\n",
       "      <td>15</td>\n",
       "      <td>131</td>\n",
       "      <td>88</td>\n",
       "      <td>4</td>\n",
       "      <td>foodsafetyworks</td>\n",
       "      <td>1405</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.foodsafetyworks.com</td>\n",
       "      <td>False</td>\n",
       "      <td>India</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.463142e+18</td>\n",
       "      <td>After a recent period of virtual learning at a...</td>\n",
       "      <td>746349877</td>\n",
       "      <td>Milton Courier</td>\n",
       "      <td>Community newspaper covering the latest happen...</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>1309</td>\n",
       "      <td>106</td>\n",
       "      <td>23</td>\n",
       "      <td>MiltonCourier</td>\n",
       "      <td>6791</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.miltoncourieronline.com</td>\n",
       "      <td>False</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.462991e+18</td>\n",
       "      <td>ONLINE EDUCATION INCREASED GENDER INEQUALITY, ...</td>\n",
       "      <td>917983451671923968</td>\n",
       "      <td>arvind sharma</td>\n",
       "      <td>arvind sharma</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>kkr_arvind</td>\n",
       "      <td>18958</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>India</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.463207e+18</td>\n",
       "      <td>The Future of Online Education: The Impact of ...</td>\n",
       "      <td>97964953</td>\n",
       "      <td>Josh Thackston</td>\n",
       "      <td>Instructional Designer &amp; Instructional Develop...</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>234</td>\n",
       "      <td>125</td>\n",
       "      <td>28</td>\n",
       "      <td>joshthackston</td>\n",
       "      <td>8144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://jthackston.com</td>\n",
       "      <td>False</td>\n",
       "      <td>Sao Tome and Principe</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.462701e+18</td>\n",
       "      <td>DesafÃ­os digitales y virtuales de las bibliot...</td>\n",
       "      <td>3122211</td>\n",
       "      <td>-ðŸª‘--- --ðŸ’º-ðŸŽ-</td>\n",
       "      <td>Asinus asinum fricat</td>\n",
       "      <td>False</td>\n",
       "      <td>8279</td>\n",
       "      <td>25181</td>\n",
       "      <td>12324</td>\n",
       "      <td>1946</td>\n",
       "      <td>eraser</td>\n",
       "      <td>698392</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.linkedin.com/in/eraser/recent-acti...</td>\n",
       "      <td>False</td>\n",
       "      <td>Spain</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.463223e+18</td>\n",
       "      <td>The COVID-19 pandemic greatly impacted us all,...</td>\n",
       "      <td>430995737</td>\n",
       "      <td>Girls Who Code</td>\n",
       "      <td>here to change the face of tech</td>\n",
       "      <td>False</td>\n",
       "      <td>32365</td>\n",
       "      <td>396965</td>\n",
       "      <td>8039</td>\n",
       "      <td>4339</td>\n",
       "      <td>GirlsWhoCode</td>\n",
       "      <td>18129</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://girlswhocode.com/programs/code-at-home</td>\n",
       "      <td>True</td>\n",
       "      <td>United States</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.462489e+18</td>\n",
       "      <td>1-Over the last year, the most fervent debate ...</td>\n",
       "      <td>2493013459</td>\n",
       "      <td>Asante</td>\n",
       "      <td>~Namaste #Mom~Politico junkie~Veteranswife~#Un...</td>\n",
       "      <td>False</td>\n",
       "      <td>68750</td>\n",
       "      <td>2793</td>\n",
       "      <td>4909</td>\n",
       "      <td>31</td>\n",
       "      <td>realtalktruthD</td>\n",
       "      <td>63745</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>United States</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1.462475e+18</td>\n",
       "      <td>University Online Education during Covid 19 by...</td>\n",
       "      <td>342274886</td>\n",
       "      <td>Muttahir Ahmed Khan</td>\n",
       "      <td>Educationist, Writer, Analyst, Journalist, TV ...</td>\n",
       "      <td>False</td>\n",
       "      <td>86</td>\n",
       "      <td>133</td>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>MuttahirAhmedKh</td>\n",
       "      <td>312</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.462559e+18</td>\n",
       "      <td>\"Why lockdown and distance learning during the...</td>\n",
       "      <td>209987389</td>\n",
       "      <td>Gustavo Siles</td>\n",
       "      <td>FotografÃ­o en mi tiempo libre. Del 79. Profes...</td>\n",
       "      <td>False</td>\n",
       "      <td>5897</td>\n",
       "      <td>592</td>\n",
       "      <td>1157</td>\n",
       "      <td>8</td>\n",
       "      <td>gus_siles</td>\n",
       "      <td>6876</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.instagram.com/gus_siles/</td>\n",
       "      <td>False</td>\n",
       "      <td>Bolivia, Plurinational State of</td>\n",
       "      <td>Male</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.462758e+18</td>\n",
       "      <td>Will online learning replace traditional, clas...</td>\n",
       "      <td>886942048661536000</td>\n",
       "      <td>Simpliv Learning</td>\n",
       "      <td>A digital platform with a vast set of #online ...</td>\n",
       "      <td>False</td>\n",
       "      <td>113658</td>\n",
       "      <td>9031</td>\n",
       "      <td>9373</td>\n",
       "      <td>148</td>\n",
       "      <td>simplivllc</td>\n",
       "      <td>66006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.simplivlearning.com/</td>\n",
       "      <td>False</td>\n",
       "      <td>United States</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             id                                               text  \\\n",
       "0  1.462744e+18  FoSTaC: Advance Catering - Food Safety Supervi...   \n",
       "1  1.463142e+18  After a recent period of virtual learning at a...   \n",
       "2  1.462991e+18  ONLINE EDUCATION INCREASED GENDER INEQUALITY, ...   \n",
       "3  1.463207e+18  The Future of Online Education: The Impact of ...   \n",
       "4  1.462701e+18  DesafÃ­os digitales y virtuales de las bibliot...   \n",
       "5  1.463223e+18  The COVID-19 pandemic greatly impacted us all,...   \n",
       "6  1.462489e+18  1-Over the last year, the most fervent debate ...   \n",
       "7  1.462475e+18  University Online Education during Covid 19 by...   \n",
       "8  1.462559e+18  \"Why lockdown and distance learning during the...   \n",
       "9  1.462758e+18  Will online learning replace traditional, clas...   \n",
       "\n",
       "              user_id              user_name  \\\n",
       "0            68736735      Food Safety Works   \n",
       "1           746349877         Milton Courier   \n",
       "2  917983451671923968          arvind sharma   \n",
       "3            97964953         Josh Thackston   \n",
       "4             3122211  -ðŸª‘--- --ðŸ’º-ðŸŽ-   \n",
       "5           430995737         Girls Who Code   \n",
       "6          2493013459                 Asante   \n",
       "7           342274886    Muttahir Ahmed Khan   \n",
       "8           209987389          Gustavo Siles   \n",
       "9  886942048661536000       Simpliv Learning   \n",
       "\n",
       "                                    user_description  \\\n",
       "0  We are a food safety solution company helping ...   \n",
       "1  Community newspaper covering the latest happen...   \n",
       "2                                      arvind sharma   \n",
       "3  Instructional Designer & Instructional Develop...   \n",
       "4                               Asinus asinum fricat   \n",
       "5                    here to change the face of tech   \n",
       "6  ~Namaste #Mom~Politico junkie~Veteranswife~#Un...   \n",
       "7  Educationist, Writer, Analyst, Journalist, TV ...   \n",
       "8  FotografÃ­o en mi tiempo libre. Del 79. Profes...   \n",
       "9  A digital platform with a vast set of #online ...   \n",
       "\n",
       "   user_default_profile_image  user_favourites_count  user_followers_count  \\\n",
       "0                       False                     15                   131   \n",
       "1                       False                      0                  1309   \n",
       "2                       False                      0                    19   \n",
       "3                       False                      0                   234   \n",
       "4                       False                   8279                 25181   \n",
       "5                       False                  32365                396965   \n",
       "6                       False                  68750                  2793   \n",
       "7                       False                     86                   133   \n",
       "8                       False                   5897                   592   \n",
       "9                       False                 113658                  9031   \n",
       "\n",
       "   user_friends_count  user_listed_count user_screen_name  \\\n",
       "0                  88                  4  foodsafetyworks   \n",
       "1                 106                 23    MiltonCourier   \n",
       "2                   3                  0       kkr_arvind   \n",
       "3                 125                 28    joshthackston   \n",
       "4               12324               1946           eraser   \n",
       "5                8039               4339     GirlsWhoCode   \n",
       "6                4909                 31   realtalktruthD   \n",
       "7                 110                  1  MuttahirAhmedKh   \n",
       "8                1157                  8        gus_siles   \n",
       "9                9373                148       simplivllc   \n",
       "\n",
       "   user_statuses_count  user_time_zone  \\\n",
       "0                 1405             NaN   \n",
       "1                 6791             NaN   \n",
       "2                18958             NaN   \n",
       "3                 8144             NaN   \n",
       "4               698392             NaN   \n",
       "5                18129             NaN   \n",
       "6                63745             NaN   \n",
       "7                  312             NaN   \n",
       "8                 6876             NaN   \n",
       "9                66006             NaN   \n",
       "\n",
       "                                           user_urls  user_verified  \\\n",
       "0                     http://www.foodsafetyworks.com          False   \n",
       "1                 http://www.miltoncourieronline.com          False   \n",
       "2                                                NaN          False   \n",
       "3                              http://jthackston.com          False   \n",
       "4  https://www.linkedin.com/in/eraser/recent-acti...          False   \n",
       "5     https://girlswhocode.com/programs/code-at-home           True   \n",
       "6                                                NaN          False   \n",
       "7                                                NaN          False   \n",
       "8               https://www.instagram.com/gus_siles/          False   \n",
       "9                   https://www.simplivlearning.com/          False   \n",
       "\n",
       "                     user_location Gender  \n",
       "0                            India   None  \n",
       "1                   United Kingdom   Male  \n",
       "2                            India   Male  \n",
       "3            Sao Tome and Principe   Male  \n",
       "4                            Spain   None  \n",
       "5                    United States   None  \n",
       "6                    United States   Male  \n",
       "7                         Pakistan   Male  \n",
       "8  Bolivia, Plurinational State of   Male  \n",
       "9                    United States   None  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = df[['Gender', 'user_location']] # new df with only relavent columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Gender</th>\n",
       "      <th>user_location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "      <td>India</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Male</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Male</td>\n",
       "      <td>India</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Male</td>\n",
       "      <td>Sao Tome and Principe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>None</td>\n",
       "      <td>Spain</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Gender          user_location\n",
       "0   None                  India\n",
       "1   Male         United Kingdom\n",
       "2   Male                  India\n",
       "3   Male  Sao Tome and Principe\n",
       "4   None                  Spain"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/7z/0kv_9f_91cn42wfl7s9v8xcr0000gn/T/ipykernel_32183/3923099423.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1['Gender'] = df1['Gender'].astype('string') # change dtype to string\n",
      "/var/folders/7z/0kv_9f_91cn42wfl7s9v8xcr0000gn/T/ipykernel_32183/3923099423.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1['user_location'] = df1['user_location'].astype('string') # change dtype to string\n"
     ]
    }
   ],
   "source": [
    "df1['Gender'] = df1['Gender'].astype('string') # change dtype to string\n",
    "df1['user_location'] = df1['user_location'].astype('string') # change dtype to string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/7z/0kv_9f_91cn42wfl7s9v8xcr0000gn/T/ipykernel_32183/3886095102.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1['Gender'] = df1['Gender'].str.lower() # lower case all genders\n",
      "/var/folders/7z/0kv_9f_91cn42wfl7s9v8xcr0000gn/T/ipykernel_32183/3886095102.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1['Gender'] = df1['Gender'].str.strip() # remove trailing and leading whitespace\n",
      "/var/folders/7z/0kv_9f_91cn42wfl7s9v8xcr0000gn/T/ipykernel_32183/3886095102.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1['user_location'] = df1['user_location'].str.strip()\n"
     ]
    }
   ],
   "source": [
    "df1['Gender'] = df1['Gender'].str.lower() # lower case all genders\n",
    "df1['Gender'] = df1['Gender'].str.strip() # remove trailing and leading whitespace\n",
    "df1['user_location'] = df1['user_location'].str.strip() \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/7z/0kv_9f_91cn42wfl7s9v8xcr0000gn/T/ipykernel_32183/3163562697.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df1['user_location'] = df1['user_location'].replace({'USA': 'United States of America', 'United States': 'United States of America'})\n"
     ]
    }
   ],
   "source": [
    "df1['user_location'] = df1['user_location'].replace({'USA': 'United States of America', 'United States': 'United States of America'})\n",
    "# Countries in my DF must match countries in countries.geojson"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped_data = df1.groupby(['Gender', 'user_location']).size().reset_index(name='Count') # group data by two coloumns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_data = grouped_data.pivot(index='user_location', columns='Gender', values='Count').reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_data.columns.name = None  # Remove the column name\n",
    "pivot_data.rename(columns={'female': 'Female', 'male': 'Male', 'none': 'None'}, inplace=True) # add new coloumn names\n",
    "pivot_data.fillna(0, inplace=True) # fill all null vals with 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_data['Total'] = pivot_data['Male']+pivot_data['Female']+pivot_data['None'] # create new col for total tweets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>user_location</th>\n",
       "      <th>Female</th>\n",
       "      <th>Male</th>\n",
       "      <th>None</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>99.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>American Samoa</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Angola</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Anguilla</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Antarctica</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>24.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Armenia</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Australia</td>\n",
       "      <td>177.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>568.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Austria</td>\n",
       "      <td>26.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>13.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Bahamas</td>\n",
       "      <td>31.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>124.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Bahrain</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>100.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>550.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Barbados</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Belarus</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Belize</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>52.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Benin</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Bermuda</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bhutan</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Bolivia, Plurinational State of</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Botswana</td>\n",
       "      <td>16.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>141.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>British Indian Ocean Territory</td>\n",
       "      <td>45.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Brunei Darussalam</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>19.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Burundi</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Cabo Verde</td>\n",
       "      <td>30.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>155.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Cambodia</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Cameroon</td>\n",
       "      <td>134.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>505.0</td>\n",
       "      <td>796.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Canada</td>\n",
       "      <td>515.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>1088.0</td>\n",
       "      <td>2069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Cayman Islands</td>\n",
       "      <td>10.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Central African Republic</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Chad</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Chile</td>\n",
       "      <td>57.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>404.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>China</td>\n",
       "      <td>9.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>32.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Comoros</td>\n",
       "      <td>32.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Congo</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Congo, The Democratic Republic of the</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Cook Islands</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Cuba</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Cyprus</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Czechia</td>\n",
       "      <td>21.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Côte d'Ivoire</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Dominica</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>76.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>206.0</td>\n",
       "      <td>363.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Egypt</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>El Salvador</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>England</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Equatorial Guinea</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Eritrea</td>\n",
       "      <td>76.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>235.0</td>\n",
       "      <td>381.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Estonia</td>\n",
       "      <td>40.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Eswatini</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Falkland Islands (Malvinas)</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Faroe Islands</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Fiji</td>\n",
       "      <td>14.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Finland</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>France</td>\n",
       "      <td>29.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>178.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>French Southern Territories</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Gabon</td>\n",
       "      <td>39.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Gambia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>13.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Germany</td>\n",
       "      <td>67.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>276.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Ghana</td>\n",
       "      <td>26.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>141.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Greece</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Greenland</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Guadeloupe</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Guam</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Guatemala</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Guernsey</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Guinea</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Guyana</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Haiti</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Heard Island and McDonald Islands</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Holy See (Vatican City State)</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Honduras</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>74.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>347.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>India</td>\n",
       "      <td>396.0</td>\n",
       "      <td>1330.0</td>\n",
       "      <td>1405.0</td>\n",
       "      <td>3131.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>14.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Iran, Islamic Republic of</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Iraq</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>46.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>242.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Isle of Man</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Israel</td>\n",
       "      <td>94.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>362.0</td>\n",
       "      <td>592.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Italy</td>\n",
       "      <td>29.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>187.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Jamaica</td>\n",
       "      <td>50.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Japan</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Jersey</td>\n",
       "      <td>17.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Jordan</td>\n",
       "      <td>173.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>431.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Kazakhstan</td>\n",
       "      <td>22.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Kenya</td>\n",
       "      <td>117.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>351.0</td>\n",
       "      <td>586.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>Kiribati</td>\n",
       "      <td>12.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>Korea, Democratic People's Republic of</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>Korea, Republic of</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Kuwait</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Lao People's Democratic Republic</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Latvia</td>\n",
       "      <td>42.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Lebanon</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Lesotho</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Liberia</td>\n",
       "      <td>46.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Libya</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Lithuania</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>63.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>Madagascar</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>Malawi</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Malaysia</td>\n",
       "      <td>15.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>166.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>Maldives</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>Mali</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>Malta</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Martinique</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Mauritania</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Mauritius</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Mayotte</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>Micronesia, Federated States of</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>Moldova, Republic of</td>\n",
       "      <td>48.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>287.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Monaco</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>Mongolia</td>\n",
       "      <td>36.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>154.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>Montenegro</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Montserrat</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Morocco</td>\n",
       "      <td>50.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>297.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Mozambique</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Myanmar</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>Namibia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Nauru</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Nepal</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>Netherlands</td>\n",
       "      <td>31.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>99.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>New Delhi</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>New Zealand</td>\n",
       "      <td>23.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Niger</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Nigeria</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>Niue</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>None</td>\n",
       "      <td>4031.0</td>\n",
       "      <td>5395.0</td>\n",
       "      <td>10494.0</td>\n",
       "      <td>19920.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>North Macedonia</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>Northern Mariana Islands</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>Norway</td>\n",
       "      <td>8.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>Oman</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>23.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>168.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>Palau</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Palestine, State of</td>\n",
       "      <td>12.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>Panama</td>\n",
       "      <td>52.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>371.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Paraguay</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>Peru</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>44.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>370.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Pitcairn</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Poland</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>Puerto Rico</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Qatar</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Romania</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>28.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Rwanda</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Saint Barthélemy</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>Saint Helena, Ascension and Tristan da Cunha</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>Saint Kitts and Nevis</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>Saint Lucia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>Saint Pierre and Miquelon</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Saint Vincent and the Grenadines</td>\n",
       "      <td>16.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Samoa</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>San Marino</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Sao Tome and Principe</td>\n",
       "      <td>38.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>151.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Senegal</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>Serbia</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Seychelles</td>\n",
       "      <td>13.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>94.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>19.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>36.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Singapore</td>\n",
       "      <td>4.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>24.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>55.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>232.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Somalia</td>\n",
       "      <td>15.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>54.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>South Sudan</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Spain</td>\n",
       "      <td>54.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>348.0</td>\n",
       "      <td>475.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>Sudan</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Suriname</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>50.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>11.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>137.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>Syrian Arab Republic</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>Taiwan, Province of China</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>Tanzania, United Republic of</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>Thailand</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>74.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>Timor-Leste</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Togo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>Tokelau</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>Tonga</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Trinidad and Tobago</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>Tunisia</td>\n",
       "      <td>33.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>167.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>Turkey</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>Turkmenistan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>Turks and Caicos Islands</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>Tuvalu</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>Uganda</td>\n",
       "      <td>63.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>379.0</td>\n",
       "      <td>546.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>631.0</td>\n",
       "      <td>607.0</td>\n",
       "      <td>1740.0</td>\n",
       "      <td>2978.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>United States Minor Outlying Islands</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>United States of America</td>\n",
       "      <td>1106.0</td>\n",
       "      <td>977.0</td>\n",
       "      <td>3447.0</td>\n",
       "      <td>5530.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Vanuatu</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>Venezuela, Bolivarian Republic of</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Wallis and Futuna</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Western Sahara</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>Åland Islands</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    user_location  Female    Male     None  \\\n",
       "0                                     Afghanistan     1.0     4.0     13.0   \n",
       "1                                         Albania    19.0    17.0     63.0   \n",
       "2                                         Algeria     6.0     3.0     25.0   \n",
       "3                                  American Samoa     0.0     5.0     16.0   \n",
       "4                                         Andorra     8.0    10.0     44.0   \n",
       "5                                          Angola     3.0     1.0      4.0   \n",
       "6                                        Anguilla     1.0     0.0      3.0   \n",
       "7                                      Antarctica     1.0     1.0      4.0   \n",
       "8                             Antigua and Barbuda     1.0     0.0      2.0   \n",
       "9                                       Argentina    24.0    17.0     39.0   \n",
       "10                                        Armenia     5.0     5.0      7.0   \n",
       "11                                      Australia   177.0    97.0    294.0   \n",
       "12                                        Austria    26.0    16.0     36.0   \n",
       "13                                     Azerbaijan    13.0    23.0     32.0   \n",
       "14                                        Bahamas    31.0    25.0     68.0   \n",
       "15                                        Bahrain     0.0     2.0      6.0   \n",
       "16                                     Bangladesh   100.0   135.0    315.0   \n",
       "17                                       Barbados     2.0     1.0     10.0   \n",
       "18                                        Belarus     5.0     8.0     13.0   \n",
       "19                                        Belgium    10.0     7.0     28.0   \n",
       "20                                         Belize     6.0     9.0     37.0   \n",
       "21                                          Benin     3.0     2.0      6.0   \n",
       "22                                        Bermuda     0.0     0.0      1.0   \n",
       "23                                         Bhutan     2.0     0.0      2.0   \n",
       "24                Bolivia, Plurinational State of     3.0    11.0      6.0   \n",
       "25                         Bosnia and Herzegovina     1.0     1.0      8.0   \n",
       "26                                       Botswana    16.0    19.0    106.0   \n",
       "27                                         Brazil     1.0     7.0     14.0   \n",
       "28                 British Indian Ocean Territory    45.0    12.0     66.0   \n",
       "29                              Brunei Darussalam     0.0     0.0      5.0   \n",
       "30                                       Bulgaria    19.0    27.0     76.0   \n",
       "31                                   Burkina Faso     4.0     4.0     12.0   \n",
       "32                                        Burundi     4.0     3.0     15.0   \n",
       "33                                     Cabo Verde    30.0    21.0    104.0   \n",
       "34                                       Cambodia     4.0     8.0     19.0   \n",
       "35                                       Cameroon   134.0   157.0    505.0   \n",
       "36                                         Canada   515.0   466.0   1088.0   \n",
       "37                                 Cayman Islands    10.0    37.0     36.0   \n",
       "38                       Central African Republic     2.0     3.0      1.0   \n",
       "39                                           Chad     0.0     1.0      1.0   \n",
       "40                                          Chile    57.0    68.0    279.0   \n",
       "41                                          China     9.0    17.0     67.0   \n",
       "42                                       Colombia    32.0    23.0     46.0   \n",
       "43                                        Comoros    32.0    17.0     66.0   \n",
       "44                                          Congo     1.0     0.0      5.0   \n",
       "45          Congo, The Democratic Republic of the     4.0     1.0      4.0   \n",
       "46                                   Cook Islands     0.0     0.0      3.0   \n",
       "47                                     Costa Rica     1.0     8.0     21.0   \n",
       "48                                        Croatia     2.0     8.0     15.0   \n",
       "49                                           Cuba     1.0     2.0      4.0   \n",
       "50                                         Cyprus     1.0     1.0      3.0   \n",
       "51                                        Czechia    21.0     5.0     41.0   \n",
       "52                                  Côte d'Ivoire     0.0     0.0      3.0   \n",
       "53                                        Denmark     3.0    11.0     21.0   \n",
       "54                                       Dominica     1.0     2.0      8.0   \n",
       "55                             Dominican Republic    76.0    81.0    206.0   \n",
       "56                                        Ecuador     1.0     1.0      8.0   \n",
       "57                                          Egypt     0.0     7.0     17.0   \n",
       "58                                    El Salvador     0.0     0.0      2.0   \n",
       "59                                        England     0.0     1.0      0.0   \n",
       "60                              Equatorial Guinea     3.0     5.0      2.0   \n",
       "61                                        Eritrea    76.0    70.0    235.0   \n",
       "62                                        Estonia    40.0    37.0    103.0   \n",
       "63                                       Eswatini     0.0     1.0      2.0   \n",
       "64                                       Ethiopia     1.0     1.0      5.0   \n",
       "65                    Falkland Islands (Malvinas)     0.0     0.0      1.0   \n",
       "66                                  Faroe Islands     0.0     1.0      1.0   \n",
       "67                                           Fiji    14.0    27.0     49.0   \n",
       "68                                        Finland    11.0     7.0     16.0   \n",
       "69                                         France    29.0    28.0    121.0   \n",
       "70                    French Southern Territories     1.0     0.0      3.0   \n",
       "71                                          Gabon    39.0    37.0     84.0   \n",
       "72                                         Gambia     1.0     1.0      3.0   \n",
       "73                                        Georgia    13.0    15.0     43.0   \n",
       "74                                        Germany    67.0    59.0    150.0   \n",
       "75                                          Ghana    26.0    24.0     91.0   \n",
       "76                                         Greece     7.0     6.0     27.0   \n",
       "77                                      Greenland     3.0     3.0      7.0   \n",
       "78                                     Guadeloupe     2.0     0.0      3.0   \n",
       "79                                           Guam     0.0     1.0      9.0   \n",
       "80                                      Guatemala     0.0     0.0      1.0   \n",
       "81                                       Guernsey     1.0     4.0      3.0   \n",
       "82                                         Guinea     0.0     0.0      3.0   \n",
       "83                                  Guinea-Bissau     0.0     0.0      1.0   \n",
       "84                                         Guyana     0.0     1.0      0.0   \n",
       "85                                          Haiti     1.0     0.0      0.0   \n",
       "86              Heard Island and McDonald Islands     0.0     1.0      0.0   \n",
       "87                  Holy See (Vatican City State)     0.0     0.0      6.0   \n",
       "88                                       Honduras     6.0     6.0      4.0   \n",
       "89                                      Hong Kong     3.0    17.0     19.0   \n",
       "90                                        Hungary     3.0     2.0      3.0   \n",
       "91                                        Iceland    74.0    69.0    204.0   \n",
       "92                                          India   396.0  1330.0   1405.0   \n",
       "93                                      Indonesia    14.0    18.0     55.0   \n",
       "94                      Iran, Islamic Republic of     3.0     3.0      8.0   \n",
       "95                                           Iraq     0.0     0.0      4.0   \n",
       "96                                        Ireland    46.0    50.0    146.0   \n",
       "97                                    Isle of Man     0.0     1.0      7.0   \n",
       "98                                         Israel    94.0   136.0    362.0   \n",
       "99                                          Italy    29.0    41.0    117.0   \n",
       "100                                       Jamaica    50.0    45.0    139.0   \n",
       "101                                         Japan    12.0    12.0     43.0   \n",
       "102                                        Jersey    17.0     4.0     13.0   \n",
       "103                                        Jordan   173.0    28.0    230.0   \n",
       "104                                    Kazakhstan    22.0    26.0     77.0   \n",
       "105                                         Kenya   117.0   118.0    351.0   \n",
       "106                                      Kiribati    12.0    16.0     42.0   \n",
       "107        Korea, Democratic People's Republic of     1.0     0.0      4.0   \n",
       "108                            Korea, Republic of     4.0     2.0     13.0   \n",
       "109                                        Kuwait     3.0     3.0      6.0   \n",
       "110              Lao People's Democratic Republic     4.0    11.0     30.0   \n",
       "111                                        Latvia    42.0    39.0    119.0   \n",
       "112                                       Lebanon     1.0     2.0      7.0   \n",
       "113                                       Lesotho     0.0     0.0      3.0   \n",
       "114                                       Liberia    46.0    15.0     59.0   \n",
       "115                                         Libya     1.0     0.0      5.0   \n",
       "116                                 Liechtenstein     0.0     0.0      2.0   \n",
       "117                                     Lithuania     1.0     3.0      6.0   \n",
       "118                                    Luxembourg     8.0    15.0     40.0   \n",
       "119                                    Madagascar     1.0     1.0      5.0   \n",
       "120                                        Malawi     0.0     2.0      2.0   \n",
       "121                                      Malaysia    15.0    19.0    132.0   \n",
       "122                                      Maldives     0.0     2.0      5.0   \n",
       "123                                          Mali     1.0     1.0      2.0   \n",
       "124                                         Malta     9.0    10.0     15.0   \n",
       "125                              Marshall Islands     9.0    13.0     18.0   \n",
       "126                                    Martinique     1.0     1.0      1.0   \n",
       "127                                    Mauritania     2.0     9.0      4.0   \n",
       "128                                     Mauritius     0.0     2.0     11.0   \n",
       "129                                       Mayotte     0.0     1.0      2.0   \n",
       "130                                        Mexico     3.0    16.0      7.0   \n",
       "131               Micronesia, Federated States of     1.0     0.0      0.0   \n",
       "132                          Moldova, Republic of    48.0    53.0    186.0   \n",
       "133                                        Monaco     8.0     4.0     15.0   \n",
       "134                                      Mongolia    36.0    26.0     92.0   \n",
       "135                                    Montenegro     7.0     2.0     10.0   \n",
       "136                                    Montserrat     5.0     3.0     13.0   \n",
       "137                                       Morocco    50.0    59.0    188.0   \n",
       "138                                    Mozambique     1.0     0.0      3.0   \n",
       "139                                       Myanmar     0.0     1.0      2.0   \n",
       "140                                       Namibia     1.0     1.0      6.0   \n",
       "141                                         Nauru     1.0     0.0      0.0   \n",
       "142                                         Nepal     3.0     8.0      7.0   \n",
       "143                                   Netherlands    31.0    21.0     47.0   \n",
       "144                                     New Delhi     0.0     0.0      1.0   \n",
       "145                                   New Zealand    23.0    26.0     45.0   \n",
       "146                                     Nicaragua     0.0     1.0      1.0   \n",
       "147                                         Niger     5.0     7.0     17.0   \n",
       "148                                       Nigeria    11.0    10.0     48.0   \n",
       "149                                          Niue     0.0     0.0      1.0   \n",
       "150                                          None  4031.0  5395.0  10494.0   \n",
       "151                               North Macedonia     2.0     4.0      6.0   \n",
       "152                      Northern Mariana Islands     0.0     3.0      1.0   \n",
       "153                                        Norway     8.0    24.0     49.0   \n",
       "154                                          Oman     1.0     1.0      6.0   \n",
       "155                                      Pakistan    23.0    66.0     79.0   \n",
       "156                                         Palau     1.0     5.0      2.0   \n",
       "157                           Palestine, State of    12.0    16.0     20.0   \n",
       "158                                        Panama    52.0    70.0    249.0   \n",
       "159                              Papua New Guinea     2.0     3.0      6.0   \n",
       "160                                      Paraguay     6.0     3.0      7.0   \n",
       "161                                          Peru     2.0     5.0      9.0   \n",
       "162                                   Philippines    44.0    65.0    261.0   \n",
       "163                                      Pitcairn     0.0     0.0      2.0   \n",
       "164                                        Poland     1.0     4.0     16.0   \n",
       "165                                      Portugal     4.0    13.0     14.0   \n",
       "166                                   Puerto Rico     2.0     0.0      8.0   \n",
       "167                                         Qatar     1.0     7.0     36.0   \n",
       "168                                       Romania     1.0     7.0      3.0   \n",
       "169                            Russian Federation    28.0    30.0     53.0   \n",
       "170                                        Rwanda     3.0     3.0     12.0   \n",
       "171                              Saint Barthélemy     0.0     0.0      1.0   \n",
       "172  Saint Helena, Ascension and Tristan da Cunha     1.0     1.0      3.0   \n",
       "173                         Saint Kitts and Nevis     6.0    13.0     23.0   \n",
       "174                                   Saint Lucia     0.0     0.0      3.0   \n",
       "175                     Saint Pierre and Miquelon     0.0     0.0      2.0   \n",
       "176              Saint Vincent and the Grenadines    16.0    11.0     16.0   \n",
       "177                                         Samoa     0.0     1.0      1.0   \n",
       "178                                    San Marino     0.0     0.0      4.0   \n",
       "179                         Sao Tome and Principe    38.0    46.0     67.0   \n",
       "180                                  Saudi Arabia     6.0     3.0     14.0   \n",
       "181                                       Senegal     0.0     0.0      3.0   \n",
       "182                                        Serbia    13.0    12.0     34.0   \n",
       "183                                    Seychelles    13.0    25.0     56.0   \n",
       "184                                  Sierra Leone    19.0     9.0      8.0   \n",
       "185                                     Singapore     4.0    64.0     21.0   \n",
       "186                                      Slovakia    24.0     3.0     24.0   \n",
       "187                                      Slovenia    55.0    41.0    136.0   \n",
       "188                               Solomon Islands     1.0     2.0      5.0   \n",
       "189                                       Somalia    15.0    12.0     27.0   \n",
       "190                                  South Africa     4.0     1.0     26.0   \n",
       "191                                   South Sudan    10.0     4.0     14.0   \n",
       "192                                         Spain    54.0    73.0    348.0   \n",
       "193                                     Sri Lanka     8.0     5.0     11.0   \n",
       "194                                         Sudan    12.0     2.0     12.0   \n",
       "195                                      Suriname     2.0     1.0      7.0   \n",
       "196                                        Sweden    50.0    34.0     86.0   \n",
       "197                                   Switzerland    11.0    15.0    111.0   \n",
       "198                          Syrian Arab Republic     0.0     0.0     11.0   \n",
       "199                     Taiwan, Province of China     6.0     8.0     14.0   \n",
       "200                  Tanzania, United Republic of     7.0     8.0     22.0   \n",
       "201                                      Thailand     7.0     8.0     59.0   \n",
       "202                                   Timor-Leste     0.0     0.0      2.0   \n",
       "203                                          Togo     0.0     0.0      4.0   \n",
       "204                                       Tokelau     0.0     1.0      0.0   \n",
       "205                                         Tonga    12.0     5.0     17.0   \n",
       "206                           Trinidad and Tobago     3.0    10.0     15.0   \n",
       "207                                       Tunisia    33.0    29.0    105.0   \n",
       "208                                        Turkey     5.0     6.0     16.0   \n",
       "209                                  Turkmenistan     1.0     0.0      0.0   \n",
       "210                      Turks and Caicos Islands     6.0     6.0     10.0   \n",
       "211                                        Tuvalu     0.0     3.0      4.0   \n",
       "212                                        Uganda    63.0   104.0    379.0   \n",
       "213                                       Ukraine     2.0     1.0      6.0   \n",
       "214                          United Arab Emirates     7.0     4.0      1.0   \n",
       "215                                United Kingdom   631.0   607.0   1740.0   \n",
       "216          United States Minor Outlying Islands     8.0     1.0     11.0   \n",
       "217                      United States of America  1106.0   977.0   3447.0   \n",
       "218                                       Uruguay     0.0     1.0      6.0   \n",
       "219                                       Vanuatu     1.0     1.0      0.0   \n",
       "220             Venezuela, Bolivarian Republic of     0.0     1.0      3.0   \n",
       "221                                      Viet Nam    12.0     8.0     23.0   \n",
       "222                             Wallis and Futuna     1.0     2.0     22.0   \n",
       "223                                Western Sahara     1.0     1.0      6.0   \n",
       "224                                         Yemen     0.0     2.0      0.0   \n",
       "225                                        Zambia     4.0     2.0      3.0   \n",
       "226                                      Zimbabwe     4.0     8.0     25.0   \n",
       "227                                 Åland Islands     0.0     0.0      1.0   \n",
       "\n",
       "       Total  \n",
       "0       18.0  \n",
       "1       99.0  \n",
       "2       34.0  \n",
       "3       21.0  \n",
       "4       62.0  \n",
       "5        8.0  \n",
       "6        4.0  \n",
       "7        6.0  \n",
       "8        3.0  \n",
       "9       80.0  \n",
       "10      17.0  \n",
       "11     568.0  \n",
       "12      78.0  \n",
       "13      68.0  \n",
       "14     124.0  \n",
       "15       8.0  \n",
       "16     550.0  \n",
       "17      13.0  \n",
       "18      26.0  \n",
       "19      45.0  \n",
       "20      52.0  \n",
       "21      11.0  \n",
       "22       1.0  \n",
       "23       4.0  \n",
       "24      20.0  \n",
       "25      10.0  \n",
       "26     141.0  \n",
       "27      22.0  \n",
       "28     123.0  \n",
       "29       5.0  \n",
       "30     122.0  \n",
       "31      20.0  \n",
       "32      22.0  \n",
       "33     155.0  \n",
       "34      31.0  \n",
       "35     796.0  \n",
       "36    2069.0  \n",
       "37      83.0  \n",
       "38       6.0  \n",
       "39       2.0  \n",
       "40     404.0  \n",
       "41      93.0  \n",
       "42     101.0  \n",
       "43     115.0  \n",
       "44       6.0  \n",
       "45       9.0  \n",
       "46       3.0  \n",
       "47      30.0  \n",
       "48      25.0  \n",
       "49       7.0  \n",
       "50       5.0  \n",
       "51      67.0  \n",
       "52       3.0  \n",
       "53      35.0  \n",
       "54      11.0  \n",
       "55     363.0  \n",
       "56      10.0  \n",
       "57      24.0  \n",
       "58       2.0  \n",
       "59       1.0  \n",
       "60      10.0  \n",
       "61     381.0  \n",
       "62     180.0  \n",
       "63       3.0  \n",
       "64       7.0  \n",
       "65       1.0  \n",
       "66       2.0  \n",
       "67      90.0  \n",
       "68      34.0  \n",
       "69     178.0  \n",
       "70       4.0  \n",
       "71     160.0  \n",
       "72       5.0  \n",
       "73      71.0  \n",
       "74     276.0  \n",
       "75     141.0  \n",
       "76      40.0  \n",
       "77      13.0  \n",
       "78       5.0  \n",
       "79      10.0  \n",
       "80       1.0  \n",
       "81       8.0  \n",
       "82       3.0  \n",
       "83       1.0  \n",
       "84       1.0  \n",
       "85       1.0  \n",
       "86       1.0  \n",
       "87       6.0  \n",
       "88      16.0  \n",
       "89      39.0  \n",
       "90       8.0  \n",
       "91     347.0  \n",
       "92    3131.0  \n",
       "93      87.0  \n",
       "94      14.0  \n",
       "95       4.0  \n",
       "96     242.0  \n",
       "97       8.0  \n",
       "98     592.0  \n",
       "99     187.0  \n",
       "100    234.0  \n",
       "101     67.0  \n",
       "102     34.0  \n",
       "103    431.0  \n",
       "104    125.0  \n",
       "105    586.0  \n",
       "106     70.0  \n",
       "107      5.0  \n",
       "108     19.0  \n",
       "109     12.0  \n",
       "110     45.0  \n",
       "111    200.0  \n",
       "112     10.0  \n",
       "113      3.0  \n",
       "114    120.0  \n",
       "115      6.0  \n",
       "116      2.0  \n",
       "117     10.0  \n",
       "118     63.0  \n",
       "119      7.0  \n",
       "120      4.0  \n",
       "121    166.0  \n",
       "122      7.0  \n",
       "123      4.0  \n",
       "124     34.0  \n",
       "125     40.0  \n",
       "126      3.0  \n",
       "127     15.0  \n",
       "128     13.0  \n",
       "129      3.0  \n",
       "130     26.0  \n",
       "131      1.0  \n",
       "132    287.0  \n",
       "133     27.0  \n",
       "134    154.0  \n",
       "135     19.0  \n",
       "136     21.0  \n",
       "137    297.0  \n",
       "138      4.0  \n",
       "139      3.0  \n",
       "140      8.0  \n",
       "141      1.0  \n",
       "142     18.0  \n",
       "143     99.0  \n",
       "144      1.0  \n",
       "145     94.0  \n",
       "146      2.0  \n",
       "147     29.0  \n",
       "148     69.0  \n",
       "149      1.0  \n",
       "150  19920.0  \n",
       "151     12.0  \n",
       "152      4.0  \n",
       "153     81.0  \n",
       "154      8.0  \n",
       "155    168.0  \n",
       "156      8.0  \n",
       "157     48.0  \n",
       "158    371.0  \n",
       "159     11.0  \n",
       "160     16.0  \n",
       "161     16.0  \n",
       "162    370.0  \n",
       "163      2.0  \n",
       "164     21.0  \n",
       "165     31.0  \n",
       "166     10.0  \n",
       "167     44.0  \n",
       "168     11.0  \n",
       "169    111.0  \n",
       "170     18.0  \n",
       "171      1.0  \n",
       "172      5.0  \n",
       "173     42.0  \n",
       "174      3.0  \n",
       "175      2.0  \n",
       "176     43.0  \n",
       "177      2.0  \n",
       "178      4.0  \n",
       "179    151.0  \n",
       "180     23.0  \n",
       "181      3.0  \n",
       "182     59.0  \n",
       "183     94.0  \n",
       "184     36.0  \n",
       "185     89.0  \n",
       "186     51.0  \n",
       "187    232.0  \n",
       "188      8.0  \n",
       "189     54.0  \n",
       "190     31.0  \n",
       "191     28.0  \n",
       "192    475.0  \n",
       "193     24.0  \n",
       "194     26.0  \n",
       "195     10.0  \n",
       "196    170.0  \n",
       "197    137.0  \n",
       "198     11.0  \n",
       "199     28.0  \n",
       "200     37.0  \n",
       "201     74.0  \n",
       "202      2.0  \n",
       "203      4.0  \n",
       "204      1.0  \n",
       "205     34.0  \n",
       "206     28.0  \n",
       "207    167.0  \n",
       "208     27.0  \n",
       "209      1.0  \n",
       "210     22.0  \n",
       "211      7.0  \n",
       "212    546.0  \n",
       "213      9.0  \n",
       "214     12.0  \n",
       "215   2978.0  \n",
       "216     20.0  \n",
       "217   5530.0  \n",
       "218      7.0  \n",
       "219      2.0  \n",
       "220      4.0  \n",
       "221     43.0  \n",
       "222     25.0  \n",
       "223      8.0  \n",
       "224      2.0  \n",
       "225      9.0  \n",
       "226     37.0  \n",
       "227      1.0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_data= pivot_data[pivot_data['user_location'] != 'None'] # remove tweets which had no country,19920.0 tweets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot_data.to_csv('Countries_num_tweets') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "import folium\n",
    "import pandas as pd\n",
    "\n",
    "\n",
    "# Create a Folium map\n",
    "m = folium.Map(location=[0, 0], zoom_start=2)\n",
    "\n",
    "# Define custom color bins and their ranges\n",
    "colors = ['green', 'yellow', 'red']\n",
    "threshold_scale = [0,50,150,300,450,600,750,900,pivot_data['Female'].max()]  # range of scale\n",
    "\n",
    "# Add choropleth layer for Female with custom color scale and ranges\n",
    "folium.Choropleth(\n",
    "    geo_data=\"countries.geojson\",  # GeoJSON file with country boundaries\n",
    "    name=\"Female\",\n",
    "    data=pivot_data,\n",
    "    columns=[\"user_location\", \"Female\"],\n",
    "    key_on=\"feature.properties.ADMIN\",\n",
    "    fill_opacity=0.7,\n",
    "    line_opacity=0.2,\n",
    "    legend_name=\"# of Female Tweets\",\n",
    "    bins=threshold_scale,  # Use the custom threshold scale\n",
    "    threshold_scale=threshold_scale,  # Specify the custom threshold scale\n",
    "    fill_color='YlGnBu',  # Use a base color scale without a lambda function\n",
    ").add_to(m)\n",
    "\n",
    "\n",
    "# Display the map\n",
    "m.save(\"female_custom_colors.html\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "import folium\n",
    "import pandas as pd\n",
    "\n",
    "\n",
    "# Create a Folium map\n",
    "m = folium.Map(location=[0, 0], zoom_start=2)\n",
    "\n",
    "# Define custom color bins and their ranges\n",
    "colors = ['green', 'yellow', 'red']\n",
    "threshold_scale = [0,50,150,300,450,600,750,900,1050,pivot_data['Male'].max()]  # Adjust the ranges as needed\n",
    "\n",
    "# Add choropleth layer for Female with custom color scale and ranges\n",
    "folium.Choropleth(\n",
    "    geo_data=\"countries.geojson\",  # GeoJSON file with country boundaries\n",
    "    name=\"Male\",\n",
    "    data=pivot_data,\n",
    "    columns=[\"user_location\", \"Male\"],\n",
    "    key_on=\"feature.properties.ADMIN\",\n",
    "    fill_opacity=0.7,\n",
    "    line_opacity=0.2,\n",
    "    legend_name=\"# of Tweets by Males\",\n",
    "    bins=threshold_scale,  # Use the custom threshold scale\n",
    "    threshold_scale=threshold_scale,  # Specify the custom threshold scale\n",
    "    fill_color='YlGnBu',  # Use a base color scale without a lambda function\n",
    ").add_to(m)\n",
    "\n",
    "\n",
    "\n",
    "# Display the map\n",
    "m.save(\"male_custom_colors.html\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "import folium\n",
    "import pandas as pd\n",
    "\n",
    "# Create a Folium map\n",
    "m = folium.Map(location=[0, 0], zoom_start=2)\n",
    "\n",
    "# Define custom color bins and their ranges\n",
    "colors = ['green', 'yellow', 'red']\n",
    "threshold_scale = [0,300,800,1400,2000, 2500,3500, 4500,pivot_data['Total'].max()]  # Adjust the ranges as needed\n",
    "\n",
    "# Add choropleth layer for Female with custom color scale and ranges\n",
    "folium.Choropleth(\n",
    "    geo_data=\"countries.geojson\",  # GeoJSON file with country boundaries\n",
    "    name=\"Total\",\n",
    "    data=pivot_data,\n",
    "    columns=[\"user_location\", \"Total\"],\n",
    "    key_on=\"feature.properties.ADMIN\",\n",
    "    fill_opacity=0.7,\n",
    "    line_opacity=0.2,\n",
    "    legend_name=\"Total Tweets per Country\",\n",
    "    bins=threshold_scale,  # Use the custom threshold scale\n",
    "    threshold_scale=threshold_scale,  # Specify the custom threshold scale\n",
    "    fill_color='YlGnBu',  # Use a base color scale without a lambda function\n",
    ").add_to(m)\n",
    "\n",
    "\n",
    "\n",
    "# Display the map\n",
    "m.save(\"total_custom_colors.html\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "import folium\n",
    "import pandas as pd\n",
    "\n",
    "# Create a Folium map\n",
    "m = folium.Map(location=[0, 0], zoom_start=2)\n",
    "\n",
    "# Define custom color bins and their ranges\n",
    "colors = ['green', 'yellow', 'red']\n",
    "threshold_scale = [0,150,500,1200,2000,pivot_data['None'].max()]  # Adjust the ranges as needed\n",
    "\n",
    "# Add choropleth layer for Female with custom color scale and ranges\n",
    "folium.Choropleth(\n",
    "    geo_data=\"countries.geojson\",  # GeoJSON file with country boundaries\n",
    "    name=\"None\",\n",
    "    data=pivot_data,\n",
    "    columns=[\"user_location\", \"None\"],\n",
    "    key_on=\"feature.properties.ADMIN\",\n",
    "    fill_opacity=0.7,\n",
    "    line_opacity=0.2,\n",
    "    legend_name=\"Tweets per Country with Gender not specified\",\n",
    "    bins=threshold_scale,  # Use the custom threshold scale\n",
    "    threshold_scale=threshold_scale,  # Specify the custom threshold scale\n",
    "    fill_color='YlGnBu',  # Use a base color scale without a lambda function\n",
    ").add_to(m)\n",
    "\n",
    "\n",
    "\n",
    "# Display the map\n",
    "m.save(\"None_custom_colors.html\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "aee8b7b246df8f9039afb4144a1f6fd8d2ca17a180786b69acc140d282b71a49"
  },
  "kernelspec": {
   "display_name": "Python 3.10.4 64-bit",
   "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.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}