Session3 woldbank indicators of original countries.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Session3 : fill all woldbank indicators of original countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas #to manipulate data\n",
    "import time #deal with time\n",
    "import random #generate random numbers\n",
    "import pickle #save data\n",
    "import requests #request on the internet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import tqdm #loading bar for loops"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Open the pickle in which we saved the dictionary ['country_name','cuntry_code']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open ('countries.pickle','rb') as fp:\n",
    "    countries = pickle.load(fp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "filename = 'Data-sheet-STUDENTS.xlsx'\n",
    "df = pandas.read_excel(filename, header=2, usecols='B:AR')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Function to get the last value of indicator for a given country code by asking the worldbank API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3.89434134127694"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_indicator(country_code,indicator):\n",
    "    head = 'http://api.worldbank.org/v2/country/'\n",
    "    middle = '/indicator/'\n",
    "    tail = '?format=json'\n",
    "    url = head+country_code+middle+indicator+tail\n",
    "    r = requests.get(url)\n",
    "    try:\n",
    "        data = r.json()\n",
    "        for i in data[1]:\n",
    "            if i['value'] is None:\n",
    "                continue\n",
    "            else:\n",
    "                return i['value']\n",
    "    except KeyError:\n",
    "        return None\n",
    "    except IndexError:\n",
    "        return None\n",
    "        \n",
    "get_indicator('CHN','GC.TAX.IMPT.ZS')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "the dic to associate indicators with the ULR code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "indicator_list={\n",
    "'IMF WB\\nCustoms and other import duties (% of tax revenue) 2016':'GC.TAX.IMPT.ZS',\n",
    "'WB IMF Non-performing loans to total gross loans ratio (%)':'FB.AST.NPER.ZS',\n",
    "'UIC Rail freight (mn ton x km travelled)':'IS.RRS.GOOD.MT.K6',\n",
    "'WB Household final consumption expenditure, PPP bn USD':'NE.CON.PRVT.PP.CD',\n",
    "'WB UNESCO R&D Expenditure % of GDP':'GB.XPD.RSDV.GD.ZS',\n",
    "'WB UNESCO Researchers p. mn inhabitants':'SP.POP.SCIE.RD.P6',\n",
    "'IFDI Net Inflows (% of GDP)':'BX.KLT.DINV.WD.GD.ZS',\n",
    "'WHO Current Health Expenditure p.c., PPP USD':'SH.XPD.CHEX.PP.CD',\n",
    "'WB Research Expenditure % of GDP':'GB.XPD.RSDV.GD.ZS',\n",
    "'WIPO Trademark applications':'IP.TMK.RSCT',\n",
    "'WIPO Patent Applications':'IP.PAT.RESD'\n",
    "}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Fill the 'GC.TAX.IMPT.ZS' indicatior collumn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Afghanistan done...\n",
      "Albania done...\n",
      "Armenia done...\n",
      "Azerbaijan done...\n",
      "Bahrain done...\n",
      "Bangladesh done...\n",
      "Belarus done...\n",
      "Bhutan done...\n",
      "Bosnia and Herzegovina done...\n",
      "Brunei done...\n",
      "Bulgaria done...\n",
      "Cambodia done...\n",
      "China done...\n",
      "Croatia done...\n",
      "Czech Republic done...\n",
      "East Timor done...\n",
      "Egypt done...\n",
      "Estonia done...\n",
      "France done...\n",
      "Georgia done...\n",
      "Germany done...\n",
      "Hungary done...\n",
      "India done...\n",
      "Indonesia done...\n",
      "Iran done...\n",
      "Iraq done...\n",
      "Israel done...\n",
      "Jordan done...\n",
      "Kazakhstan done...\n",
      "Kuwait done...\n",
      "Kyrgyzstan done...\n",
      "Laos done...\n",
      "Latvia done...\n",
      "Lebanon done...\n",
      "Lithuania done...\n",
      "Macedonia done...\n",
      "Malaysia done...\n",
      "Maldives done...\n",
      "Moldova done...\n",
      "Mongolia done...\n",
      "Montenegro done...\n",
      "Myanmar done...\n",
      "Nepal done...\n",
      "Oman done...\n",
      "Pakistan done...\n",
      "Philippines done...\n",
      "Poland done...\n",
      "Qatar done...\n",
      "Romania done...\n",
      "Russia done...\n",
      "Saudi Arabia done...\n",
      "Serbia done...\n",
      "Singapore done...\n",
      "Slovakia done...\n",
      "Slovenia done...\n",
      "Sri Lanka done...\n",
      "Syria done...\n",
      "Tajikistan done...\n",
      "Thailiand done...\n",
      "The United Arab Emirates done...\n",
      "Turkey done...\n",
      "Turkmenistan done...\n",
      "United Kingdom done...\n",
      "United States of America done...\n",
      "Ukraine done...\n",
      "Uzbekistan done...\n",
      "Vietnam done...\n",
      "Yemen done...\n"
     ]
    },
    {
     "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>Country (according to CN Gov):</th>\n",
       "      <th>IMF WB\n",
       "Customs and other import duties (% of tax revenue) 2016</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>32.551072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>2.216459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Armenia</td>\n",
       "      <td>6.275395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>4.550383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bahrain</td>\n",
       "      <td>87.914439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>28.923008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Belarus</td>\n",
       "      <td>8.200619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bhutan</td>\n",
       "      <td>3.052294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>0.066132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Brunei</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>0.072798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Cambodia</td>\n",
       "      <td>15.785253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>China</td>\n",
       "      <td>3.894341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>0.670090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>0.819567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>East Timor</td>\n",
       "      <td>5.741272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Egypt</td>\n",
       "      <td>6.849002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Estonia</td>\n",
       "      <td>0.039429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>France (Not BRI)</td>\n",
       "      <td>-0.021908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>0.796325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Germany (not BRI)</td>\n",
       "      <td>0.021249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>-0.000145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>India</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>2.463390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Iran</td>\n",
       "      <td>20.696450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Iraq</td>\n",
       "      <td>14.105211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Israel</td>\n",
       "      <td>1.153110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Jordan</td>\n",
       "      <td>8.533450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Kazakhstan</td>\n",
       "      <td>5.299908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Kuwait</td>\n",
       "      <td>66.806723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Moldova</td>\n",
       "      <td>3.423233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Mongolia</td>\n",
       "      <td>12.087573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Montenegro</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Myanmar</td>\n",
       "      <td>9.003222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Nepal</td>\n",
       "      <td>17.770038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Oman</td>\n",
       "      <td>28.368146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>18.780936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>20.357608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Poland</td>\n",
       "      <td>0.128546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Qatar</td>\n",
       "      <td>6.021326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Romania</td>\n",
       "      <td>0.003434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Russia</td>\n",
       "      <td>6.217626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Serbia</td>\n",
       "      <td>5.062219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Singapore</td>\n",
       "      <td>0.071508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>0.000290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>0.808280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>22.054891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Syria</td>\n",
       "      <td>10.230756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Thailiand</td>\n",
       "      <td>3.952757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>The United Arab Emirates</td>\n",
       "      <td>0.381747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Turkey</td>\n",
       "      <td>2.418238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Turkmenistan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>United Kingdom (Not BRI)</td>\n",
       "      <td>0.047747</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>United States of America (Not BRI)</td>\n",
       "      <td>1.656294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>3.997681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>5.186860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Vietnam</td>\n",
       "      <td>18.427549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Country (according to CN Gov):  \\\n",
       "0                          Afghanistan   \n",
       "1                              Albania   \n",
       "2                              Armenia   \n",
       "3                           Azerbaijan   \n",
       "4                              Bahrain   \n",
       "5                           Bangladesh   \n",
       "6                              Belarus   \n",
       "7                               Bhutan   \n",
       "8               Bosnia and Herzegovina   \n",
       "9                               Brunei   \n",
       "10                            Bulgaria   \n",
       "11                            Cambodia   \n",
       "12                               China   \n",
       "13                             Croatia   \n",
       "14                      Czech Republic   \n",
       "15                          East Timor   \n",
       "16                               Egypt   \n",
       "17                             Estonia   \n",
       "18                    France (Not BRI)   \n",
       "19                             Georgia   \n",
       "20                   Germany (not BRI)   \n",
       "21                             Hungary   \n",
       "22                               India   \n",
       "23                           Indonesia   \n",
       "24                                Iran   \n",
       "25                                Iraq   \n",
       "26                              Israel   \n",
       "27                              Jordan   \n",
       "28                          Kazakhstan   \n",
       "29                              Kuwait   \n",
       "..                                 ...   \n",
       "38                             Moldova   \n",
       "39                            Mongolia   \n",
       "40                          Montenegro   \n",
       "41                             Myanmar   \n",
       "42                               Nepal   \n",
       "43                                Oman   \n",
       "44                            Pakistan   \n",
       "45                         Philippines   \n",
       "46                              Poland   \n",
       "47                               Qatar   \n",
       "48                             Romania   \n",
       "49                              Russia   \n",
       "50                        Saudi Arabia   \n",
       "51                              Serbia   \n",
       "52                           Singapore   \n",
       "53                            Slovakia   \n",
       "54                            Slovenia   \n",
       "55                           Sri Lanka   \n",
       "56                               Syria   \n",
       "57                          Tajikistan   \n",
       "58                           Thailiand   \n",
       "59            The United Arab Emirates   \n",
       "60                              Turkey   \n",
       "61                        Turkmenistan   \n",
       "62            United Kingdom (Not BRI)   \n",
       "63  United States of America (Not BRI)   \n",
       "64                             Ukraine   \n",
       "65                          Uzbekistan   \n",
       "66                             Vietnam   \n",
       "67                               Yemen   \n",
       "\n",
       "    IMF WB\\nCustoms and other import duties (% of tax revenue) 2016  \n",
       "0                                           32.551072                \n",
       "1                                            2.216459                \n",
       "2                                            6.275395                \n",
       "3                                            4.550383                \n",
       "4                                           87.914439                \n",
       "5                                           28.923008                \n",
       "6                                            8.200619                \n",
       "7                                            3.052294                \n",
       "8                                            0.066132                \n",
       "9                                                 NaN                \n",
       "10                                           0.072798                \n",
       "11                                          15.785253                \n",
       "12                                           3.894341                \n",
       "13                                           0.670090                \n",
       "14                                           0.819567                \n",
       "15                                           5.741272                \n",
       "16                                           6.849002                \n",
       "17                                           0.039429                \n",
       "18                                          -0.021908                \n",
       "19                                           0.796325                \n",
       "20                                           0.021249                \n",
       "21                                          -0.000145                \n",
       "22                                                NaN                \n",
       "23                                           2.463390                \n",
       "24                                          20.696450                \n",
       "25                                          14.105211                \n",
       "26                                           1.153110                \n",
       "27                                           8.533450                \n",
       "28                                           5.299908                \n",
       "29                                          66.806723                \n",
       "..                                                ...                \n",
       "38                                           3.423233                \n",
       "39                                          12.087573                \n",
       "40                                                NaN                \n",
       "41                                           9.003222                \n",
       "42                                          17.770038                \n",
       "43                                          28.368146                \n",
       "44                                          18.780936                \n",
       "45                                          20.357608                \n",
       "46                                           0.128546                \n",
       "47                                           6.021326                \n",
       "48                                           0.003434                \n",
       "49                                           6.217626                \n",
       "50                                                NaN                \n",
       "51                                           5.062219                \n",
       "52                                           0.071508                \n",
       "53                                           0.000290                \n",
       "54                                           0.808280                \n",
       "55                                          22.054891                \n",
       "56                                          10.230756                \n",
       "57                                                NaN                \n",
       "58                                           3.952757                \n",
       "59                                           0.381747                \n",
       "60                                           2.418238                \n",
       "61                                                NaN                \n",
       "62                                           0.047747                \n",
       "63                                           1.656294                \n",
       "64                                           3.997681                \n",
       "65                                           5.186860                \n",
       "66                                          18.427549                \n",
       "67                                                NaN                \n",
       "\n",
       "[68 rows x 2 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i,v in df['Country (according to CN Gov):'].iteritems():\n",
    "    country_name = v.split('(')[0].strip()\n",
    "    country_code = countries[country_name]\n",
    "    value = get_indicator(country_code,'GC.TAX.IMPT.ZS')\n",
    "    if value is not None:\n",
    "        df.at[i,'IMF WB\\nCustoms and other import duties (% of tax revenue) 2016']=value\n",
    "    print(country_name,'done...')\n",
    "    time.sleep(0.5+random.random())\n",
    "df[['Country (according to CN Gov):','IMF WB\\nCustoms and other import duties (% of tax revenue) 2016']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Country (according to CN Gov):', 'Date of research inquiry',\n",
       "       'HF Index of Economic Freedom (Scale: 1-100)',\n",
       "       'Heritage Foundation Index of Economic Freedom (Global Ranking)',\n",
       "       'Bertelsmann Transformation index (BTI)',\n",
       "       'Bertelsmann Transformation index (BTI) - Ranking',\n",
       "       'IMF WB\\nCustoms and other import duties (% of tax revenue) 2016',\n",
       "       'WB IMF Non-performing loans to total gross loans ratio (%)',\n",
       "       'Moody's Socvereign Ratings List', 'S&P Sovereign Ratings List',\n",
       "       'Fitch Sovereign Ratings List',\n",
       "       'UIC Rail freight (mn ton x km travelled)',\n",
       "       'ICAO air freight (mn ton x km travelled)',\n",
       "       'WB Household final consumption expenditure, PPP bn USD',\n",
       "       'WB UNESCO R&D Expenditure % of GDP',\n",
       "       'WB UNESCO Researchers p. mn inhabitants',\n",
       "       'TI Corruption Perception Index',\n",
       "       'TI Corruption Perception Index - Ranking', 'BRI GDP', 'BRI GDP p.c.',\n",
       "       'BRI GDP growth rate', 'BRI Y.o.Y. GDP growth rate p.c.',\n",
       "       'BRI Agriculture value added per sector ',\n",
       "       'BRI Industry value added per sector ',\n",
       "       'BRI Services value added per sector ',\n",
       "       'Cumulative value added (numbers should reflect 100%)',\n",
       "       'Exp./Imp. volume USD', 'WITS Time to Import ', 'WITS Time to Export ',\n",
       "       'IMF Financial Soundness Indicators', 'WB Central Government Debt',\n",
       "       'BRI Internet penetration rate (%)', 'BRI Population density (/km2)',\n",
       "       'BRI Percentage of Urban Population in Total Population',\n",
       "       'WB Cost of Starting a Business',\n",
       "       'WB Ease of Doing Business Index (1 = most business-friendly regulations)',\n",
       "       'WB Logistics Performance Index (LPI) (range: 1-5) ',\n",
       "       'IFDI Net Inflows (% of GDP)',\n",
       "       'ED National Electric Power Consumption TwH',\n",
       "       'WHO Current Health Expenditure p.c., PPP USD',\n",
       "       'WB Research Expenditure % of GDP', 'WIPO Trademark applications',\n",
       "       'WIPO Patent Applications'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Fill every indicator"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Afghanistan done...\n",
      "Albania done...\n",
      "Armenia done...\n",
      "Azerbaijan done...\n",
      "Bahrain done...\n",
      "Bangladesh done...\n",
      "Belarus done...\n",
      "Bhutan done...\n",
      "Bosnia and Herzegovina done...\n",
      "Brunei done...\n",
      "Bulgaria done...\n",
      "Cambodia done...\n",
      "China done...\n",
      "Croatia done...\n",
      "Czech Republic done...\n",
      "East Timor done...\n",
      "Egypt done...\n",
      "Estonia done...\n",
      "France done...\n",
      "Georgia done...\n",
      "Germany done...\n",
      "Hungary done...\n",
      "India done...\n",
      "Indonesia done...\n",
      "Iran done...\n",
      "Iraq done...\n",
      "Israel done...\n",
      "Jordan done...\n",
      "Kazakhstan done...\n",
      "Kuwait done...\n",
      "Kyrgyzstan done...\n",
      "Laos done...\n",
      "Latvia done...\n",
      "Lebanon done...\n",
      "Lithuania done...\n",
      "Macedonia done...\n",
      "Malaysia done...\n",
      "Maldives done...\n",
      "Moldova done...\n",
      "Mongolia done...\n",
      "Montenegro done...\n",
      "Myanmar done...\n",
      "Nepal done...\n",
      "Oman done...\n",
      "Pakistan done...\n",
      "Philippines done...\n",
      "Poland done...\n",
      "Qatar done...\n",
      "Romania done...\n",
      "Russia done...\n",
      "Saudi Arabia done...\n",
      "Serbia done...\n",
      "Singapore done...\n",
      "Slovakia done...\n",
      "Slovenia done...\n",
      "Sri Lanka done...\n",
      "Syria done...\n",
      "Tajikistan done...\n",
      "Thailiand done...\n",
      "The United Arab Emirates done...\n",
      "Turkey done...\n",
      "Turkmenistan done...\n",
      "United Kingdom done...\n",
      "United States of America done...\n",
      "Ukraine done...\n",
      "Uzbekistan done...\n",
      "Vietnam done...\n",
      "Yemen done...\n"
     ]
    },
    {
     "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>Country (according to CN Gov):</th>\n",
       "      <th>Date of research inquiry</th>\n",
       "      <th>HF Index of Economic Freedom (Scale: 1-100)</th>\n",
       "      <th>Heritage Foundation Index of Economic Freedom (Global Ranking)</th>\n",
       "      <th>Bertelsmann Transformation index (BTI)</th>\n",
       "      <th>Bertelsmann Transformation index (BTI) - Ranking</th>\n",
       "      <th>IMF WB\n",
       "Customs and other import duties (% of tax revenue) 2016</th>\n",
       "      <th>WB IMF Non-performing loans to total gross loans ratio (%)</th>\n",
       "      <th>Moody's Socvereign Ratings List</th>\n",
       "      <th>S&amp;P Sovereign Ratings List</th>\n",
       "      <th>...</th>\n",
       "      <th>BRI Percentage of Urban Population in Total Population</th>\n",
       "      <th>WB Cost of Starting a Business</th>\n",
       "      <th>WB Ease of Doing Business Index (1 = most business-friendly regulations)</th>\n",
       "      <th>WB Logistics Performance Index (LPI) (range: 1-5)</th>\n",
       "      <th>IFDI Net Inflows (% of GDP)</th>\n",
       "      <th>ED National Electric Power Consumption TwH</th>\n",
       "      <th>WHO Current Health Expenditure p.c., PPP USD</th>\n",
       "      <th>WB Research Expenditure % of GDP</th>\n",
       "      <th>WIPO Trademark applications</th>\n",
       "      <th>WIPO Patent Applications</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.551072</td>\n",
       "      <td>12.201830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.273179</td>\n",
       "      <td>NaN</td>\n",
       "      <td>183.927858</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.216459</td>\n",
       "      <td>13.232533</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.839316</td>\n",
       "      <td>NaN</td>\n",
       "      <td>773.678292</td>\n",
       "      <td>0.15412</td>\n",
       "      <td>918.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Armenia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.275395</td>\n",
       "      <td>5.432318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.164932</td>\n",
       "      <td>NaN</td>\n",
       "      <td>883.220652</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2356.0</td>\n",
       "      <td>125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.550383</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.037159</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1191.289459</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2817.0</td>\n",
       "      <td>144.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bahrain</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.914439</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.469627</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2453.155914</td>\n",
       "      <td>0.10116</td>\n",
       "      <td>371.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.923008</td>\n",
       "      <td>8.397908</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.861500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88.035356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8580.0</td>\n",
       "      <td>77.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Belarus</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.200619</td>\n",
       "      <td>12.852194</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.343707</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1084.619757</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4652.0</td>\n",
       "      <td>455.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bhutan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.052294</td>\n",
       "      <td>8.417308</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.654814</td>\n",
       "      <td>NaN</td>\n",
       "      <td>287.128628</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.066132</td>\n",
       "      <td>10.046275</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.562925</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1101.792914</td>\n",
       "      <td>0.21598</td>\n",
       "      <td>797.0</td>\n",
       "      <td>60.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Brunei</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.538399</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.858213</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2083.430502</td>\n",
       "      <td>0.03701</td>\n",
       "      <td>85.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.072798</td>\n",
       "      <td>10.434453</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.747996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1491.868089</td>\n",
       "      <td>0.78006</td>\n",
       "      <td>14243.0</td>\n",
       "      <td>230.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Cambodia</td>\n",
       "      <td>2018-08-16</td>\n",
       "      <td>58.7</td>\n",
       "      <td>101.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>15.785253</td>\n",
       "      <td>2.072477</td>\n",
       "      <td>B2</td>\n",
       "      <td>B+</td>\n",
       "      <td>...</td>\n",
       "      <td>0.20723</td>\n",
       "      <td>51.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.58</td>\n",
       "      <td>12.582625</td>\n",
       "      <td>NaN</td>\n",
       "      <td>209.616863</td>\n",
       "      <td>0.11823</td>\n",
       "      <td>1182.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>China</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.894341</td>\n",
       "      <td>1.744355</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.374634</td>\n",
       "      <td>NaN</td>\n",
       "      <td>762.243779</td>\n",
       "      <td>2.10673</td>\n",
       "      <td>3526953.0</td>\n",
       "      <td>1204981.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.670090</td>\n",
       "      <td>11.201542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.695610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1656.426156</td>\n",
       "      <td>0.85621</td>\n",
       "      <td>4334.0</td>\n",
       "      <td>175.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.819567</td>\n",
       "      <td>3.741720</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.269351</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2469.851757</td>\n",
       "      <td>1.67830</td>\n",
       "      <td>19301.0</td>\n",
       "      <td>792.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>East Timor</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.741272</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.227303</td>\n",
       "      <td>NaN</td>\n",
       "      <td>141.275828</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Egypt</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.849002</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.140471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>495.165081</td>\n",
       "      <td>0.70876</td>\n",
       "      <td>12750.0</td>\n",
       "      <td>918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Estonia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.039429</td>\n",
       "      <td>0.698391</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.999697</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1886.814387</td>\n",
       "      <td>1.28129</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>France (Not BRI)</td>\n",
       "      <td>NaT</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.021908</td>\n",
       "      <td>3.080415</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.832937</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4542.307106</td>\n",
       "      <td>2.24776</td>\n",
       "      <td>258090.0</td>\n",
       "      <td>14206.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.796325</td>\n",
       "      <td>2.778800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.133758</td>\n",
       "      <td>NaN</td>\n",
       "      <td>717.716242</td>\n",
       "      <td>0.30104</td>\n",
       "      <td>2217.0</td>\n",
       "      <td>96.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Germany (not BRI)</td>\n",
       "      <td>NaT</td>\n",
       "      <td>34.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.021249</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.20</td>\n",
       "      <td>2.120590</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5356.811177</td>\n",
       "      <td>2.93949</td>\n",
       "      <td>190216.0</td>\n",
       "      <td>48480.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.000145</td>\n",
       "      <td>4.165920</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9.690974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1912.069053</td>\n",
       "      <td>1.20606</td>\n",
       "      <td>9318.0</td>\n",
       "      <td>616.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>India</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.463390</td>\n",
       "      <td>2.557005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.113612</td>\n",
       "      <td>NaN</td>\n",
       "      <td>369.286440</td>\n",
       "      <td>0.08470</td>\n",
       "      <td>48756.0</td>\n",
       "      <td>1101.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Iran</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.696450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.105476</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1261.730503</td>\n",
       "      <td>0.25267</td>\n",
       "      <td>177538.0</td>\n",
       "      <td>14930.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Iraq</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.105211</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.620212</td>\n",
       "      <td>NaN</td>\n",
       "      <td>481.039845</td>\n",
       "      <td>0.03631</td>\n",
       "      <td>NaN</td>\n",
       "      <td>335.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Israel</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.153110</td>\n",
       "      <td>1.290660</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.178530</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2819.111414</td>\n",
       "      <td>4.25121</td>\n",
       "      <td>3463.0</td>\n",
       "      <td>1300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Jordan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.533450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.065645</td>\n",
       "      <td>NaN</td>\n",
       "      <td>568.122532</td>\n",
       "      <td>0.33201</td>\n",
       "      <td>3013.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Kazakhstan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.299908</td>\n",
       "      <td>9.309768</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.857327</td>\n",
       "      <td>NaN</td>\n",
       "      <td>903.324091</td>\n",
       "      <td>0.14179</td>\n",
       "      <td>8495.0</td>\n",
       "      <td>993.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Kuwait</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66.806723</td>\n",
       "      <td>1.949390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.094078</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2977.514144</td>\n",
       "      <td>0.42705</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Moldova</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.423233</td>\n",
       "      <td>18.377209</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.978718</td>\n",
       "      <td>NaN</td>\n",
       "      <td>515.323073</td>\n",
       "      <td>0.33114</td>\n",
       "      <td>3049.0</td>\n",
       "      <td>91.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Mongolia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.087573</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.069774</td>\n",
       "      <td>NaN</td>\n",
       "      <td>469.563584</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7629.0</td>\n",
       "      <td>112.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Montenegro</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.565272</td>\n",
       "      <td>NaN</td>\n",
       "      <td>957.014821</td>\n",
       "      <td>0.37400</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Myanmar</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.003222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.985207</td>\n",
       "      <td>NaN</td>\n",
       "      <td>267.228033</td>\n",
       "      <td>0.16216</td>\n",
       "      <td>4422.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Nepal</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.770038</td>\n",
       "      <td>1.699086</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.788838</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.590369</td>\n",
       "      <td>0.30220</td>\n",
       "      <td>3215.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Oman</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.368146</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.017028</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1635.870769</td>\n",
       "      <td>0.24647</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.780936</td>\n",
       "      <td>8.429489</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.923097</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.441461</td>\n",
       "      <td>0.24605</td>\n",
       "      <td>27017.0</td>\n",
       "      <td>204.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.357608</td>\n",
       "      <td>1.579311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.207124</td>\n",
       "      <td>NaN</td>\n",
       "      <td>322.778000</td>\n",
       "      <td>0.13793</td>\n",
       "      <td>22357.0</td>\n",
       "      <td>327.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Poland</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.128546</td>\n",
       "      <td>3.941019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.027292</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1704.195989</td>\n",
       "      <td>0.96538</td>\n",
       "      <td>39420.0</td>\n",
       "      <td>4261.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Qatar</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.021326</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.590665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3900.286232</td>\n",
       "      <td>0.50969</td>\n",
       "      <td>1405.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Romania</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.003434</td>\n",
       "      <td>6.411894</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.809515</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1090.416516</td>\n",
       "      <td>0.48264</td>\n",
       "      <td>20575.0</td>\n",
       "      <td>1005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Russia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.217626</td>\n",
       "      <td>10.001412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.810270</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1414.028282</td>\n",
       "      <td>1.09690</td>\n",
       "      <td>193213.0</td>\n",
       "      <td>26795.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.613649</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.206964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3121.341632</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7423.0</td>\n",
       "      <td>1070.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Serbia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.062219</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.948354</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1323.690595</td>\n",
       "      <td>0.89059</td>\n",
       "      <td>3431.0</td>\n",
       "      <td>192.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Singapore</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.071508</td>\n",
       "      <td>1.400201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.645574</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3681.295940</td>\n",
       "      <td>2.18377</td>\n",
       "      <td>9721.0</td>\n",
       "      <td>1601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000290</td>\n",
       "      <td>3.701005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.183240</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2061.950585</td>\n",
       "      <td>0.78965</td>\n",
       "      <td>9436.0</td>\n",
       "      <td>220.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.808280</td>\n",
       "      <td>3.203634</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.218344</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2733.762624</td>\n",
       "      <td>2.00202</td>\n",
       "      <td>8.0</td>\n",
       "      <td>470.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.054891</td>\n",
       "      <td>2.498433</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.573877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>353.129150</td>\n",
       "      <td>0.09989</td>\n",
       "      <td>6893.0</td>\n",
       "      <td>280.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Syria</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.230756</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.073775</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159.716094</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>198.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.389390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.501005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>192.696191</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Thailiand</td>\n",
       "      <td>NaT</td>\n",
       "      <td>62.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.952757</td>\n",
       "      <td>3.070802</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.767068</td>\n",
       "      <td>NaN</td>\n",
       "      <td>610.170004</td>\n",
       "      <td>0.61927</td>\n",
       "      <td>35720.0</td>\n",
       "      <td>1098.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>The United Arab Emirates</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.381747</td>\n",
       "      <td>6.435573</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.706455</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2425.795649</td>\n",
       "      <td>0.98660</td>\n",
       "      <td>5199.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Turkey</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.418238</td>\n",
       "      <td>2.842714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.278376</td>\n",
       "      <td>NaN</td>\n",
       "      <td>995.966037</td>\n",
       "      <td>0.88150</td>\n",
       "      <td>193824.0</td>\n",
       "      <td>6230.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Turkmenistan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.099995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1003.781827</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>United Kingdom (Not BRI)</td>\n",
       "      <td>NaT</td>\n",
       "      <td>55.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.047747</td>\n",
       "      <td>0.734660</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.466617</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4144.600790</td>\n",
       "      <td>1.69036</td>\n",
       "      <td>114722.0</td>\n",
       "      <td>13876.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>United States of America (Not BRI)</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.656294</td>\n",
       "      <td>1.126824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.829897</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9535.945335</td>\n",
       "      <td>2.74418</td>\n",
       "      <td>388504.0</td>\n",
       "      <td>295327.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.997681</td>\n",
       "      <td>54.541296</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.520637</td>\n",
       "      <td>NaN</td>\n",
       "      <td>469.428377</td>\n",
       "      <td>0.48384</td>\n",
       "      <td>45880.0</td>\n",
       "      <td>2233.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.186860</td>\n",
       "      <td>0.436415</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.192777</td>\n",
       "      <td>NaN</td>\n",
       "      <td>382.821710</td>\n",
       "      <td>0.22089</td>\n",
       "      <td>6457.0</td>\n",
       "      <td>353.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Vietnam</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.427549</td>\n",
       "      <td>1.824981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.300835</td>\n",
       "      <td>NaN</td>\n",
       "      <td>334.319988</td>\n",
       "      <td>0.44113</td>\n",
       "      <td>54965.0</td>\n",
       "      <td>560.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.863032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>144.499884</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2561.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Country (according to CN Gov): Date of research inquiry  \\\n",
       "0                          Afghanistan                      NaT   \n",
       "1                              Albania                      NaT   \n",
       "2                              Armenia                      NaT   \n",
       "3                           Azerbaijan                      NaT   \n",
       "4                              Bahrain                      NaT   \n",
       "5                           Bangladesh                      NaT   \n",
       "6                              Belarus                      NaT   \n",
       "7                               Bhutan                      NaT   \n",
       "8               Bosnia and Herzegovina                      NaT   \n",
       "9                               Brunei                      NaT   \n",
       "10                            Bulgaria                      NaT   \n",
       "11                            Cambodia               2018-08-16   \n",
       "12                               China                      NaT   \n",
       "13                             Croatia                      NaT   \n",
       "14                      Czech Republic                      NaT   \n",
       "15                          East Timor                      NaT   \n",
       "16                               Egypt                      NaT   \n",
       "17                             Estonia                      NaT   \n",
       "18                    France (Not BRI)                      NaT   \n",
       "19                             Georgia                      NaT   \n",
       "20                   Germany (not BRI)                      NaT   \n",
       "21                             Hungary                      NaT   \n",
       "22                               India                      NaT   \n",
       "23                           Indonesia                      NaT   \n",
       "24                                Iran                      NaT   \n",
       "25                                Iraq                      NaT   \n",
       "26                              Israel                      NaT   \n",
       "27                              Jordan                      NaT   \n",
       "28                          Kazakhstan                      NaT   \n",
       "29                              Kuwait                      NaT   \n",
       "..                                 ...                      ...   \n",
       "38                             Moldova                      NaT   \n",
       "39                            Mongolia                      NaT   \n",
       "40                          Montenegro                      NaT   \n",
       "41                             Myanmar                      NaT   \n",
       "42                               Nepal                      NaT   \n",
       "43                                Oman                      NaT   \n",
       "44                            Pakistan                      NaT   \n",
       "45                         Philippines                      NaT   \n",
       "46                              Poland                      NaT   \n",
       "47                               Qatar                      NaT   \n",
       "48                             Romania                      NaT   \n",
       "49                              Russia                      NaT   \n",
       "50                        Saudi Arabia                      NaT   \n",
       "51                              Serbia                      NaT   \n",
       "52                           Singapore                      NaT   \n",
       "53                            Slovakia                      NaT   \n",
       "54                            Slovenia                      NaT   \n",
       "55                           Sri Lanka                      NaT   \n",
       "56                               Syria                      NaT   \n",
       "57                          Tajikistan                      NaT   \n",
       "58                           Thailiand                      NaT   \n",
       "59            The United Arab Emirates                      NaT   \n",
       "60                              Turkey                      NaT   \n",
       "61                        Turkmenistan                      NaT   \n",
       "62            United Kingdom (Not BRI)                      NaT   \n",
       "63  United States of America (Not BRI)                      NaT   \n",
       "64                             Ukraine                      NaT   \n",
       "65                          Uzbekistan                      NaT   \n",
       "66                             Vietnam                      NaT   \n",
       "67                               Yemen                      NaT   \n",
       "\n",
       "    HF Index of Economic Freedom (Scale: 1-100)  \\\n",
       "0                                           NaN   \n",
       "1                                           NaN   \n",
       "2                                           NaN   \n",
       "3                                           NaN   \n",
       "4                                           NaN   \n",
       "5                                           NaN   \n",
       "6                                           NaN   \n",
       "7                                           NaN   \n",
       "8                                           NaN   \n",
       "9                                           NaN   \n",
       "10                                          NaN   \n",
       "11                                         58.7   \n",
       "12                                          NaN   \n",
       "13                                          NaN   \n",
       "14                                          NaN   \n",
       "15                                          NaN   \n",
       "16                                          NaN   \n",
       "17                                          NaN   \n",
       "18                                         37.0   \n",
       "19                                          NaN   \n",
       "20                                         34.0   \n",
       "21                                          NaN   \n",
       "22                                          NaN   \n",
       "23                                          NaN   \n",
       "24                                          NaN   \n",
       "25                                          NaN   \n",
       "26                                          NaN   \n",
       "27                                          NaN   \n",
       "28                                          NaN   \n",
       "29                                          NaN   \n",
       "..                                          ...   \n",
       "38                                          NaN   \n",
       "39                                          NaN   \n",
       "40                                          NaN   \n",
       "41                                          NaN   \n",
       "42                                          NaN   \n",
       "43                                          NaN   \n",
       "44                                          NaN   \n",
       "45                                          NaN   \n",
       "46                                          NaN   \n",
       "47                                          NaN   \n",
       "48                                          NaN   \n",
       "49                                          NaN   \n",
       "50                                          NaN   \n",
       "51                                          NaN   \n",
       "52                                          NaN   \n",
       "53                                          NaN   \n",
       "54                                          NaN   \n",
       "55                                          NaN   \n",
       "56                                          NaN   \n",
       "57                                          NaN   \n",
       "58                                         62.0   \n",
       "59                                          NaN   \n",
       "60                                          NaN   \n",
       "61                                          NaN   \n",
       "62                                         55.0   \n",
       "63                                          NaN   \n",
       "64                                          NaN   \n",
       "65                                          NaN   \n",
       "66                                          NaN   \n",
       "67                                          NaN   \n",
       "\n",
       "    Heritage Foundation Index of Economic Freedom (Global Ranking)  \\\n",
       "0                                                 NaN                \n",
       "1                                                 NaN                \n",
       "2                                                 NaN                \n",
       "3                                                 NaN                \n",
       "4                                                 NaN                \n",
       "5                                                 NaN                \n",
       "6                                                 NaN                \n",
       "7                                                 NaN                \n",
       "8                                                 NaN                \n",
       "9                                                 NaN                \n",
       "10                                                NaN                \n",
       "11                                              101.0                \n",
       "12                                                NaN                \n",
       "13                                                NaN                \n",
       "14                                                NaN                \n",
       "15                                                NaN                \n",
       "16                                                NaN                \n",
       "17                                                NaN                \n",
       "18                                                NaN                \n",
       "19                                                NaN                \n",
       "20                                                NaN                \n",
       "21                                                NaN                \n",
       "22                                                NaN                \n",
       "23                                                NaN                \n",
       "24                                                NaN                \n",
       "25                                                NaN                \n",
       "26                                                NaN                \n",
       "27                                                NaN                \n",
       "28                                                NaN                \n",
       "29                                                NaN                \n",
       "..                                                ...                \n",
       "38                                                NaN                \n",
       "39                                                NaN                \n",
       "40                                                NaN                \n",
       "41                                                NaN                \n",
       "42                                                NaN                \n",
       "43                                                NaN                \n",
       "44                                                NaN                \n",
       "45                                                NaN                \n",
       "46                                                NaN                \n",
       "47                                                NaN                \n",
       "48                                                NaN                \n",
       "49                                                NaN                \n",
       "50                                                NaN                \n",
       "51                                                NaN                \n",
       "52                                                NaN                \n",
       "53                                                NaN                \n",
       "54                                                NaN                \n",
       "55                                                NaN                \n",
       "56                                                NaN                \n",
       "57                                                NaN                \n",
       "58                                                NaN                \n",
       "59                                                NaN                \n",
       "60                                                NaN                \n",
       "61                                                NaN                \n",
       "62                                                NaN                \n",
       "63                                                NaN                \n",
       "64                                                NaN                \n",
       "65                                                NaN                \n",
       "66                                                NaN                \n",
       "67                                                NaN                \n",
       "\n",
       "    Bertelsmann Transformation index (BTI)  \\\n",
       "0                                      NaN   \n",
       "1                                      NaN   \n",
       "2                                      NaN   \n",
       "3                                      NaN   \n",
       "4                                      NaN   \n",
       "5                                      NaN   \n",
       "6                                      NaN   \n",
       "7                                      NaN   \n",
       "8                                      NaN   \n",
       "9                                      NaN   \n",
       "10                                     NaN   \n",
       "11                                     4.0   \n",
       "12                                     NaN   \n",
       "13                                     NaN   \n",
       "14                                     NaN   \n",
       "15                                     NaN   \n",
       "16                                     NaN   \n",
       "17                                     NaN   \n",
       "18                                     NaN   \n",
       "19                                     NaN   \n",
       "20                                     NaN   \n",
       "21                                     NaN   \n",
       "22                                     NaN   \n",
       "23                                     NaN   \n",
       "24                                     NaN   \n",
       "25                                     NaN   \n",
       "26                                     NaN   \n",
       "27                                     NaN   \n",
       "28                                     NaN   \n",
       "29                                     NaN   \n",
       "..                                     ...   \n",
       "38                                     NaN   \n",
       "39                                     NaN   \n",
       "40                                     NaN   \n",
       "41                                     NaN   \n",
       "42                                     NaN   \n",
       "43                                     NaN   \n",
       "44                                     NaN   \n",
       "45                                     NaN   \n",
       "46                                     NaN   \n",
       "47                                     NaN   \n",
       "48                                     NaN   \n",
       "49                                     NaN   \n",
       "50                                     NaN   \n",
       "51                                     NaN   \n",
       "52                                     NaN   \n",
       "53                                     NaN   \n",
       "54                                     NaN   \n",
       "55                                     NaN   \n",
       "56                                     NaN   \n",
       "57                                     NaN   \n",
       "58                                     NaN   \n",
       "59                                     NaN   \n",
       "60                                     NaN   \n",
       "61                                     NaN   \n",
       "62                                     NaN   \n",
       "63                                     NaN   \n",
       "64                                     NaN   \n",
       "65                                     NaN   \n",
       "66                                     NaN   \n",
       "67                                     NaN   \n",
       "\n",
       "    Bertelsmann Transformation index (BTI) - Ranking  \\\n",
       "0                                                NaN   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                                NaN   \n",
       "5                                                NaN   \n",
       "6                                                NaN   \n",
       "7                                                NaN   \n",
       "8                                                NaN   \n",
       "9                                                NaN   \n",
       "10                                               NaN   \n",
       "11                                             103.0   \n",
       "12                                               NaN   \n",
       "13                                               NaN   \n",
       "14                                               NaN   \n",
       "15                                               NaN   \n",
       "16                                               NaN   \n",
       "17                                               NaN   \n",
       "18                                               NaN   \n",
       "19                                               NaN   \n",
       "20                                               NaN   \n",
       "21                                               NaN   \n",
       "22                                               NaN   \n",
       "23                                               NaN   \n",
       "24                                               NaN   \n",
       "25                                               NaN   \n",
       "26                                               NaN   \n",
       "27                                               NaN   \n",
       "28                                               NaN   \n",
       "29                                               NaN   \n",
       "..                                               ...   \n",
       "38                                               NaN   \n",
       "39                                               NaN   \n",
       "40                                               NaN   \n",
       "41                                               NaN   \n",
       "42                                               NaN   \n",
       "43                                               NaN   \n",
       "44                                               NaN   \n",
       "45                                               NaN   \n",
       "46                                               NaN   \n",
       "47                                               NaN   \n",
       "48                                               NaN   \n",
       "49                                               NaN   \n",
       "50                                               NaN   \n",
       "51                                               NaN   \n",
       "52                                               NaN   \n",
       "53                                               NaN   \n",
       "54                                               NaN   \n",
       "55                                               NaN   \n",
       "56                                               NaN   \n",
       "57                                               NaN   \n",
       "58                                               NaN   \n",
       "59                                               NaN   \n",
       "60                                               NaN   \n",
       "61                                               NaN   \n",
       "62                                               NaN   \n",
       "63                                               NaN   \n",
       "64                                               NaN   \n",
       "65                                               NaN   \n",
       "66                                               NaN   \n",
       "67                                               NaN   \n",
       "\n",
       "    IMF WB\\nCustoms and other import duties (% of tax revenue) 2016  \\\n",
       "0                                           32.551072                 \n",
       "1                                            2.216459                 \n",
       "2                                            6.275395                 \n",
       "3                                            4.550383                 \n",
       "4                                           87.914439                 \n",
       "5                                           28.923008                 \n",
       "6                                            8.200619                 \n",
       "7                                            3.052294                 \n",
       "8                                            0.066132                 \n",
       "9                                                 NaN                 \n",
       "10                                           0.072798                 \n",
       "11                                          15.785253                 \n",
       "12                                           3.894341                 \n",
       "13                                           0.670090                 \n",
       "14                                           0.819567                 \n",
       "15                                           5.741272                 \n",
       "16                                           6.849002                 \n",
       "17                                           0.039429                 \n",
       "18                                          -0.021908                 \n",
       "19                                           0.796325                 \n",
       "20                                           0.021249                 \n",
       "21                                          -0.000145                 \n",
       "22                                                NaN                 \n",
       "23                                           2.463390                 \n",
       "24                                          20.696450                 \n",
       "25                                          14.105211                 \n",
       "26                                           1.153110                 \n",
       "27                                           8.533450                 \n",
       "28                                           5.299908                 \n",
       "29                                          66.806723                 \n",
       "..                                                ...                 \n",
       "38                                           3.423233                 \n",
       "39                                          12.087573                 \n",
       "40                                                NaN                 \n",
       "41                                           9.003222                 \n",
       "42                                          17.770038                 \n",
       "43                                          28.368146                 \n",
       "44                                          18.780936                 \n",
       "45                                          20.357608                 \n",
       "46                                           0.128546                 \n",
       "47                                           6.021326                 \n",
       "48                                           0.003434                 \n",
       "49                                           6.217626                 \n",
       "50                                                NaN                 \n",
       "51                                           5.062219                 \n",
       "52                                           0.071508                 \n",
       "53                                           0.000290                 \n",
       "54                                           0.808280                 \n",
       "55                                          22.054891                 \n",
       "56                                          10.230756                 \n",
       "57                                                NaN                 \n",
       "58                                           3.952757                 \n",
       "59                                           0.381747                 \n",
       "60                                           2.418238                 \n",
       "61                                                NaN                 \n",
       "62                                           0.047747                 \n",
       "63                                           1.656294                 \n",
       "64                                           3.997681                 \n",
       "65                                           5.186860                 \n",
       "66                                          18.427549                 \n",
       "67                                                NaN                 \n",
       "\n",
       "    WB IMF Non-performing loans to total gross loans ratio (%)  \\\n",
       "0                                           12.201830            \n",
       "1                                           13.232533            \n",
       "2                                            5.432318            \n",
       "3                                                 NaN            \n",
       "4                                                 NaN            \n",
       "5                                            8.397908            \n",
       "6                                           12.852194            \n",
       "7                                            8.417308            \n",
       "8                                           10.046275            \n",
       "9                                            3.538399            \n",
       "10                                          10.434453            \n",
       "11                                           2.072477            \n",
       "12                                           1.744355            \n",
       "13                                          11.201542            \n",
       "14                                           3.741720            \n",
       "15                                                NaN            \n",
       "16                                                NaN            \n",
       "17                                           0.698391            \n",
       "18                                           3.080415            \n",
       "19                                           2.778800            \n",
       "20                                           1.500000            \n",
       "21                                           4.165920            \n",
       "22                                                NaN            \n",
       "23                                           2.557005            \n",
       "24                                                NaN            \n",
       "25                                                NaN            \n",
       "26                                           1.290660            \n",
       "27                                                NaN            \n",
       "28                                           9.309768            \n",
       "29                                           1.949390            \n",
       "..                                                ...            \n",
       "38                                          18.377209            \n",
       "39                                                NaN            \n",
       "40                                                NaN            \n",
       "41                                                NaN            \n",
       "42                                           1.699086            \n",
       "43                                                NaN            \n",
       "44                                           8.429489            \n",
       "45                                           1.579311            \n",
       "46                                           3.941019            \n",
       "47                                                NaN            \n",
       "48                                           6.411894            \n",
       "49                                          10.001412            \n",
       "50                                           1.613649            \n",
       "51                                                NaN            \n",
       "52                                           1.400201            \n",
       "53                                           3.701005            \n",
       "54                                           3.203634            \n",
       "55                                           2.498433            \n",
       "56                                                NaN            \n",
       "57                                          20.389390            \n",
       "58                                           3.070802            \n",
       "59                                           6.435573            \n",
       "60                                           2.842714            \n",
       "61                                                NaN            \n",
       "62                                           0.734660            \n",
       "63                                           1.126824            \n",
       "64                                          54.541296            \n",
       "65                                           0.436415            \n",
       "66                                           1.824981            \n",
       "67                                                NaN            \n",
       "\n",
       "   Moody's Socvereign Ratings List S&P Sovereign Ratings List  \\\n",
       "0                              NaN                        NaN   \n",
       "1                              NaN                        NaN   \n",
       "2                              NaN                        NaN   \n",
       "3                              NaN                        NaN   \n",
       "4                              NaN                        NaN   \n",
       "5                              NaN                        NaN   \n",
       "6                              NaN                        NaN   \n",
       "7                              NaN                        NaN   \n",
       "8                              NaN                        NaN   \n",
       "9                              NaN                        NaN   \n",
       "10                             NaN                        NaN   \n",
       "11                              B2                         B+   \n",
       "12                             NaN                        NaN   \n",
       "13                             NaN                        NaN   \n",
       "14                             NaN                        NaN   \n",
       "15                             NaN                        NaN   \n",
       "16                             NaN                        NaN   \n",
       "17                             NaN                        NaN   \n",
       "18                             NaN                        NaN   \n",
       "19                             NaN                        NaN   \n",
       "20                             NaN                        NaN   \n",
       "21                             NaN                        NaN   \n",
       "22                             NaN                        NaN   \n",
       "23                             NaN                        NaN   \n",
       "24                             NaN                        NaN   \n",
       "25                             NaN                        NaN   \n",
       "26                             NaN                        NaN   \n",
       "27                             NaN                        NaN   \n",
       "28                             NaN                        NaN   \n",
       "29                             NaN                        NaN   \n",
       "..                             ...                        ...   \n",
       "38                             NaN                        NaN   \n",
       "39                             NaN                        NaN   \n",
       "40                             NaN                        NaN   \n",
       "41                             NaN                        NaN   \n",
       "42                             NaN                        NaN   \n",
       "43                             NaN                        NaN   \n",
       "44                             NaN                        NaN   \n",
       "45                             NaN                        NaN   \n",
       "46                             NaN                        NaN   \n",
       "47                             NaN                        NaN   \n",
       "48                             NaN                        NaN   \n",
       "49                             NaN                        NaN   \n",
       "50                             NaN                        NaN   \n",
       "51                             NaN                        NaN   \n",
       "52                             NaN                        NaN   \n",
       "53                             NaN                        NaN   \n",
       "54                             NaN                        NaN   \n",
       "55                             NaN                        NaN   \n",
       "56                             NaN                        NaN   \n",
       "57                             NaN                        NaN   \n",
       "58                             NaN                        NaN   \n",
       "59                             NaN                        NaN   \n",
       "60                             NaN                        NaN   \n",
       "61                             NaN                        NaN   \n",
       "62                             NaN                        NaN   \n",
       "63                             NaN                        NaN   \n",
       "64                             NaN                        NaN   \n",
       "65                             NaN                        NaN   \n",
       "66                             NaN                        NaN   \n",
       "67                             NaN                        NaN   \n",
       "\n",
       "              ...             \\\n",
       "0             ...              \n",
       "1             ...              \n",
       "2             ...              \n",
       "3             ...              \n",
       "4             ...              \n",
       "5             ...              \n",
       "6             ...              \n",
       "7             ...              \n",
       "8             ...              \n",
       "9             ...              \n",
       "10            ...              \n",
       "11            ...              \n",
       "12            ...              \n",
       "13            ...              \n",
       "14            ...              \n",
       "15            ...              \n",
       "16            ...              \n",
       "17            ...              \n",
       "18            ...              \n",
       "19            ...              \n",
       "20            ...              \n",
       "21            ...              \n",
       "22            ...              \n",
       "23            ...              \n",
       "24            ...              \n",
       "25            ...              \n",
       "26            ...              \n",
       "27            ...              \n",
       "28            ...              \n",
       "29            ...              \n",
       "..            ...              \n",
       "38            ...              \n",
       "39            ...              \n",
       "40            ...              \n",
       "41            ...              \n",
       "42            ...              \n",
       "43            ...              \n",
       "44            ...              \n",
       "45            ...              \n",
       "46            ...              \n",
       "47            ...              \n",
       "48            ...              \n",
       "49            ...              \n",
       "50            ...              \n",
       "51            ...              \n",
       "52            ...              \n",
       "53            ...              \n",
       "54            ...              \n",
       "55            ...              \n",
       "56            ...              \n",
       "57            ...              \n",
       "58            ...              \n",
       "59            ...              \n",
       "60            ...              \n",
       "61            ...              \n",
       "62            ...              \n",
       "63            ...              \n",
       "64            ...              \n",
       "65            ...              \n",
       "66            ...              \n",
       "67            ...              \n",
       "\n",
       "   BRI Percentage of Urban Population in Total Population  \\\n",
       "0                                                 NaN       \n",
       "1                                                 NaN       \n",
       "2                                                 NaN       \n",
       "3                                                 NaN       \n",
       "4                                                 NaN       \n",
       "5                                                 NaN       \n",
       "6                                                 NaN       \n",
       "7                                                 NaN       \n",
       "8                                                 NaN       \n",
       "9                                                 NaN       \n",
       "10                                                NaN       \n",
       "11                                            0.20723       \n",
       "12                                                NaN       \n",
       "13                                                NaN       \n",
       "14                                                NaN       \n",
       "15                                                NaN       \n",
       "16                                                NaN       \n",
       "17                                                NaN       \n",
       "18                                                NaN       \n",
       "19                                                NaN       \n",
       "20                                                NaN       \n",
       "21                                                NaN       \n",
       "22                                                NaN       \n",
       "23                                                NaN       \n",
       "24                                                NaN       \n",
       "25                                                NaN       \n",
       "26                                                NaN       \n",
       "27                                                NaN       \n",
       "28                                                NaN       \n",
       "29                                                NaN       \n",
       "..                                                ...       \n",
       "38                                                NaN       \n",
       "39                                                NaN       \n",
       "40                                                NaN       \n",
       "41                                                NaN       \n",
       "42                                                NaN       \n",
       "43                                                NaN       \n",
       "44                                                NaN       \n",
       "45                                                NaN       \n",
       "46                                                NaN       \n",
       "47                                                NaN       \n",
       "48                                                NaN       \n",
       "49                                                NaN       \n",
       "50                                                NaN       \n",
       "51                                                NaN       \n",
       "52                                                NaN       \n",
       "53                                                NaN       \n",
       "54                                                NaN       \n",
       "55                                                NaN       \n",
       "56                                                NaN       \n",
       "57                                                NaN       \n",
       "58                                                NaN       \n",
       "59                                                NaN       \n",
       "60                                                NaN       \n",
       "61                                                NaN       \n",
       "62                                                NaN       \n",
       "63                                                NaN       \n",
       "64                                                NaN       \n",
       "65                                                NaN       \n",
       "66                                                NaN       \n",
       "67                                                NaN       \n",
       "\n",
       "    WB Cost of Starting a Business  \\\n",
       "0                              NaN   \n",
       "1                              NaN   \n",
       "2                              NaN   \n",
       "3                              NaN   \n",
       "4                              NaN   \n",
       "5                              NaN   \n",
       "6                              NaN   \n",
       "7                              NaN   \n",
       "8                              NaN   \n",
       "9                              NaN   \n",
       "10                             NaN   \n",
       "11                            51.3   \n",
       "12                             NaN   \n",
       "13                             NaN   \n",
       "14                             NaN   \n",
       "15                             NaN   \n",
       "16                             NaN   \n",
       "17                             NaN   \n",
       "18                             NaN   \n",
       "19                             NaN   \n",
       "20                             NaN   \n",
       "21                             NaN   \n",
       "22                             NaN   \n",
       "23                             NaN   \n",
       "24                             NaN   \n",
       "25                             NaN   \n",
       "26                             NaN   \n",
       "27                             NaN   \n",
       "28                             NaN   \n",
       "29                             NaN   \n",
       "..                             ...   \n",
       "38                             NaN   \n",
       "39                             NaN   \n",
       "40                             NaN   \n",
       "41                             NaN   \n",
       "42                             NaN   \n",
       "43                             NaN   \n",
       "44                             NaN   \n",
       "45                             NaN   \n",
       "46                             NaN   \n",
       "47                             NaN   \n",
       "48                             NaN   \n",
       "49                             NaN   \n",
       "50                             NaN   \n",
       "51                             NaN   \n",
       "52                             NaN   \n",
       "53                             NaN   \n",
       "54                             NaN   \n",
       "55                             NaN   \n",
       "56                             NaN   \n",
       "57                             NaN   \n",
       "58                             NaN   \n",
       "59                             NaN   \n",
       "60                             NaN   \n",
       "61                             NaN   \n",
       "62                             NaN   \n",
       "63                             NaN   \n",
       "64                             NaN   \n",
       "65                             NaN   \n",
       "66                             NaN   \n",
       "67                             NaN   \n",
       "\n",
       "    WB Ease of Doing Business Index (1 = most business-friendly regulations)  \\\n",
       "0                                                 NaN                          \n",
       "1                                                 NaN                          \n",
       "2                                                 NaN                          \n",
       "3                                                 NaN                          \n",
       "4                                                 NaN                          \n",
       "5                                                 NaN                          \n",
       "6                                                 NaN                          \n",
       "7                                                 NaN                          \n",
       "8                                                 NaN                          \n",
       "9                                                 NaN                          \n",
       "10                                                NaN                          \n",
       "11                                                NaN                          \n",
       "12                                                NaN                          \n",
       "13                                                NaN                          \n",
       "14                                                NaN                          \n",
       "15                                                NaN                          \n",
       "16                                                NaN                          \n",
       "17                                                NaN                          \n",
       "18                                                NaN                          \n",
       "19                                                NaN                          \n",
       "20                                                NaN                          \n",
       "21                                                NaN                          \n",
       "22                                                NaN                          \n",
       "23                                                NaN                          \n",
       "24                                                NaN                          \n",
       "25                                                NaN                          \n",
       "26                                                NaN                          \n",
       "27                                                NaN                          \n",
       "28                                                NaN                          \n",
       "29                                                NaN                          \n",
       "..                                                ...                          \n",
       "38                                                NaN                          \n",
       "39                                                NaN                          \n",
       "40                                                NaN                          \n",
       "41                                                NaN                          \n",
       "42                                                NaN                          \n",
       "43                                                NaN                          \n",
       "44                                                NaN                          \n",
       "45                                                NaN                          \n",
       "46                                                NaN                          \n",
       "47                                                NaN                          \n",
       "48                                                NaN                          \n",
       "49                                                NaN                          \n",
       "50                                                NaN                          \n",
       "51                                                NaN                          \n",
       "52                                                NaN                          \n",
       "53                                                NaN                          \n",
       "54                                                NaN                          \n",
       "55                                                NaN                          \n",
       "56                                                NaN                          \n",
       "57                                                NaN                          \n",
       "58                                                NaN                          \n",
       "59                                                NaN                          \n",
       "60                                                NaN                          \n",
       "61                                                NaN                          \n",
       "62                                                NaN                          \n",
       "63                                                NaN                          \n",
       "64                                                NaN                          \n",
       "65                                                NaN                          \n",
       "66                                                NaN                          \n",
       "67                                                NaN                          \n",
       "\n",
       "    WB Logistics Performance Index (LPI) (range: 1-5)   \\\n",
       "0                                                 NaN    \n",
       "1                                                 NaN    \n",
       "2                                                 NaN    \n",
       "3                                                 NaN    \n",
       "4                                                 NaN    \n",
       "5                                                 NaN    \n",
       "6                                                 NaN    \n",
       "7                                                 NaN    \n",
       "8                                                 NaN    \n",
       "9                                                 NaN    \n",
       "10                                                NaN    \n",
       "11                                               2.58    \n",
       "12                                                NaN    \n",
       "13                                                NaN    \n",
       "14                                                NaN    \n",
       "15                                                NaN    \n",
       "16                                                NaN    \n",
       "17                                                NaN    \n",
       "18                                                NaN    \n",
       "19                                                NaN    \n",
       "20                                               4.20    \n",
       "21                                                NaN    \n",
       "22                                                NaN    \n",
       "23                                                NaN    \n",
       "24                                                NaN    \n",
       "25                                                NaN    \n",
       "26                                                NaN    \n",
       "27                                                NaN    \n",
       "28                                                NaN    \n",
       "29                                                NaN    \n",
       "..                                                ...    \n",
       "38                                                NaN    \n",
       "39                                                NaN    \n",
       "40                                                NaN    \n",
       "41                                                NaN    \n",
       "42                                                NaN    \n",
       "43                                                NaN    \n",
       "44                                                NaN    \n",
       "45                                                NaN    \n",
       "46                                                NaN    \n",
       "47                                                NaN    \n",
       "48                                                NaN    \n",
       "49                                                NaN    \n",
       "50                                                NaN    \n",
       "51                                                NaN    \n",
       "52                                                NaN    \n",
       "53                                                NaN    \n",
       "54                                                NaN    \n",
       "55                                                NaN    \n",
       "56                                                NaN    \n",
       "57                                                NaN    \n",
       "58                                                NaN    \n",
       "59                                                NaN    \n",
       "60                                                NaN    \n",
       "61                                                NaN    \n",
       "62                                                NaN    \n",
       "63                                                NaN    \n",
       "64                                                NaN    \n",
       "65                                                NaN    \n",
       "66                                                NaN    \n",
       "67                                                NaN    \n",
       "\n",
       "    IFDI Net Inflows (% of GDP)  ED National Electric Power Consumption TwH  \\\n",
       "0                      0.273179                                         NaN   \n",
       "1                      7.839316                                         NaN   \n",
       "2                      2.164932                                         NaN   \n",
       "3                      7.037159                                         NaN   \n",
       "4                      1.469627                                         NaN   \n",
       "5                      0.861500                                         NaN   \n",
       "6                      2.343707                                         NaN   \n",
       "7                     -0.654814                                         NaN   \n",
       "8                      2.562925                                         NaN   \n",
       "9                      3.858213                                         NaN   \n",
       "10                     3.747996                                         NaN   \n",
       "11                    12.582625                                         NaN   \n",
       "12                     1.374634                                         NaN   \n",
       "13                     3.695610                                         NaN   \n",
       "14                     4.269351                                         NaN   \n",
       "15                     0.227303                                         NaN   \n",
       "16                     3.140471                                         NaN   \n",
       "17                     5.999697                                         NaN   \n",
       "18                     1.832937                                         NaN   \n",
       "19                    12.133758                                         NaN   \n",
       "20                     2.120590                                         NaN   \n",
       "21                    -9.690974                                         NaN   \n",
       "22                          NaN                                         NaN   \n",
       "23                     2.113612                                         NaN   \n",
       "24                     1.105476                                         NaN   \n",
       "25                    -2.620212                                         NaN   \n",
       "26                     5.178530                                         NaN   \n",
       "27                     5.065645                                         NaN   \n",
       "28                     2.857327                                         NaN   \n",
       "29                     0.094078                                         NaN   \n",
       "..                          ...                                         ...   \n",
       "38                     1.978718                                         NaN   \n",
       "39                    13.069774                                         NaN   \n",
       "40                    11.565272                                         NaN   \n",
       "41                     6.985207                                         NaN   \n",
       "42                     0.788838                                         NaN   \n",
       "43                     4.017028                                         NaN   \n",
       "44                     0.923097                                         NaN   \n",
       "45                     3.207124                                         NaN   \n",
       "46                     2.027292                                         NaN   \n",
       "47                     0.590665                                         NaN   \n",
       "48                     2.809515                                         NaN   \n",
       "49                     1.810270                                         NaN   \n",
       "50                     0.206964                                         NaN   \n",
       "51                     6.948354                                         NaN   \n",
       "52                    19.645574                                         NaN   \n",
       "53                     6.183240                                         NaN   \n",
       "54                     2.218344                                         NaN   \n",
       "55                     1.573877                                         NaN   \n",
       "56                     3.073775                                         NaN   \n",
       "57                     1.501005                                         NaN   \n",
       "58                     1.767068                                         NaN   \n",
       "59                     2.706455                                         NaN   \n",
       "60                     1.278376                                         NaN   \n",
       "61                     6.099995                                         NaN   \n",
       "62                     2.466617                                         NaN   \n",
       "63                     1.829897                                         NaN   \n",
       "64                     2.520637                                         NaN   \n",
       "65                     0.192777                                         NaN   \n",
       "66                     6.300835                                         NaN   \n",
       "67                    -0.863032                                         NaN   \n",
       "\n",
       "    WHO Current Health Expenditure p.c., PPP USD  \\\n",
       "0                                     183.927858   \n",
       "1                                     773.678292   \n",
       "2                                     883.220652   \n",
       "3                                    1191.289459   \n",
       "4                                    2453.155914   \n",
       "5                                      88.035356   \n",
       "6                                    1084.619757   \n",
       "7                                     287.128628   \n",
       "8                                    1101.792914   \n",
       "9                                    2083.430502   \n",
       "10                                   1491.868089   \n",
       "11                                    209.616863   \n",
       "12                                    762.243779   \n",
       "13                                   1656.426156   \n",
       "14                                   2469.851757   \n",
       "15                                    141.275828   \n",
       "16                                    495.165081   \n",
       "17                                   1886.814387   \n",
       "18                                   4542.307106   \n",
       "19                                    717.716242   \n",
       "20                                   5356.811177   \n",
       "21                                   1912.069053   \n",
       "22                                           NaN   \n",
       "23                                    369.286440   \n",
       "24                                   1261.730503   \n",
       "25                                    481.039845   \n",
       "26                                   2819.111414   \n",
       "27                                    568.122532   \n",
       "28                                    903.324091   \n",
       "29                                   2977.514144   \n",
       "..                                           ...   \n",
       "38                                    515.323073   \n",
       "39                                    469.563584   \n",
       "40                                    957.014821   \n",
       "41                                    267.228033   \n",
       "42                                    150.590369   \n",
       "43                                   1635.870769   \n",
       "44                                    134.441461   \n",
       "45                                    322.778000   \n",
       "46                                   1704.195989   \n",
       "47                                   3900.286232   \n",
       "48                                   1090.416516   \n",
       "49                                   1414.028282   \n",
       "50                                   3121.341632   \n",
       "51                                   1323.690595   \n",
       "52                                   3681.295940   \n",
       "53                                   2061.950585   \n",
       "54                                   2733.762624   \n",
       "55                                    353.129150   \n",
       "56                                    159.716094   \n",
       "57                                    192.696191   \n",
       "58                                    610.170004   \n",
       "59                                   2425.795649   \n",
       "60                                    995.966037   \n",
       "61                                   1003.781827   \n",
       "62                                   4144.600790   \n",
       "63                                   9535.945335   \n",
       "64                                    469.428377   \n",
       "65                                    382.821710   \n",
       "66                                    334.319988   \n",
       "67                                    144.499884   \n",
       "\n",
       "    WB Research Expenditure % of GDP  WIPO Trademark applications  \\\n",
       "0                                NaN                          NaN   \n",
       "1                            0.15412                        918.0   \n",
       "2                                NaN                       2356.0   \n",
       "3                                NaN                       2817.0   \n",
       "4                            0.10116                        371.0   \n",
       "5                                NaN                       8580.0   \n",
       "6                                NaN                       4652.0   \n",
       "7                                NaN                         16.0   \n",
       "8                            0.21598                        797.0   \n",
       "9                            0.03701                         85.0   \n",
       "10                           0.78006                      14243.0   \n",
       "11                           0.11823                       1182.0   \n",
       "12                           2.10673                    3526953.0   \n",
       "13                           0.85621                       4334.0   \n",
       "14                           1.67830                      19301.0   \n",
       "15                               NaN                          NaN   \n",
       "16                           0.70876                      12750.0   \n",
       "17                           1.28129                       1999.0   \n",
       "18                           2.24776                     258090.0   \n",
       "19                           0.30104                       2217.0   \n",
       "20                           2.93949                     190216.0   \n",
       "21                           1.20606                       9318.0   \n",
       "22                               NaN                          NaN   \n",
       "23                           0.08470                      48756.0   \n",
       "24                           0.25267                     177538.0   \n",
       "25                           0.03631                          NaN   \n",
       "26                           4.25121                       3463.0   \n",
       "27                           0.33201                       3013.0   \n",
       "28                           0.14179                       8495.0   \n",
       "29                           0.42705                          NaN   \n",
       "..                               ...                          ...   \n",
       "38                           0.33114                       3049.0   \n",
       "39                               NaN                       7629.0   \n",
       "40                           0.37400                          3.0   \n",
       "41                           0.16216                       4422.0   \n",
       "42                           0.30220                       3215.0   \n",
       "43                           0.24647                          1.0   \n",
       "44                           0.24605                      27017.0   \n",
       "45                           0.13793                      22357.0   \n",
       "46                           0.96538                      39420.0   \n",
       "47                           0.50969                       1405.0   \n",
       "48                           0.48264                      20575.0   \n",
       "49                           1.09690                     193213.0   \n",
       "50                               NaN                       7423.0   \n",
       "51                           0.89059                       3431.0   \n",
       "52                           2.18377                       9721.0   \n",
       "53                           0.78965                       9436.0   \n",
       "54                           2.00202                          8.0   \n",
       "55                           0.09989                       6893.0   \n",
       "56                               NaN                          1.0   \n",
       "57                               NaN                        160.0   \n",
       "58                           0.61927                      35720.0   \n",
       "59                           0.98660                       5199.0   \n",
       "60                           0.88150                     193824.0   \n",
       "61                               NaN                          NaN   \n",
       "62                           1.69036                     114722.0   \n",
       "63                           2.74418                     388504.0   \n",
       "64                           0.48384                      45880.0   \n",
       "65                           0.22089                       6457.0   \n",
       "66                           0.44113                      54965.0   \n",
       "67                               NaN                       2561.0   \n",
       "\n",
       "    WIPO Patent Applications  \n",
       "0                        NaN  \n",
       "1                       21.0  \n",
       "2                      125.0  \n",
       "3                      144.0  \n",
       "4                        6.0  \n",
       "5                       77.0  \n",
       "6                      455.0  \n",
       "7                        3.0  \n",
       "8                       60.0  \n",
       "9                       26.0  \n",
       "10                     230.0  \n",
       "11                       2.0  \n",
       "12                 1204981.0  \n",
       "13                     175.0  \n",
       "14                     792.0  \n",
       "15                       NaN  \n",
       "16                     918.0  \n",
       "17                      29.0  \n",
       "18                   14206.0  \n",
       "19                      96.0  \n",
       "20                   48480.0  \n",
       "21                     616.0  \n",
       "22                       NaN  \n",
       "23                    1101.0  \n",
       "24                   14930.0  \n",
       "25                     335.0  \n",
       "26                    1300.0  \n",
       "27                      22.0  \n",
       "28                     993.0  \n",
       "29                       4.0  \n",
       "..                       ...  \n",
       "38                      91.0  \n",
       "39                     112.0  \n",
       "40                      10.0  \n",
       "41                       NaN  \n",
       "42                      11.0  \n",
       "43                       NaN  \n",
       "44                     204.0  \n",
       "45                     327.0  \n",
       "46                    4261.0  \n",
       "47                      16.0  \n",
       "48                    1005.0  \n",
       "49                   26795.0  \n",
       "50                    1070.0  \n",
       "51                     192.0  \n",
       "52                    1601.0  \n",
       "53                     220.0  \n",
       "54                     470.0  \n",
       "55                     280.0  \n",
       "56                     198.0  \n",
       "57                       2.0  \n",
       "58                    1098.0  \n",
       "59                      15.0  \n",
       "60                    6230.0  \n",
       "61                      44.0  \n",
       "62                   13876.0  \n",
       "63                  295327.0  \n",
       "64                    2233.0  \n",
       "65                     353.0  \n",
       "66                     560.0  \n",
       "67                      16.0  \n",
       "\n",
       "[68 rows x 43 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i,v in df['Country (according to CN Gov):'].iteritems():\n",
    "    country=v.split('(')[0].strip()\n",
    "    code = countries[country]\n",
    "    for il in indicator_list : \n",
    "        value = get_indicator(code,indicator_list[il])\n",
    "        if value is not None:\n",
    "            df.at[i,il]=value\n",
    "    print(country,'done...')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('filled-indicator.xls')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}