{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name": "ISTA322_FinalProjectTemplate.ipynb", "provenance": [] }, "kernelspec": { "name": "python3", "display_name": "Python 3" } },...

1 answer below »
Deadline : Tuesday Nights


{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name": "ISTA322_FinalProjectTemplate.ipynb", "provenance": [] }, "kernelspec": { "name": "python3", "display_name": "Python 3" } }, "cells": [ { "cell_type": "markdown", "metadata": { "id": "l0YVyBu0SnDv" }, "source": [ "# Template for your final project\n", "\n", "This is just a template that hopefully provides a rough guideline for your final project. You will obviously need to add sections, descriptions, text, and code as needed. " ] }, { "cell_type": "markdown", "metadata": { "id": "A2O9EVQSS9ht" }, "source": [ "## Data import\n", "\n", "Import your dataset or multiple datasets here below. Start by adding a text cell that talks about what the dataset is and provides a link to the original data source and description (i.e. it should take me to a high-level page that describes the data or source, not to a raw CSV or JSON). \n", "\n", "Then add code cells that import the data from a stable source and verifies that they have been loaded. \n", "\n", "You should also load all necessary libraries at the start. \n" ] }, { "cell_type": "code", "metadata": { "id": "15ucntg9SitM" }, "source": [ "Data Source - Kaggle - Link: https://www.kaggle.com/theworldbank/world-bank-intl-education" ], "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "iPR1QogNFAgm" }, "source": [ "## Explore your data\n", " \n", "Below take some time to explore your date. Check out the following items.\n", " \n", "* Head and tail of both datasets\n", "* Shape\n", "* Datatypes\n", "* The number of NaN values in the rating column of the ratings dataset\n", " \n", "**Task** Do the head,tail, and shape operations all in one cell. Count the number of NaNs in another. " ] }, { "cell_type": "code", "metadata": { "id": "CtuR3bP6T2lN" }, "source": [ "" ], "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "F7pz9GdhTnMP" }, "source": [ "## Roadmap\n", "\n", "Add in text cells that describe what the data are based on your exploration *and* where you want to take the data. In other words, what is your data endpoint? Also describe the specific steps you need to take in your extractions and transformations to get to that endpoint." ] }, { "cell_type": "code", "metadata": { "id": "tKD4aB_3T1kB" }, "source": [ "" ], "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "-21CvY52T3St" }, "source": [ "## Transforms\n", " \n", "Start your transforms here. You should be doing the transforms you listed in your roadmap. For each transform describe what you're doing by annotating the code. Also include code that validates that the transformed data looks like what you want it to. For example, if you filtered data, do a summary of some type that makes sure your data contains the correct filtered values. \n", " \n", "This section will be the most intensive." ] }, { "cell_type": "code", "metadata": { "id": "OwSh837tUO9B" }, "source": [ "" ], "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "6F1eCoP4UOiY" }, "source": [ "## Normalize your data for loads\n", " \n", "Break down the data you transformed into normalized tables that you'll then push to your database. Start by describing what tables you want to create in a text cell, then create those tables in code cells.\n" ] }, { "cell_type": "code", "metadata": { "id": "_ZwFFAwNU0FI" }, "source": [ "" ], "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "uEhtj0b0Uy2v" }, "source": [ "## Load to database\n", " \n", "First, set up your database on AWS like we did previously. Then set up a connection and cursor function with your credentials so you and I can access it.\n", " \n", "Once that is done build the appropriate tables, prepare your data, and load them into the databases.\n" ] }, { "cell_type": "code", "metadata": { "id": "s8ttjyo8VP2v" }, "source": [ "" ], "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "PlM4tK-oVQTZ" }, "source": [ "## Check\n", " \n", "Perform some SQL check to validate that your data is in the database. Do a basic select and filter, or a simple join, for example. " ] } ] } Final Project ISTA 322 - Data Engineering Goal of final project ● Develop a full data engineering pipeline on real-world data ● ETL ○ Extract data from an online source ○ Do transformations needed in python /
Answered Same DayDec 13, 2021

Answer To: { "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name":...

Swapnil answered on Dec 16 2021
123 Votes
assignment/.ipynb_checkpoints/assign-checkpoint.ipynb{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import numpy as np\n",
"import pandas as pd\n",
"import matplotlib.pyplot as plt"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"edstats_country = pd.read_csv(\"EdStatsCountry.csv\")"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"\n",
"RangeIndex: 241 entries, 0 to 240\n",
"Data columns (total 32 columns):\n",
"Country Code 241 non-null object\n",
"Short Name 241 non-null object\n",
"Table Name 241 non-null object\n",
"Long Name 241 non-null object\n",
"2-alpha code 238 non-null object\n",
"Currency Unit 215 non-null object\n",
"Special Notes 145 non-null object\n",
"Region 214 non-null object\n",
"Income Group 214 non-null object\n",
"WB-2 code 240 non-null object\n",
"National accounts base year 205 non-null object\n",
"National accounts reference year 32 non-null float64\n",
"SNA price valuation 197 non-null object\n",
"Lending category 144 non-null object\n",
"Other groups 58 non-null object\n",
"System of National Accounts 215 non-null object\n",
"Alternative conversion factor 47 non-null object\n",
"PPP survey year 145 non-null object\n",
"Balance of Payments Manual in use 181 non-null object\n",
"External debt Reporting status 124 non-null object\n",
"System of trade 200 non-null object\n",
"Government Accounting concept 161 non-null object\n",
"IMF data dissemination standard 181 non-null object\n",
"Latest population census 213 non-null object\n",
"Latest household survey 141 non-null object\n",
"Source of most recent Income and expenditure data 160 non-null object\n",
"Vital registration complete 111 non-null object\n",
"Latest agricultural census 142 non-null object\n",
"Latest industrial data 107 non-null float64\n",
"Latest trade data 185 non-null float64\n",
"Latest water withdrawal data 179 non-null object\n",
"Unnamed: 31 0 non-null float64\n",
"dtypes: float64(4), object(28)\n",
"memory usage: 60.3+ KB\n"
]
}
],
"source": [
"edstats_country.info()"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"(241, 32)"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"edstats_country.shape"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"pd.options.display.max_columns = 35"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"
Country CodeShort NameTable NameLong Name2-alpha codeCurrency UnitSpecial NotesRegionIncome GroupWB-2 codeNational accounts base yearNational accounts reference yearSNA price valuationLending categoryOther groupsSystem of National AccountsAlternative conversion factorPPP survey yearBalance of Payments Manual in useExternal debt Reporting statusSystem of tradeGovernment Accounting conceptIMF data dissemination standardLatest population censusLatest household surveySource of most recent Income and expenditure dataVital registration completeLatest agricultural censusLatest industrial dataLatest trade dataLatest water withdrawal dataUnnamed: 31
0ABWArubaArubaArubaAWAruban florinSNA data for 2000-2011 are updated from offici...Latin America & CaribbeanHigh income: nonOECDAW2000NaNValue added at basic prices (VAB)NaNNaNCountry uses the 1993 System of National Accou...NaNNaNIMF Balance of Payments Manual, 6th edition.NaNSpecial trade systemNaNNaN2010NaNNaNYesNaNNaN2012.0NaNNaN
1AFGAfghanistanAfghanistanIslamic State of AfghanistanAFAfghan afghaniFiscal year end: March 20; reporting period fo...South AsiaLow incomeAF2002/03NaNValue added at basic prices (VAB)IDAHIPCCountry uses the 1993 System of National Accou...NaNNaNNaNActualGeneral trade systemConsolidated central governmentGeneral Data Dissemination System (GDDS)1979Multiple Indicator Cluster Survey (MICS), 2010/11Integrated household survey (IHS), 2008NaN2013/14NaN2012.02000NaN
2AGOAngolaAngolaPeople's Republic of AngolaAOAngolan kwanzaApril 2013 database update: Based on IMF data,...Sub-Saharan AfricaUpper middle incomeAO2002NaNValue added at producer prices (VAP)IBRDNaNCountry uses the 1993 System of National Accou...1991–962005IMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemBudgetary central governmentGeneral Data Dissemination System (GDDS)1970Malaria Indicator Survey (MIS), 2011Integrated household survey (IHS), 2008NaN2015NaNNaN2005NaN
3ALBAlbaniaAlbaniaRepublic of AlbaniaALAlbanian lekNaNEurope & Central AsiaUpper middle incomeALOriginal chained constant price data are resca...1996.0Value added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...NaNRollingIMF Balance of Payments Manual, 6th edition.ActualGeneral trade systemBudgetary central governmentGeneral Data Dissemination System (GDDS)2011Demographic and Health Survey (DHS), 2008/09Living Standards Measurement Study Survey (LSM...Yes20122010.02012.02006NaN
4ANDAndorraAndorraPrincipality of AndorraADEuroNaNEurope & Central AsiaHigh income: nonOECDAD1990NaNNaNNaNNaNCountry uses the 1968 System of National Accou...NaNNaNNaNNaNSpecial trade systemNaNNaN2011. Population figures compiled from adminis...NaNNaNYesNaNNaN2006.0NaNNaN
\n",
"
"
],
"text/plain": [
" Country Code Short Name Table Name Long Name \\\n",
"0 ABW Aruba Aruba Aruba \n",
"1 AFG Afghanistan Afghanistan Islamic State of Afghanistan \n",
"2 AGO Angola Angola People's Republic of Angola \n",
"3 ALB Albania Albania Republic of Albania \n",
"4 AND Andorra Andorra Principality of Andorra \n",
"\n",
" 2-alpha code Currency Unit \\\n",
"0 AW Aruban florin \n",
"1 AF Afghan afghani \n",
"2 AO Angolan kwanza \n",
"3 AL Albanian lek \n",
"4 AD Euro \n",
"\n",
" Special Notes \\\n",
"0 SNA data for 2000-2011 are updated from offici... \n",
"1 Fiscal year end: March 20; reporting period fo... \n",
"2 April 2013 database update: Based on IMF data,... \n",
"3 NaN \n",
"4 NaN \n",
"\n",
" Region Income Group WB-2 code \\\n",
"0 Latin America & Caribbean High income: nonOECD AW \n",
"1 South Asia Low income AF \n",
"2 Sub-Saharan Africa Upper middle income AO \n",
"3 Europe & Central Asia Upper middle income AL \n",
"4 Europe & Central Asia High income: nonOECD AD \n",
"\n",
" National accounts base year \\\n",
"0 2000 \n",
"1 2002/03 \n",
"2 2002 \n",
"3 Original chained constant price data are resca... \n",
"4 1990 \n",
"\n",
" National accounts reference year SNA price valuation \\\n",
"0 NaN Value added at basic prices (VAB) \n",
"1 NaN Value added at basic prices (VAB) \n",
"2 NaN Value added at producer prices (VAP) \n",
"3 1996.0 Value added at basic prices (VAB) \n",
"4 NaN NaN \n",
"\n",
" Lending category Other groups \\\n",
"0 NaN NaN \n",
"1 IDA HIPC \n",
"2 IBRD NaN \n",
"3 IBRD NaN \n",
"4 NaN NaN \n",
"\n",
" System of National Accounts \\\n",
"0 Country uses the 1993 System of National Accou... \n",
"1 Country uses the 1993 System of National Accou... \n",
"2 Country uses the 1993 System of National Accou... \n",
"3 Country uses the 1993 System of National Accou... \n",
"4 Country uses the 1968 System of National Accou... \n",
"\n",
" Alternative conversion factor PPP survey year \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 1991–96 2005 \n",
"3 NaN Rolling \n",
"4 NaN NaN \n",
"\n",
" Balance of Payments Manual in use \\\n",
"0 IMF Balance of Payments Manual, 6th edition. \n",
"1 NaN \n",
"2 IMF Balance of Payments Manual, 6th edition. \n",
"3 IMF Balance of Payments Manual, 6th edition. \n",
"4 NaN \n",
"\n",
" External debt Reporting status System of trade \\\n",
"0 NaN Special trade system \n",
"1 Actual General trade system \n",
"2 Actual Special trade system \n",
"3 Actual General trade system \n",
"4 NaN Special trade system \n",
"\n",
" Government Accounting concept IMF data dissemination standard \\\n",
"0 NaN NaN \n",
"1 Consolidated central government General Data Dissemination System (GDDS) \n",
"2 Budgetary central government General Data Dissemination System (GDDS) \n",
"3 Budgetary central government General Data Dissemination System (GDDS) \n",
"4 NaN NaN \n",
"\n",
" Latest population census \\\n",
"0 2010 \n",
"1 1979 \n",
"2 1970 \n",
"3 2011 \n",
"4 2011. Population figures compiled from adminis... \n",
"\n",
" Latest household survey \\\n",
"0 NaN \n",
"1 Multiple Indicator Cluster Survey (MICS), 2010/11 \n",
"2 Malaria Indicator Survey (MIS), 2011 \n",
"3 Demographic and Health Survey (DHS), 2008/09 \n",
"4 NaN \n",
"\n",
" Source of most recent Income and expenditure data \\\n",
"0 NaN \n",
"1 Integrated household survey (IHS), 2008 \n",
"2 Integrated household survey (IHS), 2008 \n",
"3 Living Standards Measurement Study Survey (LSM... \n",
"4 NaN \n",
"\n",
" Vital registration complete Latest agricultural census \\\n",
"0 Yes NaN \n",
"1 NaN 2013/14 \n",
"2 NaN 2015 \n",
"3 Yes 2012 \n",
"4 Yes NaN \n",
"\n",
" Latest industrial data Latest trade data Latest water withdrawal data \\\n",
"0 NaN 2012.0 NaN \n",
"1 NaN 2012.0 2000 \n",
"2 NaN NaN 2005 \n",
"3 2010.0 2012.0 2006 \n",
"4 NaN 2006.0 NaN \n",
"\n",
" Unnamed: 31 \n",
"0 NaN \n",
"1 NaN \n",
"2 NaN \n",
"3 NaN \n",
"4 NaN "
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"edstats_country.head()"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"
Country CodeShort NameTable NameLong Name2-alpha codeCurrency UnitSpecial NotesRegionIncome GroupWB-2 codeNational accounts base yearNational accounts reference yearSNA price valuationLending categoryOther groupsSystem of National AccountsAlternative conversion factorPPP survey yearBalance of Payments Manual in useExternal debt Reporting statusSystem of tradeGovernment Accounting conceptIMF data dissemination standardLatest population censusLatest household surveySource of most recent Income and expenditure dataVital registration completeLatest agricultural censusLatest industrial dataLatest trade dataLatest water withdrawal dataUnnamed: 31
21BHSThe BahamasBahamas, TheCommonwealth of The BahamasBSBahamian dollarNaNLatin America & CaribbeanHigh income: nonOECDBS2006NaNValue added at basic prices (VAB)NaNNaNCountry uses the 1993 System of National Accou...NaNNaNIMF Balance of Payments Manual, 6th edition.NaNGeneral trade systemBudgetary central governmentGeneral Data Dissemination System (GDDS)2010NaNNaNNaNNaNNaN2012.0NaNNaN
29BRNBruneiBrunei DarussalamBrunei DarussalamBNBrunei dollarNaNEast Asia & PacificHigh income: nonOECDBN2000NaNValue added at producer prices (VAP)NaNNaNCountry uses the 1993 System of National Accou...NaN2005NaNNaNSpecial trade systemNaNGeneral Data Dissemination System (GDDS)2011NaNNaNYesNaNNaN2012.01994NaN
40CODDem. Rep. CongoCongo, Dem. Rep.Democratic Republic of the CongoCDCongolese francBased on INS (2000-09) and IMF (2010-13) data,...Sub-Saharan AfricaLow incomeZR2005NaNValue added at basic prices (VAB)IDAHIPCCountry uses the 1993 System of National Accou...1999–20012005IMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemConsolidated central governmentGeneral Data Dissemination System (GDDS)1984Demographic and Health Survey (DHS), 20131-2-3 survey (1-2-3), 2004/05NaNNaNNaNNaN2005NaN
41COGCongoCongo, Rep.Republic of CongoCGCFA francApril 2013 database update: Based on IMF data,...Sub-Saharan AfricaLower middle incomeCG1990NaNValue added at producer prices (VAP)BlendHIPCCountry uses the 1968 System of National Accou...19932005IMF Balance of Payments Manual, 6th edition.PreliminarySpecial trade systemConsolidated central governmentGeneral Data Dissemination System (GDDS)2007Demographic and Health Survey (DHS), 2011/12Core Welfare Indicator Questionnaire Survey (C...NaN20132009.02010.02002NaN
57EAPEast Asia & Pacific (developing only)East Asia & PacificEast Asia & Pacific (developing only)4ENaNEast Asia and Pacific regional aggregate (does...NaNNaN4ENaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
59ECAEurope & Central Asia (developing only)Europe & Central AsiaEurope & Central Asia (developing only)7ENaNEurope and Central Asia regional aggregate (do...NaNNaN7ENaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
62EGYEgyptEgypt, Arab Rep.Arab Republic of EgyptEGEgyptian poundFiscal year end: June 30; reporting period for...Middle East & North AfricaLower middle incomeEG1991/92NaNValue added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...NaN2005IMF Balance of Payments Manual, 6th edition.ActualGeneral trade systemConsolidated central governmentSpecial Data Dissemination Standard (SDDS)2006Demographic and Health Survey (DHS), 2008Expenditure survey/budget survey (ES/BS), 2011Yes2009/20102010.02012.02000NaN
73FSMMicronesiaMicronesia, Fed. Sts.Federated States of MicronesiaFMU.S. dollarFiscal year ends on September 30; reporting pe...East Asia & PacificLower middle incomeFM2004NaNValue added at basic prices (VAB)IDANaNCountry uses the 1993 System of National Accou...NaNNaNNaNNaNNaNNaNNaN2010NaNIntegrated household survey (IHS), 2000NaNNaNNaNNaNNaNNaN
80GMBThe GambiaGambia, TheRepublic of The GambiaGMGambian dalasiFiscal year end: June 30; reporting period for...Sub-Saharan AfricaLow incomeGM2004NaNValue added at producer prices (VAP)IDAHIPCCountry uses the 1993 System of National Accou...NaN2005IMF Balance of Payments Manual, 6th edition.ActualGeneral trade systemBudgetary central governmentGeneral Data Dissemination System (GDDS)2013Demographic and Health Survey (DHS), 2013Integrated household survey (IHS), 2010NaNNaN2004.02011.02000NaN
100IRNIranIran, Islamic Rep.Islamic Republic of IranIRIranian rialFiscal year end: March 20; reporting period fo...Middle East & North AfricaUpper middle incomeIR1997/98NaNValue added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...1980–20022005IMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemConsolidated central governmentGeneral Data Dissemination System (GDDS)2011Demographic and Health Survey (DHS), 2000Expenditure survey/budget survey (ES/BS), 2005Yes20132009.02011.02004NaN
114KORKoreaKorea, Rep.Republic of KoreaKRKorean wonNew base year is 2010. GDP data are available ...East Asia & PacificHigh income: OECDKR2010NaNValue added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...NaN2011IMF Balance of Payments Manual, 6th edition.NaNGeneral trade systemConsolidated central governmentSpecial Data Dissemination Standard (SDDS)2010NaNExpenditure survey/budget survey (ES/BS), 1998Yes20102008.02012.02002NaN
116LACLatin America & Caribbean (developing only)Latin America & CaribbeanLatin America & Caribbean (developing only)XJNaNLatin America and Caribbean regional aggregate...NaNNaNXJNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
144MKDMacedoniaMacedonia, FYRFormer Yugoslav Republic of MacedoniaMKMacedonian denarApril 2012 database update: Based on official ...Europe & Central AsiaUpper middle incomeMK1995NaNValue added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...NaNRollingIMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemConsolidated central governmentSpecial Data Dissemination Standard (SDDS)2002Multiple Indicator Cluster Survey (MICS), 2011Expenditure survey/budget survey (ES/BS), 2009Yes20072010.02012.02007NaN
148MNAMiddle East & North Africa (developing only)Middle East & North AfricaMiddle East & North Africa (developing only)XQNaNMiddle East and North Africa regional aggregat...NaNNaNXQNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
178PRKDem. People's Rep. KoreaKorea, Dem. Rep.Democratic People's Republic of KoreaKPDemocratic People's Republic of Korean wonNaNEast Asia & PacificLow incomeKPNaNNaNNaNNaNNaNCountry uses the 1968 System of National Accou...NaNNaNIMF Balance of Payments Manual, 6th edition.NaNNaNNaNNaN2008Multiple Indicator Cluster Survey (MICS), 2009NaNNaNNaNNaNNaN2005NaN
185RUSRussiaRussian FederationRussian FederationRURussian rubleNaNEurope & Central AsiaHigh income: nonOECDRU2000NaNValue added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...1987–952011IMF Balance of Payments Manual, 6th edition.NaNGeneral trade systemConsolidated central governmentSpecial Data Dissemination Standard (SDDS)2010World Health Survey (WHS), 2003Integrated household survey (IHS), 2012Yes20142010.02012.02001NaN
198SSASub-Saharan Africa (developing only)Sub-Saharan AfricaSub-Saharan Africa (developing only)ZFNaNSub-Saharan Africa regional aggregate (does no...NaNNaNZFNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
230VENVenezuelaVenezuela, RBRepública Bolivariana de VenezuelaVEVenezuelan bolivar fuerteNaNLatin America & CaribbeanUpper middle incomeVE1997NaNValue added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...NaN2005IMF Balance of Payments Manual, 6th edition.ActualGeneral trade systemConsolidated central governmentGeneral Data Dissemination System (GDDS)2011Multiple Indicator Cluster Survey (MICS), 2000Integrated household survey (IHS), 2012Yes2007NaN2011.02000NaN
231VIRVirgin IslandsVirgin Islands (U.S.)Virgin Islands of the United StatesVIU.S. dollarNaNLatin America & CaribbeanHigh income: nonOECDVI1982NaNNaNNaNNaNCountry uses the 1968 System of National Accou...NaNNaNNaNNaNGeneral trade systemNaNNaN2010NaNNaNYes2007NaNNaNNaNNaN
237YEMYemenYemen, Rep.Republic of YemenYEYemeni rialBased on official government statistics and In...Middle East & North AfricaLower middle incomeRY2007NaNValue added at producer prices (VAP)IDANaNCountry uses the 1993 System of National Accou...1990–962005IMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemBudgetary central governmentGeneral Data Dissemination System (GDDS)2004Demographic and Health Survey (DHS), 2013Expenditure survey/budget survey (ES/BS), 2005NaNNaN2006.02012.02005NaN
\n",
"
"
],
"text/plain": [
" Country Code Short Name \\\n",
"21 BHS The Bahamas \n",
"29 BRN Brunei \n",
"40 COD Dem. Rep. Congo \n",
"41 COG Congo \n",
"57 EAP East Asia & Pacific (developing only) \n",
"59 ECA Europe & Central Asia (developing only) \n",
"62 EGY Egypt \n",
"73 FSM Micronesia \n",
"80 GMB The Gambia \n",
"100 IRN Iran \n",
"114 KOR Korea \n",
"116 LAC Latin America & Caribbean (developing only) \n",
"144 MKD Macedonia \n",
"148 MNA Middle East & North Africa (developing only) \n",
"178 PRK Dem. People's Rep. Korea \n",
"185 RUS Russia \n",
"198 SSA Sub-Saharan Africa (developing only) \n",
"230 VEN Venezuela \n",
"231 VIR Virgin Islands \n",
"237 YEM Yemen \n",
"\n",
" Table Name Long Name \\\n",
"21 Bahamas, The Commonwealth of The Bahamas \n",
"29 Brunei Darussalam Brunei Darussalam \n",
"40 Congo, Dem. Rep. Democratic Republic of the Congo \n",
"41 Congo, Rep. Republic of Congo \n",
"57 East Asia & Pacific East Asia & Pacific (developing only) \n",
"59 Europe & Central Asia Europe & Central Asia (developing only) \n",
"62 Egypt, Arab Rep. Arab Republic of Egypt \n",
"73 Micronesia, Fed. Sts. Federated States of Micronesia \n",
"80 Gambia, The Republic of The Gambia \n",
"100 Iran, Islamic Rep. Islamic Republic of Iran \n",
"114 Korea, Rep. Republic of Korea \n",
"116 Latin America & Caribbean Latin America & Caribbean (developing only) \n",
"144 Macedonia, FYR Former Yugoslav Republic of Macedonia \n",
"148 Middle East & North Africa Middle East & North Africa (developing only) \n",
"178 Korea, Dem. Rep. Democratic People's Republic of Korea \n",
"185 Russian Federation Russian Federation \n",
"198 Sub-Saharan Africa Sub-Saharan Africa (developing only) \n",
"230 Venezuela, RB República Bolivariana de Venezuela \n",
"231 Virgin Islands (U.S.) Virgin Islands of the United States \n",
"237 Yemen, Rep. Republic of Yemen \n",
"\n",
" 2-alpha code Currency Unit \\\n",
"21 BS Bahamian dollar \n",
"29 BN Brunei dollar \n",
"40 CD Congolese franc \n",
"41 CG CFA franc \n",
"57 4E NaN \n",
"59 7E NaN \n",
"62 EG Egyptian pound \n",
"73 FM U.S. dollar \n",
"80 GM Gambian dalasi \n",
"100 IR Iranian rial \n",
"114 KR Korean won \n",
"116 XJ NaN \n",
"144 MK Macedonian denar \n",
"148 XQ NaN \n",
"178 KP Democratic People's Republic of Korean won \n",
"185 RU Russian ruble \n",
"198 ZF NaN \n",
"230 VE Venezuelan bolivar fuerte \n",
"231 VI U.S. dollar \n",
"237 YE Yemeni rial \n",
"\n",
" Special Notes \\\n",
"21 NaN \n",
"29 NaN \n",
"40 Based on INS (2000-09) and IMF (2010-13) data,... \n",
"41 April 2013 database update: Based on IMF data,... \n",
"57 East Asia and Pacific regional aggregate (does... \n",
"59 Europe and Central Asia regional aggregate (do... \n",
"62 Fiscal year end: June 30; reporting period for... \n",
"73 Fiscal year ends on September 30; reporting pe... \n",
"80 Fiscal year end: June 30; reporting period for... \n",
"100 Fiscal year end: March 20; reporting period fo... \n",
"114 New base year is 2010. GDP data are available ... \n",
"116 Latin America and Caribbean regional aggregate... \n",
"144 April 2012 database update: Based on official ... \n",
"148 Middle East and North Africa regional aggregat... \n",
"178 NaN \n",
"185 NaN \n",
"198 Sub-Saharan Africa regional aggregate (does no... \n",
"230 NaN \n",
"231 NaN \n",
"237 Based on official government statistics and In... \n",
"\n",
" Region Income Group WB-2 code \\\n",
"21 Latin America & Caribbean High income: nonOECD BS \n",
"29 East Asia & Pacific High income: nonOECD BN \n",
"40 Sub-Saharan Africa Low income ZR \n",
"41 Sub-Saharan Africa Lower middle income CG \n",
"57 NaN NaN 4E \n",
"59 NaN NaN 7E \n",
"62 Middle East & North Africa Lower middle income EG \n",
"73 East Asia & Pacific Lower middle income FM \n",
"80 Sub-Saharan Africa Low income GM \n",
"100 Middle East & North Africa Upper middle income IR \n",
"114 East Asia & Pacific High income: OECD KR \n",
"116 NaN NaN XJ \n",
"144 Europe & Central Asia Upper middle income MK \n",
"148 NaN NaN XQ \n",
"178 East Asia & Pacific Low income KP \n",
"185 Europe & Central Asia High income: nonOECD RU \n",
"198 NaN NaN ZF \n",
"230 Latin America & Caribbean Upper middle income VE \n",
"231 Latin America & Caribbean High income: nonOECD VI \n",
"237 Middle East & North Africa Lower middle income RY \n",
"\n",
" National accounts base year National accounts reference year \\\n",
"21 2006 NaN \n",
"29 2000 NaN \n",
"40 2005 NaN \n",
"41 1990 NaN \n",
"57 NaN NaN \n",
"59 NaN NaN \n",
"62 1991/92 NaN \n",
"73 2004 NaN \n",
"80 2004 NaN \n",
"100 1997/98 NaN \n",
"114 2010 NaN \n",
"116 NaN NaN \n",
"144 1995 NaN \n",
"148 NaN NaN \n",
"178 NaN NaN \n",
"185 2000 NaN \n",
"198 NaN NaN \n",
"230 1997 NaN \n",
"231 1982 NaN \n",
"237 2007 NaN \n",
"\n",
" SNA price valuation Lending category Other groups \\\n",
"21 Value added at basic prices (VAB) NaN NaN \n",
"29 Value added at producer prices (VAP) NaN NaN \n",
"40 Value added at basic prices (VAB) IDA HIPC \n",
"41 Value added at producer prices (VAP) Blend HIPC \n",
"57 NaN NaN NaN \n",
"59 NaN NaN NaN \n",
"62 Value added at basic prices (VAB) IBRD NaN \n",
"73 Value added at basic prices (VAB) IDA NaN \n",
"80 Value added at producer prices (VAP) IDA HIPC \n",
"100 Value added at basic prices (VAB) IBRD NaN \n",
"114 Value added at basic prices (VAB) IBRD NaN \n",
"116 NaN NaN NaN \n",
"144 Value added at basic prices (VAB) IBRD NaN \n",
"148 NaN NaN NaN \n",
"178 NaN NaN NaN \n",
"185 Value added at basic prices (VAB) IBRD NaN \n",
"198 NaN NaN NaN \n",
"230 Value added at basic prices (VAB) IBRD NaN \n",
"231 NaN NaN NaN \n",
"237 Value added at producer prices (VAP) IDA NaN \n",
"\n",
" System of National Accounts \\\n",
"21 Country uses the 1993 System of National Accou... \n",
"29 Country uses the 1993 System of National Accou... \n",
"40 Country uses the 1993 System of National Accou... \n",
"41 Country uses the 1968 System of National Accou... \n",
"57 NaN \n",
"59 NaN \n",
"62 Country uses the 1993 System of National Accou... \n",
"73 Country uses the 1993 System of National Accou... \n",
"80 Country uses the 1993 System of National Accou... \n",
"100 Country uses the 1993 System of National Accou... \n",
"114 Country uses the 1993 System of National Accou... \n",
"116 NaN \n",
"144 Country uses the 1993 System of National Accou... \n",
"148 NaN \n",
"178 Country uses the 1968 System of National Accou... \n",
"185 Country uses the 1993 System of National Accou... \n",
"198 NaN \n",
"230 Country uses the 1993 System of National Accou... \n",
"231 Country uses the 1968 System of National Accou... \n",
"237 Country uses the 1993 System of National Accou... \n",
"\n",
" Alternative conversion factor PPP survey year \\\n",
"21 NaN NaN \n",
"29 NaN 2005 \n",
"40 1999–2001 2005 \n",
"41 1993 2005 \n",
"57 NaN NaN \n",
"59 NaN NaN \n",
"62 NaN 2005 \n",
"73 NaN NaN \n",
"80 NaN 2005 \n",
"100 1980–2002 2005 \n",
"114 NaN 2011 \n",
"116 NaN NaN \n",
"144 NaN Rolling \n",
"148 NaN NaN \n",
"178 NaN NaN \n",
"185 1987–95 2011 \n",
"198 NaN NaN \n",
"230 NaN 2005 \n",
"231 NaN NaN \n",
"237 1990–96 2005 \n",
"\n",
" Balance of Payments Manual in use \\\n",
"21 IMF Balance of Payments Manual, 6th edition. \n",
"29 NaN \n",
"40 IMF Balance of Payments Manual, 6th edition. \n",
"41 IMF Balance of Payments Manual, 6th edition. \n",
"57 NaN \n",
"59 NaN \n",
"62 IMF Balance of Payments Manual, 6th edition. \n",
"73 NaN \n",
"80 IMF Balance of Payments Manual, 6th edition. \n",
"100 IMF Balance of Payments Manual, 6th edition. \n",
"114 IMF Balance of Payments Manual, 6th edition. \n",
"116 NaN \n",
"144 IMF Balance of Payments Manual, 6th edition. \n",
"148 NaN \n",
"178 IMF Balance of Payments Manual, 6th edition. \n",
"185 IMF Balance of Payments Manual, 6th edition. \n",
"198 NaN \n",
"230 IMF Balance of Payments Manual, 6th edition. \n",
"231 NaN \n",
"237 IMF Balance of Payments Manual, 6th edition. \n",
"\n",
" External debt Reporting status System of trade \\\n",
"21 NaN General trade system \n",
"29 NaN Special trade system \n",
"40 Actual Special trade system \n",
"41 Preliminary Special trade system \n",
"57 NaN NaN \n",
"59 NaN NaN \n",
"62 Actual General trade system \n",
"73 NaN NaN \n",
"80 Actual General trade system \n",
"100 Actual Special trade system \n",
"114 NaN General trade system \n",
"116 NaN NaN \n",
"144 Actual Special trade system \n",
"148 NaN NaN \n",
"178 NaN NaN \n",
"185 NaN General trade system \n",
"198 NaN NaN \n",
"230 Actual General trade system \n",
"231 NaN General trade system \n",
"237 Actual Special trade system \n",
"\n",
" Government Accounting concept \\\n",
"21 Budgetary central government \n",
"29 NaN \n",
"40 Consolidated central government \n",
"41 Consolidated central government \n",
"57 NaN \n",
"59 NaN \n",
"62 Consolidated central government \n",
"73 NaN \n",
"80 Budgetary central government \n",
"100 Consolidated central government \n",
"114 Consolidated central government \n",
"116 NaN \n",
"144 Consolidated central government \n",
"148 NaN \n",
"178 NaN \n",
"185 Consolidated central government \n",
"198 NaN \n",
"230 Consolidated central government \n",
"231 NaN \n",
"237 Budgetary central government \n",
"\n",
" IMF data dissemination standard Latest population census \\\n",
"21 General Data Dissemination System (GDDS) 2010 \n",
"29 General Data Dissemination System (GDDS) 2011 \n",
"40 General Data Dissemination System (GDDS) 1984 \n",
"41 General Data Dissemination System (GDDS) 2007 \n",
"57 NaN NaN \n",
"59 NaN NaN \n",
"62 Special Data Dissemination Standard (SDDS) 2006 \n",
"73 NaN 2010 \n",
"80 General Data Dissemination System (GDDS) 2013 \n",
"100 General Data Dissemination System (GDDS) 2011 \n",
"114 Special Data Dissemination Standard (SDDS) 2010 \n",
"116 NaN NaN \n",
"144 Special Data Dissemination Standard (SDDS) 2002 \n",
"148 NaN NaN \n",
"178 NaN 2008 \n",
"185 Special Data Dissemination Standard (SDDS) 2010 \n",
"198 NaN NaN \n",
"230 General Data Dissemination System (GDDS) 2011 \n",
"231 NaN 2010 \n",
"237 General Data Dissemination System (GDDS) 2004 \n",
"\n",
" Latest household survey \\\n",
"21 NaN \n",
"29 NaN \n",
"40 Demographic and Health Survey (DHS), 2013 \n",
"41 Demographic and Health Survey (DHS), 2011/12 \n",
"57 NaN \n",
"59 NaN \n",
"62 Demographic and Health Survey (DHS), 2008 \n",
"73 NaN \n",
"80 Demographic and Health Survey (DHS), 2013 \n",
"100 Demographic and Health Survey (DHS), 2000 \n",
"114 NaN \n",
"116 NaN \n",
"144 Multiple Indicator Cluster Survey (MICS), 2011 \n",
"148 NaN \n",
"178 Multiple Indicator Cluster Survey (MICS), 2009 \n",
"185 World Health Survey (WHS), 2003 \n",
"198 NaN \n",
"230 Multiple Indicator Cluster Survey (MICS), 2000 \n",
"231 NaN \n",
"237 Demographic and Health Survey (DHS), 2013 \n",
"\n",
" Source of most recent Income and expenditure data \\\n",
"21 NaN \n",
"29 NaN \n",
"40 1-2-3 survey (1-2-3), 2004/05 \n",
"41 Core Welfare Indicator Questionnaire Survey (C... \n",
"57 NaN \n",
"59 NaN \n",
"62 Expenditure survey/budget survey (ES/BS), 2011 \n",
"73 Integrated household survey (IHS), 2000 \n",
"80 Integrated household survey (IHS), 2010 \n",
"100 Expenditure survey/budget survey (ES/BS), 2005 \n",
"114 Expenditure survey/budget survey (ES/BS), 1998 \n",
"116 NaN \n",
"144 Expenditure survey/budget survey (ES/BS), 2009 \n",
"148 NaN \n",
"178 NaN \n",
"185 Integrated household survey (IHS), 2012 \n",
"198 NaN \n",
"230 Integrated household survey (IHS), 2012 \n",
"231 NaN \n",
"237 Expenditure survey/budget survey (ES/BS), 2005 \n",
"\n",
" Vital registration complete Latest agricultural census \\\n",
"21 NaN NaN \n",
"29 Yes NaN \n",
"40 NaN NaN \n",
"41 NaN 2013 \n",
"57 NaN NaN \n",
"59 NaN NaN \n",
"62 Yes 2009/2010 \n",
"73 NaN NaN \n",
"80 NaN NaN \n",
"100 Yes 2013 \n",
"114 Yes 2010 \n",
"116 NaN NaN \n",
"144 Yes 2007 \n",
"148 NaN NaN \n",
"178 NaN NaN \n",
"185 Yes 2014 \n",
"198 NaN NaN \n",
"230 Yes 2007 \n",
"231 Yes 2007 \n",
"237 NaN NaN \n",
"\n",
" Latest industrial data Latest trade data Latest water withdrawal data \\\n",
"21 NaN 2012.0 NaN \n",
"29 NaN 2012.0 1994 \n",
"40 NaN NaN 2005 \n",
"41 2009.0 2010.0 2002 \n",
"57 NaN NaN NaN \n",
"59 NaN NaN NaN \n",
"62 2010.0 2012.0 2000 \n",
"73 NaN NaN NaN \n",
"80 2004.0 2011.0 2000 \n",
"100 2009.0 2011.0 2004 \n",
"114 2008.0 2012.0 2002 \n",
"116 NaN NaN NaN \n",
"144 2010.0 2012.0 2007 \n",
"148 NaN NaN NaN \n",
"178 NaN NaN 2005 \n",
"185 2010.0 2012.0 2001 \n",
"198 NaN NaN NaN \n",
"230 NaN 2011.0 2000 \n",
"231 NaN NaN NaN \n",
"237 2006.0 2012.0 2005 \n",
"\n",
" Unnamed: 31 \n",
"21 NaN \n",
"29 NaN \n",
"40 NaN \n",
"41 NaN \n",
"57 NaN \n",
"59 NaN \n",
"62 NaN \n",
"73 NaN \n",
"80 NaN \n",
"100 NaN \n",
"114 NaN \n",
"116 NaN \n",
"144 NaN \n",
"148 NaN \n",
"178 NaN \n",
"185 NaN \n",
"198 NaN \n",
"230 NaN \n",
"231 NaN \n",
"237 NaN "
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"edstats_country[edstats_country['Short Name'] != edstats_country['Table Name']]"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"
Country CodeShort NameTable NameLong Name2-alpha codeCurrency UnitSpecial NotesRegionIncome GroupWB-2 codeNational accounts base yearNational accounts reference yearSNA price valuationLending categoryOther groupsSystem of National AccountsAlternative conversion factorPPP survey yearBalance of Payments Manual in useExternal debt Reporting statusSystem of tradeGovernment Accounting conceptIMF data dissemination standardLatest population censusLatest household surveySource of most recent Income and expenditure dataVital registration completeLatest agricultural censusLatest industrial dataLatest trade dataLatest water withdrawal dataUnnamed: 31
35CHIChannel IslandsChannel IslandsChannel IslandsNaNPound sterlingNaNEurope & Central AsiaHigh income: nonOECDJG20032007.0Value added at basic prices (VAB)NaNNaNCountry uses the 1968 System of National Accou...NaNNaNNaNNaNNaNNaNNaNGuernsey: 2009; Jersey: 2011.NaNNaNYes. Vital registration for Guernsey and Jersey.NaNNaNNaNNaNNaN
40CODDem. Rep. CongoCongo, Dem. Rep.Democratic Republic of the CongoCDCongolese francBased on INS (2000-09) and IMF (2010-13) data,...Sub-Saharan AfricaLow incomeZR2005NaNValue added at basic prices (VAB)IDAHIPCCountry uses the 1993 System of National Accou...1999–20012005IMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemConsolidated central governmentGeneral Data Dissemination System (GDDS)1984Demographic and Health Survey (DHS), 20131-2-3 survey (1-2-3), 2004/05NaNNaNNaNNaN2005NaN
158NAMNamibiaNamibiaRepublic of NamibiaNaNNamibian dollarFiscal year end: March 31; reporting period fo...Sub-Saharan AfricaUpper middle incomeNaN2010NaNValue added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...NaN2005IMF Balance of Payments Manual, 6th edition.NaNGeneral trade systemBudgetary central governmentGeneral Data Dissemination System (GDDS)2011Demographic and Health Survey (DHS), 2013Expenditure survey/budget survey (ES/BS), 2009/10NaN2014NaN2012.02002NaN
181PSEWest Bank and GazaWest Bank and GazaWest Bank and GazaPSIsraeli new shekelNaNMiddle East & North AfricaLower middle incomeGZ2004NaNValue added at basic prices (VAB)NaNNaNCountry uses the 1968 System of National Accou...NaNNaNIMF Balance of Payments Manual, 6th edition.NaNSpecial trade systemBudgetary central governmentSpecial Data Dissemination Standard (SDDS)2007Multiple Indicator Cluster Survey (MICS), 2010Integrated household survey (IHS), 2009NaNNaN2010.0NaN2005NaN
197SRBSerbiaSerbiaRepublic of SerbiaRSNew Serbian dinarMontenegro declared independence from Serbia a...Europe & Central AsiaUpper middle incomeYFOriginal chained constant price data are resca...2002.0Value added at basic prices (VAB)IBRDNaNCountry uses the 1993 System of National Accou...NaNRollingIMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemConsolidated central governmentGeneral Data Dissemination System (GDDS)2011Multiple Indicator Cluster Survey (MICS), 2010Integrated household survey (IHS), 2010Yes20122010.0NaN2009NaN
216TLSTimor-LesteTimor-LesteDemocratic Republic of Timor-LesteTLU.S. dollarBased on official government statistics, natio...East Asia & PacificLower middle incomeTP2010NaNValue added at basic prices (VAB)BlendNaNCountry uses the 2008 System of National Accou...NaNNaNNaNNaNSpecial trade systemNaNGeneral Data Dissemination System (GDDS)2010Demographic and Health Survey (DHS), 2009/10Living Standards Measurement Study Survey (LSM...NaN2010. Population and Housing Census.NaN2005.02004NaN
236XKXKosovoKosovoRepublic of KosovoNaNEuroKosovo became a World Bank member on June 29, ...Europe & Central AsiaLower middle incomeKV2008NaNValue added at basic prices (VAB)IDANaNCountry uses the 1993 System of National Accou...NaNNaNNaNActualNaNNaNGeneral Data Dissemination System (GDDS)2011NaNIntegrated household survey (IHS), 2011NaNNaNNaNNaNNaNNaN
237YEMYemenYemen, Rep.Republic of YemenYEYemeni rialBased on official government statistics and In...Middle East & North AfricaLower middle incomeRY2007NaNValue added at producer prices (VAP)IDANaNCountry uses the 1993 System of National Accou...1990–962005IMF Balance of Payments Manual, 6th edition.ActualSpecial trade systemBudgetary central governmentGeneral Data Dissemination System (GDDS)2004Demographic and Health Survey (DHS), 2013Expenditure survey/budget survey (ES/BS), 2005NaNNaN2006.02012.02005NaN
\n",
"
"
],
"text/plain": [
" Country Code Short Name Table Name \\\n",
"35 CHI Channel Islands Channel Islands \n",
"40 COD Dem. Rep. Congo Congo, Dem. Rep. \n",
"158 NAM Namibia Namibia \n",
"181 PSE West Bank and Gaza West Bank and Gaza \n",
"197 SRB Serbia Serbia \n",
"216 TLS Timor-Leste Timor-Leste \n",
"236 XKX Kosovo Kosovo \n",
"237 YEM Yemen Yemen, Rep. \n",
"\n",
" Long Name 2-alpha code Currency Unit \\\n",
"35 Channel Islands NaN Pound sterling \n",
"40 Democratic Republic of the Congo CD Congolese franc \n",
"158 Republic of Namibia NaN Namibian dollar \n",
"181 West Bank and Gaza PS Israeli new shekel \n",
"197 Republic of Serbia RS New Serbian dinar \n",
"216 Democratic Republic of Timor-Leste TL U.S. dollar \n",
"236 Republic of Kosovo NaN Euro \n",
"237 Republic of Yemen YE Yemeni rial \n",
"\n",
" Special Notes \\\n",
"35 NaN \n",
"40 Based on INS (2000-09) and IMF (2010-13) data,... \n",
"158 Fiscal year end: March 31; reporting period fo... \n",
"181 NaN \n",
"197 Montenegro declared independence from Serbia a... \n",
"216 Based on official government statistics, natio... \n",
"236 Kosovo became a World Bank member on June 29, ... \n",
"237 Based on official government statistics and In... \n",
"\n",
" Region Income Group WB-2 code \\\n",
"35 Europe & Central Asia High income: nonOECD JG \n",
"40 Sub-Saharan Africa Low income ZR \n",
"158 Sub-Saharan Africa Upper middle income NaN \n",
"181 Middle East & North Africa Lower middle income GZ \n",
"197 Europe & Central Asia Upper middle income YF \n",
"216 East Asia & Pacific Lower middle income TP \n",
"236 Europe & Central Asia Lower middle income KV \n",
"237 Middle East & North Africa Lower middle income RY \n",
"\n",
" National accounts base year \\\n",
"35 2003 \n",
"40 2005 \n",
"158 2010 \n",
"181 2004 \n",
"197 Original chained constant price data are resca... \n",
"216 2010 \n",
"236 2008 \n",
"237 2007 \n",
"\n",
" National accounts reference year SNA price valuation \\\n",
"35 2007.0 Value added at basic prices (VAB) \n",
"40 NaN Value added at basic prices (VAB) \n",
"158 NaN Value added at basic prices (VAB) \n",
"181 NaN Value added at basic prices (VAB) \n",
"197 2002.0 Value added at basic prices (VAB) \n",
"216 NaN Value added at basic prices (VAB) \n",
"236 NaN Value added at basic prices (VAB) \n",
"237 NaN Value added at producer prices (VAP) \n",
"\n",
" Lending category Other groups \\\n",
"35 NaN NaN \n",
"40 IDA HIPC \n",
"158 IBRD NaN \n",
"181 NaN NaN \n",
"197 IBRD NaN \n",
"216 Blend NaN \n",
"236 IDA NaN \n",
"237 IDA NaN \n",
"\n",
" System of National Accounts \\\n",
"35 Country uses the 1968 System of National Accou... \n",
"40 Country uses the 1993 System of National Accou... \n",
"158 Country uses the 1993 System of National Accou... \n",
"181 Country uses the 1968 System of National Accou... \n",
"197 Country uses the 1993 System of National Accou... \n",
"216 Country uses the 2008 System of National Accou... \n",
"236 Country uses the 1993 System of National Accou... \n",
"237 Country uses the 1993 System of National Accou... \n",
"\n",
" Alternative conversion factor PPP survey year \\\n",
"35 NaN NaN \n",
"40 1999–2001 2005 \n",
"158 NaN 2005 \n",
"181 NaN NaN \n",
"197 NaN Rolling \n",
"216 NaN NaN \n",
"236 NaN NaN \n",
"237 1990–96 2005 \n",
"\n",
" Balance of Payments Manual in use \\\n",
"35 NaN \n",
"40 IMF Balance of Payments Manual, 6th edition. \n",
"158 IMF Balance of Payments Manual, 6th edition. \n",
"181 IMF Balance of Payments Manual, 6th edition. \n",
"197 IMF Balance of Payments Manual, 6th edition. \n",
"216 NaN \n",
"236 NaN \n",
"237 IMF Balance of Payments Manual, 6th edition. \n",
"\n",
" External debt Reporting status System of trade \\\n",
"35 NaN NaN \n",
"40 Actual Special trade system \n",
"158 NaN General trade system \n",
"181 NaN Special trade system \n",
"197 Actual Special trade system \n",
"216 NaN Special trade system \n",
"236 Actual NaN \n",
"237 Actual Special trade system \n",
"\n",
" Government Accounting concept \\\n",
"35 NaN \n",
"40 Consolidated central government \n",
"158 Budgetary central government \n",
"181 Budgetary central government \n",
"197 Consolidated central government \n",
"216 NaN \n",
"236 NaN \n",
"237 Budgetary central government \n",
"\n",
" IMF data dissemination standard \\\n",
"35 NaN \n",
"40 General Data Dissemination System (GDDS) \n",
"158 General Data Dissemination System (GDDS) \n",
"181 Special Data Dissemination Standard (SDDS) \n",
"197 General Data Dissemination System (GDDS) \n",
"216 General Data Dissemination System (GDDS) \n",
"236 General Data Dissemination System (GDDS) \n",
"237 General Data Dissemination System (GDDS) \n",
"\n",
" Latest population census \\\n",
"35 Guernsey: 2009; Jersey: 2011. \n",
"40 1984 \n",
"158 2011 \n",
"181 2007 \n",
"197 2011 \n",
"216 2010 \n",
"236 2011 \n",
"237 2004 \n",
"\n",
" Latest household survey \\\n",
"35 NaN \n",
"40 Demographic and Health Survey (DHS), 2013 \n",
"158 Demographic and Health Survey (DHS), 2013 \n",
"181 Multiple Indicator Cluster Survey (MICS), 2010 \n",
"197 Multiple Indicator Cluster Survey (MICS), 2010 \n",
"216 Demographic and Health Survey (DHS), 2009/10 \n",
"236 NaN \n",
"237 Demographic and Health Survey (DHS), 2013 \n",
"\n",
" Source of most recent Income and expenditure data \\\n",
"35 NaN \n",
"40 1-2-3 survey (1-2-3), 2004/05 \n",
"158 Expenditure survey/budget survey (ES/BS), 2009/10 \n",
"181 Integrated household survey (IHS), 2009 \n",
"197 Integrated household survey (IHS), 2010 \n",
"216 Living Standards Measurement Study Survey (LSM... \n",
"236 Integrated household survey (IHS), 2011 \n",
"237 Expenditure survey/budget survey (ES/BS), 2005 \n",
"\n",
" Vital registration complete \\\n",
"35 Yes. Vital registration for Guernsey and Jersey. \n",
"40 NaN \n",
"158 NaN \n",
"181 NaN \n",
"197 Yes \n",
"216 NaN \n",
"236 NaN \n",
"237 NaN \n",
"\n",
" Latest agricultural census Latest industrial data \\\n",
"35 NaN NaN \n",
"40 NaN NaN \n",
"158 2014 NaN \n",
"181 NaN 2010.0 \n",
"197 2012 2010.0 \n",
"216 2010. Population and Housing Census. NaN \n",
"236 NaN NaN \n",
"237 NaN 2006.0 \n",
"\n",
" Latest trade data Latest water withdrawal data Unnamed: 31 \n",
"35 NaN NaN NaN \n",
"40 NaN 2005 NaN \n",
"158 2012.0 2002 NaN \n",
"181 NaN 2005 NaN \n",
"197 NaN 2009 NaN \n",
"216 2005.0 2004 NaN \n",
"236 NaN NaN NaN \n",
"237 2012.0 2005 NaN "
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"edstats_country[edstats_country['2-alpha code'] != edstats_country['WB-2 code']]"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Country Code 0\n",
"Short Name 0\n",
"Table Name 0\n",
"Long Name 0\n",
"2-alpha code 3\n",
"Currency...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here