pruna.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import statsmodels as sm\n",
    "import matplotlib\n",
    "import folium\n",
    "import geocoder\n",
    "%pylab inline\n",
    "pylab.rcParams['figure.figsize'] = (10, 8)\n",
    "# from pandas import Series, DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# !ls -laSh"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# from pd import Series, DataFrame\n",
    "# from IPython.external.mathjax import install_mathjax\n",
    "data = []\n",
    "data = pd.read_csv('adi_data.csv', na_values=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country_Name_attr</th>\n",
       "      <th>Country__attrCode</th>\n",
       "      <th>Indicator_Name</th>\n",
       "      <th>Indicator_Code</th>\n",
       "      <th>1960</th>\n",
       "      <th>1961</th>\n",
       "      <th>1962</th>\n",
       "      <th>1963</th>\n",
       "      <th>1964</th>\n",
       "      <th>1965</th>\n",
       "      <th>...</th>\n",
       "      <th>2003</th>\n",
       "      <th>2004</th>\n",
       "      <th>2005</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>\"Fiscal balance, cash surplus/deficit (current...</td>\n",
       "      <td>GC.BAL.CASH.CD</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>1</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>10th pillar: Market size</td>\n",
       "      <td>GCI.10THPILLAR.XQ</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>2</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>11th pillar: Business sophistication</td>\n",
       "      <td>GCI.11THPILLAR.XQ</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>3</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>12th pillar: Innovation</td>\n",
       "      <td>GCI.12THPILLAR.XQ</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>4</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>1st pillar: Institutions</td>\n",
       "      <td>GCI.1STPILLAR.XQ</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 57 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Country_Name_attr Country__attrCode  \\\n",
       "0            Africa               AFR   \n",
       "1            Africa               AFR   \n",
       "2            Africa               AFR   \n",
       "3            Africa               AFR   \n",
       "4            Africa               AFR   \n",
       "\n",
       "                                      Indicator_Name     Indicator_Code  1960  \\\n",
       "0  \"Fiscal balance, cash surplus/deficit (current...     GC.BAL.CASH.CD   NaN   \n",
       "1                           10th pillar: Market size  GCI.10THPILLAR.XQ   NaN   \n",
       "2               11th pillar: Business sophistication  GCI.11THPILLAR.XQ   NaN   \n",
       "3                            12th pillar: Innovation  GCI.12THPILLAR.XQ   NaN   \n",
       "4                           1st pillar: Institutions   GCI.1STPILLAR.XQ   NaN   \n",
       "\n",
       "   1961  1962  1963  1964  1965  ...   2003  2004  2005  2006  2007  2008  \\\n",
       "0   NaN   NaN   NaN   NaN   NaN  ...    NaN   NaN   NaN   NaN   NaN   NaN   \n",
       "1   NaN   NaN   NaN   NaN   NaN  ...    NaN   NaN   NaN   NaN   NaN   NaN   \n",
       "2   NaN   NaN   NaN   NaN   NaN  ...    NaN   NaN   NaN   NaN   NaN   NaN   \n",
       "3   NaN   NaN   NaN   NaN   NaN  ...    NaN   NaN   NaN   NaN   NaN   NaN   \n",
       "4   NaN   NaN   NaN   NaN   NaN  ...    NaN   NaN   NaN   NaN   NaN   NaN   \n",
       "\n",
       "   2009  2010  2011  2012  \n",
       "0   NaN   NaN   NaN   NaN  \n",
       "1   NaN   NaN   NaN   NaN  \n",
       "2   NaN   NaN   NaN   NaN  \n",
       "3   NaN   NaN   NaN   NaN  \n",
       "4   NaN   NaN   NaN   NaN  \n",
       "\n",
       "[5 rows x 57 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Country_Name_attr', 'Country__attrCode', 'Indicator_Name',\n",
       "       'Indicator_Code', '1960', '1961', '1962', '1963', '1964', '1965',\n",
       "       '1966', '1967', '1968', '1969', '1970', '1971', '1972', '1973', '1974',\n",
       "       '1975', '1976', '1977', '1978', '1979', '1980', '1981', '1982', '1983',\n",
       "       '1984', '1985', '1986', '1987', '1988', '1989', '1990', '1991', '1992',\n",
       "       '1993', '1994', '1995', '1996', '1997', '1998', '1999', '2000', '2001',\n",
       "       '2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009', '2010',\n",
       "       '2011', '2012'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 104760 entries, 0 to 104759\n",
      "Data columns (total 57 columns):\n",
      "Country_Name_attr    104760 non-null object\n",
      "Country__attrCode    104760 non-null object\n",
      "Indicator_Name       104760 non-null object\n",
      "Indicator_Code       104760 non-null object\n",
      "1960                 10458 non-null float64\n",
      "1961                 14011 non-null float64\n",
      "1962                 14641 non-null float64\n",
      "1963                 14666 non-null float64\n",
      "1964                 14986 non-null float64\n",
      "1965                 17986 non-null float64\n",
      "1966                 17588 non-null float64\n",
      "1967                 18048 non-null float64\n",
      "1968                 18120 non-null float64\n",
      "1969                 18227 non-null float64\n",
      "1970                 26426 non-null float64\n",
      "1971                 27110 non-null float64\n",
      "1972                 27419 non-null float64\n",
      "1973                 27231 non-null float64\n",
      "1974                 27480 non-null float64\n",
      "1975                 29182 non-null float64\n",
      "1976                 29695 non-null float64\n",
      "1977                 30226 non-null float64\n",
      "1978                 30217 non-null float64\n",
      "1979                 30456 non-null float64\n",
      "1980                 33416 non-null float64\n",
      "1981                 34095 non-null float64\n",
      "1982                 34593 non-null float64\n",
      "1983                 34618 non-null float64\n",
      "1984                 35613 non-null float64\n",
      "1985                 36854 non-null float64\n",
      "1986                 37306 non-null float64\n",
      "1987                 38104 non-null float64\n",
      "1988                 38355 non-null float64\n",
      "1989                 38807 non-null float64\n",
      "1990                 46599 non-null float64\n",
      "1991                 47061 non-null float64\n",
      "1992                 47965 non-null float64\n",
      "1993                 47752 non-null float64\n",
      "1994                 48497 non-null float64\n",
      "1995                 50633 non-null float64\n",
      "1996                 51332 non-null float64\n",
      "1997                 50967 non-null float64\n",
      "1998                 51863 non-null float64\n",
      "1999                 51804 non-null float64\n",
      "2000                 55009 non-null float64\n",
      "2001                 53990 non-null float64\n",
      "2002                 58135 non-null float64\n",
      "2003                 57781 non-null float64\n",
      "2004                 58664 non-null float64\n",
      "2005                 65084 non-null float64\n",
      "2006                 65715 non-null float64\n",
      "2007                 64897 non-null float64\n",
      "2008                 62472 non-null float64\n",
      "2009                 62854 non-null float64\n",
      "2010                 58877 non-null float64\n",
      "2011                 51970 non-null float64\n",
      "2012                 5022 non-null float64\n",
      "dtypes: float64(53), object(4)\n",
      "memory usage: 45.6+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python3.5/dist-packages/numpy/lib/function_base.py:3834: RuntimeWarning: Invalid value encountered in percentile\n",
      "  RuntimeWarning)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1960</th>\n",
       "      <th>1961</th>\n",
       "      <th>1962</th>\n",
       "      <th>1963</th>\n",
       "      <th>1964</th>\n",
       "      <th>1965</th>\n",
       "      <th>1966</th>\n",
       "      <th>1967</th>\n",
       "      <th>1968</th>\n",
       "      <th>1969</th>\n",
       "      <th>...</th>\n",
       "      <th>2003</th>\n",
       "      <th>2004</th>\n",
       "      <th>2005</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.045800e+04</td>\n",
       "      <td>1.401100e+04</td>\n",
       "      <td>1.464100e+04</td>\n",
       "      <td>1.466600e+04</td>\n",
       "      <td>1.498600e+04</td>\n",
       "      <td>1.798600e+04</td>\n",
       "      <td>1.758800e+04</td>\n",
       "      <td>1.804800e+04</td>\n",
       "      <td>1.812000e+04</td>\n",
       "      <td>1.822700e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>5.778100e+04</td>\n",
       "      <td>5.866400e+04</td>\n",
       "      <td>6.508400e+04</td>\n",
       "      <td>6.571500e+04</td>\n",
       "      <td>6.489700e+04</td>\n",
       "      <td>6.247200e+04</td>\n",
       "      <td>6.285400e+04</td>\n",
       "      <td>5.887700e+04</td>\n",
       "      <td>5.197000e+04</td>\n",
       "      <td>5.022000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>9.698293e+09</td>\n",
       "      <td>7.435320e+09</td>\n",
       "      <td>7.321397e+09</td>\n",
       "      <td>7.608746e+09</td>\n",
       "      <td>8.437124e+09</td>\n",
       "      <td>9.466919e+09</td>\n",
       "      <td>1.039587e+10</td>\n",
       "      <td>1.138860e+10</td>\n",
       "      <td>1.224405e+10</td>\n",
       "      <td>1.327963e+10</td>\n",
       "      <td>...</td>\n",
       "      <td>1.443773e+16</td>\n",
       "      <td>1.504945e+16</td>\n",
       "      <td>1.422888e+16</td>\n",
       "      <td>1.537146e+16</td>\n",
       "      <td>1.702430e+16</td>\n",
       "      <td>1.753084e+16</td>\n",
       "      <td>1.090952e+11</td>\n",
       "      <td>1.326100e+11</td>\n",
       "      <td>1.608894e+11</td>\n",
       "      <td>1.844105e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>9.661116e+10</td>\n",
       "      <td>8.329482e+10</td>\n",
       "      <td>8.312047e+10</td>\n",
       "      <td>8.650995e+10</td>\n",
       "      <td>9.573042e+10</td>\n",
       "      <td>1.000417e+11</td>\n",
       "      <td>1.108124e+11</td>\n",
       "      <td>1.189969e+11</td>\n",
       "      <td>1.256872e+11</td>\n",
       "      <td>1.437140e+11</td>\n",
       "      <td>...</td>\n",
       "      <td>3.470481e+18</td>\n",
       "      <td>3.645059e+18</td>\n",
       "      <td>3.629993e+18</td>\n",
       "      <td>3.940443e+18</td>\n",
       "      <td>4.336898e+18</td>\n",
       "      <td>4.381702e+18</td>\n",
       "      <td>1.518539e+12</td>\n",
       "      <td>1.789520e+12</td>\n",
       "      <td>2.121123e+12</td>\n",
       "      <td>1.447996e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-7.142710e+11</td>\n",
       "      <td>-6.453520e+11</td>\n",
       "      <td>-7.333810e+11</td>\n",
       "      <td>-5.887420e+11</td>\n",
       "      <td>-3.996050e+11</td>\n",
       "      <td>-7.566140e+11</td>\n",
       "      <td>-1.308750e+12</td>\n",
       "      <td>-1.716620e+12</td>\n",
       "      <td>-1.841570e+12</td>\n",
       "      <td>-1.424600e+12</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.247470e+13</td>\n",
       "      <td>-2.217360e+13</td>\n",
       "      <td>-1.357200e+13</td>\n",
       "      <td>-2.205640e+13</td>\n",
       "      <td>-2.716460e+13</td>\n",
       "      <td>-2.820880e+13</td>\n",
       "      <td>-3.996840e+13</td>\n",
       "      <td>-4.139820e+13</td>\n",
       "      <td>-5.797690e+13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\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",
       "      <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>50%</th>\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",
       "      <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>75%</th>\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",
       "      <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>max</th>\n",
       "      <td>2.568620e+12</td>\n",
       "      <td>2.386980e+12</td>\n",
       "      <td>2.476740e+12</td>\n",
       "      <td>2.658270e+12</td>\n",
       "      <td>2.815490e+12</td>\n",
       "      <td>3.180670e+12</td>\n",
       "      <td>3.680690e+12</td>\n",
       "      <td>3.816560e+12</td>\n",
       "      <td>4.032870e+12</td>\n",
       "      <td>5.764460e+12</td>\n",
       "      <td>...</td>\n",
       "      <td>8.342230e+20</td>\n",
       "      <td>8.828570e+20</td>\n",
       "      <td>9.260680e+20</td>\n",
       "      <td>1.010130e+21</td>\n",
       "      <td>1.104820e+21</td>\n",
       "      <td>1.095180e+21</td>\n",
       "      <td>9.739010e+13</td>\n",
       "      <td>1.066470e+14</td>\n",
       "      <td>1.241490e+14</td>\n",
       "      <td>3.345706e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               1960          1961          1962          1963          1964  \\\n",
       "count  1.045800e+04  1.401100e+04  1.464100e+04  1.466600e+04  1.498600e+04   \n",
       "mean   9.698293e+09  7.435320e+09  7.321397e+09  7.608746e+09  8.437124e+09   \n",
       "std    9.661116e+10  8.329482e+10  8.312047e+10  8.650995e+10  9.573042e+10   \n",
       "min   -7.142710e+11 -6.453520e+11 -7.333810e+11 -5.887420e+11 -3.996050e+11   \n",
       "25%             NaN           NaN           NaN           NaN           NaN   \n",
       "50%             NaN           NaN           NaN           NaN           NaN   \n",
       "75%             NaN           NaN           NaN           NaN           NaN   \n",
       "max    2.568620e+12  2.386980e+12  2.476740e+12  2.658270e+12  2.815490e+12   \n",
       "\n",
       "               1965          1966          1967          1968          1969  \\\n",
       "count  1.798600e+04  1.758800e+04  1.804800e+04  1.812000e+04  1.822700e+04   \n",
       "mean   9.466919e+09  1.039587e+10  1.138860e+10  1.224405e+10  1.327963e+10   \n",
       "std    1.000417e+11  1.108124e+11  1.189969e+11  1.256872e+11  1.437140e+11   \n",
       "min   -7.566140e+11 -1.308750e+12 -1.716620e+12 -1.841570e+12 -1.424600e+12   \n",
       "25%             NaN           NaN           NaN           NaN           NaN   \n",
       "50%             NaN           NaN           NaN           NaN           NaN   \n",
       "75%             NaN           NaN           NaN           NaN           NaN   \n",
       "max    3.180670e+12  3.680690e+12  3.816560e+12  4.032870e+12  5.764460e+12   \n",
       "\n",
       "           ...               2003          2004          2005          2006  \\\n",
       "count      ...       5.778100e+04  5.866400e+04  6.508400e+04  6.571500e+04   \n",
       "mean       ...       1.443773e+16  1.504945e+16  1.422888e+16  1.537146e+16   \n",
       "std        ...       3.470481e+18  3.645059e+18  3.629993e+18  3.940443e+18   \n",
       "min        ...      -1.247470e+13 -2.217360e+13 -1.357200e+13 -2.205640e+13   \n",
       "25%        ...                NaN           NaN           NaN           NaN   \n",
       "50%        ...                NaN           NaN           NaN           NaN   \n",
       "75%        ...                NaN           NaN           NaN           NaN   \n",
       "max        ...       8.342230e+20  8.828570e+20  9.260680e+20  1.010130e+21   \n",
       "\n",
       "               2007          2008          2009          2010          2011  \\\n",
       "count  6.489700e+04  6.247200e+04  6.285400e+04  5.887700e+04  5.197000e+04   \n",
       "mean   1.702430e+16  1.753084e+16  1.090952e+11  1.326100e+11  1.608894e+11   \n",
       "std    4.336898e+18  4.381702e+18  1.518539e+12  1.789520e+12  2.121123e+12   \n",
       "min   -2.716460e+13 -2.820880e+13 -3.996840e+13 -4.139820e+13 -5.797690e+13   \n",
       "25%             NaN           NaN           NaN           NaN           NaN   \n",
       "50%             NaN           NaN           NaN           NaN           NaN   \n",
       "75%             NaN           NaN           NaN           NaN           NaN   \n",
       "max    1.104820e+21  1.095180e+21  9.739010e+13  1.066470e+14  1.241490e+14   \n",
       "\n",
       "               2012  \n",
       "count  5.022000e+03  \n",
       "mean   1.844105e+08  \n",
       "std    1.447996e+09  \n",
       "min    0.000000e+00  \n",
       "25%             NaN  \n",
       "50%             NaN  \n",
       "75%             NaN  \n",
       "max    3.345706e+10  \n",
       "\n",
       "[8 rows x 53 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Country_Name_attr', 'Country__attrCode', 'Indicator_Name',\n",
       "       'Indicator_Code', '1960', '1961', '1962', '1963', '1964', '1965',\n",
       "       '1966', '1967', '1968', '1969', '1970', '1971', '1972', '1973', '1974',\n",
       "       '1975', '1976', '1977', '1978', '1979', '1980', '1981', '1982', '1983',\n",
       "       '1984', '1985', '1986', '1987', '1988', '1989', '1990', '1991', '1992',\n",
       "       '1993', '1994', '1995', '1996', '1997', '1998', '1999', '2000', '2001',\n",
       "       '2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009', '2010',\n",
       "       '2011', '2012'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df = data.groupby(['Country_Name_attr', 'Country__attrCode', 'Indicator_Name',\n",
    "       'Indicator_Code'])\n",
    "# df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data = data.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country_Name_attr</th>\n",
       "      <th>Country__attrCode</th>\n",
       "      <th>Indicator_Name</th>\n",
       "      <th>Indicator_Code</th>\n",
       "      <th>1960</th>\n",
       "      <th>1961</th>\n",
       "      <th>1962</th>\n",
       "      <th>1963</th>\n",
       "      <th>1964</th>\n",
       "      <th>1965</th>\n",
       "      <th>...</th>\n",
       "      <th>2003</th>\n",
       "      <th>2004</th>\n",
       "      <th>2005</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>\"Fiscal balance, cash surplus/deficit (current...</td>\n",
       "      <td>GC.BAL.CASH.CD</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>10th pillar: Market size</td>\n",
       "      <td>GCI.10THPILLAR.XQ</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>11th pillar: Business sophistication</td>\n",
       "      <td>GCI.11THPILLAR.XQ</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>12th pillar: Innovation</td>\n",
       "      <td>GCI.12THPILLAR.XQ</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Africa</td>\n",
       "      <td>AFR</td>\n",
       "      <td>1st pillar: Institutions</td>\n",
       "      <td>GCI.1STPILLAR.XQ</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 57 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Country_Name_attr Country__attrCode  \\\n",
       "0            Africa               AFR   \n",
       "1            Africa               AFR   \n",
       "2            Africa               AFR   \n",
       "3            Africa               AFR   \n",
       "4            Africa               AFR   \n",
       "\n",
       "                                      Indicator_Name     Indicator_Code  1960  \\\n",
       "0  \"Fiscal balance, cash surplus/deficit (current...     GC.BAL.CASH.CD   0.0   \n",
       "1                           10th pillar: Market size  GCI.10THPILLAR.XQ   0.0   \n",
       "2               11th pillar: Business sophistication  GCI.11THPILLAR.XQ   0.0   \n",
       "3                            12th pillar: Innovation  GCI.12THPILLAR.XQ   0.0   \n",
       "4                           1st pillar: Institutions   GCI.1STPILLAR.XQ   0.0   \n",
       "\n",
       "   1961  1962  1963  1964  1965  ...   2003  2004  2005  2006  2007  2008  \\\n",
       "0   0.0   0.0   0.0   0.0   0.0  ...    0.0   0.0   0.0   0.0   0.0   0.0   \n",
       "1   0.0   0.0   0.0   0.0   0.0  ...    0.0   0.0   0.0   0.0   0.0   0.0   \n",
       "2   0.0   0.0   0.0   0.0   0.0  ...    0.0   0.0   0.0   0.0   0.0   0.0   \n",
       "3   0.0   0.0   0.0   0.0   0.0  ...    0.0   0.0   0.0   0.0   0.0   0.0   \n",
       "4   0.0   0.0   0.0   0.0   0.0  ...    0.0   0.0   0.0   0.0   0.0   0.0   \n",
       "\n",
       "   2009  2010  2011  2012  \n",
       "0   0.0   0.0   0.0   0.0  \n",
       "1   0.0   0.0   0.0   0.0  \n",
       "2   0.0   0.0   0.0   0.0  \n",
       "3   0.0   0.0   0.0   0.0  \n",
       "4   0.0   0.0   0.0   0.0  \n",
       "\n",
       "[5 rows x 57 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>1960</th>\n",
       "      <th>1961</th>\n",
       "      <th>1962</th>\n",
       "      <th>1963</th>\n",
       "      <th>1964</th>\n",
       "      <th>1965</th>\n",
       "      <th>1966</th>\n",
       "      <th>1967</th>\n",
       "      <th>1968</th>\n",
       "      <th>1969</th>\n",
       "      <th>...</th>\n",
       "      <th>2003</th>\n",
       "      <th>2004</th>\n",
       "      <th>2005</th>\n",
       "      <th>2006</th>\n",
       "      <th>2007</th>\n",
       "      <th>2008</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country_Name_attr</th>\n",
       "      <th>Country__attrCode</th>\n",
       "      <th>Indicator_Name</th>\n",
       "      <th>Indicator_Code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Africa</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">AFR</th>\n",
       "      <th>\"Fiscal balance, cash surplus/deficit (current US$)\\r\"</th>\n",
       "      <th>GC.BAL.CASH.CD</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10th pillar: Market size</th>\n",
       "      <th>GCI.10THPILLAR.XQ</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11th pillar: Business sophistication</th>\n",
       "      <th>GCI.11THPILLAR.XQ</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12th pillar: Innovation</th>\n",
       "      <th>GCI.12THPILLAR.XQ</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1st pillar: Institutions</th>\n",
       "      <th>GCI.1STPILLAR.XQ</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                          1960  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1961  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1962  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1963  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1964  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1965  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1966  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1967  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1968  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          1969  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          ...   \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code     ...    \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD     ...    \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ  ...    \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ  ...    \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ  ...    \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ   ...    \n",
       "\n",
       "                                                                                                          2003  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2004  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2005  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2006  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2007  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2008  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2009  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2010  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2011  \\\n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code            \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0   \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0   \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0   \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0   \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0   \n",
       "\n",
       "                                                                                                          2012  \n",
       "Country_Name_attr Country__attrCode Indicator_Name                                     Indicator_Code           \n",
       "Africa            AFR               \"Fiscal balance, cash surplus/deficit (current ... GC.BAL.CASH.CD        0  \n",
       "                                    10th pillar: Market size                           GCI.10THPILLAR.XQ     0  \n",
       "                                    11th pillar: Business sophistication               GCI.11THPILLAR.XQ     0  \n",
       "                                    12th pillar: Innovation                            GCI.12THPILLAR.XQ     0  \n",
       "                                    1st pillar: Institutions                           GCI.1STPILLAR.XQ      0  \n",
       "\n",
       "[5 rows x 53 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.index\n",
    "count_nations = df.count()\n",
    "count_nations.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "data.sort_index(axis=1, ascending=False)\n",
    "data[0:6]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}