
# coding: utf-8

# In[1]:


import numpy as np 
import pandas as pd 
import seaborn as sns
import matplotlib.pyplot as plt
get_ipython().magic('matplotlib inline')

import warnings
get_ipython().magic("config InlineBackend.figure_format = 'png' #set 'png' here when working on notebook")
warnings.filterwarnings('ignore') 

# Set some parameters to get good visuals - style to ggplot and size to 15,10

pd.set_option('display.width',170, 'display.max_rows',200, 'display.max_columns',300)


# In[2]:


df = pd.read_csv(r"data\WDI_csv\WDIData.csv")


# In[3]:


df.columns


# In[4]:


df.shape


# In[ ]:


df = df.drop(['Country Code','Indicator Code'], 1)


# ###### Selecting just United Kingdom

# In[5]:


df = df[df['Country Name'] == "United Kingdom"]


# In[6]:


import re
missing_values = []
nonumeric_values = []

print ("DATA SET INFORMATION")
print ("========================\n")

for column in df:
    # Find all the unique feature values
    uniq = df[column].unique()
    print ("'{}' has {} unique values" .format(column,uniq.size))
    if (uniq.size > 10):
        print("~~Listing up to 10 unique values~~")
    print (uniq[0:10])
    print ("\n-----------------------------------------------------------------------\n")
    
    # Find features with missing values
    if (True in pd.isnull(uniq)):
        s = "{} has {} missing" .format(column, pd.isnull(df[column]).sum())
        missing_values.append(s)
    
    # Find features with non-numeric values
    for i in range (1, np.prod(uniq.shape)):
        if (re.match('nan', str(uniq[i]))):
            break
        if not (re.search('(^\d+\.?\d*$)|(^\d*\.?\d+$)', str(uniq[i]))):
            nonumeric_values.append(column)
            break
  
print ("\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n")
print ("Features with missing values:\n{}\n\n" .format(missing_values))
print ("Features with non-numeric values:\n{}" .format(nonumeric_values))
print ("\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n")



# In[7]:


#Not null values for the column
# Selected 2015 because the brexit happened in 2016 
dfi2 = df[df['2015'].notnull()]


# In[8]:


list(dfi2['Indicator Name'])


# #### Uk joined EU in 1973 hence select data from 1973

# In[13]:


#Select the row with Total population , select only the years data, transpose the data and reset the index
dfi = dfi2[dfi2['Indicator Name'].isin(['Access to clean fuels and technologies for cooking  (% of population)',
 'Access to electricity (% of population)',
 'Access to electricity, rural (% of rural population)',
 'Access to electricity, urban (% of urban population)',
 'Adjusted net enrollment rate, primary (% of primary school age children)',
 'Adjusted net national income (annual % growth)',
 'Adjusted net national income (constant 2010 US$)',
 'Adjusted net national income (current US$)',
 'Adjusted net national income per capita (annual % growth)',
 'Adjusted net national income per capita (constant 2010 US$)',
 'Adjusted net national income per capita (current US$)',
 'Adjusted net savings, excluding particulate emission damage (% of GNI)',
 'Adjusted net savings, excluding particulate emission damage (current US$)',
 'Adjusted net savings, including particulate emission damage (% of GNI)',
 'Adjusted net savings, including particulate emission damage (current US$)',
 'Adjusted savings: carbon dioxide damage (% of GNI)',
 'Adjusted savings: carbon dioxide damage (current US$)',
 'Adjusted savings: consumption of fixed capital (% of GNI)',
 'Adjusted savings: consumption of fixed capital (current US$)',
 'Adjusted savings: education expenditure (% of GNI)',
 'Adjusted savings: education expenditure (current US$)',
 'Adjusted savings: energy depletion (% of GNI)',
 'Adjusted savings: energy depletion (current US$)',
 'Adjusted savings: gross savings (% of GNI)',
 'Adjusted savings: mineral depletion (% of GNI)',
 'Adjusted savings: mineral depletion (current US$)',
 'Adjusted savings: natural resources depletion (% of GNI)',
 'Adjusted savings: net forest depletion (% of GNI)',
 'Adjusted savings: net forest depletion (current US$)',
 'Adjusted savings: net national savings (% of GNI)',
 'Adjusted savings: net national savings (current US$)',
 'Adjusted savings: particulate emission damage (% of GNI)',
 'Adjusted savings: particulate emission damage (current US$)',
 'Adolescent fertility rate (births per 1,000 women ages 15-19)',
 'Adolescents out of school (% of lower secondary school age)',
 'Adolescents out of school, female (% of female lower secondary school age)',
 'Adolescents out of school, male (% of male lower secondary school age)',
 'Age dependency ratio (% of working-age population)',
 'Age dependency ratio, old (% of working-age population)',
 'Age dependency ratio, young (% of working-age population)',
 'Agricultural land (% of land area)',
 'Agricultural land (sq. km)',
 'Agricultural raw materials exports (% of merchandise exports)',
 'Agricultural raw materials imports (% of merchandise imports)',
 'Agriculture, forestry, and fishing, value added (% of GDP)',
 'Agriculture, forestry, and fishing, value added (annual % growth)',
 'Agriculture, forestry, and fishing, value added (constant 2010 US$)',
 'Agriculture, forestry, and fishing, value added (constant LCU)',
 'Agriculture, forestry, and fishing, value added (current LCU)',
 'Agriculture, forestry, and fishing, value added (current US$)',
 'Agriculture, forestry, and fishing, value added per worker (constant 2010 US$)',
 'Air transport, freight (million ton-km)',
 'Air transport, passengers carried',
 'Air transport, registered carrier departures worldwide',
 'All education staff compensation, primary (% of total expenditure in primary public institutions)',
 'All education staff compensation, secondary (% of total expenditure in secondary public institutions)',
 'All education staff compensation, total (% of total expenditure in public institutions)',
 'Alternative and nuclear energy (% of total energy use)',
 'Annualized average growth rate in per capita real survey mean consumption or income, bottom 40% of population (%)',
 'Annualized average growth rate in per capita real survey mean consumption or income, total population (%)',
 'Aquaculture production (metric tons)',
 'Arable land (% of land area)',
 'Arable land (hectares per person)',
 'Arable land (hectares)',
 'Armed forces personnel (% of total labor force)',
 'Armed forces personnel, total',
 'Arms exports (SIPRI trend indicator values)',
 'Arms imports (SIPRI trend indicator values)',
 'Automated teller machines (ATMs) (per 100,000 adults)',
 'Average transaction cost of sending remittances from a specific country (%)',
 'Bank capital to assets ratio (%)',
 'Bank nonperforming loans to total gross loans (%)',
 'Binding coverage, all products (%)',
 'Binding coverage, manufactured products (%)',
 'Binding coverage, primary products (%)',
 'Birth rate, crude (per 1,000 people)',
 'Bound rate, simple mean, all products (%)',
 'Bound rate, simple mean, manufactured products (%)',
 'Bound rate, simple mean, primary products (%)',
 'Broad money (% of GDP)',
 'Broad money (current LCU)',
 'Broad money growth (annual %)',
 'Broad money to total reserves ratio',
 'Burden of customs procedure, WEF (1=extremely inefficient to 7=extremely efficient)',
 'Business extent of disclosure index (0=less disclosure to 10=more disclosure)',
 'Capture fisheries production (metric tons)',
 'Cause of death, by communicable diseases and maternal, prenatal and nutrition conditions (% of total)',
 'Cause of death, by injury (% of total)',
 'Cause of death, by non-communicable diseases (% of total)',
 'Central government debt, total (% of GDP)',
 'Central government debt, total (current LCU)',
 'Cereal production (metric tons)',
 'Cereal yield (kg per hectare)',
 'Changes in inventories (current LCU)',
 'Changes in inventories (current US$)',
 'Charges for the use of intellectual property, payments (BoP, current US$)',
 'Charges for the use of intellectual property, receipts (BoP, current US$)',
 'Children out of school (% of primary school age)',
 'Children out of school, primary',
 'Claims on central government (annual growth as % of broad money)',
 'Claims on central government, etc. (% GDP)',
 'Claims on private sector (annual growth as % of broad money)',
 'Coal rents (% of GDP)',
 'Combustible renewables and waste (% of total energy)',
 'Commercial service exports (current US$)',
 'Commercial service imports (current US$)',
 'Communications, computer, etc. (% of service exports, BoP)',
 'Communications, computer, etc. (% of service imports, BoP)',
 'Compensation of employees (% of expense)',
 'Compensation of employees (current LCU)',
 'Compulsory education, duration (years)',
 'Computer, communications and other services (% of commercial service exports)',
 'Computer, communications and other services (% of commercial service imports)',
 'Consumer price index (2010 = 100)',
 'Container port traffic (TEU: 20 foot equivalent units)',
 'Contributing family workers, female (% of female employment) (modeled ILO estimate)',
 'Contributing family workers, male (% of male employment) (modeled ILO estimate)',
 'Contributing family workers, total (% of total employment) (modeled ILO estimate)',
 'Cost of business start-up procedures (% of GNI per capita)',
 'Cost of business start-up procedures, female (% of GNI per capita)',
 'Cost of business start-up procedures, male (% of GNI per capita)',
 'Cost to export, border compliance (US$)',
 'Cost to export, documentary compliance (US$)',
 'Cost to import, border compliance (US$)',
 'Cost to import, documentary compliance (US$)',
 'Crop production index (2004-2006 = 100)',
 'Current account balance (% of GDP)',
 'Current account balance (BoP, current US$)',
 'Current education expenditure, primary (% of total expenditure in primary public institutions)',
 'Current education expenditure, secondary (% of total expenditure in secondary public institutions)',
 'Current education expenditure, total (% of total expenditure in public institutions)',
 'Current health expenditure (% of GDP)',
 'Current health expenditure per capita (current US$)',
 'Current health expenditure per capita, PPP (current international $)',
 'Death rate, crude (per 1,000 people)',
 'DEC alternative conversion factor (LCU per US$)',
 'Depth of credit information index (0=low to 8=high)',
 'Discrepancy in expenditure estimate of GDP (constant LCU)',
 'Discrepancy in expenditure estimate of GDP (current LCU)',
 'Distance to frontier score (0=lowest performance to 100=frontier)',
 'Domestic credit provided by financial sector (% of GDP)',
 'Domestic credit to private sector (% of GDP)',
 'Domestic credit to private sector by banks (% of GDP)',
 'Domestic general government health expenditure (% of current health expenditure)',
 'Domestic general government health expenditure (% of GDP)',
 'Domestic general government health expenditure (% of general government expenditure)',
 'Domestic general government health expenditure per capita (current US$)',
 'Domestic general government health expenditure per capita, PPP (current international $)',
 'Domestic private health expenditure (% of current health expenditure)',
 'Domestic private health expenditure per capita (current US$)',
 'Domestic private health expenditure per capita, PPP  (current international $)',
 'Electricity production from coal sources (% of total)',
 'Electricity production from hydroelectric sources (% of total)',
 'Electricity production from natural gas sources (% of total)',
 'Electricity production from nuclear sources (% of total)',
 'Electricity production from oil sources (% of total)',
 'Electricity production from oil, gas and coal sources (% of total)',
 'Electricity production from renewable sources, excluding hydroelectric (% of total)',
 'Electricity production from renewable sources, excluding hydroelectric (kWh)',
 'Employers, female (% of female employment) (modeled ILO estimate)',
 'Employers, male (% of male employment) (modeled ILO estimate)',
 'Employers, total (% of total employment) (modeled ILO estimate)',
 'Employment in agriculture (% of total employment) (modeled ILO estimate)',
 'Employment in agriculture, female (% of female employment) (modeled ILO estimate)',
 'Employment in agriculture, male (% of male employment) (modeled ILO estimate)',
 'Employment in industry (% of total employment) (modeled ILO estimate)',
 'Employment in industry, female (% of female employment) (modeled ILO estimate)',
 'Employment in industry, male (% of male employment) (modeled ILO estimate)',
 'Employment in services (% of total employment) (modeled ILO estimate)',
 'Employment in services, female (% of female employment) (modeled ILO estimate)',
 'Employment in services, male (% of male employment) (modeled ILO estimate)',
 'Employment to population ratio, 15+, female (%) (modeled ILO estimate)',
 'Employment to population ratio, 15+, female (%) (national estimate)',
 'Employment to population ratio, 15+, male (%) (modeled ILO estimate)',
 'Employment to population ratio, 15+, male (%) (national estimate)',
 'Employment to population ratio, 15+, total (%) (modeled ILO estimate)',
 'Employment to population ratio, 15+, total (%) (national estimate)',
 'Employment to population ratio, ages 15-24, female (%) (modeled ILO estimate)',
 'Employment to population ratio, ages 15-24, female (%) (national estimate)',
 'Employment to population ratio, ages 15-24, male (%) (modeled ILO estimate)',
 'Employment to population ratio, ages 15-24, male (%) (national estimate)',
 'Employment to population ratio, ages 15-24, total (%) (modeled ILO estimate)',
 'Employment to population ratio, ages 15-24, total (%) (national estimate)',
 'Energy imports, net (% of energy use)',
 'Energy intensity level of primary energy (MJ/$2011 PPP GDP)',
 'Energy use (kg of oil equivalent per capita)',
 'Energy use (kg of oil equivalent) per $1,000 GDP (constant 2011 PPP)',
 'Expenditure on primary education (% of government expenditure on education)',
 'Expenditure on secondary education (% of government expenditure on education)',
 'Expenditure on tertiary education (% of government expenditure on education)',
 'Expense (% of GDP)',
 'Expense (current LCU)',
 'Export unit value index (2000 = 100)',
 'Export value index (2000 = 100)',
 'Export volume index (2000 = 100)',
 'Exports as a capacity to import (constant LCU)',
 'Exports of goods and services (% of GDP)',
 'Exports of goods and services (annual % growth)',
 'Exports of goods and services (BoP, current US$)',
 'Exports of goods and services (constant 2010 US$)',
 'Exports of goods and services (constant LCU)',
 'Exports of goods and services (current LCU)',
 'Exports of goods and services (current US$)',
 'Exports of goods, services and primary income (BoP, current US$)',
 'External balance on goods and services (% of GDP)',
 'External balance on goods and services (constant LCU)',
 'External balance on goods and services (current LCU)',
 'External balance on goods and services (current US$)',
 'External health expenditure (% of current health expenditure)',
 'External health expenditure per capita (current US$)',
 'External health expenditure per capita, PPP (current international $)',
 'Female share of employment in senior and middle management (%)',
 'Fertility rate, total (births per woman)',
 'Fertilizer consumption (kilograms per hectare of arable land)',
 'Final consumption expenditure (% of GDP)',
 'Final consumption expenditure (constant 2010 US$)',
 'Final consumption expenditure (constant LCU)',
 'Final consumption expenditure (current LCU)',
 'Final consumption expenditure (current US$)',
 'Fixed broadband subscriptions',
 'Fixed broadband subscriptions (per 100 people)',
 'Fixed telephone subscriptions',
 'Fixed telephone subscriptions (per 100 people)',
 'Food exports (% of merchandise exports)',
 'Food imports (% of merchandise imports)',
 'Food production index (2004-2006 = 100)',
 'Foreign direct investment, net (BoP, current US$)',
 'Foreign direct investment, net inflows (% of GDP)',
 'Foreign direct investment, net inflows (BoP, current US$)',
 'Foreign direct investment, net outflows (% of GDP)',
 'Foreign direct investment, net outflows (BoP, current US$)',
 'Forest area (% of land area)',
 'Forest area (sq. km)',
 'Forest rents (% of GDP)',
 'Fossil fuel energy consumption (% of total)',
 'Fuel exports (% of merchandise exports)',
 'Fuel imports (% of merchandise imports)',
 'GDP (constant 2010 US$)',
 'GDP (constant LCU)',
 'GDP (current LCU)',
 'GDP (current US$)',
 'GDP deflator (base year varies by country)',
 'GDP deflator: linked series (base year varies by country)',
 'GDP growth (annual %)',
 'GDP per capita (constant 2010 US$)',
 'GDP per capita (constant LCU)',
 'GDP per capita (current LCU)',
 'GDP per capita (current US$)',
 'GDP per capita growth (annual %)',
 'GDP per capita, PPP (constant 2011 international $)',
 'GDP per capita, PPP (current international $)',
 'GDP per person employed (constant 2011 PPP $)',
 'GDP per unit of energy use (constant 2011 PPP $ per kg of oil equivalent)',
 'GDP per unit of energy use (PPP $ per kg of oil equivalent)',
 'GDP, PPP (constant 2011 international $)',
 'GDP, PPP (current international $)',
 'GDP: linked series (current LCU)',
 'General government final consumption expenditure (% of GDP)',
 'General government final consumption expenditure (annual % growth)',
 'General government final consumption expenditure (constant 2010 US$)',
 'General government final consumption expenditure (constant LCU)',
 'General government final consumption expenditure (current LCU)',
 'General government final consumption expenditure (current US$)',
 'GINI index (World Bank estimate)',
 'GNI (constant 2010 US$)',
 'GNI (constant LCU)',
 'GNI (current LCU)',
 'GNI (current US$)',
 'GNI growth (annual %)',
 'GNI per capita (constant 2010 US$)',
 'GNI per capita (constant LCU)',
 'GNI per capita (current LCU)',
 'GNI per capita growth (annual %)',
 'GNI per capita, Atlas method (current US$)',
 'GNI per capita, PPP (constant 2011 international $)',
 'GNI per capita, PPP (current international $)',
 'GNI, Atlas method (current US$)',
 'GNI, PPP (constant 2011 international $)',
 'GNI, PPP (current international $)',
 'Goods and services expense (% of expense)',
 'Goods and services expense (current LCU)',
 'Goods exports (BoP, current US$)',
 'Goods imports (BoP, current US$)',
 'Government expenditure on education, total (% of GDP)',
 'Government expenditure on education, total (% of government expenditure)',
 'Government expenditure per student, primary (% of GDP per capita)',
 'Government expenditure per student, secondary (% of GDP per capita)',
 'Government expenditure per student, tertiary (% of GDP per capita)',
 'Grants and other revenue (% of revenue)',
 'Grants and other revenue (current LCU)',
 'Gross capital formation (% of GDP)',
 'Gross capital formation (annual % growth)',
 'Gross capital formation (constant 2010 US$)',
 'Gross capital formation (constant LCU)',
 'Gross capital formation (current LCU)',
 'Gross capital formation (current US$)',
 'Gross domestic income (constant LCU)',
 'Gross domestic savings (% of GDP)',
 'Gross domestic savings (current LCU)',
 'Gross domestic savings (current US$)',
 'Gross fixed capital formation (% of GDP)',
 'Gross fixed capital formation (annual % growth)',
 'Gross fixed capital formation (constant 2010 US$)',
 'Gross fixed capital formation (constant LCU)',
 'Gross fixed capital formation (current LCU)',
 'Gross fixed capital formation (current US$)',
 'Gross intake ratio in first grade of primary education, female (% of relevant age group)',
 'Gross intake ratio in first grade of primary education, male (% of relevant age group)',
 'Gross intake ratio in first grade of primary education, total (% of relevant age group)',
 'Gross national expenditure (% of GDP)',
 'Gross national expenditure (constant 2010 US$)',
 'Gross national expenditure (constant LCU)',
 'Gross national expenditure (current LCU)',
 'Gross national expenditure (current US$)',
 'Gross national expenditure deflator (base year varies by country)',
 'Gross savings (% of GDP)',
 'Gross savings (% of GNI)',
 'Gross savings (current LCU)',
 'Gross savings (current US$)',
 'Gross value added at basic prices (GVA) (constant 2010 US$)',
 'Gross value added at basic prices (GVA) (constant LCU)',
 'Gross value added at basic prices (GVA) (current LCU)',
 'Gross value added at basic prices (GVA) (current US$)',
 'High-technology exports (% of manufactured exports)',
 'High-technology exports (current US$)',
 'Households and NPISHs final consumption expenditure (% of GDP)',
 'Households and NPISHs Final consumption expenditure (annual % growth)',
 'Households and NPISHs Final consumption expenditure (constant 2010 US$)',
 'Households and NPISHs Final consumption expenditure (constant LCU)',
 'Households and NPISHs Final consumption expenditure (current LCU)',
 'Households and NPISHs Final consumption expenditure (current US$)',
 'Households and NPISHs Final consumption expenditure per capita (constant 2010 US$)',
 'Households and NPISHs Final consumption expenditure per capita growth (annual %)',
 'Households and NPISHs Final consumption expenditure, PPP (constant 2011 international $)',
 'Households and NPISHs Final consumption expenditure, PPP (current international $)',
 'ICT goods exports (% of total goods exports)',
 'ICT goods imports (% total goods imports)',
 'ICT service exports (% of service exports, BoP)',
 'ICT service exports (BoP, current US$)',
 'Immunization, DPT (% of children ages 12-23 months)',
 'Immunization, measles (% of children ages 12-23 months)',
 'Import unit value index (2000 = 100)',
 'Import value index (2000 = 100)',
 'Import volume index (2000 = 100)',
 'Imports of goods and services (% of GDP)',
 'Imports of goods and services (annual % growth)',
 'Imports of goods and services (BoP, current US$)',
 'Imports of goods and services (constant 2010 US$)',
 'Imports of goods and services (constant LCU)',
 'Imports of goods and services (current LCU)',
 'Imports of goods and services (current US$)',
 'Imports of goods, services and primary income (BoP, current US$)',
 'Incidence of tuberculosis (per 100,000 people)',
 'Income share held by fourth 20%',
 'Income share held by highest 10%',
 'Income share held by highest 20%',
 'Income share held by lowest 10%',
 'Income share held by lowest 20%',
 'Income share held by second 20%',
 'Income share held by third 20%',
 'Individuals using the Internet (% of population)',
 'Industrial design applications, nonresident, by count',
 'Industrial design applications, resident, by count',
 'Industry (including construction), value added (% of GDP)',
 'Industry (including construction), value added (annual % growth)',
 'Industry (including construction), value added (constant 2010 US$)',
 'Industry (including construction), value added (constant LCU)',
 'Industry (including construction), value added (current LCU)',
 'Industry (including construction), value added (current US$)',
 'Industry (including construction), value added per worker (constant 2010 US$)',
 'Inflation, consumer prices (annual %)',
 'Inflation, GDP deflator (annual %)',
 'Inflation, GDP deflator: linked series (annual %)',
 'Insurance and financial services (% of commercial service exports)',
 'Insurance and financial services (% of commercial service imports)',
 'Insurance and financial services (% of service exports, BoP)',
 'Insurance and financial services (% of service imports, BoP)',
 'Intentional homicides (per 100,000 people)',
 'Intentional homicides, female (per 100,000 female)',
 'Intentional homicides, male (per 100,000 male)',
 'Interest payments (% of expense)',
 'Interest payments (% of revenue)',
 'Interest payments (current LCU)',
 'Internally displaced persons, new displacement associated with disasters (number of cases)',
 'International migrant stock (% of population)',
 'International migrant stock, total',
 'International tourism, expenditures (% of total imports)',
 'International tourism, expenditures (current US$)',
 'International tourism, expenditures for passenger transport items (current US$)',
 'International tourism, expenditures for travel items (current US$)',
 'International tourism, number of arrivals',
 'International tourism, number of departures',
 'International tourism, receipts (% of total exports)',
 'International tourism, receipts (current US$)',
 'International tourism, receipts for passenger transport items (current US$)',
 'International tourism, receipts for travel items (current US$)',
 'Labor force participation rate for ages 15-24, female (%) (modeled ILO estimate)',
 'Labor force participation rate for ages 15-24, female (%) (national estimate)',
 'Labor force participation rate for ages 15-24, male (%) (modeled ILO estimate)',
 'Labor force participation rate for ages 15-24, male (%) (national estimate)',
 'Labor force participation rate for ages 15-24, total (%) (modeled ILO estimate)',
 'Labor force participation rate for ages 15-24, total (%) (national estimate)',
 'Labor force participation rate, female (% of female population ages 15+) (modeled ILO estimate)',
 'Labor force participation rate, female (% of female population ages 15+) (national estimate)',
 'Labor force participation rate, female (% of female population ages 15-64) (modeled ILO estimate)',
 'Labor force participation rate, male (% of male population ages 15+) (modeled ILO estimate)',
 'Labor force participation rate, male (% of male population ages 15+) (national estimate)',
 'Labor force participation rate, male (% of male population ages 15-64) (modeled ILO estimate)',
 'Labor force participation rate, total (% of total population ages 15+) (modeled ILO estimate)',
 'Labor force participation rate, total (% of total population ages 15+) (national estimate)',
 'Labor force participation rate, total (% of total population ages 15-64) (modeled ILO estimate)',
 'Labor force with advanced education (% of total working-age population with advanced education)',
 'Labor force with advanced education, female (% of female working-age population with advanced education)',
 'Labor force with advanced education, male (% of male working-age population with advanced education)',
 'Labor force with basic education (% of total working-age population with basic education)',
 'Labor force with basic education, female (% of female working-age population with basic education)',
 'Labor force with basic education, male (% of male working-age population with basic education)',
 'Labor force with intermediate education (% of total working-age population with intermediate education)',
 'Labor force with intermediate education, female (% of female working-age population with intermediate education)',
 'Labor force with intermediate education, male (% of male working-age population with intermediate education)',
 'Labor force, female (% of total labor force)',
 'Labor force, total',
 'Labor tax and contributions (% of commercial profits)',
 'Land area (sq. km)',
 'Land under cereal production (hectares)',
 'Law mandates equal remuneration for females and males for work of equal value (1=yes; 0=no)',
 'Law mandates nondiscrimination based on gender in hiring (1=yes; 0=no)',
 'Law mandates paid or unpaid maternity leave (1=yes; 0=no)',
 'Law prohibits or invalidates child or early marriage (1=yes; 0=no)',
 'Legislation exists on domestic violence (1=yes; 0=no)',
 'Life expectancy at birth, female (years)',
 'Life expectancy at birth, male (years)',
 'Life expectancy at birth, total (years)',
 'Lifetime risk of maternal death (%)',
 'Lifetime risk of maternal death (1 in: rate varies by country)',
 'Liner shipping connectivity index (maximum value in 2004 = 100)',
 'Livestock production index (2004-2006 = 100)',
 'Lower secondary completion rate, female (% of relevant age group)',
 'Lower secondary completion rate, male (% of relevant age group)',
 'Lower secondary completion rate, total (% of relevant age group)',
 'Lower secondary school starting age (years)',
 'Manufactures exports (% of merchandise exports)',
 'Manufactures imports (% of merchandise imports)',
 'Manufacturing, value added (% of GDP)',
 'Manufacturing, value added (annual % growth)',
 'Manufacturing, value added (constant 2010 US$)',
 'Manufacturing, value added (constant LCU)',
 'Manufacturing, value added (current LCU)',
 'Manufacturing, value added (current US$)',
 'Maternal mortality ratio (modeled estimate, per 100,000 live births)',
 'Medium and high-tech exports (% manufactured exports)',
 'Medium and high-tech Industry (including construction) (% manufacturing value added)',
 'Merchandise exports (current US$)',
 'Merchandise exports by the reporting economy (current US$)',
 'Merchandise exports by the reporting economy, residual (% of total merchandise exports)',
 'Merchandise exports to economies in the Arab World (% of total merchandise exports)',
 'Merchandise exports to high-income economies (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in East Asia & Pacific (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Europe & Central Asia (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Latin America & the Caribbean (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Middle East & North Africa (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in South Asia (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Sub-Saharan Africa (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies outside region (% of total merchandise exports)',
 'Merchandise imports (current US$)',
 'Merchandise imports by the reporting economy (current US$)',
 'Merchandise imports by the reporting economy, residual (% of total merchandise imports)',
 'Merchandise imports from economies in the Arab World (% of total merchandise imports)',
 'Merchandise imports from high-income economies (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in East Asia & Pacific (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Europe & Central Asia (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Latin America & the Caribbean (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Middle East & North Africa (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in South Asia (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Sub-Saharan Africa (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies outside region (% of total merchandise imports)',
 'Merchandise trade (% of GDP)',
 'Military expenditure (% of central government expenditure)',
 'Military expenditure (% of GDP)',
 'Military expenditure (current LCU)',
 'Military expenditure (current USD)',
 'Mineral rents (% of GDP)',
 'Mobile cellular subscriptions',
 'Mobile cellular subscriptions (per 100 people)',
 'Mortality caused by road traffic injury (per 100,000 people)',
 'Mortality from CVD, cancer, diabetes or CRD between exact ages 30 and 70 (%)',
 'Mortality rate attributed to unintentional poisoning  (per 100,000 population)',
 'Mortality rate attributed to unintentional poisoning, female (per 100,000 female population)',
 'Mortality rate attributed to unintentional poisoning, male (per 100,000 male population)',
 'Mortality rate, infant (per 1,000 live births)',
 'Mortality rate, infant, female (per 1,000 live births)',
 'Mortality rate, infant, male (per 1,000 live births)',
 'Mortality rate, neonatal (per 1,000 live births)',
 'Mortality rate, under-5 (per 1,000 live births)',
 'Mortality rate, under-5, female (per 1,000 live births)',
 'Mortality rate, under-5, male (per 1,000 live births)',
 'Mothers are guaranteed an equivalent position after maternity leave (1=yes; 0=no)',
 'Natural gas rents (% of GDP)',
 'Net acquisition of financial assets (% of GDP)',
 'Net acquisition of financial assets (current LCU)',
 'Net barter terms of trade index (2000 = 100)',
 'Net capital account (BoP, current US$)',
 'Net domestic credit (current LCU)',
 'Net errors and omissions (BoP, current US$)',
 'Net financial account (BoP, current US$)',
 'Net foreign assets (current LCU)',
 'Net incurrence of liabilities, total (% of GDP)',
 'Net incurrence of liabilities, total (current LCU)',
 'Net intake rate in grade 1 (% of official school-age population)',
 'Net intake rate in grade 1, female (% of official school-age population)',
 'Net intake rate in grade 1, male (% of official school-age population)',
 'Net investment in nonfinancial assets (% of GDP)',
 'Net investment in nonfinancial assets (current LCU)',
 'Net lending (+) / net borrowing (-) (% of GDP)',
 'Net lending (+) / net borrowing (-) (current LCU)',
 'Net ODA provided to the least developed countries (% of GNI)',
 'Net ODA provided, to the least developed countries (current US$)',
 'Net ODA provided, total (% of GNI)',
 'Net ODA provided, total (constant 2015 US$)',
 'Net ODA provided, total (current US$)',
 'Net primary income (BoP, current US$)',
 'Net primary income (Net income from abroad) (constant LCU)',
 'Net primary income (Net income from abroad) (current LCU)',
 'Net primary income (Net income from abroad) (current US$)',
 'Net secondary income (BoP, current US$)',
 'Net secondary income (Net current transfers from abroad) (current LCU)',
 'Net secondary income (Net current transfers from abroad) (current US$)',
 'Net trade in goods (BoP, current US$)',
 'Net trade in goods and services (BoP, current US$)',
 'New business density (new registrations per 1,000 people ages 15-64)',
 'New businesses registered (number)',
 'Nonpregnant and nonnursing women can do the same jobs as men (1=yes; 0=no)',
 'Number of deaths ages 5-14 years',
 'Number of infant deaths',
 'Number of maternal deaths',
 'Number of neonatal deaths',
 'Number of under-five deaths',
 'Nurses and midwives (per 1,000 people)',
 'Official exchange rate (LCU per US$, period average)',
 'Oil rents (% of GDP)',
 'Ores and metals exports (% of merchandise exports)',
 'Ores and metals imports (% of merchandise imports)',
 'Other expense (% of expense)',
 'Other expense (current LCU)',
 'Other taxes (% of revenue)',
 'Other taxes (current LCU)',
 'Other taxes payable by businesses (% of commercial profits)',
 'Out-of-pocket expenditure (% of current health expenditure)',
 'Out-of-pocket expenditure per capita (current US$)',
 'Out-of-pocket expenditure per capita, PPP (current international $)',
 'Over-age students, primary (% of enrollment)',
 'Over-age students, primary, female (% of female enrollment)',
 'Over-age students, primary, male (% of male enrollment)',
 'Part time employment, female (% of total female employment)',
 'Part time employment, male (% of total male employment)',
 'Part time employment, total (% of total employment)',
 'Patent applications, nonresidents',
 'Patent applications, residents',
 'People practicing open defecation (% of population)',
 'People practicing open defecation, rural (% of rural population)',
 'People practicing open defecation, urban (% of urban population)',
 'People using at least basic drinking water services (% of population)',
 'People using at least basic drinking water services, rural (% of rural population)',
 'People using at least basic drinking water services, urban (% of urban population)',
 'People using at least basic sanitation services (% of population)',
 'People using at least basic sanitation services, rural (% of rural population)',
 'People using at least basic sanitation services, urban  (% of urban population)',
 'People using safely managed drinking water services (% of population)',
 'People using safely managed sanitation services (% of population)',
 'People using safely managed sanitation services, rural (% of rural population)',
 'People using safely managed sanitation services, urban  (% of urban population)',
 'Permanent cropland (% of land area)',
 'Personal remittances, paid (current US$)',
 'Personal remittances, received (% of GDP)',
 'Personal remittances, received (current US$)',
 'Personal transfers, receipts (BoP, current US$)',
 'Physicians (per 1,000 people)',
 'PM2.5 air pollution, mean annual exposure (micrograms per cubic meter)',
 'PM2.5 air pollution, population exposed to levels exceeding WHO guideline value (% of total)',
 'PM2.5 pollution, population exposed to levels exceeding WHO Interim Target-1 value (% of total)',
 'PM2.5 pollution, population exposed to levels exceeding WHO Interim Target-2 value (% of total)',
 'PM2.5 pollution, population exposed to levels exceeding WHO Interim Target-3 value (% of total)',
 'Population ages 0-14 (% of total)',
 'Population ages 0-14, female',
 'Population ages 0-14, female (% of total)',
 'Population ages 0-14, male',
 'Population ages 0-14, male (% of total)',
 'Population ages 0-14, total',
 'Population ages 0-4, female (% of female population)',
 'Population ages 0-4, male (% of male population)',
 'Population ages 10-14, female (% of female population)',
 'Population ages 10-14, male (% of male population)',
 'Population ages 15-19, female (% of female population)',
 'Population ages 15-19, male (% of male population)',
 'Population ages 15-64 (% of total)',
 'Population ages 15-64, female',
 'Population ages 15-64, female (% of total)',
 'Population ages 15-64, male',
 'Population ages 15-64, male (% of total)',
 'Population ages 15-64, total',
 'Population ages 20-24, female (% of female population)',
 'Population ages 20-24, male (% of male population)',
 'Population ages 25-29, female (% of female population)',
 'Population ages 25-29, male (% of male population)',
 'Population ages 30-34, female (% of female population)',
 'Population ages 30-34, male (% of male population)',
 'Population ages 35-39, female (% of female population)',
 'Population ages 35-39, male (% of male population)',
 'Population ages 40-44, female (% of female population)',
 'Population ages 40-44, male (% of male population)',
 'Population ages 45-49, female (% of female population)',
 'Population ages 45-49, male (% of male population)',
 'Population ages 50-54, female (% of female population)',
 'Population ages 50-54, male (% of male population)',
 'Population ages 55-59, female (% of female population)',
 'Population ages 55-59, male (% of male population)',
 'Population ages 5-9, female (% of female population)',
 'Population ages 5-9, male (% of male population)',
 'Population ages 60-64, female (% of female population)',
 'Population ages 60-64, male (% of male population)',
 'Population ages 65 and above (% of total)',
 'Population ages 65 and above, female',
 'Population ages 65 and above, female (% of total)',
 'Population ages 65 and above, male',
 'Population ages 65 and above, male (% of total)',
 'Population ages 65 and above, total',
 'Population ages 65-69, female (% of female population)',
 'Population ages 65-69, male (% of male population)',
 'Population ages 70-74, female (% of female population)',
 'Population ages 70-74, male (% of male population)',
 'Population ages 75-79, female (% of female population)',
 'Population ages 75-79, male (% of male population)',
 'Population ages 80 and above, female (% of female population)',
 'Population ages 80 and above, male (% of male population)',
 'Population density (people per sq. km of land area)',
 'Population growth (annual %)',
 'Population in largest city',
 'Population in the largest city (% of urban population)',
 'Population in urban agglomerations of more than 1 million',
 'Population in urban agglomerations of more than 1 million (% of total population)',
 'Population, female',
 'Population, female (% of total)',
 'Population, male',
 'Population, male (% of total)',
 'Population, total',
 'Portfolio equity, net inflows (BoP, current US$)',
 'Portfolio investment, net (BoP, current US$)',
 'Poverty gap at $1.90 a day (2011 PPP) (%)',
 'Poverty gap at $3.20 a day (2011 PPP) (%)',
 'Poverty gap at $5.50 a day (2011 PPP) (%)',
 'Poverty headcount ratio at $1.90 a day (2011 PPP) (% of population)',
 'Poverty headcount ratio at $3.20 a day (2011 PPP) (% of population)',
 'Poverty headcount ratio at $5.50 a day (2011 PPP) (% of population)',
 'PPP conversion factor, GDP (LCU per international $)',
 'PPP conversion factor, private consumption (LCU per international $)',
 'Preprimary education, duration (years)',
 'Prevalence of anemia among children (% of children under 5)',
 'Prevalence of anemia among non-pregnant women (% of women ages 15-49)',
 'Prevalence of anemia among pregnant women (%)',
 'Prevalence of anemia among women of reproductive age (% of women ages 15-49)',
 'Prevalence of undernourishment (% of population)',
 'Price level ratio of PPP conversion factor (GDP) to market exchange rate',
 'Primary completion rate, female (% of relevant age group)',
 'Primary completion rate, male (% of relevant age group)',
 'Primary completion rate, total (% of relevant age group)',
 'Primary education, duration (years)',
 'Primary education, pupils',
 'Primary education, pupils (% female)',
 'Primary income payments (BoP, current US$)',
 'Primary income receipts (BoP, current US$)',
 'Primary school starting age (years)',
 'Private credit bureau coverage (% of adults)',
 'Probability of dying at age 5-14 years (per 1,000 children age 5)',
 'Procedures to build a warehouse (number)',
 'Procedures to register property (number)',
 'Profit tax (% of commercial profits)',
 'Proportion of seats held by women in national parliaments (%)',
 'Public credit registry coverage (% of adults)',
 'Pupil-teacher ratio, secondary',
 'Pupil-teacher ratio, tertiary',
 'Quality of port infrastructure, WEF (1=extremely underdeveloped to 7=well developed and efficient by international standards)',
 'Rail lines (total route-km)',
 'Ratio of female to male labor force participation rate (%) (modeled ILO estimate)',
 'Ratio of female to male labor force participation rate (%) (national estimate)',
 'Real effective exchange rate index (2010 = 100)',
 'Refugee population by country or territory of asylum',
 'Refugee population by country or territory of origin',
 'Renewable electricity output (% of total electricity output)',
 'Renewable energy consumption (% of total final energy consumption)',
 'Research and development expenditure (% of GDP)',
 'Researchers in R&D (per million people)',
 'Reserves and related items (BoP, current US$)',
 'Revenue, excluding grants (% of GDP)',
 'Revenue, excluding grants (current LCU)',
 'Risk of catastrophic expenditure for surgical care (% of people at risk)',
 'Risk of impoverishing expenditure for surgical care (% of people at risk)',
 'Rural population',
 'Rural population (% of total population)',
 'Rural population growth (annual %)',
 'S&P Global Equity Indices (annual % change)',
 'School enrollment, preprimary (% gross)',
 'School enrollment, preprimary, female (% gross)',
 'School enrollment, preprimary, male (% gross)',
 'School enrollment, primary (% gross)',
 'School enrollment, primary (% net)',
 'School enrollment, primary (gross), gender parity index (GPI)',
 'School enrollment, primary and secondary (gross), gender parity index (GPI)',
 'School enrollment, primary, female (% gross)',
 'School enrollment, primary, male (% gross)',
 'School enrollment, primary, private (% of total primary)',
 'School enrollment, secondary (% gross)',
 'School enrollment, secondary (% net)',
 'School enrollment, secondary (gross), gender parity index (GPI)',
 'School enrollment, secondary, female (% gross)',
 'School enrollment, secondary, female (% net)',
 'School enrollment, secondary, male (% gross)',
 'School enrollment, secondary, male (% net)',
 'School enrollment, secondary, private (% of total secondary)',
 'School enrollment, tertiary (% gross)',
 'School enrollment, tertiary (gross), gender parity index (GPI)',
 'School enrollment, tertiary, female (% gross)',
 'School enrollment, tertiary, male (% gross)',
 'Scientific and technical journal articles',
 'Secondary education, duration (years)',
 'Secondary education, general pupils',
 'Secondary education, general pupils (% female)',
 'Secondary education, pupils',
 'Secondary education, pupils (% female)',
 'Secondary education, teachers',
 'Secondary education, teachers (% female)',
 'Secondary education, teachers, female',
 'Secondary education, vocational pupils',
 'Secondary education, vocational pupils (% female)',
 'Secondary income receipts (BoP, current US$)',
 'Secondary income, other sectors, payments (BoP, current US$)',
 'Secure Internet servers',
 'Secure Internet servers (per 1 million people)',
 'Self-employed, female (% of female employment) (modeled ILO estimate)',
 'Self-employed, male (% of male employment) (modeled ILO estimate)',
 'Self-employed, total (% of total employment) (modeled ILO estimate)',
 'Service exports (BoP, current US$)',
 'Service imports (BoP, current US$)',
 'Services, value added (% of GDP)',
 'Services, value added (annual % growth)',
 'Services, value added (constant 2010 US$)',
 'Services, value added (constant LCU)',
 'Services, value added (current LCU)',
 'Services, value added (current US$)',
 'Services, value added per worker (constant 2010 US$)',
 'Sex ratio at birth (male births per female births)',
 'Share of tariff lines with international peaks, all products (%)',
 'Share of tariff lines with international peaks, manufactured products (%)',
 'Share of tariff lines with international peaks, primary products (%)',
 'Share of tariff lines with specific rates, all products (%)',
 'Share of tariff lines with specific rates, manufactured products (%)',
 'Share of tariff lines with specific rates, primary products (%)',
 'Share of youth not in education, employment or training, female (% of female youth population)',
 'Share of youth not in education, employment or training, male (% of male youth population)',
 'Share of youth not in education, employment or training, total (% of youth population)',
 'Smoking prevalence, females (% of adults)',
 'Smoking prevalence, males (% of adults)',
 'Smoking prevalence, total (ages 15+)',
 'Social contributions (% of revenue)',
 'Social contributions (current LCU)',
 'Specialist surgical workforce (per 100,000 population)',
 'Start-up procedures to register a business (number)',
 'Start-up procedures to register a business, female (number)',
 'Start-up procedures to register a business, male (number)',
 'Strength of legal rights index (0=weak to 12=strong)',
 'Subsidies and other transfers (% of expense)',
 'Subsidies and other transfers (current LCU)',
 'Suicide mortality rate (per 100,000 population)',
 'Surface area (sq. km)',
 'Survey mean consumption or income per capita, bottom 40% of population (2011 PPP $ per day)',
 'Survey mean consumption or income per capita, total population (2011 PPP $ per day)',
 'Survival to age 65, female (% of cohort)',
 'Survival to age 65, male (% of cohort)',
 'Tariff rate, applied, simple mean, all products (%)',
 'Tariff rate, applied, simple mean, manufactured products (%)',
 'Tariff rate, applied, simple mean, primary products (%)',
 'Tariff rate, applied, weighted mean, all products (%)',
 'Tariff rate, applied, weighted mean, manufactured products (%)',
 'Tariff rate, applied, weighted mean, primary products (%)',
 'Tariff rate, most favored nation, simple mean, all products (%)',
 'Tariff rate, most favored nation, simple mean, manufactured products (%)',
 'Tariff rate, most favored nation, simple mean, primary products (%)',
 'Tariff rate, most favored nation, weighted mean, all products (%)',
 'Tariff rate, most favored nation, weighted mean, manufactured products (%)',
 'Tariff rate, most favored nation, weighted mean, primary products (%)',
 'Tax payments (number)',
 'Tax revenue (% of GDP)',
 'Tax revenue (current LCU)',
 'Taxes less subsidies on products (constant LCU)',
 'Taxes less subsidies on products (current LCU)',
 'Taxes less subsidies on products (current US$)',
 'Taxes on goods and services (% of revenue)',
 'Taxes on goods and services (% value added of industry and services)',
 'Taxes on goods and services (current LCU)',
 'Taxes on income, profits and capital gains (% of revenue)',
 'Taxes on income, profits and capital gains (% of total taxes)',
 'Taxes on income, profits and capital gains (current LCU)',
 'Technicians in R&D (per million people)',
 'Terms of trade adjustment (constant LCU)',
 'Tertiary education, academic staff (% female)',
 'Time required to build a warehouse (days)',
 'Time required to enforce a contract (days)',
 'Time required to get electricity (days)',
 'Time required to register property (days)',
 'Time required to start a business (days)',
 'Time required to start a business, female (days)',
 'Time required to start a business, male (days)',
 'Time to export, border compliance (hours)',
 'Time to export, documentary compliance (hours)',
 'Time to import, border compliance (hours)',
 'Time to import, documentary compliance (hours)',
 'Time to prepare and pay taxes (hours)',
 'Time to resolve insolvency (years)',
 'Total fisheries production (metric tons)',
 'Total natural resources rents (% of GDP)',
 'Total reserves (includes gold, current US$)',
 'Total reserves in months of imports',
 'Total reserves minus gold (current US$)',
 'Total tax rate (% of commercial profits)',
 'Trade (% of GDP)',
 'Trade in services (% of GDP)',
 'Trademark applications, direct nonresident',
 'Trademark applications, direct resident',
 'Trademark applications, nonresident, by count',
 'Trademark applications, resident, by count',
 'Trademark applications, total',
 'Transport services (% of commercial service exports)',
 'Transport services (% of commercial service imports)',
 'Transport services (% of service exports, BoP)',
 'Transport services (% of service imports, BoP)',
 'Travel services (% of commercial service exports)',
 'Travel services (% of commercial service imports)',
 'Travel services (% of service exports, BoP)',
 'Travel services (% of service imports, BoP)',
 'Tuberculosis case detection rate (%, all forms)',
 'Tuberculosis treatment success rate (% of new cases)',
 'UHC service coverage index',
 'Unemployment with advanced education (% of total labor force with advanced education)',
 'Unemployment with advanced education, female (% of female labor force with advanced education)',
 'Unemployment with advanced education, male (% of male labor force with advanced education)',
 'Unemployment with basic education (% of total labor force with basic education)',
 'Unemployment with basic education, female (% of female labor force with basic education)',
 'Unemployment with basic education, male (% of male labor force with basic education)',
 'Unemployment with intermediate education (% of total labor force with intermediate education)',
 'Unemployment with intermediate education, female (% of female labor force with intermediate education)',
 'Unemployment with intermediate education, male (% of male labor force with intermediate education)',
 'Unemployment, female (% of female labor force) (modeled ILO estimate)',
 'Unemployment, female (% of female labor force) (national estimate)',
 'Unemployment, male (% of male labor force) (modeled ILO estimate)',
 'Unemployment, male (% of male labor force) (national estimate)',
 'Unemployment, total (% of total labor force) (modeled ILO estimate)',
 'Unemployment, total (% of total labor force) (national estimate)',
 'Unemployment, youth female (% of female labor force ages 15-24) (modeled ILO estimate)',
 'Unemployment, youth female (% of female labor force ages 15-24) (national estimate)',
 'Unemployment, youth male (% of male labor force ages 15-24) (modeled ILO estimate)',
 'Unemployment, youth male (% of male labor force ages 15-24) (national estimate)',
 'Unemployment, youth total (% of total labor force ages 15-24) (modeled ILO estimate)',
 'Unemployment, youth total (% of total labor force ages 15-24) (national estimate)',
 'Urban population',
 'Urban population (% of total)',
 'Urban population growth (annual %)',
 'Vulnerable employment, female (% of female employment) (modeled ILO estimate)',
 'Vulnerable employment, male (% of male employment) (modeled ILO estimate)',
 'Vulnerable employment, total (% of total employment) (modeled ILO estimate)',
 'Wage and salaried workers, female (% of female employment) (modeled ILO estimate)',
 'Wage and salaried workers, male (% of male employment) (modeled ILO estimate)',
 'Wage and salaried workers, total (% of total employment) (modeled ILO estimate)'])].iloc[:,15:60].T.reset_index()


# In[15]:


#rename the columns
dfi.columns = ['Year','Access to clean fuels and technologies for cooking  (% of population)',
 'Access to electricity (% of population)',
 'Access to electricity, rural (% of rural population)',
 'Access to electricity, urban (% of urban population)',
 'Adjusted net enrollment rate, primary (% of primary school age children)',
 'Adjusted net national income (annual % growth)',
 'Adjusted net national income (constant 2010 US$)',
 'Adjusted net national income (current US$)',
 'Adjusted net national income per capita (annual % growth)',
 'Adjusted net national income per capita (constant 2010 US$)',
 'Adjusted net national income per capita (current US$)',
 'Adjusted net savings, excluding particulate emission damage (% of GNI)',
 'Adjusted net savings, excluding particulate emission damage (current US$)',
 'Adjusted net savings, including particulate emission damage (% of GNI)',
 'Adjusted net savings, including particulate emission damage (current US$)',
 'Adjusted savings: carbon dioxide damage (% of GNI)',
 'Adjusted savings: carbon dioxide damage (current US$)',
 'Adjusted savings: consumption of fixed capital (% of GNI)',
 'Adjusted savings: consumption of fixed capital (current US$)',
 'Adjusted savings: education expenditure (% of GNI)',
 'Adjusted savings: education expenditure (current US$)',
 'Adjusted savings: energy depletion (% of GNI)',
 'Adjusted savings: energy depletion (current US$)',
 'Adjusted savings: gross savings (% of GNI)',
 'Adjusted savings: mineral depletion (% of GNI)',
 'Adjusted savings: mineral depletion (current US$)',
 'Adjusted savings: natural resources depletion (% of GNI)',
 'Adjusted savings: net forest depletion (% of GNI)',
 'Adjusted savings: net forest depletion (current US$)',
 'Adjusted savings: net national savings (% of GNI)',
 'Adjusted savings: net national savings (current US$)',
 'Adjusted savings: particulate emission damage (% of GNI)',
 'Adjusted savings: particulate emission damage (current US$)',
 'Adolescent fertility rate (births per 1,000 women ages 15-19)',
 'Adolescents out of school (% of lower secondary school age)',
 'Adolescents out of school, female (% of female lower secondary school age)',
 'Adolescents out of school, male (% of male lower secondary school age)',
 'Age dependency ratio (% of working-age population)',
 'Age dependency ratio, old (% of working-age population)',
 'Age dependency ratio, young (% of working-age population)',
 'Agricultural land (% of land area)',
 'Agricultural land (sq. km)',
 'Agricultural raw materials exports (% of merchandise exports)',
 'Agricultural raw materials imports (% of merchandise imports)',
 'Agriculture, forestry, and fishing, value added (% of GDP)',
 'Agriculture, forestry, and fishing, value added (annual % growth)',
 'Agriculture, forestry, and fishing, value added (constant 2010 US$)',
 'Agriculture, forestry, and fishing, value added (constant LCU)',
 'Agriculture, forestry, and fishing, value added (current LCU)',
 'Agriculture, forestry, and fishing, value added (current US$)',
 'Agriculture, forestry, and fishing, value added per worker (constant 2010 US$)',
 'Air transport, freight (million ton-km)',
 'Air transport, passengers carried',
 'Air transport, registered carrier departures worldwide',
 'All education staff compensation, primary (% of total expenditure in primary public institutions)',
 'All education staff compensation, secondary (% of total expenditure in secondary public institutions)',
 'All education staff compensation, total (% of total expenditure in public institutions)',
 'Alternative and nuclear energy (% of total energy use)',
 'Annualized average growth rate in per capita real survey mean consumption or income, bottom 40% of population (%)',
 'Annualized average growth rate in per capita real survey mean consumption or income, total population (%)',
 'Aquaculture production (metric tons)',
 'Arable land (% of land area)',
 'Arable land (hectares per person)',
 'Arable land (hectares)',
 'Armed forces personnel (% of total labor force)',
 'Armed forces personnel, total',
 'Arms exports (SIPRI trend indicator values)',
 'Arms imports (SIPRI trend indicator values)',
 'Automated teller machines (ATMs) (per 100,000 adults)',
 'Average transaction cost of sending remittances from a specific country (%)',
 'Bank capital to assets ratio (%)',
 'Bank nonperforming loans to total gross loans (%)',
 'Binding coverage, all products (%)',
 'Binding coverage, manufactured products (%)',
 'Binding coverage, primary products (%)',
 'Birth rate, crude (per 1,000 people)',
 'Bound rate, simple mean, all products (%)',
 'Bound rate, simple mean, manufactured products (%)',
 'Bound rate, simple mean, primary products (%)',
 'Broad money (% of GDP)',
 'Broad money (current LCU)',
 'Broad money growth (annual %)',
 'Broad money to total reserves ratio',
 'Burden of customs procedure, WEF (1=extremely inefficient to 7=extremely efficient)',
 'Business extent of disclosure index (0=less disclosure to 10=more disclosure)',
 'Capture fisheries production (metric tons)',
 'Cause of death, by communicable diseases and maternal, prenatal and nutrition conditions (% of total)',
 'Cause of death, by injury (% of total)',
 'Cause of death, by non-communicable diseases (% of total)',
 'Central government debt, total (% of GDP)',
 'Central government debt, total (current LCU)',
 'Cereal production (metric tons)',
 'Cereal yield (kg per hectare)',
 'Changes in inventories (current LCU)',
 'Changes in inventories (current US$)',
 'Charges for the use of intellectual property, payments (BoP, current US$)',
 'Charges for the use of intellectual property, receipts (BoP, current US$)',
 'Children out of school (% of primary school age)',
 'Children out of school, primary',
 'Claims on central government (annual growth as % of broad money)',
 'Claims on central government, etc. (% GDP)',
 'Claims on private sector (annual growth as % of broad money)',
 'Coal rents (% of GDP)',
 'Combustible renewables and waste (% of total energy)',
 'Commercial service exports (current US$)',
 'Commercial service imports (current US$)',
 'Communications, computer, etc. (% of service exports, BoP)',
 'Communications, computer, etc. (% of service imports, BoP)',
 'Compensation of employees (% of expense)',
 'Compensation of employees (current LCU)',
 'Compulsory education, duration (years)',
 'Computer, communications and other services (% of commercial service exports)',
 'Computer, communications and other services (% of commercial service imports)',
 'Consumer price index (2010 = 100)',
 'Container port traffic (TEU: 20 foot equivalent units)',
 'Contributing family workers, female (% of female employment) (modeled ILO estimate)',
 'Contributing family workers, male (% of male employment) (modeled ILO estimate)',
 'Contributing family workers, total (% of total employment) (modeled ILO estimate)',
 'Cost of business start-up procedures (% of GNI per capita)',
 'Cost of business start-up procedures, female (% of GNI per capita)',
 'Cost of business start-up procedures, male (% of GNI per capita)',
 'Cost to export, border compliance (US$)',
 'Cost to export, documentary compliance (US$)',
 'Cost to import, border compliance (US$)',
 'Cost to import, documentary compliance (US$)',
 'Crop production index (2004-2006 = 100)',
 'Current account balance (% of GDP)',
 'Current account balance (BoP, current US$)',
 'Current education expenditure, primary (% of total expenditure in primary public institutions)',
 'Current education expenditure, secondary (% of total expenditure in secondary public institutions)',
 'Current education expenditure, total (% of total expenditure in public institutions)',
 'Current health expenditure (% of GDP)',
 'Current health expenditure per capita (current US$)',
 'Current health expenditure per capita, PPP (current international $)',
 'Death rate, crude (per 1,000 people)',
 'DEC alternative conversion factor (LCU per US$)',
 'Depth of credit information index (0=low to 8=high)',
 'Discrepancy in expenditure estimate of GDP (constant LCU)',
 'Discrepancy in expenditure estimate of GDP (current LCU)',
 'Distance to frontier score (0=lowest performance to 100=frontier)',
 'Domestic credit provided by financial sector (% of GDP)',
 'Domestic credit to private sector (% of GDP)',
 'Domestic credit to private sector by banks (% of GDP)',
 'Domestic general government health expenditure (% of current health expenditure)',
 'Domestic general government health expenditure (% of GDP)',
 'Domestic general government health expenditure (% of general government expenditure)',
 'Domestic general government health expenditure per capita (current US$)',
 'Domestic general government health expenditure per capita, PPP (current international $)',
 'Domestic private health expenditure (% of current health expenditure)',
 'Domestic private health expenditure per capita (current US$)',
 'Domestic private health expenditure per capita, PPP  (current international $)',
 'Electricity production from coal sources (% of total)',
 'Electricity production from hydroelectric sources (% of total)',
 'Electricity production from natural gas sources (% of total)',
 'Electricity production from nuclear sources (% of total)',
 'Electricity production from oil sources (% of total)',
 'Electricity production from oil, gas and coal sources (% of total)',
 'Electricity production from renewable sources, excluding hydroelectric (% of total)',
 'Electricity production from renewable sources, excluding hydroelectric (kWh)',
 'Employers, female (% of female employment) (modeled ILO estimate)',
 'Employers, male (% of male employment) (modeled ILO estimate)',
 'Employers, total (% of total employment) (modeled ILO estimate)',
 'Employment in agriculture (% of total employment) (modeled ILO estimate)',
 'Employment in agriculture, female (% of female employment) (modeled ILO estimate)',
 'Employment in agriculture, male (% of male employment) (modeled ILO estimate)',
 'Employment in industry (% of total employment) (modeled ILO estimate)',
 'Employment in industry, female (% of female employment) (modeled ILO estimate)',
 'Employment in industry, male (% of male employment) (modeled ILO estimate)',
 'Employment in services (% of total employment) (modeled ILO estimate)',
 'Employment in services, female (% of female employment) (modeled ILO estimate)',
 'Employment in services, male (% of male employment) (modeled ILO estimate)',
 'Employment to population ratio, 15+, female (%) (modeled ILO estimate)',
 'Employment to population ratio, 15+, female (%) (national estimate)',
 'Employment to population ratio, 15+, male (%) (modeled ILO estimate)',
 'Employment to population ratio, 15+, male (%) (national estimate)',
 'Employment to population ratio, 15+, total (%) (modeled ILO estimate)',
 'Employment to population ratio, 15+, total (%) (national estimate)',
 'Employment to population ratio, ages 15-24, female (%) (modeled ILO estimate)',
 'Employment to population ratio, ages 15-24, female (%) (national estimate)',
 'Employment to population ratio, ages 15-24, male (%) (modeled ILO estimate)',
 'Employment to population ratio, ages 15-24, male (%) (national estimate)',
 'Employment to population ratio, ages 15-24, total (%) (modeled ILO estimate)',
 'Employment to population ratio, ages 15-24, total (%) (national estimate)',
 'Energy imports, net (% of energy use)',
 'Energy intensity level of primary energy (MJ/$2011 PPP GDP)',
 'Energy use (kg of oil equivalent per capita)',
 'Energy use (kg of oil equivalent) per $1,000 GDP (constant 2011 PPP)',
 'Expenditure on primary education (% of government expenditure on education)',
 'Expenditure on secondary education (% of government expenditure on education)',
 'Expenditure on tertiary education (% of government expenditure on education)',
 'Expense (% of GDP)',
 'Expense (current LCU)',
 'Export unit value index (2000 = 100)',
 'Export value index (2000 = 100)',
 'Export volume index (2000 = 100)',
 'Exports as a capacity to import (constant LCU)',
 'Exports of goods and services (% of GDP)',
 'Exports of goods and services (annual % growth)',
 'Exports of goods and services (BoP, current US$)',
 'Exports of goods and services (constant 2010 US$)',
 'Exports of goods and services (constant LCU)',
 'Exports of goods and services (current LCU)',
 'Exports of goods and services (current US$)',
 'Exports of goods, services and primary income (BoP, current US$)',
 'External balance on goods and services (% of GDP)',
 'External balance on goods and services (constant LCU)',
 'External balance on goods and services (current LCU)',
 'External balance on goods and services (current US$)',
 'External health expenditure (% of current health expenditure)',
 'External health expenditure per capita (current US$)',
 'External health expenditure per capita, PPP (current international $)',
 'Female share of employment in senior and middle management (%)',
 'Fertility rate, total (births per woman)',
 'Fertilizer consumption (kilograms per hectare of arable land)',
 'Final consumption expenditure (% of GDP)',
 'Final consumption expenditure (constant 2010 US$)',
 'Final consumption expenditure (constant LCU)',
 'Final consumption expenditure (current LCU)',
 'Final consumption expenditure (current US$)',
 'Fixed broadband subscriptions',
 'Fixed broadband subscriptions (per 100 people)',
 'Fixed telephone subscriptions',
 'Fixed telephone subscriptions (per 100 people)',
 'Food exports (% of merchandise exports)',
 'Food imports (% of merchandise imports)',
 'Food production index (2004-2006 = 100)',
 'Foreign direct investment, net (BoP, current US$)',
 'Foreign direct investment, net inflows (% of GDP)',
 'Foreign direct investment, net inflows (BoP, current US$)',
 'Foreign direct investment, net outflows (% of GDP)',
 'Foreign direct investment, net outflows (BoP, current US$)',
 'Forest area (% of land area)',
 'Forest area (sq. km)',
 'Forest rents (% of GDP)',
 'Fossil fuel energy consumption (% of total)',
 'Fuel exports (% of merchandise exports)',
 'Fuel imports (% of merchandise imports)',
 'GDP (constant 2010 US$)',
 'GDP (constant LCU)',
 'GDP (current LCU)',
 'GDP (current US$)',
 'GDP deflator (base year varies by country)',
 'GDP deflator: linked series (base year varies by country)',
 'GDP growth (annual %)',
 'GDP per capita (constant 2010 US$)',
 'GDP per capita (constant LCU)',
 'GDP per capita (current LCU)',
 'GDP per capita (current US$)',
 'GDP per capita growth (annual %)',
 'GDP per capita, PPP (constant 2011 international $)',
 'GDP per capita, PPP (current international $)',
 'GDP per person employed (constant 2011 PPP $)',
 'GDP per unit of energy use (constant 2011 PPP $ per kg of oil equivalent)',
 'GDP per unit of energy use (PPP $ per kg of oil equivalent)',
 'GDP, PPP (constant 2011 international $)',
 'GDP, PPP (current international $)',
 'GDP: linked series (current LCU)',
 'General government final consumption expenditure (% of GDP)',
 'General government final consumption expenditure (annual % growth)',
 'General government final consumption expenditure (constant 2010 US$)',
 'General government final consumption expenditure (constant LCU)',
 'General government final consumption expenditure (current LCU)',
 'General government final consumption expenditure (current US$)',
 'GINI index (World Bank estimate)',
 'GNI (constant 2010 US$)',
 'GNI (constant LCU)',
 'GNI (current LCU)',
 'GNI (current US$)',
 'GNI growth (annual %)',
 'GNI per capita (constant 2010 US$)',
 'GNI per capita (constant LCU)',
 'GNI per capita (current LCU)',
 'GNI per capita growth (annual %)',
 'GNI per capita, Atlas method (current US$)',
 'GNI per capita, PPP (constant 2011 international $)',
 'GNI per capita, PPP (current international $)',
 'GNI, Atlas method (current US$)',
 'GNI, PPP (constant 2011 international $)',
 'GNI, PPP (current international $)',
 'Goods and services expense (% of expense)',
 'Goods and services expense (current LCU)',
 'Goods exports (BoP, current US$)',
 'Goods imports (BoP, current US$)',
 'Government expenditure on education, total (% of GDP)',
 'Government expenditure on education, total (% of government expenditure)',
 'Government expenditure per student, primary (% of GDP per capita)',
 'Government expenditure per student, secondary (% of GDP per capita)',
 'Government expenditure per student, tertiary (% of GDP per capita)',
 'Grants and other revenue (% of revenue)',
 'Grants and other revenue (current LCU)',
 'Gross capital formation (% of GDP)',
 'Gross capital formation (annual % growth)',
 'Gross capital formation (constant 2010 US$)',
 'Gross capital formation (constant LCU)',
 'Gross capital formation (current LCU)',
 'Gross capital formation (current US$)',
 'Gross domestic income (constant LCU)',
 'Gross domestic savings (% of GDP)',
 'Gross domestic savings (current LCU)',
 'Gross domestic savings (current US$)',
 'Gross fixed capital formation (% of GDP)',
 'Gross fixed capital formation (annual % growth)',
 'Gross fixed capital formation (constant 2010 US$)',
 'Gross fixed capital formation (constant LCU)',
 'Gross fixed capital formation (current LCU)',
 'Gross fixed capital formation (current US$)',
 'Gross intake ratio in first grade of primary education, female (% of relevant age group)',
 'Gross intake ratio in first grade of primary education, male (% of relevant age group)',
 'Gross intake ratio in first grade of primary education, total (% of relevant age group)',
 'Gross national expenditure (% of GDP)',
 'Gross national expenditure (constant 2010 US$)',
 'Gross national expenditure (constant LCU)',
 'Gross national expenditure (current LCU)',
 'Gross national expenditure (current US$)',
 'Gross national expenditure deflator (base year varies by country)',
 'Gross savings (% of GDP)',
 'Gross savings (% of GNI)',
 'Gross savings (current LCU)',
 'Gross savings (current US$)',
 'Gross value added at basic prices (GVA) (constant 2010 US$)',
 'Gross value added at basic prices (GVA) (constant LCU)',
 'Gross value added at basic prices (GVA) (current LCU)',
 'Gross value added at basic prices (GVA) (current US$)',
 'High-technology exports (% of manufactured exports)',
 'High-technology exports (current US$)',
 'Households and NPISHs final consumption expenditure (% of GDP)',
 'Households and NPISHs Final consumption expenditure (annual % growth)',
 'Households and NPISHs Final consumption expenditure (constant 2010 US$)',
 'Households and NPISHs Final consumption expenditure (constant LCU)',
 'Households and NPISHs Final consumption expenditure (current LCU)',
 'Households and NPISHs Final consumption expenditure (current US$)',
 'Households and NPISHs Final consumption expenditure per capita (constant 2010 US$)',
 'Households and NPISHs Final consumption expenditure per capita growth (annual %)',
 'Households and NPISHs Final consumption expenditure, PPP (constant 2011 international $)',
 'Households and NPISHs Final consumption expenditure, PPP (current international $)',
 'ICT goods exports (% of total goods exports)',
 'ICT goods imports (% total goods imports)',
 'ICT service exports (% of service exports, BoP)',
 'ICT service exports (BoP, current US$)',
 'Immunization, DPT (% of children ages 12-23 months)',
 'Immunization, measles (% of children ages 12-23 months)',
 'Import unit value index (2000 = 100)',
 'Import value index (2000 = 100)',
 'Import volume index (2000 = 100)',
 'Imports of goods and services (% of GDP)',
 'Imports of goods and services (annual % growth)',
 'Imports of goods and services (BoP, current US$)',
 'Imports of goods and services (constant 2010 US$)',
 'Imports of goods and services (constant LCU)',
 'Imports of goods and services (current LCU)',
 'Imports of goods and services (current US$)',
 'Imports of goods, services and primary income (BoP, current US$)',
 'Incidence of tuberculosis (per 100,000 people)',
 'Income share held by fourth 20%',
 'Income share held by highest 10%',
 'Income share held by highest 20%',
 'Income share held by lowest 10%',
 'Income share held by lowest 20%',
 'Income share held by second 20%',
 'Income share held by third 20%',
 'Individuals using the Internet (% of population)',
 'Industrial design applications, nonresident, by count',
 'Industrial design applications, resident, by count',
 'Industry (including construction), value added (% of GDP)',
 'Industry (including construction), value added (annual % growth)',
 'Industry (including construction), value added (constant 2010 US$)',
 'Industry (including construction), value added (constant LCU)',
 'Industry (including construction), value added (current LCU)',
 'Industry (including construction), value added (current US$)',
 'Industry (including construction), value added per worker (constant 2010 US$)',
 'Inflation, consumer prices (annual %)',
 'Inflation, GDP deflator (annual %)',
 'Inflation, GDP deflator: linked series (annual %)',
 'Insurance and financial services (% of commercial service exports)',
 'Insurance and financial services (% of commercial service imports)',
 'Insurance and financial services (% of service exports, BoP)',
 'Insurance and financial services (% of service imports, BoP)',
 'Intentional homicides (per 100,000 people)',
 'Intentional homicides, female (per 100,000 female)',
 'Intentional homicides, male (per 100,000 male)',
 'Interest payments (% of expense)',
 'Interest payments (% of revenue)',
 'Interest payments (current LCU)',
 'Internally displaced persons, new displacement associated with disasters (number of cases)',
 'International migrant stock (% of population)',
 'International migrant stock, total',
 'International tourism, expenditures (% of total imports)',
 'International tourism, expenditures (current US$)',
 'International tourism, expenditures for passenger transport items (current US$)',
 'International tourism, expenditures for travel items (current US$)',
 'International tourism, number of arrivals',
 'International tourism, number of departures',
 'International tourism, receipts (% of total exports)',
 'International tourism, receipts (current US$)',
 'International tourism, receipts for passenger transport items (current US$)',
 'International tourism, receipts for travel items (current US$)',
 'Labor force participation rate for ages 15-24, female (%) (modeled ILO estimate)',
 'Labor force participation rate for ages 15-24, female (%) (national estimate)',
 'Labor force participation rate for ages 15-24, male (%) (modeled ILO estimate)',
 'Labor force participation rate for ages 15-24, male (%) (national estimate)',
 'Labor force participation rate for ages 15-24, total (%) (modeled ILO estimate)',
 'Labor force participation rate for ages 15-24, total (%) (national estimate)',
 'Labor force participation rate, female (% of female population ages 15+) (modeled ILO estimate)',
 'Labor force participation rate, female (% of female population ages 15+) (national estimate)',
 'Labor force participation rate, female (% of female population ages 15-64) (modeled ILO estimate)',
 'Labor force participation rate, male (% of male population ages 15+) (modeled ILO estimate)',
 'Labor force participation rate, male (% of male population ages 15+) (national estimate)',
 'Labor force participation rate, male (% of male population ages 15-64) (modeled ILO estimate)',
 'Labor force participation rate, total (% of total population ages 15+) (modeled ILO estimate)',
 'Labor force participation rate, total (% of total population ages 15+) (national estimate)',
 'Labor force participation rate, total (% of total population ages 15-64) (modeled ILO estimate)',
 'Labor force with advanced education (% of total working-age population with advanced education)',
 'Labor force with advanced education, female (% of female working-age population with advanced education)',
 'Labor force with advanced education, male (% of male working-age population with advanced education)',
 'Labor force with basic education (% of total working-age population with basic education)',
 'Labor force with basic education, female (% of female working-age population with basic education)',
 'Labor force with basic education, male (% of male working-age population with basic education)',
 'Labor force with intermediate education (% of total working-age population with intermediate education)',
 'Labor force with intermediate education, female (% of female working-age population with intermediate education)',
 'Labor force with intermediate education, male (% of male working-age population with intermediate education)',
 'Labor force, female (% of total labor force)',
 'Labor force, total',
 'Labor tax and contributions (% of commercial profits)',
 'Land area (sq. km)',
 'Land under cereal production (hectares)',
 'Law mandates equal remuneration for females and males for work of equal value (1=yes; 0=no)',
 'Law mandates nondiscrimination based on gender in hiring (1=yes; 0=no)',
 'Law mandates paid or unpaid maternity leave (1=yes; 0=no)',
 'Law prohibits or invalidates child or early marriage (1=yes; 0=no)',
 'Legislation exists on domestic violence (1=yes; 0=no)',
 'Life expectancy at birth, female (years)',
 'Life expectancy at birth, male (years)',
 'Life expectancy at birth, total (years)',
 'Lifetime risk of maternal death (%)',
 'Lifetime risk of maternal death (1 in: rate varies by country)',
 'Liner shipping connectivity index (maximum value in 2004 = 100)',
 'Livestock production index (2004-2006 = 100)',
 'Lower secondary completion rate, female (% of relevant age group)',
 'Lower secondary completion rate, male (% of relevant age group)',
 'Lower secondary completion rate, total (% of relevant age group)',
 'Lower secondary school starting age (years)',
 'Manufactures exports (% of merchandise exports)',
 'Manufactures imports (% of merchandise imports)',
 'Manufacturing, value added (% of GDP)',
 'Manufacturing, value added (annual % growth)',
 'Manufacturing, value added (constant 2010 US$)',
 'Manufacturing, value added (constant LCU)',
 'Manufacturing, value added (current LCU)',
 'Manufacturing, value added (current US$)',
 'Maternal mortality ratio (modeled estimate, per 100,000 live births)',
 'Medium and high-tech exports (% manufactured exports)',
 'Medium and high-tech Industry (including construction) (% manufacturing value added)',
 'Merchandise exports (current US$)',
 'Merchandise exports by the reporting economy (current US$)',
 'Merchandise exports by the reporting economy, residual (% of total merchandise exports)',
 'Merchandise exports to economies in the Arab World (% of total merchandise exports)',
 'Merchandise exports to high-income economies (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in East Asia & Pacific (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Europe & Central Asia (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Latin America & the Caribbean (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Middle East & North Africa (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in South Asia (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies in Sub-Saharan Africa (% of total merchandise exports)',
 'Merchandise exports to low- and middle-income economies outside region (% of total merchandise exports)',
 'Merchandise imports (current US$)',
 'Merchandise imports by the reporting economy (current US$)',
 'Merchandise imports by the reporting economy, residual (% of total merchandise imports)',
 'Merchandise imports from economies in the Arab World (% of total merchandise imports)',
 'Merchandise imports from high-income economies (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in East Asia & Pacific (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Europe & Central Asia (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Latin America & the Caribbean (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Middle East & North Africa (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in South Asia (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies in Sub-Saharan Africa (% of total merchandise imports)',
 'Merchandise imports from low- and middle-income economies outside region (% of total merchandise imports)',
 'Merchandise trade (% of GDP)',
 'Military expenditure (% of central government expenditure)',
 'Military expenditure (% of GDP)',
 'Military expenditure (current LCU)',
 'Military expenditure (current USD)',
 'Mineral rents (% of GDP)',
 'Mobile cellular subscriptions',
 'Mobile cellular subscriptions (per 100 people)',
 'Mortality caused by road traffic injury (per 100,000 people)',
 'Mortality from CVD, cancer, diabetes or CRD between exact ages 30 and 70 (%)',
 'Mortality rate attributed to unintentional poisoning  (per 100,000 population)',
 'Mortality rate attributed to unintentional poisoning, female (per 100,000 female population)',
 'Mortality rate attributed to unintentional poisoning, male (per 100,000 male population)',
 'Mortality rate, infant (per 1,000 live births)',
 'Mortality rate, infant, female (per 1,000 live births)',
 'Mortality rate, infant, male (per 1,000 live births)',
 'Mortality rate, neonatal (per 1,000 live births)',
 'Mortality rate, under-5 (per 1,000 live births)',
 'Mortality rate, under-5, female (per 1,000 live births)',
 'Mortality rate, under-5, male (per 1,000 live births)',
 'Mothers are guaranteed an equivalent position after maternity leave (1=yes; 0=no)',
 'Natural gas rents (% of GDP)',
 'Net acquisition of financial assets (% of GDP)',
 'Net acquisition of financial assets (current LCU)',
 'Net barter terms of trade index (2000 = 100)',
 'Net capital account (BoP, current US$)',
 'Net domestic credit (current LCU)',
 'Net errors and omissions (BoP, current US$)',
 'Net financial account (BoP, current US$)',
 'Net foreign assets (current LCU)',
 'Net incurrence of liabilities, total (% of GDP)',
 'Net incurrence of liabilities, total (current LCU)',
 'Net intake rate in grade 1 (% of official school-age population)',
 'Net intake rate in grade 1, female (% of official school-age population)',
 'Net intake rate in grade 1, male (% of official school-age population)',
 'Net investment in nonfinancial assets (% of GDP)',
 'Net investment in nonfinancial assets (current LCU)',
 'Net lending (+) / net borrowing (-) (% of GDP)',
 'Net lending (+) / net borrowing (-) (current LCU)',
 'Net ODA provided to the least developed countries (% of GNI)',
 'Net ODA provided, to the least developed countries (current US$)',
 'Net ODA provided, total (% of GNI)',
 'Net ODA provided, total (constant 2015 US$)',
 'Net ODA provided, total (current US$)',
 'Net primary income (BoP, current US$)',
 'Net primary income (Net income from abroad) (constant LCU)',
 'Net primary income (Net income from abroad) (current LCU)',
 'Net primary income (Net income from abroad) (current US$)',
 'Net secondary income (BoP, current US$)',
 'Net secondary income (Net current transfers from abroad) (current LCU)',
 'Net secondary income (Net current transfers from abroad) (current US$)',
 'Net trade in goods (BoP, current US$)',
 'Net trade in goods and services (BoP, current US$)',
 'New business density (new registrations per 1,000 people ages 15-64)',
 'New businesses registered (number)',
 'Nonpregnant and nonnursing women can do the same jobs as men (1=yes; 0=no)',
 'Number of deaths ages 5-14 years',
 'Number of infant deaths',
 'Number of maternal deaths',
 'Number of neonatal deaths',
 'Number of under-five deaths',
 'Nurses and midwives (per 1,000 people)',
 'Official exchange rate (LCU per US$, period average)',
 'Oil rents (% of GDP)',
 'Ores and metals exports (% of merchandise exports)',
 'Ores and metals imports (% of merchandise imports)',
 'Other expense (% of expense)',
 'Other expense (current LCU)',
 'Other taxes (% of revenue)',
 'Other taxes (current LCU)',
 'Other taxes payable by businesses (% of commercial profits)',
 'Out-of-pocket expenditure (% of current health expenditure)',
 'Out-of-pocket expenditure per capita (current US$)',
 'Out-of-pocket expenditure per capita, PPP (current international $)',
 'Over-age students, primary (% of enrollment)',
 'Over-age students, primary, female (% of female enrollment)',
 'Over-age students, primary, male (% of male enrollment)',
 'Part time employment, female (% of total female employment)',
 'Part time employment, male (% of total male employment)',
 'Part time employment, total (% of total employment)',
 'Patent applications, nonresidents',
 'Patent applications, residents',
 'People practicing open defecation (% of population)',
 'People practicing open defecation, rural (% of rural population)',
 'People practicing open defecation, urban (% of urban population)',
 'People using at least basic drinking water services (% of population)',
 'People using at least basic drinking water services, rural (% of rural population)',
 'People using at least basic drinking water services, urban (% of urban population)',
 'People using at least basic sanitation services (% of population)',
 'People using at least basic sanitation services, rural (% of rural population)',
 'People using at least basic sanitation services, urban  (% of urban population)',
 'People using safely managed drinking water services (% of population)',
 'People using safely managed sanitation services (% of population)',
 'People using safely managed sanitation services, rural (% of rural population)',
 'People using safely managed sanitation services, urban  (% of urban population)',
 'Permanent cropland (% of land area)',
 'Personal remittances, paid (current US$)',
 'Personal remittances, received (% of GDP)',
 'Personal remittances, received (current US$)',
 'Personal transfers, receipts (BoP, current US$)',
 'Physicians (per 1,000 people)',
 'PM2.5 air pollution, mean annual exposure (micrograms per cubic meter)',
 'PM2.5 air pollution, population exposed to levels exceeding WHO guideline value (% of total)',
 'PM2.5 pollution, population exposed to levels exceeding WHO Interim Target-1 value (% of total)',
 'PM2.5 pollution, population exposed to levels exceeding WHO Interim Target-2 value (% of total)',
 'PM2.5 pollution, population exposed to levels exceeding WHO Interim Target-3 value (% of total)',
 'Population ages 0-14 (% of total)',
 'Population ages 0-14, female',
 'Population ages 0-14, female (% of total)',
 'Population ages 0-14, male',
 'Population ages 0-14, male (% of total)',
 'Population ages 0-14, total',
 'Population ages 0-4, female (% of female population)',
 'Population ages 0-4, male (% of male population)',
 'Population ages 10-14, female (% of female population)',
 'Population ages 10-14, male (% of male population)',
 'Population ages 15-19, female (% of female population)',
 'Population ages 15-19, male (% of male population)',
 'Population ages 15-64 (% of total)',
 'Population ages 15-64, female',
 'Population ages 15-64, female (% of total)',
 'Population ages 15-64, male',
 'Population ages 15-64, male (% of total)',
 'Population ages 15-64, total',
 'Population ages 20-24, female (% of female population)',
 'Population ages 20-24, male (% of male population)',
 'Population ages 25-29, female (% of female population)',
 'Population ages 25-29, male (% of male population)',
 'Population ages 30-34, female (% of female population)',
 'Population ages 30-34, male (% of male population)',
 'Population ages 35-39, female (% of female population)',
 'Population ages 35-39, male (% of male population)',
 'Population ages 40-44, female (% of female population)',
 'Population ages 40-44, male (% of male population)',
 'Population ages 45-49, female (% of female population)',
 'Population ages 45-49, male (% of male population)',
 'Population ages 50-54, female (% of female population)',
 'Population ages 50-54, male (% of male population)',
 'Population ages 55-59, female (% of female population)',
 'Population ages 55-59, male (% of male population)',
 'Population ages 5-9, female (% of female population)',
 'Population ages 5-9, male (% of male population)',
 'Population ages 60-64, female (% of female population)',
 'Population ages 60-64, male (% of male population)',
 'Population ages 65 and above (% of total)',
 'Population ages 65 and above, female',
 'Population ages 65 and above, female (% of total)',
 'Population ages 65 and above, male',
 'Population ages 65 and above, male (% of total)',
 'Population ages 65 and above, total',
 'Population ages 65-69, female (% of female population)',
 'Population ages 65-69, male (% of male population)',
 'Population ages 70-74, female (% of female population)',
 'Population ages 70-74, male (% of male population)',
 'Population ages 75-79, female (% of female population)',
 'Population ages 75-79, male (% of male population)',
 'Population ages 80 and above, female (% of female population)',
 'Population ages 80 and above, male (% of male population)',
 'Population density (people per sq. km of land area)',
 'Population growth (annual %)',
 'Population in largest city',
 'Population in the largest city (% of urban population)',
 'Population in urban agglomerations of more than 1 million',
 'Population in urban agglomerations of more than 1 million (% of total population)',
 'Population, female',
 'Population, female (% of total)',
 'Population, male',
 'Population, male (% of total)',
 'Population, total',
 'Portfolio equity, net inflows (BoP, current US$)',
 'Portfolio investment, net (BoP, current US$)',
 'Poverty gap at $1.90 a day (2011 PPP) (%)',
 'Poverty gap at $3.20 a day (2011 PPP) (%)',
 'Poverty gap at $5.50 a day (2011 PPP) (%)',
 'Poverty headcount ratio at $1.90 a day (2011 PPP) (% of population)',
 'Poverty headcount ratio at $3.20 a day (2011 PPP) (% of population)',
 'Poverty headcount ratio at $5.50 a day (2011 PPP) (% of population)',
 'PPP conversion factor, GDP (LCU per international $)',
 'PPP conversion factor, private consumption (LCU per international $)',
 'Preprimary education, duration (years)',
 'Prevalence of anemia among children (% of children under 5)',
 'Prevalence of anemia among non-pregnant women (% of women ages 15-49)',
 'Prevalence of anemia among pregnant women (%)',
 'Prevalence of anemia among women of reproductive age (% of women ages 15-49)',
 'Prevalence of undernourishment (% of population)',
 'Price level ratio of PPP conversion factor (GDP) to market exchange rate',
 'Primary completion rate, female (% of relevant age group)',
 'Primary completion rate, male (% of relevant age group)',
 'Primary completion rate, total (% of relevant age group)',
 'Primary education, duration (years)',
 'Primary education, pupils',
 'Primary education, pupils (% female)',
 'Primary income payments (BoP, current US$)',
 'Primary income receipts (BoP, current US$)',
 'Primary school starting age (years)',
 'Private credit bureau coverage (% of adults)',
 'Probability of dying at age 5-14 years (per 1,000 children age 5)',
 'Procedures to build a warehouse (number)',
 'Procedures to register property (number)',
 'Profit tax (% of commercial profits)',
 'Proportion of seats held by women in national parliaments (%)',
 'Public credit registry coverage (% of adults)',
 'Pupil-teacher ratio, secondary',
 'Pupil-teacher ratio, tertiary',
 'Quality of port infrastructure, WEF (1=extremely underdeveloped to 7=well developed and efficient by international standards)',
 'Rail lines (total route-km)',
 'Ratio of female to male labor force participation rate (%) (modeled ILO estimate)',
 'Ratio of female to male labor force participation rate (%) (national estimate)',
 'Real effective exchange rate index (2010 = 100)',
 'Refugee population by country or territory of asylum',
 'Refugee population by country or territory of origin',
 'Renewable electricity output (% of total electricity output)',
 'Renewable energy consumption (% of total final energy consumption)',
 'Research and development expenditure (% of GDP)',
 'Researchers in R&D (per million people)',
 'Reserves and related items (BoP, current US$)',
 'Revenue, excluding grants (% of GDP)',
 'Revenue, excluding grants (current LCU)',
 'Risk of catastrophic expenditure for surgical care (% of people at risk)',
 'Risk of impoverishing expenditure for surgical care (% of people at risk)',
 'Rural population',
 'Rural population (% of total population)',
 'Rural population growth (annual %)',
 'S&P Global Equity Indices (annual % change)',
 'School enrollment, preprimary (% gross)',
 'School enrollment, preprimary, female (% gross)',
 'School enrollment, preprimary, male (% gross)',
 'School enrollment, primary (% gross)',
 'School enrollment, primary (% net)',
 'School enrollment, primary (gross), gender parity index (GPI)',
 'School enrollment, primary and secondary (gross), gender parity index (GPI)',
 'School enrollment, primary, female (% gross)',
 'School enrollment, primary, male (% gross)',
 'School enrollment, primary, private (% of total primary)',
 'School enrollment, secondary (% gross)',
 'School enrollment, secondary (% net)',
 'School enrollment, secondary (gross), gender parity index (GPI)',
 'School enrollment, secondary, female (% gross)',
 'School enrollment, secondary, female (% net)',
 'School enrollment, secondary, male (% gross)',
 'School enrollment, secondary, male (% net)',
 'School enrollment, secondary, private (% of total secondary)',
 'School enrollment, tertiary (% gross)',
 'School enrollment, tertiary (gross), gender parity index (GPI)',
 'School enrollment, tertiary, female (% gross)',
 'School enrollment, tertiary, male (% gross)',
 'Scientific and technical journal articles',
 'Secondary education, duration (years)',
 'Secondary education, general pupils',
 'Secondary education, general pupils (% female)',
 'Secondary education, pupils',
 'Secondary education, pupils (% female)',
 'Secondary education, teachers',
 'Secondary education, teachers (% female)',
 'Secondary education, teachers, female',
 'Secondary education, vocational pupils',
 'Secondary education, vocational pupils (% female)',
 'Secondary income receipts (BoP, current US$)',
 'Secondary income, other sectors, payments (BoP, current US$)',
 'Secure Internet servers',
 'Secure Internet servers (per 1 million people)',
 'Self-employed, female (% of female employment) (modeled ILO estimate)',
 'Self-employed, male (% of male employment) (modeled ILO estimate)',
 'Self-employed, total (% of total employment) (modeled ILO estimate)',
 'Service exports (BoP, current US$)',
 'Service imports (BoP, current US$)',
 'Services, value added (% of GDP)',
 'Services, value added (annual % growth)',
 'Services, value added (constant 2010 US$)',
 'Services, value added (constant LCU)',
 'Services, value added (current LCU)',
 'Services, value added (current US$)',
 'Services, value added per worker (constant 2010 US$)',
 'Sex ratio at birth (male births per female births)',
 'Share of tariff lines with international peaks, all products (%)',
 'Share of tariff lines with international peaks, manufactured products (%)',
 'Share of tariff lines with international peaks, primary products (%)',
 'Share of tariff lines with specific rates, all products (%)',
 'Share of tariff lines with specific rates, manufactured products (%)',
 'Share of tariff lines with specific rates, primary products (%)',
 'Share of youth not in education, employment or training, female (% of female youth population)',
 'Share of youth not in education, employment or training, male (% of male youth population)',
 'Share of youth not in education, employment or training, total (% of youth population)',
 'Smoking prevalence, females (% of adults)',
 'Smoking prevalence, males (% of adults)',
 'Smoking prevalence, total (ages 15+)',
 'Social contributions (% of revenue)',
 'Social contributions (current LCU)',
 'Specialist surgical workforce (per 100,000 population)',
 'Start-up procedures to register a business (number)',
 'Start-up procedures to register a business, female (number)',
 'Start-up procedures to register a business, male (number)',
 'Strength of legal rights index (0=weak to 12=strong)',
 'Subsidies and other transfers (% of expense)',
 'Subsidies and other transfers (current LCU)',
 'Suicide mortality rate (per 100,000 population)',
 'Surface area (sq. km)',
 'Survey mean consumption or income per capita, bottom 40% of population (2011 PPP $ per day)',
 'Survey mean consumption or income per capita, total population (2011 PPP $ per day)',
 'Survival to age 65, female (% of cohort)',
 'Survival to age 65, male (% of cohort)',
 'Tariff rate, applied, simple mean, all products (%)',
 'Tariff rate, applied, simple mean, manufactured products (%)',
 'Tariff rate, applied, simple mean, primary products (%)',
 'Tariff rate, applied, weighted mean, all products (%)',
 'Tariff rate, applied, weighted mean, manufactured products (%)',
 'Tariff rate, applied, weighted mean, primary products (%)',
 'Tariff rate, most favored nation, simple mean, all products (%)',
 'Tariff rate, most favored nation, simple mean, manufactured products (%)',
 'Tariff rate, most favored nation, simple mean, primary products (%)',
 'Tariff rate, most favored nation, weighted mean, all products (%)',
 'Tariff rate, most favored nation, weighted mean, manufactured products (%)',
 'Tariff rate, most favored nation, weighted mean, primary products (%)',
 'Tax payments (number)',
 'Tax revenue (% of GDP)',
 'Tax revenue (current LCU)',
 'Taxes less subsidies on products (constant LCU)',
 'Taxes less subsidies on products (current LCU)',
 'Taxes less subsidies on products (current US$)',
 'Taxes on goods and services (% of revenue)',
 'Taxes on goods and services (% value added of industry and services)',
 'Taxes on goods and services (current LCU)',
 'Taxes on income, profits and capital gains (% of revenue)',
 'Taxes on income, profits and capital gains (% of total taxes)',
 'Taxes on income, profits and capital gains (current LCU)',
 'Technicians in R&D (per million people)',
 'Terms of trade adjustment (constant LCU)',
 'Tertiary education, academic staff (% female)',
 'Time required to build a warehouse (days)',
 'Time required to enforce a contract (days)',
 'Time required to get electricity (days)',
 'Time required to register property (days)',
 'Time required to start a business (days)',
 'Time required to start a business, female (days)',
 'Time required to start a business, male (days)',
 'Time to export, border compliance (hours)',
 'Time to export, documentary compliance (hours)',
 'Time to import, border compliance (hours)',
 'Time to import, documentary compliance (hours)',
 'Time to prepare and pay taxes (hours)',
 'Time to resolve insolvency (years)',
 'Total fisheries production (metric tons)',
 'Total natural resources rents (% of GDP)',
 'Total reserves (includes gold, current US$)',
 'Total reserves in months of imports',
 'Total reserves minus gold (current US$)',
 'Total tax rate (% of commercial profits)',
 'Trade (% of GDP)',
 'Trade in services (% of GDP)',
 'Trademark applications, direct nonresident',
 'Trademark applications, direct resident',
 'Trademark applications, nonresident, by count',
 'Trademark applications, resident, by count',
 'Trademark applications, total',
 'Transport services (% of commercial service exports)',
 'Transport services (% of commercial service imports)',
 'Transport services (% of service exports, BoP)',
 'Transport services (% of service imports, BoP)',
 'Travel services (% of commercial service exports)',
 'Travel services (% of commercial service imports)',
 'Travel services (% of service exports, BoP)',
 'Travel services (% of service imports, BoP)',
 'Tuberculosis case detection rate (%, all forms)',
 'Tuberculosis treatment success rate (% of new cases)',
 'UHC service coverage index',
 'Unemployment with advanced education (% of total labor force with advanced education)',
 'Unemployment with advanced education, female (% of female labor force with advanced education)',
 'Unemployment with advanced education, male (% of male labor force with advanced education)',
 'Unemployment with basic education (% of total labor force with basic education)',
 'Unemployment with basic education, female (% of female labor force with basic education)',
 'Unemployment with basic education, male (% of male labor force with basic education)',
 'Unemployment with intermediate education (% of total labor force with intermediate education)',
 'Unemployment with intermediate education, female (% of female labor force with intermediate education)',
 'Unemployment with intermediate education, male (% of male labor force with intermediate education)',
 'Unemployment, female (% of female labor force) (modeled ILO estimate)',
 'Unemployment, female (% of female labor force) (national estimate)',
 'Unemployment, male (% of male labor force) (modeled ILO estimate)',
 'Unemployment, male (% of male labor force) (national estimate)',
 'Unemployment, total (% of total labor force) (modeled ILO estimate)',
 'Unemployment, total (% of total labor force) (national estimate)',
 'Unemployment, youth female (% of female labor force ages 15-24) (modeled ILO estimate)',
 'Unemployment, youth female (% of female labor force ages 15-24) (national estimate)',
 'Unemployment, youth male (% of male labor force ages 15-24) (modeled ILO estimate)',
 'Unemployment, youth male (% of male labor force ages 15-24) (national estimate)',
 'Unemployment, youth total (% of total labor force ages 15-24) (modeled ILO estimate)',
 'Unemployment, youth total (% of total labor force ages 15-24) (national estimate)',
 'Urban population',
 'Urban population (% of total)',
 'Urban population growth (annual %)',
 'Vulnerable employment, female (% of female employment) (modeled ILO estimate)',
 'Vulnerable employment, male (% of male employment) (modeled ILO estimate)',
 'Vulnerable employment, total (% of total employment) (modeled ILO estimate)',
 'Wage and salaried workers, female (% of female employment) (modeled ILO estimate)',
 'Wage and salaried workers, male (% of male employment) (modeled ILO estimate)',
 'Wage and salaried workers, total (% of total employment) (modeled ILO estimate)']
dfi.set_index('Year', inplace=True)
dfi.head()


# In[16]:


dfi.to_csv("uk_data.csv")

