Skip to content

Instantly share code, notes, and snippets.

@finnqiao

finnqiao/gist:2d9824d43e46b07f008b3414d0880e2e

Last active June 23, 2018 04:29
Show Gist options
  • Save finnqiao/2d9824d43e46b07f008b3414d0880e2e to your computer and use it in GitHub Desktop.
Save finnqiao/2d9824d43e46b07f008b3414d0880e2e to your computer and use it in GitHub Desktop.
Download ZIP
test1
Display the source blob
Display the rendered blob
Raw
gistfile1.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 148,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import seaborn as sb\n",
"import numpy as np\n",
"import matplotlib\n",
"import matplotlib.pyplot as plt"
]
},
{
"cell_type": "code",
"execution_count": 69,
"metadata": {},
"outputs": [],
"source": [
"import missingno as msno"
]
},
{
"cell_type": "code",
"execution_count": 70,
"metadata": {},
"outputs": [],
"source": [
"from itertools import islice\n",
"import csv"
]
},
{
"cell_type": "code",
"execution_count": 71,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>...</th>\n",
" <th>53</th>\n",
" <th>54</th>\n",
" <th>55</th>\n",
" <th>56</th>\n",
" <th>57</th>\n",
" <th>58</th>\n",
" <th>59</th>\n",
" <th>60</th>\n",
" <th>61</th>\n",
" <th>62</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Country Name</td>\n",
" <td>Country Code</td>\n",
" <td>Indicator Name</td>\n",
" <td>Indicator Code</td>\n",
" <td>1960</td>\n",
" <td>1961</td>\n",
" <td>1962</td>\n",
" <td>1963</td>\n",
" <td>1964</td>\n",
" <td>1965</td>\n",
" <td>...</td>\n",
" <td>2009</td>\n",
" <td>2010</td>\n",
" <td>2011</td>\n",
" <td>2012</td>\n",
" <td>2013</td>\n",
" <td>2014</td>\n",
" <td>2015</td>\n",
" <td>2016</td>\n",
" <td>2017</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Aruba</td>\n",
" <td>ABW</td>\n",
" <td>Bank nonperforming loans to total gross loans (%)</td>\n",
" <td>FB.AST.NPER.ZS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Afghanistan</td>\n",
" <td>AFG</td>\n",
" <td>Bank nonperforming loans to total gross loans (%)</td>\n",
" <td>FB.AST.NPER.ZS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td>49.9013229069412</td>\n",
" <td>4.6968178252385</td>\n",
" <td>4.95890140377645</td>\n",
" <td>4.85228704838131</td>\n",
" <td>7.7810908959605</td>\n",
" <td>12.0536179767696</td>\n",
" <td>11.0743789647307</td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Angola</td>\n",
" <td>AGO</td>\n",
" <td>Bank nonperforming loans to total gross loans (%)</td>\n",
" <td>FB.AST.NPER.ZS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td>3.17305056414187</td>\n",
" <td>2.01496821504011</td>\n",
" <td>4.35011884491608</td>\n",
" <td>7.97676918024597</td>\n",
" <td>10.1905320738466</td>\n",
" <td>10.6112339715733</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Albania</td>\n",
" <td>ALB</td>\n",
" <td>Bank nonperforming loans to total gross loans (%)</td>\n",
" <td>FB.AST.NPER.ZS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 63 columns</p>\n",
"</div>"
],
"text/plain": [
" 0 1 \\\n",
"0 Country Name Country Code \n",
"1 Aruba ABW \n",
"2 Afghanistan AFG \n",
"3 Angola AGO \n",
"4 Albania ALB \n",
"\n",
" 2 3 4 \\\n",
"0 Indicator Name Indicator Code 1960 \n",
"1 Bank nonperforming loans to total gross loans (%) FB.AST.NPER.ZS \n",
"2 Bank nonperforming loans to total gross loans (%) FB.AST.NPER.ZS \n",
"3 Bank nonperforming loans to total gross loans (%) FB.AST.NPER.ZS \n",
"4 Bank nonperforming loans to total gross loans (%) FB.AST.NPER.ZS \n",
"\n",
" 5 6 7 8 9 ... 53 54 55 \\\n",
"0 1961 1962 1963 1964 1965 ... 2009 2010 2011 \n",
"1 ... \n",
"2 ... 49.9013229069412 4.6968178252385 \n",
"3 ... 3.17305056414187 2.01496821504011 \n",
"4 ... \n",
"\n",
" 56 57 58 59 \\\n",
"0 2012 2013 2014 2015 \n",
"1 \n",
"2 4.95890140377645 4.85228704838131 7.7810908959605 12.0536179767696 \n",
"3 4.35011884491608 7.97676918024597 10.1905320738466 10.6112339715733 \n",
"4 \n",
"\n",
" 60 61 62 \n",
"0 2016 2017 \n",
"1 \n",
"2 11.0743789647307 \n",
"3 \n",
"4 \n",
"\n",
"[5 rows x 63 columns]"
]
},
"execution_count": 71,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"all_data = []\n",
"with open('NPL.csv') as data:\n",
" for row in islice(csv.reader(data), 4, None):\n",
" all_data.append(np.array(row))\n",
" \n",
"df = pd.DataFrame(all_data)\n",
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 72,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"RangeIndex(start=0, stop=63, step=1)"
]
},
"execution_count": 72,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.columns"
]
},
{
"cell_type": "code",
"execution_count": 76,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Country Name</th>\n",
" <th>Country Code</th>\n",
" <th>2008</th>\n",
" <th>2009</th>\n",
" <th>2010</th>\n",
" <th>2011</th>\n",
" <th>2012</th>\n",
" <th>2013</th>\n",
" <th>2014</th>\n",
" <th>2015</th>\n",
" <th>2016</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Aruba</td>\n",
" <td>ABW</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Afghanistan</td>\n",
" <td>AFG</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>49.9013229069412</td>\n",
" <td>4.6968178252385</td>\n",
" <td>4.95890140377645</td>\n",
" <td>4.85228704838131</td>\n",
" <td>7.7810908959605</td>\n",
" <td>12.0536179767696</td>\n",
" <td>11.0743789647307</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Angola</td>\n",
" <td>AGO</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>3.17305056414187</td>\n",
" <td>2.01496821504011</td>\n",
" <td>4.35011884491608</td>\n",
" <td>7.97676918024597</td>\n",
" <td>10.1905320738466</td>\n",
" <td>10.6112339715733</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Albania</td>\n",
" <td>ALB</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Andorra</td>\n",
" <td>AND</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Arab World</td>\n",
" <td>ARB</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>United Arab Emirates</td>\n",
" <td>ARE</td>\n",
" <td></td>\n",
" <td>4.17812783392795</td>\n",
" <td>5.26698896173513</td>\n",
" <td>6.08629581295722</td>\n",
" <td>7.12965175228017</td>\n",
" <td>6.73555170490737</td>\n",
" <td>5.63661628252583</td>\n",
" <td>5.19506180189675</td>\n",
" <td>5.29846353155647</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Argentina</td>\n",
" <td>ARG</td>\n",
" <td>3.10838474371201</td>\n",
" <td>3.46682830746549</td>\n",
" <td>2.11702287385862</td>\n",
" <td>1.39559840620402</td>\n",
" <td>1.7345487210843</td>\n",
" <td>1.73258243136737</td>\n",
" <td>1.990064383351</td>\n",
" <td>1.73684181834171</td>\n",
" <td>1.83660554376284</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Armenia</td>\n",
" <td>ARM</td>\n",
" <td>4.28418920018598</td>\n",
" <td>4.86361900244843</td>\n",
" <td>3.04141129948019</td>\n",
" <td>3.42109151341693</td>\n",
" <td>3.66922217057882</td>\n",
" <td>4.48533892299217</td>\n",
" <td>6.96975042813576</td>\n",
" <td>7.94971668385926</td>\n",
" <td>6.72411125058909</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>American Samoa</td>\n",
" <td>ASM</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Antigua and Barbuda</td>\n",
" <td>ATG</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Australia</td>\n",
" <td>AUS</td>\n",
" <td>1.35526208847002</td>\n",
" <td>2.01806458457878</td>\n",
" <td>2.149</td>\n",
" <td>1.968</td>\n",
" <td>1.747</td>\n",
" <td>1.399</td>\n",
" <td>1.047</td>\n",
" <td>0.924</td>\n",
" <td>0.979</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Austria</td>\n",
" <td>AUT</td>\n",
" <td>1.90306942802893</td>\n",
" <td>2.25042258658752</td>\n",
" <td>2.83071715205898</td>\n",
" <td>2.70681550509306</td>\n",
" <td>2.81336476630545</td>\n",
" <td>2.86654169526513</td>\n",
" <td>3.47337431453068</td>\n",
" <td>3.39283728404187</td>\n",
" <td>2.69521741465076</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Azerbaijan</td>\n",
" <td>AZE</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Burundi</td>\n",
" <td>BDI</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>9.31523574939506</td>\n",
" <td>7.39310710399005</td>\n",
" <td>8.16828544058576</td>\n",
" <td>9.88695195519018</td>\n",
" <td>10.8229150487183</td>\n",
" <td>17.9166965111326</td>\n",
" <td>21.0565185978806</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Belgium</td>\n",
" <td>BEL</td>\n",
" <td>1.65216421885301</td>\n",
" <td>3.07543666306607</td>\n",
" <td>2.79861058961923</td>\n",
" <td>3.30230175656615</td>\n",
" <td>3.73825450719312</td>\n",
" <td>4.24497740525735</td>\n",
" <td>4.17569211829305</td>\n",
" <td>3.78935142858271</td>\n",
" <td>3.43203325193356</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Benin</td>\n",
" <td>BEN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Burkina Faso</td>\n",
" <td>BFA</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Bangladesh</td>\n",
" <td>BGD</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>5.84900153173375</td>\n",
" <td>9.72807562789872</td>\n",
" <td>8.64185174932391</td>\n",
" <td>9.3655406413084</td>\n",
" <td>8.39790781352825</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Bulgaria</td>\n",
" <td>BGR</td>\n",
" <td>2.40390652919768</td>\n",
" <td>6.42293385932725</td>\n",
" <td>11.9177087634194</td>\n",
" <td>14.9736139565097</td>\n",
" <td>16.6263209293069</td>\n",
" <td>16.8785208328338</td>\n",
" <td>16.7465294214345</td>\n",
" <td>14.612050861519</td>\n",
" <td>13.1730655335127</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Bahrain</td>\n",
" <td>BHR</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Bahamas, The</td>\n",
" <td>BHS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Bosnia and Herzegovina</td>\n",
" <td>BIH</td>\n",
" <td>3.09120794221065</td>\n",
" <td>5.8712072518763</td>\n",
" <td>11.421782175376</td>\n",
" <td>11.7997140822193</td>\n",
" <td>13.4656882284517</td>\n",
" <td>15.1198478740683</td>\n",
" <td>14.1653123764986</td>\n",
" <td>13.7084158662801</td>\n",
" <td>11.7777190845963</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Belarus</td>\n",
" <td>BLR</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>3.54880427143014</td>\n",
" <td>4.15959581162895</td>\n",
" <td>5.50187400609008</td>\n",
" <td>4.44733135755543</td>\n",
" <td>4.37130403366124</td>\n",
" <td>6.83494796382143</td>\n",
" <td>12.791174278387</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Belize</td>\n",
" <td>BLZ</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Bermuda</td>\n",
" <td>BMU</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Bolivia</td>\n",
" <td>BOL</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>2.14098016078259</td>\n",
" <td>1.64499555407419</td>\n",
" <td>1.45359977173878</td>\n",
" <td>1.48473224456689</td>\n",
" <td>1.50237950472033</td>\n",
" <td>1.49992861153731</td>\n",
" <td>1.5769576006293</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Brazil</td>\n",
" <td>BRA</td>\n",
" <td>3.10639256827815</td>\n",
" <td>4.21499469701351</td>\n",
" <td>3.10772417173934</td>\n",
" <td>3.46686409051456</td>\n",
" <td>3.44682339262827</td>\n",
" <td>2.85728229301093</td>\n",
" <td>2.85479995510717</td>\n",
" <td>3.31178796015599</td>\n",
" <td>3.91663909818561</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Barbados</td>\n",
" <td>BRB</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Brunei Darussalam</td>\n",
" <td>BRN</td>\n",
" <td></td>\n",
" <td>9.36467132030001</td>\n",
" <td>6.86702975926534</td>\n",
" <td>6.03201397638731</td>\n",
" <td>5.37615761868223</td>\n",
" <td>4.52530200889505</td>\n",
" <td>3.85059424062381</td>\n",
" <td>0.399835180405115</td>\n",
" <td>4.62526313226275</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>235</th>\n",
" <td>Latin America &amp; the Caribbean (IDA &amp; IBRD coun...</td>\n",
" <td>TLA</td>\n",
" <td>2.96558812609128</td>\n",
" <td>3.57302236577286</td>\n",
" <td>2.77832843863172</td>\n",
" <td>2.42099970411912</td>\n",
" <td>2.33052458084595</td>\n",
" <td>2.19164716358291</td>\n",
" <td>2.13340352095405</td>\n",
" <td>2.22478823868599</td>\n",
" <td>2.30165735720531</td>\n",
" </tr>\n",
" <tr>\n",
" <th>236</th>\n",
" <td>Timor-Leste</td>\n",
" <td>TLS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>237</th>\n",
" <td>Middle East &amp; North Africa (IDA &amp; IBRD countries)</td>\n",
" <td>TMN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>238</th>\n",
" <td>Tonga</td>\n",
" <td>TON</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>14.3731796444657</td>\n",
" <td>10.6057193507607</td>\n",
" <td>10.4781361324885</td>\n",
" <td>7.64017617486987</td>\n",
" <td>4.07173200693191</td>\n",
" </tr>\n",
" <tr>\n",
" <th>239</th>\n",
" <td>South Asia (IDA &amp; IBRD)</td>\n",
" <td>TSA</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>14.7475434474005</td>\n",
" <td>4.6968178252385</td>\n",
" <td>4.95890140377645</td>\n",
" <td>5.57505787931051</td>\n",
" <td>7.7810908959605</td>\n",
" <td>8.39790781352825</td>\n",
" <td>9.62068119899267</td>\n",
" </tr>\n",
" <tr>\n",
" <th>240</th>\n",
" <td>Sub-Saharan Africa (IDA &amp; IBRD countries)</td>\n",
" <td>TSS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>5.10621026773849</td>\n",
" <td>6.06755038882137</td>\n",
" <td>6.08459649451211</td>\n",
" <td>6.5581708416557</td>\n",
" <td>9.61457507208068</td>\n",
" </tr>\n",
" <tr>\n",
" <th>241</th>\n",
" <td>Trinidad and Tobago</td>\n",
" <td>TTO</td>\n",
" <td>2.43949335676895</td>\n",
" <td>4.88533772882428</td>\n",
" <td>6.09055701593636</td>\n",
" <td>6.18622767169789</td>\n",
" <td>5.32423289788734</td>\n",
" <td>4.18396509854302</td>\n",
" <td>4.06029704176324</td>\n",
" <td>3.40922365291852</td>\n",
" <td>3.12500531931932</td>\n",
" </tr>\n",
" <tr>\n",
" <th>242</th>\n",
" <td>Tunisia</td>\n",
" <td>TUN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>243</th>\n",
" <td>Turkey</td>\n",
" <td>TUR</td>\n",
" <td>3.44167340058132</td>\n",
" <td>4.96997625418198</td>\n",
" <td>3.48959158482402</td>\n",
" <td>2.57632211204451</td>\n",
" <td>2.7433675978872</td>\n",
" <td>2.63627102630174</td>\n",
" <td>2.74183131997442</td>\n",
" <td>2.98772329214314</td>\n",
" <td>3.10968373133547</td>\n",
" </tr>\n",
" <tr>\n",
" <th>244</th>\n",
" <td>Tuvalu</td>\n",
" <td>TUV</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>245</th>\n",
" <td>Tanzania</td>\n",
" <td>TZA</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>7.84376122521316</td>\n",
" <td>5.39637230168725</td>\n",
" <td>6.4018854955144</td>\n",
" <td>5.11514486567446</td>\n",
" <td>6.58398471153915</td>\n",
" <td>8.58250269886561</td>\n",
" <td>9.60809945919417</td>\n",
" </tr>\n",
" <tr>\n",
" <th>246</th>\n",
" <td>Uganda</td>\n",
" <td>UGA</td>\n",
" <td>2.0902179694744</td>\n",
" <td>3.97399121299265</td>\n",
" <td>1.86158193519678</td>\n",
" <td>2.03212772455735</td>\n",
" <td>4.05584907416987</td>\n",
" <td>5.7568890765564</td>\n",
" <td>4.01059662166392</td>\n",
" <td>5.12695553089331</td>\n",
" <td>10.4013107515952</td>\n",
" </tr>\n",
" <tr>\n",
" <th>247</th>\n",
" <td>Ukraine</td>\n",
" <td>UKR</td>\n",
" <td>3.88384824266828</td>\n",
" <td>13.6977713199854</td>\n",
" <td>15.2665117708456</td>\n",
" <td>14.7322884259186</td>\n",
" <td>16.5423303569023</td>\n",
" <td>12.8861390797106</td>\n",
" <td>18.9844230177685</td>\n",
" <td>28.0347714697952</td>\n",
" <td>30.4682699223548</td>\n",
" </tr>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>Upper middle income</td>\n",
" <td>UMC</td>\n",
" <td>3.44042599537793</td>\n",
" <td>4.62203078842052</td>\n",
" <td>3.35402670735158</td>\n",
" <td>2.9126845602561</td>\n",
" <td>3.45084175332667</td>\n",
" <td>3.53004504580609</td>\n",
" <td>3.56658358508436</td>\n",
" <td>3.8299205830029</td>\n",
" <td>4.12832311760232</td>\n",
" </tr>\n",
" <tr>\n",
" <th>249</th>\n",
" <td>Uruguay</td>\n",
" <td>URY</td>\n",
" <td>0.509364858663751</td>\n",
" <td>3.81668671640444</td>\n",
" <td>2.42280900203523</td>\n",
" <td>1.49105441888857</td>\n",
" <td>1.32547589221842</td>\n",
" <td>1.27694211466818</td>\n",
" <td>1.27782210089718</td>\n",
" <td>1.59817495618485</td>\n",
" <td>2.31586181233161</td>\n",
" </tr>\n",
" <tr>\n",
" <th>250</th>\n",
" <td>United States</td>\n",
" <td>USA</td>\n",
" <td></td>\n",
" <td>4.95990413551278</td>\n",
" <td>4.38774309355536</td>\n",
" <td>3.78150446863877</td>\n",
" <td>3.31729162388854</td>\n",
" <td>2.45239118205519</td>\n",
" <td>1.85071180176899</td>\n",
" <td>1.47342654864512</td>\n",
" <td>1.32052217712119</td>\n",
" </tr>\n",
" <tr>\n",
" <th>251</th>\n",
" <td>Uzbekistan</td>\n",
" <td>UZB</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0.965131048293637</td>\n",
" <td>0.709190155100445</td>\n",
" <td>0.533310395251817</td>\n",
" <td>0.405672371638142</td>\n",
" <td>0.390536334493127</td>\n",
" <td>0.418195139268297</td>\n",
" <td>0.43641478412104</td>\n",
" </tr>\n",
" <tr>\n",
" <th>252</th>\n",
" <td>St. Vincent and the Grenadines</td>\n",
" <td>VCT</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>253</th>\n",
" <td>Venezuela, RB</td>\n",
" <td>VEN</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>254</th>\n",
" <td>British Virgin Islands</td>\n",
" <td>VGB</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>255</th>\n",
" <td>Virgin Islands (U.S.)</td>\n",
" <td>VIR</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>256</th>\n",
" <td>Vietnam</td>\n",
" <td>VNM</td>\n",
" <td>2.15099820496032</td>\n",
" <td>1.79656609383679</td>\n",
" <td>2.09259938242</td>\n",
" <td>2.79209384764477</td>\n",
" <td>3.43791016533393</td>\n",
" <td>3.10707263260723</td>\n",
" <td>2.93510795966688</td>\n",
" <td>2.33849921547478</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>257</th>\n",
" <td>Vanuatu</td>\n",
" <td>VUT</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>4.77150543510283</td>\n",
" <td>7.82015970798529</td>\n",
" <td>7.82678528887575</td>\n",
" <td>14.1043951624069</td>\n",
" <td>10.72651222798</td>\n",
" <td>12.2669904276453</td>\n",
" <td>11.5303725603049</td>\n",
" </tr>\n",
" <tr>\n",
" <th>258</th>\n",
" <td>World</td>\n",
" <td>WLD</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>3.89392892252872</td>\n",
" <td>3.70863914664164</td>\n",
" <td>3.69274020433977</td>\n",
" <td>4.02772863501631</td>\n",
" <td>4.06703210187157</td>\n",
" <td>4.0890988575673</td>\n",
" <td>3.91663909818561</td>\n",
" </tr>\n",
" <tr>\n",
" <th>259</th>\n",
" <td>Samoa</td>\n",
" <td>WSM</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>3.72405853190229</td>\n",
" </tr>\n",
" <tr>\n",
" <th>260</th>\n",
" <td>Kosovo</td>\n",
" <td>XKX</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>5.80526374637873</td>\n",
" <td>5.66580052766946</td>\n",
" <td>7.40082979935601</td>\n",
" <td>8.5482461957591</td>\n",
" <td>8.30909888012837</td>\n",
" <td>6.15184768358736</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>261</th>\n",
" <td>Yemen, Rep.</td>\n",
" <td>YEM</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>262</th>\n",
" <td>South Africa</td>\n",
" <td>ZAF</td>\n",
" <td>3.9215151760083</td>\n",
" <td>5.93611005938851</td>\n",
" <td>5.79213811982895</td>\n",
" <td>4.68085603795407</td>\n",
" <td>4.04289179376388</td>\n",
" <td>3.6412867248273</td>\n",
" <td>3.24484669266088</td>\n",
" <td>3.12168564309893</td>\n",
" <td>2.85780789607925</td>\n",
" </tr>\n",
" <tr>\n",
" <th>263</th>\n",
" <td>Zambia</td>\n",
" <td>ZMB</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>14.823594208206</td>\n",
" <td>10.3761928815145</td>\n",
" <td>8.10539132030299</td>\n",
" <td>6.95836227043975</td>\n",
" <td>6.10431782511365</td>\n",
" <td>7.27921009900605</td>\n",
" <td>9.66492659101592</td>\n",
" </tr>\n",
" <tr>\n",
" <th>264</th>\n",
" <td>Zimbabwe</td>\n",
" <td>ZWE</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>264 rows × 11 columns</p>\n",
"</div>"
],
"text/plain": [
"0 Country Name Country Code \\\n",
"1 Aruba ABW \n",
"2 Afghanistan AFG \n",
"3 Angola AGO \n",
"4 Albania ALB \n",
"5 Andorra AND \n",
"6 Arab World ARB \n",
"7 United Arab Emirates ARE \n",
"8 Argentina ARG \n",
"9 Armenia ARM \n",
"10 American Samoa ASM \n",
"11 Antigua and Barbuda ATG \n",
"12 Australia AUS \n",
"13 Austria AUT \n",
"14 Azerbaijan AZE \n",
"15 Burundi BDI \n",
"16 Belgium BEL \n",
"17 Benin BEN \n",
"18 Burkina Faso BFA \n",
"19 Bangladesh BGD \n",
"20 Bulgaria BGR \n",
"21 Bahrain BHR \n",
"22 Bahamas, The BHS \n",
"23 Bosnia and Herzegovina BIH \n",
"24 Belarus BLR \n",
"25 Belize BLZ \n",
"26 Bermuda BMU \n",
"27 Bolivia BOL \n",
"28 Brazil BRA \n",
"29 Barbados BRB \n",
"30 Brunei Darussalam BRN \n",
".. ... ... \n",
"235 Latin America & the Caribbean (IDA & IBRD coun... TLA \n",
"236 Timor-Leste TLS \n",
"237 Middle East & North Africa (IDA & IBRD countries) TMN \n",
"238 Tonga TON \n",
"239 South Asia (IDA & IBRD) TSA \n",
"240 Sub-Saharan Africa (IDA & IBRD countries) TSS \n",
"241 Trinidad and Tobago TTO \n",
"242 Tunisia TUN \n",
"243 Turkey TUR \n",
"244 Tuvalu TUV \n",
"245 Tanzania TZA \n",
"246 Uganda UGA \n",
"247 Ukraine UKR \n",
"248 Upper middle income UMC \n",
"249 Uruguay URY \n",
"250 United States USA \n",
"251 Uzbekistan UZB \n",
"252 St. Vincent and the Grenadines VCT \n",
"253 Venezuela, RB VEN \n",
"254 British Virgin Islands VGB \n",
"255 Virgin Islands (U.S.) VIR \n",
"256 Vietnam VNM \n",
"257 Vanuatu VUT \n",
"258 World WLD \n",
"259 Samoa WSM \n",
"260 Kosovo XKX \n",
"261 Yemen, Rep. YEM \n",
"262 South Africa ZAF \n",
"263 Zambia ZMB \n",
"264 Zimbabwe ZWE \n",
"\n",
"0 2008 2009 2010 \\\n",
"1 \n",
"2 49.9013229069412 \n",
"3 3.17305056414187 \n",
"4 \n",
"5 \n",
"6 \n",
"7 4.17812783392795 5.26698896173513 \n",
"8 3.10838474371201 3.46682830746549 2.11702287385862 \n",
"9 4.28418920018598 4.86361900244843 3.04141129948019 \n",
"10 \n",
"11 \n",
"12 1.35526208847002 2.01806458457878 2.149 \n",
"13 1.90306942802893 2.25042258658752 2.83071715205898 \n",
"14 \n",
"15 9.31523574939506 \n",
"16 1.65216421885301 3.07543666306607 2.79861058961923 \n",
"17 \n",
"18 \n",
"19 \n",
"20 2.40390652919768 6.42293385932725 11.9177087634194 \n",
"21 \n",
"22 \n",
"23 3.09120794221065 5.8712072518763 11.421782175376 \n",
"24 3.54880427143014 \n",
"25 \n",
"26 \n",
"27 2.14098016078259 \n",
"28 3.10639256827815 4.21499469701351 3.10772417173934 \n",
"29 \n",
"30 9.36467132030001 6.86702975926534 \n",
".. ... ... ... \n",
"235 2.96558812609128 3.57302236577286 2.77832843863172 \n",
"236 \n",
"237 \n",
"238 0 \n",
"239 14.7475434474005 \n",
"240 \n",
"241 2.43949335676895 4.88533772882428 6.09055701593636 \n",
"242 \n",
"243 3.44167340058132 4.96997625418198 3.48959158482402 \n",
"244 \n",
"245 7.84376122521316 \n",
"246 2.0902179694744 3.97399121299265 1.86158193519678 \n",
"247 3.88384824266828 13.6977713199854 15.2665117708456 \n",
"248 3.44042599537793 4.62203078842052 3.35402670735158 \n",
"249 0.509364858663751 3.81668671640444 2.42280900203523 \n",
"250 4.95990413551278 4.38774309355536 \n",
"251 0.965131048293637 \n",
"252 \n",
"253 \n",
"254 \n",
"255 \n",
"256 2.15099820496032 1.79656609383679 2.09259938242 \n",
"257 4.77150543510283 \n",
"258 3.89392892252872 \n",
"259 \n",
"260 5.80526374637873 \n",
"261 \n",
"262 3.9215151760083 5.93611005938851 5.79213811982895 \n",
"263 14.823594208206 \n",
"264 \n",
"\n",
"0 2011 2012 2013 \\\n",
"1 \n",
"2 4.6968178252385 4.95890140377645 4.85228704838131 \n",
"3 2.01496821504011 4.35011884491608 7.97676918024597 \n",
"4 \n",
"5 \n",
"6 \n",
"7 6.08629581295722 7.12965175228017 6.73555170490737 \n",
"8 1.39559840620402 1.7345487210843 1.73258243136737 \n",
"9 3.42109151341693 3.66922217057882 4.48533892299217 \n",
"10 \n",
"11 \n",
"12 1.968 1.747 1.399 \n",
"13 2.70681550509306 2.81336476630545 2.86654169526513 \n",
"14 \n",
"15 7.39310710399005 8.16828544058576 9.88695195519018 \n",
"16 3.30230175656615 3.73825450719312 4.24497740525735 \n",
"17 \n",
"18 \n",
"19 5.84900153173375 9.72807562789872 8.64185174932391 \n",
"20 14.9736139565097 16.6263209293069 16.8785208328338 \n",
"21 \n",
"22 \n",
"23 11.7997140822193 13.4656882284517 15.1198478740683 \n",
"24 4.15959581162895 5.50187400609008 4.44733135755543 \n",
"25 \n",
"26 \n",
"27 1.64499555407419 1.45359977173878 1.48473224456689 \n",
"28 3.46686409051456 3.44682339262827 2.85728229301093 \n",
"29 \n",
"30 6.03201397638731 5.37615761868223 4.52530200889505 \n",
".. ... ... ... \n",
"235 2.42099970411912 2.33052458084595 2.19164716358291 \n",
"236 \n",
"237 \n",
"238 0 14.3731796444657 10.6057193507607 \n",
"239 4.6968178252385 4.95890140377645 5.57505787931051 \n",
"240 5.10621026773849 6.06755038882137 \n",
"241 6.18622767169789 5.32423289788734 4.18396509854302 \n",
"242 \n",
"243 2.57632211204451 2.7433675978872 2.63627102630174 \n",
"244 \n",
"245 5.39637230168725 6.4018854955144 5.11514486567446 \n",
"246 2.03212772455735 4.05584907416987 5.7568890765564 \n",
"247 14.7322884259186 16.5423303569023 12.8861390797106 \n",
"248 2.9126845602561 3.45084175332667 3.53004504580609 \n",
"249 1.49105441888857 1.32547589221842 1.27694211466818 \n",
"250 3.78150446863877 3.31729162388854 2.45239118205519 \n",
"251 0.709190155100445 0.533310395251817 0.405672371638142 \n",
"252 \n",
"253 \n",
"254 \n",
"255 \n",
"256 2.79209384764477 3.43791016533393 3.10707263260723 \n",
"257 7.82015970798529 7.82678528887575 14.1043951624069 \n",
"258 3.70863914664164 3.69274020433977 4.02772863501631 \n",
"259 \n",
"260 5.66580052766946 7.40082979935601 8.5482461957591 \n",
"261 \n",
"262 4.68085603795407 4.04289179376388 3.6412867248273 \n",
"263 10.3761928815145 8.10539132030299 6.95836227043975 \n",
"264 \n",
"\n",
"0 2014 2015 2016 \n",
"1 \n",
"2 7.7810908959605 12.0536179767696 11.0743789647307 \n",
"3 10.1905320738466 10.6112339715733 \n",
"4 \n",
"5 \n",
"6 \n",
"7 5.63661628252583 5.19506180189675 5.29846353155647 \n",
"8 1.990064383351 1.73684181834171 1.83660554376284 \n",
"9 6.96975042813576 7.94971668385926 6.72411125058909 \n",
"10 \n",
"11 \n",
"12 1.047 0.924 0.979 \n",
"13 3.47337431453068 3.39283728404187 2.69521741465076 \n",
"14 \n",
"15 10.8229150487183 17.9166965111326 21.0565185978806 \n",
"16 4.17569211829305 3.78935142858271 3.43203325193356 \n",
"17 \n",
"18 \n",
"19 9.3655406413084 8.39790781352825 \n",
"20 16.7465294214345 14.612050861519 13.1730655335127 \n",
"21 \n",
"22 \n",
"23 14.1653123764986 13.7084158662801 11.7777190845963 \n",
"24 4.37130403366124 6.83494796382143 12.791174278387 \n",
"25 \n",
"26 \n",
"27 1.50237950472033 1.49992861153731 1.5769576006293 \n",
"28 2.85479995510717 3.31178796015599 3.91663909818561 \n",
"29 \n",
"30 3.85059424062381 0.399835180405115 4.62526313226275 \n",
".. ... ... ... \n",
"235 2.13340352095405 2.22478823868599 2.30165735720531 \n",
"236 \n",
"237 \n",
"238 10.4781361324885 7.64017617486987 4.07173200693191 \n",
"239 7.7810908959605 8.39790781352825 9.62068119899267 \n",
"240 6.08459649451211 6.5581708416557 9.61457507208068 \n",
"241 4.06029704176324 3.40922365291852 3.12500531931932 \n",
"242 \n",
"243 2.74183131997442 2.98772329214314 3.10968373133547 \n",
"244 \n",
"245 6.58398471153915 8.58250269886561 9.60809945919417 \n",
"246 4.01059662166392 5.12695553089331 10.4013107515952 \n",
"247 18.9844230177685 28.0347714697952 30.4682699223548 \n",
"248 3.56658358508436 3.8299205830029 4.12832311760232 \n",
"249 1.27782210089718 1.59817495618485 2.31586181233161 \n",
"250 1.85071180176899 1.47342654864512 1.32052217712119 \n",
"251 0.390536334493127 0.418195139268297 0.43641478412104 \n",
"252 \n",
"253 \n",
"254 \n",
"255 \n",
"256 2.93510795966688 2.33849921547478 \n",
"257 10.72651222798 12.2669904276453 11.5303725603049 \n",
"258 4.06703210187157 4.0890988575673 3.91663909818561 \n",
"259 3.72405853190229 \n",
"260 8.30909888012837 6.15184768358736 \n",
"261 \n",
"262 3.24484669266088 3.12168564309893 2.85780789607925 \n",
"263 6.10431782511365 7.27921009900605 9.66492659101592 \n",
"264 \n",
"\n",
"[264 rows x 11 columns]"
]
},
"execution_count": 76,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = df[[0,1,52,53,54,55,56,57,58,59,60]]\n",
"df.columns = df.iloc[0]\n",
"df.reindex(df.index.drop(0))"
]
},
{
"cell_type": "code",
"execution_count": 139,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"0 Country Name Country Code 2008 2009 2010 2011 2012 2013 2014 2015 2016\n",
"128 Lao PDR LAO \n"
]
}
],
"source": [
"print(df[df['Country Name'] == 'Lao PDR'])\n",
"ASEAN = ['Vietnam', 'Thailand', 'Indonesia', 'Singapore', 'Malaysia', 'Philippines', 'Cambodia', 'Myanmar', 'Lao PDR', 'Brunei Darussalam', 'Timor-Leste']"
]
},
{
"cell_type": "code",
"execution_count": 142,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'list'>\n"
]
},
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Country Name</th>\n",
" <th>Country Code</th>\n",
" <th>2008</th>\n",
" <th>2009</th>\n",
" <th>2010</th>\n",
" <th>2011</th>\n",
" <th>2012</th>\n",
" <th>2013</th>\n",
" <th>2014</th>\n",
" <th>2015</th>\n",
" <th>2016</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>256</th>\n",
" <td>Vietnam</td>\n",
" <td>VNM</td>\n",
" <td>2.15099820496032</td>\n",
" <td>1.79656609383679</td>\n",
" <td>2.09259938242</td>\n",
" <td>2.79209384764477</td>\n",
" <td>3.43791016533393</td>\n",
" <td>3.10707263260723</td>\n",
" <td>2.93510795966688</td>\n",
" <td>2.33849921547478</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>232</th>\n",
" <td>Thailand</td>\n",
" <td>THA</td>\n",
" <td>5.59879211346277</td>\n",
" <td>5.22061861150825</td>\n",
" <td>3.88785784505743</td>\n",
" <td>2.93261853635558</td>\n",
" <td>2.43018679665442</td>\n",
" <td>2.30382713124504</td>\n",
" <td>2.305232984074</td>\n",
" <td>2.6828308673521</td>\n",
" <td>2.98569607594999</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>Indonesia</td>\n",
" <td>IDN</td>\n",
" <td>3.18971629952475</td>\n",
" <td>3.28838738104322</td>\n",
" <td>2.53187560750083</td>\n",
" <td>2.14412680479297</td>\n",
" <td>1.77338188532309</td>\n",
" <td>1.68676678017478</td>\n",
" <td>2.0668174536709</td>\n",
" <td>2.43104248114155</td>\n",
" <td>2.89634913035996</td>\n",
" </tr>\n",
" <tr>\n",
" <th>207</th>\n",
" <td>Singapore</td>\n",
" <td>SGP</td>\n",
" <td>1.42549965541006</td>\n",
" <td>2.03438434173328</td>\n",
" <td>1.40635425755787</td>\n",
" <td>1.06045560853893</td>\n",
" <td>1.04262808908742</td>\n",
" <td>0.866941606339939</td>\n",
" <td>0.756532862271537</td>\n",
" <td>0.92406290512104</td>\n",
" <td>1.22253307180161</td>\n",
" </tr>\n",
" <tr>\n",
" <th>168</th>\n",
" <td>Malaysia</td>\n",
" <td>MYS</td>\n",
" <td>4.8081809717361</td>\n",
" <td>3.62656549307932</td>\n",
" <td>3.35402670735158</td>\n",
" <td>2.6813903080324</td>\n",
" <td>2.01584311320696</td>\n",
" <td>1.84914657141208</td>\n",
" <td>1.64578545979143</td>\n",
" <td>1.60139095442719</td>\n",
" <td>1.61189739525395</td>\n",
" </tr>\n",
" <tr>\n",
" <th>186</th>\n",
" <td>Philippines</td>\n",
" <td>PHL</td>\n",
" <td></td>\n",
" <td>3.48947494826148</td>\n",
" <td>3.38074340505264</td>\n",
" <td>2.55545771909276</td>\n",
" <td>2.22289481153936</td>\n",
" <td>2.44086452225225</td>\n",
" <td>2.02468665436274</td>\n",
" <td>1.88547820763544</td>\n",
" <td>1.7158480997</td>\n",
" </tr>\n",
" <tr>\n",
" <th>122</th>\n",
" <td>Cambodia</td>\n",
" <td>KHM</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>3.14187854787214</td>\n",
" <td>2.29438855572053</td>\n",
" <td>2.22469008934459</td>\n",
" <td>2.30267771735678</td>\n",
" <td>1.62133907710753</td>\n",
" <td>1.59273995602264</td>\n",
" <td>2.13063064162181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159</th>\n",
" <td>Myanmar</td>\n",
" <td>MMR</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>128</th>\n",
" <td>Lao PDR</td>\n",
" <td>LAO</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Brunei Darussalam</td>\n",
" <td>BRN</td>\n",
" <td></td>\n",
" <td>9.36467132030001</td>\n",
" <td>6.86702975926534</td>\n",
" <td>6.03201397638731</td>\n",
" <td>5.37615761868223</td>\n",
" <td>4.52530200889505</td>\n",
" <td>3.85059424062381</td>\n",
" <td>0.399835180405115</td>\n",
" <td>4.62526313226275</td>\n",
" </tr>\n",
" <tr>\n",
" <th>236</th>\n",
" <td>Timor-Leste</td>\n",
" <td>TLS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"0 Country Name Country Code 2008 2009 \\\n",
"256 Vietnam VNM 2.15099820496032 1.79656609383679 \n",
"232 Thailand THA 5.59879211346277 5.22061861150825 \n",
"105 Indonesia IDN 3.18971629952475 3.28838738104322 \n",
"207 Singapore SGP 1.42549965541006 2.03438434173328 \n",
"168 Malaysia MYS 4.8081809717361 3.62656549307932 \n",
"186 Philippines PHL 3.48947494826148 \n",
"122 Cambodia KHM \n",
"159 Myanmar MMR \n",
"128 Lao PDR LAO \n",
"30 Brunei Darussalam BRN 9.36467132030001 \n",
"236 Timor-Leste TLS \n",
"\n",
"0 2010 2011 2012 2013 \\\n",
"256 2.09259938242 2.79209384764477 3.43791016533393 3.10707263260723 \n",
"232 3.88785784505743 2.93261853635558 2.43018679665442 2.30382713124504 \n",
"105 2.53187560750083 2.14412680479297 1.77338188532309 1.68676678017478 \n",
"207 1.40635425755787 1.06045560853893 1.04262808908742 0.866941606339939 \n",
"168 3.35402670735158 2.6813903080324 2.01584311320696 1.84914657141208 \n",
"186 3.38074340505264 2.55545771909276 2.22289481153936 2.44086452225225 \n",
"122 3.14187854787214 2.29438855572053 2.22469008934459 2.30267771735678 \n",
"159 \n",
"128 \n",
"30 6.86702975926534 6.03201397638731 5.37615761868223 4.52530200889505 \n",
"236 \n",
"\n",
"0 2014 2015 2016 \n",
"256 2.93510795966688 2.33849921547478 \n",
"232 2.305232984074 2.6828308673521 2.98569607594999 \n",
"105 2.0668174536709 2.43104248114155 2.89634913035996 \n",
"207 0.756532862271537 0.92406290512104 1.22253307180161 \n",
"168 1.64578545979143 1.60139095442719 1.61189739525395 \n",
"186 2.02468665436274 1.88547820763544 1.7158480997 \n",
"122 1.62133907710753 1.59273995602264 2.13063064162181 \n",
"159 \n",
"128 \n",
"30 3.85059424062381 0.399835180405115 4.62526313226275 \n",
"236 "
]
},
"execution_count": 142,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ASEAN_data = []\n",
"print(type(ASEAN_data))\n",
"\n",
"for country in ASEAN:\n",
" ASEAN_data.append(df[df['Country Name'] == country])\n",
"\n",
"\n",
"ASEAN_df = pd.concat(ASEAN_data)\n",
"ASEAN_df"
]
},
{
"cell_type": "code",
"execution_count": 145,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Country Name</th>\n",
" <th>Country Code</th>\n",
" <th>2008</th>\n",
" <th>2009</th>\n",
" <th>2010</th>\n",
" <th>2011</th>\n",
" <th>2012</th>\n",
" <th>2013</th>\n",
" <th>2014</th>\n",
" <th>2015</th>\n",
" <th>2016</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>256</th>\n",
" <td>Vietnam</td>\n",
" <td>VNM</td>\n",
" <td>2.15099820496032</td>\n",
" <td>1.79656609383679</td>\n",
" <td>2.09259938242</td>\n",
" <td>2.79209384764477</td>\n",
" <td>3.43791016533393</td>\n",
" <td>3.10707263260723</td>\n",
" <td>2.93510795966688</td>\n",
" <td>2.33849921547478</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>232</th>\n",
" <td>Thailand</td>\n",
" <td>THA</td>\n",
" <td>5.59879211346277</td>\n",
" <td>5.22061861150825</td>\n",
" <td>3.88785784505743</td>\n",
" <td>2.93261853635558</td>\n",
" <td>2.43018679665442</td>\n",
" <td>2.30382713124504</td>\n",
" <td>2.305232984074</td>\n",
" <td>2.6828308673521</td>\n",
" <td>2.98569607594999</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>Indonesia</td>\n",
" <td>IDN</td>\n",
" <td>3.18971629952475</td>\n",
" <td>3.28838738104322</td>\n",
" <td>2.53187560750083</td>\n",
" <td>2.14412680479297</td>\n",
" <td>1.77338188532309</td>\n",
" <td>1.68676678017478</td>\n",
" <td>2.0668174536709</td>\n",
" <td>2.43104248114155</td>\n",
" <td>2.89634913035996</td>\n",
" </tr>\n",
" <tr>\n",
" <th>207</th>\n",
" <td>Singapore</td>\n",
" <td>SGP</td>\n",
" <td>1.42549965541006</td>\n",
" <td>2.03438434173328</td>\n",
" <td>1.40635425755787</td>\n",
" <td>1.06045560853893</td>\n",
" <td>1.04262808908742</td>\n",
" <td>0.866941606339939</td>\n",
" <td>0.756532862271537</td>\n",
" <td>0.92406290512104</td>\n",
" <td>1.22253307180161</td>\n",
" </tr>\n",
" <tr>\n",
" <th>168</th>\n",
" <td>Malaysia</td>\n",
" <td>MYS</td>\n",
" <td>4.8081809717361</td>\n",
" <td>3.62656549307932</td>\n",
" <td>3.35402670735158</td>\n",
" <td>2.6813903080324</td>\n",
" <td>2.01584311320696</td>\n",
" <td>1.84914657141208</td>\n",
" <td>1.64578545979143</td>\n",
" <td>1.60139095442719</td>\n",
" <td>1.61189739525395</td>\n",
" </tr>\n",
" <tr>\n",
" <th>186</th>\n",
" <td>Philippines</td>\n",
" <td>PHL</td>\n",
" <td></td>\n",
" <td>3.48947494826148</td>\n",
" <td>3.38074340505264</td>\n",
" <td>2.55545771909276</td>\n",
" <td>2.22289481153936</td>\n",
" <td>2.44086452225225</td>\n",
" <td>2.02468665436274</td>\n",
" <td>1.88547820763544</td>\n",
" <td>1.7158480997</td>\n",
" </tr>\n",
" <tr>\n",
" <th>122</th>\n",
" <td>Cambodia</td>\n",
" <td>KHM</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>3.14187854787214</td>\n",
" <td>2.29438855572053</td>\n",
" <td>2.22469008934459</td>\n",
" <td>2.30267771735678</td>\n",
" <td>1.62133907710753</td>\n",
" <td>1.59273995602264</td>\n",
" <td>2.13063064162181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>159</th>\n",
" <td>Myanmar</td>\n",
" <td>MMR</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>128</th>\n",
" <td>Lao PDR</td>\n",
" <td>LAO</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Brunei Darussalam</td>\n",
" <td>BRN</td>\n",
" <td></td>\n",
" <td>9.36467132030001</td>\n",
" <td>6.86702975926534</td>\n",
" <td>6.03201397638731</td>\n",
" <td>5.37615761868223</td>\n",
" <td>4.52530200889505</td>\n",
" <td>3.85059424062381</td>\n",
" <td>0.399835180405115</td>\n",
" <td>4.62526313226275</td>\n",
" </tr>\n",
" <tr>\n",
" <th>236</th>\n",
" <td>Timor-Leste</td>\n",
" <td>TLS</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"0 Country Name Country Code 2008 2009 \\\n",
"256 Vietnam VNM 2.15099820496032 1.79656609383679 \n",
"232 Thailand THA 5.59879211346277 5.22061861150825 \n",
"105 Indonesia IDN 3.18971629952475 3.28838738104322 \n",
"207 Singapore SGP 1.42549965541006 2.03438434173328 \n",
"168 Malaysia MYS 4.8081809717361 3.62656549307932 \n",
"186 Philippines PHL 3.48947494826148 \n",
"122 Cambodia KHM \n",
"159 Myanmar MMR \n",
"128 Lao PDR LAO \n",
"30 Brunei Darussalam BRN 9.36467132030001 \n",
"236 Timor-Leste TLS \n",
"\n",
"0 2010 2011 2012 2013 \\\n",
"256 2.09259938242 2.79209384764477 3.43791016533393 3.10707263260723 \n",
"232 3.88785784505743 2.93261853635558 2.43018679665442 2.30382713124504 \n",
"105 2.53187560750083 2.14412680479297 1.77338188532309 1.68676678017478 \n",
"207 1.40635425755787 1.06045560853893 1.04262808908742 0.866941606339939 \n",
"168 3.35402670735158 2.6813903080324 2.01584311320696 1.84914657141208 \n",
"186 3.38074340505264 2.55545771909276 2.22289481153936 2.44086452225225 \n",
"122 3.14187854787214 2.29438855572053 2.22469008934459 2.30267771735678 \n",
"159 \n",
"128 \n",
"30 6.86702975926534 6.03201397638731 5.37615761868223 4.52530200889505 \n",
"236 \n",
"\n",
"0 2014 2015 2016 \n",
"256 2.93510795966688 2.33849921547478 \n",
"232 2.305232984074 2.6828308673521 2.98569607594999 \n",
"105 2.0668174536709 2.43104248114155 2.89634913035996 \n",
"207 0.756532862271537 0.92406290512104 1.22253307180161 \n",
"168 1.64578545979143 1.60139095442719 1.61189739525395 \n",
"186 2.02468665436274 1.88547820763544 1.7158480997 \n",
"122 1.62133907710753 1.59273995602264 2.13063064162181 \n",
"159 \n",
"128 \n",
"30 3.85059424062381 0.399835180405115 4.62526313226275 \n",
"236 "
]
},
"execution_count": 145,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ASEAN_df.dropna()"
]
},
{
"cell_type": "code",
"execution_count": 179,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Vietnam</th>\n",
" <th>Thailand</th>\n",
" <th>Indonesia</th>\n",
" <th>Singapore</th>\n",
" <th>Malaysia</th>\n",
" <th>Philippines</th>\n",
" <th>Cambodia</th>\n",
" <th>Myanmar</th>\n",
" <th>Lao PDR</th>\n",
" <th>Brunei Darussalam</th>\n",
" <th>Timor-Leste</th>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Country Name</th>\n",
" <td>Vietnam</td>\n",
" <td>Thailand</td>\n",
" <td>Indonesia</td>\n",
" <td>Singapore</td>\n",
" <td>Malaysia</td>\n",
" <td>Philippines</td>\n",
" <td>Cambodia</td>\n",
" <td>Myanmar</td>\n",
" <td>Lao PDR</td>\n",
" <td>Brunei Darussalam</td>\n",
" <td>Timor-Leste</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Country Code</th>\n",
" <td>VNM</td>\n",
" <td>THA</td>\n",
" <td>IDN</td>\n",
" <td>SGP</td>\n",
" <td>MYS</td>\n",
" <td>PHL</td>\n",
" <td>KHM</td>\n",
" <td>MMR</td>\n",
" <td>LAO</td>\n",
" <td>BRN</td>\n",
" <td>TLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2008</th>\n",
" <td>2.15099820496032</td>\n",
" <td>5.59879211346277</td>\n",
" <td>3.18971629952475</td>\n",
" <td>1.42549965541006</td>\n",
" <td>4.8081809717361</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2009</th>\n",
" <td>1.79656609383679</td>\n",
" <td>5.22061861150825</td>\n",
" <td>3.28838738104322</td>\n",
" <td>2.03438434173328</td>\n",
" <td>3.62656549307932</td>\n",
" <td>3.48947494826148</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>9.36467132030001</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2010</th>\n",
" <td>2.09259938242</td>\n",
" <td>3.88785784505743</td>\n",
" <td>2.53187560750083</td>\n",
" <td>1.40635425755787</td>\n",
" <td>3.35402670735158</td>\n",
" <td>3.38074340505264</td>\n",
" <td>3.14187854787214</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>6.86702975926534</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2011</th>\n",
" <td>2.79209384764477</td>\n",
" <td>2.93261853635558</td>\n",
" <td>2.14412680479297</td>\n",
" <td>1.06045560853893</td>\n",
" <td>2.6813903080324</td>\n",
" <td>2.55545771909276</td>\n",
" <td>2.29438855572053</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>6.03201397638731</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2012</th>\n",
" <td>3.43791016533393</td>\n",
" <td>2.43018679665442</td>\n",
" <td>1.77338188532309</td>\n",
" <td>1.04262808908742</td>\n",
" <td>2.01584311320696</td>\n",
" <td>2.22289481153936</td>\n",
" <td>2.22469008934459</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>5.37615761868223</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2013</th>\n",
" <td>3.10707263260723</td>\n",
" <td>2.30382713124504</td>\n",
" <td>1.68676678017478</td>\n",
" <td>0.866941606339939</td>\n",
" <td>1.84914657141208</td>\n",
" <td>2.44086452225225</td>\n",
" <td>2.30267771735678</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>4.52530200889505</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2014</th>\n",
" <td>2.93510795966688</td>\n",
" <td>2.305232984074</td>\n",
" <td>2.0668174536709</td>\n",
" <td>0.756532862271537</td>\n",
" <td>1.64578545979143</td>\n",
" <td>2.02468665436274</td>\n",
" <td>1.62133907710753</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>3.85059424062381</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2015</th>\n",
" <td>2.33849921547478</td>\n",
" <td>2.6828308673521</td>\n",
" <td>2.43104248114155</td>\n",
" <td>0.92406290512104</td>\n",
" <td>1.60139095442719</td>\n",
" <td>1.88547820763544</td>\n",
" <td>1.59273995602264</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0.399835180405115</td>\n",
" <td></td>\n",
" </tr>\n",
" <tr>\n",
" <th>2016</th>\n",
" <td></td>\n",
" <td>2.98569607594999</td>\n",
" <td>2.89634913035996</td>\n",
" <td>1.22253307180161</td>\n",
" <td>1.61189739525395</td>\n",
" <td>1.7158480997</td>\n",
" <td>2.13063064162181</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>4.62526313226275</td>\n",
" <td></td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Vietnam Thailand Indonesia \\\n",
"0 \n",
"Country Name Vietnam Thailand Indonesia \n",
"Country Code VNM THA IDN \n",
"2008 2.15099820496032 5.59879211346277 3.18971629952475 \n",
"2009 1.79656609383679 5.22061861150825 3.28838738104322 \n",
"2010 2.09259938242 3.88785784505743 2.53187560750083 \n",
"2011 2.79209384764477 2.93261853635558 2.14412680479297 \n",
"2012 3.43791016533393 2.43018679665442 1.77338188532309 \n",
"2013 3.10707263260723 2.30382713124504 1.68676678017478 \n",
"2014 2.93510795966688 2.305232984074 2.0668174536709 \n",
"2015 2.33849921547478 2.6828308673521 2.43104248114155 \n",
"2016 2.98569607594999 2.89634913035996 \n",
"\n",
" Singapore Malaysia Philippines \\\n",
"0 \n",
"Country Name Singapore Malaysia Philippines \n",
"Country Code SGP MYS PHL \n",
"2008 1.42549965541006 4.8081809717361 \n",
"2009 2.03438434173328 3.62656549307932 3.48947494826148 \n",
"2010 1.40635425755787 3.35402670735158 3.38074340505264 \n",
"2011 1.06045560853893 2.6813903080324 2.55545771909276 \n",
"2012 1.04262808908742 2.01584311320696 2.22289481153936 \n",
"2013 0.866941606339939 1.84914657141208 2.44086452225225 \n",
"2014 0.756532862271537 1.64578545979143 2.02468665436274 \n",
"2015 0.92406290512104 1.60139095442719 1.88547820763544 \n",
"2016 1.22253307180161 1.61189739525395 1.7158480997 \n",
"\n",
" Cambodia Myanmar Lao PDR Brunei Darussalam \\\n",
"0 \n",
"Country Name Cambodia Myanmar Lao PDR Brunei Darussalam \n",
"Country Code KHM MMR LAO BRN \n",
"2008 \n",
"2009 9.36467132030001 \n",
"2010 3.14187854787214 6.86702975926534 \n",
"2011 2.29438855572053 6.03201397638731 \n",
"2012 2.22469008934459 5.37615761868223 \n",
"2013 2.30267771735678 4.52530200889505 \n",
"2014 1.62133907710753 3.85059424062381 \n",
"2015 1.59273995602264 0.399835180405115 \n",
"2016 2.13063064162181 4.62526313226275 \n",
"\n",
" Timor-Leste \n",
"0 \n",
"Country Name Timor-Leste \n",
"Country Code TLS \n",
"2008 \n",
"2009 \n",
"2010 \n",
"2011 \n",
"2012 \n",
"2013 \n",
"2014 \n",
"2015 \n",
"2016 "
]
},
"execution_count": 179,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ASEAN_T = ASEAN_df.T\n",
"ASEAN_T.columns = ASEAN\n",
"ASEAN_T"
]
},
{
"cell_type": "code",
"execution_count": 193,
"metadata": {},
"outputs": [],
"source": [
"years = ASEAN_T.index[2:11]"
]
},
{
"cell_type": "code",
"execution_count": 194,
"metadata": {},
"outputs": [
{
"ename": "ValueError",
"evalue": "x and y must have same first dimension, but have shapes (9,) and (11,)",
"output_type": "error",
"traceback": [
"\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
"\u001b[0;31mValueError\u001b[0m Traceback (most recent call last)",
"\u001b[0;32m<ipython-input-194-34f6a1155c1c>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mplt\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mplot\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0myears\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'Vietnam'\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mASEAN_T\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/matplotlib/pyplot.py\u001b[0m in \u001b[0;36mplot\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m 3238\u001b[0m mplDeprecation)\n\u001b[1;32m 3239\u001b[0m \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3240\u001b[0;31m \u001b[0mret\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0max\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mplot\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 3241\u001b[0m \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 3242\u001b[0m \u001b[0max\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_hold\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mwashold\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
"\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/matplotlib/__init__.py\u001b[0m in \u001b[0;36minner\u001b[0;34m(ax, *args, **kwargs)\u001b[0m\n\u001b[1;32m 1708\u001b[0m warnings.warn(msg % (label_namer, func.__name__),\n\u001b[1;32m 1709\u001b[0m RuntimeWarning, stacklevel=2)\n\u001b[0;32m-> 1710\u001b[0;31m \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0max\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 1711\u001b[0m \u001b[0mpre_doc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0minner\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__doc__\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 1712\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0mpre_doc\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
"\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/matplotlib/axes/_axes.py\u001b[0m in \u001b[0;36mplot\u001b[0;34m(self, *args, **kwargs)\u001b[0m\n\u001b[1;32m 1435\u001b[0m \u001b[0mkwargs\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcbook\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnormalize_kwargs\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0m_alias_map\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 1436\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1437\u001b[0;31m \u001b[0;32mfor\u001b[0m \u001b[0mline\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_lines\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 1438\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0madd_line\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mline\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 1439\u001b[0m \u001b[0mlines\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mline\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
"\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/matplotlib/axes/_base.py\u001b[0m in \u001b[0;36m_grab_next_args\u001b[0;34m(self, *args, **kwargs)\u001b[0m\n\u001b[1;32m 402\u001b[0m \u001b[0mthis\u001b[0m \u001b[0;34m+=\u001b[0m \u001b[0margs\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 403\u001b[0m \u001b[0margs\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0margs\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 404\u001b[0;31m \u001b[0;32mfor\u001b[0m \u001b[0mseg\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_plot_args\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mthis\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 405\u001b[0m \u001b[0;32myield\u001b[0m \u001b[0mseg\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 406\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
"\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/matplotlib/axes/_base.py\u001b[0m in \u001b[0;36m_plot_args\u001b[0;34m(self, tup, kwargs)\u001b[0m\n\u001b[1;32m 382\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mindex_of\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtup\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 383\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 384\u001b[0;31m \u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_xy_from_xy\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 385\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 386\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcommand\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;34m'plot'\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
"\u001b[0;32m/Applications/anaconda3/lib/python3.6/site-packages/matplotlib/axes/_base.py\u001b[0m in \u001b[0;36m_xy_from_xy\u001b[0;34m(self, x, y)\u001b[0m\n\u001b[1;32m 241\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mshape\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0my\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mshape\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 242\u001b[0m raise ValueError(\"x and y must have same first dimension, but \"\n\u001b[0;32m--> 243\u001b[0;31m \"have shapes {} and {}\".format(x.shape, y.shape))\n\u001b[0m\u001b[1;32m 244\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mndim\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m2\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0my\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mndim\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m2\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 245\u001b[0m raise ValueError(\"x and y can be no greater than 2-D, but have \"\n",
"\u001b[0;31mValueError\u001b[0m: x and y must have same first dimension, but have shapes (9,) and (11,)"
]
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAcIAAAD3CAYAAACO2FTvAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAADudJREFUeJzt3HlsVPXex/HPdLpQGWpbLFEoLS00\nBEIwDqSoCApigEQoWJCwFAkKskRFKBbaYmu6UJUlssRQY4AYgyFVCMgSScsSqQhl0UDAKAESlhCk\nbei+/p4/bu4kPM+9ck1B7uP3/frvzEznnPM7ye895zfNeJxzTgAAGBX0sA8AAICHiRACAEwjhAAA\n0wghAMA0QggAMI0QAgBMC/5PXvTTTz9p1apV+uKLLwKP3bp1S4sXLw5snz9/XkuWLNHYsWO1dOlS\n1dbWKjIyUvn5+eratat+/vlnFRUVyTmnmJgYffzxxwoLC9OECRPUpUsXSVJsbKxWrlypK1euKCcn\nRy0tLQoNDdWaNWsUFRWlb775Rtu2bVNbW5tefPFFLVy4UJWVlUpPT1djY6O6deumlStXKjw8XMXF\nxdqzZ498Pp/eeOMNjRgxQrdu3VJ6erpaWloUExOjoqIihYeHa9euXdq8ebOCgoKUmpqqadOmqa2t\nTdnZ2bp06ZK8Xq9WrlypuLg43b59W9nZ2bpz547a2tr00Ucfqa6uToWFhYGxOHPmjDZu3KiEhAQt\nW7ZMzjl1795deXl5Cg8Pv1/XDgBwP7h7KC4udi+//LKbPHnyv33NqVOnXFpammttbXVFRUXu008/\ndc45d/ToUZeZmena29vd+PHj3eXLl51zzm3fvt1dvHjRNTY2upSUlP/zfmlpae706dPOOef279/v\nTp065a5cueImTZrkGhoaXFtbm1u7dq1rbm52eXl57uuvv3bOObdp0ya3efNmd+HCBTdu3DjX2Njo\nGhsb3YQJE1x9fb3Lz893O3bscM45t27dOrd582bnnHNDhw51VVVVrqmpyY0aNcpVV1e7AwcOuGXL\nljnnnDt27JibN2+ec865jIwMt2fPHueccz/88IM7ePDgXce+d+9et3jxYuecc2+99ZbbtWtX4Jw3\nbtx4r+EGAPzF7rk0GhcXp/Xr1/9RSJWXl6fc3Fx5vV799ttvGj58uCTJ7/fr5MmTunTpkiIjI7V1\n61bNmDFD1dXVSkxM1IULF9TQ0KDZs2dr5syZOnPmjBobG1VZWamDBw8qLS1NZ86c0cCBA1VeXq4B\nAwYoIyNDM2bMkN/vV0hIiE6ePKlhw4ZJkoYPH67y8nJdvHhRycnJCgsLU1hYmOLj4/XLL78oMzNT\n48ePV3t7u27cuKGuXbtKkvr27auamho1NzfLOSePx6NRo0YpLy9PknT9+nU99thjkqRTp07p5s2b\nmjVrlnbv3q3k5OTAWNTX12v9+vXKysqSpH85FgCA/y73XBodPXq0rl69+m+fLysrU1JSkhITEyVJ\n/fr1U1lZmfr376+ysjI1NjaqqqpKp0+f1ooVKxQfH6958+ZpwIABio6O1uuvv67Jkyfr8uXLmjNn\njrZu3apff/1V2dnZWrRokbKysrRjxw5VVVWpoqJC27ZtU1NTk6ZOnaqSkhLV1tYGllY7d+6smpoa\n9e3bV8XFxaqtrVVLS4tOnz6tKVOmyOPxqLW1VSkpKWpqatLChQslSUlJSUpNTVV4eLheeuklRURE\n/GNwgoOVkZGhAwcOaN26dZKka9euKSIiQlu2bNGGDRv02Wef6Z133pEklZSUaMyYMYqOjr5rLCZO\nnKjS0lI1NDT8yzFsbW0Tv+8DAH9OSIj3vrzPf/Qd4R/ZtWuXZs6cGdieO3euCgoKNGvWLA0bNkyP\nP/64IiMjFR8frz59+kiShg0bprNnz+q1115TfHy8PB6PEhISFBkZqaCgIHXu3FlPP/20JGnEiBE6\nevSo+vbtq+TkZPl8Pvl8PvXu3VuXL1+Wz+dTXV2dOnXqpLq6OkVERKh3796aPn265syZo/j4eD35\n5JOKioqSJIWEhGjv3r0qLy9XRkaGsrOzdejQIZWWluqRRx7R0qVLtW/fPo0dO1aS9OGHHyo9PV2v\nvvqq9uzZo8jISI0cOVKSNHLkSK1duzZw7rt37w4EU5IyMjKUl5enb7/9Vs8880zgGP4356Tq6vqO\nXgoAMCUmpst9eZ8O/9fouXPn5Pf7A9sVFRVKSUnRli1bFBsbK7/fr549e6qurk5XrlwJvCYpKUkl\nJSUqKiqSJN28eVO1tbWKiYlRr169VFFRIUk6ceKEkpKS5Pf7dfz4cTU1Nam+vl4XL15UXFyc/H6/\nDh8+LEk6cuSIBg0apMrKSlVVVWnbtm3KysrSjRs3lJSUpNzcXB07dkzSP+4ePR6PunTpok6dOiks\nLExer1fR0dG6c+eOdu7cqU2bNkmSwsPD5fF45PV6NWjQoMD+Tpw4EYj7P5dWn3jiicBYlJeXa+HC\nhfr8888VFBSkZ599tqPDDQC4z/70HeHu3btVX1+vKVOmqLKyMhCUf0pISFBGRoYkqVu3biosLFRo\naKgKCgq0ZMkSOef01FNP6YUXXlBzc7OWL1+uqVOnyuPxqLCwUMHBwSosLNQHH3ygtrY2xcbGKj09\nXaGhoUpNTdXUqVPlnNOCBQsUGRmp+fPnKyMjQ9u3b1dUVJRWr16t8PBwXb16VampqQoJCdF7770n\nr9ertLQ05ebmauPGjQoKClJubq569OihKVOmaNq0aQoJCVFcXJwmTpyo1tZWLV++XNOnT1dra6sy\nMzMVFhYWuIv86quv5PP5tHr1aknSpUuX1KNHj7vGKiEhQZmZmQoNDVVSUpLef//9jlwrAMAD4HGO\nb6cetpaWNpZGAeBP+q9ZGgUA4P8zQggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTCCEA\nwDRCCAAwjRACAEwjhAAA0wghAMA0QggAMI0QAgBMI4QAANMIIQDANEIIADCNEAIATCOEAADTPM45\n97APAgCAh4U7QgCAaYQQAGAaIQQAmEYIAQCmBT/sA/i7amlpUWZmpq5du6bm5mbNnz9fffr00bJl\ny+TxeJSUlKScnBwFBQVpw4YNOnTokIKDg5WZmamBAwfq/PnzysnJkdfrVa9evVRQUKCgID63APh7\n6+jcee7cOeXk5Cg0NFT9+vVTVlbWvedOhweipKTE5efnO+ecq6ysdM8//7x788033bFjx5xzzq1Y\nscJ999137uzZsy4tLc21t7e7a9euuVdeecU559yCBQvcoUOHnHPOLV682JWWlj6cEwGAv1BH586J\nEye6kydPOuecW7Nmjdu5c+c998kd4QMyZswYjR49OrDt9Xp17tw5JScnS5KGDx+uo0ePKiEhQc89\n95w8Ho+6d++utrY2VVZWql+/fqqurpZzTnV1dQoO5lIB+Pvr6Nx58+ZN+f1+SZLf71dpaalSUlL+\ncJ+stT0gnTt3ls/nU21trd5++20tWrRIzjl5PJ7A8zU1NaqtrZXP57vr72pqagLLoWPHjtXt27c1\nZMiQh3UqAPCX6ejc2bNnTx0/flySdPDgQTU0NNxzn4TwAbpx44ZmzpyplJQUjRs37q516rq6OkVE\nRMjn86muru6ux7t06aKCggJ9+eWX2r9/vyZMmKCioqKHcQoA8JfryNxZWFioTZs2ae7cuerataui\noqLuuT9C+ID8/vvvmj17tpYuXapJkyZJkvr3768ff/xRknTkyBENHjxYfr9f33//vdrb23X9+nW1\nt7crOjpajz76aODTTrdu3XTnzp2Hdi4A8Ffp6Nx5+PBhFRYWqri4WNXV1Ro6dOg998lPrD0g+fn5\n2rdvnxITEwOPZWVlKT8/Xy0tLUpMTFR+fr68Xq/Wr1+vI0eOqL29XcuXL9fgwYNVUVGhVatWKTg4\nWCEhIcrLy1NsbOxDPCMAePA6OneWlZXpk08+UXh4uIYMGaJ33333nvskhAAA01gaBQCYRggBAKYR\nQgCAaYQQAGAaIQQAmEYIAQCmEUIAgGn/AwChOeUSLghjAAAAAElFTkSuQmCC\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x1a22175080>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"plt.plot(years,'Vietnam',data = ASEAN_T)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment