sliderule_dsi_json_exercise.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# JSON examples and exercise\n",
    "****\n",
    "+ get familiar with packages for dealing with JSON\n",
    "+ study examples with JSON strings and files \n",
    "+ work on exercise to be completed and submitted \n",
    "****\n",
    "+ reference: http://pandas.pydata.org/pandas-docs/stable/io.html#io-json-reader\n",
    "+ data source: http://jsonstudio.com/resources/\n",
    "****"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## imports for Python, Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import json\n",
    "from pandas.io.json import json_normalize"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## JSON example, with string\n",
    "\n",
    "+ demonstrates creation of normalized dataframes (tables) from nested json string\n",
    "+ source: http://pandas.pydata.org/pandas-docs/stable/io.html#normalization"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# define json string\n",
    "data = [{'state': 'Florida', \n",
    "         'shortname': 'FL',\n",
    "         'info': {'governor': 'Rick Scott'},\n",
    "         'counties': [{'name': 'Dade', 'population': 12345},\n",
    "                      {'name': 'Broward', 'population': 40000},\n",
    "                      {'name': 'Palm Beach', 'population': 60000}]},\n",
    "        {'state': 'Ohio',\n",
    "         'shortname': 'OH',\n",
    "         'info': {'governor': 'John Kasich'},\n",
    "         'counties': [{'name': 'Summit', 'population': 1234},\n",
    "                      {'name': 'Cuyahoga', 'population': 1337}]}]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dade</td>\n",
       "      <td>12345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Broward</td>\n",
       "      <td>40000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Palm Beach</td>\n",
       "      <td>60000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Summit</td>\n",
       "      <td>1234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1337</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         name  population\n",
       "0        Dade       12345\n",
       "1     Broward       40000\n",
       "2  Palm Beach       60000\n",
       "3      Summit        1234\n",
       "4    Cuyahoga        1337"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# use normalization to create tables from nested element\n",
    "json_normalize(data, 'counties')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>population</th>\n",
       "      <th>state</th>\n",
       "      <th>shortname</th>\n",
       "      <th>info.governor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dade</td>\n",
       "      <td>12345</td>\n",
       "      <td>Florida</td>\n",
       "      <td>FL</td>\n",
       "      <td>Rick Scott</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Broward</td>\n",
       "      <td>40000</td>\n",
       "      <td>Florida</td>\n",
       "      <td>FL</td>\n",
       "      <td>Rick Scott</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Palm Beach</td>\n",
       "      <td>60000</td>\n",
       "      <td>Florida</td>\n",
       "      <td>FL</td>\n",
       "      <td>Rick Scott</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Summit</td>\n",
       "      <td>1234</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>OH</td>\n",
       "      <td>John Kasich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1337</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>OH</td>\n",
       "      <td>John Kasich</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         name  population    state shortname info.governor\n",
       "0        Dade       12345  Florida        FL    Rick Scott\n",
       "1     Broward       40000  Florida        FL    Rick Scott\n",
       "2  Palm Beach       60000  Florida        FL    Rick Scott\n",
       "3      Summit        1234     Ohio        OH   John Kasich\n",
       "4    Cuyahoga        1337     Ohio        OH   John Kasich"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# further populate tables created from nested element\n",
    "json_normalize(data, 'counties', ['state', 'shortname', ['info', 'governor']])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "****\n",
    "## JSON example, with file\n",
    "\n",
    "+ demonstrates reading in a json file as a string and as a table\n",
    "+ uses small sample file containing data about projects funded by the World Bank \n",
    "+ data source: http://jsonstudio.com/resources/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'_id': {'$oid': '52b213b38594d8a2be17c780'},\n",
       "  'approvalfy': 1999,\n",
       "  'board_approval_month': 'November',\n",
       "  'boardapprovaldate': '2013-11-12T00:00:00Z',\n",
       "  'borrower': 'FEDERAL DEMOCRATIC REPUBLIC OF ETHIOPIA',\n",
       "  'closingdate': '2018-07-07T00:00:00Z',\n",
       "  'country_namecode': 'Federal Democratic Republic of Ethiopia!$!ET',\n",
       "  'countrycode': 'ET',\n",
       "  'countryname': 'Federal Democratic Republic of Ethiopia',\n",
       "  'countryshortname': 'Ethiopia',\n",
       "  'docty': 'Project Information Document,Indigenous Peoples Plan,Project Information Document',\n",
       "  'envassesmentcategorycode': 'C',\n",
       "  'grantamt': 0,\n",
       "  'ibrdcommamt': 0,\n",
       "  'id': 'P129828',\n",
       "  'idacommamt': 130000000,\n",
       "  'impagency': 'MINISTRY OF EDUCATION',\n",
       "  'lendinginstr': 'Investment Project Financing',\n",
       "  'lendinginstrtype': 'IN',\n",
       "  'lendprojectcost': 550000000,\n",
       "  'majorsector_percent': [{'Name': 'Education', 'Percent': 46},\n",
       "   {'Name': 'Education', 'Percent': 26},\n",
       "   {'Name': 'Public Administration, Law, and Justice', 'Percent': 16},\n",
       "   {'Name': 'Education', 'Percent': 12}],\n",
       "  'mjsector_namecode': [{'code': 'EX', 'name': 'Education'},\n",
       "   {'code': 'EX', 'name': 'Education'},\n",
       "   {'code': 'BX', 'name': 'Public Administration, Law, and Justice'},\n",
       "   {'code': 'EX', 'name': 'Education'}],\n",
       "  'mjtheme': ['Human development'],\n",
       "  'mjtheme_namecode': [{'code': '8', 'name': 'Human development'},\n",
       "   {'code': '11', 'name': ''}],\n",
       "  'mjthemecode': '8,11',\n",
       "  'prodline': 'PE',\n",
       "  'prodlinetext': 'IBRD/IDA',\n",
       "  'productlinetype': 'L',\n",
       "  'project_abstract': {'cdata': 'The development objective of the Second Phase of General Education Quality Improvement Project for Ethiopia is to improve learning conditions in primary and secondary schools and strengthen institutions at different levels of educational administration. The project has six components. The first component is curriculum, textbooks, assessment, examinations, and inspection. This component will support improvement of learning conditions in grades KG-12 by providing increased access to teaching and learning materials and through improvements to the curriculum by assessing the strengths and weaknesses of the current curriculum. This component has following four sub-components: (i) curriculum reform and implementation; (ii) teaching and learning materials; (iii) assessment and examinations; and (iv) inspection. The second component is teacher development program (TDP). This component will support improvements in learning conditions in both primary and secondary schools by advancing the quality of teaching in general education through: (a) enhancing the training of pre-service teachers in teacher education institutions; and (b) improving the quality of in-service teacher training. This component has following three sub-components: (i) pre-service teacher training; (ii) in-service teacher training; and (iii) licensing and relicensing of teachers and school leaders. The third component is school improvement plan. This component will support the strengthening of school planning in order to improve learning outcomes, and to partly fund the school improvement plans through school grants. It has following two sub-components: (i) school improvement plan; and (ii) school grants. The fourth component is management and capacity building, including education management information systems (EMIS). This component will support management and capacity building aspect of the project. This component has following three sub-components: (i) capacity building for education planning and management; (ii) capacity building for school planning and management; and (iii) EMIS. The fifth component is improving the quality of learning and teaching in secondary schools and universities through the use of information and communications technology (ICT). It has following five sub-components: (i) national policy and institution for ICT in general education; (ii) national ICT infrastructure improvement plan for general education; (iii) develop an integrated monitoring, evaluation, and learning system specifically for the ICT component; (iv) teacher professional development in the use of ICT; and (v) provision of limited number of e-Braille display readers with the possibility to scale up to all secondary education schools based on the successful implementation and usage of the readers. The sixth component is program coordination, monitoring and evaluation, and communication. It will support institutional strengthening by developing capacities in all aspects of program coordination, monitoring and evaluation; a new sub-component on communications will support information sharing for better management and accountability. It has following three sub-components: (i) program coordination; (ii) monitoring and evaluation (M and E); and (iii) communication.'},\n",
       "  'project_name': 'Ethiopia General Education Quality Improvement Project II',\n",
       "  'projectdocs': [{'DocDate': '28-AUG-2013',\n",
       "    'DocType': 'PID',\n",
       "    'DocTypeDesc': 'Project Information Document (PID),  Vol.',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=090224b081e545fb_1_0',\n",
       "    'EntityID': '090224b081e545fb_1_0'},\n",
       "   {'DocDate': '01-JUL-2013',\n",
       "    'DocType': 'IP',\n",
       "    'DocTypeDesc': 'Indigenous Peoples Plan (IP),  Vol.1 of 1',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=000442464_20130920111729',\n",
       "    'EntityID': '000442464_20130920111729'},\n",
       "   {'DocDate': '22-NOV-2012',\n",
       "    'DocType': 'PID',\n",
       "    'DocTypeDesc': 'Project Information Document (PID),  Vol.',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=090224b0817b19e2_1_0',\n",
       "    'EntityID': '090224b0817b19e2_1_0'}],\n",
       "  'projectfinancialtype': 'IDA',\n",
       "  'projectstatusdisplay': 'Active',\n",
       "  'regionname': 'Africa',\n",
       "  'sector': [{'Name': 'Primary education'},\n",
       "   {'Name': 'Secondary education'},\n",
       "   {'Name': 'Public administration- Other social services'},\n",
       "   {'Name': 'Tertiary education'}],\n",
       "  'sector1': {'Name': 'Primary education', 'Percent': 46},\n",
       "  'sector2': {'Name': 'Secondary education', 'Percent': 26},\n",
       "  'sector3': {'Name': 'Public administration- Other social services',\n",
       "   'Percent': 16},\n",
       "  'sector4': {'Name': 'Tertiary education', 'Percent': 12},\n",
       "  'sector_namecode': [{'code': 'EP', 'name': 'Primary education'},\n",
       "   {'code': 'ES', 'name': 'Secondary education'},\n",
       "   {'code': 'BS', 'name': 'Public administration- Other social services'},\n",
       "   {'code': 'ET', 'name': 'Tertiary education'}],\n",
       "  'sectorcode': 'ET,BS,ES,EP',\n",
       "  'source': 'IBRD',\n",
       "  'status': 'Active',\n",
       "  'supplementprojectflg': 'N',\n",
       "  'theme1': {'Name': 'Education for all', 'Percent': 100},\n",
       "  'theme_namecode': [{'code': '65', 'name': 'Education for all'}],\n",
       "  'themecode': '65',\n",
       "  'totalamt': 130000000,\n",
       "  'totalcommamt': 130000000,\n",
       "  'url': 'http://www.worldbank.org/projects/P129828/ethiopia-general-education-quality-improvement-project-ii?lang=en'},\n",
       " {'_id': {'$oid': '52b213b38594d8a2be17c781'},\n",
       "  'approvalfy': 2015,\n",
       "  'board_approval_month': 'November',\n",
       "  'boardapprovaldate': '2013-11-04T00:00:00Z',\n",
       "  'borrower': 'GOVERNMENT OF TUNISIA',\n",
       "  'country_namecode': 'Republic of Tunisia!$!TN',\n",
       "  'countrycode': 'TN',\n",
       "  'countryname': 'Republic of Tunisia',\n",
       "  'countryshortname': 'Tunisia',\n",
       "  'docty': 'Project Information Document,Integrated Safeguards Data Sheet,Integrated Safeguards Data Sheet,Project Information Document,Integrated Safeguards Data Sheet,Project Information Document',\n",
       "  'envassesmentcategorycode': 'C',\n",
       "  'grantamt': 4700000,\n",
       "  'ibrdcommamt': 0,\n",
       "  'id': 'P144674',\n",
       "  'idacommamt': 0,\n",
       "  'impagency': 'MINISTRY OF FINANCE',\n",
       "  'lendinginstr': 'Specific Investment Loan',\n",
       "  'lendinginstrtype': 'IN',\n",
       "  'lendprojectcost': 5700000,\n",
       "  'majorsector_percent': [{'Name': 'Public Administration, Law, and Justice',\n",
       "    'Percent': 70},\n",
       "   {'Name': 'Public Administration, Law, and Justice', 'Percent': 30}],\n",
       "  'mjsector_namecode': [{'code': 'BX',\n",
       "    'name': 'Public Administration, Law, and Justice'},\n",
       "   {'code': 'BX', 'name': 'Public Administration, Law, and Justice'}],\n",
       "  'mjtheme': ['Economic management', 'Social protection and risk management'],\n",
       "  'mjtheme_namecode': [{'code': '1', 'name': 'Economic management'},\n",
       "   {'code': '6', 'name': 'Social protection and risk management'}],\n",
       "  'mjthemecode': '1,6',\n",
       "  'prodline': 'RE',\n",
       "  'prodlinetext': 'Recipient Executed Activities',\n",
       "  'productlinetype': 'L',\n",
       "  'project_name': 'TN: DTF Social Protection Reforms Support',\n",
       "  'projectdocs': [{'DocDate': '29-MAR-2013',\n",
       "    'DocType': 'PID',\n",
       "    'DocTypeDesc': 'Project Information Document (PID),  Vol.1 of 1',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=000333037_20131024115616',\n",
       "    'EntityID': '000333037_20131024115616'},\n",
       "   {'DocDate': '29-MAR-2013',\n",
       "    'DocType': 'ISDS',\n",
       "    'DocTypeDesc': 'Integrated Safeguards Data Sheet (ISDS),  Vol.1 of 1',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=000356161_20131024151611',\n",
       "    'EntityID': '000356161_20131024151611'},\n",
       "   {'DocDate': '29-MAR-2013',\n",
       "    'DocType': 'ISDS',\n",
       "    'DocTypeDesc': 'Integrated Safeguards Data Sheet (ISDS),  Vol.1 of 1',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=000442464_20131031112136',\n",
       "    'EntityID': '000442464_20131031112136'},\n",
       "   {'DocDate': '29-MAR-2013',\n",
       "    'DocType': 'PID',\n",
       "    'DocTypeDesc': 'Project Information Document (PID),  Vol.1 of 1',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=000333037_20131031105716',\n",
       "    'EntityID': '000333037_20131031105716'},\n",
       "   {'DocDate': '16-JAN-2013',\n",
       "    'DocType': 'ISDS',\n",
       "    'DocTypeDesc': 'Integrated Safeguards Data Sheet (ISDS),  Vol.1 of 1',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=000356161_20130305113209',\n",
       "    'EntityID': '000356161_20130305113209'},\n",
       "   {'DocDate': '16-JAN-2013',\n",
       "    'DocType': 'PID',\n",
       "    'DocTypeDesc': 'Project Information Document (PID),  Vol.1 of 1',\n",
       "    'DocURL': 'http://www-wds.worldbank.org/servlet/WDSServlet?pcont=details&eid=000356161_20130305113716',\n",
       "    'EntityID': '000356161_20130305113716'}],\n",
       "  'projectfinancialtype': 'OTHER',\n",
       "  'projectstatusdisplay': 'Active',\n",
       "  'regionname': 'Middle East and North Africa',\n",
       "  'sector': [{'Name': 'Public administration- Other social services'},\n",
       "   {'Name': 'General public administration sector'}],\n",
       "  'sector1': {'Name': 'Public administration- Other social services',\n",
       "   'Percent': 70},\n",
       "  'sector2': {'Name': 'General public administration sector', 'Percent': 30},\n",
       "  'sector_namecode': [{'code': 'BS',\n",
       "    'name': 'Public administration- Other social services'},\n",
       "   {'code': 'BZ', 'name': 'General public administration sector'}],\n",
       "  'sectorcode': 'BZ,BS',\n",
       "  'source': 'IBRD',\n",
       "  'status': 'Active',\n",
       "  'supplementprojectflg': 'N',\n",
       "  'theme1': {'Name': 'Other economic management', 'Percent': 30},\n",
       "  'theme_namecode': [{'code': '24', 'name': 'Other economic management'},\n",
       "   {'code': '54', 'name': 'Social safety nets'}],\n",
       "  'themecode': '54,24',\n",
       "  'totalamt': 0,\n",
       "  'totalcommamt': 4700000,\n",
       "  'url': 'http://www.worldbank.org/projects/P144674?lang=en'}]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# load json as string\n",
    "json.load((open('world_bank_projects_less.json')))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>approvalfy</th>\n",
       "      <th>board_approval_month</th>\n",
       "      <th>boardapprovaldate</th>\n",
       "      <th>borrower</th>\n",
       "      <th>closingdate</th>\n",
       "      <th>country_namecode</th>\n",
       "      <th>countrycode</th>\n",
       "      <th>countryname</th>\n",
       "      <th>countryshortname</th>\n",
       "      <th>...</th>\n",
       "      <th>sectorcode</th>\n",
       "      <th>source</th>\n",
       "      <th>status</th>\n",
       "      <th>supplementprojectflg</th>\n",
       "      <th>theme1</th>\n",
       "      <th>theme_namecode</th>\n",
       "      <th>themecode</th>\n",
       "      <th>totalamt</th>\n",
       "      <th>totalcommamt</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c780'}</td>\n",
       "      <td>1999</td>\n",
       "      <td>November</td>\n",
       "      <td>2013-11-12T00:00:00Z</td>\n",
       "      <td>FEDERAL DEMOCRATIC REPUBLIC OF ETHIOPIA</td>\n",
       "      <td>2018-07-07T00:00:00Z</td>\n",
       "      <td>Federal Democratic Republic of Ethiopia!$!ET</td>\n",
       "      <td>ET</td>\n",
       "      <td>Federal Democratic Republic of Ethiopia</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>...</td>\n",
       "      <td>ET,BS,ES,EP</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Name': 'Education for all', 'Percent': 100}</td>\n",
       "      <td>[{'name': 'Education for all', 'code': '65'}]</td>\n",
       "      <td>65</td>\n",
       "      <td>130000000</td>\n",
       "      <td>130000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P129828/ethi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c781'}</td>\n",
       "      <td>2015</td>\n",
       "      <td>November</td>\n",
       "      <td>2013-11-04T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF TUNISIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Tunisia!$!TN</td>\n",
       "      <td>TN</td>\n",
       "      <td>Republic of Tunisia</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>...</td>\n",
       "      <td>BZ,BS</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Name': 'Other economic management', 'Percent...</td>\n",
       "      <td>[{'name': 'Other economic management', 'code':...</td>\n",
       "      <td>54,24</td>\n",
       "      <td>0</td>\n",
       "      <td>4700000</td>\n",
       "      <td>http://www.worldbank.org/projects/P144674?lang=en</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    _id  approvalfy board_approval_month  \\\n",
       "0  {'$oid': '52b213b38594d8a2be17c780'}        1999             November   \n",
       "1  {'$oid': '52b213b38594d8a2be17c781'}        2015             November   \n",
       "\n",
       "      boardapprovaldate                                 borrower  \\\n",
       "0  2013-11-12T00:00:00Z  FEDERAL DEMOCRATIC REPUBLIC OF ETHIOPIA   \n",
       "1  2013-11-04T00:00:00Z                    GOVERNMENT OF TUNISIA   \n",
       "\n",
       "            closingdate                              country_namecode  \\\n",
       "0  2018-07-07T00:00:00Z  Federal Democratic Republic of Ethiopia!$!ET   \n",
       "1                   NaN                      Republic of Tunisia!$!TN   \n",
       "\n",
       "  countrycode                              countryname countryshortname  \\\n",
       "0          ET  Federal Democratic Republic of Ethiopia         Ethiopia   \n",
       "1          TN                      Republic of Tunisia          Tunisia   \n",
       "\n",
       "                         ...                           sectorcode source  \\\n",
       "0                        ...                          ET,BS,ES,EP   IBRD   \n",
       "1                        ...                                BZ,BS   IBRD   \n",
       "\n",
       "   status  supplementprojectflg  \\\n",
       "0  Active                     N   \n",
       "1  Active                     N   \n",
       "\n",
       "                                              theme1  \\\n",
       "0      {'Name': 'Education for all', 'Percent': 100}   \n",
       "1  {'Name': 'Other economic management', 'Percent...   \n",
       "\n",
       "                                      theme_namecode themecode   totalamt  \\\n",
       "0      [{'name': 'Education for all', 'code': '65'}]        65  130000000   \n",
       "1  [{'name': 'Other economic management', 'code':...     54,24          0   \n",
       "\n",
       "  totalcommamt                                                url  \n",
       "0    130000000  http://www.worldbank.org/projects/P129828/ethi...  \n",
       "1      4700000  http://www.worldbank.org/projects/P144674?lang=en  \n",
       "\n",
       "[2 rows x 50 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# load as Pandas dataframe\n",
    "sample_json_df = pd.read_json('world_bank_projects_less.json')\n",
    "sample_json_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "****\n",
    "## JSON exercise\n",
    "\n",
    "Using data in file 'data/world_bank_projects.json' and the techniques demonstrated above,\n",
    "1. Find the 10 countries with most projects\n",
    "2. Find the top 10 major project themes (using column 'mjtheme_namecode')\n",
    "3. In 2. above you will notice that some entries have only the code and the name is missing. Create a dataframe with the missing names filled in."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find the 10 countries with most projects"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>approvalfy</th>\n",
       "      <th>board_approval_month</th>\n",
       "      <th>boardapprovaldate</th>\n",
       "      <th>borrower</th>\n",
       "      <th>closingdate</th>\n",
       "      <th>country_namecode</th>\n",
       "      <th>countrycode</th>\n",
       "      <th>countryname</th>\n",
       "      <th>countryshortname</th>\n",
       "      <th>...</th>\n",
       "      <th>sectorcode</th>\n",
       "      <th>source</th>\n",
       "      <th>status</th>\n",
       "      <th>supplementprojectflg</th>\n",
       "      <th>theme1</th>\n",
       "      <th>theme_namecode</th>\n",
       "      <th>themecode</th>\n",
       "      <th>totalamt</th>\n",
       "      <th>totalcommamt</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c780'}</td>\n",
       "      <td>1999</td>\n",
       "      <td>November</td>\n",
       "      <td>2013-11-12T00:00:00Z</td>\n",
       "      <td>FEDERAL DEMOCRATIC REPUBLIC OF ETHIOPIA</td>\n",
       "      <td>2018-07-07T00:00:00Z</td>\n",
       "      <td>Federal Democratic Republic of Ethiopia!$!ET</td>\n",
       "      <td>ET</td>\n",
       "      <td>Federal Democratic Republic of Ethiopia</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>...</td>\n",
       "      <td>ET,BS,ES,EP</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Education for all'}</td>\n",
       "      <td>[{'code': '65', 'name': 'Education for all'}]</td>\n",
       "      <td>65</td>\n",
       "      <td>130000000</td>\n",
       "      <td>130000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P129828/ethi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c781'}</td>\n",
       "      <td>2015</td>\n",
       "      <td>November</td>\n",
       "      <td>2013-11-04T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF TUNISIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Tunisia!$!TN</td>\n",
       "      <td>TN</td>\n",
       "      <td>Republic of Tunisia</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>...</td>\n",
       "      <td>BZ,BS</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 30, 'Name': 'Other economic manage...</td>\n",
       "      <td>[{'code': '24', 'name': 'Other economic manage...</td>\n",
       "      <td>54,24</td>\n",
       "      <td>0</td>\n",
       "      <td>4700000</td>\n",
       "      <td>http://www.worldbank.org/projects/P144674?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c782'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>November</td>\n",
       "      <td>2013-11-01T00:00:00Z</td>\n",
       "      <td>MINISTRY OF FINANCE AND ECONOMIC DEVEL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tuvalu!$!TV</td>\n",
       "      <td>TV</td>\n",
       "      <td>Tuvalu</td>\n",
       "      <td>Tuvalu</td>\n",
       "      <td>...</td>\n",
       "      <td>TI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 46, 'Name': 'Regional integration'}</td>\n",
       "      <td>[{'code': '47', 'name': 'Regional integration'...</td>\n",
       "      <td>52,81,25,47</td>\n",
       "      <td>6060000</td>\n",
       "      <td>6060000</td>\n",
       "      <td>http://www.worldbank.org/projects/P145310?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c783'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-31T00:00:00Z</td>\n",
       "      <td>MIN. OF PLANNING AND INT'L COOPERATION</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Yemen!$!RY</td>\n",
       "      <td>RY</td>\n",
       "      <td>Republic of Yemen</td>\n",
       "      <td>Yemen, Republic of</td>\n",
       "      <td>...</td>\n",
       "      <td>JB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 50, 'Name': 'Participation and civ...</td>\n",
       "      <td>[{'code': '57', 'name': 'Participation and civ...</td>\n",
       "      <td>59,57</td>\n",
       "      <td>0</td>\n",
       "      <td>1500000</td>\n",
       "      <td>http://www.worldbank.org/projects/P144665?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c784'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-31T00:00:00Z</td>\n",
       "      <td>MINISTRY OF FINANCE</td>\n",
       "      <td>2019-04-30T00:00:00Z</td>\n",
       "      <td>Kingdom of Lesotho!$!LS</td>\n",
       "      <td>LS</td>\n",
       "      <td>Kingdom of Lesotho</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>...</td>\n",
       "      <td>FH,YW,YZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 30, 'Name': 'Export development an...</td>\n",
       "      <td>[{'code': '45', 'name': 'Export development an...</td>\n",
       "      <td>41,45</td>\n",
       "      <td>13100000</td>\n",
       "      <td>13100000</td>\n",
       "      <td>http://www.worldbank.org/projects/P144933/seco...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c785'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-31T00:00:00Z</td>\n",
       "      <td>REPUBLIC OF KENYA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Kenya!$!KE</td>\n",
       "      <td>KE</td>\n",
       "      <td>Republic of Kenya</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>...</td>\n",
       "      <td>JB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Social safety nets'}</td>\n",
       "      <td>[{'code': '54', 'name': 'Social safety nets'}]</td>\n",
       "      <td>54</td>\n",
       "      <td>10000000</td>\n",
       "      <td>10000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P146161?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c786'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-29T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF INDIA</td>\n",
       "      <td>2019-06-30T00:00:00Z</td>\n",
       "      <td>Republic of India!$!IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>Republic of India</td>\n",
       "      <td>India</td>\n",
       "      <td>...</td>\n",
       "      <td>TI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 20, 'Name': 'Administrative and ci...</td>\n",
       "      <td>[{'code': '25', 'name': 'Administrative and ci...</td>\n",
       "      <td>39,25</td>\n",
       "      <td>500000000</td>\n",
       "      <td>500000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P121185/firs...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c787'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-29T00:00:00Z</td>\n",
       "      <td>PEOPLE'S REPUBLIC OF CHINA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>People's Republic of China!$!CN</td>\n",
       "      <td>CN</td>\n",
       "      <td>People's Republic of China</td>\n",
       "      <td>China</td>\n",
       "      <td>...</td>\n",
       "      <td>LR</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Climate change'}</td>\n",
       "      <td>[{'code': '81', 'name': 'Climate change'}]</td>\n",
       "      <td>81</td>\n",
       "      <td>0</td>\n",
       "      <td>27280000</td>\n",
       "      <td>http://www.worldbank.org/projects/P127033/chin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c788'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-29T00:00:00Z</td>\n",
       "      <td>THE GOVERNMENT OF INDIA</td>\n",
       "      <td>2018-12-31T00:00:00Z</td>\n",
       "      <td>Republic of India!$!IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>Republic of India</td>\n",
       "      <td>India</td>\n",
       "      <td>...</td>\n",
       "      <td>TI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 87, 'Name': 'Other rural developme...</td>\n",
       "      <td>[{'code': '79', 'name': 'Other rural developme...</td>\n",
       "      <td>79</td>\n",
       "      <td>160000000</td>\n",
       "      <td>160000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P130164/raja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c789'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-29T00:00:00Z</td>\n",
       "      <td>THE KINGDOM OF MOROCCO</td>\n",
       "      <td>2014-12-31T00:00:00Z</td>\n",
       "      <td>Kingdom of Morocco!$!MA</td>\n",
       "      <td>MA</td>\n",
       "      <td>Kingdom of Morocco</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>...</td>\n",
       "      <td>BM,BC,BZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 33, 'Name': 'Other accountability/...</td>\n",
       "      <td>[{'code': '29', 'name': 'Other accountability/...</td>\n",
       "      <td>27,30,29</td>\n",
       "      <td>200000000</td>\n",
       "      <td>200000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P130903?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c78a'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-25T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF SOUTH SUDAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of South Sudan!$!SS</td>\n",
       "      <td>SS</td>\n",
       "      <td>Republic of South Sudan</td>\n",
       "      <td>South Sudan</td>\n",
       "      <td>...</td>\n",
       "      <td>AZ,JB,AH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Global food crisis r...</td>\n",
       "      <td>[{'code': '91', 'name': 'Global food crisis re...</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>7530000</td>\n",
       "      <td>http://www.worldbank.org/projects/P145339?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c78b'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-25T00:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-12-31T00:00:00Z</td>\n",
       "      <td>Republic of India!$!IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>Republic of India</td>\n",
       "      <td>India</td>\n",
       "      <td>...</td>\n",
       "      <td>JB,YC,WD,TI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 60, 'Name': 'Rural services and in...</td>\n",
       "      <td>[{'code': '78', 'name': 'Rural services and in...</td>\n",
       "      <td>81,87,52,78</td>\n",
       "      <td>250000000</td>\n",
       "      <td>250000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P146653?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c78c'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-24T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF GHANA</td>\n",
       "      <td>2019-06-30T00:00:00Z</td>\n",
       "      <td>Republic of Ghana!$!GH</td>\n",
       "      <td>GH</td>\n",
       "      <td>Republic of Ghana</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>...</td>\n",
       "      <td>CZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 0, 'Name': ''}</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>97000000</td>\n",
       "      <td>97000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P144140/gh-e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c78d'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-22T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF TIMOR LESTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic Republic of Timor-Leste!$!TP</td>\n",
       "      <td>TP</td>\n",
       "      <td>Democratic Republic of Timor-Leste</td>\n",
       "      <td>Timor-Leste</td>\n",
       "      <td>...</td>\n",
       "      <td>BV,TI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 20, 'Name': 'Regional integration'}</td>\n",
       "      <td>[{'code': '47', 'name': 'Regional integration'...</td>\n",
       "      <td>78,81,47</td>\n",
       "      <td>40000000</td>\n",
       "      <td>40000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P130975/timo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c78e'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-22T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF JORDAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hashemite Kingdom of Jordan!$!JO</td>\n",
       "      <td>JO</td>\n",
       "      <td>Hashemite Kingdom of Jordan</td>\n",
       "      <td>Jordan</td>\n",
       "      <td>...</td>\n",
       "      <td>JB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 50, 'Name': 'Social safety nets'}</td>\n",
       "      <td>[{'code': '54', 'name': 'Social safety nets'},...</td>\n",
       "      <td>53,56,54</td>\n",
       "      <td>0</td>\n",
       "      <td>9500000</td>\n",
       "      <td>http://www.worldbank.org/projects/P144832?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c78f'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-17T00:00:00Z</td>\n",
       "      <td>MINISTRY OF FINANCE</td>\n",
       "      <td>2019-04-30T00:00:00Z</td>\n",
       "      <td>Samoa!$!WS</td>\n",
       "      <td>WS</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>...</td>\n",
       "      <td>TI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 60, 'Name': 'Rural services and in...</td>\n",
       "      <td>[{'code': '78', 'name': 'Rural services and in...</td>\n",
       "      <td>49,81,78</td>\n",
       "      <td>20000000</td>\n",
       "      <td>20000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P145545?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c790'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-17T00:00:00Z</td>\n",
       "      <td>MINISTRY OF FINANCE</td>\n",
       "      <td>2015-12-31T00:00:00Z</td>\n",
       "      <td>Samoa!$!WS</td>\n",
       "      <td>WS</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>...</td>\n",
       "      <td>AZ,AJ,AH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Other rural developm...</td>\n",
       "      <td>[{'code': '79', 'name': 'Other rural developme...</td>\n",
       "      <td>79</td>\n",
       "      <td>5000000</td>\n",
       "      <td>5000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P145938?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c791'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-16T00:00:00Z</td>\n",
       "      <td>MINISTRY OF FINANCE AND BUDGET (MFB)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Madagascar!$!MG</td>\n",
       "      <td>MG</td>\n",
       "      <td>Republic of Madagascar</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>...</td>\n",
       "      <td>EP</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Education for all'}</td>\n",
       "      <td>[{'code': '65', 'name': 'Education for all'}]</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>85400000</td>\n",
       "      <td>http://www.worldbank.org/projects/P132616?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c792'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-16T00:00:00Z</td>\n",
       "      <td>ROYAL GOVERNMENT OF CAMBODIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kingdom of Cambodia!$!KH</td>\n",
       "      <td>KH</td>\n",
       "      <td>Kingdom of Cambodia</td>\n",
       "      <td>Cambodia</td>\n",
       "      <td>...</td>\n",
       "      <td>BK,JB,BH,BC,JA</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 17, 'Name': 'Child health'}</td>\n",
       "      <td>[{'code': '63', 'name': 'Child health'}, {'cod...</td>\n",
       "      <td>69,57,25,67,63</td>\n",
       "      <td>0</td>\n",
       "      <td>13450000</td>\n",
       "      <td>http://www.worldbank.org/projects/P146271?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c793'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-10T00:00:00Z</td>\n",
       "      <td>MINISTRY OF FINANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kingdom of Morocco!$!MA</td>\n",
       "      <td>MA</td>\n",
       "      <td>Kingdom of Morocco</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>...</td>\n",
       "      <td>BH,BC,BZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 40, 'Name': 'Public expenditure, f...</td>\n",
       "      <td>[{'code': '27', 'name': 'Public expenditure, f...</td>\n",
       "      <td>25,26,27</td>\n",
       "      <td>0</td>\n",
       "      <td>4350000</td>\n",
       "      <td>http://www.worldbank.org/projects/P143979?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c794'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-09T00:00:00Z</td>\n",
       "      <td>AGA KHAN DEVELOPMENT NETWORK (AKDN)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kyrgyz Republic!$!KG</td>\n",
       "      <td>KG</td>\n",
       "      <td>Kyrgyz Republic</td>\n",
       "      <td>Kyrgyz Republic</td>\n",
       "      <td>...</td>\n",
       "      <td>JB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 50, 'Name': 'Conflict prevention a...</td>\n",
       "      <td>[{'code': '58', 'name': 'Conflict prevention a...</td>\n",
       "      <td>57,58</td>\n",
       "      <td>0</td>\n",
       "      <td>2000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P132577?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c795'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-07T00:00:00Z</td>\n",
       "      <td>NEPAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nepal!$!NP</td>\n",
       "      <td>NP</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>...</td>\n",
       "      <td>BH,YW,JB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 30, 'Name': 'Urban services and ho...</td>\n",
       "      <td>[{'code': '71', 'name': 'Urban services and ho...</td>\n",
       "      <td>57,71</td>\n",
       "      <td>0</td>\n",
       "      <td>2750000</td>\n",
       "      <td>http://www.worldbank.org/projects/P145359?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c796'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-07T00:00:00Z</td>\n",
       "      <td>MINISTRY OF PLANNING AND INTERNATIONAL C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hashemite Kingdom of Jordan!$!JO</td>\n",
       "      <td>JO</td>\n",
       "      <td>Hashemite Kingdom of Jordan</td>\n",
       "      <td>Jordan</td>\n",
       "      <td>...</td>\n",
       "      <td>WC,BS,BH,TZ,WB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 25, 'Name': 'Other social developm...</td>\n",
       "      <td>[{'code': '62', 'name': 'Other social developm...</td>\n",
       "      <td>58,62</td>\n",
       "      <td>0</td>\n",
       "      <td>50000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P147689?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c797'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>October</td>\n",
       "      <td>2013-10-03T00:00:00Z</td>\n",
       "      <td>REPUBLIC OF TAJIKISTAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Tajikistan!$!TJ</td>\n",
       "      <td>TJ</td>\n",
       "      <td>Republic of Tajikistan</td>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>...</td>\n",
       "      <td>JA</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 60, 'Name': 'Nutrition and food se...</td>\n",
       "      <td>[{'code': '68', 'name': 'Nutrition and food se...</td>\n",
       "      <td>63,68</td>\n",
       "      <td>0</td>\n",
       "      <td>2800000</td>\n",
       "      <td>http://www.worldbank.org/projects/P146109?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c798'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>September</td>\n",
       "      <td>2013-09-30T00:00:00Z</td>\n",
       "      <td>REPUBLIC OF AZERBAIJAN</td>\n",
       "      <td>2018-12-31T00:00:00Z</td>\n",
       "      <td>Republic of Azerbaijan!$!AZ</td>\n",
       "      <td>AZ</td>\n",
       "      <td>Republic of Azerbaijan</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>...</td>\n",
       "      <td>AB,AZ,YA</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 30, 'Name': 'Rural markets'}</td>\n",
       "      <td>[{'code': '75', 'name': 'Rural markets'}, {'co...</td>\n",
       "      <td>56,78,76,75</td>\n",
       "      <td>34500000</td>\n",
       "      <td>34500000</td>\n",
       "      <td>http://www.worldbank.org/projects/P122812/thir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c799'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>September</td>\n",
       "      <td>2013-09-30T00:00:00Z</td>\n",
       "      <td>UNIVERSITY OF QUEENSLAND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>East Asia and Pacific!$!4E</td>\n",
       "      <td>4E</td>\n",
       "      <td>East Asia and Pacific</td>\n",
       "      <td>East Asia and Pacific</td>\n",
       "      <td>...</td>\n",
       "      <td>AB,AZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 40, 'Name': 'Other environment and...</td>\n",
       "      <td>[{'code': '86', 'name': 'Other environment and...</td>\n",
       "      <td>80,81,86</td>\n",
       "      <td>0</td>\n",
       "      <td>4500000</td>\n",
       "      <td>http://www.worldbank.org/projects/P123933/capt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c79a'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>September</td>\n",
       "      <td>2013-09-30T00:00:00Z</td>\n",
       "      <td>LAO PEOPLES DEMOCRATIC REPUBLIC</td>\n",
       "      <td>2014-03-31T00:00:00Z</td>\n",
       "      <td>Lao People's Democratic Republic!$!LA</td>\n",
       "      <td>LA</td>\n",
       "      <td>Lao People's Democratic Republic</td>\n",
       "      <td>Lao People's Democratic Republic</td>\n",
       "      <td>...</td>\n",
       "      <td>LG,FB,EZ,YZ,BC</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Closed</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 14, 'Name': 'Regulation and compet...</td>\n",
       "      <td>[{'code': '40', 'name': 'Regulation and compet...</td>\n",
       "      <td>67,27,49,40</td>\n",
       "      <td>20000000</td>\n",
       "      <td>20000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P143025/lao-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c79b'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>September</td>\n",
       "      <td>2013-09-30T00:00:00Z</td>\n",
       "      <td>PACIFIC AVIATION SECURITY OFFICE</td>\n",
       "      <td>2018-12-31T00:00:00Z</td>\n",
       "      <td>Pacific Islands!$!4P</td>\n",
       "      <td>4P</td>\n",
       "      <td>Pacific Islands</td>\n",
       "      <td>Pacific Islands</td>\n",
       "      <td>...</td>\n",
       "      <td>BV,TV</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 5, 'Name': 'Climate change'}</td>\n",
       "      <td>[{'code': '81', 'name': 'Climate change'}, {'c...</td>\n",
       "      <td>52,47,25,81</td>\n",
       "      <td>2150000</td>\n",
       "      <td>2150000</td>\n",
       "      <td>http://www.worldbank.org/projects/P145057/paci...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c79c'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>September</td>\n",
       "      <td>2013-09-30T00:00:00Z</td>\n",
       "      <td>SOLOMON ISLANDS GOVERNMENT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Solomon Islands!$!SB</td>\n",
       "      <td>SB</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>Solomon Islands</td>\n",
       "      <td>...</td>\n",
       "      <td>BZ,AZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 30, 'Name': 'Rural policies and in...</td>\n",
       "      <td>[{'code': '77', 'name': 'Rural policies and in...</td>\n",
       "      <td>57,78,77</td>\n",
       "      <td>3000000</td>\n",
       "      <td>3000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P146021?lang=en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c79d'}</td>\n",
       "      <td>2014</td>\n",
       "      <td>September</td>\n",
       "      <td>2013-09-27T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF MOZAMBIQUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Mozambique!$!MZ</td>\n",
       "      <td>MZ</td>\n",
       "      <td>Republic of Mozambique</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>...</td>\n",
       "      <td>JB,BW,WZ,WD</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 4, 'Name': 'Other social developme...</td>\n",
       "      <td>[{'code': '62', 'name': 'Other social developm...</td>\n",
       "      <td>85,62</td>\n",
       "      <td>32000000</td>\n",
       "      <td>32000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P146098?lang=en</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>470</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c956'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-20T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF LIBERIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Liberia!$!LR</td>\n",
       "      <td>LR</td>\n",
       "      <td>Republic of Liberia</td>\n",
       "      <td>Liberia</td>\n",
       "      <td>...</td>\n",
       "      <td>BV,TI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 40, 'Name': 'Trade facilitation an...</td>\n",
       "      <td>[{'code': '49', 'name': 'Trade facilitation an...</td>\n",
       "      <td>78,49</td>\n",
       "      <td>50000000</td>\n",
       "      <td>50000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P129654/libe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c957'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-20T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF BANGLADESH</td>\n",
       "      <td>2018-12-31T00:00:00Z</td>\n",
       "      <td>People's Republic of Bangladesh!$!BD</td>\n",
       "      <td>BD</td>\n",
       "      <td>People's Republic of Bangladesh</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>...</td>\n",
       "      <td>BU,LA,LR</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 45, 'Name': 'Rural services and in...</td>\n",
       "      <td>[{'code': '78', 'name': 'Rural services and in...</td>\n",
       "      <td>59,81,57,78</td>\n",
       "      <td>155000000</td>\n",
       "      <td>155000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P131263/rura...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c958'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-13T00:00:00Z</td>\n",
       "      <td>MINISTRY OF NATURE PROTECTION</td>\n",
       "      <td>2014-09-30T00:00:00Z</td>\n",
       "      <td>Republic of Armenia!$!AM</td>\n",
       "      <td>AM</td>\n",
       "      <td>Republic of Armenia</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>...</td>\n",
       "      <td>BC</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Other environment an...</td>\n",
       "      <td>[{'code': '86', 'name': 'Other environment and...</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>150000</td>\n",
       "      <td>http://www.worldbank.org/projects/P131631/repo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c959'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-13T00:00:00Z</td>\n",
       "      <td>MINISTRY OF ENVIRONMENT, FORESTS, WATER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Albania!$!AL</td>\n",
       "      <td>AL</td>\n",
       "      <td>Republic of Albania</td>\n",
       "      <td>Albania</td>\n",
       "      <td>...</td>\n",
       "      <td>BC</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Other environment an...</td>\n",
       "      <td>[{'code': '86', 'name': 'Other environment and...</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>150000</td>\n",
       "      <td>http://www.worldbank.org/projects/P132679/land...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c95a'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-11T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF PAKISTAN</td>\n",
       "      <td>2017-06-30T00:00:00Z</td>\n",
       "      <td>Islamic Republic of Pakistan!$!PK</td>\n",
       "      <td>PK</td>\n",
       "      <td>Islamic Republic of Pakistan</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>...</td>\n",
       "      <td>BM,BH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 34, 'Name': 'Municipal finance'}</td>\n",
       "      <td>[{'code': '72', 'name': 'Municipal finance'}, ...</td>\n",
       "      <td>73,72</td>\n",
       "      <td>150000000</td>\n",
       "      <td>150000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P112901/pk-p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c95b'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-11T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF INDONESIA</td>\n",
       "      <td>2018-03-31T00:00:00Z</td>\n",
       "      <td>Republic of Indonesia!$!ID</td>\n",
       "      <td>ID</td>\n",
       "      <td>Republic of Indonesia</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>...</td>\n",
       "      <td>BO,BH,LZ,TZ,WZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 25, 'Name': 'Infrastructure servic...</td>\n",
       "      <td>[{'code': '39', 'name': 'Infrastructure servic...</td>\n",
       "      <td>72,39</td>\n",
       "      <td>29600000</td>\n",
       "      <td>29600000</td>\n",
       "      <td>http://www.worldbank.org/projects/P118916/infr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c95c'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-11T00:00:00Z</td>\n",
       "      <td>SOCIALIST REPUBLIC OF VIETNAM</td>\n",
       "      <td>2018-12-31T00:00:00Z</td>\n",
       "      <td>Socialist Republic of Vietnam!$!VN</td>\n",
       "      <td>VN</td>\n",
       "      <td>Socialist Republic of Vietnam</td>\n",
       "      <td>Vietnam</td>\n",
       "      <td>...</td>\n",
       "      <td>BU,LT,LA</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Rural services and i...</td>\n",
       "      <td>[{'code': '78', 'name': 'Rural services and in...</td>\n",
       "      <td>78</td>\n",
       "      <td>448900000</td>\n",
       "      <td>448900000</td>\n",
       "      <td>http://www.worldbank.org/projects/P125996/dist...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c95d'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-11T00:00:00Z</td>\n",
       "      <td>REPUBLIC OF UZBEKISTAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republic of Uzbekistan!$!UZ</td>\n",
       "      <td>UZ</td>\n",
       "      <td>Republic of Uzbekistan</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>...</td>\n",
       "      <td>FH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 40, 'Name': 'Micro, Small and Medi...</td>\n",
       "      <td>[{'code': '41', 'name': 'Micro, Small and Medi...</td>\n",
       "      <td>75,41</td>\n",
       "      <td>40000000</td>\n",
       "      <td>40000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P126962/addi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c95e'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-11T00:00:00Z</td>\n",
       "      <td>ISLAMIC REPUBLIC OF PAKISTAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Islamic Republic of Pakistan!$!PK</td>\n",
       "      <td>PK</td>\n",
       "      <td>Islamic Republic of Pakistan</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>...</td>\n",
       "      <td>BH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 10, 'Name': 'Administrative and ci...</td>\n",
       "      <td>[{'code': '25', 'name': 'Administrative and ci...</td>\n",
       "      <td>83,36,25</td>\n",
       "      <td>70000000</td>\n",
       "      <td>70000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P131266/punj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c95f'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-10T00:00:00Z</td>\n",
       "      <td>UT'Z CHE</td>\n",
       "      <td>2016-05-07T00:00:00Z</td>\n",
       "      <td>Republic of Guatemala!$!GT</td>\n",
       "      <td>GT</td>\n",
       "      <td>Republic of Guatemala</td>\n",
       "      <td>Guatemala</td>\n",
       "      <td>...</td>\n",
       "      <td>AZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Other social develop...</td>\n",
       "      <td>[{'code': '62', 'name': 'Other social developm...</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>2510000</td>\n",
       "      <td>http://www.worldbank.org/projects/P130412/stre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c960'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-10T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF ZAMBIA</td>\n",
       "      <td>2014-12-31T00:00:00Z</td>\n",
       "      <td>Republic of Zambia!$!ZM</td>\n",
       "      <td>ZM</td>\n",
       "      <td>Republic of Zambia</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>...</td>\n",
       "      <td>LS</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Other public sector ...</td>\n",
       "      <td>[{'code': '30', 'name': 'Other public sector g...</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>350000</td>\n",
       "      <td>http://www.worldbank.org/projects/P131881/zamb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c961'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-06T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF INDIA</td>\n",
       "      <td>2015-12-31T00:00:00Z</td>\n",
       "      <td>Republic of India!$!IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>Republic of India</td>\n",
       "      <td>India</td>\n",
       "      <td>...</td>\n",
       "      <td>BC,EC,BQ,BH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 23, 'Name': 'Child health'}</td>\n",
       "      <td>[{'code': '63', 'name': 'Child health'}, {'cod...</td>\n",
       "      <td>68,59,57,63</td>\n",
       "      <td>106000000</td>\n",
       "      <td>106000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P121731/icds...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c962'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-06T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF INDIA</td>\n",
       "      <td>2018-12-31T00:00:00Z</td>\n",
       "      <td>Republic of India!$!IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>Republic of India</td>\n",
       "      <td>India</td>\n",
       "      <td>...</td>\n",
       "      <td>AI,YA,AH,BL,AB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 10, 'Name': 'Rural services and in...</td>\n",
       "      <td>[{'code': '78', 'name': 'Rural services and in...</td>\n",
       "      <td>79,85,86,78</td>\n",
       "      <td>60000000</td>\n",
       "      <td>60000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P122486/karn...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c963'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-06T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF INDIA</td>\n",
       "      <td>2013-09-30T00:00:00Z</td>\n",
       "      <td>Republic of India!$!IN</td>\n",
       "      <td>IN</td>\n",
       "      <td>Republic of India</td>\n",
       "      <td>India</td>\n",
       "      <td>...</td>\n",
       "      <td>CZ,AH,LA,AI,LH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Closed</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 19, 'Name': 'Pollution management ...</td>\n",
       "      <td>[{'code': '84', 'name': 'Pollution management ...</td>\n",
       "      <td>82,78,81,84</td>\n",
       "      <td>100000000</td>\n",
       "      <td>100000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P124041/hima...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c964'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-06T00:00:00Z</td>\n",
       "      <td>ILO, MINLAND &amp; CFSI &amp; BANK</td>\n",
       "      <td>2015-12-31T00:00:00Z</td>\n",
       "      <td>Republic of the Philippines!$!PH</td>\n",
       "      <td>PH</td>\n",
       "      <td>Republic of the Philippines</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>...</td>\n",
       "      <td>EV,FH,BZ,JB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>Y</td>\n",
       "      <td>{'Percent': 9, 'Name': 'Rural non-farm income ...</td>\n",
       "      <td>[{'code': '76', 'name': 'Rural non-farm income...</td>\n",
       "      <td>78,58,41,76</td>\n",
       "      <td>0</td>\n",
       "      <td>5570000</td>\n",
       "      <td>http://www.worldbank.org/projects/P132238/mult...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c965'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-05T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF MONGOLIA</td>\n",
       "      <td>2013-12-31T00:00:00Z</td>\n",
       "      <td>Mongolia!$!MN</td>\n",
       "      <td>MN</td>\n",
       "      <td>Mongolia</td>\n",
       "      <td>Mongolia</td>\n",
       "      <td>...</td>\n",
       "      <td>BZ,JA,AJ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Other communicable d...</td>\n",
       "      <td>[{'code': '64', 'name': 'Other communicable di...</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>2900000</td>\n",
       "      <td>http://www.worldbank.org/projects/P131204/capa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c966'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>September</td>\n",
       "      <td>2012-09-01T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF LEBANON &amp; JORDAN</td>\n",
       "      <td>2015-01-31T00:00:00Z</td>\n",
       "      <td>Middle East and North Africa!$!5M</td>\n",
       "      <td>5M</td>\n",
       "      <td>Middle East and North Africa</td>\n",
       "      <td>Middle East and North Africa</td>\n",
       "      <td>...</td>\n",
       "      <td>BZ,BS,BQ,BN</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 25, 'Name': 'Other public sector g...</td>\n",
       "      <td>[{'code': '30', 'name': 'Other public sector g...</td>\n",
       "      <td>54,55,56,30</td>\n",
       "      <td>0</td>\n",
       "      <td>2400000</td>\n",
       "      <td>http://www.worldbank.org/projects/P132097/5m-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c967'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-30T00:00:00Z</td>\n",
       "      <td>UNITED MEXICAN STATES</td>\n",
       "      <td>2017-08-31T00:00:00Z</td>\n",
       "      <td>United Mexican States!$!MX</td>\n",
       "      <td>MX</td>\n",
       "      <td>United Mexican States</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>...</td>\n",
       "      <td>YA,BL,AB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 20, 'Name': 'Biodiversity'}</td>\n",
       "      <td>[{'code': '80', 'name': 'Biodiversity'}, {'cod...</td>\n",
       "      <td>82,79,77,80</td>\n",
       "      <td>0</td>\n",
       "      <td>11690000</td>\n",
       "      <td>http://www.worldbank.org/projects/P121116/sust...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c968'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-30T00:00:00Z</td>\n",
       "      <td>THE STATE OF RIO DE JANEIRO</td>\n",
       "      <td>2014-01-31T00:00:00Z</td>\n",
       "      <td>Federative Republic of Brazil!$!BR</td>\n",
       "      <td>BR</td>\n",
       "      <td>Federative Republic of Brazil</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>...</td>\n",
       "      <td>JA,EZ,BH</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Closed</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 20, 'Name': 'Health system perform...</td>\n",
       "      <td>[{'code': '67', 'name': 'Health system perform...</td>\n",
       "      <td>65,28,27,67</td>\n",
       "      <td>300000000</td>\n",
       "      <td>300000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P126465/rio-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c969'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-30T00:00:00Z</td>\n",
       "      <td>UN-HABITAT</td>\n",
       "      <td>2015-06-30T00:00:00Z</td>\n",
       "      <td>The Independent State of Papua New Guine!$!PG</td>\n",
       "      <td>PG</td>\n",
       "      <td>The Independent State of Papua New Guine</td>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>...</td>\n",
       "      <td>BW</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Closed</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 50, 'Name': 'Urban services and ho...</td>\n",
       "      <td>[{'code': '71', 'name': 'Urban services and ho...</td>\n",
       "      <td>73,55,52,71</td>\n",
       "      <td>0</td>\n",
       "      <td>350000</td>\n",
       "      <td>http://www.worldbank.org/projects/P128763/papu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c96a'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-29T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF NEPAL</td>\n",
       "      <td>2014-06-30T00:00:00Z</td>\n",
       "      <td>Nepal!$!NP</td>\n",
       "      <td>NP</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>...</td>\n",
       "      <td>BZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 80, 'Name': 'Public expenditure, f...</td>\n",
       "      <td>[{'code': '27', 'name': 'Public expenditure, f...</td>\n",
       "      <td>29,27</td>\n",
       "      <td>0</td>\n",
       "      <td>800000</td>\n",
       "      <td>http://www.worldbank.org/projects/P131860/stre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c96b'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-24T00:00:00Z</td>\n",
       "      <td>PALESTINIAN WATER AUTHORITY</td>\n",
       "      <td>2014-03-31T00:00:00Z</td>\n",
       "      <td>West Bank and Gaza!$!GZ</td>\n",
       "      <td>GZ</td>\n",
       "      <td>West Bank and Gaza</td>\n",
       "      <td>West Bank and Gaza</td>\n",
       "      <td>...</td>\n",
       "      <td>WC,WA</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Rural services and i...</td>\n",
       "      <td>[{'code': '78', 'name': 'Rural services and in...</td>\n",
       "      <td>78</td>\n",
       "      <td>0</td>\n",
       "      <td>3650000</td>\n",
       "      <td>http://www.worldbank.org/projects/P123322/wate...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c96c'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-21T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF PAKISTAN</td>\n",
       "      <td>2015-06-30T00:00:00Z</td>\n",
       "      <td>Islamic Republic of Pakistan!$!PK</td>\n",
       "      <td>PK</td>\n",
       "      <td>Islamic Republic of Pakistan</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>...</td>\n",
       "      <td>EP</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 70, 'Name': 'Education for all'}</td>\n",
       "      <td>[{'code': '65', 'name': 'Education for all'}, ...</td>\n",
       "      <td>59,65</td>\n",
       "      <td>0</td>\n",
       "      <td>10000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P128096/paki...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c96d'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-21T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF BANGLADESH</td>\n",
       "      <td>2015-04-30T00:00:00Z</td>\n",
       "      <td>People's Republic of Bangladesh!$!BD</td>\n",
       "      <td>BD</td>\n",
       "      <td>People's Republic of Bangladesh</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>...</td>\n",
       "      <td>BC</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Other environment an...</td>\n",
       "      <td>[{'code': '86', 'name': 'Other environment and...</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>150000</td>\n",
       "      <td>http://www.worldbank.org/projects/P132138/revi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c96e'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-17T00:00:00Z</td>\n",
       "      <td>MINISTRY OF EDUCATION</td>\n",
       "      <td>2014-06-30T00:00:00Z</td>\n",
       "      <td>Nepal!$!NP</td>\n",
       "      <td>NP</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>...</td>\n",
       "      <td>EZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Natural disaster man...</td>\n",
       "      <td>[{'code': '52', 'name': 'Natural disaster mana...</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>1510000</td>\n",
       "      <td>http://www.worldbank.org/projects/P129177/nepa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c96f'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-10T00:00:00Z</td>\n",
       "      <td>THE COMPETITIVENESS COMPANY</td>\n",
       "      <td>2013-08-31T00:00:00Z</td>\n",
       "      <td>Jamaica!$!JM</td>\n",
       "      <td>JM</td>\n",
       "      <td>Jamaica</td>\n",
       "      <td>Jamaica</td>\n",
       "      <td>...</td>\n",
       "      <td>EV,AZ</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Closed</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 50, 'Name': 'Regulation and compet...</td>\n",
       "      <td>[{'code': '40', 'name': 'Regulation and compet...</td>\n",
       "      <td>62,40</td>\n",
       "      <td>0</td>\n",
       "      <td>50000</td>\n",
       "      <td>http://www.worldbank.org/projects/P127299/tech...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c970'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-09T00:00:00Z</td>\n",
       "      <td>LAO PEOPLES DEMOCRATIC REPUBLIC</td>\n",
       "      <td>2012-12-31T00:00:00Z</td>\n",
       "      <td>Lao People's Democratic Republic!$!LA</td>\n",
       "      <td>LA</td>\n",
       "      <td>Lao People's Democratic Republic</td>\n",
       "      <td>Lao People's Democratic Republic</td>\n",
       "      <td>...</td>\n",
       "      <td>YZ,JA,EZ,FZ,BC</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Closed</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 14, 'Name': 'Child health'}</td>\n",
       "      <td>[{'code': '63', 'name': 'Child health'}, {'cod...</td>\n",
       "      <td>65,27,49,63</td>\n",
       "      <td>20000000</td>\n",
       "      <td>20000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P125298/lao-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c971'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-03T00:00:00Z</td>\n",
       "      <td>GOVERNMENT OF THE REPUBLIC OF GUINEA</td>\n",
       "      <td>2014-12-31T00:00:00Z</td>\n",
       "      <td>Republic of Guinea!$!GN</td>\n",
       "      <td>GN</td>\n",
       "      <td>Republic of Guinea</td>\n",
       "      <td>Guinea</td>\n",
       "      <td>...</td>\n",
       "      <td>AB,AH,AI</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 100, 'Name': 'Global food crisis r...</td>\n",
       "      <td>[{'code': '91', 'name': 'Global food crisis re...</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>20000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P128309/seco...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c972'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-02T00:00:00Z</td>\n",
       "      <td>REPUBLIC OF INDONESIA</td>\n",
       "      <td>2017-09-30T00:00:00Z</td>\n",
       "      <td>Republic of Indonesia!$!ID</td>\n",
       "      <td>ID</td>\n",
       "      <td>Republic of Indonesia</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>...</td>\n",
       "      <td>YA,BL,AB</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 85, 'Name': 'Rural services and in...</td>\n",
       "      <td>[{'code': '78', 'name': 'Rural services and in...</td>\n",
       "      <td>77,91,78</td>\n",
       "      <td>80000000</td>\n",
       "      <td>80000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P117243/sust...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>{'$oid': '52b213b38594d8a2be17c973'}</td>\n",
       "      <td>2013</td>\n",
       "      <td>August</td>\n",
       "      <td>2012-08-02T00:00:00Z</td>\n",
       "      <td>GOVERMENT OF KENYA</td>\n",
       "      <td>2018-12-31T00:00:00Z</td>\n",
       "      <td>Republic of Kenya!$!KE</td>\n",
       "      <td>KE</td>\n",
       "      <td>Republic of Kenya</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>...</td>\n",
       "      <td>BV,TC</td>\n",
       "      <td>IBRD</td>\n",
       "      <td>Active</td>\n",
       "      <td>N</td>\n",
       "      <td>{'Percent': 1, 'Name': 'Municipal governance a...</td>\n",
       "      <td>[{'code': '73', 'name': 'Municipal governance ...</td>\n",
       "      <td>39,49,88,73</td>\n",
       "      <td>300000000</td>\n",
       "      <td>300000000</td>\n",
       "      <td>http://www.worldbank.org/projects/P126321/keny...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>500 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      _id  approvalfy board_approval_month  \\\n",
       "0    {'$oid': '52b213b38594d8a2be17c780'}        1999             November   \n",
       "1    {'$oid': '52b213b38594d8a2be17c781'}        2015             November   \n",
       "2    {'$oid': '52b213b38594d8a2be17c782'}        2014             November   \n",
       "3    {'$oid': '52b213b38594d8a2be17c783'}        2014              October   \n",
       "4    {'$oid': '52b213b38594d8a2be17c784'}        2014              October   \n",
       "5    {'$oid': '52b213b38594d8a2be17c785'}        2014              October   \n",
       "6    {'$oid': '52b213b38594d8a2be17c786'}        2014              October   \n",
       "7    {'$oid': '52b213b38594d8a2be17c787'}        2014              October   \n",
       "8    {'$oid': '52b213b38594d8a2be17c788'}        2014              October   \n",
       "9    {'$oid': '52b213b38594d8a2be17c789'}        2014              October   \n",
       "10   {'$oid': '52b213b38594d8a2be17c78a'}        2014              October   \n",
       "11   {'$oid': '52b213b38594d8a2be17c78b'}        2014              October   \n",
       "12   {'$oid': '52b213b38594d8a2be17c78c'}        2014              October   \n",
       "13   {'$oid': '52b213b38594d8a2be17c78d'}        2014              October   \n",
       "14   {'$oid': '52b213b38594d8a2be17c78e'}        2014              October   \n",
       "15   {'$oid': '52b213b38594d8a2be17c78f'}        2014              October   \n",
       "16   {'$oid': '52b213b38594d8a2be17c790'}        2014              October   \n",
       "17   {'$oid': '52b213b38594d8a2be17c791'}        2014              October   \n",
       "18   {'$oid': '52b213b38594d8a2be17c792'}        2014              October   \n",
       "19   {'$oid': '52b213b38594d8a2be17c793'}        2014              October   \n",
       "20   {'$oid': '52b213b38594d8a2be17c794'}        2014              October   \n",
       "21   {'$oid': '52b213b38594d8a2be17c795'}        2014              October   \n",
       "22   {'$oid': '52b213b38594d8a2be17c796'}        2014              October   \n",
       "23   {'$oid': '52b213b38594d8a2be17c797'}        2014              October   \n",
       "24   {'$oid': '52b213b38594d8a2be17c798'}        2014            September   \n",
       "25   {'$oid': '52b213b38594d8a2be17c799'}        2014            September   \n",
       "26   {'$oid': '52b213b38594d8a2be17c79a'}        2014            September   \n",
       "27   {'$oid': '52b213b38594d8a2be17c79b'}        2014            September   \n",
       "28   {'$oid': '52b213b38594d8a2be17c79c'}        2014            September   \n",
       "29   {'$oid': '52b213b38594d8a2be17c79d'}        2014            September   \n",
       "..                                    ...         ...                  ...   \n",
       "470  {'$oid': '52b213b38594d8a2be17c956'}        2013            September   \n",
       "471  {'$oid': '52b213b38594d8a2be17c957'}        2013            September   \n",
       "472  {'$oid': '52b213b38594d8a2be17c958'}        2013            September   \n",
       "473  {'$oid': '52b213b38594d8a2be17c959'}        2013            September   \n",
       "474  {'$oid': '52b213b38594d8a2be17c95a'}        2013            September   \n",
       "475  {'$oid': '52b213b38594d8a2be17c95b'}        2013            September   \n",
       "476  {'$oid': '52b213b38594d8a2be17c95c'}        2013            September   \n",
       "477  {'$oid': '52b213b38594d8a2be17c95d'}        2013            September   \n",
       "478  {'$oid': '52b213b38594d8a2be17c95e'}        2013            September   \n",
       "479  {'$oid': '52b213b38594d8a2be17c95f'}        2013            September   \n",
       "480  {'$oid': '52b213b38594d8a2be17c960'}        2013            September   \n",
       "481  {'$oid': '52b213b38594d8a2be17c961'}        2013            September   \n",
       "482  {'$oid': '52b213b38594d8a2be17c962'}        2013            September   \n",
       "483  {'$oid': '52b213b38594d8a2be17c963'}        2013            September   \n",
       "484  {'$oid': '52b213b38594d8a2be17c964'}        2013            September   \n",
       "485  {'$oid': '52b213b38594d8a2be17c965'}        2013            September   \n",
       "486  {'$oid': '52b213b38594d8a2be17c966'}        2013            September   \n",
       "487  {'$oid': '52b213b38594d8a2be17c967'}        2013               August   \n",
       "488  {'$oid': '52b213b38594d8a2be17c968'}        2013               August   \n",
       "489  {'$oid': '52b213b38594d8a2be17c969'}        2013               August   \n",
       "490  {'$oid': '52b213b38594d8a2be17c96a'}        2013               August   \n",
       "491  {'$oid': '52b213b38594d8a2be17c96b'}        2013               August   \n",
       "492  {'$oid': '52b213b38594d8a2be17c96c'}        2013               August   \n",
       "493  {'$oid': '52b213b38594d8a2be17c96d'}        2013               August   \n",
       "494  {'$oid': '52b213b38594d8a2be17c96e'}        2013               August   \n",
       "495  {'$oid': '52b213b38594d8a2be17c96f'}        2013               August   \n",
       "496  {'$oid': '52b213b38594d8a2be17c970'}        2013               August   \n",
       "497  {'$oid': '52b213b38594d8a2be17c971'}        2013               August   \n",
       "498  {'$oid': '52b213b38594d8a2be17c972'}        2013               August   \n",
       "499  {'$oid': '52b213b38594d8a2be17c973'}        2013               August   \n",
       "\n",
       "        boardapprovaldate                                  borrower  \\\n",
       "0    2013-11-12T00:00:00Z   FEDERAL DEMOCRATIC REPUBLIC OF ETHIOPIA   \n",
       "1    2013-11-04T00:00:00Z                     GOVERNMENT OF TUNISIA   \n",
       "2    2013-11-01T00:00:00Z    MINISTRY OF FINANCE AND ECONOMIC DEVEL   \n",
       "3    2013-10-31T00:00:00Z    MIN. OF PLANNING AND INT'L COOPERATION   \n",
       "4    2013-10-31T00:00:00Z                       MINISTRY OF FINANCE   \n",
       "5    2013-10-31T00:00:00Z                         REPUBLIC OF KENYA   \n",
       "6    2013-10-29T00:00:00Z                       GOVERNMENT OF INDIA   \n",
       "7    2013-10-29T00:00:00Z                PEOPLE'S REPUBLIC OF CHINA   \n",
       "8    2013-10-29T00:00:00Z                   THE GOVERNMENT OF INDIA   \n",
       "9    2013-10-29T00:00:00Z                    THE KINGDOM OF MOROCCO   \n",
       "10   2013-10-25T00:00:00Z                 GOVERNMENT OF SOUTH SUDAN   \n",
       "11   2013-10-25T00:00:00Z                                       NaN   \n",
       "12   2013-10-24T00:00:00Z                       GOVERNMENT OF GHANA   \n",
       "13   2013-10-22T00:00:00Z                 GOVERNMENT OF TIMOR LESTE   \n",
       "14   2013-10-22T00:00:00Z                      GOVERNMENT OF JORDAN   \n",
       "15   2013-10-17T00:00:00Z                       MINISTRY OF FINANCE   \n",
       "16   2013-10-17T00:00:00Z                       MINISTRY OF FINANCE   \n",
       "17   2013-10-16T00:00:00Z      MINISTRY OF FINANCE AND BUDGET (MFB)   \n",
       "18   2013-10-16T00:00:00Z              ROYAL GOVERNMENT OF CAMBODIA   \n",
       "19   2013-10-10T00:00:00Z                       MINISTRY OF FINANCE   \n",
       "20   2013-10-09T00:00:00Z       AGA KHAN DEVELOPMENT NETWORK (AKDN)   \n",
       "21   2013-10-07T00:00:00Z                                     NEPAL   \n",
       "22   2013-10-07T00:00:00Z  MINISTRY OF PLANNING AND INTERNATIONAL C   \n",
       "23   2013-10-03T00:00:00Z                    REPUBLIC OF TAJIKISTAN   \n",
       "24   2013-09-30T00:00:00Z                    REPUBLIC OF AZERBAIJAN   \n",
       "25   2013-09-30T00:00:00Z                  UNIVERSITY OF QUEENSLAND   \n",
       "26   2013-09-30T00:00:00Z           LAO PEOPLES DEMOCRATIC REPUBLIC   \n",
       "27   2013-09-30T00:00:00Z          PACIFIC AVIATION SECURITY OFFICE   \n",
       "28   2013-09-30T00:00:00Z                SOLOMON ISLANDS GOVERNMENT   \n",
       "29   2013-09-27T00:00:00Z                  GOVERNMENT OF MOZAMBIQUE   \n",
       "..                    ...                                       ...   \n",
       "470  2012-09-20T00:00:00Z                     GOVERNMENT OF LIBERIA   \n",
       "471  2012-09-20T00:00:00Z                  GOVERNMENT OF BANGLADESH   \n",
       "472  2012-09-13T00:00:00Z             MINISTRY OF NATURE PROTECTION   \n",
       "473  2012-09-13T00:00:00Z   MINISTRY OF ENVIRONMENT, FORESTS, WATER   \n",
       "474  2012-09-11T00:00:00Z                    GOVERNMENT OF PAKISTAN   \n",
       "475  2012-09-11T00:00:00Z                   GOVERNMENT OF INDONESIA   \n",
       "476  2012-09-11T00:00:00Z             SOCIALIST REPUBLIC OF VIETNAM   \n",
       "477  2012-09-11T00:00:00Z                    REPUBLIC OF UZBEKISTAN   \n",
       "478  2012-09-11T00:00:00Z              ISLAMIC REPUBLIC OF PAKISTAN   \n",
       "479  2012-09-10T00:00:00Z                                  UT'Z CHE   \n",
       "480  2012-09-10T00:00:00Z                      GOVERNMENT OF ZAMBIA   \n",
       "481  2012-09-06T00:00:00Z                       GOVERNMENT OF INDIA   \n",
       "482  2012-09-06T00:00:00Z                       GOVERNMENT OF INDIA   \n",
       "483  2012-09-06T00:00:00Z                       GOVERNMENT OF INDIA   \n",
       "484  2012-09-06T00:00:00Z                ILO, MINLAND & CFSI & BANK   \n",
       "485  2012-09-05T00:00:00Z                    GOVERNMENT OF MONGOLIA   \n",
       "486  2012-09-01T00:00:00Z            GOVERNMENT OF LEBANON & JORDAN   \n",
       "487  2012-08-30T00:00:00Z                     UNITED MEXICAN STATES   \n",
       "488  2012-08-30T00:00:00Z               THE STATE OF RIO DE JANEIRO   \n",
       "489  2012-08-30T00:00:00Z                                UN-HABITAT   \n",
       "490  2012-08-29T00:00:00Z                       GOVERNMENT OF NEPAL   \n",
       "491  2012-08-24T00:00:00Z               PALESTINIAN WATER AUTHORITY   \n",
       "492  2012-08-21T00:00:00Z                    GOVERNMENT OF PAKISTAN   \n",
       "493  2012-08-21T00:00:00Z                  GOVERNMENT OF BANGLADESH   \n",
       "494  2012-08-17T00:00:00Z                     MINISTRY OF EDUCATION   \n",
       "495  2012-08-10T00:00:00Z               THE COMPETITIVENESS COMPANY   \n",
       "496  2012-08-09T00:00:00Z           LAO PEOPLES DEMOCRATIC REPUBLIC   \n",
       "497  2012-08-03T00:00:00Z      GOVERNMENT OF THE REPUBLIC OF GUINEA   \n",
       "498  2012-08-02T00:00:00Z                     REPUBLIC OF INDONESIA   \n",
       "499  2012-08-02T00:00:00Z                        GOVERMENT OF KENYA   \n",
       "\n",
       "              closingdate                               country_namecode  \\\n",
       "0    2018-07-07T00:00:00Z   Federal Democratic Republic of Ethiopia!$!ET   \n",
       "1                     NaN                       Republic of Tunisia!$!TN   \n",
       "2                     NaN                                    Tuvalu!$!TV   \n",
       "3                     NaN                         Republic of Yemen!$!RY   \n",
       "4    2019-04-30T00:00:00Z                        Kingdom of Lesotho!$!LS   \n",
       "5                     NaN                         Republic of Kenya!$!KE   \n",
       "6    2019-06-30T00:00:00Z                         Republic of India!$!IN   \n",
       "7                     NaN                People's Republic of China!$!CN   \n",
       "8    2018-12-31T00:00:00Z                         Republic of India!$!IN   \n",
       "9    2014-12-31T00:00:00Z                        Kingdom of Morocco!$!MA   \n",
       "10                    NaN                   Republic of South Sudan!$!SS   \n",
       "11   2017-12-31T00:00:00Z                         Republic of India!$!IN   \n",
       "12   2019-06-30T00:00:00Z                         Republic of Ghana!$!GH   \n",
       "13                    NaN        Democratic Republic of Timor-Leste!$!TP   \n",
       "14                    NaN               Hashemite Kingdom of Jordan!$!JO   \n",
       "15   2019-04-30T00:00:00Z                                     Samoa!$!WS   \n",
       "16   2015-12-31T00:00:00Z                                     Samoa!$!WS   \n",
       "17                    NaN                    Republic of Madagascar!$!MG   \n",
       "18                    NaN                       Kingdom of Cambodia!$!KH   \n",
       "19                    NaN                        Kingdom of Morocco!$!MA   \n",
       "20                    NaN                           Kyrgyz Republic!$!KG   \n",
       "21                    NaN                                     Nepal!$!NP   \n",
       "22                    NaN               Hashemite Kingdom of Jordan!$!JO   \n",
       "23                    NaN                    Republic of Tajikistan!$!TJ   \n",
       "24   2018-12-31T00:00:00Z                    Republic of Azerbaijan!$!AZ   \n",
       "25                    NaN                     East Asia and Pacific!$!4E   \n",
       "26   2014-03-31T00:00:00Z          Lao People's Democratic Republic!$!LA   \n",
       "27   2018-12-31T00:00:00Z                           Pacific Islands!$!4P   \n",
       "28                    NaN                           Solomon Islands!$!SB   \n",
       "29                    NaN                    Republic of Mozambique!$!MZ   \n",
       "..                    ...                                            ...   \n",
       "470                   NaN                       Republic of Liberia!$!LR   \n",
       "471  2018-12-31T00:00:00Z           People's Republic of Bangladesh!$!BD   \n",
       "472  2014-09-30T00:00:00Z                       Republic of Armenia!$!AM   \n",
       "473                   NaN                       Republic of Albania!$!AL   \n",
       "474  2017-06-30T00:00:00Z              Islamic Republic of Pakistan!$!PK   \n",
       "475  2018-03-31T00:00:00Z                     Republic of Indonesia!$!ID   \n",
       "476  2018-12-31T00:00:00Z             Socialist Republic of Vietnam!$!VN   \n",
       "477                   NaN                    Republic of Uzbekistan!$!UZ   \n",
       "478                   NaN              Islamic Republic of Pakistan!$!PK   \n",
       "479  2016-05-07T00:00:00Z                     Republic of Guatemala!$!GT   \n",
       "480  2014-12-31T00:00:00Z                        Republic of Zambia!$!ZM   \n",
       "481  2015-12-31T00:00:00Z                         Republic of India!$!IN   \n",
       "482  2018-12-31T00:00:00Z                         Republic of India!$!IN   \n",
       "483  2013-09-30T00:00:00Z                         Republic of India!$!IN   \n",
       "484  2015-12-31T00:00:00Z               Republic of the Philippines!$!PH   \n",
       "485  2013-12-31T00:00:00Z                                  Mongolia!$!MN   \n",
       "486  2015-01-31T00:00:00Z              Middle East and North Africa!$!5M   \n",
       "487  2017-08-31T00:00:00Z                     United Mexican States!$!MX   \n",
       "488  2014-01-31T00:00:00Z             Federative Republic of Brazil!$!BR   \n",
       "489  2015-06-30T00:00:00Z  The Independent State of Papua New Guine!$!PG   \n",
       "490  2014-06-30T00:00:00Z                                     Nepal!$!NP   \n",
       "491  2014-03-31T00:00:00Z                        West Bank and Gaza!$!GZ   \n",
       "492  2015-06-30T00:00:00Z              Islamic Republic of Pakistan!$!PK   \n",
       "493  2015-04-30T00:00:00Z           People's Republic of Bangladesh!$!BD   \n",
       "494  2014-06-30T00:00:00Z                                     Nepal!$!NP   \n",
       "495  2013-08-31T00:00:00Z                                   Jamaica!$!JM   \n",
       "496  2012-12-31T00:00:00Z          Lao People's Democratic Republic!$!LA   \n",
       "497  2014-12-31T00:00:00Z                        Republic of Guinea!$!GN   \n",
       "498  2017-09-30T00:00:00Z                     Republic of Indonesia!$!ID   \n",
       "499  2018-12-31T00:00:00Z                         Republic of Kenya!$!KE   \n",
       "\n",
       "    countrycode                               countryname  \\\n",
       "0            ET   Federal Democratic Republic of Ethiopia   \n",
       "1            TN                       Republic of Tunisia   \n",
       "2            TV                                    Tuvalu   \n",
       "3            RY                         Republic of Yemen   \n",
       "4            LS                        Kingdom of Lesotho   \n",
       "5            KE                         Republic of Kenya   \n",
       "6            IN                         Republic of India   \n",
       "7            CN                People's Republic of China   \n",
       "8            IN                         Republic of India   \n",
       "9            MA                        Kingdom of Morocco   \n",
       "10           SS                   Republic of South Sudan   \n",
       "11           IN                         Republic of India   \n",
       "12           GH                         Republic of Ghana   \n",
       "13           TP        Democratic Republic of Timor-Leste   \n",
       "14           JO               Hashemite Kingdom of Jordan   \n",
       "15           WS                                     Samoa   \n",
       "16           WS                                     Samoa   \n",
       "17           MG                    Republic of Madagascar   \n",
       "18           KH                       Kingdom of Cambodia   \n",
       "19           MA                        Kingdom of Morocco   \n",
       "20           KG                           Kyrgyz Republic   \n",
       "21           NP                                     Nepal   \n",
       "22           JO               Hashemite Kingdom of Jordan   \n",
       "23           TJ                    Republic of Tajikistan   \n",
       "24           AZ                    Republic of Azerbaijan   \n",
       "25           4E                     East Asia and Pacific   \n",
       "26           LA          Lao People's Democratic Republic   \n",
       "27           4P                           Pacific Islands   \n",
       "28           SB                           Solomon Islands   \n",
       "29           MZ                    Republic of Mozambique   \n",
       "..          ...                                       ...   \n",
       "470          LR                       Republic of Liberia   \n",
       "471          BD           People's Republic of Bangladesh   \n",
       "472          AM                       Republic of Armenia   \n",
       "473          AL                       Republic of Albania   \n",
       "474          PK              Islamic Republic of Pakistan   \n",
       "475          ID                     Republic of Indonesia   \n",
       "476          VN             Socialist Republic of Vietnam   \n",
       "477          UZ                    Republic of Uzbekistan   \n",
       "478          PK              Islamic Republic of Pakistan   \n",
       "479          GT                     Republic of Guatemala   \n",
       "480          ZM                        Republic of Zambia   \n",
       "481          IN                         Republic of India   \n",
       "482          IN                         Republic of India   \n",
       "483          IN                         Republic of India   \n",
       "484          PH               Republic of the Philippines   \n",
       "485          MN                                  Mongolia   \n",
       "486          5M              Middle East and North Africa   \n",
       "487          MX                     United Mexican States   \n",
       "488          BR             Federative Republic of Brazil   \n",
       "489          PG  The Independent State of Papua New Guine   \n",
       "490          NP                                     Nepal   \n",
       "491          GZ                        West Bank and Gaza   \n",
       "492          PK              Islamic Republic of Pakistan   \n",
       "493          BD           People's Republic of Bangladesh   \n",
       "494          NP                                     Nepal   \n",
       "495          JM                                   Jamaica   \n",
       "496          LA          Lao People's Democratic Republic   \n",
       "497          GN                        Republic of Guinea   \n",
       "498          ID                     Republic of Indonesia   \n",
       "499          KE                         Republic of Kenya   \n",
       "\n",
       "                     countryshortname  \\\n",
       "0                            Ethiopia   \n",
       "1                             Tunisia   \n",
       "2                              Tuvalu   \n",
       "3                  Yemen, Republic of   \n",
       "4                             Lesotho   \n",
       "5                               Kenya   \n",
       "6                               India   \n",
       "7                               China   \n",
       "8                               India   \n",
       "9                             Morocco   \n",
       "10                        South Sudan   \n",
       "11                              India   \n",
       "12                              Ghana   \n",
       "13                        Timor-Leste   \n",
       "14                             Jordan   \n",
       "15                              Samoa   \n",
       "16                              Samoa   \n",
       "17                         Madagascar   \n",
       "18                           Cambodia   \n",
       "19                            Morocco   \n",
       "20                    Kyrgyz Republic   \n",
       "21                              Nepal   \n",
       "22                             Jordan   \n",
       "23                         Tajikistan   \n",
       "24                         Azerbaijan   \n",
       "25              East Asia and Pacific   \n",
       "26   Lao People's Democratic Republic   \n",
       "27                    Pacific Islands   \n",
       "28                    Solomon Islands   \n",
       "29                         Mozambique   \n",
       "..                                ...   \n",
       "470                           Liberia   \n",
       "471                        Bangladesh   \n",
       "472                           Armenia   \n",
       "473                           Albania   \n",
       "474                          Pakistan   \n",
       "475                         Indonesia   \n",
       "476                           Vietnam   \n",
       "477                        Uzbekistan   \n",
       "478                          Pakistan   \n",
       "479                         Guatemala   \n",
       "480                            Zambia   \n",
       "481                             India   \n",
       "482                             India   \n",
       "483                             India   \n",
       "484                       Philippines   \n",
       "485                          Mongolia   \n",
       "486      Middle East and North Africa   \n",
       "487                            Mexico   \n",
       "488                            Brazil   \n",
       "489                  Papua New Guinea   \n",
       "490                             Nepal   \n",
       "491                West Bank and Gaza   \n",
       "492                          Pakistan   \n",
       "493                        Bangladesh   \n",
       "494                             Nepal   \n",
       "495                           Jamaica   \n",
       "496  Lao People's Democratic Republic   \n",
       "497                            Guinea   \n",
       "498                         Indonesia   \n",
       "499                             Kenya   \n",
       "\n",
       "                           ...                              sectorcode source  \\\n",
       "0                          ...                             ET,BS,ES,EP   IBRD   \n",
       "1                          ...                                   BZ,BS   IBRD   \n",
       "2                          ...                                      TI   IBRD   \n",
       "3                          ...                                      JB   IBRD   \n",
       "4                          ...                                FH,YW,YZ   IBRD   \n",
       "5                          ...                                      JB   IBRD   \n",
       "6                          ...                                      TI   IBRD   \n",
       "7                          ...                                      LR   IBRD   \n",
       "8                          ...                                      TI   IBRD   \n",
       "9                          ...                                BM,BC,BZ   IBRD   \n",
       "10                         ...                                AZ,JB,AH   IBRD   \n",
       "11                         ...                             JB,YC,WD,TI   IBRD   \n",
       "12                         ...                                      CZ   IBRD   \n",
       "13                         ...                                   BV,TI   IBRD   \n",
       "14                         ...                                      JB   IBRD   \n",
       "15                         ...                                      TI   IBRD   \n",
       "16                         ...                                AZ,AJ,AH   IBRD   \n",
       "17                         ...                                      EP   IBRD   \n",
       "18                         ...                          BK,JB,BH,BC,JA   IBRD   \n",
       "19                         ...                                BH,BC,BZ   IBRD   \n",
       "20                         ...                                      JB   IBRD   \n",
       "21                         ...                                BH,YW,JB   IBRD   \n",
       "22                         ...                          WC,BS,BH,TZ,WB   IBRD   \n",
       "23                         ...                                      JA   IBRD   \n",
       "24                         ...                                AB,AZ,YA   IBRD   \n",
       "25                         ...                                   AB,AZ   IBRD   \n",
       "26                         ...                          LG,FB,EZ,YZ,BC   IBRD   \n",
       "27                         ...                                   BV,TV   IBRD   \n",
       "28                         ...                                   BZ,AZ   IBRD   \n",
       "29                         ...                             JB,BW,WZ,WD   IBRD   \n",
       "..                         ...                                     ...    ...   \n",
       "470                        ...                                   BV,TI   IBRD   \n",
       "471                        ...                                BU,LA,LR   IBRD   \n",
       "472                        ...                                      BC   IBRD   \n",
       "473                        ...                                      BC   IBRD   \n",
       "474                        ...                                   BM,BH   IBRD   \n",
       "475                        ...                          BO,BH,LZ,TZ,WZ   IBRD   \n",
       "476                        ...                                BU,LT,LA   IBRD   \n",
       "477                        ...                                      FH   IBRD   \n",
       "478                        ...                                      BH   IBRD   \n",
       "479                        ...                                      AZ   IBRD   \n",
       "480                        ...                                      LS   IBRD   \n",
       "481                        ...                             BC,EC,BQ,BH   IBRD   \n",
       "482                        ...                          AI,YA,AH,BL,AB   IBRD   \n",
       "483                        ...                          CZ,AH,LA,AI,LH   IBRD   \n",
       "484                        ...                             EV,FH,BZ,JB   IBRD   \n",
       "485                        ...                                BZ,JA,AJ   IBRD   \n",
       "486                        ...                             BZ,BS,BQ,BN   IBRD   \n",
       "487                        ...                                YA,BL,AB   IBRD   \n",
       "488                        ...                                JA,EZ,BH   IBRD   \n",
       "489                        ...                                      BW   IBRD   \n",
       "490                        ...                                      BZ   IBRD   \n",
       "491                        ...                                   WC,WA   IBRD   \n",
       "492                        ...                                      EP   IBRD   \n",
       "493                        ...                                      BC   IBRD   \n",
       "494                        ...                                      EZ   IBRD   \n",
       "495                        ...                                   EV,AZ   IBRD   \n",
       "496                        ...                          YZ,JA,EZ,FZ,BC   IBRD   \n",
       "497                        ...                                AB,AH,AI   IBRD   \n",
       "498                        ...                                YA,BL,AB   IBRD   \n",
       "499                        ...                                   BV,TC   IBRD   \n",
       "\n",
       "     status  supplementprojectflg  \\\n",
       "0    Active                     N   \n",
       "1    Active                     N   \n",
       "2    Active                     Y   \n",
       "3    Active                     N   \n",
       "4    Active                     N   \n",
       "5    Active                     Y   \n",
       "6    Active                     N   \n",
       "7    Active                     N   \n",
       "8    Active                     N   \n",
       "9    Active                     N   \n",
       "10   Active                     Y   \n",
       "11   Active                     N   \n",
       "12   Active                     N   \n",
       "13   Active                     Y   \n",
       "14   Active                     N   \n",
       "15   Active                     N   \n",
       "16   Active                     N   \n",
       "17   Active                     N   \n",
       "18   Active                     Y   \n",
       "19   Active                     N   \n",
       "20   Active                     N   \n",
       "21   Active                     N   \n",
       "22   Active                     N   \n",
       "23   Active                     N   \n",
       "24   Active                     N   \n",
       "25   Active                     N   \n",
       "26   Closed                     N   \n",
       "27   Active                     N   \n",
       "28   Active                     Y   \n",
       "29   Active                     Y   \n",
       "..      ...                   ...   \n",
       "470  Active                     Y   \n",
       "471  Active                     N   \n",
       "472  Active                     N   \n",
       "473  Active                     N   \n",
       "474  Active                     N   \n",
       "475  Active                     N   \n",
       "476  Active                     N   \n",
       "477  Active                     Y   \n",
       "478  Active                     Y   \n",
       "479  Active                     N   \n",
       "480  Active                     N   \n",
       "481  Active                     N   \n",
       "482  Active                     N   \n",
       "483  Closed                     N   \n",
       "484  Active                     Y   \n",
       "485  Active                     N   \n",
       "486  Active                     N   \n",
       "487  Active                     N   \n",
       "488  Closed                     N   \n",
       "489  Closed                     N   \n",
       "490  Active                     N   \n",
       "491  Active                     N   \n",
       "492  Active                     N   \n",
       "493  Active                     N   \n",
       "494  Active                     N   \n",
       "495  Closed                     N   \n",
       "496  Closed                     N   \n",
       "497  Active                     N   \n",
       "498  Active                     N   \n",
       "499  Active                     N   \n",
       "\n",
       "                                                theme1  \\\n",
       "0        {'Percent': 100, 'Name': 'Education for all'}   \n",
       "1    {'Percent': 30, 'Name': 'Other economic manage...   \n",
       "2      {'Percent': 46, 'Name': 'Regional integration'}   \n",
       "3    {'Percent': 50, 'Name': 'Participation and civ...   \n",
       "4    {'Percent': 30, 'Name': 'Export development an...   \n",
       "5       {'Percent': 100, 'Name': 'Social safety nets'}   \n",
       "6    {'Percent': 20, 'Name': 'Administrative and ci...   \n",
       "7           {'Percent': 100, 'Name': 'Climate change'}   \n",
       "8    {'Percent': 87, 'Name': 'Other rural developme...   \n",
       "9    {'Percent': 33, 'Name': 'Other accountability/...   \n",
       "10   {'Percent': 100, 'Name': 'Global food crisis r...   \n",
       "11   {'Percent': 60, 'Name': 'Rural services and in...   \n",
       "12                          {'Percent': 0, 'Name': ''}   \n",
       "13     {'Percent': 20, 'Name': 'Regional integration'}   \n",
       "14       {'Percent': 50, 'Name': 'Social safety nets'}   \n",
       "15   {'Percent': 60, 'Name': 'Rural services and in...   \n",
       "16   {'Percent': 100, 'Name': 'Other rural developm...   \n",
       "17       {'Percent': 100, 'Name': 'Education for all'}   \n",
       "18             {'Percent': 17, 'Name': 'Child health'}   \n",
       "19   {'Percent': 40, 'Name': 'Public expenditure, f...   \n",
       "20   {'Percent': 50, 'Name': 'Conflict prevention a...   \n",
       "21   {'Percent': 30, 'Name': 'Urban services and ho...   \n",
       "22   {'Percent': 25, 'Name': 'Other social developm...   \n",
       "23   {'Percent': 60, 'Name': 'Nutrition and food se...   \n",
       "24            {'Percent': 30, 'Name': 'Rural markets'}   \n",
       "25   {'Percent': 40, 'Name': 'Other environment and...   \n",
       "26   {'Percent': 14, 'Name': 'Regulation and compet...   \n",
       "27            {'Percent': 5, 'Name': 'Climate change'}   \n",
       "28   {'Percent': 30, 'Name': 'Rural policies and in...   \n",
       "29   {'Percent': 4, 'Name': 'Other social developme...   \n",
       "..                                                 ...   \n",
       "470  {'Percent': 40, 'Name': 'Trade facilitation an...   \n",
       "471  {'Percent': 45, 'Name': 'Rural services and in...   \n",
       "472  {'Percent': 100, 'Name': 'Other environment an...   \n",
       "473  {'Percent': 100, 'Name': 'Other environment an...   \n",
       "474       {'Percent': 34, 'Name': 'Municipal finance'}   \n",
       "475  {'Percent': 25, 'Name': 'Infrastructure servic...   \n",
       "476  {'Percent': 100, 'Name': 'Rural services and i...   \n",
       "477  {'Percent': 40, 'Name': 'Micro, Small and Medi...   \n",
       "478  {'Percent': 10, 'Name': 'Administrative and ci...   \n",
       "479  {'Percent': 100, 'Name': 'Other social develop...   \n",
       "480  {'Percent': 100, 'Name': 'Other public sector ...   \n",
       "481            {'Percent': 23, 'Name': 'Child health'}   \n",
       "482  {'Percent': 10, 'Name': 'Rural services and in...   \n",
       "483  {'Percent': 19, 'Name': 'Pollution management ...   \n",
       "484  {'Percent': 9, 'Name': 'Rural non-farm income ...   \n",
       "485  {'Percent': 100, 'Name': 'Other communicable d...   \n",
       "486  {'Percent': 25, 'Name': 'Other public sector g...   \n",
       "487            {'Percent': 20, 'Name': 'Biodiversity'}   \n",
       "488  {'Percent': 20, 'Name': 'Health system perform...   \n",
       "489  {'Percent': 50, 'Name': 'Urban services and ho...   \n",
       "490  {'Percent': 80, 'Name': 'Public expenditure, f...   \n",
       "491  {'Percent': 100, 'Name': 'Rural services and i...   \n",
       "492       {'Percent': 70, 'Name': 'Education for all'}   \n",
       "493  {'Percent': 100, 'Name': 'Other environment an...   \n",
       "494  {'Percent': 100, 'Name': 'Natural disaster man...   \n",
       "495  {'Percent': 50, 'Name': 'Regulation and compet...   \n",
       "496            {'Percent': 14, 'Name': 'Child health'}   \n",
       "497  {'Percent': 100, 'Name': 'Global food crisis r...   \n",
       "498  {'Percent': 85, 'Name': 'Rural services and in...   \n",
       "499  {'Percent': 1, 'Name': 'Municipal governance a...   \n",
       "\n",
       "                                        theme_namecode       themecode  \\\n",
       "0        [{'code': '65', 'name': 'Education for all'}]              65   \n",
       "1    [{'code': '24', 'name': 'Other economic manage...           54,24   \n",
       "2    [{'code': '47', 'name': 'Regional integration'...     52,81,25,47   \n",
       "3    [{'code': '57', 'name': 'Participation and civ...           59,57   \n",
       "4    [{'code': '45', 'name': 'Export development an...           41,45   \n",
       "5       [{'code': '54', 'name': 'Social safety nets'}]              54   \n",
       "6    [{'code': '25', 'name': 'Administrative and ci...           39,25   \n",
       "7           [{'code': '81', 'name': 'Climate change'}]              81   \n",
       "8    [{'code': '79', 'name': 'Other rural developme...              79   \n",
       "9    [{'code': '29', 'name': 'Other accountability/...        27,30,29   \n",
       "10   [{'code': '91', 'name': 'Global food crisis re...              91   \n",
       "11   [{'code': '78', 'name': 'Rural services and in...     81,87,52,78   \n",
       "12                                                 NaN             NaN   \n",
       "13   [{'code': '47', 'name': 'Regional integration'...        78,81,47   \n",
       "14   [{'code': '54', 'name': 'Social safety nets'},...        53,56,54   \n",
       "15   [{'code': '78', 'name': 'Rural services and in...        49,81,78   \n",
       "16   [{'code': '79', 'name': 'Other rural developme...              79   \n",
       "17       [{'code': '65', 'name': 'Education for all'}]              65   \n",
       "18   [{'code': '63', 'name': 'Child health'}, {'cod...  69,57,25,67,63   \n",
       "19   [{'code': '27', 'name': 'Public expenditure, f...        25,26,27   \n",
       "20   [{'code': '58', 'name': 'Conflict prevention a...           57,58   \n",
       "21   [{'code': '71', 'name': 'Urban services and ho...           57,71   \n",
       "22   [{'code': '62', 'name': 'Other social developm...           58,62   \n",
       "23   [{'code': '68', 'name': 'Nutrition and food se...           63,68   \n",
       "24   [{'code': '75', 'name': 'Rural markets'}, {'co...     56,78,76,75   \n",
       "25   [{'code': '86', 'name': 'Other environment and...        80,81,86   \n",
       "26   [{'code': '40', 'name': 'Regulation and compet...     67,27,49,40   \n",
       "27   [{'code': '81', 'name': 'Climate change'}, {'c...     52,47,25,81   \n",
       "28   [{'code': '77', 'name': 'Rural policies and in...        57,78,77   \n",
       "29   [{'code': '62', 'name': 'Other social developm...           85,62   \n",
       "..                                                 ...             ...   \n",
       "470  [{'code': '49', 'name': 'Trade facilitation an...           78,49   \n",
       "471  [{'code': '78', 'name': 'Rural services and in...     59,81,57,78   \n",
       "472  [{'code': '86', 'name': 'Other environment and...              86   \n",
       "473  [{'code': '86', 'name': 'Other environment and...              86   \n",
       "474  [{'code': '72', 'name': 'Municipal finance'}, ...           73,72   \n",
       "475  [{'code': '39', 'name': 'Infrastructure servic...           72,39   \n",
       "476  [{'code': '78', 'name': 'Rural services and in...              78   \n",
       "477  [{'code': '41', 'name': 'Micro, Small and Medi...           75,41   \n",
       "478  [{'code': '25', 'name': 'Administrative and ci...        83,36,25   \n",
       "479  [{'code': '62', 'name': 'Other social developm...              62   \n",
       "480  [{'code': '30', 'name': 'Other public sector g...              30   \n",
       "481  [{'code': '63', 'name': 'Child health'}, {'cod...     68,59,57,63   \n",
       "482  [{'code': '78', 'name': 'Rural services and in...     79,85,86,78   \n",
       "483  [{'code': '84', 'name': 'Pollution management ...     82,78,81,84   \n",
       "484  [{'code': '76', 'name': 'Rural non-farm income...     78,58,41,76   \n",
       "485  [{'code': '64', 'name': 'Other communicable di...              64   \n",
       "486  [{'code': '30', 'name': 'Other public sector g...     54,55,56,30   \n",
       "487  [{'code': '80', 'name': 'Biodiversity'}, {'cod...     82,79,77,80   \n",
       "488  [{'code': '67', 'name': 'Health system perform...     65,28,27,67   \n",
       "489  [{'code': '71', 'name': 'Urban services and ho...     73,55,52,71   \n",
       "490  [{'code': '27', 'name': 'Public expenditure, f...           29,27   \n",
       "491  [{'code': '78', 'name': 'Rural services and in...              78   \n",
       "492  [{'code': '65', 'name': 'Education for all'}, ...           59,65   \n",
       "493  [{'code': '86', 'name': 'Other environment and...              86   \n",
       "494  [{'code': '52', 'name': 'Natural disaster mana...              52   \n",
       "495  [{'code': '40', 'name': 'Regulation and compet...           62,40   \n",
       "496  [{'code': '63', 'name': 'Child health'}, {'cod...     65,27,49,63   \n",
       "497  [{'code': '91', 'name': 'Global food crisis re...              91   \n",
       "498  [{'code': '78', 'name': 'Rural services and in...        77,91,78   \n",
       "499  [{'code': '73', 'name': 'Municipal governance ...     39,49,88,73   \n",
       "\n",
       "      totalamt totalcommamt                                                url  \n",
       "0    130000000    130000000  http://www.worldbank.org/projects/P129828/ethi...  \n",
       "1            0      4700000  http://www.worldbank.org/projects/P144674?lang=en  \n",
       "2      6060000      6060000  http://www.worldbank.org/projects/P145310?lang=en  \n",
       "3            0      1500000  http://www.worldbank.org/projects/P144665?lang=en  \n",
       "4     13100000     13100000  http://www.worldbank.org/projects/P144933/seco...  \n",
       "5     10000000     10000000  http://www.worldbank.org/projects/P146161?lang=en  \n",
       "6    500000000    500000000  http://www.worldbank.org/projects/P121185/firs...  \n",
       "7            0     27280000  http://www.worldbank.org/projects/P127033/chin...  \n",
       "8    160000000    160000000  http://www.worldbank.org/projects/P130164/raja...  \n",
       "9    200000000    200000000  http://www.worldbank.org/projects/P130903?lang=en  \n",
       "10           0      7530000  http://www.worldbank.org/projects/P145339?lang=en  \n",
       "11   250000000    250000000  http://www.worldbank.org/projects/P146653?lang=en  \n",
       "12    97000000     97000000  http://www.worldbank.org/projects/P144140/gh-e...  \n",
       "13    40000000     40000000  http://www.worldbank.org/projects/P130975/timo...  \n",
       "14           0      9500000  http://www.worldbank.org/projects/P144832?lang=en  \n",
       "15    20000000     20000000  http://www.worldbank.org/projects/P145545?lang=en  \n",
       "16     5000000      5000000  http://www.worldbank.org/projects/P145938?lang=en  \n",
       "17           0     85400000  http://www.worldbank.org/projects/P132616?lang=en  \n",
       "18           0     13450000  http://www.worldbank.org/projects/P146271?lang=en  \n",
       "19           0      4350000  http://www.worldbank.org/projects/P143979?lang=en  \n",
       "20           0      2000000  http://www.worldbank.org/projects/P132577?lang=en  \n",
       "21           0      2750000  http://www.worldbank.org/projects/P145359?lang=en  \n",
       "22           0     50000000  http://www.worldbank.org/projects/P147689?lang=en  \n",
       "23           0      2800000  http://www.worldbank.org/projects/P146109?lang=en  \n",
       "24    34500000     34500000  http://www.worldbank.org/projects/P122812/thir...  \n",
       "25           0      4500000  http://www.worldbank.org/projects/P123933/capt...  \n",
       "26    20000000     20000000  http://www.worldbank.org/projects/P143025/lao-...  \n",
       "27     2150000      2150000  http://www.worldbank.org/projects/P145057/paci...  \n",
       "28     3000000      3000000  http://www.worldbank.org/projects/P146021?lang=en  \n",
       "29    32000000     32000000  http://www.worldbank.org/projects/P146098?lang=en  \n",
       "..         ...          ...                                                ...  \n",
       "470   50000000     50000000  http://www.worldbank.org/projects/P129654/libe...  \n",
       "471  155000000    155000000  http://www.worldbank.org/projects/P131263/rura...  \n",
       "472          0       150000  http://www.worldbank.org/projects/P131631/repo...  \n",
       "473          0       150000  http://www.worldbank.org/projects/P132679/land...  \n",
       "474  150000000    150000000  http://www.worldbank.org/projects/P112901/pk-p...  \n",
       "475   29600000     29600000  http://www.worldbank.org/projects/P118916/infr...  \n",
       "476  448900000    448900000  http://www.worldbank.org/projects/P125996/dist...  \n",
       "477   40000000     40000000  http://www.worldbank.org/projects/P126962/addi...  \n",
       "478   70000000     70000000  http://www.worldbank.org/projects/P131266/punj...  \n",
       "479          0      2510000  http://www.worldbank.org/projects/P130412/stre...  \n",
       "480          0       350000  http://www.worldbank.org/projects/P131881/zamb...  \n",
       "481  106000000    106000000  http://www.worldbank.org/projects/P121731/icds...  \n",
       "482   60000000     60000000  http://www.worldbank.org/projects/P122486/karn...  \n",
       "483  100000000    100000000  http://www.worldbank.org/projects/P124041/hima...  \n",
       "484          0      5570000  http://www.worldbank.org/projects/P132238/mult...  \n",
       "485          0      2900000  http://www.worldbank.org/projects/P131204/capa...  \n",
       "486          0      2400000  http://www.worldbank.org/projects/P132097/5m-d...  \n",
       "487          0     11690000  http://www.worldbank.org/projects/P121116/sust...  \n",
       "488  300000000    300000000  http://www.worldbank.org/projects/P126465/rio-...  \n",
       "489          0       350000  http://www.worldbank.org/projects/P128763/papu...  \n",
       "490          0       800000  http://www.worldbank.org/projects/P131860/stre...  \n",
       "491          0      3650000  http://www.worldbank.org/projects/P123322/wate...  \n",
       "492          0     10000000  http://www.worldbank.org/projects/P128096/paki...  \n",
       "493          0       150000  http://www.worldbank.org/projects/P132138/revi...  \n",
       "494          0      1510000  http://www.worldbank.org/projects/P129177/nepa...  \n",
       "495          0        50000  http://www.worldbank.org/projects/P127299/tech...  \n",
       "496   20000000     20000000  http://www.worldbank.org/projects/P125298/lao-...  \n",
       "497          0     20000000  http://www.worldbank.org/projects/P128309/seco...  \n",
       "498   80000000     80000000  http://www.worldbank.org/projects/P117243/sust...  \n",
       "499  300000000    300000000  http://www.worldbank.org/projects/P126321/keny...  \n",
       "\n",
       "[500 rows x 50 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Reading world_bank_projects.json into a dataframe\n",
    "x = pd.read_json('world_bank_projects.json')\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "_id                           0\n",
      "approvalfy                    0\n",
      "board_approval_month          0\n",
      "boardapprovaldate             0\n",
      "borrower                     15\n",
      "closingdate                 130\n",
      "country_namecode              0\n",
      "countrycode                   0\n",
      "countryname                   0\n",
      "countryshortname              0\n",
      "docty                        54\n",
      "envassesmentcategorycode     70\n",
      "grantamt                      0\n",
      "ibrdcommamt                   0\n",
      "id                            0\n",
      "idacommamt                    0\n",
      "impagency                    28\n",
      "lendinginstr                  5\n",
      "lendinginstrtype              5\n",
      "lendprojectcost               0\n",
      "majorsector_percent           0\n",
      "mjsector_namecode             0\n",
      "mjtheme                       9\n",
      "mjtheme_namecode              0\n",
      "mjthemecode                   0\n",
      "prodline                      0\n",
      "prodlinetext                  0\n",
      "productlinetype               0\n",
      "project_abstract            138\n",
      "project_name                  0\n",
      "projectdocs                  54\n",
      "projectfinancialtype          0\n",
      "projectstatusdisplay          0\n",
      "regionname                    0\n",
      "sector                        0\n",
      "sector1                       0\n",
      "sector2                     120\n",
      "sector3                     235\n",
      "sector4                     326\n",
      "sector_namecode               0\n",
      "sectorcode                    0\n",
      "source                        0\n",
      "status                        0\n",
      "supplementprojectflg          2\n",
      "theme1                        0\n",
      "theme_namecode                9\n",
      "themecode                     9\n",
      "totalamt                      0\n",
      "totalcommamt                  0\n",
      "url                           0\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Checking the count of NAN values in every column\n",
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):\n",
    "    print(x.isnull().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Here I verify if any of the project names are duplicated. And hence I can group the the countries by the project names.\n",
    "x.project_name.duplicated().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(500, 50)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking the number of rows and columns in the dataframe \n",
    "x.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Ethiopia General Education Quality Improvement Project II',\n",
       "       'TN: DTF Social Protection Reforms Support',\n",
       "       'Tuvalu Aviation Investment Project - Additional Financing',\n",
       "       \"Gov't and Civil Society Organization Partnership\",\n",
       "       'Second Private Sector Competitiveness and Economic Diversification Prj',\n",
       "       'Additional Financing for Cash Transfers for Orphans and Vulnerable Children',\n",
       "       'National Highways Interconnectivity Improvement Project',\n",
       "       'China Renewable Energy Scale-Up Program Phase II',\n",
       "       'Rajasthan Road Sector Modernization Project',\n",
       "       'MA Accountability and Transparency DPL',\n",
       "       'Southern Sudan Emergency Food Crisis Response Project- AF III',\n",
       "       'Uttarakhand Disaster Recovery Project', 'GH eTransform Ghana',\n",
       "       'Timor Leste Road Climate Resilience Project - Additional Financing',\n",
       "       'NATIONAL UNIFIED REGISTRY AND OUTREACH WORKER PROGRAM',\n",
       "       'Enhanced Road Access Project',\n",
       "       'Samoa Agriculture & Fisheries Cyclone Response Project',\n",
       "       'Emergency Support to Education For all Project',\n",
       "       'Additional Financing for the Second Health Sector Support Project',\n",
       "       'DTF:MA- Support New Governance Framework',\n",
       "       'SOCIAL COHESION THROUGH COMMUNITY-BASED DEVELOPMENT',\n",
       "       'Nepal: Pro-poor Urban Regeneration Pilot',\n",
       "       'Jordan- Emergency Services and Social Resilience',\n",
       "       'Tajikistan JSDF Nutrition Grant Scale Up',\n",
       "       'AGRICULTURAL COMPETITIVENESS IMPROVEMENT PROJECT',\n",
       "       'Capturing Coral Reef Ecosystem Services (CCRES)',\n",
       "       'Lao PDR Ninth Poverty Reduction Support Operation',\n",
       "       'Pacific Aviation Safety Office Reform',\n",
       "       'Additional Financing 2 - Solomon Islands Rural Development Program',\n",
       "       'Water Resources Development Flood Response Additional Financing',\n",
       "       'Angola Learning for All Project',\n",
       "       'Kihansi Catchment Conservation and Management Project',\n",
       "       'Housing Finance Development Program',\n",
       "       'Sustainability and Competitiveness DPL 2',\n",
       "       'Additional Financing: Skills and Training Enhancement Project',\n",
       "       'SN:Casamance Development Pole Project', 'Electric Power Project',\n",
       "       'West Bank and Gaza Cash Transfer Project Additional Financing',\n",
       "       'Adaptation Fund: Increasing Climate Resilience & Enhancing Sustainable Land Management in the Southwest of the Buenos Aires Province',\n",
       "       'GM-Integrated Financial Management and Information System Project-Additional Financing',\n",
       "       'RUSSIA HYDROMETEOROLOGICAL SERVICES MODERNIZATION',\n",
       "       'Congo Skills Development for Employability Project',\n",
       "       'Public Finance Management Technical Assistance Project',\n",
       "       'Sao Tome & Principe-Extractive Industries Transparency Initiative',\n",
       "       'Solomon Islands - Extractive Industries Transparency Initiative Implementation',\n",
       "       'West Africa  Regional Disease Surveillance Capacity Strengthening',\n",
       "       'RCIP4 - Regional Communications Infrastructure Program - APL 4',\n",
       "       'Ukraine - Smart Grid Project &#8211; PPG',\n",
       "       'KM-Electricity Sect. Recovery Proj(FY14)',\n",
       "       'CO: Enhancing Fiscal Capacity to Promote Shared Prosperity DPL',\n",
       "       'Climate Information System and PPCR Coordination',\n",
       "       'Building Resilience through Innovation, Communication & Knowledge Svcs',\n",
       "       'Pacific Catastrophe Risk Assessment and Financing Initiative Phase 3 - (RETF)',\n",
       "       \"Cote d'Ivoire PRSC 1\", \"SL-RCHP2 Add'l Financing (FY13)\",\n",
       "       'Red Sea and Gulf of Aden Strategic Ecosystem Management GEF Project',\n",
       "       'FSM and PW Telecoms & ICT TA Project',\n",
       "       'Uttar Pradesh Water Sector Restructuring Project Phase 2',\n",
       "       'Fighting against wildlife poaching and illegal trade in Africa',\n",
       "       'Solomon Islands Development Policy Operation-2',\n",
       "       'Peru - Post Compliance I', 'Agriculture Sector Support Project',\n",
       "       'EC Manta Public Services Improvement Project',\n",
       "       'Honduras Additional Financing Social Protection',\n",
       "       'AF: Development Policy Prog. Series',\n",
       "       'Regional Rusumo Falls Hydroelectric Project',\n",
       "       'Municipal Solid Waste Carbon Financing Program',\n",
       "       'Mauritania - TFSCB - Support to NSDS implementation',\n",
       "       'LB: Mobile Internet Ecosystem Project (MIEP)', 'GZ-PNGO IV AF',\n",
       "       'Tajikistan Health Services Improvement Project (HSIP)',\n",
       "       'Burkina Faso Electricity Sector Support Project',\n",
       "       'Montreal Protocol Hydrochlorofluorocarbons (HCFC) Phase-out Project',\n",
       "       'MH:  ICT Technical Assistance Project',\n",
       "       'Greater Maputo Water Supply Expansion Project',\n",
       "       'Programmatic Development Policy Operation 1',\n",
       "       'Financial Infrastructure Project', 'Quito Metro Line One',\n",
       "       'Liberia EITI - Post Compliance I',\n",
       "       'National Safety Net Program for Results',\n",
       "       'State Assets Inventory and Registry',\n",
       "       'Tunisia - Communications for policy reforms',\n",
       "       'Mitigate the Impact of Syrian Displacement on Jordan',\n",
       "       'MZ Extractive Industries Transparancy Initiative Post Compliance I',\n",
       "       'Ninth Poverty Reduction Support Credit (PRSC 9)',\n",
       "       'Global Partnership for Education (GPE)-4',\n",
       "       'Samoa Development Policy Operation',\n",
       "       'Strengthening micro-entrepreneurship for disadvantaged youth',\n",
       "       'TJ-Public Procurement Capacity Building',\n",
       "       'Additional Financing Health Sector Development Support Project',\n",
       "       'Mali Emergency Education For All Project',\n",
       "       'Morocco Microfinance Development Project',\n",
       "       'Indonesia Second Power Transmission Development Project',\n",
       "       'Afghanistan Agricultural Inputs Project (AAIP)',\n",
       "       'Armenia Pilot Agricultural Census implementation support',\n",
       "       'Guinea - MSME Development Project',\n",
       "       'Nigeria Agriculture Sector Development Policy Operation',\n",
       "       'THIRD NATIONAL FADAMA DEVELOPMENT PROJECT - ADDITIONAL FINANCING',\n",
       "       'Nepal-India Regional Trade And Transport Project',\n",
       "       'Additional Financing-West Africa Agricultural Productivity Program 2A',\n",
       "       'Second Irrigation and Drainage Improvement Project',\n",
       "       'EG - Helwan South Power Project',\n",
       "       'NP: Financial sector stability DPC',\n",
       "       'Croatia Export Financing Guarantee Operation',\n",
       "       'Georgia Competitiveness and Growth DPO2',\n",
       "       'AZ Integrated Solid Waste Management Project (AF)',\n",
       "       'Rail Trade and Transport Facilitation AF',\n",
       "       'LR-Poverty Reduction Strategy Credit I',\n",
       "       'Coastal Embankment Improvement Project - Phase I (CEIP-I)',\n",
       "       'TR Third Access to Finance for SMEs (SME III)',\n",
       "       'Bangladesh Safety Net Systems for the Poorest Project',\n",
       "       'Rio Grande do Norte: Regional Development and Governance',\n",
       "       'Pernambuco Equity and Inclusive Growth DPL',\n",
       "       'Cape Verde - Transport Sector Reform Project',\n",
       "       'Additional Financing for Nepal-India Electricity Transmission and Trade Project',\n",
       "       'Benin Cities Support Project',\n",
       "       'Bangladesh: Safe Migration for Bangladeshi Workers',\n",
       "       'Chad Education Sector Reform Project Phase 2',\n",
       "       'Safety Net and Skills Development',\n",
       "       'China: Guangdong Social Security Integration and Rural Worker Training',\n",
       "       'Anhui Xuancheng Infrastructure for Industry Relocation',\n",
       "       'China: Nanchang Urban Rail Project',\n",
       "       'Tamil Nadu and Puducherry Coastal Disaster Risk Reduction Project',\n",
       "       'HN RURAL INFRASTRUCTURE PROJECT (AF)', 'HN AF WSS Modernization',\n",
       "       'Kenya Water Security and Climate Resilience Project', 'Mali RRSC',\n",
       "       'Economic Reconstruction and Growth Development Policy Credit',\n",
       "       'Local Government Development Program', 'Development Policy Loan 2',\n",
       "       'CI - 27  Gas Field Expansion',\n",
       "       'MNXTA: Enhancing Microfinance Amongst Women and Youth in MENA',\n",
       "       'Belo Horizonte Urban Development Policy Loan',\n",
       "       'Rio de Janeiro Strengthening Public Sector Management Technical Assistance Project',\n",
       "       'Sao Paulo State Sustainable Transport Project',\n",
       "       'Albania MDTF for Extractive Industry Transparency Initiative (EITI), Implementation Support, Phase III',\n",
       "       'Afghanistan: Safety Nets and Pensions Support Project - AF',\n",
       "       'Senegal Quality and Equity of Basic Education',\n",
       "       'Indonesia Phase II: EITI Implementation',\n",
       "       'Energy Sector Development Project',\n",
       "       'Dem Rep Congo - Western Growth Poles',\n",
       "       'DRC-Multi-Modal Transp Additional Financing',\n",
       "       'Cameroon Flood Emergency Project',\n",
       "       'MNXTA: Yemen Enhancing Governance through Procurement',\n",
       "       'SME Revitalization and Employment Pilot Project',\n",
       "       'Sustainable Land Management Project',\n",
       "       'GH-GAMA Sanitation and Water Project',\n",
       "       'Competitiveness and Savings Development Policy Loan (CSDPL)',\n",
       "       'Natural Resources and Environmental Governance Technical Assistance',\n",
       "       'Additional Financing Belarus Energy Efficiency Project',\n",
       "       'Competitive Industries Project for Khyber Pakhtunkhwa',\n",
       "       'Public and Social Sector Transformation Project (PSST)',\n",
       "       'DJ Geothermal Power Generation Project',\n",
       "       'DJ (GEF) Geothermal Power Generation Program',\n",
       "       'Second Additional Financing for the Poverty Alleviation FundII Project',\n",
       "       'Mongolia Livestock and Agricultural Marketing Project',\n",
       "       \"Ma'anshan Cihu River Basin Improvement Project\",\n",
       "       'Emergency Infrastructure Rehabilitation & Energy Project - Additional Financing',\n",
       "       'LS- First Growth and Competitiveness DPG',\n",
       "       'Second Governance and Competitiveness Development Policy Operation',\n",
       "       'Fostering Innovation through Research, Science and Technology (FIRST)',\n",
       "       'North East and Red River Delta Regions Health System Support Project',\n",
       "       'Ningbo Municipal Solid Waste Minimization and Recycling Project',\n",
       "       'Punjab Health Sector Reform Project',\n",
       "       'Guangxi Laibin Water Environment Project',\n",
       "       'LA-Scaling-Up Participatory Sustainable Forest Management',\n",
       "       'PSG: Integrated Ecosystems Management',\n",
       "       'West Africa Regional Communications Infrastructure Project - APL 2',\n",
       "       'Liberia Health Systems Strengthening',\n",
       "       'Lusaka Transmission and Distribution Rehabilitation Project',\n",
       "       'Liberia  Accelerated Electricity Expansion Project (LACEEP)',\n",
       "       'Second Education Development Policy Loan',\n",
       "       'Sustainable livelihoods for displaced and vulnerable communities in Eastern Sudan',\n",
       "       'Malawi Economic Recovery Development Policy Operation 1',\n",
       "       'Lao PDR Customs and Trade Facilitation Project - Additional Financing',\n",
       "       'NIGER COMMUNITY ACTION PROGRAM PHASE 3', 'PNPM Justice Services',\n",
       "       'GZ-Second Municipal Development Project', 'WBG - PRDP Support V',\n",
       "       'MENA- Desert Ecosystems and Livelihoods Knowledge Sharing and Coordination Project',\n",
       "       'BF-Youth Employment & Skills Development',\n",
       "       'IRRIGATION SYSTEM ENHANCEMENT PROJECT',\n",
       "       'Energy Efficiency Project',\n",
       "       'Uganda Energy for Rural Transformation IPF Phase2 Additional Financing',\n",
       "       'Southern Africa Trade and Transport Facilitation Project',\n",
       "       'Improving Maternal and Child Health through Integrated Social Services',\n",
       "       'Haiti Business Development and Investment Project',\n",
       "       'Development Policies for the State of Sergipe',\n",
       "       'Cash Transfer Program for Vulnerable Children in Northern Togo',\n",
       "       'Social Promotion And Protection Project',\n",
       "       'Yemen Public Finance Modernization Project - Additional Financing',\n",
       "       'Burkina Faso  Donsin Transport Infrastructure Project',\n",
       "       'Nepal: School Sector Reform Program Additional Financing',\n",
       "       'Sustainable Financing for Biodiversity Conservation and Natural Resources Management',\n",
       "       'Kali Gandaki A Hydropower Plant Rehabilitation Project (KGAHPRP)',\n",
       "       'India Low-Income Housing Finance',\n",
       "       'India Second Kerala State Transport Project',\n",
       "       'Integration of Children with Disabilities into Mainstream Schools',\n",
       "       'Quality of Decentralized Service Delivery Support Development Policy Operation',\n",
       "       'Vietnam Inclusive Innovation Project',\n",
       "       'China: Jiangxi Shangrao Sanqingshan Airport Project',\n",
       "       'AF - Clean-up & Land Reclamation Project',\n",
       "       'ID-TF PNPM Disabled Persons Organisations Program',\n",
       "       'Governance II',\n",
       "       'Zambia Strengthening Climate Resilience (PPCR Phase II)',\n",
       "       'DRC Urban  Development Project FY13',\n",
       "       'Fourth East West Highway Improvement Project',\n",
       "       'Competitiveness and Enterprise Development Project (CEDP)',\n",
       "       'Additional Finaning of Public Procurement Reform Project II',\n",
       "       'Public Accounting Certification Training',\n",
       "       'ID-TF NATIONAL PROGRAM FOR COMMUNITY EMPOWERMENT IN RURAL AREAS HEALTHY AND BRIGHT GENERATION (PNPM GENERASI)',\n",
       "       'Kyrgyz Second Health and Social Protection Project',\n",
       "       'Add. Fin. - Third Water Supply and Sanitation for Low Income Communities (Community Based Water Supply/PAMSIMAS II)',\n",
       "       'ZR SUPPORT TO BASIC EDUCATION PROGRAM',\n",
       "       'National AIDS Control Support Project',\n",
       "       'Skills Development for Growth Project',\n",
       "       'Sustainable Coffee Landscape Project',\n",
       "       'Emergency Safety Nets project (Jigis&#233;m&#233;jiri)',\n",
       "       'Enhancing Education Development Project',\n",
       "       'Second Shared Growth Credit',\n",
       "       'LAOSTAT-STRENGTHENING THE NATIONAL STATISTICAL SYSTEM PROJECT',\n",
       "       'Danang Sustainable City Development Project (SCDP)',\n",
       "       'Second Science & Technology Project',\n",
       "       'Jordan Ozone Depleting Substances HCFC Phase-Out Project (ODS3)',\n",
       "       'SERBIA ROAD REHABILITATION AND SAFETY PROJECT',\n",
       "       'Revenue Administration Modernization Project',\n",
       "       'Urban Scale Building Energy Efficiency and Renewable Energy',\n",
       "       'Additional Financing Energy Efficiency - Industrial Enterprises',\n",
       "       'Zambia Water Resources Development Project',\n",
       "       'Mozambique - Integrated Growth Poles Project',\n",
       "       'MZ First Agriculture Development Policy Operation AgDPO-1',\n",
       "       'Climate Resilience: Transforming Hydro-Meteorological Services',\n",
       "       'PNPM Creative Communities II',\n",
       "       'Education Sector Strategy Support Project',\n",
       "       'Preparation of SREP Investment Plan',\n",
       "       'LA-Nam Et-Phou Louey Tiger Landscape Conservation Project',\n",
       "       'Kyrgyz Health Results Based Financing',\n",
       "       'Emergency Demobilization and Transitional Reintegration Project AF',\n",
       "       'National Human and Animal Health Systems Assessment Tools and Bridges',\n",
       "       'Yemen: Preparation of SREP Investment Plan',\n",
       "       'Lesotho Maternal & Newborn Health PBF',\n",
       "       'Multi-Donor Trust Fund for PNG-IBBS',\n",
       "       'Social Inclusion and Improvement of Livelihoods of Youth, Vulnerable Women and Handicapped in Post Conflict Western Cote d&#8217;Ivoire',\n",
       "       'BJ-PRSC 8-Eighth Poverty Reduction Suppo',\n",
       "       'PE AF Sierra Rural Development Project',\n",
       "       'DJ Improving Health Sector Performance',\n",
       "       'Additional Financing for Social Fund for Development IV',\n",
       "       'Research and Innovation in Science and Technology Project',\n",
       "       'Environmental Land Management and Rural Livelihoods Project',\n",
       "       'Vietnam - Coastal Resources for Sustainable Development',\n",
       "       'China GEF Large City Congestion and Carbon Reduction Project',\n",
       "       'Sudan Basic Education Recovery Project',\n",
       "       'Uganda Support to Municipal Infrastructure Development Program',\n",
       "       'Local Governance and Service Delivery Project',\n",
       "       'MZ-Social Protection project',\n",
       "       'Mozambique Mining and Gas Technical Assistance Project',\n",
       "       'Agricultural Competitiveness and Diversification Project',\n",
       "       'Comoros Emergency Response Project (Additional Financing)',\n",
       "       'Sri Lanka - Second Health Sector Development Project',\n",
       "       'SME ENERGY EFFICIENCY',\n",
       "       'Second DPL in support of the Plan Maroc Vert',\n",
       "       'MU -Second Public Sector Performance DPL',\n",
       "       'Disease Prevention and Control Project',\n",
       "       'Turkey SME&#12288;Energy Efficiency Project',\n",
       "       'Mauritius Second Private Sector Competitiveness DPL',\n",
       "       'Tanzania Poverty Reduction Support Credit 10',\n",
       "       'Second Land Administration Project (PRODEP II)',\n",
       "       'Nigeria - State Education Program Investment Project',\n",
       "       'Energy Sector Capacity Building Project (ESCBP)',\n",
       "       'Nigeria Youth Employment & Social Support Operation',\n",
       "       'Second Programmatic Development Policy Loan',\n",
       "       'TZ First Power and Gas Sector DPO', 'Cameroon Social Safety Nets',\n",
       "       'NE - Transp Sector Program Support Project Addit Fin',\n",
       "       'Second Growth and Competitiveness Grant',\n",
       "       'CN: Beijing Rooftop Solar Photovoltaic Scale-Up (Sunshine Schools) Project',\n",
       "       'Liaoning Coastal Economic Zone Urban Infrastructure and Environmental Management Project',\n",
       "       'CN-Jiangxi Poyang Lake Basin and Ecological Economic Zone Small Town Development Project',\n",
       "       'Green Energy Schemes for Low-carbon City in Shanghai',\n",
       "       'Green Energy Schemes for Low-carbon City in Shanghai, China',\n",
       "       'Jiangxi Wuxikou Integrated Flood Management Project',\n",
       "       'VU:  Telecommunications and ICT TA, Additional Financing',\n",
       "       'Economic Management Competitiveness Credit 1',\n",
       "       'PH - PH Development Policy Loan 2',\n",
       "       'MH:  First ICT Sector Development Operation',\n",
       "       'Afghanistan - Second Skills Development Project',\n",
       "       'Emergency Agriculture Support Project',\n",
       "       'Agricultural Productivity Program for Southern Africa (APPSA)',\n",
       "       'Pakistan: Second Sindh Education Sector Project',\n",
       "       'AF-Forest and Adjacent Land Management',\n",
       "       'Rwanda Second Support to Social Protection System',\n",
       "       'BJ-Forest & Adjacent Land Mgmt Addit Fin',\n",
       "       'Kiribati Grid  Connected Solar PV Project',\n",
       "       'Economic Competitiveness Support Program DPL',\n",
       "       'Morocco Social and Integrated Agriculture',\n",
       "       'Second Additional Financing to the North Sudan Decentralized Health System Development Project',\n",
       "       'Sector Support for Education Reform Project',\n",
       "       'Additional Financing to Health System Improvement Project',\n",
       "       'MSME Development Project for Inclusive Growth',\n",
       "       'ID-TF PNPM Pro-Poor Planning, Budgeting and Monitoring Program',\n",
       "       'ID-PNPM Village Training Project', 'Yemen Household Budget Survey',\n",
       "       'Higher Education Development Policy Program - Third Operation',\n",
       "       'Vietnam School Readiness Promotion Project',\n",
       "       'Ethiopia Health MDG Support Operation',\n",
       "       'China:Fujian Meizhou Bay Navigation Improvement Project',\n",
       "       'Afghanistan: System Enhancement for Health Action in Transition Project',\n",
       "       'Community-based Livelihood Support for the Urban Poor',\n",
       "       'AusAid TA for Vietnam Rural Water Supply and Sanitation PforR',\n",
       "       'Reducing the Vulnerability of Small Farmers to Price Risk',\n",
       "       'AFSF-Burkina Faso-FCPB', 'PNG Energy Sector Development Project',\n",
       "       'GM- PG Energy Sector Development Project',\n",
       "       'Rwanda Electricity Access additional Financing',\n",
       "       'RY-Road Asset Management Project',\n",
       "       'Building Resilience to Climate Related Hazards',\n",
       "       'Solid Waste Sector DPL3',\n",
       "       'Yemen: Second Basic Education Development Project',\n",
       "       'Emergency Crisis Recovery Project',\n",
       "       'AFSF - Asia - Cambodia - AMRET',\n",
       "       'Nepal Agriculture and Food Security Project',\n",
       "       'Climate Resilient Participatory Afforestation and Reforestation Project',\n",
       "       'Solid Waste Management OBA Pilot in West Bank',\n",
       "       'Kazakhstan - Youth Corps program',\n",
       "       'Health Sector Strategic Plan Support Additional Financing',\n",
       "       'PEFA Study for Local Governments in Croatia',\n",
       "       'Improving Resilience to Seismic Risk',\n",
       "       'Enhancing the Climate Resilience of the West Coast Road',\n",
       "       'Microfinance Development Project',\n",
       "       'Sierra Leone Energy Access Project - Sierra Leone Infrastructure Development Fund',\n",
       "       'LIFELINE ROAD NETWORK IMPROVEMENT PROJECT',\n",
       "       'Emergency Livestock Feed Access Project',\n",
       "       'JSDF Strengthening the Livelihoods and Voice of Vulnerable and Disabled Persons in Armenia',\n",
       "       'Mekong Delta Transport Infrastructure Development Project - Additional Financing',\n",
       "       'SUSTAINABLE AGRICULTURE AND CLIMATE CHANGE MITIGATION PROJECT (GEF)',\n",
       "       'Mozambique Nutrition Additional Financing',\n",
       "       'Moldova Education Reform Project',\n",
       "       'Mozambique Climate Change Development Policy Operation',\n",
       "       'Strengthening the Capacity of the Court of Accounts of Moldova (CoA)',\n",
       "       'Tunisia: Ecotourism and Conservation of Desert Biodiversity',\n",
       "       'MM-Reengagement and Reform Support Program',\n",
       "       'Nigeria Post-Compliance I EITI', 'PE Basic Education',\n",
       "       'Hunan Forest Restoration and Development Project',\n",
       "       'NI AF Rural Water Supply and Sanitation',\n",
       "       'HIV/AIDS Prevention Additional Financing',\n",
       "       \"TANZANIA SECOND CENTRAL TRANSP CORRIDOR PROJECT - ADD'L FINANC\",\n",
       "       'Community Agricultural Resource Management and Competitiveness Project',\n",
       "       'Second MDTF for Capacity Building Support to Implement the IPS (IPS 2)',\n",
       "       'ENPI East Countries FLEG II Program',\n",
       "       'Vietnam:  Global Partnership for Education - Vietnam Escuela Nueva Project',\n",
       "       'Integrated Disaster and Land Management Project',\n",
       "       'FYR Macedonia Public Expenditure PBG',\n",
       "       'Nile Cooperation for Results Project',\n",
       "       'Community Climate Change Project',\n",
       "       'PNG Social and Economic Empowerment for Women in Mining and Petroleum Areas',\n",
       "       'Maldives  Ari Atoll Solid Waste Management Project',\n",
       "       'Azerbaijan - Establishment of Meta-Information System',\n",
       "       'SN- First Governance and Growth Support Project',\n",
       "       'Namibian Coast Conservation Additional Finance',\n",
       "       'Third Phase Community Based Rural Development Project',\n",
       "       'Sustainable land and forestry management Project',\n",
       "       'Second Additional Financing for the Second Village Investment Project',\n",
       "       'DEVSTAT Additional Financing',\n",
       "       'Disaster Risk Management Program for The Third National Program For Community Empowerment in Urban Areas',\n",
       "       'DRC Phase II: Extractive Industries Transparency Initiative',\n",
       "       'Central African Republic - Post Compliance I',\n",
       "       'Afghanistan: National Horticulture and Livestock Productivity Project',\n",
       "       'Youth Employment', 'Alat and Karakul Water Supply Project',\n",
       "       'HN Safer Municipalities',\n",
       "       'Financial Reporting and Oversight Improvement Project',\n",
       "       'Productive and Sustainable Cities Development Policy Loan',\n",
       "       'PE Social Inclusion DPL', 'PE Social Inclusion TAL',\n",
       "       'Disaster Risk Management Project',\n",
       "       'Social Welfare and Development Reform Project Additional Financing',\n",
       "       'NATIONAL PROGRAM FOR COMMUNITY EMPOWERMENT IN RURAL AREA (PNPM RURAL 2012-2015',\n",
       "       'The Gambia Emergency Agricultural Production Support Project',\n",
       "       'Increasing Resilience to Climate Change and Natural Hazards in Vanuatu',\n",
       "       'HIGHER EDUCATION QUALITY IMPROVEMENT',\n",
       "       'Lao PDR Second Trade Development Facility Project',\n",
       "       'KP Southern Area Development Project',\n",
       "       'Water Resources and Irrigation Project',\n",
       "       'Comoros Development Policy Grant 2', 'Competitiveness DPL',\n",
       "       'Madagascar Emergency Support to Critical Education, Health and Nutrition Services Project',\n",
       "       'Emergency Infrastructure Preservation & Vulnerability Reduction Project',\n",
       "       'TAJIKISTAN SECOND PUBLIC EMPLOYMENT FOR SUSTAINABLE AGRICULTURE AND WATER RESOURCES MANAGEMENT PROJECT',\n",
       "       'GZ-Gaza Water Supply & Sewage System Improvement',\n",
       "       'JO-Badia Ecosystem and Livelihoods',\n",
       "       'Tunisia - Governance, Opportunities and Jobs DPL',\n",
       "       'Improving Livestock Production and Marketing Project - A Pilot',\n",
       "       'China HCFC Phase-Out Project (Stage I)',\n",
       "       'Himachal Pradesh Watershed Management Project',\n",
       "       'First Connectivity Development Policy Loan',\n",
       "       'National Community  Empowerment Program In Urban Areas For 2012-2015',\n",
       "       'Institutional, Tax Administration, Social and Investment (INSTANSI) DPL',\n",
       "       'Financial sector and Investment climate Reform and Modernization DPL',\n",
       "       'Sustainable Rural Development Additional Financing',\n",
       "       'MDTF FATA Emergency Rural Roads Project',\n",
       "       'Pacific catastrophe risk insurance pilot program',\n",
       "       'Judicial Performance Improvement',\n",
       "       'Kenya Infrastructure Finance/PPP project',\n",
       "       'Additional Financing for the Project for Agriculture Commercialization and Trade',\n",
       "       'Tonga Economic Recovery Operation II',\n",
       "       'Vietnam-HCFC Phase-out Project (Phase I)',\n",
       "       'Road Rehabilitation and Maintenance Program',\n",
       "       'Adaptation of Nicaraguas  Water Supplies to Climate Change',\n",
       "       'Second  Programmatic Fiscal Sustainability and Growth Resilience Development Policy Loan',\n",
       "       'Public Sector Management and Social Inclusion Development Policy Loan',\n",
       "       'Hurricane Felix Emergency Recovery Additional Financing',\n",
       "       'Jamaica Social and Economic Inclusion of Persons with Disabilities',\n",
       "       'Vietnam Climate Change Development Policy 2', 'CTF in Ukraine',\n",
       "       'SWAp for Parana Multi-sector Development Project',\n",
       "       'Additional Financing - Rio de Janeiro Sustainable Rural Development',\n",
       "       'Second Regional Development Project',\n",
       "       'Emergency Targeted Nutrition Intervention',\n",
       "       'MV: Statistical Capacity Building',\n",
       "       'Jordan Statistical Capacity Building TF',\n",
       "       'Strengthen IYCF Capacity in SAR',\n",
       "       'Competitiveness Developmenet Policy Operation',\n",
       "       'Results-Based Rural Water Supply and Sanitation Under the National Target Program',\n",
       "       'Myanmar National Community Driven Development Project',\n",
       "       'Tajikistan PDPG6', 'LB Supporting Innovation in SMEs Project',\n",
       "       'Amanar for Youth Berbers', 'Tax Administration',\n",
       "       'Vietnam Industrial Pollution Management Project',\n",
       "       'REAL ESTATE REGISTRATION PROJECT',\n",
       "       'HP State Roads Project - Additional Financing',\n",
       "       'Urban Local Government Strengthening Program',\n",
       "       'Burundi Sixth Economic Reform Support Grant - First Operation in the series of 3',\n",
       "       'Rural Alliances Project II',\n",
       "       'BO Urban Infrastructure Project (II) Additional Finance',\n",
       "       'Second Additional Financing Burundi Health Sector Development Support Project',\n",
       "       'Accelerated Food Security Project Additional Financing',\n",
       "       'Tanzania: Third Additional Financing for Agricultural Sector Development Project',\n",
       "       'Community Peacebuilding Initiatives in Casamance, Senegal',\n",
       "       'Output-Based Aid for Municipal Solid Waste Management',\n",
       "       'International Institute for Water and Environmental Engineering AF',\n",
       "       'Ghana Partnership for Education',\n",
       "       'Energy Sector Cleanup and Land Reclamation Trust Fund',\n",
       "       'Moroccan Association of Family Renaissance',\n",
       "       'Barefoot Engineers III',\n",
       "       'An Innovative, Integrated Approach to Enhance Smallholder Family Nutrition',\n",
       "       'Remote Rural Communities Development Project', 'BT:  DPC 2',\n",
       "       'First Part of the Second Phase of the Niger Basin Water Resources Development and Sustainable Ecosystems Management Program - APL 2A',\n",
       "       'BD: Reaching Out of School Children II',\n",
       "       'Second Additional Financing for Third Partnership for Polio Eradication Project',\n",
       "       'India - Bihar Panchayat Strengthening Project',\n",
       "       'Costa Rica Higher Education',\n",
       "       'Support to Uruguayan Public Schools Project',\n",
       "       'Rebuilding Energy Infrastructure and Access',\n",
       "       'India:  Karnataka Health Systems Additional Financing',\n",
       "       'AF Infrastructure & Institutions Emergency Recovery',\n",
       "       'AF - HP Mid-Himalayan Watershed Development Project',\n",
       "       'First Programmatic Development Policy Loan',\n",
       "       'NG-RURAL ACCESS & MOBILITY PROJECT-Phase 2',\n",
       "       'Ethiopia-Transport Sector Project in Support of RSDP4',\n",
       "       'Mineral Governance Support Project',\n",
       "       'Ethiopia Promoting Basic Services Program Phase III Project',\n",
       "       'BD:  Leveraging ICT Growth, Employment and Governance Project',\n",
       "       'Second Rural Transport Improvement Project',\n",
       "       'RUSSIA FOREST FIRE RESPONSE PROJECT',\n",
       "       'FIRST SUSTAINABILITY AND COMPETITVENESS DEVELOPMENT POLICY LOAN',\n",
       "       'SECOND ROAD AND SAFETY IMPROVEMENT PROJECT',\n",
       "       'Export Finance Intermediation Loan Additional Financing',\n",
       "       'Road Asset Management Project - Additional Financing',\n",
       "       'Rural Electrification and Renewable Energy Development II (RERED II) Project',\n",
       "       'Reports to Conventions - UNCCD - Armenia',\n",
       "       'Land Degradation Enabling Activities - Albania',\n",
       "       'PK: Punjab Cities Governance Improvement',\n",
       "       'Indonesia Infrastructure Guarantee Fund Project',\n",
       "       'Distribution Efficiency Project',\n",
       "       'Additional Financing for the Second Rural Enterprise Support Project',\n",
       "       'Punjab Land Records Management and Information Systems Project - Additional Financing',\n",
       "       'Strengthening the resilience capacity of Maya indigenous peoples and peasants to cope with food insecurity and CC in GT dry-corridor',\n",
       "       'Zambia - Extractive Industries Transparency Initiative Implementation Post Compliance I',\n",
       "       'India: ICDS Systems Strengthening & Nutrition Improvement Program (ISSNIP)',\n",
       "       'Karnataka Watershed Development II',\n",
       "       'IN: Development Policy Loan (DPL) to Promote Inclusive Green Growth and Sustainable Development in Himachal Pradesh',\n",
       "       'Multi Donor Facility - PH Mindanao Reconstruction & Development',\n",
       "       'Capacity Builiding for Emerging Infectious Disease Preparedness',\n",
       "       '5M: Displaced People in Jordan / Lebanon',\n",
       "       'Sustainable Production Systems and Biodiversity',\n",
       "       'RIO STATE DEVELOPMENT POLICY LOAN III',\n",
       "       'Papua New Guinea Settlement Upgrading Programme',\n",
       "       \"Nepal PFM-MDTF Strengthening Civil Society Organizations' use of Social Accountability to improve PFM in Nepal\",\n",
       "       'Water Supply and Sanitation Improvements for West Bethlehem Villages',\n",
       "       \"Pakistan: Promoting Girls' Education in Balochistan (PGEB)\",\n",
       "       'Revision and Alignment of NAP with UNCCD 10-year Strategic Plan and Framework',\n",
       "       'Nepal: Pilot Project for Seismic School Safety in the kathmandu',\n",
       "       'Technological Scale Up for Youth-led Urban Ornamental Aquaculture',\n",
       "       'Lao Eight Poverty Reduction Support',\n",
       "       'Second Emergency Agricultural Productivity Support Project',\n",
       "       'Sustainable Management of Agricultural Research and Technology Dissemination (SMARTD)',\n",
       "       'KENYA: NATIONAL URBAN TRANSPORT IMPROVEMENT PROJECT'], dtype=object)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#List unique values in the df['name'] column\n",
    "x.project_name.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Grouping all countries by the number of unique projects they have\n",
    "df = x.groupby('countryname')['project_name'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Checking the type of df\n",
    "type(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "\n",
    "# Converting df (which is of Series type) to Pandas Dataframe type\n",
    "df1=pd.DataFrame(df)\n",
    "# Renaming the Column Names\n",
    "df1.columns = ['Project Count']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Project Count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>countryname</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>People's Republic of China</th>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Republic of Indonesia</th>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Socialist Republic of Vietnam</th>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Republic of India</th>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Republic of Yemen</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>People's Republic of Bangladesh</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nepal</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kingdom of Morocco</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Republic of Mozambique</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Africa</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Project Count\n",
       "countryname                                   \n",
       "People's Republic of China                  19\n",
       "Republic of Indonesia                       19\n",
       "Socialist Republic of Vietnam               17\n",
       "Republic of India                           16\n",
       "Republic of Yemen                           13\n",
       "People's Republic of Bangladesh             12\n",
       "Nepal                                       12\n",
       "Kingdom of Morocco                          12\n",
       "Republic of Mozambique                      11\n",
       "Africa                                      11"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sorting the dataframe by the project count\n",
    "df1=df1.sort_values(by=['Project Count'],ascending=False, na_position='first')\n",
    "df1.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Find the top 10 major project themes (using column 'mjtheme_namecode')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Loading the JSON data \n",
    "r = json.load((open('world_bank_projects.json')))\n",
    "y=json_normalize(r, 'mjtheme_namecode')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "code    0\n",
      "name    0\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Checking the count of NAN values in every column\n",
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):\n",
    "    print(y.isnull().sum())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Re-ordering the columns \n",
    "y = y[['name', 'code']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "name    object\n",
       "code    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking the data types of each column\n",
    "y.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "name    object\n",
       "code     int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Re-checking the data types of each column\n",
    "y[['code']] = y[['code']].apply(pd.to_numeric)\n",
    "y.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Human development</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Economic management</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Social protection and risk management</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Trade and integration</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    name  code\n",
       "0                      Human development     8\n",
       "1                                           11\n",
       "2                    Economic management     1\n",
       "3  Social protection and risk management     6\n",
       "4                  Trade and integration     5"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking the contents of the data frame\n",
    "y.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Economic management</th>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Environment and natural resources management</th>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Financial and private sector development</th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Human development</th>\n",
       "      <td>197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Public sector governance</th>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rule of law</th>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rural development</th>\n",
       "      <td>202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Social dev/gender/inclusion</th>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Social protection and risk management</th>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              code\n",
       "                                             count\n",
       "name                                              \n",
       "                                               122\n",
       "Economic management                             33\n",
       "Environment and natural resources management   223\n",
       "Financial and private sector development       130\n",
       "Human development                              197\n",
       "Public sector governance                       184\n",
       "Rule of law                                     12\n",
       "Rural development                              202\n",
       "Social dev/gender/inclusion                    119\n",
       "Social protection and risk management          158"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x=y.groupby(['name']).agg(['count'])\n",
    "x.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### In 2. above you will notice that some entries have only the code and the name is missing. Create a dataframe with the missing names filled in."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Reloading the JSON data and saving it in the form of a DataFrame\n",
    "r = json.load((open('world_bank_projects.json')))\n",
    "y=json_normalize(r, 'mjtheme_namecode')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "code    0\n",
      "name    0\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Checking the count of NAN values in every column\n",
    "with pd.option_context('display.max_rows', None, 'display.max_columns', None):\n",
    "    print(y.isnull().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Re-ordering the columns \n",
    "y = y[['name', 'code']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "name    object\n",
       "code     int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Re-checking the data types of each column\n",
    "y[['code']] = y[['code']].apply(pd.to_numeric)\n",
    "y.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Human development</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Economic management</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Social protection and risk management</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Trade and integration</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    name  code\n",
       "0                      Human development     8\n",
       "1                                           11\n",
       "2                    Economic management     1\n",
       "3  Social protection and risk management     6\n",
       "4                  Trade and integration     5"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking the contents of the data frame\n",
    "y.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Filtering the y dataframe by the name of the column\n",
    "z=y.loc[y['code'] == 11]\n",
    "# Changing the obtained Series Type to Pandas DataFrame type \n",
    "z = pd.DataFrame(z)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Environment and natural resources management</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Environment and natural resources management</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Environment and natural resources management</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Environment and natural resources management</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            name  code\n",
       "1                                                   11\n",
       "6   Environment and natural resources management    11\n",
       "16  Environment and natural resources management    11\n",
       "28  Environment and natural resources management    11\n",
       "31  Environment and natural resources management    11"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking the contents of the data frame\n",
    "z.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### It is clear that the missing entry for names column is 'Environment and natural resources management'. Hence we'll start filling up the above mentioned entry wherever there is a blank space. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Human development</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Environment and natural resources management</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Economic management</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Social protection and risk management</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Trade and integration</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           name  code\n",
       "0                             Human development     8\n",
       "1  Environment and natural resources management    11\n",
       "2                           Economic management     1\n",
       "3         Social protection and risk management     6\n",
       "4                         Trade and integration     5"
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Substituting empty spaces with specific values\n",
    "Final=y.replace('', 'Environment and natural resources management')\n",
    "#Converting the obtained Series into Dataframe\n",
    "Final = pd.DataFrame(Final)\n",
    "Final.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Final['name'][Final['name'] == ''].count()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Hence there are no empty values in the names column in the dataframe"
   ]
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}