In [1]:
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

from matplotlib.ticker import ScalarFormatter, FormatStrFormatter

In [2]:
!ls #verificar el fichero a ser importado
fichero_pop_total = 'API_SP.POP.TOTL_DS2_es_csv_v2.csv'


API_SP.POP.TOTL_DS2_es_csv_v2.csv
clase 1 - Intro padas Series y DataFrame.ipynb
clase 2 - Importar y exportar data.ipynb
clase 3 - plotting con pandas.ipynb
ficheroexcelsalida.xlsx

In [3]:
dfpoptotal = pd.read_csv(fichero_pop_total,sep=',',header=1,skiprows=2) #Lee un fichero csv

In [4]:
del dfpoptotal['Indicator Name']
del dfpoptotal['Indicator Code']
del dfpoptotal['2016']
del dfpoptotal['Unnamed: 61']
#dfpoptotal=dfpoptotal['Indicator Name','Indicator Code','2016','Unnamed: 61'].drop
dfpoptotal


Out[4]:
Country Name Country Code 1960 1961 1962 1963 1964 1965 1966 1967 ... 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
0 Aruba ABW 5.420800e+04 5.543500e+04 5.622600e+04 5.669700e+04 5.702900e+04 5.736000e+04 5.771200e+04 5.804900e+04 ... 1.008300e+05 1.012180e+05 1.013420e+05 1.014160e+05 1.015970e+05 1.019360e+05 1.023930e+05 1.029210e+05 1.034410e+05 1.038890e+05
1 Afganistán AFG 8.994793e+06 9.164945e+06 9.343772e+06 9.531555e+06 9.728645e+06 9.935358e+06 1.014884e+07 1.036860e+07 ... 2.518362e+07 2.587754e+07 2.652874e+07 2.720729e+07 2.796221e+07 2.880917e+07 2.972680e+07 3.068250e+07 3.162751e+07 3.252656e+07
2 Angola AGO 5.270844e+06 5.367287e+06 5.465905e+06 5.565808e+06 5.665701e+06 5.765025e+06 5.863568e+06 5.962831e+06 ... 1.854147e+07 1.918391e+07 1.984225e+07 2.052010e+07 2.121995e+07 2.194230e+07 2.268563e+07 2.344820e+07 2.422752e+07 2.502197e+07
3 Albania ALB 1.608800e+06 1.659800e+06 1.711319e+06 1.762621e+06 1.814135e+06 1.864791e+06 1.914573e+06 1.965598e+06 ... 2.992547e+06 2.970017e+06 2.947314e+06 2.927519e+06 2.913021e+06 2.904780e+06 2.900247e+06 2.896652e+06 2.893654e+06 2.889167e+06
4 Andorra AND 1.341400e+04 1.437600e+04 1.537600e+04 1.641000e+04 1.747000e+04 1.855100e+04 1.964600e+04 2.075500e+04 ... 8.337300e+04 8.487800e+04 8.561600e+04 8.547400e+04 8.441900e+04 8.232600e+04 7.931600e+04 7.590200e+04 7.278600e+04 7.047300e+04
5 El mundo árabe ARB 9.254053e+07 9.507799e+07 9.771119e+07 1.004394e+08 1.032637e+08 1.061841e+08 1.092107e+08 1.123426e+08 ... 3.209067e+08 3.287666e+08 3.368865e+08 3.450542e+08 3.531122e+08 3.610318e+08 3.688026e+08 3.765043e+08 3.842226e+08 3.920223e+08
6 Emiratos Árabes Unidos ARE 9.261200e+04 1.009850e+05 1.122400e+05 1.252160e+05 1.382200e+05 1.503180e+05 1.610770e+05 1.717810e+05 ... 5.171255e+06 6.010100e+06 6.900142e+06 7.705423e+06 8.329453e+06 8.734722e+06 8.952542e+06 9.039978e+06 9.086139e+06 9.156963e+06
7 Argentina ARG 2.061908e+07 2.095308e+07 2.128768e+07 2.162184e+07 2.195393e+07 2.228339e+07 2.260875e+07 2.293220e+07 ... 3.955875e+07 3.996990e+07 4.038186e+07 4.079864e+07 4.122288e+07 4.165562e+07 4.209522e+07 4.253830e+07 4.298003e+07 4.341676e+07
8 Armenia ARM 1.867396e+06 1.934239e+06 2.002170e+06 2.070427e+06 2.138133e+06 2.204650e+06 2.269475e+06 2.332624e+06 ... 3.002161e+06 2.988117e+06 2.975029e+06 2.966108e+06 2.963496e+06 2.967984e+06 2.978339e+06 2.992192e+06 3.006154e+06 3.017712e+06
9 Samoa Americana ASM 2.001200e+04 2.047800e+04 2.111800e+04 2.188300e+04 2.270100e+04 2.351800e+04 2.432000e+04 2.511600e+04 ... 5.864800e+04 5.790400e+04 5.703100e+04 5.622600e+04 5.563600e+04 5.531600e+04 5.522700e+04 5.530200e+04 5.543400e+04 5.553800e+04
10 Antigua y Barbuda ATG 5.468100e+04 5.540300e+04 5.631100e+04 5.736800e+04 5.850000e+04 5.965300e+04 6.081800e+04 6.200200e+04 ... 8.346700e+04 8.439700e+04 8.535000e+04 8.630000e+04 8.723300e+04 8.815200e+04 8.906900e+04 8.998500e+04 9.090000e+04 9.181800e+04
11 Australia AUS 1.027648e+07 1.048300e+07 1.074200e+07 1.095000e+07 1.116700e+07 1.138800e+07 1.165100e+07 1.179900e+07 ... 2.069790e+07 2.082760e+07 2.124920e+07 2.169170e+07 2.203175e+07 2.234002e+07 2.272825e+07 2.311735e+07 2.346409e+07 2.378117e+07
12 Austria AUT 7.047539e+06 7.086299e+06 7.129864e+06 7.175811e+06 7.223801e+06 7.270889e+06 7.322066e+06 7.376998e+06 ... 8.268641e+06 8.295487e+06 8.321496e+06 8.343323e+06 8.363404e+06 8.391643e+06 8.429991e+06 8.479375e+06 8.541575e+06 8.611088e+06
13 Azerbaiyán AZE 3.897889e+06 4.030130e+06 4.167558e+06 4.307315e+06 4.445653e+06 4.579759e+06 4.708485e+06 4.832098e+06 ... 8.484550e+06 8.581300e+06 8.763400e+06 8.947243e+06 9.054332e+06 9.173082e+06 9.295784e+06 9.416801e+06 9.535079e+06 9.651349e+06
14 Burundi BDI 2.786740e+06 2.840375e+06 2.894510e+06 2.950903e+06 3.011957e+06 3.079034e+06 3.153879e+06 3.235125e+06 ... 8.218070e+06 8.514578e+06 8.821795e+06 9.137786e+06 9.461117e+06 9.790151e+06 1.012457e+07 1.046596e+07 1.081686e+07 1.117892e+07
15 Bélgica BEL 9.153489e+06 9.183948e+06 9.220578e+06 9.289770e+06 9.378113e+06 9.463667e+06 9.527807e+06 9.580991e+06 ... 1.054796e+07 1.062570e+07 1.070997e+07 1.079649e+07 1.089559e+07 1.104774e+07 1.112825e+07 1.118282e+07 1.123121e+07 1.128572e+07
16 Benin BEN 2.431620e+06 2.466002e+06 2.503232e+06 2.543335e+06 2.586362e+06 2.632360e+06 2.681382e+06 2.733450e+06 ... 8.443717e+06 8.707637e+06 8.973525e+06 9.240982e+06 9.509798e+06 9.779391e+06 1.004979e+07 1.032223e+07 1.059848e+07 1.087983e+07
17 Burkina Faso BFA 4.829291e+06 4.894578e+06 4.960325e+06 5.027818e+06 5.098892e+06 5.174869e+06 5.256363e+06 5.343020e+06 ... 1.383420e+07 1.426400e+07 1.470901e+07 1.516586e+07 1.563207e+07 1.610685e+07 1.659081e+07 1.708455e+07 1.758920e+07 1.810557e+07
18 Bangladesh BGD 4.820070e+07 4.959361e+07 5.103060e+07 5.253260e+07 5.412939e+07 5.583502e+07 5.767553e+07 5.962529e+07 ... 1.448392e+08 1.465927e+08 1.482525e+08 1.499058e+08 1.516168e+08 1.534056e+08 1.552574e+08 1.571574e+08 1.590775e+08 1.609956e+08
19 Bulgaria BGR 7.867374e+06 7.943118e+06 8.012946e+06 8.078145e+06 8.144340e+06 8.204168e+06 8.258057e+06 8.310226e+06 ... 7.699020e+06 7.545338e+06 7.492561e+06 7.444443e+06 7.395599e+06 7.348328e+06 7.305888e+06 7.265115e+06 7.223938e+06 7.177991e+06
20 Bahrein BHR 1.625010e+05 1.679240e+05 1.731070e+05 1.780480e+05 1.827740e+05 1.873480e+05 1.917820e+05 1.962030e+05 ... 9.408080e+05 1.026568e+06 1.115777e+06 1.196774e+06 1.261319e+06 1.306014e+06 1.333577e+06 1.349427e+06 1.361930e+06 1.377237e+06
21 Bahamas BHS 1.095260e+05 1.151080e+05 1.210830e+05 1.273310e+05 1.336970e+05 1.400490e+05 1.463640e+05 1.526070e+05 ... 3.358010e+05 3.422590e+05 3.485870e+05 3.547800e+05 3.608300e+05 3.667110e+05 3.723880e+05 3.778410e+05 3.830540e+05 3.880190e+05
22 Bosnia y Herzegovina BIH 3.214520e+06 3.277096e+06 3.341809e+06 3.406466e+06 3.468083e+06 3.524596e+06 3.574972e+06 3.619997e+06 ... 3.838504e+06 3.840418e+06 3.839749e+06 3.837732e+06 3.835258e+06 3.832310e+06 3.828419e+06 3.823533e+06 3.817554e+06 3.810416e+06
23 Belarús BLR 8.198000e+06 8.271216e+06 8.351928e+06 8.437232e+06 8.524224e+06 8.610000e+06 8.696496e+06 8.785648e+06 ... 9.604000e+06 9.560000e+06 9.528000e+06 9.507000e+06 9.490000e+06 9.473000e+06 9.464000e+06 9.466000e+06 9.483000e+06 9.513000e+06
24 Belice BLZ 9.206800e+04 9.470100e+04 9.738900e+04 1.001660e+05 1.030700e+05 1.061210e+05 1.093440e+05 1.126990e+05 ... 2.907510e+05 2.984030e+05 3.061650e+05 3.139250e+05 3.216090e+05 3.291930e+05 3.367070e+05 3.441930e+05 3.517060e+05 3.592870e+05
25 Bermudas BMU 4.440000e+04 4.550000e+04 4.660000e+04 4.770000e+04 4.890000e+04 5.010000e+04 5.100000e+04 5.200000e+04 ... 6.452300e+04 6.488800e+04 6.527300e+04 6.563600e+04 6.512400e+04 6.456400e+04 6.479800e+04 6.500100e+04 6.513900e+04 6.523500e+04
26 Bolivia BOL 3.693451e+06 3.764815e+06 3.838096e+06 3.913397e+06 3.990855e+06 4.070590e+06 4.152665e+06 4.237126e+06 ... 9.283345e+06 9.441482e+06 9.599916e+06 9.758799e+06 9.918245e+06 1.007824e+07 1.023876e+07 1.039993e+07 1.056189e+07 1.072470e+07
27 Brasil BRA 7.249358e+07 7.470689e+07 7.700755e+07 7.936845e+07 8.175180e+07 8.413006e+07 8.649499e+07 8.885368e+07 ... 1.906982e+08 1.927845e+08 1.947697e+08 1.967013e+08 1.986142e+08 2.005176e+08 2.024016e+08 2.042594e+08 2.060779e+08 2.078475e+08
28 Barbados BRB 2.309340e+05 2.316740e+05 2.325840e+05 2.335870e+05 2.345470e+05 2.353730e+05 2.360430e+05 2.366200e+05 ... 2.750400e+05 2.761540e+05 2.773150e+05 2.784660e+05 2.795660e+05 2.806020e+05 2.815800e+05 2.825030e+05 2.833800e+05 2.842150e+05
29 Brunei Darussalam BRN 8.182500e+04 8.568700e+04 8.960300e+04 9.365000e+04 9.793300e+04 1.025250e+05 1.074500e+05 1.126800e+05 ... 3.681500e+05 3.744590e+05 3.807860e+05 3.870800e+05 3.933020e+05 3.994430e+05 4.055120e+05 4.114990e+05 4.173940e+05 4.231880e+05
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
234 América Latina y el Caribe (BIRF y la AIF) TLA 2.104957e+08 2.164941e+08 2.226894e+08 2.290425e+08 2.354987e+08 2.420184e+08 2.485867e+08 2.552118e+08 ... 5.538446e+08 5.610617e+08 5.682523e+08 5.753981e+08 5.824841e+08 5.895062e+08 5.964635e+08 6.033477e+08 6.101499e+08 6.168626e+08
235 Timor-Leste TLS 4.995250e+05 5.083110e+05 5.174460e+05 5.269360e+05 5.367980e+05 5.470350e+05 5.572520e+05 5.673300e+05 ... 9.960520e+05 1.013194e+06 1.030630e+06 1.048367e+06 1.066409e+06 1.120392e+06 1.148958e+06 1.180069e+06 1.212107e+06 1.245015e+06
236 Oriente Medio y Norte de África (BIRF y la AIF) TMN 9.791405e+07 1.005201e+08 1.032034e+08 1.059679e+08 1.088222e+08 1.117711e+08 1.148228e+08 1.179711e+08 ... 3.055886e+08 3.110368e+08 3.166325e+08 3.223389e+08 3.281177e+08 3.339812e+08 3.398933e+08 3.458872e+08 3.519682e+08 3.581388e+08
237 Tonga TON 6.160000e+04 6.374000e+04 6.625500e+04 6.900000e+04 7.175700e+04 7.436300e+04 7.678700e+04 7.904800e+04 ... 1.015070e+05 1.021690e+05 1.028160e+05 1.034160e+05 1.039470e+05 1.043920e+05 1.047690e+05 1.051390e+05 1.055860e+05 1.061700e+05
238 Asia meridional (BIRF y la AIF) TSA 5.720361e+08 5.841432e+08 5.967011e+08 6.095715e+08 6.230731e+08 6.369638e+08 6.513260e+08 6.661343e+08 ... 1.534950e+09 1.558686e+09 1.582147e+09 1.605444e+09 1.628689e+09 1.651889e+09 1.675019e+09 1.698093e+09 1.721153e+09 1.744161e+09
239 África al sur del Sahara (BIRF y la AIF) TSS 2.282688e+08 2.337600e+08 2.394036e+08 2.452170e+08 2.512159e+08 2.574149e+08 2.638307e+08 2.704776e+08 ... 7.833576e+08 8.049504e+08 8.272397e+08 8.501903e+08 8.737802e+08 8.979985e+08 9.228551e+08 9.483224e+08 9.743719e+08 1.000981e+09
240 Trinidad y Tobago TTO 8.484810e+05 8.653560e+05 8.800190e+05 8.925710e+05 9.032720e+05 9.124190e+05 9.199020e+05 9.259180e+05 ... 1.303141e+06 1.309260e+06 1.315372e+06 1.321624e+06 1.328095e+06 1.334790e+06 1.341579e+06 1.348240e+06 1.354483e+06 1.360088e+06
241 Túnez TUN 4.220701e+06 4.277371e+06 4.350811e+06 4.436643e+06 4.530835e+06 4.630000e+06 4.731395e+06 4.832923e+06 ... 1.012790e+07 1.022510e+07 1.032890e+07 1.043960e+07 1.054710e+07 1.067380e+07 1.077750e+07 1.088650e+07 1.099660e+07 1.110780e+07
242 Turquía TUR 2.755328e+07 2.822929e+07 2.890998e+07 2.959705e+07 3.029297e+07 3.100017e+07 3.171827e+07 3.244840e+07 ... 6.870472e+07 6.951549e+07 7.034436e+07 7.126131e+07 7.231042e+07 7.351700e+07 7.484919e+07 7.622364e+07 7.752379e+07 7.866583e+07
243 Tuvalu TUV 6.104000e+03 6.242000e+03 6.391000e+03 6.542000e+03 6.687000e+03 6.819000e+03 6.935000e+03 7.037000e+03 ... 9.732000e+03 9.764000e+03 9.788000e+03 9.808000e+03 9.827000e+03 9.844000e+03 9.860000e+03 9.876000e+03 9.893000e+03 9.916000e+03
244 Tanzanía TZA 1.007449e+07 1.037338e+07 1.068389e+07 1.100588e+07 1.133908e+07 1.168351e+07 1.203889e+07 1.240604e+07 ... 4.026085e+07 4.152200e+07 4.284474e+07 4.422211e+07 4.564852e+07 4.712300e+07 4.864571e+07 5.021346e+07 5.182262e+07 5.347042e+07
245 Uganda UGA 6.788211e+06 7.006629e+06 7.240155e+06 7.487411e+06 7.746181e+06 8.014376e+06 8.292747e+06 8.580632e+06 ... 2.900092e+07 2.999196e+07 3.101443e+07 3.206712e+07 3.314942e+07 3.426034e+07 3.540062e+07 3.657339e+07 3.778297e+07 3.903238e+07
246 Ucrania UKR 4.266215e+07 4.320364e+07 4.374947e+07 4.428590e+07 4.479432e+07 4.526194e+07 4.568231e+07 4.606046e+07 ... 4.678775e+07 4.650935e+07 4.625820e+07 4.605330e+07 4.587070e+07 4.570610e+07 4.559330e+07 4.548960e+07 4.536290e+07 4.519820e+07
247 Ingreso mediano alto UMC 1.175211e+09 1.180098e+09 1.197381e+09 1.225994e+09 1.254220e+09 1.283353e+09 1.315364e+09 1.346548e+09 ... 2.419695e+09 2.437537e+09 2.455687e+09 2.474451e+09 2.493277e+09 2.512627e+09 2.532681e+09 2.553112e+09 2.573612e+09 2.593743e+09
248 Uruguay URY 2.538651e+06 2.571691e+06 2.603887e+06 2.635128e+06 2.665387e+06 2.694535e+06 2.722874e+06 2.750093e+06 ... 3.331041e+06 3.339750e+06 3.350832e+06 3.362761e+06 3.374414e+06 3.385610e+06 3.396753e+06 3.407969e+06 3.419516e+06 3.431555e+06
249 Estados Unidos USA 1.806710e+08 1.836910e+08 1.865380e+08 1.892420e+08 1.918890e+08 1.943030e+08 1.965600e+08 1.987120e+08 ... 2.983799e+08 3.012312e+08 3.040940e+08 3.067715e+08 3.093469e+08 3.117189e+08 3.141026e+08 3.164274e+08 3.189074e+08 3.214188e+08
250 Uzbekistán UZB 8.789492e+06 9.044671e+06 9.319510e+06 9.611601e+06 9.917202e+06 1.023350e+07 1.055905e+07 1.089431e+07 ... 2.648825e+07 2.686800e+07 2.730280e+07 2.776740e+07 2.856240e+07 2.933940e+07 2.977450e+07 3.024320e+07 3.075770e+07 3.129950e+07
251 San Vicente y las Granadinas VCT 8.094800e+04 8.214400e+04 8.320600e+04 8.416700e+04 8.507600e+04 8.597200e+04 8.686000e+04 8.773600e+04 ... 1.089080e+05 1.090490e+05 1.091650e+05 1.092550e+05 1.093160e+05 1.093410e+05 1.093340e+05 1.093270e+05 1.093600e+05 1.094620e+05
252 Venezuela VEN 8.146845e+06 8.461684e+06 8.790590e+06 9.130346e+06 9.476255e+06 9.824694e+06 1.017514e+07 1.052805e+07 ... 2.722123e+07 2.767066e+07 2.811672e+07 2.855861e+07 2.899574e+07 2.942763e+07 2.985424e+07 3.027604e+07 3.069383e+07 3.110808e+07
253 Islas Vírgenes Británicas VGB 8.036000e+03 8.157000e+03 8.298000e+03 8.455000e+03 8.628000e+03 8.813000e+03 9.009000e+03 9.214000e+03 ... 2.390800e+04 2.473500e+04 2.560400e+04 2.645000e+04 2.722300e+04 2.790600e+04 2.851100e+04 2.905800e+04 2.958500e+04 3.011700e+04
254 Islas Vírgenes (EE.UU.) VIR 3.200000e+04 3.410000e+04 3.630000e+04 3.870000e+04 4.130000e+04 4.400000e+04 4.730000e+04 5.080000e+04 ... 1.077000e+05 1.074230e+05 1.070910e+05 1.067070e+05 1.062670e+05 1.057840e+05 1.052750e+05 1.047370e+05 1.041700e+05 1.035740e+05
255 Viet Nam VNM 3.474300e+07 3.542800e+07 3.612300e+07 3.683600e+07 3.757400e+07 3.834100e+07 3.914200e+07 3.998000e+07 ... 8.331120e+07 8.421850e+07 8.511870e+07 8.602500e+07 8.693250e+07 8.786030e+07 8.880920e+07 8.975950e+07 9.072890e+07 9.170380e+07
256 Vanuatu VUT 6.370100e+04 6.570800e+04 6.780600e+04 6.996200e+04 7.213100e+04 7.428700e+04 7.641000e+04 7.851800e+04 ... 2.146350e+05 2.199560e+05 2.253350e+05 2.307820e+05 2.362990e+05 2.418760e+05 2.474980e+05 2.531650e+05 2.588830e+05 2.646520e+05
257 Mundo WLD 3.035056e+09 3.076121e+09 3.129064e+09 3.193947e+09 3.259355e+09 3.326054e+09 3.395866e+09 3.465297e+09 ... 6.594722e+09 6.675833e+09 6.758303e+09 6.840956e+09 6.923684e+09 7.006908e+09 7.089452e+09 7.176092e+09 7.260780e+09 7.346633e+09
258 Samoa WSM 1.086450e+05 1.121210e+05 1.157860e+05 1.195640e+05 1.233540e+05 1.270680e+05 1.306870e+05 1.341940e+05 ... 1.810720e+05 1.822380e+05 1.834400e+05 1.847000e+05 1.860290e+05 1.874340e+05 1.889010e+05 1.903900e+05 1.918450e+05 1.932280e+05
259 Kosovo XKX 9.470000e+05 9.660000e+05 9.940000e+05 1.022000e+06 1.050000e+06 1.078000e+06 1.106000e+06 1.135000e+06 ... 1.719536e+06 1.733404e+06 1.747383e+06 1.761474e+06 1.775680e+06 1.790957e+06 1.805200e+06 1.818117e+06 1.812771e+06 1.797151e+06
260 Yemen, Rep. del YEM 5.166311e+06 5.251663e+06 5.339285e+06 5.429501e+06 5.522690e+06 5.619170e+06 5.720538e+06 5.827223e+06 ... 2.109397e+07 2.170110e+07 2.232270e+07 2.295423e+07 2.359197e+07 2.423494e+07 2.488279e+07 2.553322e+07 2.618368e+07 2.683222e+07
261 Sudáfrica ZAF 1.739600e+07 1.794996e+07 1.845944e+07 1.893614e+07 1.939055e+07 1.983200e+07 2.026859e+07 2.070726e+07 ... 4.792168e+07 4.859678e+07 4.929622e+07 5.002092e+07 5.077183e+07 5.154996e+07 5.235638e+07 5.319222e+07 5.405865e+07 5.495692e+07
262 Zambia ZMB 3.049586e+06 3.142848e+06 3.240664e+06 3.342894e+06 3.449266e+06 3.559687e+06 3.674088e+06 3.792864e+06 ... 1.238151e+07 1.273868e+07 1.311458e+07 1.350785e+07 1.391744e+07 1.434353e+07 1.478658e+07 1.524609e+07 1.572134e+07 1.621177e+07
263 Zimbabwe ZWE 3.752390e+06 3.876638e+06 4.006262e+06 4.140804e+06 4.279561e+06 4.422132e+06 4.568320e+06 4.718612e+06 ... 1.312794e+07 1.329780e+07 1.349546e+07 1.372100e+07 1.397390e+07 1.425559e+07 1.456548e+07 1.489809e+07 1.524586e+07 1.560275e+07

264 rows × 58 columns


In [5]:
# Cambiando indice en un dataframe
dfpoptotal.index = dfpoptotal['Country Code'] +'-'+dfpoptotal['Country Name']
dfpoptotal.index.name = 'Código País'

In [6]:
lcodigopaisfiltro = ['CUB','HTI','DOM','PRI','JAM']
dfAM=dfpoptotal[dfpoptotal['Country Code'].isin(lcodigopaisfiltro)].T.drop(['Country Name', 'Country Code']).astype(np.int64)

dfAM.head(3)


Out[6]:
Código País CUB-Cuba DOM-República Dominicana HTI-Haití JAM-Jamaica PRI-Puerto Rico
1960 7141129 3294039 3866160 1629003 2358000
1961 7289828 3406299 3943363 1651915 2399722
1962 7450404 3521276 4022596 1678467 2450322

In [7]:
dfAM.plot()

#Título
plt.title('Desde 1960 hasta 2015')
plt.suptitle('Evolución población Antillas Mayores')

#Cambia formato númerico axis y
ax = plt.gca()
ax.yaxis.set_major_formatter(FormatStrFormatter('%0.f'))

# Etiqueta x
plt.xlabel('Año')

# Etiqueta y
plt.ylabel('Población')

#Modificar posición de la leyenda
plt.legend(bbox_to_anchor=(1.05, 1), loc=2, borderaxespad=0.,title='Leyenda')

# Mostrar gráfica
plt.show()