Raw material and raw data I.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Python code and workflow for data import, merging and cleaning"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1) Import packages and files  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from pandas import Series, DataFrame\n",
    "%matplotlib inline\n",
    "pd.set_option('display.max_rows', 500)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_80 = pd.read_csv('Cu_Mined_1970_80_edit.csv')\n",
    "cu_mined_81_91 = pd.read_csv('Cu_Mined_1981_91_edit.csv')\n",
    "cu_mined_92_02 = pd.read_csv('Cu_Mined_1992_2002_edit.csv')\n",
    "cu_mined_03_13 = pd.read_csv('Cu_Mined_2003_2013_edit.csv')\n",
    "cu_mined_14_18 = pd.read_csv('Cu_Mined_2014_2018_edit.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>yr1979</th>\n",
       "      <th>yr1980</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Albania</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>6500.0</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>11500.0</td>\n",
       "      <td>9700.0</td>\n",
       "      <td>11500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>574.0</td>\n",
       "      <td>514.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>353.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>461.0</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1125.0</td>\n",
       "      <td>284.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>380.0</td>\n",
       "      <td>265.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>182.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Australia</td>\n",
       "      <td>157790.0</td>\n",
       "      <td>177261.0</td>\n",
       "      <td>185843.0</td>\n",
       "      <td>220335.0</td>\n",
       "      <td>251340.0</td>\n",
       "      <td>218961.0</td>\n",
       "      <td>218480.0</td>\n",
       "      <td>221579.0</td>\n",
       "      <td>222111.0</td>\n",
       "      <td>237614.0</td>\n",
       "      <td>243541.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Austria</td>\n",
       "      <td>2262.0</td>\n",
       "      <td>2575.0</td>\n",
       "      <td>2231.0</td>\n",
       "      <td>2713.0</td>\n",
       "      <td>2612.0</td>\n",
       "      <td>1923.0</td>\n",
       "      <td>1138.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Country    yr1970    yr1971    yr1972    yr1973    yr1974    yr1975  \\\n",
       "0    Albania    6000.0    6500.0    6700.0    7000.0    7000.0    9000.0   \n",
       "1    Algeria     574.0     514.0     428.0     353.0     350.0     378.0   \n",
       "2  Argentina     461.0     497.0    1125.0     284.0     315.0     380.0   \n",
       "3  Australia  157790.0  177261.0  185843.0  220335.0  251340.0  218961.0   \n",
       "4    Austria    2262.0    2575.0    2231.0    2713.0    2612.0    1923.0   \n",
       "\n",
       "     yr1976    yr1977    yr1978    yr1979    yr1980  \n",
       "0   10000.0   10000.0   11500.0    9700.0   11500.0  \n",
       "1     400.0     400.0     200.0     200.0     200.0  \n",
       "2     265.0     169.0     319.0      89.0     182.0  \n",
       "3  218480.0  221579.0  222111.0  237614.0  243541.0  \n",
       "4    1138.0       NaN       NaN       NaN       NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_80.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2) Merge DataFrames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_91 = pd.merge(cu_mined_70_80, cu_mined_81_91, left_on='Country',right_on='Country', how ='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_02 = pd.merge(cu_mined_70_91, cu_mined_92_02, left_on='Country',right_on='Country', how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_13 = pd.merge(cu_mined_70_02, cu_mined_03_13, left_on='Country', right_on='Country', how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_18 = pd.merge(cu_mined_70_13, cu_mined_14_18, left_on='Country', right_on='Country', how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>...</th>\n",
       "      <th>yr2009</th>\n",
       "      <th>yr2010</th>\n",
       "      <th>yr2011</th>\n",
       "      <th>yr2012</th>\n",
       "      <th>yr2013</th>\n",
       "      <th>yr2014</th>\n",
       "      <th>yr2015</th>\n",
       "      <th>yr2016</th>\n",
       "      <th>yr2017</th>\n",
       "      <th>yr2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Albania</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>6500.0</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>11500.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>2672.0</td>\n",
       "      <td>4379.0</td>\n",
       "      <td>5691.0</td>\n",
       "      <td>5087.0</td>\n",
       "      <td>3503.0</td>\n",
       "      <td>2106.0</td>\n",
       "      <td>218.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2601.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>574.0</td>\n",
       "      <td>514.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>353.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>461.0</td>\n",
       "      <td>497.0</td>\n",
       "      <td>1125.0</td>\n",
       "      <td>284.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>380.0</td>\n",
       "      <td>265.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>...</td>\n",
       "      <td>143084.0</td>\n",
       "      <td>140300.0</td>\n",
       "      <td>116700.0</td>\n",
       "      <td>135700.0</td>\n",
       "      <td>109600.0</td>\n",
       "      <td>102600.0</td>\n",
       "      <td>61800.0</td>\n",
       "      <td>81900.0</td>\n",
       "      <td>33300.0</td>\n",
       "      <td>17400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Australia</td>\n",
       "      <td>157790.0</td>\n",
       "      <td>177261.0</td>\n",
       "      <td>185843.0</td>\n",
       "      <td>220335.0</td>\n",
       "      <td>251340.0</td>\n",
       "      <td>218961.0</td>\n",
       "      <td>218480.0</td>\n",
       "      <td>221579.0</td>\n",
       "      <td>222111.0</td>\n",
       "      <td>...</td>\n",
       "      <td>855892.0</td>\n",
       "      <td>871963.0</td>\n",
       "      <td>960649.0</td>\n",
       "      <td>921390.0</td>\n",
       "      <td>1000999.0</td>\n",
       "      <td>978534.0</td>\n",
       "      <td>995881.0</td>\n",
       "      <td>947555.0</td>\n",
       "      <td>849121.0</td>\n",
       "      <td>913336.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Austria</td>\n",
       "      <td>2262.0</td>\n",
       "      <td>2575.0</td>\n",
       "      <td>2231.0</td>\n",
       "      <td>2713.0</td>\n",
       "      <td>2612.0</td>\n",
       "      <td>1923.0</td>\n",
       "      <td>1138.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Country    yr1970    yr1971    yr1972    yr1973    yr1974    yr1975  \\\n",
       "0    Albania    6000.0    6500.0    6700.0    7000.0    7000.0    9000.0   \n",
       "1    Algeria     574.0     514.0     428.0     353.0     350.0     378.0   \n",
       "2  Argentina     461.0     497.0    1125.0     284.0     315.0     380.0   \n",
       "3  Australia  157790.0  177261.0  185843.0  220335.0  251340.0  218961.0   \n",
       "4    Austria    2262.0    2575.0    2231.0    2713.0    2612.0    1923.0   \n",
       "\n",
       "     yr1976    yr1977    yr1978  ...    yr2009    yr2010    yr2011    yr2012  \\\n",
       "0   10000.0   10000.0   11500.0  ...    2600.0    2672.0    4379.0    5691.0   \n",
       "1     400.0     400.0     200.0  ...       NaN       NaN       NaN       NaN   \n",
       "2     265.0     169.0     319.0  ...  143084.0  140300.0  116700.0  135700.0   \n",
       "3  218480.0  221579.0  222111.0  ...  855892.0  871963.0  960649.0  921390.0   \n",
       "4    1138.0       NaN       NaN  ...       NaN       NaN       NaN       NaN   \n",
       "\n",
       "      yr2013    yr2014    yr2015    yr2016    yr2017    yr2018  \n",
       "0     5087.0    3503.0    2106.0     218.0       0.0    2601.0  \n",
       "1        NaN       NaN       NaN       NaN       NaN       NaN  \n",
       "2   109600.0  102600.0   61800.0   81900.0   33300.0   17400.0  \n",
       "3  1000999.0  978534.0  995881.0  947555.0  849121.0  913336.0  \n",
       "4        NaN       NaN       NaN       NaN       NaN       NaN  \n",
       "\n",
       "[5 rows x 50 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((69, 12), (61, 12), (56, 12), (60, 12), (57, 6))"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_80.shape, cu_mined_81_91.shape, cu_mined_92_02.shape, cu_mined_03_13.shape,cu_mined_14_18.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(90, 50)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3) Clean data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 3.1) Examine the data type and null values in each column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 90 entries, 0 to 89\n",
      "Data columns (total 50 columns):\n",
      " #   Column   Non-Null Count  Dtype  \n",
      "---  ------   --------------  -----  \n",
      " 0   Country  90 non-null     object \n",
      " 1   yr1970   52 non-null     float64\n",
      " 2   yr1971   51 non-null     float64\n",
      " 3   yr1972   55 non-null     float64\n",
      " 4   yr1973   57 non-null     float64\n",
      " 5   yr1974   61 non-null     float64\n",
      " 6   yr1975   63 non-null     float64\n",
      " 7   yr1976   63 non-null     float64\n",
      " 8   yr1977   62 non-null     float64\n",
      " 9   yr1978   62 non-null     float64\n",
      " 10  yr1979   61 non-null     float64\n",
      " 11  yr1980   60 non-null     float64\n",
      " 12  yr1981   60 non-null     float64\n",
      " 13  yr1982   57 non-null     float64\n",
      " 14  yr1983   55 non-null     float64\n",
      " 15  yr1984   55 non-null     float64\n",
      " 16  yr1985   55 non-null     float64\n",
      " 17  yr1986   55 non-null     float64\n",
      " 18  yr1987   52 non-null     float64\n",
      " 19  yr1988   49 non-null     float64\n",
      " 20  yr1989   48 non-null     float64\n",
      " 21  yr1990   48 non-null     float64\n",
      " 22  yr1991   47 non-null     float64\n",
      " 23  yr1992   47 non-null     float64\n",
      " 24  yr1993   46 non-null     float64\n",
      " 25  yr1994   49 non-null     float64\n",
      " 26  yr1995   48 non-null     float64\n",
      " 27  yr1996   48 non-null     float64\n",
      " 28  yr1997   48 non-null     float64\n",
      " 29  yr1998   49 non-null     float64\n",
      " 30  yr1999   49 non-null     float64\n",
      " 31  yr2000   48 non-null     float64\n",
      " 32  yr2001   50 non-null     float64\n",
      " 33  yr2002   50 non-null     float64\n",
      " 34  yr2003   51 non-null     float64\n",
      " 35  yr2004   51 non-null     float64\n",
      " 36  yr2005   51 non-null     float64\n",
      " 37  yr2006   52 non-null     float64\n",
      " 38  yr2007   52 non-null     float64\n",
      " 39  yr2008   52 non-null     float64\n",
      " 40  yr2009   56 non-null     float64\n",
      " 41  yr2010   56 non-null     float64\n",
      " 42  yr2011   56 non-null     float64\n",
      " 43  yr2012   56 non-null     float64\n",
      " 44  yr2013   57 non-null     float64\n",
      " 45  yr2014   57 non-null     float64\n",
      " 46  yr2015   57 non-null     float64\n",
      " 47  yr2016   57 non-null     float64\n",
      " 48  yr2017   57 non-null     float64\n",
      " 49  yr2018   57 non-null     float64\n",
      "dtypes: float64(49), object(1)\n",
      "memory usage: 35.9+ KB\n"
     ]
    }
   ],
   "source": [
    "cu_mined_70_18.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 3.2) Fill NaN with zero"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_18.loc[:,'yr1970':'yr2018']=cu_mined_70_18.loc[:,'yr1970':'yr2018'].fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 90 entries, 0 to 89\n",
      "Data columns (total 50 columns):\n",
      " #   Column   Non-Null Count  Dtype  \n",
      "---  ------   --------------  -----  \n",
      " 0   Country  90 non-null     object \n",
      " 1   yr1970   90 non-null     float64\n",
      " 2   yr1971   90 non-null     float64\n",
      " 3   yr1972   90 non-null     float64\n",
      " 4   yr1973   90 non-null     float64\n",
      " 5   yr1974   90 non-null     float64\n",
      " 6   yr1975   90 non-null     float64\n",
      " 7   yr1976   90 non-null     float64\n",
      " 8   yr1977   90 non-null     float64\n",
      " 9   yr1978   90 non-null     float64\n",
      " 10  yr1979   90 non-null     float64\n",
      " 11  yr1980   90 non-null     float64\n",
      " 12  yr1981   90 non-null     float64\n",
      " 13  yr1982   90 non-null     float64\n",
      " 14  yr1983   90 non-null     float64\n",
      " 15  yr1984   90 non-null     float64\n",
      " 16  yr1985   90 non-null     float64\n",
      " 17  yr1986   90 non-null     float64\n",
      " 18  yr1987   90 non-null     float64\n",
      " 19  yr1988   90 non-null     float64\n",
      " 20  yr1989   90 non-null     float64\n",
      " 21  yr1990   90 non-null     float64\n",
      " 22  yr1991   90 non-null     float64\n",
      " 23  yr1992   90 non-null     float64\n",
      " 24  yr1993   90 non-null     float64\n",
      " 25  yr1994   90 non-null     float64\n",
      " 26  yr1995   90 non-null     float64\n",
      " 27  yr1996   90 non-null     float64\n",
      " 28  yr1997   90 non-null     float64\n",
      " 29  yr1998   90 non-null     float64\n",
      " 30  yr1999   90 non-null     float64\n",
      " 31  yr2000   90 non-null     float64\n",
      " 32  yr2001   90 non-null     float64\n",
      " 33  yr2002   90 non-null     float64\n",
      " 34  yr2003   90 non-null     float64\n",
      " 35  yr2004   90 non-null     float64\n",
      " 36  yr2005   90 non-null     float64\n",
      " 37  yr2006   90 non-null     float64\n",
      " 38  yr2007   90 non-null     float64\n",
      " 39  yr2008   90 non-null     float64\n",
      " 40  yr2009   90 non-null     float64\n",
      " 41  yr2010   90 non-null     float64\n",
      " 42  yr2011   90 non-null     float64\n",
      " 43  yr2012   90 non-null     float64\n",
      " 44  yr2013   90 non-null     float64\n",
      " 45  yr2014   90 non-null     float64\n",
      " 46  yr2015   90 non-null     float64\n",
      " 47  yr2016   90 non-null     float64\n",
      " 48  yr2017   90 non-null     float64\n",
      " 49  yr2018   90 non-null     float64\n",
      "dtypes: float64(49), object(1)\n",
      "memory usage: 35.9+ KB\n"
     ]
    }
   ],
   "source": [
    "cu_mined_70_18.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 3.2) Clean string values\n",
    "Replace country names with official country names using a dictionary of old:new names and .map()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Albania',\n",
       " 'Algeria',\n",
       " 'Argentina',\n",
       " 'Australia',\n",
       " 'Austria',\n",
       " 'Bolivia',\n",
       " 'Botswana',\n",
       " 'Brazil',\n",
       " 'Bulgaria',\n",
       " 'Burma',\n",
       " 'Canada',\n",
       " 'Chile',\n",
       " 'China',\n",
       " 'Colombia',\n",
       " 'Congo',\n",
       " 'Cuba',\n",
       " 'Cyprus',\n",
       " 'Czechoslovakia',\n",
       " 'Ecuador',\n",
       " 'Finland',\n",
       " 'France',\n",
       " 'German Democratic Rep',\n",
       " 'German Federal Republic',\n",
       " 'Greece',\n",
       " 'Guatemala',\n",
       " 'Haiti',\n",
       " 'Honduras',\n",
       " 'Hungary',\n",
       " 'India',\n",
       " 'Indonesia',\n",
       " 'Iran',\n",
       " 'Ireland, Republic of',\n",
       " 'Israel',\n",
       " 'Italy',\n",
       " 'Japan',\n",
       " 'Kenya',\n",
       " 'Korea (Rep. of)',\n",
       " 'Korea, Dem. P.R. of',\n",
       " 'Malaysia',\n",
       " 'Mauritania',\n",
       " 'Mexico',\n",
       " 'Mongolia',\n",
       " 'Morocco',\n",
       " 'Mozambique',\n",
       " 'Namibia',\n",
       " 'New Zealand',\n",
       " 'Nicaragua',\n",
       " 'Norway',\n",
       " 'Oman',\n",
       " 'Papua New Guinea',\n",
       " 'Peru',\n",
       " 'Philippines',\n",
       " 'Poland',\n",
       " 'Portugal',\n",
       " 'Rhodesia',\n",
       " 'Romania',\n",
       " 'South Africa',\n",
       " 'Soviet Union',\n",
       " 'Spain',\n",
       " 'Sweden',\n",
       " 'Taiwan',\n",
       " 'Turkey',\n",
       " 'USA',\n",
       " 'Uganda',\n",
       " 'United Kingdom',\n",
       " 'Yugoslavia',\n",
       " 'Zaire',\n",
       " 'Zambia',\n",
       " 'Zimbabwe',\n",
       " 'Germany',\n",
       " 'Armenia',\n",
       " 'Congo, Democratic Republic',\n",
       " 'Georgia',\n",
       " 'Kazakhstan',\n",
       " 'Laos',\n",
       " 'Macedonia',\n",
       " 'Pakistan',\n",
       " 'Russia',\n",
       " 'Saudi Arabia',\n",
       " 'Serbia',\n",
       " 'Serbia and Montenegro',\n",
       " 'Tanzania',\n",
       " 'Uzbekistan',\n",
       " 'Vietnam',\n",
       " 'Azerbaijan',\n",
       " 'Dominican Republic',\n",
       " 'Eritrea',\n",
       " 'Kyrgyzstan',\n",
       " 'Slovakia',\n",
       " 'Tajikistan']"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18['Country'].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "rename_map = {'German Democratic Rep':'Germany','German Federal Republic':'Germany',\n",
    "              'Ireland, Republic of':'Ireland','Korea (Rep. of)':'South Korea','Korea, Dem. P.R. of':'North Korea',\n",
    "              'Rhodesia':'Zimbabwe','Soviet Union':'Russia','USA':'United States of America',\n",
    "              'Congo, Democratic Republic':'Democratic Republic of the Congo','Serbia and Montenegro':'Republic of Serbia',\n",
    "              'Serbia':'Republic of Serbia','Congo':'Democratic Republic of the Congo','Tanzania':'United Republic of Tanzania',\n",
    "             'Burma':'Myanmar','Czechoslovakia':'Czechia','Zaire':'Democratic Republic of the Congo'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_18['Country'] = cu_mined_70_18['Country'].map(rename_map).fillna(cu_mined_70_18['Country'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Albania',\n",
       " 'Algeria',\n",
       " 'Argentina',\n",
       " 'Australia',\n",
       " 'Austria',\n",
       " 'Bolivia',\n",
       " 'Botswana',\n",
       " 'Brazil',\n",
       " 'Bulgaria',\n",
       " 'Myanmar',\n",
       " 'Canada',\n",
       " 'Chile',\n",
       " 'China',\n",
       " 'Colombia',\n",
       " 'Democratic Republic of the Congo',\n",
       " 'Cuba',\n",
       " 'Cyprus',\n",
       " 'Czechia',\n",
       " 'Ecuador',\n",
       " 'Finland',\n",
       " 'France',\n",
       " 'Germany',\n",
       " 'Germany',\n",
       " 'Greece',\n",
       " 'Guatemala',\n",
       " 'Haiti',\n",
       " 'Honduras',\n",
       " 'Hungary',\n",
       " 'India',\n",
       " 'Indonesia',\n",
       " 'Iran',\n",
       " 'Ireland',\n",
       " 'Israel',\n",
       " 'Italy',\n",
       " 'Japan',\n",
       " 'Kenya',\n",
       " 'South Korea',\n",
       " 'North Korea',\n",
       " 'Malaysia',\n",
       " 'Mauritania',\n",
       " 'Mexico',\n",
       " 'Mongolia',\n",
       " 'Morocco',\n",
       " 'Mozambique',\n",
       " 'Namibia',\n",
       " 'New Zealand',\n",
       " 'Nicaragua',\n",
       " 'Norway',\n",
       " 'Oman',\n",
       " 'Papua New Guinea',\n",
       " 'Peru',\n",
       " 'Philippines',\n",
       " 'Poland',\n",
       " 'Portugal',\n",
       " 'Zimbabwe',\n",
       " 'Romania',\n",
       " 'South Africa',\n",
       " 'Russia',\n",
       " 'Spain',\n",
       " 'Sweden',\n",
       " 'Taiwan',\n",
       " 'Turkey',\n",
       " 'United States of America',\n",
       " 'Uganda',\n",
       " 'United Kingdom',\n",
       " 'Yugoslavia',\n",
       " 'Democratic Republic of the Congo',\n",
       " 'Zambia',\n",
       " 'Zimbabwe',\n",
       " 'Germany',\n",
       " 'Armenia',\n",
       " 'Democratic Republic of the Congo',\n",
       " 'Georgia',\n",
       " 'Kazakhstan',\n",
       " 'Laos',\n",
       " 'Macedonia',\n",
       " 'Pakistan',\n",
       " 'Russia',\n",
       " 'Saudi Arabia',\n",
       " 'Republic of Serbia',\n",
       " 'Republic of Serbia',\n",
       " 'United Republic of Tanzania',\n",
       " 'Uzbekistan',\n",
       " 'Vietnam',\n",
       " 'Azerbaijan',\n",
       " 'Dominican Republic',\n",
       " 'Eritrea',\n",
       " 'Kyrgyzstan',\n",
       " 'Slovakia',\n",
       " 'Tajikistan']"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18['Country'].tolist()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 3.3) Check and remove duplicates in the country column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Germany                             3\n",
       "Democratic Republic of the Congo    3\n",
       "Republic of Serbia                  2\n",
       "Zimbabwe                            2\n",
       "Russia                              2\n",
       "Mongolia                            1\n",
       "Namibia                             1\n",
       "Finland                             1\n",
       "Turkey                              1\n",
       "Laos                                1\n",
       "South Korea                         1\n",
       "Malaysia                            1\n",
       "Kyrgyzstan                          1\n",
       "Slovakia                            1\n",
       "Yugoslavia                          1\n",
       "United Republic of Tanzania         1\n",
       "Taiwan                              1\n",
       "China                               1\n",
       "South Africa                        1\n",
       "Kenya                               1\n",
       "Papua New Guinea                    1\n",
       "Georgia                             1\n",
       "Brazil                              1\n",
       "Chile                               1\n",
       "Portugal                            1\n",
       "Canada                              1\n",
       "Tajikistan                          1\n",
       "Macedonia                           1\n",
       "Botswana                            1\n",
       "Indonesia                           1\n",
       "Hungary                             1\n",
       "Czechia                             1\n",
       "Ireland                             1\n",
       "Colombia                            1\n",
       "United Kingdom                      1\n",
       "Zambia                              1\n",
       "Armenia                             1\n",
       "Oman                                1\n",
       "Japan                               1\n",
       "Pakistan                            1\n",
       "Ecuador                             1\n",
       "Romania                             1\n",
       "India                               1\n",
       "Mauritania                          1\n",
       "Vietnam                             1\n",
       "Algeria                             1\n",
       "Spain                               1\n",
       "Italy                               1\n",
       "Myanmar                             1\n",
       "Saudi Arabia                        1\n",
       "North Korea                         1\n",
       "Argentina                           1\n",
       "Australia                           1\n",
       "Cyprus                              1\n",
       "Israel                              1\n",
       "Nicaragua                           1\n",
       "Bolivia                             1\n",
       "Dominican Republic                  1\n",
       "Poland                              1\n",
       "New Zealand                         1\n",
       "Mexico                              1\n",
       "Morocco                             1\n",
       "Sweden                              1\n",
       "Azerbaijan                          1\n",
       "Uzbekistan                          1\n",
       "Peru                                1\n",
       "Iran                                1\n",
       "Kazakhstan                          1\n",
       "Philippines                         1\n",
       "Albania                             1\n",
       "Bulgaria                            1\n",
       "Honduras                            1\n",
       "Mozambique                          1\n",
       "Austria                             1\n",
       "Eritrea                             1\n",
       "Greece                              1\n",
       "France                              1\n",
       "United States of America            1\n",
       "Uganda                              1\n",
       "Norway                              1\n",
       "Cuba                                1\n",
       "Haiti                               1\n",
       "Guatemala                           1\n",
       "Name: Country, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.Country.value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Create a for loop that extracts a sub-dataframe of the duplicated country rows and sums the rows to produce one row containing the total mined per year for that country."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[                                                         0\n",
       " Country  Democratic Republic of the CongoDemocratic Rep...\n",
       " yr1970                                              385948\n",
       " yr1971                                              409770\n",
       " yr1972                                              443986\n",
       " yr1973                                              492223\n",
       " yr1974                                              501431\n",
       " yr1975                                              465846\n",
       " yr1976                                              444356\n",
       " yr1977                                              453731\n",
       " yr1978                                              473128\n",
       " yr1979                                              402416\n",
       " yr1980                                              463502\n",
       " yr1981                                              506726\n",
       " yr1982                                              505485\n",
       " yr1983                                              504307\n",
       " yr1984                                              500220\n",
       " yr1985                                              504335\n",
       " yr1986                                              503300\n",
       " yr1987                                              502184\n",
       " yr1988                                              506320\n",
       " yr1989                                              442800\n",
       " yr1990                                              352400\n",
       " yr1991                                              236100\n",
       " yr1992                                              144300\n",
       " yr1993                                               60000\n",
       " yr1994                                               40642\n",
       " yr1995                                               34958\n",
       " yr1996                                               40165\n",
       " yr1997                                               39651\n",
       " yr1998                                               38236\n",
       " yr1999                                               33000\n",
       " yr2000                                               33000\n",
       " yr2001                                               37845\n",
       " yr2002                                               27359\n",
       " yr2003                                               16359\n",
       " yr2004                                               18995\n",
       " yr2005                                               97500\n",
       " yr2006                                              142300\n",
       " yr2007                                              144600\n",
       " yr2008                                              239200\n",
       " yr2009                                              299300\n",
       " yr2010                                              378300\n",
       " yr2011                                              499198\n",
       " yr2012                                              619942\n",
       " yr2013                                              922016\n",
       " yr2014                                         1.03013e+06\n",
       " yr2015                                         1.03901e+06\n",
       " yr2016                                         1.02369e+06\n",
       " yr2017                                         1.09464e+06\n",
       " yr2018                                         1.22523e+06,\n",
       "                              0\n",
       " Country  GermanyGermanyGermany\n",
       " yr1970                   19477\n",
       " yr1971                   16484\n",
       " yr1972                   21321\n",
       " yr1973                   19436\n",
       " yr1974                   19734\n",
       " yr1975                   18461\n",
       " yr1976                   17613\n",
       " yr1977                   18210\n",
       " yr1978                   15821\n",
       " yr1979                   14851\n",
       " yr1980                   13074\n",
       " yr1981                   13400\n",
       " yr1982                   14300\n",
       " yr1983                   13200\n",
       " yr1984                   13000\n",
       " yr1985                   13500\n",
       " yr1986                   12300\n",
       " yr1987                   12612\n",
       " yr1988                    9719\n",
       " yr1989                    8006\n",
       " yr1990                    3564\n",
       " yr1991                       0\n",
       " yr1992                       0\n",
       " yr1993                       0\n",
       " yr1994                       0\n",
       " yr1995                       0\n",
       " yr1996                       0\n",
       " yr1997                       0\n",
       " yr1998                       0\n",
       " yr1999                       0\n",
       " yr2000                       0\n",
       " yr2001                       0\n",
       " yr2002                       0\n",
       " yr2003                       0\n",
       " yr2004                       0\n",
       " yr2005                       0\n",
       " yr2006                       0\n",
       " yr2007                       0\n",
       " yr2008                       0\n",
       " yr2009                       0\n",
       " yr2010                       0\n",
       " yr2011                       0\n",
       " yr2012                       0\n",
       " yr2013                       0\n",
       " yr2014                       0\n",
       " yr2015                       0\n",
       " yr2016                       0\n",
       " yr2017                       0\n",
       " yr2018                       0,\n",
       "                                             0\n",
       " Country  Republic of SerbiaRepublic of Serbia\n",
       " yr1970                                      0\n",
       " yr1971                                      0\n",
       " yr1972                                      0\n",
       " yr1973                                      0\n",
       " yr1974                                      0\n",
       " yr1975                                      0\n",
       " yr1976                                      0\n",
       " yr1977                                      0\n",
       " yr1978                                      0\n",
       " yr1979                                      0\n",
       " yr1980                                      0\n",
       " yr1981                                      0\n",
       " yr1982                                      0\n",
       " yr1983                                      0\n",
       " yr1984                                      0\n",
       " yr1985                                      0\n",
       " yr1986                                      0\n",
       " yr1987                                      0\n",
       " yr1988                                      0\n",
       " yr1989                                      0\n",
       " yr1990                                      0\n",
       " yr1991                                      0\n",
       " yr1992                                  97811\n",
       " yr1993                                  57375\n",
       " yr1994                                  74351\n",
       " yr1995                                  74619\n",
       " yr1996                                  69467\n",
       " yr1997                                  73567\n",
       " yr1998                                  70900\n",
       " yr1999                                  51700\n",
       " yr2000                                  46000\n",
       " yr2001                                  31000\n",
       " yr2002                                  23100\n",
       " yr2003                                  15500\n",
       " yr2004                                  13800\n",
       " yr2005                                  11600\n",
       " yr2006                                  11100\n",
       " yr2007                                  16500\n",
       " yr2008                                  17600\n",
       " yr2009                                  19400\n",
       " yr2010                                  22800\n",
       " yr2011                                  26100\n",
       " yr2012                                  32200\n",
       " yr2013                                  36200\n",
       " yr2014                                  33739\n",
       " yr2015                                  29827\n",
       " yr2016                                  41300\n",
       " yr2017                                  44800\n",
       " yr2018                                  44100,\n",
       "                         0\n",
       " Country  ZimbabweZimbabwe\n",
       " yr1970              24000\n",
       " yr1971              23300\n",
       " yr1972              31800\n",
       " yr1973              35000\n",
       " yr1974              40000\n",
       " yr1975              47579\n",
       " yr1976              48186\n",
       " yr1977              34767\n",
       " yr1978              33848\n",
       " yr1979              29724\n",
       " yr1980              26901\n",
       " yr1981              24583\n",
       " yr1982              24800\n",
       " yr1983              21560\n",
       " yr1984              22687\n",
       " yr1985              20700\n",
       " yr1986              20600\n",
       " yr1987              18800\n",
       " yr1988              16116\n",
       " yr1989              15800\n",
       " yr1990              14800\n",
       " yr1991              13811\n",
       " yr1992               9673\n",
       " yr1993               8187\n",
       " yr1994               9350\n",
       " yr1995               8045\n",
       " yr1996               9028\n",
       " yr1997               6832\n",
       " yr1998               2941\n",
       " yr1999               4977\n",
       " yr2000                558\n",
       " yr2001               2057\n",
       " yr2002               2502\n",
       " yr2003               2767\n",
       " yr2004               2383\n",
       " yr2005               2570\n",
       " yr2006               2581\n",
       " yr2007               2681\n",
       " yr2008               2827\n",
       " yr2009               3572\n",
       " yr2010               4629\n",
       " yr2011               6555\n",
       " yr2012               6665\n",
       " yr2013               8285\n",
       " yr2014               8261\n",
       " yr2015               8218\n",
       " yr2016               9101\n",
       " yr2017               8839\n",
       " yr2018               9077,\n",
       "                     0\n",
       " Country  RussiaRussia\n",
       " yr1970         925000\n",
       " yr1971         990000\n",
       " yr1972       1.03e+06\n",
       " yr1973       1.06e+06\n",
       " yr1974       1.06e+06\n",
       " yr1975        1.1e+06\n",
       " yr1976       1.13e+06\n",
       " yr1977        1.1e+06\n",
       " yr1978       1.14e+06\n",
       " yr1979       1.13e+06\n",
       " yr1980         980000\n",
       " yr1981          1e+06\n",
       " yr1982       1.01e+06\n",
       " yr1983       1.02e+06\n",
       " yr1984       1.02e+06\n",
       " yr1985       1.03e+06\n",
       " yr1986       1.03e+06\n",
       " yr1987       1.01e+06\n",
       " yr1988         990000\n",
       " yr1989         950000\n",
       " yr1990         900000\n",
       " yr1991         840000\n",
       " yr1992         680000\n",
       " yr1993         594000\n",
       " yr1994         573300\n",
       " yr1995         525900\n",
       " yr1996         523000\n",
       " yr1997         505000\n",
       " yr1998         530000\n",
       " yr1999         535000\n",
       " yr2000         530000\n",
       " yr2001         540000\n",
       " yr2002         662100\n",
       " yr2003         650000\n",
       " yr2004         630000\n",
       " yr2005         640000\n",
       " yr2006         675000\n",
       " yr2007         690000\n",
       " yr2008         705000\n",
       " yr2009         675700\n",
       " yr2010         702700\n",
       " yr2011         587900\n",
       " yr2012         582900\n",
       " yr2013         655900\n",
       " yr2014         691500\n",
       " yr2015         711400\n",
       " yr2016         702300\n",
       " yr2017         762300\n",
       " yr2018         785300]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_list=['Democratic Republic of the Congo', 'Germany','Republic of Serbia','Zimbabwe','Russia']\n",
    "subdf_list=[]\n",
    "for country in country_list:\n",
    "    sub_df=(cu_mined_70_18[cu_mined_70_18['Country'] == country])\n",
    "    summed=sub_df.sum(skipna=True)\n",
    "    DF = pd.DataFrame(summed)\n",
    "    subdf_list.append(DF)\n",
    "subdf_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <td>Democratic Republic of the CongoDemocratic Rep...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1970</th>\n",
       "      <td>385948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1971</th>\n",
       "      <td>409770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1972</th>\n",
       "      <td>443986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1973</th>\n",
       "      <td>492223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1974</th>\n",
       "      <td>501431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1975</th>\n",
       "      <td>465846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1976</th>\n",
       "      <td>444356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1977</th>\n",
       "      <td>453731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1978</th>\n",
       "      <td>473128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1979</th>\n",
       "      <td>402416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1980</th>\n",
       "      <td>463502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1981</th>\n",
       "      <td>506726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1982</th>\n",
       "      <td>505485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1983</th>\n",
       "      <td>504307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1984</th>\n",
       "      <td>500220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1985</th>\n",
       "      <td>504335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1986</th>\n",
       "      <td>503300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1987</th>\n",
       "      <td>502184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1988</th>\n",
       "      <td>506320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1989</th>\n",
       "      <td>442800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1990</th>\n",
       "      <td>352400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1991</th>\n",
       "      <td>236100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1992</th>\n",
       "      <td>144300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1993</th>\n",
       "      <td>60000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1994</th>\n",
       "      <td>40642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1995</th>\n",
       "      <td>34958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1996</th>\n",
       "      <td>40165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1997</th>\n",
       "      <td>39651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1998</th>\n",
       "      <td>38236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr1999</th>\n",
       "      <td>33000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2000</th>\n",
       "      <td>33000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2001</th>\n",
       "      <td>37845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2002</th>\n",
       "      <td>27359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2003</th>\n",
       "      <td>16359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2004</th>\n",
       "      <td>18995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2005</th>\n",
       "      <td>97500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2006</th>\n",
       "      <td>142300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2007</th>\n",
       "      <td>144600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2008</th>\n",
       "      <td>239200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2009</th>\n",
       "      <td>299300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2010</th>\n",
       "      <td>378300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2011</th>\n",
       "      <td>499198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2012</th>\n",
       "      <td>619942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2013</th>\n",
       "      <td>922016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2014</th>\n",
       "      <td>1.03013e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2015</th>\n",
       "      <td>1.03901e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2016</th>\n",
       "      <td>1.02369e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2017</th>\n",
       "      <td>1.09464e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yr2018</th>\n",
       "      <td>1.22523e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                         0\n",
       "Country  Democratic Republic of the CongoDemocratic Rep...\n",
       "yr1970                                              385948\n",
       "yr1971                                              409770\n",
       "yr1972                                              443986\n",
       "yr1973                                              492223\n",
       "yr1974                                              501431\n",
       "yr1975                                              465846\n",
       "yr1976                                              444356\n",
       "yr1977                                              453731\n",
       "yr1978                                              473128\n",
       "yr1979                                              402416\n",
       "yr1980                                              463502\n",
       "yr1981                                              506726\n",
       "yr1982                                              505485\n",
       "yr1983                                              504307\n",
       "yr1984                                              500220\n",
       "yr1985                                              504335\n",
       "yr1986                                              503300\n",
       "yr1987                                              502184\n",
       "yr1988                                              506320\n",
       "yr1989                                              442800\n",
       "yr1990                                              352400\n",
       "yr1991                                              236100\n",
       "yr1992                                              144300\n",
       "yr1993                                               60000\n",
       "yr1994                                               40642\n",
       "yr1995                                               34958\n",
       "yr1996                                               40165\n",
       "yr1997                                               39651\n",
       "yr1998                                               38236\n",
       "yr1999                                               33000\n",
       "yr2000                                               33000\n",
       "yr2001                                               37845\n",
       "yr2002                                               27359\n",
       "yr2003                                               16359\n",
       "yr2004                                               18995\n",
       "yr2005                                               97500\n",
       "yr2006                                              142300\n",
       "yr2007                                              144600\n",
       "yr2008                                              239200\n",
       "yr2009                                              299300\n",
       "yr2010                                              378300\n",
       "yr2011                                              499198\n",
       "yr2012                                              619942\n",
       "yr2013                                              922016\n",
       "yr2014                                         1.03013e+06\n",
       "yr2015                                         1.03901e+06\n",
       "yr2016                                         1.02369e+06\n",
       "yr2017                                         1.09464e+06\n",
       "yr2018                                         1.22523e+06"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subdf_list[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 3.4) Create a new dataframe for each of the countries by extracting each dataframe from the list and transposing the dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "DRC=subdf_list[0].T\n",
    "G=subdf_list[1].T\n",
    "RS=subdf_list[2].T\n",
    "Z=subdf_list[3].T\n",
    "R=subdf_list[4].T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>...</th>\n",
       "      <th>yr2009</th>\n",
       "      <th>yr2010</th>\n",
       "      <th>yr2011</th>\n",
       "      <th>yr2012</th>\n",
       "      <th>yr2013</th>\n",
       "      <th>yr2014</th>\n",
       "      <th>yr2015</th>\n",
       "      <th>yr2016</th>\n",
       "      <th>yr2017</th>\n",
       "      <th>yr2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Democratic Republic of the CongoDemocratic Rep...</td>\n",
       "      <td>385948</td>\n",
       "      <td>409770</td>\n",
       "      <td>443986</td>\n",
       "      <td>492223</td>\n",
       "      <td>501431</td>\n",
       "      <td>465846</td>\n",
       "      <td>444356</td>\n",
       "      <td>453731</td>\n",
       "      <td>473128</td>\n",
       "      <td>...</td>\n",
       "      <td>299300</td>\n",
       "      <td>378300</td>\n",
       "      <td>499198</td>\n",
       "      <td>619942</td>\n",
       "      <td>922016</td>\n",
       "      <td>1.03013e+06</td>\n",
       "      <td>1.03901e+06</td>\n",
       "      <td>1.02369e+06</td>\n",
       "      <td>1.09464e+06</td>\n",
       "      <td>1.22523e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Country  yr1970  yr1971  yr1972  \\\n",
       "0  Democratic Republic of the CongoDemocratic Rep...  385948  409770  443986   \n",
       "\n",
       "   yr1973  yr1974  yr1975  yr1976  yr1977  yr1978  ...  yr2009  yr2010  \\\n",
       "0  492223  501431  465846  444356  453731  473128  ...  299300  378300   \n",
       "\n",
       "   yr2011  yr2012  yr2013       yr2014       yr2015       yr2016       yr2017  \\\n",
       "0  499198  619942  922016  1.03013e+06  1.03901e+06  1.02369e+06  1.09464e+06   \n",
       "\n",
       "        yr2018  \n",
       "0  1.22523e+06  \n",
       "\n",
       "[1 rows x 50 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DRC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Alternatively can define a function that is assigned to the new dataframe variable and called with \n",
    "#the index of the dataframe in the list and transposed in the one line, rather then assigning the \n",
    "#subdf to the variable.\n",
    "#def function():\n",
    "    #df_list=[]\n",
    "    #for country in country_list:\n",
    "        #subdf=(cu_mined_70_18[cu_mined_70_18['Country'] == country])\n",
    "        #summed=subdf.sum(skipna=True)\n",
    "        #DF = pd.DataFrame(summed)\n",
    "        #df_list.append(DF)\n",
    "    #return df_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "#DRC=function()[0].T\n",
    "#DRC"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 3.5) Join all 5 dataframes into one dataframe. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>...</th>\n",
       "      <th>yr2009</th>\n",
       "      <th>yr2010</th>\n",
       "      <th>yr2011</th>\n",
       "      <th>yr2012</th>\n",
       "      <th>yr2013</th>\n",
       "      <th>yr2014</th>\n",
       "      <th>yr2015</th>\n",
       "      <th>yr2016</th>\n",
       "      <th>yr2017</th>\n",
       "      <th>yr2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Democratic Republic of the CongoDemocratic Rep...</td>\n",
       "      <td>385948</td>\n",
       "      <td>409770</td>\n",
       "      <td>443986</td>\n",
       "      <td>492223</td>\n",
       "      <td>501431</td>\n",
       "      <td>465846</td>\n",
       "      <td>444356</td>\n",
       "      <td>453731</td>\n",
       "      <td>473128</td>\n",
       "      <td>...</td>\n",
       "      <td>299300</td>\n",
       "      <td>378300</td>\n",
       "      <td>499198</td>\n",
       "      <td>619942</td>\n",
       "      <td>922016</td>\n",
       "      <td>1.03013e+06</td>\n",
       "      <td>1.03901e+06</td>\n",
       "      <td>1.02369e+06</td>\n",
       "      <td>1.09464e+06</td>\n",
       "      <td>1.22523e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GermanyGermanyGermany</td>\n",
       "      <td>19477</td>\n",
       "      <td>16484</td>\n",
       "      <td>21321</td>\n",
       "      <td>19436</td>\n",
       "      <td>19734</td>\n",
       "      <td>18461</td>\n",
       "      <td>17613</td>\n",
       "      <td>18210</td>\n",
       "      <td>15821</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Republic of SerbiaRepublic of Serbia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>19400</td>\n",
       "      <td>22800</td>\n",
       "      <td>26100</td>\n",
       "      <td>32200</td>\n",
       "      <td>36200</td>\n",
       "      <td>33739</td>\n",
       "      <td>29827</td>\n",
       "      <td>41300</td>\n",
       "      <td>44800</td>\n",
       "      <td>44100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ZimbabweZimbabwe</td>\n",
       "      <td>24000</td>\n",
       "      <td>23300</td>\n",
       "      <td>31800</td>\n",
       "      <td>35000</td>\n",
       "      <td>40000</td>\n",
       "      <td>47579</td>\n",
       "      <td>48186</td>\n",
       "      <td>34767</td>\n",
       "      <td>33848</td>\n",
       "      <td>...</td>\n",
       "      <td>3572</td>\n",
       "      <td>4629</td>\n",
       "      <td>6555</td>\n",
       "      <td>6665</td>\n",
       "      <td>8285</td>\n",
       "      <td>8261</td>\n",
       "      <td>8218</td>\n",
       "      <td>9101</td>\n",
       "      <td>8839</td>\n",
       "      <td>9077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>RussiaRussia</td>\n",
       "      <td>925000</td>\n",
       "      <td>990000</td>\n",
       "      <td>1.03e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.13e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.14e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>675700</td>\n",
       "      <td>702700</td>\n",
       "      <td>587900</td>\n",
       "      <td>582900</td>\n",
       "      <td>655900</td>\n",
       "      <td>691500</td>\n",
       "      <td>711400</td>\n",
       "      <td>702300</td>\n",
       "      <td>762300</td>\n",
       "      <td>785300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Country  yr1970  yr1971  \\\n",
       "0  Democratic Republic of the CongoDemocratic Rep...  385948  409770   \n",
       "0                              GermanyGermanyGermany   19477   16484   \n",
       "0               Republic of SerbiaRepublic of Serbia       0       0   \n",
       "0                                   ZimbabweZimbabwe   24000   23300   \n",
       "0                                       RussiaRussia  925000  990000   \n",
       "\n",
       "     yr1972    yr1973    yr1974   yr1975    yr1976   yr1977    yr1978  ...  \\\n",
       "0    443986    492223    501431   465846    444356   453731    473128  ...   \n",
       "0     21321     19436     19734    18461     17613    18210     15821  ...   \n",
       "0         0         0         0        0         0        0         0  ...   \n",
       "0     31800     35000     40000    47579     48186    34767     33848  ...   \n",
       "0  1.03e+06  1.06e+06  1.06e+06  1.1e+06  1.13e+06  1.1e+06  1.14e+06  ...   \n",
       "\n",
       "   yr2009  yr2010  yr2011  yr2012  yr2013       yr2014       yr2015  \\\n",
       "0  299300  378300  499198  619942  922016  1.03013e+06  1.03901e+06   \n",
       "0       0       0       0       0       0            0            0   \n",
       "0   19400   22800   26100   32200   36200        33739        29827   \n",
       "0    3572    4629    6555    6665    8285         8261         8218   \n",
       "0  675700  702700  587900  582900  655900       691500       711400   \n",
       "\n",
       "        yr2016       yr2017       yr2018  \n",
       "0  1.02369e+06  1.09464e+06  1.22523e+06  \n",
       "0            0            0            0  \n",
       "0        41300        44800        44100  \n",
       "0         9101         8839         9077  \n",
       "0       702300       762300       785300  \n",
       "\n",
       "[5 rows x 50 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subdf_concat=pd.concat([DRC, G, RS, Z, R])\n",
    "subdf_concat"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Replace the multiple country names in each row with one country name."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "subdf_concat['Country']=subdf_concat['Country'].replace({'Republic of SerbiaRepublic of Serbia':'Republic of Serbia', 'GermanyGermanyGermany':'Germany','Democratic Republic of the CongoDemocratic Republic of the CongoDemocratic Republic of the Congo':'Democratic Republic of the Congo','ZimbabweZimbabwe':'Zimbabwe','RussiaRussia':'Russia'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>...</th>\n",
       "      <th>yr2009</th>\n",
       "      <th>yr2010</th>\n",
       "      <th>yr2011</th>\n",
       "      <th>yr2012</th>\n",
       "      <th>yr2013</th>\n",
       "      <th>yr2014</th>\n",
       "      <th>yr2015</th>\n",
       "      <th>yr2016</th>\n",
       "      <th>yr2017</th>\n",
       "      <th>yr2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Democratic Republic of the Congo</td>\n",
       "      <td>385948</td>\n",
       "      <td>409770</td>\n",
       "      <td>443986</td>\n",
       "      <td>492223</td>\n",
       "      <td>501431</td>\n",
       "      <td>465846</td>\n",
       "      <td>444356</td>\n",
       "      <td>453731</td>\n",
       "      <td>473128</td>\n",
       "      <td>...</td>\n",
       "      <td>299300</td>\n",
       "      <td>378300</td>\n",
       "      <td>499198</td>\n",
       "      <td>619942</td>\n",
       "      <td>922016</td>\n",
       "      <td>1.03013e+06</td>\n",
       "      <td>1.03901e+06</td>\n",
       "      <td>1.02369e+06</td>\n",
       "      <td>1.09464e+06</td>\n",
       "      <td>1.22523e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Germany</td>\n",
       "      <td>19477</td>\n",
       "      <td>16484</td>\n",
       "      <td>21321</td>\n",
       "      <td>19436</td>\n",
       "      <td>19734</td>\n",
       "      <td>18461</td>\n",
       "      <td>17613</td>\n",
       "      <td>18210</td>\n",
       "      <td>15821</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Republic of Serbia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>19400</td>\n",
       "      <td>22800</td>\n",
       "      <td>26100</td>\n",
       "      <td>32200</td>\n",
       "      <td>36200</td>\n",
       "      <td>33739</td>\n",
       "      <td>29827</td>\n",
       "      <td>41300</td>\n",
       "      <td>44800</td>\n",
       "      <td>44100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>24000</td>\n",
       "      <td>23300</td>\n",
       "      <td>31800</td>\n",
       "      <td>35000</td>\n",
       "      <td>40000</td>\n",
       "      <td>47579</td>\n",
       "      <td>48186</td>\n",
       "      <td>34767</td>\n",
       "      <td>33848</td>\n",
       "      <td>...</td>\n",
       "      <td>3572</td>\n",
       "      <td>4629</td>\n",
       "      <td>6555</td>\n",
       "      <td>6665</td>\n",
       "      <td>8285</td>\n",
       "      <td>8261</td>\n",
       "      <td>8218</td>\n",
       "      <td>9101</td>\n",
       "      <td>8839</td>\n",
       "      <td>9077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Russia</td>\n",
       "      <td>925000</td>\n",
       "      <td>990000</td>\n",
       "      <td>1.03e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.13e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.14e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>675700</td>\n",
       "      <td>702700</td>\n",
       "      <td>587900</td>\n",
       "      <td>582900</td>\n",
       "      <td>655900</td>\n",
       "      <td>691500</td>\n",
       "      <td>711400</td>\n",
       "      <td>702300</td>\n",
       "      <td>762300</td>\n",
       "      <td>785300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Country  yr1970  yr1971    yr1972    yr1973  \\\n",
       "0  Democratic Republic of the Congo  385948  409770    443986    492223   \n",
       "0                           Germany   19477   16484     21321     19436   \n",
       "0                Republic of Serbia       0       0         0         0   \n",
       "0                          Zimbabwe   24000   23300     31800     35000   \n",
       "0                            Russia  925000  990000  1.03e+06  1.06e+06   \n",
       "\n",
       "     yr1974   yr1975    yr1976   yr1977    yr1978  ...  yr2009  yr2010  \\\n",
       "0    501431   465846    444356   453731    473128  ...  299300  378300   \n",
       "0     19734    18461     17613    18210     15821  ...       0       0   \n",
       "0         0        0         0        0         0  ...   19400   22800   \n",
       "0     40000    47579     48186    34767     33848  ...    3572    4629   \n",
       "0  1.06e+06  1.1e+06  1.13e+06  1.1e+06  1.14e+06  ...  675700  702700   \n",
       "\n",
       "   yr2011  yr2012  yr2013       yr2014       yr2015       yr2016       yr2017  \\\n",
       "0  499198  619942  922016  1.03013e+06  1.03901e+06  1.02369e+06  1.09464e+06   \n",
       "0       0       0       0            0            0            0            0   \n",
       "0   26100   32200   36200        33739        29827        41300        44800   \n",
       "0    6555    6665    8285         8261         8218         9101         8839   \n",
       "0  587900  582900  655900       691500       711400       702300       762300   \n",
       "\n",
       "        yr2018  \n",
       "0  1.22523e+06  \n",
       "0            0  \n",
       "0        44100  \n",
       "0         9077  \n",
       "0       785300  \n",
       "\n",
       "[5 rows x 50 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subdf_concat"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 3.6) Remove duplicate rows from original dataframe and append sub-dataframe with summed rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>...</th>\n",
       "      <th>yr2009</th>\n",
       "      <th>yr2010</th>\n",
       "      <th>yr2011</th>\n",
       "      <th>yr2012</th>\n",
       "      <th>yr2013</th>\n",
       "      <th>yr2014</th>\n",
       "      <th>yr2015</th>\n",
       "      <th>yr2016</th>\n",
       "      <th>yr2017</th>\n",
       "      <th>yr2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Democratic Republic of the Congo</td>\n",
       "      <td>269.0</td>\n",
       "      <td>2070.0</td>\n",
       "      <td>5485.0</td>\n",
       "      <td>3709.0</td>\n",
       "      <td>2100.0</td>\n",
       "      <td>918.0</td>\n",
       "      <td>408.0</td>\n",
       "      <td>1015.0</td>\n",
       "      <td>595.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Germany</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>16500.0</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>17000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Germany</td>\n",
       "      <td>1477.0</td>\n",
       "      <td>1484.0</td>\n",
       "      <td>1321.0</td>\n",
       "      <td>1436.0</td>\n",
       "      <td>1734.0</td>\n",
       "      <td>1961.0</td>\n",
       "      <td>1613.0</td>\n",
       "      <td>1210.0</td>\n",
       "      <td>821.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>24000.0</td>\n",
       "      <td>23300.0</td>\n",
       "      <td>31800.0</td>\n",
       "      <td>35000.0</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>47579.0</td>\n",
       "      <td>48186.0</td>\n",
       "      <td>34767.0</td>\n",
       "      <td>33848.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Russia</td>\n",
       "      <td>925000.0</td>\n",
       "      <td>990000.0</td>\n",
       "      <td>1030000.0</td>\n",
       "      <td>1060000.0</td>\n",
       "      <td>1060000.0</td>\n",
       "      <td>1100000.0</td>\n",
       "      <td>1130000.0</td>\n",
       "      <td>1100000.0</td>\n",
       "      <td>1140000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Democratic Republic of the Congo</td>\n",
       "      <td>385679.0</td>\n",
       "      <td>407700.0</td>\n",
       "      <td>438501.0</td>\n",
       "      <td>488514.0</td>\n",
       "      <td>499331.0</td>\n",
       "      <td>464928.0</td>\n",
       "      <td>443948.0</td>\n",
       "      <td>452716.0</td>\n",
       "      <td>472533.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3572.0</td>\n",
       "      <td>4629.0</td>\n",
       "      <td>6555.0</td>\n",
       "      <td>6665.0</td>\n",
       "      <td>8285.0</td>\n",
       "      <td>8261.0</td>\n",
       "      <td>8218.0</td>\n",
       "      <td>9101.0</td>\n",
       "      <td>8839.0</td>\n",
       "      <td>9077.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Germany</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Democratic Republic of the Congo</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>299300.0</td>\n",
       "      <td>378300.0</td>\n",
       "      <td>499198.0</td>\n",
       "      <td>619942.0</td>\n",
       "      <td>922016.0</td>\n",
       "      <td>1030129.0</td>\n",
       "      <td>1039007.0</td>\n",
       "      <td>1023687.0</td>\n",
       "      <td>1094638.0</td>\n",
       "      <td>1225227.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Russia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>675700.0</td>\n",
       "      <td>702700.0</td>\n",
       "      <td>587900.0</td>\n",
       "      <td>582900.0</td>\n",
       "      <td>655900.0</td>\n",
       "      <td>691500.0</td>\n",
       "      <td>711400.0</td>\n",
       "      <td>702300.0</td>\n",
       "      <td>762300.0</td>\n",
       "      <td>785300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Republic of Serbia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>19400.0</td>\n",
       "      <td>22800.0</td>\n",
       "      <td>26100.0</td>\n",
       "      <td>32200.0</td>\n",
       "      <td>36200.0</td>\n",
       "      <td>33739.0</td>\n",
       "      <td>29827.0</td>\n",
       "      <td>41300.0</td>\n",
       "      <td>44800.0</td>\n",
       "      <td>44100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Republic of Serbia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Country    yr1970    yr1971     yr1972  \\\n",
       "14  Democratic Republic of the Congo     269.0    2070.0     5485.0   \n",
       "21                           Germany   18000.0   15000.0    20000.0   \n",
       "22                           Germany    1477.0    1484.0     1321.0   \n",
       "54                          Zimbabwe   24000.0   23300.0    31800.0   \n",
       "57                            Russia  925000.0  990000.0  1030000.0   \n",
       "66  Democratic Republic of the Congo  385679.0  407700.0   438501.0   \n",
       "68                          Zimbabwe       0.0       0.0        0.0   \n",
       "69                           Germany       0.0       0.0        0.0   \n",
       "71  Democratic Republic of the Congo       0.0       0.0        0.0   \n",
       "77                            Russia       0.0       0.0        0.0   \n",
       "79                Republic of Serbia       0.0       0.0        0.0   \n",
       "80                Republic of Serbia       0.0       0.0        0.0   \n",
       "\n",
       "       yr1973     yr1974     yr1975     yr1976     yr1977     yr1978  ...  \\\n",
       "14     3709.0     2100.0      918.0      408.0     1015.0      595.0  ...   \n",
       "21    18000.0    18000.0    16500.0    16000.0    17000.0    15000.0  ...   \n",
       "22     1436.0     1734.0     1961.0     1613.0     1210.0      821.0  ...   \n",
       "54    35000.0    40000.0    47579.0    48186.0    34767.0    33848.0  ...   \n",
       "57  1060000.0  1060000.0  1100000.0  1130000.0  1100000.0  1140000.0  ...   \n",
       "66   488514.0   499331.0   464928.0   443948.0   452716.0   472533.0  ...   \n",
       "68        0.0        0.0        0.0        0.0        0.0        0.0  ...   \n",
       "69        0.0        0.0        0.0        0.0        0.0        0.0  ...   \n",
       "71        0.0        0.0        0.0        0.0        0.0        0.0  ...   \n",
       "77        0.0        0.0        0.0        0.0        0.0        0.0  ...   \n",
       "79        0.0        0.0        0.0        0.0        0.0        0.0  ...   \n",
       "80        0.0        0.0        0.0        0.0        0.0        0.0  ...   \n",
       "\n",
       "      yr2009    yr2010    yr2011    yr2012    yr2013     yr2014     yr2015  \\\n",
       "14       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "21       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "22       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "54       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "57       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "66       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "68    3572.0    4629.0    6555.0    6665.0    8285.0     8261.0     8218.0   \n",
       "69       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "71  299300.0  378300.0  499198.0  619942.0  922016.0  1030129.0  1039007.0   \n",
       "77  675700.0  702700.0  587900.0  582900.0  655900.0   691500.0   711400.0   \n",
       "79   19400.0   22800.0   26100.0   32200.0   36200.0    33739.0    29827.0   \n",
       "80       0.0       0.0       0.0       0.0       0.0        0.0        0.0   \n",
       "\n",
       "       yr2016     yr2017     yr2018  \n",
       "14        0.0        0.0        0.0  \n",
       "21        0.0        0.0        0.0  \n",
       "22        0.0        0.0        0.0  \n",
       "54        0.0        0.0        0.0  \n",
       "57        0.0        0.0        0.0  \n",
       "66        0.0        0.0        0.0  \n",
       "68     9101.0     8839.0     9077.0  \n",
       "69        0.0        0.0        0.0  \n",
       "71  1023687.0  1094638.0  1225227.0  \n",
       "77   702300.0   762300.0   785300.0  \n",
       "79    41300.0    44800.0    44100.0  \n",
       "80        0.0        0.0        0.0  \n",
       "\n",
       "[12 rows x 50 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "duplicate_index = cu_mined_70_18.loc[cu_mined_70_18['Country'].isin(['Democratic Republic of the Congo','Russia',\n",
    "                                                       'Germany','Republic of Serbia','Zimbabwe'])]\n",
    "duplicate_index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(90, 50)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_18 = cu_mined_70_18.drop([14, 21, 22, 54, 57, 66, 68, 69, 71, 77, 79, 80])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(78, 50)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_18 = cu_mined_70_18.append(subdf_concat, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(83, 50)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>...</th>\n",
       "      <th>yr2009</th>\n",
       "      <th>yr2010</th>\n",
       "      <th>yr2011</th>\n",
       "      <th>yr2012</th>\n",
       "      <th>yr2013</th>\n",
       "      <th>yr2014</th>\n",
       "      <th>yr2015</th>\n",
       "      <th>yr2016</th>\n",
       "      <th>yr2017</th>\n",
       "      <th>yr2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12937</td>\n",
       "      <td>10015</td>\n",
       "      <td>11777</td>\n",
       "      <td>11737</td>\n",
       "      <td>10379</td>\n",
       "      <td>9262</td>\n",
       "      <td>7324</td>\n",
       "      <td>9725</td>\n",
       "      <td>9618</td>\n",
       "      <td>8588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Eritrea</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21800</td>\n",
       "      <td>88900</td>\n",
       "      <td>61600</td>\n",
       "      <td>25300</td>\n",
       "      <td>7900</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Kyrgyzstan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>700</td>\n",
       "      <td>3100</td>\n",
       "      <td>8200</td>\n",
       "      <td>7500</td>\n",
       "      <td>7200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>22</td>\n",
       "      <td>28</td>\n",
       "      <td>31</td>\n",
       "      <td>40</td>\n",
       "      <td>46</td>\n",
       "      <td>58</td>\n",
       "      <td>39</td>\n",
       "      <td>32</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>600</td>\n",
       "      <td>100</td>\n",
       "      <td>1400</td>\n",
       "      <td>2500</td>\n",
       "      <td>6100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Democratic Republic of the Congo</td>\n",
       "      <td>385948</td>\n",
       "      <td>409770</td>\n",
       "      <td>443986</td>\n",
       "      <td>492223</td>\n",
       "      <td>501431</td>\n",
       "      <td>465846</td>\n",
       "      <td>444356</td>\n",
       "      <td>453731</td>\n",
       "      <td>473128</td>\n",
       "      <td>...</td>\n",
       "      <td>299300</td>\n",
       "      <td>378300</td>\n",
       "      <td>499198</td>\n",
       "      <td>619942</td>\n",
       "      <td>922016</td>\n",
       "      <td>1.03013e+06</td>\n",
       "      <td>1.03901e+06</td>\n",
       "      <td>1.02369e+06</td>\n",
       "      <td>1.09464e+06</td>\n",
       "      <td>1.22523e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Germany</td>\n",
       "      <td>19477</td>\n",
       "      <td>16484</td>\n",
       "      <td>21321</td>\n",
       "      <td>19436</td>\n",
       "      <td>19734</td>\n",
       "      <td>18461</td>\n",
       "      <td>17613</td>\n",
       "      <td>18210</td>\n",
       "      <td>15821</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Republic of Serbia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>19400</td>\n",
       "      <td>22800</td>\n",
       "      <td>26100</td>\n",
       "      <td>32200</td>\n",
       "      <td>36200</td>\n",
       "      <td>33739</td>\n",
       "      <td>29827</td>\n",
       "      <td>41300</td>\n",
       "      <td>44800</td>\n",
       "      <td>44100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>24000</td>\n",
       "      <td>23300</td>\n",
       "      <td>31800</td>\n",
       "      <td>35000</td>\n",
       "      <td>40000</td>\n",
       "      <td>47579</td>\n",
       "      <td>48186</td>\n",
       "      <td>34767</td>\n",
       "      <td>33848</td>\n",
       "      <td>...</td>\n",
       "      <td>3572</td>\n",
       "      <td>4629</td>\n",
       "      <td>6555</td>\n",
       "      <td>6665</td>\n",
       "      <td>8285</td>\n",
       "      <td>8261</td>\n",
       "      <td>8218</td>\n",
       "      <td>9101</td>\n",
       "      <td>8839</td>\n",
       "      <td>9077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Russia</td>\n",
       "      <td>925000</td>\n",
       "      <td>990000</td>\n",
       "      <td>1.03e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.13e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.14e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>675700</td>\n",
       "      <td>702700</td>\n",
       "      <td>587900</td>\n",
       "      <td>582900</td>\n",
       "      <td>655900</td>\n",
       "      <td>691500</td>\n",
       "      <td>711400</td>\n",
       "      <td>702300</td>\n",
       "      <td>762300</td>\n",
       "      <td>785300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Country  yr1970  yr1971    yr1972    yr1973  \\\n",
       "73                Dominican Republic       0       0         0         0   \n",
       "74                           Eritrea       0       0         0         0   \n",
       "75                        Kyrgyzstan       0       0         0         0   \n",
       "76                          Slovakia       0       0         0         0   \n",
       "77                        Tajikistan       0       0         0         0   \n",
       "78  Democratic Republic of the Congo  385948  409770    443986    492223   \n",
       "79                           Germany   19477   16484     21321     19436   \n",
       "80                Republic of Serbia       0       0         0         0   \n",
       "81                          Zimbabwe   24000   23300     31800     35000   \n",
       "82                            Russia  925000  990000  1.03e+06  1.06e+06   \n",
       "\n",
       "      yr1974   yr1975    yr1976   yr1977    yr1978  ...  yr2009  yr2010  \\\n",
       "73         0        0         0        0         0  ...   12937   10015   \n",
       "74         0        0         0        0         0  ...       0       0   \n",
       "75         0        0         0        0         0  ...       0       0   \n",
       "76         0        0         0        0         0  ...      14      22   \n",
       "77         0        0         0        0         0  ...       0       0   \n",
       "78    501431   465846    444356   453731    473128  ...  299300  378300   \n",
       "79     19734    18461     17613    18210     15821  ...       0       0   \n",
       "80         0        0         0        0         0  ...   19400   22800   \n",
       "81     40000    47579     48186    34767     33848  ...    3572    4629   \n",
       "82  1.06e+06  1.1e+06  1.13e+06  1.1e+06  1.14e+06  ...  675700  702700   \n",
       "\n",
       "    yr2011  yr2012  yr2013       yr2014       yr2015       yr2016  \\\n",
       "73   11777   11737   10379         9262         7324         9725   \n",
       "74       0       0   21800        88900        61600        25300   \n",
       "75       0       0       0          700         3100         8200   \n",
       "76      28      31      40           46           58           39   \n",
       "77       0       0     600          100         1400         2500   \n",
       "78  499198  619942  922016  1.03013e+06  1.03901e+06  1.02369e+06   \n",
       "79       0       0       0            0            0            0   \n",
       "80   26100   32200   36200        33739        29827        41300   \n",
       "81    6555    6665    8285         8261         8218         9101   \n",
       "82  587900  582900  655900       691500       711400       702300   \n",
       "\n",
       "         yr2017       yr2018  \n",
       "73         9618         8588  \n",
       "74         7900        17300  \n",
       "75         7500         7200  \n",
       "76           32           21  \n",
       "77         6100            0  \n",
       "78  1.09464e+06  1.22523e+06  \n",
       "79            0            0  \n",
       "80        44800        44100  \n",
       "81         8839         9077  \n",
       "82       762300       785300  \n",
       "\n",
       "[10 rows x 50 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Check that there are no duplicates names in the country column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.Country.value_counts()[0]==1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Check there are no NaN in the year columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "yr1970    True\n",
       "yr1971    True\n",
       "yr1972    True\n",
       "yr1973    True\n",
       "yr1974    True\n",
       "yr1975    True\n",
       "yr1976    True\n",
       "yr1977    True\n",
       "yr1978    True\n",
       "yr1979    True\n",
       "yr1980    True\n",
       "yr1981    True\n",
       "yr1982    True\n",
       "yr1983    True\n",
       "yr1984    True\n",
       "yr1985    True\n",
       "yr1986    True\n",
       "yr1987    True\n",
       "yr1988    True\n",
       "yr1989    True\n",
       "yr1990    True\n",
       "yr1991    True\n",
       "yr1992    True\n",
       "yr1993    True\n",
       "yr1994    True\n",
       "yr1995    True\n",
       "yr1996    True\n",
       "yr1997    True\n",
       "yr1998    True\n",
       "yr1999    True\n",
       "yr2000    True\n",
       "yr2001    True\n",
       "yr2002    True\n",
       "yr2003    True\n",
       "yr2004    True\n",
       "yr2005    True\n",
       "yr2006    True\n",
       "yr2007    True\n",
       "yr2008    True\n",
       "yr2009    True\n",
       "yr2010    True\n",
       "yr2011    True\n",
       "yr2012    True\n",
       "yr2013    True\n",
       "yr2014    True\n",
       "yr2015    True\n",
       "yr2016    True\n",
       "dtype: bool"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.iloc[:,1:48].notnull().all()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18.iloc[:,1:48].notnull().all().all()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4) Save the merged clean file to csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "cu_mined_70_18.to_csv('clean_cu_mined_70_18.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>yr1970</th>\n",
       "      <th>yr1971</th>\n",
       "      <th>yr1972</th>\n",
       "      <th>yr1973</th>\n",
       "      <th>yr1974</th>\n",
       "      <th>yr1975</th>\n",
       "      <th>yr1976</th>\n",
       "      <th>yr1977</th>\n",
       "      <th>yr1978</th>\n",
       "      <th>...</th>\n",
       "      <th>yr2009</th>\n",
       "      <th>yr2010</th>\n",
       "      <th>yr2011</th>\n",
       "      <th>yr2012</th>\n",
       "      <th>yr2013</th>\n",
       "      <th>yr2014</th>\n",
       "      <th>yr2015</th>\n",
       "      <th>yr2016</th>\n",
       "      <th>yr2017</th>\n",
       "      <th>yr2018</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Albania</td>\n",
       "      <td>6000</td>\n",
       "      <td>6500</td>\n",
       "      <td>6700</td>\n",
       "      <td>7000</td>\n",
       "      <td>7000</td>\n",
       "      <td>9000</td>\n",
       "      <td>10000</td>\n",
       "      <td>10000</td>\n",
       "      <td>11500</td>\n",
       "      <td>...</td>\n",
       "      <td>2600</td>\n",
       "      <td>2672</td>\n",
       "      <td>4379</td>\n",
       "      <td>5691</td>\n",
       "      <td>5087</td>\n",
       "      <td>3503</td>\n",
       "      <td>2106</td>\n",
       "      <td>218</td>\n",
       "      <td>0</td>\n",
       "      <td>2601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>574</td>\n",
       "      <td>514</td>\n",
       "      <td>428</td>\n",
       "      <td>353</td>\n",
       "      <td>350</td>\n",
       "      <td>378</td>\n",
       "      <td>400</td>\n",
       "      <td>400</td>\n",
       "      <td>200</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>461</td>\n",
       "      <td>497</td>\n",
       "      <td>1125</td>\n",
       "      <td>284</td>\n",
       "      <td>315</td>\n",
       "      <td>380</td>\n",
       "      <td>265</td>\n",
       "      <td>169</td>\n",
       "      <td>319</td>\n",
       "      <td>...</td>\n",
       "      <td>143084</td>\n",
       "      <td>140300</td>\n",
       "      <td>116700</td>\n",
       "      <td>135700</td>\n",
       "      <td>109600</td>\n",
       "      <td>102600</td>\n",
       "      <td>61800</td>\n",
       "      <td>81900</td>\n",
       "      <td>33300</td>\n",
       "      <td>17400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Australia</td>\n",
       "      <td>157790</td>\n",
       "      <td>177261</td>\n",
       "      <td>185843</td>\n",
       "      <td>220335</td>\n",
       "      <td>251340</td>\n",
       "      <td>218961</td>\n",
       "      <td>218480</td>\n",
       "      <td>221579</td>\n",
       "      <td>222111</td>\n",
       "      <td>...</td>\n",
       "      <td>855892</td>\n",
       "      <td>871963</td>\n",
       "      <td>960649</td>\n",
       "      <td>921390</td>\n",
       "      <td>1.001e+06</td>\n",
       "      <td>978534</td>\n",
       "      <td>995881</td>\n",
       "      <td>947555</td>\n",
       "      <td>849121</td>\n",
       "      <td>913336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Austria</td>\n",
       "      <td>2262</td>\n",
       "      <td>2575</td>\n",
       "      <td>2231</td>\n",
       "      <td>2713</td>\n",
       "      <td>2612</td>\n",
       "      <td>1923</td>\n",
       "      <td>1138</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bolivia</td>\n",
       "      <td>8700</td>\n",
       "      <td>7809</td>\n",
       "      <td>8400</td>\n",
       "      <td>7971</td>\n",
       "      <td>7433</td>\n",
       "      <td>5882</td>\n",
       "      <td>4680</td>\n",
       "      <td>3670</td>\n",
       "      <td>3267</td>\n",
       "      <td>...</td>\n",
       "      <td>620</td>\n",
       "      <td>2100</td>\n",
       "      <td>4176</td>\n",
       "      <td>8700</td>\n",
       "      <td>7549</td>\n",
       "      <td>10746</td>\n",
       "      <td>9479</td>\n",
       "      <td>8718</td>\n",
       "      <td>7219</td>\n",
       "      <td>5200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Botswana</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>600</td>\n",
       "      <td>2755</td>\n",
       "      <td>6504</td>\n",
       "      <td>12473</td>\n",
       "      <td>11788</td>\n",
       "      <td>14615</td>\n",
       "      <td>...</td>\n",
       "      <td>24382</td>\n",
       "      <td>48026</td>\n",
       "      <td>31929</td>\n",
       "      <td>35768</td>\n",
       "      <td>48500</td>\n",
       "      <td>38000</td>\n",
       "      <td>9162</td>\n",
       "      <td>12415</td>\n",
       "      <td>1239</td>\n",
       "      <td>1462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Brazil</td>\n",
       "      <td>3920</td>\n",
       "      <td>5418</td>\n",
       "      <td>4455</td>\n",
       "      <td>3412</td>\n",
       "      <td>3075</td>\n",
       "      <td>1922</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>211692</td>\n",
       "      <td>213548</td>\n",
       "      <td>213760</td>\n",
       "      <td>223141</td>\n",
       "      <td>270979</td>\n",
       "      <td>301197</td>\n",
       "      <td>359463</td>\n",
       "      <td>337600</td>\n",
       "      <td>384542</td>\n",
       "      <td>381000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>42000</td>\n",
       "      <td>44400</td>\n",
       "      <td>46300</td>\n",
       "      <td>48000</td>\n",
       "      <td>51600</td>\n",
       "      <td>55000</td>\n",
       "      <td>57000</td>\n",
       "      <td>57000</td>\n",
       "      <td>57000</td>\n",
       "      <td>...</td>\n",
       "      <td>110652</td>\n",
       "      <td>112904</td>\n",
       "      <td>114603</td>\n",
       "      <td>118255</td>\n",
       "      <td>115149</td>\n",
       "      <td>108323</td>\n",
       "      <td>111746</td>\n",
       "      <td>109702</td>\n",
       "      <td>109078</td>\n",
       "      <td>109400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Myanmar</td>\n",
       "      <td>70</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>75</td>\n",
       "      <td>70</td>\n",
       "      <td>86</td>\n",
       "      <td>92</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>9800</td>\n",
       "      <td>10000</td>\n",
       "      <td>12000</td>\n",
       "      <td>25000</td>\n",
       "      <td>33000</td>\n",
       "      <td>42000</td>\n",
       "      <td>71000</td>\n",
       "      <td>95000</td>\n",
       "      <td>116000</td>\n",
       "      <td>154000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Canada</td>\n",
       "      <td>610281</td>\n",
       "      <td>654470</td>\n",
       "      <td>719672</td>\n",
       "      <td>823942</td>\n",
       "      <td>821381</td>\n",
       "      <td>733826</td>\n",
       "      <td>730930</td>\n",
       "      <td>759423</td>\n",
       "      <td>659380</td>\n",
       "      <td>...</td>\n",
       "      <td>484605</td>\n",
       "      <td>522172</td>\n",
       "      <td>566779</td>\n",
       "      <td>580082</td>\n",
       "      <td>652595</td>\n",
       "      <td>672729</td>\n",
       "      <td>714647</td>\n",
       "      <td>693059</td>\n",
       "      <td>597194</td>\n",
       "      <td>539473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Chile</td>\n",
       "      <td>685600</td>\n",
       "      <td>708300</td>\n",
       "      <td>716900</td>\n",
       "      <td>735400</td>\n",
       "      <td>899700</td>\n",
       "      <td>828300</td>\n",
       "      <td>1.0052e+06</td>\n",
       "      <td>1.0562e+06</td>\n",
       "      <td>1.0342e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>5.3944e+06</td>\n",
       "      <td>5.4189e+06</td>\n",
       "      <td>5.2628e+06</td>\n",
       "      <td>5.4339e+06</td>\n",
       "      <td>5.776e+06</td>\n",
       "      <td>5.7611e+06</td>\n",
       "      <td>5.7721e+06</td>\n",
       "      <td>5.5526e+06</td>\n",
       "      <td>5.5035e+06</td>\n",
       "      <td>5.8316e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>China</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>115000</td>\n",
       "      <td>120000</td>\n",
       "      <td>130000</td>\n",
       "      <td>140000</td>\n",
       "      <td>150000</td>\n",
       "      <td>155000</td>\n",
       "      <td>160000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.062e+06</td>\n",
       "      <td>1.1558e+06</td>\n",
       "      <td>1.2947e+06</td>\n",
       "      <td>1.5768e+06</td>\n",
       "      <td>1.71515e+06</td>\n",
       "      <td>1.77679e+06</td>\n",
       "      <td>1.71206e+06</td>\n",
       "      <td>1.90019e+06</td>\n",
       "      <td>1.7064e+06</td>\n",
       "      <td>1.591e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>260</td>\n",
       "      <td>78</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>1140</td>\n",
       "      <td>711</td>\n",
       "      <td>808</td>\n",
       "      <td>781</td>\n",
       "      <td>659</td>\n",
       "      <td>4118</td>\n",
       "      <td>5463</td>\n",
       "      <td>8493</td>\n",
       "      <td>9355</td>\n",
       "      <td>10371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Cuba</td>\n",
       "      <td>400</td>\n",
       "      <td>0</td>\n",
       "      <td>1827</td>\n",
       "      <td>2107</td>\n",
       "      <td>2901</td>\n",
       "      <td>2777</td>\n",
       "      <td>2898</td>\n",
       "      <td>2583</td>\n",
       "      <td>2821</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Cyprus</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16767</td>\n",
       "      <td>14217</td>\n",
       "      <td>12828</td>\n",
       "      <td>9866</td>\n",
       "      <td>7900</td>\n",
       "      <td>6800</td>\n",
       "      <td>4678</td>\n",
       "      <td>...</td>\n",
       "      <td>2380</td>\n",
       "      <td>2595</td>\n",
       "      <td>3660</td>\n",
       "      <td>4328</td>\n",
       "      <td>3631</td>\n",
       "      <td>3088</td>\n",
       "      <td>2121</td>\n",
       "      <td>1754</td>\n",
       "      <td>1293</td>\n",
       "      <td>908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Czechia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10900</td>\n",
       "      <td>10700</td>\n",
       "      <td>8500</td>\n",
       "      <td>7800</td>\n",
       "      <td>8200</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>510</td>\n",
       "      <td>565</td>\n",
       "      <td>438</td>\n",
       "      <td>304</td>\n",
       "      <td>179</td>\n",
       "      <td>239</td>\n",
       "      <td>267</td>\n",
       "      <td>765</td>\n",
       "      <td>508</td>\n",
       "      <td>...</td>\n",
       "      <td>300</td>\n",
       "      <td>700</td>\n",
       "      <td>1400</td>\n",
       "      <td>1800</td>\n",
       "      <td>4700</td>\n",
       "      <td>3000</td>\n",
       "      <td>1800</td>\n",
       "      <td>1000</td>\n",
       "      <td>8200</td>\n",
       "      <td>8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Finland</td>\n",
       "      <td>30900</td>\n",
       "      <td>28500</td>\n",
       "      <td>34800</td>\n",
       "      <td>38213</td>\n",
       "      <td>36667</td>\n",
       "      <td>38000</td>\n",
       "      <td>41700</td>\n",
       "      <td>52113</td>\n",
       "      <td>52089</td>\n",
       "      <td>...</td>\n",
       "      <td>14600</td>\n",
       "      <td>14700</td>\n",
       "      <td>14000</td>\n",
       "      <td>25446</td>\n",
       "      <td>38763</td>\n",
       "      <td>42790</td>\n",
       "      <td>41085</td>\n",
       "      <td>47488</td>\n",
       "      <td>53144</td>\n",
       "      <td>46755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>France</td>\n",
       "      <td>250</td>\n",
       "      <td>248</td>\n",
       "      <td>472</td>\n",
       "      <td>414</td>\n",
       "      <td>392</td>\n",
       "      <td>183</td>\n",
       "      <td>188</td>\n",
       "      <td>128</td>\n",
       "      <td>200</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Greece</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1500</td>\n",
       "      <td>2500</td>\n",
       "      <td>2600</td>\n",
       "      <td>3500</td>\n",
       "      <td>1500</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Guatemala</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1600</td>\n",
       "      <td>3300</td>\n",
       "      <td>3500</td>\n",
       "      <td>2500</td>\n",
       "      <td>2023</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Haiti</td>\n",
       "      <td>4848</td>\n",
       "      <td>6500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Honduras</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>200</td>\n",
       "      <td>364</td>\n",
       "      <td>535</td>\n",
       "      <td>427</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>400</td>\n",
       "      <td>262</td>\n",
       "      <td>304</td>\n",
       "      <td>203</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>India</td>\n",
       "      <td>9700</td>\n",
       "      <td>11096</td>\n",
       "      <td>15669</td>\n",
       "      <td>15785</td>\n",
       "      <td>20457</td>\n",
       "      <td>25155</td>\n",
       "      <td>25400</td>\n",
       "      <td>29011</td>\n",
       "      <td>26640</td>\n",
       "      <td>...</td>\n",
       "      <td>28491</td>\n",
       "      <td>31778</td>\n",
       "      <td>31375</td>\n",
       "      <td>29281</td>\n",
       "      <td>32194</td>\n",
       "      <td>24889</td>\n",
       "      <td>32493</td>\n",
       "      <td>31999</td>\n",
       "      <td>33678</td>\n",
       "      <td>37000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5000</td>\n",
       "      <td>37900</td>\n",
       "      <td>64600</td>\n",
       "      <td>63500</td>\n",
       "      <td>69100</td>\n",
       "      <td>57100</td>\n",
       "      <td>58000</td>\n",
       "      <td>...</td>\n",
       "      <td>995500</td>\n",
       "      <td>863900</td>\n",
       "      <td>538300</td>\n",
       "      <td>398100</td>\n",
       "      <td>509300</td>\n",
       "      <td>378500</td>\n",
       "      <td>578600</td>\n",
       "      <td>728000</td>\n",
       "      <td>622030</td>\n",
       "      <td>651136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Iran</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4000</td>\n",
       "      <td>4000</td>\n",
       "      <td>6000</td>\n",
       "      <td>6000</td>\n",
       "      <td>6000</td>\n",
       "      <td>...</td>\n",
       "      <td>262500</td>\n",
       "      <td>256700</td>\n",
       "      <td>258900</td>\n",
       "      <td>245500</td>\n",
       "      <td>222900</td>\n",
       "      <td>216800</td>\n",
       "      <td>246400</td>\n",
       "      <td>289300</td>\n",
       "      <td>295621</td>\n",
       "      <td>316500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>8281</td>\n",
       "      <td>11800</td>\n",
       "      <td>13656</td>\n",
       "      <td>13046</td>\n",
       "      <td>12700</td>\n",
       "      <td>9839</td>\n",
       "      <td>4097</td>\n",
       "      <td>4829</td>\n",
       "      <td>4700</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Israel</td>\n",
       "      <td>10988</td>\n",
       "      <td>10700</td>\n",
       "      <td>11175</td>\n",
       "      <td>10165</td>\n",
       "      <td>9488</td>\n",
       "      <td>8035</td>\n",
       "      <td>2100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Italy</td>\n",
       "      <td>2300</td>\n",
       "      <td>1540</td>\n",
       "      <td>1049</td>\n",
       "      <td>858</td>\n",
       "      <td>900</td>\n",
       "      <td>800</td>\n",
       "      <td>1000</td>\n",
       "      <td>700</td>\n",
       "      <td>531</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Japan</td>\n",
       "      <td>119513</td>\n",
       "      <td>120551</td>\n",
       "      <td>112114</td>\n",
       "      <td>91280</td>\n",
       "      <td>82135</td>\n",
       "      <td>84639</td>\n",
       "      <td>81606</td>\n",
       "      <td>81395</td>\n",
       "      <td>71951</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Kenya</td>\n",
       "      <td>79</td>\n",
       "      <td>73</td>\n",
       "      <td>72</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>1639</td>\n",
       "      <td>1773</td>\n",
       "      <td>2082</td>\n",
       "      <td>2321</td>\n",
       "      <td>3235</td>\n",
       "      <td>2330</td>\n",
       "      <td>2097</td>\n",
       "      <td>1688</td>\n",
       "      <td>715</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>North Korea</td>\n",
       "      <td>13000</td>\n",
       "      <td>13000</td>\n",
       "      <td>13000</td>\n",
       "      <td>13000</td>\n",
       "      <td>14000</td>\n",
       "      <td>15000</td>\n",
       "      <td>15000</td>\n",
       "      <td>15000</td>\n",
       "      <td>15000</td>\n",
       "      <td>...</td>\n",
       "      <td>3700</td>\n",
       "      <td>4600</td>\n",
       "      <td>7000</td>\n",
       "      <td>17000</td>\n",
       "      <td>15000</td>\n",
       "      <td>7700</td>\n",
       "      <td>8600</td>\n",
       "      <td>12600</td>\n",
       "      <td>1800</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Malaysia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3800</td>\n",
       "      <td>18200</td>\n",
       "      <td>24000</td>\n",
       "      <td>26000</td>\n",
       "      <td>...</td>\n",
       "      <td>240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Mauritania</td>\n",
       "      <td>1950</td>\n",
       "      <td>4740</td>\n",
       "      <td>15051</td>\n",
       "      <td>21277</td>\n",
       "      <td>20079</td>\n",
       "      <td>6582</td>\n",
       "      <td>10000</td>\n",
       "      <td>7640</td>\n",
       "      <td>1773</td>\n",
       "      <td>...</td>\n",
       "      <td>36608</td>\n",
       "      <td>36969</td>\n",
       "      <td>35281</td>\n",
       "      <td>37670</td>\n",
       "      <td>37970</td>\n",
       "      <td>33079</td>\n",
       "      <td>45001</td>\n",
       "      <td>32820</td>\n",
       "      <td>28791</td>\n",
       "      <td>28138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Mexico</td>\n",
       "      <td>61012</td>\n",
       "      <td>63150</td>\n",
       "      <td>78720</td>\n",
       "      <td>80501</td>\n",
       "      <td>82670</td>\n",
       "      <td>78196</td>\n",
       "      <td>88970</td>\n",
       "      <td>89662</td>\n",
       "      <td>87186</td>\n",
       "      <td>...</td>\n",
       "      <td>240648</td>\n",
       "      <td>270136</td>\n",
       "      <td>443621</td>\n",
       "      <td>500275</td>\n",
       "      <td>480124</td>\n",
       "      <td>515025</td>\n",
       "      <td>594451</td>\n",
       "      <td>766129</td>\n",
       "      <td>742246</td>\n",
       "      <td>696580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Mongolia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4000</td>\n",
       "      <td>...</td>\n",
       "      <td>132300</td>\n",
       "      <td>127600</td>\n",
       "      <td>124000</td>\n",
       "      <td>123900</td>\n",
       "      <td>189000</td>\n",
       "      <td>253000</td>\n",
       "      <td>318000</td>\n",
       "      <td>516000</td>\n",
       "      <td>475000</td>\n",
       "      <td>458780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Morocco</td>\n",
       "      <td>3172</td>\n",
       "      <td>2595</td>\n",
       "      <td>3831</td>\n",
       "      <td>4149</td>\n",
       "      <td>4670</td>\n",
       "      <td>4600</td>\n",
       "      <td>4400</td>\n",
       "      <td>3370</td>\n",
       "      <td>4300</td>\n",
       "      <td>...</td>\n",
       "      <td>11830</td>\n",
       "      <td>14986</td>\n",
       "      <td>12076</td>\n",
       "      <td>14750</td>\n",
       "      <td>11575</td>\n",
       "      <td>16579</td>\n",
       "      <td>19903</td>\n",
       "      <td>23586</td>\n",
       "      <td>24603</td>\n",
       "      <td>23859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Mozambique</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2000</td>\n",
       "      <td>3000</td>\n",
       "      <td>300</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Namibia</td>\n",
       "      <td>23000</td>\n",
       "      <td>25900</td>\n",
       "      <td>21500</td>\n",
       "      <td>28300</td>\n",
       "      <td>33200</td>\n",
       "      <td>34900</td>\n",
       "      <td>43500</td>\n",
       "      <td>49200</td>\n",
       "      <td>37700</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3366</td>\n",
       "      <td>5304</td>\n",
       "      <td>4896</td>\n",
       "      <td>5249</td>\n",
       "      <td>14010</td>\n",
       "      <td>16653</td>\n",
       "      <td>15534</td>\n",
       "      <td>15177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>New Zealand</td>\n",
       "      <td>47</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Nicaragua</td>\n",
       "      <td>3029</td>\n",
       "      <td>3662</td>\n",
       "      <td>2188</td>\n",
       "      <td>1545</td>\n",
       "      <td>1775</td>\n",
       "      <td>600</td>\n",
       "      <td>800</td>\n",
       "      <td>300</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Norway</td>\n",
       "      <td>19947</td>\n",
       "      <td>21672</td>\n",
       "      <td>26007</td>\n",
       "      <td>29947</td>\n",
       "      <td>24120</td>\n",
       "      <td>26647</td>\n",
       "      <td>31080</td>\n",
       "      <td>29053</td>\n",
       "      <td>29073</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Oman</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>15563</td>\n",
       "      <td>16530</td>\n",
       "      <td>21166</td>\n",
       "      <td>19684</td>\n",
       "      <td>10906</td>\n",
       "      <td>13699</td>\n",
       "      <td>7828</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>124000</td>\n",
       "      <td>182900</td>\n",
       "      <td>184100</td>\n",
       "      <td>172477</td>\n",
       "      <td>176519</td>\n",
       "      <td>182291</td>\n",
       "      <td>198603</td>\n",
       "      <td>...</td>\n",
       "      <td>166669</td>\n",
       "      <td>159821</td>\n",
       "      <td>130456</td>\n",
       "      <td>125326</td>\n",
       "      <td>105523</td>\n",
       "      <td>75901</td>\n",
       "      <td>45185</td>\n",
       "      <td>80022</td>\n",
       "      <td>105419</td>\n",
       "      <td>96287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Peru</td>\n",
       "      <td>220225</td>\n",
       "      <td>207346</td>\n",
       "      <td>219126</td>\n",
       "      <td>202686</td>\n",
       "      <td>211593</td>\n",
       "      <td>165813</td>\n",
       "      <td>220269</td>\n",
       "      <td>338110</td>\n",
       "      <td>366753</td>\n",
       "      <td>...</td>\n",
       "      <td>1.27625e+06</td>\n",
       "      <td>1.24718e+06</td>\n",
       "      <td>1.23534e+06</td>\n",
       "      <td>1.29876e+06</td>\n",
       "      <td>1.37564e+06</td>\n",
       "      <td>1.37764e+06</td>\n",
       "      <td>1.70082e+06</td>\n",
       "      <td>2.35386e+06</td>\n",
       "      <td>2.44558e+06</td>\n",
       "      <td>2.43695e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Philippines</td>\n",
       "      <td>160292</td>\n",
       "      <td>197573</td>\n",
       "      <td>213695</td>\n",
       "      <td>221195</td>\n",
       "      <td>225485</td>\n",
       "      <td>225775</td>\n",
       "      <td>237588</td>\n",
       "      <td>272792</td>\n",
       "      <td>263589</td>\n",
       "      <td>...</td>\n",
       "      <td>49060</td>\n",
       "      <td>58412</td>\n",
       "      <td>63835</td>\n",
       "      <td>65444</td>\n",
       "      <td>90861</td>\n",
       "      <td>91824</td>\n",
       "      <td>83835</td>\n",
       "      <td>83649</td>\n",
       "      <td>68156</td>\n",
       "      <td>69933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Poland</td>\n",
       "      <td>83000</td>\n",
       "      <td>122300</td>\n",
       "      <td>135000</td>\n",
       "      <td>152000</td>\n",
       "      <td>185000</td>\n",
       "      <td>230000</td>\n",
       "      <td>263000</td>\n",
       "      <td>282000</td>\n",
       "      <td>312000</td>\n",
       "      <td>...</td>\n",
       "      <td>439365</td>\n",
       "      <td>425725</td>\n",
       "      <td>426665</td>\n",
       "      <td>427064</td>\n",
       "      <td>428879</td>\n",
       "      <td>421285</td>\n",
       "      <td>426196</td>\n",
       "      <td>424000</td>\n",
       "      <td>419000</td>\n",
       "      <td>401300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>3762</td>\n",
       "      <td>3957</td>\n",
       "      <td>543</td>\n",
       "      <td>651</td>\n",
       "      <td>568</td>\n",
       "      <td>447</td>\n",
       "      <td>387</td>\n",
       "      <td>3208</td>\n",
       "      <td>2962</td>\n",
       "      <td>...</td>\n",
       "      <td>86462</td>\n",
       "      <td>74426</td>\n",
       "      <td>79686</td>\n",
       "      <td>74043</td>\n",
       "      <td>77236</td>\n",
       "      <td>75433</td>\n",
       "      <td>83081</td>\n",
       "      <td>74453</td>\n",
       "      <td>63812</td>\n",
       "      <td>49064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Romania</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30000</td>\n",
       "      <td>40000</td>\n",
       "      <td>40000</td>\n",
       "      <td>44000</td>\n",
       "      <td>30000</td>\n",
       "      <td>27000</td>\n",
       "      <td>27000</td>\n",
       "      <td>...</td>\n",
       "      <td>3129</td>\n",
       "      <td>5127</td>\n",
       "      <td>6355</td>\n",
       "      <td>5902</td>\n",
       "      <td>6800</td>\n",
       "      <td>7200</td>\n",
       "      <td>3600</td>\n",
       "      <td>7300</td>\n",
       "      <td>7400</td>\n",
       "      <td>8100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>144200</td>\n",
       "      <td>148400</td>\n",
       "      <td>161927</td>\n",
       "      <td>175797</td>\n",
       "      <td>179111</td>\n",
       "      <td>178927</td>\n",
       "      <td>196880</td>\n",
       "      <td>205414</td>\n",
       "      <td>205745</td>\n",
       "      <td>...</td>\n",
       "      <td>107600</td>\n",
       "      <td>102600</td>\n",
       "      <td>96600</td>\n",
       "      <td>88800</td>\n",
       "      <td>80821</td>\n",
       "      <td>78697</td>\n",
       "      <td>77360</td>\n",
       "      <td>65257</td>\n",
       "      <td>65503</td>\n",
       "      <td>46900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Spain</td>\n",
       "      <td>9522</td>\n",
       "      <td>34032</td>\n",
       "      <td>39900</td>\n",
       "      <td>51588</td>\n",
       "      <td>46753</td>\n",
       "      <td>30020</td>\n",
       "      <td>34867</td>\n",
       "      <td>43462</td>\n",
       "      <td>40448</td>\n",
       "      <td>...</td>\n",
       "      <td>17663</td>\n",
       "      <td>54335</td>\n",
       "      <td>68511</td>\n",
       "      <td>99894</td>\n",
       "      <td>104600</td>\n",
       "      <td>103900</td>\n",
       "      <td>112690</td>\n",
       "      <td>167736</td>\n",
       "      <td>198353</td>\n",
       "      <td>185237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>26283</td>\n",
       "      <td>30200</td>\n",
       "      <td>30619</td>\n",
       "      <td>44819</td>\n",
       "      <td>40637</td>\n",
       "      <td>40634</td>\n",
       "      <td>44860</td>\n",
       "      <td>44764</td>\n",
       "      <td>47412</td>\n",
       "      <td>...</td>\n",
       "      <td>55414</td>\n",
       "      <td>76514</td>\n",
       "      <td>82967</td>\n",
       "      <td>82422</td>\n",
       "      <td>82904</td>\n",
       "      <td>79345</td>\n",
       "      <td>75125</td>\n",
       "      <td>78992</td>\n",
       "      <td>104450</td>\n",
       "      <td>106142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Taiwan</td>\n",
       "      <td>2500</td>\n",
       "      <td>2400</td>\n",
       "      <td>1996</td>\n",
       "      <td>2400</td>\n",
       "      <td>2500</td>\n",
       "      <td>1900</td>\n",
       "      <td>2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>800</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Turkey</td>\n",
       "      <td>31100</td>\n",
       "      <td>30000</td>\n",
       "      <td>22100</td>\n",
       "      <td>30200</td>\n",
       "      <td>30000</td>\n",
       "      <td>27300</td>\n",
       "      <td>29323</td>\n",
       "      <td>34979</td>\n",
       "      <td>27188</td>\n",
       "      <td>...</td>\n",
       "      <td>72400</td>\n",
       "      <td>79900</td>\n",
       "      <td>92500</td>\n",
       "      <td>104300</td>\n",
       "      <td>120500</td>\n",
       "      <td>122000</td>\n",
       "      <td>108000</td>\n",
       "      <td>100000</td>\n",
       "      <td>83000</td>\n",
       "      <td>79600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>United States of America</td>\n",
       "      <td>1.56004e+06</td>\n",
       "      <td>1.38089e+06</td>\n",
       "      <td>1.51032e+06</td>\n",
       "      <td>1.55849e+06</td>\n",
       "      <td>1.44878e+06</td>\n",
       "      <td>1.28218e+06</td>\n",
       "      <td>1.45656e+06</td>\n",
       "      <td>1.36438e+06</td>\n",
       "      <td>1.35759e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.18e+06</td>\n",
       "      <td>1.11e+06</td>\n",
       "      <td>1.1129e+06</td>\n",
       "      <td>1.1668e+06</td>\n",
       "      <td>1.2782e+06</td>\n",
       "      <td>1.3847e+06</td>\n",
       "      <td>1.4163e+06</td>\n",
       "      <td>1.4619e+06</td>\n",
       "      <td>1.29e+06</td>\n",
       "      <td>1.25e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Uganda</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14200</td>\n",
       "      <td>11500</td>\n",
       "      <td>8500</td>\n",
       "      <td>7000</td>\n",
       "      <td>4000</td>\n",
       "      <td>7200</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>238</td>\n",
       "      <td>459</td>\n",
       "      <td>434</td>\n",
       "      <td>652</td>\n",
       "      <td>552</td>\n",
       "      <td>453</td>\n",
       "      <td>135</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td>90808</td>\n",
       "      <td>94392</td>\n",
       "      <td>103133</td>\n",
       "      <td>111797</td>\n",
       "      <td>112080</td>\n",
       "      <td>114894</td>\n",
       "      <td>120130</td>\n",
       "      <td>116218</td>\n",
       "      <td>123319</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>684100</td>\n",
       "      <td>651400</td>\n",
       "      <td>717700</td>\n",
       "      <td>706574</td>\n",
       "      <td>697956</td>\n",
       "      <td>647163</td>\n",
       "      <td>711681</td>\n",
       "      <td>658788</td>\n",
       "      <td>654012</td>\n",
       "      <td>...</td>\n",
       "      <td>601200</td>\n",
       "      <td>767008</td>\n",
       "      <td>663400</td>\n",
       "      <td>695200</td>\n",
       "      <td>759800</td>\n",
       "      <td>708259</td>\n",
       "      <td>710860</td>\n",
       "      <td>725359</td>\n",
       "      <td>797266</td>\n",
       "      <td>851089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Armenia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>23233</td>\n",
       "      <td>31062</td>\n",
       "      <td>33597</td>\n",
       "      <td>40908</td>\n",
       "      <td>48891</td>\n",
       "      <td>50952</td>\n",
       "      <td>83634</td>\n",
       "      <td>102962</td>\n",
       "      <td>113560</td>\n",
       "      <td>84100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Georgia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>16600</td>\n",
       "      <td>10600</td>\n",
       "      <td>10000</td>\n",
       "      <td>6800</td>\n",
       "      <td>10000</td>\n",
       "      <td>6800</td>\n",
       "      <td>13000</td>\n",
       "      <td>14000</td>\n",
       "      <td>15000</td>\n",
       "      <td>13000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Kazakhstan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>406100</td>\n",
       "      <td>380600</td>\n",
       "      <td>405300</td>\n",
       "      <td>426800</td>\n",
       "      <td>454400</td>\n",
       "      <td>471700</td>\n",
       "      <td>473600</td>\n",
       "      <td>474800</td>\n",
       "      <td>557800</td>\n",
       "      <td>635500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Laos</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>121581</td>\n",
       "      <td>132047</td>\n",
       "      <td>138756</td>\n",
       "      <td>149580</td>\n",
       "      <td>154915</td>\n",
       "      <td>159696</td>\n",
       "      <td>167702</td>\n",
       "      <td>177939</td>\n",
       "      <td>153304</td>\n",
       "      <td>147019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Macedonia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7440</td>\n",
       "      <td>7912</td>\n",
       "      <td>7555</td>\n",
       "      <td>10600</td>\n",
       "      <td>11700</td>\n",
       "      <td>9600</td>\n",
       "      <td>11400</td>\n",
       "      <td>10200</td>\n",
       "      <td>9000</td>\n",
       "      <td>8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>19600</td>\n",
       "      <td>19900</td>\n",
       "      <td>20000</td>\n",
       "      <td>23900</td>\n",
       "      <td>20700</td>\n",
       "      <td>18000</td>\n",
       "      <td>16000</td>\n",
       "      <td>14100</td>\n",
       "      <td>15000</td>\n",
       "      <td>16700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1719</td>\n",
       "      <td>1603</td>\n",
       "      <td>1954</td>\n",
       "      <td>4410</td>\n",
       "      <td>5095</td>\n",
       "      <td>10848</td>\n",
       "      <td>11563</td>\n",
       "      <td>27500</td>\n",
       "      <td>36279</td>\n",
       "      <td>67508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>United Republic of Tanzania</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3079</td>\n",
       "      <td>6400</td>\n",
       "      <td>6748</td>\n",
       "      <td>5840</td>\n",
       "      <td>5740</td>\n",
       "      <td>6363</td>\n",
       "      <td>6465</td>\n",
       "      <td>7150</td>\n",
       "      <td>1331</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>80000</td>\n",
       "      <td>80000</td>\n",
       "      <td>80000</td>\n",
       "      <td>95600</td>\n",
       "      <td>100000</td>\n",
       "      <td>100000</td>\n",
       "      <td>100000</td>\n",
       "      <td>100000</td>\n",
       "      <td>100000</td>\n",
       "      <td>100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Vietnam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12935</td>\n",
       "      <td>12260</td>\n",
       "      <td>11888</td>\n",
       "      <td>12716</td>\n",
       "      <td>12958</td>\n",
       "      <td>20296</td>\n",
       "      <td>22524</td>\n",
       "      <td>22636</td>\n",
       "      <td>21451</td>\n",
       "      <td>23378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>183</td>\n",
       "      <td>611</td>\n",
       "      <td>502</td>\n",
       "      <td>327</td>\n",
       "      <td>784</td>\n",
       "      <td>969</td>\n",
       "      <td>1941</td>\n",
       "      <td>1991</td>\n",
       "      <td>1645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Dominican Republic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12937</td>\n",
       "      <td>10015</td>\n",
       "      <td>11777</td>\n",
       "      <td>11737</td>\n",
       "      <td>10379</td>\n",
       "      <td>9262</td>\n",
       "      <td>7324</td>\n",
       "      <td>9725</td>\n",
       "      <td>9618</td>\n",
       "      <td>8588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Eritrea</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21800</td>\n",
       "      <td>88900</td>\n",
       "      <td>61600</td>\n",
       "      <td>25300</td>\n",
       "      <td>7900</td>\n",
       "      <td>17300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Kyrgyzstan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>700</td>\n",
       "      <td>3100</td>\n",
       "      <td>8200</td>\n",
       "      <td>7500</td>\n",
       "      <td>7200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>22</td>\n",
       "      <td>28</td>\n",
       "      <td>31</td>\n",
       "      <td>40</td>\n",
       "      <td>46</td>\n",
       "      <td>58</td>\n",
       "      <td>39</td>\n",
       "      <td>32</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Tajikistan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>600</td>\n",
       "      <td>100</td>\n",
       "      <td>1400</td>\n",
       "      <td>2500</td>\n",
       "      <td>6100</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Democratic Republic of the Congo</td>\n",
       "      <td>385948</td>\n",
       "      <td>409770</td>\n",
       "      <td>443986</td>\n",
       "      <td>492223</td>\n",
       "      <td>501431</td>\n",
       "      <td>465846</td>\n",
       "      <td>444356</td>\n",
       "      <td>453731</td>\n",
       "      <td>473128</td>\n",
       "      <td>...</td>\n",
       "      <td>299300</td>\n",
       "      <td>378300</td>\n",
       "      <td>499198</td>\n",
       "      <td>619942</td>\n",
       "      <td>922016</td>\n",
       "      <td>1.03013e+06</td>\n",
       "      <td>1.03901e+06</td>\n",
       "      <td>1.02369e+06</td>\n",
       "      <td>1.09464e+06</td>\n",
       "      <td>1.22523e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Germany</td>\n",
       "      <td>19477</td>\n",
       "      <td>16484</td>\n",
       "      <td>21321</td>\n",
       "      <td>19436</td>\n",
       "      <td>19734</td>\n",
       "      <td>18461</td>\n",
       "      <td>17613</td>\n",
       "      <td>18210</td>\n",
       "      <td>15821</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Republic of Serbia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>19400</td>\n",
       "      <td>22800</td>\n",
       "      <td>26100</td>\n",
       "      <td>32200</td>\n",
       "      <td>36200</td>\n",
       "      <td>33739</td>\n",
       "      <td>29827</td>\n",
       "      <td>41300</td>\n",
       "      <td>44800</td>\n",
       "      <td>44100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>24000</td>\n",
       "      <td>23300</td>\n",
       "      <td>31800</td>\n",
       "      <td>35000</td>\n",
       "      <td>40000</td>\n",
       "      <td>47579</td>\n",
       "      <td>48186</td>\n",
       "      <td>34767</td>\n",
       "      <td>33848</td>\n",
       "      <td>...</td>\n",
       "      <td>3572</td>\n",
       "      <td>4629</td>\n",
       "      <td>6555</td>\n",
       "      <td>6665</td>\n",
       "      <td>8285</td>\n",
       "      <td>8261</td>\n",
       "      <td>8218</td>\n",
       "      <td>9101</td>\n",
       "      <td>8839</td>\n",
       "      <td>9077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Russia</td>\n",
       "      <td>925000</td>\n",
       "      <td>990000</td>\n",
       "      <td>1.03e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.06e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.13e+06</td>\n",
       "      <td>1.1e+06</td>\n",
       "      <td>1.14e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>675700</td>\n",
       "      <td>702700</td>\n",
       "      <td>587900</td>\n",
       "      <td>582900</td>\n",
       "      <td>655900</td>\n",
       "      <td>691500</td>\n",
       "      <td>711400</td>\n",
       "      <td>702300</td>\n",
       "      <td>762300</td>\n",
       "      <td>785300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>83 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Country       yr1970       yr1971       yr1972  \\\n",
       "0                            Albania         6000         6500         6700   \n",
       "1                            Algeria          574          514          428   \n",
       "2                          Argentina          461          497         1125   \n",
       "3                          Australia       157790       177261       185843   \n",
       "4                            Austria         2262         2575         2231   \n",
       "5                            Bolivia         8700         7809         8400   \n",
       "6                           Botswana            0            0            0   \n",
       "7                             Brazil         3920         5418         4455   \n",
       "8                           Bulgaria        42000        44400        46300   \n",
       "9                            Myanmar           70           80           80   \n",
       "10                            Canada       610281       654470       719672   \n",
       "11                             Chile       685600       708300       716900   \n",
       "12                             China            0            0       115000   \n",
       "13                          Colombia            0            0            0   \n",
       "14                              Cuba          400            0         1827   \n",
       "15                            Cyprus            0            0        16767   \n",
       "16                           Czechia            0            0            0   \n",
       "17                           Ecuador          510          565          438   \n",
       "18                           Finland        30900        28500        34800   \n",
       "19                            France          250          248          472   \n",
       "20                            Greece            0            0            0   \n",
       "21                         Guatemala            0            0            0   \n",
       "22                             Haiti         4848         6500            0   \n",
       "23                          Honduras            0            0            0   \n",
       "24                           Hungary            0            0            0   \n",
       "25                             India         9700        11096        15669   \n",
       "26                         Indonesia            0            0         5000   \n",
       "27                              Iran            0            0            0   \n",
       "28                           Ireland         8281        11800        13656   \n",
       "29                            Israel        10988        10700        11175   \n",
       "30                             Italy         2300         1540         1049   \n",
       "31                             Japan       119513       120551       112114   \n",
       "32                             Kenya           79           73           72   \n",
       "33                       South Korea         1639         1773         2082   \n",
       "34                       North Korea        13000        13000        13000   \n",
       "35                          Malaysia            0            0            0   \n",
       "36                        Mauritania         1950         4740        15051   \n",
       "37                            Mexico        61012        63150        78720   \n",
       "38                          Mongolia            0            0            0   \n",
       "39                           Morocco         3172         2595         3831   \n",
       "40                        Mozambique            0            0            0   \n",
       "41                           Namibia        23000        25900        21500   \n",
       "42                       New Zealand           47           85            0   \n",
       "43                         Nicaragua         3029         3662         2188   \n",
       "44                            Norway        19947        21672        26007   \n",
       "45                              Oman            0            0            0   \n",
       "46                  Papua New Guinea            0            0       124000   \n",
       "47                              Peru       220225       207346       219126   \n",
       "48                       Philippines       160292       197573       213695   \n",
       "49                            Poland        83000       122300       135000   \n",
       "50                          Portugal         3762         3957          543   \n",
       "51                           Romania            0            0        30000   \n",
       "52                      South Africa       144200       148400       161927   \n",
       "53                             Spain         9522        34032        39900   \n",
       "54                            Sweden        26283        30200        30619   \n",
       "55                            Taiwan         2500         2400         1996   \n",
       "56                            Turkey        31100        30000        22100   \n",
       "57          United States of America  1.56004e+06  1.38089e+06  1.51032e+06   \n",
       "58                            Uganda            0            0            0   \n",
       "59                    United Kingdom            0            0          238   \n",
       "60                        Yugoslavia        90808        94392       103133   \n",
       "61                            Zambia       684100       651400       717700   \n",
       "62                           Armenia            0            0            0   \n",
       "63                           Georgia            0            0            0   \n",
       "64                        Kazakhstan            0            0            0   \n",
       "65                              Laos            0            0            0   \n",
       "66                         Macedonia            0            0            0   \n",
       "67                          Pakistan            0            0            0   \n",
       "68                      Saudi Arabia            0            0            0   \n",
       "69       United Republic of Tanzania            0            0            0   \n",
       "70                        Uzbekistan            0            0            0   \n",
       "71                           Vietnam            0            0            0   \n",
       "72                        Azerbaijan            0            0            0   \n",
       "73                Dominican Republic            0            0            0   \n",
       "74                           Eritrea            0            0            0   \n",
       "75                        Kyrgyzstan            0            0            0   \n",
       "76                          Slovakia            0            0            0   \n",
       "77                        Tajikistan            0            0            0   \n",
       "78  Democratic Republic of the Congo       385948       409770       443986   \n",
       "79                           Germany        19477        16484        21321   \n",
       "80                Republic of Serbia            0            0            0   \n",
       "81                          Zimbabwe        24000        23300        31800   \n",
       "82                            Russia       925000       990000     1.03e+06   \n",
       "\n",
       "         yr1973       yr1974       yr1975       yr1976       yr1977  \\\n",
       "0          7000         7000         9000        10000        10000   \n",
       "1           353          350          378          400          400   \n",
       "2           284          315          380          265          169   \n",
       "3        220335       251340       218961       218480       221579   \n",
       "4          2713         2612         1923         1138            0   \n",
       "5          7971         7433         5882         4680         3670   \n",
       "6           600         2755         6504        12473        11788   \n",
       "7          3412         3075         1922           54            0   \n",
       "8         48000        51600        55000        57000        57000   \n",
       "9            75           70           86           92          100   \n",
       "10       823942       821381       733826       730930       759423   \n",
       "11       735400       899700       828300   1.0052e+06   1.0562e+06   \n",
       "12       120000       130000       140000       150000       155000   \n",
       "13            0            0            0          260           78   \n",
       "14         2107         2901         2777         2898         2583   \n",
       "15        14217        12828         9866         7900         6800   \n",
       "16            0        10900        10700         8500         7800   \n",
       "17          304          179          239          267          765   \n",
       "18        38213        36667        38000        41700        52113   \n",
       "19          414          392          183          188          128   \n",
       "20            0         1500         2500         2600         3500   \n",
       "21            0         1600         3300         3500         2500   \n",
       "22            0            0            0            0            0   \n",
       "23            0            0          200          364          535   \n",
       "24            0            0          400          262          304   \n",
       "25        15785        20457        25155        25400        29011   \n",
       "26        37900        64600        63500        69100        57100   \n",
       "27            0         4000         4000         6000         6000   \n",
       "28        13046        12700         9839         4097         4829   \n",
       "29        10165         9488         8035         2100            0   \n",
       "30          858          900          800         1000          700   \n",
       "31        91280        82135        84639        81606        81395   \n",
       "32           70           70           70            0            0   \n",
       "33         2321         3235         2330         2097         1688   \n",
       "34        13000        14000        15000        15000        15000   \n",
       "35            0            0         3800        18200        24000   \n",
       "36        21277        20079         6582        10000         7640   \n",
       "37        80501        82670        78196        88970        89662   \n",
       "38            0            0            0            0            0   \n",
       "39         4149         4670         4600         4400         3370   \n",
       "40            0            0            0         2000         3000   \n",
       "41        28300        33200        34900        43500        49200   \n",
       "42            0            0            0            0            0   \n",
       "43         1545         1775          600          800          300   \n",
       "44        29947        24120        26647        31080        29053   \n",
       "45            0            0            0            0            0   \n",
       "46       182900       184100       172477       176519       182291   \n",
       "47       202686       211593       165813       220269       338110   \n",
       "48       221195       225485       225775       237588       272792   \n",
       "49       152000       185000       230000       263000       282000   \n",
       "50          651          568          447          387         3208   \n",
       "51        40000        40000        44000        30000        27000   \n",
       "52       175797       179111       178927       196880       205414   \n",
       "53        51588        46753        30020        34867        43462   \n",
       "54        44819        40637        40634        44860        44764   \n",
       "55         2400         2500         1900         2000         2000   \n",
       "56        30200        30000        27300        29323        34979   \n",
       "57  1.55849e+06  1.44878e+06  1.28218e+06  1.45656e+06  1.36438e+06   \n",
       "58        14200        11500         8500         7000         4000   \n",
       "59          459          434          652          552          453   \n",
       "60       111797       112080       114894       120130       116218   \n",
       "61       706574       697956       647163       711681       658788   \n",
       "62            0            0            0            0            0   \n",
       "63            0            0            0            0            0   \n",
       "64            0            0            0            0            0   \n",
       "65            0            0            0            0            0   \n",
       "66            0            0            0            0            0   \n",
       "67            0            0            0            0            0   \n",
       "68            0            0            0            0            0   \n",
       "69            0            0            0            0            0   \n",
       "70            0            0            0            0            0   \n",
       "71            0            0            0            0            0   \n",
       "72            0            0            0            0            0   \n",
       "73            0            0            0            0            0   \n",
       "74            0            0            0            0            0   \n",
       "75            0            0            0            0            0   \n",
       "76            0            0            0            0            0   \n",
       "77            0            0            0            0            0   \n",
       "78       492223       501431       465846       444356       453731   \n",
       "79        19436        19734        18461        17613        18210   \n",
       "80            0            0            0            0            0   \n",
       "81        35000        40000        47579        48186        34767   \n",
       "82     1.06e+06     1.06e+06      1.1e+06     1.13e+06      1.1e+06   \n",
       "\n",
       "         yr1978  ...       yr2009       yr2010       yr2011       yr2012  \\\n",
       "0         11500  ...         2600         2672         4379         5691   \n",
       "1           200  ...            0            0            0            0   \n",
       "2           319  ...       143084       140300       116700       135700   \n",
       "3        222111  ...       855892       871963       960649       921390   \n",
       "4             0  ...            0            0            0            0   \n",
       "5          3267  ...          620         2100         4176         8700   \n",
       "6         14615  ...        24382        48026        31929        35768   \n",
       "7             0  ...       211692       213548       213760       223141   \n",
       "8         57000  ...       110652       112904       114603       118255   \n",
       "9           100  ...         9800        10000        12000        25000   \n",
       "10       659380  ...       484605       522172       566779       580082   \n",
       "11   1.0342e+06  ...   5.3944e+06   5.4189e+06   5.2628e+06   5.4339e+06   \n",
       "12       160000  ...    1.062e+06   1.1558e+06   1.2947e+06   1.5768e+06   \n",
       "13          100  ...         1140          711          808          781   \n",
       "14         2821  ...            0            0            0            0   \n",
       "15         4678  ...         2380         2595         3660         4328   \n",
       "16         8200  ...            0            0            0            0   \n",
       "17          508  ...          300          700         1400         1800   \n",
       "18        52089  ...        14600        14700        14000        25446   \n",
       "19          200  ...            0            0            0            0   \n",
       "20         1500  ...            0            0            0            0   \n",
       "21         2023  ...            0            0            0            0   \n",
       "22            0  ...            0            0            0            0   \n",
       "23          427  ...            0            0            0            0   \n",
       "24          203  ...            0            0            0            0   \n",
       "25        26640  ...        28491        31778        31375        29281   \n",
       "26        58000  ...       995500       863900       538300       398100   \n",
       "27         6000  ...       262500       256700       258900       245500   \n",
       "28         4700  ...            0            0            0            0   \n",
       "29            0  ...            0            0            0            0   \n",
       "30          531  ...            0            0            0            0   \n",
       "31        71951  ...            0            0            0            0   \n",
       "32            0  ...            0            0            0            0   \n",
       "33          715  ...            0            0            0            0   \n",
       "34        15000  ...         3700         4600         7000        17000   \n",
       "35        26000  ...          240            0            0            0   \n",
       "36         1773  ...        36608        36969        35281        37670   \n",
       "37        87186  ...       240648       270136       443621       500275   \n",
       "38         4000  ...       132300       127600       124000       123900   \n",
       "39         4300  ...        11830        14986        12076        14750   \n",
       "40          300  ...            0            0            0            0   \n",
       "41        37700  ...            0            0         3366         5304   \n",
       "42            0  ...            0            0            0            0   \n",
       "43            0  ...            0            0            0            0   \n",
       "44        29073  ...            0            0            0            0   \n",
       "45            0  ...        15563        16530        21166        19684   \n",
       "46       198603  ...       166669       159821       130456       125326   \n",
       "47       366753  ...  1.27625e+06  1.24718e+06  1.23534e+06  1.29876e+06   \n",
       "48       263589  ...        49060        58412        63835        65444   \n",
       "49       312000  ...       439365       425725       426665       427064   \n",
       "50         2962  ...        86462        74426        79686        74043   \n",
       "51        27000  ...         3129         5127         6355         5902   \n",
       "52       205745  ...       107600       102600        96600        88800   \n",
       "53        40448  ...        17663        54335        68511        99894   \n",
       "54        47412  ...        55414        76514        82967        82422   \n",
       "55          800  ...            0            0            0            0   \n",
       "56        27188  ...        72400        79900        92500       104300   \n",
       "57  1.35759e+06  ...     1.18e+06     1.11e+06   1.1129e+06   1.1668e+06   \n",
       "58         7200  ...            0            0            0            0   \n",
       "59          135  ...            0            0            0            0   \n",
       "60       123319  ...            0            0            0            0   \n",
       "61       654012  ...       601200       767008       663400       695200   \n",
       "62            0  ...        23233        31062        33597        40908   \n",
       "63            0  ...        16600        10600        10000         6800   \n",
       "64            0  ...       406100       380600       405300       426800   \n",
       "65            0  ...       121581       132047       138756       149580   \n",
       "66            0  ...         7440         7912         7555        10600   \n",
       "67            0  ...        19600        19900        20000        23900   \n",
       "68            0  ...         1719         1603         1954         4410   \n",
       "69            0  ...         3079         6400         6748         5840   \n",
       "70            0  ...        80000        80000        80000        95600   \n",
       "71            0  ...        12935        12260        11888        12716   \n",
       "72            0  ...            0          183          611          502   \n",
       "73            0  ...        12937        10015        11777        11737   \n",
       "74            0  ...            0            0            0            0   \n",
       "75            0  ...            0            0            0            0   \n",
       "76            0  ...           14           22           28           31   \n",
       "77            0  ...            0            0            0            0   \n",
       "78       473128  ...       299300       378300       499198       619942   \n",
       "79        15821  ...            0            0            0            0   \n",
       "80            0  ...        19400        22800        26100        32200   \n",
       "81        33848  ...         3572         4629         6555         6665   \n",
       "82     1.14e+06  ...       675700       702700       587900       582900   \n",
       "\n",
       "         yr2013       yr2014       yr2015       yr2016       yr2017  \\\n",
       "0          5087         3503         2106          218            0   \n",
       "1             0            0            0            0            0   \n",
       "2        109600       102600        61800        81900        33300   \n",
       "3     1.001e+06       978534       995881       947555       849121   \n",
       "4             0            0            0            0            0   \n",
       "5          7549        10746         9479         8718         7219   \n",
       "6         48500        38000         9162        12415         1239   \n",
       "7        270979       301197       359463       337600       384542   \n",
       "8        115149       108323       111746       109702       109078   \n",
       "9         33000        42000        71000        95000       116000   \n",
       "10       652595       672729       714647       693059       597194   \n",
       "11    5.776e+06   5.7611e+06   5.7721e+06   5.5526e+06   5.5035e+06   \n",
       "12  1.71515e+06  1.77679e+06  1.71206e+06  1.90019e+06   1.7064e+06   \n",
       "13          659         4118         5463         8493         9355   \n",
       "14            0            0            0            0            0   \n",
       "15         3631         3088         2121         1754         1293   \n",
       "16            0            0            0            0            0   \n",
       "17         4700         3000         1800         1000         8200   \n",
       "18        38763        42790        41085        47488        53144   \n",
       "19            0            0            0            0            0   \n",
       "20            0            0            0            0            0   \n",
       "21            0            0            0            0            0   \n",
       "22            0            0            0            0            0   \n",
       "23            0            0            0            0            0   \n",
       "24            0            0            0            0            0   \n",
       "25        32194        24889        32493        31999        33678   \n",
       "26       509300       378500       578600       728000       622030   \n",
       "27       222900       216800       246400       289300       295621   \n",
       "28            0            0            0            0            0   \n",
       "29            0            0            0            0            0   \n",
       "30            0            0            0            0            0   \n",
       "31            0            0            0            0            0   \n",
       "32            0            0            0            0            0   \n",
       "33            0            0            0            0            0   \n",
       "34        15000         7700         8600        12600         1800   \n",
       "35            0            0            0            0            0   \n",
       "36        37970        33079        45001        32820        28791   \n",
       "37       480124       515025       594451       766129       742246   \n",
       "38       189000       253000       318000       516000       475000   \n",
       "39        11575        16579        19903        23586        24603   \n",
       "40            0            0            0            0            0   \n",
       "41         4896         5249        14010        16653        15534   \n",
       "42            0            0            0            0            0   \n",
       "43            0            0            0            0            0   \n",
       "44            0            0            0            0            0   \n",
       "45        10906        13699         7828            0            0   \n",
       "46       105523        75901        45185        80022       105419   \n",
       "47  1.37564e+06  1.37764e+06  1.70082e+06  2.35386e+06  2.44558e+06   \n",
       "48        90861        91824        83835        83649        68156   \n",
       "49       428879       421285       426196       424000       419000   \n",
       "50        77236        75433        83081        74453        63812   \n",
       "51         6800         7200         3600         7300         7400   \n",
       "52        80821        78697        77360        65257        65503   \n",
       "53       104600       103900       112690       167736       198353   \n",
       "54        82904        79345        75125        78992       104450   \n",
       "55            0            0            0            0            0   \n",
       "56       120500       122000       108000       100000        83000   \n",
       "57   1.2782e+06   1.3847e+06   1.4163e+06   1.4619e+06     1.29e+06   \n",
       "58            0            0            0            0            0   \n",
       "59            0            0            0            0            0   \n",
       "60            0            0            0            0            0   \n",
       "61       759800       708259       710860       725359       797266   \n",
       "62        48891        50952        83634       102962       113560   \n",
       "63        10000         6800        13000        14000        15000   \n",
       "64       454400       471700       473600       474800       557800   \n",
       "65       154915       159696       167702       177939       153304   \n",
       "66        11700         9600        11400        10200         9000   \n",
       "67        20700        18000        16000        14100        15000   \n",
       "68         5095        10848        11563        27500        36279   \n",
       "69         5740         6363         6465         7150         1331   \n",
       "70       100000       100000       100000       100000       100000   \n",
       "71        12958        20296        22524        22636        21451   \n",
       "72          327          784          969         1941         1991   \n",
       "73        10379         9262         7324         9725         9618   \n",
       "74        21800        88900        61600        25300         7900   \n",
       "75            0          700         3100         8200         7500   \n",
       "76           40           46           58           39           32   \n",
       "77          600          100         1400         2500         6100   \n",
       "78       922016  1.03013e+06  1.03901e+06  1.02369e+06  1.09464e+06   \n",
       "79            0            0            0            0            0   \n",
       "80        36200        33739        29827        41300        44800   \n",
       "81         8285         8261         8218         9101         8839   \n",
       "82       655900       691500       711400       702300       762300   \n",
       "\n",
       "         yr2018  \n",
       "0          2601  \n",
       "1             0  \n",
       "2         17400  \n",
       "3        913336  \n",
       "4             0  \n",
       "5          5200  \n",
       "6          1462  \n",
       "7        381000  \n",
       "8        109400  \n",
       "9        154000  \n",
       "10       539473  \n",
       "11   5.8316e+06  \n",
       "12    1.591e+06  \n",
       "13        10371  \n",
       "14            0  \n",
       "15          908  \n",
       "16            0  \n",
       "17         8000  \n",
       "18        46755  \n",
       "19            0  \n",
       "20            0  \n",
       "21            0  \n",
       "22            0  \n",
       "23            0  \n",
       "24            0  \n",
       "25        37000  \n",
       "26       651136  \n",
       "27       316500  \n",
       "28            0  \n",
       "29            0  \n",
       "30            0  \n",
       "31            0  \n",
       "32            0  \n",
       "33            0  \n",
       "34            0  \n",
       "35            0  \n",
       "36        28138  \n",
       "37       696580  \n",
       "38       458780  \n",
       "39        23859  \n",
       "40            0  \n",
       "41        15177  \n",
       "42            0  \n",
       "43            0  \n",
       "44            0  \n",
       "45            0  \n",
       "46        96287  \n",
       "47  2.43695e+06  \n",
       "48        69933  \n",
       "49       401300  \n",
       "50        49064  \n",
       "51         8100  \n",
       "52        46900  \n",
       "53       185237  \n",
       "54       106142  \n",
       "55            0  \n",
       "56        79600  \n",
       "57     1.25e+06  \n",
       "58            0  \n",
       "59            0  \n",
       "60            0  \n",
       "61       851089  \n",
       "62        84100  \n",
       "63        13000  \n",
       "64       635500  \n",
       "65       147019  \n",
       "66         8000  \n",
       "67        16700  \n",
       "68        67508  \n",
       "69            0  \n",
       "70       100000  \n",
       "71        23378  \n",
       "72         1645  \n",
       "73         8588  \n",
       "74        17300  \n",
       "75         7200  \n",
       "76           21  \n",
       "77            0  \n",
       "78  1.22523e+06  \n",
       "79            0  \n",
       "80        44100  \n",
       "81         9077  \n",
       "82       785300  \n",
       "\n",
       "[83 rows x 50 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cu_mined_70_18"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}