library(dplyr)
library(kableExtra)
options(scipen = 9999)
source(file = "C:/Users/Rivera/Downloads/metodos_Ademir/funciones_comercio_exterior.R")

Clave 1.

Usando los datos de Comercio Exterior de El Salvador, disponibles en la base de datos preparada en clases, responda las siguientes preguntas:

Importante: muestre sus resultados en formato tabular, y asignando los encabezados y pies de página apropiados en cada caso.

1. Calcule las exportaciones totales de El Salvador hacia la region de África Sub-Sahariana, para el perido 2019-2020 (en millones de US$).

data_comercio_exterior_actualizada_AdemAgo %>%
  select("anio","valor_fob","sub_region") %>%
  filter(anio %in% 2019:2020, sub_region=="Africa Sub-Sahariana",valor_fob>0) %>%
  group_by(anio) %>%
  summarise(`Total de exportaciones de El Salvador hacia la sub region de Africa Sub-Sahariana en Millones de US$`=sum(valor_fob)/1e6) %>%
  head() %>% 
  kable(caption = "Exportaciones totales de El Salvador hacia la sub region de Africa Sub-Sahariana, para el periodo 2019-2020",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Exportaciones totales de El Salvador hacia la sub region de Africa Sub-Sahariana, para el periodo 2019-2020
anio Total de exportaciones de El Salvador hacia la sub region de Africa Sub-Sahariana en Millones de US$
2019 2.453
2020 1.504
* Elaboración propia con base en datos del BCR

2. Obtenga el saldo de la balanza comercial de El Salvador, con “Asia Sudoriental”, para el periodo de 2017-2019 (En millones de US$).

data_comercio_exterior_actualizada_AdemAgo %>%
  group_by(anio,sub_region) %>%
  summarise(`Total de exportaciones en millones de US$`= sum(valor_fob)/1e6,
    `Total de importaciones en millones de US$`= sum(valor_cif)/1e6,
    `Balanza Comercial de El Salvador con Asia Sudoriental`=`Total de exportaciones en millones de US$`-`Total de importaciones en millones de US$`) %>%
  select("anio","sub_region","Total de exportaciones en millones de US$","Total de importaciones en millones de US$","Balanza Comercial de El Salvador con Asia Sudoriental") %>%
  filter(anio %in% 2017:2019, sub_region=="Asia Sudoriental") %>%
  head() %>% kable(caption = "Balanza comercial de El Salvador con Asia Sudoriental, para el periodo 2017-2019",align = "l",digits = 3) %>% kable_minimal() %>%add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Balanza comercial de El Salvador con Asia Sudoriental, para el periodo 2017-2019
anio sub_region Total de exportaciones en millones de US$ Total de importaciones en millones de US$ Balanza Comercial de El Salvador con Asia Sudoriental
2017 Asia Sudoriental 73.591 269.484 -195.893
2018 Asia Sudoriental 16.610 280.884 -264.274
2019 Asia Sudoriental 4.609 262.550 -257.941
* Elaboración propia con base en datos del BCR

3. Por cada dolar exportado a la region Sudamericana, en el año 2019, ¿Cuánto se importó?

data_comercio_exterior_actualizada_AdemAgo %>% 
  group_by(anio,region_intermedia) %>%
  summarise(`Importacion por dolar exportado`=(sum(valor_cif)/sum(valor_fob))) %>%
  select("anio","region_intermedia","Importacion por dolar exportado") %>%
  filter(anio==2019, region_intermedia=="Sudamerica") %>%
  head() %>% 
  kable(caption = "Importación por cada dolar exportado a la región de Sudamerica",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Importación por cada dolar exportado a la región de Sudamerica
anio region_intermedia Importacion por dolar exportado
2019 Sudamerica 15.056
* Elaboración propia con base en datos del BCR

4. Calcule el Indicador de Balassa de El Salvador, con Mexico, Estados Unidos y Canadá, durante el periodo 2017-2020, para el capitulo “01” del SAC.

resultados_Balassa_esa <- data.frame("Años"=2017:2020,
                                 "IB_Mexico"= sapply(X=2017:2020,
                                              FUN = indicadores_Balassa_capitulo,
                                              codigo_pais=484,
                                              capitulo="01"),
                                 "IB_USA"= sapply(X=2017:2020,
                                              FUN = indicadores_Balassa_capitulo,
                                              codigo_pais=840,
                                              capitulo="01"),
                                 "IB_Canada"= sapply(X=2017:2020,
                                              FUN = indicadores_Balassa_capitulo,
                                              codigo_pais=124,
                                              capitulo="01"))

resultados_Balassa_esa %>%
  kable(align = "l", caption = "Indicador de Balassa de El Salvador con Mexico, Estados Unidos y Canada, durante el periodo 2017-2020, para el capitulo 01 del SAC.", digits = 4) %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) %>%
  add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>%
  kable_minimal()
Indicador de Balassa de El Salvador con Mexico, Estados Unidos y Canada, durante el periodo 2017-2020, para el capitulo 01 del SAC.
Años IB_Mexico IB_USA IB_Canada
2017 -0.5761 0.3598 0.3954
2018 -0.8244 0.3229 0.6144
2019 -0.8981 0.4016 0.1885
2020 -0.9775 0.7035 0.0411
* Elaboración propia con base en datos del BCR

Clave 2.

Usando los datos de Comercio Exterior de El Salvador, disponibles en la base de datos preparada en clases, responda las siguientes preguntas:

Importante: muestre sus resultados en formato tabular, y asignando los encabezados y pies de página apropiados en cada caso

1. Calcule el indicador IVCR de El Salvador con Mexico, Estados Unidos y Canada, durante el periodo 2017-2020, para el capitulo “01” del SAC.

resultados_IVCR_esa <- data.frame("Años"=2017:2020,
                              "IVCR_Mexico"=sapply(X=2017:2020,
                                            FUN = indicadores_IVCR_capitulo,
                                            codigo_pais=484,
                                            capitulo="01"),
                              "IVCR_USA"=sapply(X=2017:2020,
                                            FUN = indicadores_IVCR_capitulo,
                                            codigo_pais=840,
                                            capitulo="01"),
                              "IVCR_Canada"=sapply(X=2017:2020,
                                            FUN = indicadores_IVCR_capitulo,
                                            codigo_pais=124,
                                            capitulo="01"))

resultados_IVCR_esa %>% 
  kable(align = "l", caption = "Indicador IVCR de El Salvador con Mexico, Estados Unidos y Canada,durante el periodo 2017-2020", digits = 4) %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) %>%
  add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>%
  kable_minimal()
Indicador IVCR de El Salvador con Mexico, Estados Unidos y Canada,durante el periodo 2017-2020
Años IVCR_Mexico IVCR_USA IVCR_Canada
2017 -0.0006 -0.1268 0.0026
2018 -0.0048 -0.0997 0.0000
2019 -0.0015 -0.0881 0.0003
2020 -0.0014 -0.0842 -0.0028
* Elaboración propia con base en datos del BCR

2. Por cada dolar exportado a la region centroamericana, en el periodo 2017-2019 ¿uanto se importó? (resultado por año).

data_comercio_exterior_actualizada_AdemAgo %>% 
  group_by(anio,region_intermedia) %>%
  summarise(`Importacion por dolar exportado`=(sum(valor_cif)/sum(valor_fob))) %>%
  select("anio","region_intermedia","Importacion por dolar exportado") %>%
  filter(anio %in% 2017:2019, region_intermedia=="Centroamérica") %>%
  head() %>% 
  kable(caption = "Importación por cada dolar exportado a la región centroameriana",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Importación por cada dolar exportado a la región centroameriana
anio region_intermedia Importacion por dolar exportado
2017 Centroamérica 1.230
2018 Centroamérica 1.280
2019 Centroamérica 1.338
* Elaboración propia con base en datos del BCR

3. Obtenga el saldo de la balanza Comercial de EL Salvador, con el Caribe, para el periodo 2017-2019 (en millones de USD).

data_comercio_exterior_actualizada_AdemAgo %>%
  group_by(anio,region_intermedia) %>%
  summarise(
    `Total de exportaciones en millones de US$`= sum(valor_fob)/1e6,
    `Total de importaciones en millones de US$`= sum(valor_cif)/1e6,
    `Balanza Comercial de El Salvador con el Caribe`=`Total de exportaciones en millones de US$`-`Total de importaciones en millones de US$`) %>%
  select("anio","region_intermedia","Total de exportaciones en millones de US$","Total de importaciones en millones de US$","Balanza Comercial de El Salvador con el Caribe") %>%
  filter(anio %in% 2017:2019, region_intermedia=="Caribe") %>%
  head() %>% 
  kable(caption = "Balanza Comercial de El Salvador con el Caribe en Millones de US$",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Balanza Comercial de El Salvador con el Caribe en Millones de US\(</caption> <thead> <tr> <th style="text-align:left;"> anio </th> <th style="text-align:left;"> region_intermedia </th> <th style="text-align:left;"> Total de exportaciones en millones de US\)
Total de importaciones en millones de US$ Balanza Comercial de El Salvador con el Caribe
2017 Caribe 150.182 46.048 104.134
2018 Caribe 172.133 34.045 138.088
2019 Caribe 169.137 21.612 147.525
* Elaboración propia con base en datos del BCR

4. Calcule las exportaciones totales de El Salvador hacia la region Norte de Europa, para el periodo 2019-2020 (en millones de USD).

data_comercio_exterior_actualizada_AdemAgo %>%
  select("anio","valor_fob","sub_region") %>%
  filter(anio %in% 2019:2020, sub_region=="Norte De Europa",valor_fob>0) %>%
  group_by(anio) %>%
  summarise(`Total de exportaciones de El Salvador hacia la region Norte de Europa en Millones de US$`=sum(valor_fob)/1e6) %>%
  head() %>% 
  kable(caption = "Exportaciones totales de El Salvador hacia la region Norte de Europa, para el periodo 2019-2020",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Exportaciones totales de El Salvador hacia la region Norte de Europa, para el periodo 2019-2020
anio Total de exportaciones de El Salvador hacia la region Norte de Europa en Millones de US$
2019 19.809
2020 12.152
* Elaboración propia con base en datos del BCR

Clave 3.

Usando los datos de Comercio Exterior de El Salvador, disponibles en la base de datos preparada en clases, responda las siguientes preguntas:

Importante: muestre sus resultados en formato tabular, y asignando los encabezados y pies de página apropiados en cada caso

1. Por cada dolar exportado a la region Suramericana, en el periodo 2018-2019, ¿Cuánto se importó?

data_comercio_exterior_actualizada_AdemAgo %>% 
  group_by(anio,region_intermedia) %>%
  summarise(`Importacion por dolar exportado`=(sum(valor_cif)/sum(valor_fob))) %>%
  select("anio","region_intermedia","Importacion por dolar exportado") %>%
  filter(anio %in% 2018:2019, region_intermedia=="Sudamerica") %>%
  head() %>% 
  kable(caption = "Importación por cada dolar exportado a la región de Sudamerica",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Importación por cada dolar exportado a la región de Sudamerica
anio region_intermedia Importacion por dolar exportado
2018 Sudamerica 14.886
2019 Sudamerica 15.056
* Elaboración propia con base en datos del BCR

2. Calcule el IHH de El Salvador, con Mexico Estados Unidos y Canadá, durante el periodo 2017-2020, normalizado.

resultados_IHH_esa <- data.frame("años"=2017:2020,
                             "IHH_Mexico"=sapply(X=2017:2020,
                                          FUN = indicadores_IHH_Herfindahl_Hirschmann_anual,
                                          codigo_pais=484,
                                          normalizado=TRUE),
                             "IHH_USA"=sapply(X=2017:2020,
                                          FUN = indicadores_IHH_Herfindahl_Hirschmann_anual,
                                          codigo_pais=840,
                                          normalizado=TRUE),
                             "IHH_Canada"=sapply(X=2017:2020,
                                          FUN = indicadores_IHH_Herfindahl_Hirschmann_anual,
                                          codigo_pais=124,
                                          normalizado=TRUE))
resultados_IHH_esa %>%
   kable(align = "l", caption = "Indicador IHH de El Salvador con Mexico, Estados Unidos y Canada, durante el periodo 2017-2020", digits = 4) %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) %>%
  add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>%
  kable_minimal()
Indicador IHH de El Salvador con Mexico, Estados Unidos y Canada, durante el periodo 2017-2020
años IHH_Mexico IHH_USA IHH_Canada
2017 0.0166 0.0056 0.1231
2018 0.0182 0.0057 0.0084
2019 0.0143 0.0059 0.1190
2020 0.0147 0.0099 0.0591
* Elaboración propia con base en datos del BCR

3. Calcule las exportaciones totales de EL Salvador, hacia la region de Asia Oriental, para el periodo 2017-2020 (en millones de US$).

data_comercio_exterior_actualizada_AdemAgo %>%
  select("anio","valor_fob","sub_region") %>%
  filter(anio %in% 2017:2020, sub_region=="Asia Oriental",valor_fob>0) %>%
  group_by(anio) %>%
  summarise(`Total de exportaciones de El Salvador hacia la region de Asia Oriental en Millones de US$`=sum(valor_fob)/1e6) %>%
  head() %>% 
  kable(caption = "Exportaciones totales de El Salvador hacia la region de Asia Oriental, para el periodo 2017-2020",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Exportaciones totales de El Salvador hacia la region de Asia Oriental, para el periodo 2017-2020
anio Total de exportaciones de El Salvador hacia la region de Asia Oriental en Millones de US$
2017 133.859
2018 144.394
2019 122.952
2020 134.662
* Elaboración propia con base en datos del BCR

4. Obtenga el saldo de la Balanza comercial de El salvador, con Latinoamerica, para el periodo 2017-2019 (en millones de US$).

data_comercio_exterior_actualizada_AdemAgo %>%
  group_by(anio,sub_region) %>%
  summarise(
    `Total de exportaciones en millones de US$`= sum(valor_fob)/1e6,
    `Total de importaciones en millones de US$`= sum(valor_cif)/1e6,
    `Balanza Comercial de El Salvador con América Latina Y El Caribe`=`Total de exportaciones en millones de US$`-`Total de importaciones en millones de US$`) %>%
  select("anio","sub_region","Total de exportaciones en millones de US$","Total de importaciones en millones de US$","Balanza Comercial de El Salvador con América Latina Y El Caribe") %>%
  filter(anio %in% 2017:2019, sub_region=="América Latina Y El Caribe") %>%
  head() %>% 
  kable(caption = "Balanza Comercial de El Salvador con América Latina Y El Caribe en Millones de US$",align = "l",digits = 3) %>% 
  kable_minimal() %>%
   add_footnote(label="Elaboración propia con base en datos del BCR",notation="symbol") %>% kable_styling()
Balanza Comercial de El Salvador con América Latina Y El Caribe en Millones de US\(</caption> <thead> <tr> <th style="text-align:left;"> anio </th> <th style="text-align:left;"> sub_region </th> <th style="text-align:left;"> Total de exportaciones en millones de US\)
Total de importaciones en millones de US$ Balanza Comercial de El Salvador con América Latina Y El Caribe
2017 América Latina Y El Caribe 2746.262 3770.895 -1024.633
2018 América Latina Y El Caribe 2922.872 4144.131 -1221.259
2019 América Latina Y El Caribe 3067.961 4553.745 -1485.784
* Elaboración propia con base en datos del BCR

Ejercicio 2.

library(readr)
library(dplyr)
library(kableExtra)
library(pwt9)

Clave 1.

###Usando los datos de la Penn World Table, de la Universidad de Groningen. ###Resuelva los siguientes requerimientos (es importante mostrar todos sus resultados en formato tabular):

1. Construya una funcion que le permita eleger el pais y filtrar para un periodo (inicio, final). Muestre su uso filtrando los datos para El Salvador, en el periodo de 1950-2014.

data("pwt9.0")
options(scipen = 999999)
#crear la funcion.
funcion_elegir_pais <- function(iso_pais,anio_ini,anio_fin){
  enquo(iso_pais)->iso_pais
  pwt9.0 %>% filter(isocode==!!iso_pais,
                    year>=anio_ini,
                    year<=anio_fin)-> elegir_pais
  return(elegir_pais)
}
#Probando la funcion.
funcion_elegir_pais(iso_pais = "SLV",1950,2014) %>%
  kable(caption = "Datos de El Salvador de 1950 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de El Salvador de 1950 a 2014
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
SLV-1950 El Salvador SLV 1950 US Dollar 1328.68 1162.96 1.97 NA NA 1.22 1106.17 1178.05 1276.18 1136.44 1489.37 NA NA 6510.53 6671.51 6988.91 14268.64 NA NA NA 0.04 1 0.07 0.08 0.09 extrapolated extrapolated market no NA NA 0.86 0.06 0.11 0.23 -0.27 0.00 0.07 0.14 0.06 0.10 0.06 0.17
SLV-1951 El Salvador SLV 1951 US Dollar 1406.21 1163.40 2.03 NA NA 1.23 1178.87 1266.99 1349.93 1105.53 1544.81 NA NA 6766.86 7134.09 7564.44 14326.17 NA NA NA 0.04 1 0.08 0.09 0.11 extrapolated extrapolated market no NA NA 0.94 0.08 0.12 0.23 -0.38 0.00 0.08 0.16 0.07 0.12 0.06 0.19
SLV-1952 El Salvador SLV 1952 US Dollar 1488.13 1253.54 2.08 NA NA 1.23 1251.23 1349.25 1420.91 1192.77 1588.55 NA NA 7264.29 7644.17 8093.95 14409.00 NA NA NA 0.04 1 0.08 0.09 0.10 extrapolated extrapolated market no NA NA 0.92 0.08 0.13 0.22 -0.35 0.00 0.08 0.15 0.07 0.12 0.06 0.18
SLV-1953 El Salvador SLV 1953 US Dollar 1593.58 1346.11 2.14 NA NA 1.24 1362.83 1463.97 1525.12 1305.57 1600.30 NA NA 7817.62 8292.65 8739.85 14508.44 NA NA NA 0.04 1 0.09 0.09 0.11 extrapolated extrapolated market no NA NA 0.91 0.08 0.13 0.20 -0.33 0.00 0.09 0.16 0.07 0.12 0.06 0.19
SLV-1954 El Salvador SLV 1954 US Dollar 1690.62 1356.89 2.20 NA NA 1.24 1450.98 1549.41 1615.58 1317.64 1580.19 NA NA 8021.83 8827.66 9217.75 14583.29 NA NA NA 0.04 1 0.09 0.10 0.12 extrapolated extrapolated market no NA NA 0.96 0.07 0.15 0.18 -0.36 0.00 0.09 0.16 0.08 0.16 0.07 0.20
SLV-1955 El Salvador SLV 1955 US Dollar 1753.40 1425.70 2.26 NA NA 1.25 1517.85 1618.17 1669.60 1384.10 1582.67 NA NA 8445.04 9284.06 9673.21 14673.44 NA NA NA 0.04 1 0.10 0.10 0.12 extrapolated extrapolated market no NA NA 0.96 0.07 0.13 0.20 -0.37 0.00 0.10 0.17 0.08 0.14 0.07 0.20
SLV-1956 El Salvador SLV 1956 US Dollar 1828.69 1514.19 2.33 NA NA 1.25 1564.43 1707.02 1730.09 1459.71 1657.90 NA NA 8990.82 9644.38 10412.62 15037.84 NA NA NA 0.04 1 0.10 0.10 0.12 extrapolated extrapolated market no NA NA 0.94 0.10 0.14 0.21 -0.38 0.00 0.10 0.17 0.08 0.14 0.07 0.20
SLV-1957 El Salvador SLV 1957 US Dollar 1975.54 1593.03 2.40 NA NA 1.26 1624.57 1784.29 1864.72 1527.84 1710.36 NA NA 9393.49 10034.27 10928.63 15464.78 NA NA NA 0.05 1 0.09 0.10 0.12 extrapolated extrapolated market no NA NA 0.92 0.10 0.15 0.21 -0.38 0.00 0.09 0.16 0.08 0.16 0.07 0.20
SLV-1958 El Salvador SLV 1958 US Dollar 1892.23 1650.91 2.47 NA NA 1.26 1627.99 1763.58 1785.91 1607.49 1703.70 NA NA 9519.50 10066.13 10701.72 15672.67 NA NA NA 0.05 1 0.10 0.10 0.11 extrapolated extrapolated market no NA NA 0.87 0.08 0.14 0.21 -0.31 0.00 0.10 0.17 0.08 0.12 0.08 0.21
SLV-1959 El Salvador SLV 1959 US Dollar 1908.08 1710.75 2.55 NA NA 1.27 1668.14 1771.13 1790.04 1664.50 1698.59 NA NA 9704.64 10381.46 10665.75 15645.99 NA NA NA 0.04 1 0.09 0.10 0.11 extrapolated extrapolated market no NA NA 0.86 0.06 0.14 0.22 -0.29 0.00 0.10 0.17 0.08 0.11 0.08 0.21
SLV-1960 El Salvador SLV 1960 US Dollar 1935.00 1727.86 2.63 NA NA 1.27 1713.03 1907.99 1833.12 1611.01 1723.05 NA NA 10141.43 10527.88 11719.51 16277.75 NA NA NA 0.05 1 0.10 0.10 0.12 extrapolated extrapolated market no NA NA 0.92 0.12 0.15 0.22 -0.40 0.00 0.10 0.15 0.08 0.11 0.07 0.19
SLV-1961 El Salvador SLV 1961 US Dollar 1988.43 1832.71 2.71 NA NA 1.27 1722.87 1888.86 1898.73 1738.63 1761.34 NA NA 10299.34 10425.42 11426.50 16665.32 NA NA NA 0.05 1 0.09 0.10 0.11 extrapolated extrapolated market no NA NA 0.84 0.10 0.15 0.23 -0.32 0.00 0.10 0.16 0.08 0.11 0.08 0.19
SLV-1962 El Salvador SLV 1962 US Dollar 2190.93 2056.03 2.80 NA NA 1.28 1908.77 2075.22 2094.64 2008.37 1795.50 NA NA 11393.63 11522.74 12500.36 17062.97 NA NA NA 0.05 1 0.10 0.10 0.10 extrapolated extrapolated market no NA NA 0.81 0.08 0.14 0.24 -0.28 0.00 0.10 0.16 0.07 0.10 0.09 0.19
SLV-1963 El Salvador SLV 1963 US Dollar 2262.95 2125.34 2.89 NA NA 1.28 2000.29 2183.82 2154.52 2091.82 1823.31 NA NA 11892.12 12173.60 13265.75 17543.06 NA NA NA 0.05 1 0.10 0.10 0.11 extrapolated extrapolated market no NA NA 0.82 0.09 0.13 0.26 -0.31 0.00 0.10 0.16 0.08 0.10 0.09 0.19
SLV-1964 El Salvador SLV 1964 US Dollar 2459.91 2274.69 2.98 NA NA 1.29 2139.12 2404.75 2332.53 2232.75 1897.55 NA NA 13026.59 13116.39 14919.76 18561.30 NA NA NA 0.05 1 0.10 0.11 0.11 extrapolated extrapolated market no NA NA 0.83 0.12 0.12 0.26 -0.34 0.00 0.10 0.16 0.08 0.11 0.09 0.20
SLV-1965 El Salvador SLV 1965 US Dollar 2638.42 2413.01 3.07 NA NA 1.29 2302.30 2551.58 2502.29 2375.56 1982.95 NA NA 13802.44 14112.00 15722.13 19365.05 NA NA NA 0.05 1 0.10 0.10 0.11 extrapolated extrapolated market no NA NA 0.84 0.10 0.13 0.25 -0.32 0.00 0.10 0.16 0.08 0.12 0.10 0.20
SLV-1966 El Salvador SLV 1966 US Dollar 2809.26 2571.69 3.18 NA NA 1.30 2499.56 2790.95 2666.59 2550.16 2106.57 NA NA 14927.10 15302.31 17257.17 20419.53 NA NA NA 0.06 1 0.10 0.10 0.11 extrapolated extrapolated market no NA NA 0.85 0.11 0.13 0.23 -0.33 0.00 0.10 0.16 0.07 0.12 0.10 0.19
SLV-1967 El Salvador SLV 1967 US Dollar 2962.03 2743.17 3.29 NA NA 1.30 2645.24 2897.41 2824.93 2745.08 2182.76 NA NA 15570.67 16075.05 17633.51 21093.55 NA NA NA 0.06 1 0.10 0.10 0.11 extrapolated extrapolated market no NA NA 0.83 0.09 0.13 0.24 -0.30 0.00 0.10 0.17 0.07 0.11 0.10 0.20
SLV-1968 El Salvador SLV 1968 US Dollar 2973.30 2871.79 3.41 NA NA 1.31 2685.81 2881.08 2844.07 2889.15 2199.78 NA NA 15887.05 16238.39 17227.88 21297.18 NA NA NA 0.06 1 0.10 0.11 0.10 extrapolated extrapolated market no NA NA 0.79 0.07 0.14 0.25 -0.25 0.00 0.11 0.18 0.07 0.11 0.11 0.21
SLV-1969 El Salvador SLV 1969 US Dollar 3072.13 2982.77 3.53 NA NA 1.31 2770.12 2991.30 2928.17 2991.86 2260.09 NA NA 16480.47 16726.62 17930.42 21689.30 NA NA NA 0.06 1 0.10 0.11 0.10 extrapolated extrapolated market no NA NA 0.77 0.07 0.15 0.23 -0.23 0.00 0.11 0.19 0.07 0.11 0.12 0.22
SLV-1970 El Salvador SLV 1970 US Dollar 3365.30 3070.21 3.67 NA NA 1.32 2927.78 3175.92 3199.56 3084.66 2350.38 NA NA 17229.57 17737.79 19129.14 22254.20 NA NA NA 0.06 1 0.10 0.11 0.11 extrapolated extrapolated market no NA NA 0.79 0.08 0.16 0.21 -0.24 0.00 0.10 0.18 0.07 0.13 0.11 0.21
SLV-1971 El Salvador SLV 1971 US Dollar 3400.10 3162.70 3.77 NA NA 1.33 2983.48 3288.68 3220.79 3166.82 2453.24 NA NA 18064.77 18239.38 20145.91 23028.00 NA NA NA 0.06 1 0.10 0.11 0.11 extrapolated extrapolated market no NA NA 0.79 0.10 0.15 0.21 -0.25 0.00 0.11 0.18 0.08 0.13 0.12 0.22
SLV-1972 El Salvador SLV 1972 US Dollar 3625.13 3332.76 3.86 NA NA 1.34 3142.78 3429.80 3420.30 3342.62 2626.67 NA NA 19058.37 19195.18 20843.31 24376.66 NA NA NA 0.06 1 0.10 0.11 0.11 extrapolated extrapolated market no NA NA 0.77 0.09 0.17 0.24 -0.25 -0.01 0.11 0.19 0.07 0.14 0.13 0.22
SLV-1973 El Salvador SLV 1973 US Dollar 3889.18 3535.08 3.96 NA NA 1.35 3363.57 3739.71 3641.35 3510.52 2769.80 NA NA 20023.17 20695.36 23138.52 25351.46 NA NA NA 0.06 1 0.11 0.12 0.12 extrapolated extrapolated market no NA NA 0.78 0.11 0.17 0.23 -0.30 0.00 0.12 0.21 0.07 0.16 0.14 0.26
SLV-1974 El Salvador SLV 1974 US Dollar 3845.12 3708.94 4.05 NA NA 1.36 3419.45 3909.46 3613.52 3589.11 2981.38 NA NA 21304.77 21122.95 24593.07 26587.17 NA NA NA 0.06 1 0.13 0.14 0.14 extrapolated extrapolated market no NA NA 0.79 0.14 0.17 0.26 -0.36 0.00 0.14 0.24 0.10 0.18 0.17 0.30
SLV-1975 El Salvador SLV 1975 US Dollar 3991.86 3920.17 4.15 1.22 NA 1.37 3559.14 4010.07 3760.65 3768.43 3251.17 NA NA 22492.77 21941.90 24788.35 28534.64 NA NA NA 0.06 1 0.14 0.16 0.16 extrapolated extrapolated market no NA NA 0.77 0.12 0.17 0.27 -0.32 -0.01 0.15 0.29 0.10 0.19 0.19 0.33
SLV-1976 El Salvador SLV 1976 US Dollar 4630.99 4075.13 4.24 1.27 NA 1.38 3937.18 4431.38 4343.84 3940.43 3467.64 NA NA 23378.36 24298.49 27443.89 30453.12 NA NA NA 0.07 1 0.16 0.17 0.19 extrapolated extrapolated market no NA NA 0.81 0.13 0.19 0.24 -0.35 -0.01 0.17 0.30 0.12 0.29 0.20 0.36
SLV-1977 El Salvador SLV 1977 US Dollar 5449.36 4217.09 4.33 1.32 NA 1.39 4365.59 5064.45 5118.73 4090.55 3840.36 NA NA 24789.56 26910.18 32121.75 33198.95 NA NA NA 0.07 1 0.16 0.18 0.23 extrapolated extrapolated market no NA NA 0.88 0.17 0.19 0.20 -0.44 0.00 0.17 0.32 0.14 0.44 0.20 0.37
SLV-1978 El Salvador SLV 1978 US Dollar 5117.85 4515.62 4.42 1.38 NA 1.40 4523.67 5243.15 4798.95 4355.54 4239.02 NA NA 26387.96 27856.90 33214.86 35825.07 NA NA NA 0.07 1 0.19 0.21 0.23 extrapolated extrapolated market no NA NA 0.84 0.17 0.20 0.22 -0.42 0.00 0.20 0.34 0.15 0.32 0.22 0.38
SLV-1979 El Salvador SLV 1979 US Dollar 5126.82 4554.47 4.50 1.44 NA 1.41 4269.27 4817.53 4809.16 4363.93 4503.05 NA NA 25934.36 26117.22 29952.76 37426.36 NA NA NA 0.07 1 0.22 0.24 0.26 extrapolated extrapolated market no NA NA 0.78 0.13 0.20 0.31 -0.41 0.00 0.23 0.37 0.17 0.31 0.23 0.40
SLV-1980 El Salvador SLV 1980 US Dollar 4649.40 4278.78 4.58 1.39 NA 1.42 3981.78 4354.68 4395.12 4056.50 4601.36 NA NA 23680.76 24121.24 26371.44 37785.80 NA NA NA 0.07 1 0.25 0.27 0.29 benchmark extrapolated market no 0.45 NA 0.77 0.09 0.21 0.29 -0.36 0.00 0.27 0.42 0.20 0.34 0.26 0.44
SLV-1981 El Salvador SLV 1981 US Dollar 4158.87 4066.77 4.65 1.39 NA 1.44 3844.26 4213.65 3941.54 3838.30 4800.85 NA NA 21722.37 22491.96 24689.91 37937.38 NA NA NA 0.06 1 0.27 0.29 0.30 interpolated extrapolated market no NA NA 0.77 0.10 0.23 0.24 -0.34 0.00 0.30 0.44 0.20 0.32 0.29 0.46
SLV-1982 El Salvador SLV 1982 US Dollar 4018.59 4018.67 4.72 1.39 NA 1.46 3696.28 4041.96 3824.03 3818.75 4955.20 NA NA 20505.57 20884.33 22829.72 37910.16 NA NA NA 0.06 1 0.30 0.31 0.31 interpolated extrapolated market no NA NA 0.73 0.09 0.24 0.21 -0.26 0.00 0.32 0.45 0.20 0.34 0.33 0.48
SLV-1983 El Salvador SLV 1983 US Dollar 4132.64 4157.73 4.79 1.38 NA 1.48 3822.89 4145.28 3932.27 3985.51 4915.65 NA NA 20663.97 21008.33 22708.59 37828.39 NA NA NA 0.06 1 0.33 0.34 0.34 interpolated extrapolated market no NA NA 0.73 0.08 0.23 0.24 -0.28 0.00 0.36 0.50 0.23 0.35 0.36 0.54
SLV-1984 El Salvador SLV 1984 US Dollar 4359.04 4385.90 4.86 1.38 NA 1.50 4078.10 4414.78 4134.59 4203.64 5056.05 NA NA 21139.17 21835.71 23572.51 37889.25 NA NA NA 0.06 1 0.36 0.37 0.36 interpolated benchmark market no NA NA 0.74 0.08 0.23 0.22 -0.27 0.00 0.39 0.54 0.25 0.36 0.39 0.59
SLV-1985 El Salvador SLV 1985 US Dollar 4607.48 4457.17 4.92 1.37 NA 1.52 4401.04 4728.10 4395.92 4341.91 5212.89 NA NA 21556.77 22713.37 24274.54 38249.86 NA NA NA 0.05 1 0.41 0.43 0.43 interpolated benchmark market no NA NA 0.77 0.08 0.25 0.25 -0.34 0.00 0.46 0.63 0.27 0.38 0.38 0.67
SLV-1986 El Salvador SLV 1986 US Dollar 4992.92 4837.99 4.99 1.43 NA 1.55 4592.70 4999.51 4789.88 4753.40 5513.21 NA NA 21693.57 22798.42 24897.78 38841.21 NA NA NA 0.05 1 0.52 0.54 0.55 interpolated benchmark market no NA NA 0.72 0.09 0.25 0.32 -0.37 0.00 0.58 0.85 0.31 0.43 0.43 0.90
SLV-1987 El Salvador SLV 1987 US Dollar 5051.60 4840.54 5.05 1.49 NA 1.57 4786.57 5187.15 4842.90 4730.77 5833.61 NA NA 22276.77 23019.10 24972.50 39691.29 NA NA NA 0.05 1 0.60 0.63 0.64 interpolated benchmark market no NA NA 0.75 0.08 0.26 0.26 -0.35 0.00 0.69 0.94 0.34 0.48 0.48 0.97
SLV-1988 El Salvador SLV 1988 US Dollar 5382.77 5085.71 5.12 1.54 NA 1.59 5001.59 5500.93 5166.40 4977.86 6169.56 NA NA 22636.77 23238.74 25760.60 40608.01 NA NA NA 0.05 1 0.67 0.70 0.72 interpolated benchmark market no NA NA 0.75 0.10 0.26 0.22 -0.33 0.00 0.78 0.92 0.36 0.51 0.49 0.99
SLV-1989 El Salvador SLV 1989 US Dollar 5544.97 5135.78 5.18 1.60 NA 1.61 5268.28 5894.86 5336.99 5043.73 6527.53 NA NA 22874.37 23690.60 26922.24 41774.36 NA NA NA 0.05 1 0.77 0.79 0.84 interpolated benchmark market no NA NA 0.79 0.12 0.26 0.22 -0.39 0.00 0.89 1.04 0.40 0.51 0.51 1.10
SLV-1990 El Salvador SLV 1990 US Dollar 5535.06 4805.48 5.25 1.67 NA 1.63 5606.01 6046.09 5366.17 4701.27 6861.52 NA NA 23651.96 24139.15 26146.76 42318.50 NA NA NA 0.05 1 0.85 0.89 1.02 interpolated benchmark market no NA NA 0.92 0.09 0.27 0.37 -0.65 0.00 0.98 1.51 0.38 0.51 0.49 1.49
SLV-1991 El Salvador SLV 1991 US Dollar 5936.14 4939.16 5.32 1.73 NA 1.66 5953.35 6497.96 5734.86 4986.13 7202.85 NA NA 24497.86 24875.98 27400.65 43371.30 NA NA NA 0.05 1 0.87 0.93 1.07 interpolated benchmark market no NA NA 0.93 0.11 0.26 0.34 -0.64 0.00 1.01 1.50 0.40 0.54 0.51 1.53
SLV-1992 El Salvador SLV 1992 US Dollar 6504.19 5411.80 5.39 1.79 NA 1.69 6571.22 7304.61 6278.40 5206.08 7687.24 NA NA 26345.81 26750.48 30236.16 45022.50 NA NA NA 0.05 1 0.89 0.95 1.14 interpolated benchmark market no NA NA 1.00 0.14 0.26 0.36 -0.76 0.00 1.01 1.50 0.41 0.51 0.49 1.60
SLV-1993 El Salvador SLV 1993 US Dollar 7346.24 6345.94 5.46 1.89 NA 1.72 7273.72 8122.34 7078.08 6101.31 8461.29 NA NA 28287.37 28806.22 32671.09 47214.08 NA NA NA 0.05 1 0.92 0.98 1.14 interpolated benchmark market no NA NA 0.96 0.14 0.23 0.43 -0.76 0.00 1.03 1.52 0.43 0.51 0.51 1.58
SLV-1994 El Salvador SLV 1994 US Dollar 8207.58 6780.74 5.53 1.97 NA 1.74 8116.86 9098.44 7895.16 6775.15 9419.25 NA NA 29998.86 30968.71 35479.19 49824.06 NA NA NA 0.05 1 0.95 1.02 1.19 interpolated benchmark market no NA NA 0.98 0.14 0.22 0.46 -0.81 0.00 1.06 1.62 0.46 0.51 0.52 1.61
SLV-1995 El Salvador SLV 1995 US Dollar 9318.73 7888.29 5.59 1.99 NA 1.76 9281.09 10435.22 8986.57 7912.95 10640.51 NA NA 31917.76 33815.81 39097.07 53000.34 NA NA NA 0.05 1 0.98 1.06 1.20 interpolated benchmark market no NA NA 0.97 0.15 0.20 0.50 -0.82 0.00 1.08 1.65 0.51 0.52 0.56 1.57
SLV-1996 El Salvador SLV 1996 US Dollar 9934.67 8648.70 5.64 2.02 NA 1.79 9901.10 10819.75 9587.27 8671.39 11636.62 NA NA 32462.15 34372.49 38158.64 55270.48 NA NA NA 0.05 1 1.02 1.08 1.19 interpolated benchmark market no NA NA 0.95 0.11 0.19 0.46 -0.71 0.00 1.10 1.71 0.58 0.54 0.57 1.57
SLV-1997 El Salvador SLV 1997 US Dollar 10864.99 9510.29 5.69 2.04 NA 1.81 10656.52 11679.93 10460.34 9594.17 12896.58 NA NA 33840.60 35405.27 39482.61 57859.71 NA NA NA 0.05 1 1.01 1.06 1.16 interpolated benchmark market no NA NA 0.92 0.11 0.19 0.58 -0.79 0.00 1.10 1.64 0.56 0.52 0.55 1.51
SLV-1998 El Salvador SLV 1998 US Dollar 11822.44 9966.68 5.74 2.13 NA 1.83 11420.49 12730.70 11336.87 10310.08 14480.63 NA NA 35109.19 36252.88 41511.21 60866.61 NA NA NA 0.05 1 1.00 1.06 1.16 interpolated benchmark market no NA NA 0.92 0.13 0.19 0.58 -0.81 0.00 1.08 1.61 0.60 0.50 0.53 1.44
SLV-1999 El Salvador SLV 1999 US Dollar 12738.64 10614.19 5.78 2.15 NA 1.86 12412.75 13745.82 12235.42 11020.90 16210.29 NA NA 36320.14 37471.43 42427.06 63673.29 NA NA NA 0.05 1 0.96 1.02 1.13 interpolated benchmark market no NA 66.67 0.94 0.12 0.18 0.58 -0.83 0.00 1.03 1.54 0.61 0.48 0.51 1.35
SLV-2000 El Salvador SLV 2000 US Dollar 13578.46 11809.71 5.81 2.16 NA 1.88 13529.31 15016.76 13054.28 11988.98 18214.93 NA NA 37101.99 38822.00 43901.07 66648.95 NA NA NA 0.05 1 0.95 1.01 1.10 interpolated benchmark market no NA NA 0.95 0.12 0.18 0.66 -0.91 0.00 1.02 1.49 0.62 0.46 0.51 1.33
SLV-2001 El Salvador SLV 2001 US Dollar 14789.43 12413.91 5.84 2.20 NA 1.89 14839.51 16534.24 14277.92 12442.97 20437.46 NA NA 37736.04 40093.39 45452.23 69572.88 NA NA NA 0.05 1 0.92 0.97 1.11 interpolated benchmark market no NA NA 1.00 0.14 0.19 0.64 -0.97 0.00 0.98 1.36 0.61 0.45 0.48 1.24
SLV-2002 El Salvador SLV 2002 US Dollar 16034.23 13837.70 5.87 2.18 NA 1.91 15961.07 17768.06 15489.48 13999.21 22973.78 NA NA 38619.32 40673.87 45836.98 72607.56 NA NA NA 0.05 1 0.88 0.92 1.02 interpolated benchmark market no NA NA 0.96 0.13 0.18 0.59 -0.86 0.00 0.93 1.30 0.60 0.46 0.49 1.16
SLV-2003 El Salvador SLV 2003 US Dollar 17350.32 15385.29 5.90 2.24 NA 1.92 17365.37 19451.20 16781.77 15672.60 26116.70 NA NA 39507.68 41409.53 47055.91 75721.65 NA NA NA 0.05 1 0.86 0.90 0.96 interpolated benchmark market no NA NA 0.94 0.13 0.17 0.54 -0.78 0.00 0.91 1.22 0.57 0.49 0.53 1.10
SLV-2004 El Salvador SLV 2004 US Dollar 18765.11 16650.42 5.93 2.21 NA 1.93 19149.89 21319.06 18169.02 16952.93 30179.75 NA NA 40238.82 42535.23 47876.02 78393.28 NA NA NA 0.05 1 0.83 0.87 0.93 interpolated benchmark market no NA 68.33 0.97 0.13 0.16 0.48 -0.74 0.00 0.88 1.18 0.55 0.52 0.56 1.02
SLV-2005 El Salvador SLV 2005 US Dollar 20962.34 19788.17 5.95 2.25 NA 1.95 22115.60 24575.89 20735.33 19766.06 35501.44 NA NA 41672.35 44661.03 50177.75 81070.17 NA NA NA 0.05 1 0.79 0.82 0.86 interpolated benchmark market no NA 71.67 0.96 0.12 0.16 0.43 -0.67 0.00 0.83 1.12 0.53 0.52 0.57 0.93
SLV-2006 El Salvador SLV 2006 US Dollar 23670.12 22070.84 5.97 2.30 NA 1.96 25040.70 28038.22 23271.09 22347.13 42249.99 NA NA 43302.64 46758.60 53000.10 84467.60 NA NA NA 0.05 1 0.77 0.80 0.83 interpolated benchmark market no NA 71.67 0.97 0.13 0.15 0.39 -0.64 0.00 0.80 1.04 0.55 0.55 0.60 0.83
SLV-2007 El Salvador SLV 2007 US Dollar 26954.08 25463.66 5.99 2.37 NA 1.98 29046.20 32438.27 26499.25 25836.85 49601.39 NA NA 44965.51 49451.01 55837.31 88289.65 NA NA NA 0.05 1 0.73 0.76 0.78 interpolated benchmark market no NA 73.33 0.99 0.13 0.14 0.33 -0.58 0.00 0.76 0.97 0.53 0.61 0.64 0.75
SLV-2008 El Salvador SLV 2008 US Dollar 30053.27 28863.73 6.00 2.38 NA 1.99 33050.30 36672.09 29859.18 28644.17 57652.11 NA NA 45538.08 50258.55 56225.36 91446.33 NA NA NA 0.05 1 0.70 0.72 0.75 interpolated benchmark market no NA 83.33 1.02 0.13 0.13 0.29 -0.57 0.00 0.72 0.90 0.52 0.69 0.65 0.70
SLV-2009 El Salvador SLV 2009 US Dollar 32585.90 31136.00 6.02 2.36 NA 2.00 33882.79 37215.62 32227.38 31383.49 66042.59 NA NA 44111.37 45806.52 50506.80 92998.63 NA NA NA 0.05 1 0.62 0.64 0.66 interpolated benchmark market no NA 83.33 0.95 0.11 0.13 0.23 -0.41 0.00 0.64 0.83 0.52 0.68 0.62 0.65
SLV-2010 El Salvador SLV 2010 US Dollar 37684.82 37108.66 6.04 2.39 NA 2.02 39829.33 43812.20 37471.93 37264.89 77955.60 NA NA 44713.64 46830.70 51644.92 94734.91 NA NA NA 0.05 1 0.56 0.57 0.57 interpolated benchmark market no NA 90.00 0.95 0.11 0.12 0.22 -0.39 0.00 0.56 0.72 0.50 0.69 0.63 0.56
SLV-2011 El Salvador SLV 2011 US Dollar 45166.76 45704.81 6.06 2.45 NA 2.05 48017.28 53605.34 45166.76 45704.81 97264.73 NA NA 45704.81 48017.28 53605.34 97264.73 NA NA NA 0.05 1 0.50 0.51 0.51 benchmark benchmark market no 0.64 85.56 0.94 0.12 0.11 0.19 -0.37 0.00 0.50 0.59 0.52 0.73 0.64 0.47
SLV-2012 El Salvador SLV 2012 US Dollar 46164.43 47179.36 6.07 2.51 NA 2.08 49224.95 54663.91 46147.61 46956.67 99345.64 NA NA 46564.57 49170.92 54642.68 99598.18 NA NA NA 0.05 1 0.50 0.52 0.51 extrapolated benchmark market no NA 91.00 0.94 0.12 0.11 0.19 -0.35 0.00 0.50 0.62 0.53 0.69 0.63 0.49
SLV-2013 El Salvador SLV 2013 US Dollar 46742.54 47392.96 6.09 2.56 NA 2.11 49761.24 55572.07 46618.41 47147.33 103172.30 NA NA 47424.43 49694.70 55754.14 102483.91 NA NA NA 0.05 1 0.51 0.52 0.52 extrapolated benchmark market no NA 91.11 0.94 0.12 0.11 0.19 -0.37 0.00 0.51 0.63 0.54 0.70 0.63 0.48
SLV-2014 El Salvador SLV 2014 US Dollar 47903.34 48970.29 6.11 2.60 NA 2.14 50944.91 56342.74 47846.68 48643.55 107174.82 NA NA 48350.45 50767.72 56361.07 104730.74 NA NA NA 0.05 1 0.51 0.53 0.52 extrapolated benchmark market no NA 91.11 0.94 0.11 0.11 0.19 -0.35 0.00 0.51 0.63 0.55 0.70 0.65 0.47

2. Construya una funcion que le permita elegir todas las variables de la categoria “Trade detail”, muestre su uso para los datos de Argentina.

funcion_TradeDetail <- function(iso_pais){
  enquo(iso_pais)->iso_pais
  pwt9.0 %>% filter(isocode==!!iso_pais) %>%
    select(country,isocode,year,currency,csh_c,csh_x,csh_m,pl_c,pl_x,pl_m)->TradeDetail
  return(TradeDetail)
}

funcion_TradeDetail(iso_pais = "ARG") %>% 
  kable(caption = "Datos del Trade detail de Argentina de 1950 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE)
Datos del Trade detail de Argentina de 1950 a 2014
country isocode year currency csh_c csh_x csh_m pl_c pl_x pl_m
ARG-1950 Argentina ARG 1950 Argentine Peso 0.79 0.11 -0.05 0.21 0.13 0.12
ARG-1951 Argentina ARG 1951 Argentine Peso 0.79 0.09 -0.07 0.23 0.16 0.13
ARG-1952 Argentina ARG 1952 Argentine Peso 0.81 0.07 -0.05 0.25 0.14 0.15
ARG-1953 Argentina ARG 1953 Argentine Peso 0.76 0.10 -0.04 0.26 0.12 0.11
ARG-1954 Argentina ARG 1954 Argentine Peso 0.79 0.10 -0.05 0.25 0.10 0.10
ARG-1955 Argentina ARG 1955 Argentine Peso 0.81 0.08 -0.05 0.26 0.12 0.12
ARG-1956 Argentina ARG 1956 Argentine Peso 0.78 0.09 -0.04 0.27 0.22 0.25
ARG-1957 Argentina ARG 1957 Argentine Peso 0.79 0.09 -0.05 0.28 0.20 0.25
ARG-1958 Argentina ARG 1958 Argentine Peso 0.79 0.08 -0.04 0.27 0.19 0.23
ARG-1959 Argentina ARG 1959 Argentine Peso 0.76 0.09 -0.04 0.29 0.25 0.28
ARG-1960 Argentina ARG 1960 Argentine Peso 0.74 0.09 -0.05 0.30 0.25 0.23
ARG-1961 Argentina ARG 1961 Argentine Peso 0.76 0.07 -0.06 0.29 0.24 0.17
ARG-1962 Argentina ARG 1962 Argentine Peso 0.76 0.10 -0.05 0.31 0.14 0.30
ARG-1963 Argentina ARG 1963 Argentine Peso 0.76 0.09 -0.05 0.32 0.21 0.32
ARG-1964 Argentina ARG 1964 Argentine Peso 0.77 0.09 -0.06 0.33 0.19 0.22
ARG-1965 Argentina ARG 1965 Argentine Peso 0.79 0.07 -0.07 0.30 0.22 0.18
ARG-1966 Argentina ARG 1966 Argentine Peso 0.76 0.08 -0.04 0.31 0.20 0.25
ARG-1967 Argentina ARG 1967 Argentine Peso 0.76 0.07 -0.05 0.32 0.25 0.27
ARG-1968 Argentina ARG 1968 Argentine Peso 0.77 0.06 -0.05 0.34 0.25 0.30
ARG-1969 Argentina ARG 1969 Argentine Peso 0.75 0.07 -0.05 0.37 0.25 0.34
ARG-1970 Argentina ARG 1970 Argentine Peso 0.74 0.09 -0.05 0.36 0.22 0.32
ARG-1971 Argentina ARG 1971 Argentine Peso 0.75 0.07 -0.06 0.42 0.26 0.34
ARG-1972 Argentina ARG 1972 Argentine Peso 0.74 0.04 -0.03 0.39 0.28 0.36
ARG-1973 Argentina ARG 1973 Argentine Peso 0.73 0.05 -0.03 0.40 0.27 0.31
ARG-1974 Argentina ARG 1974 Argentine Peso 0.74 0.05 -0.03 0.42 0.25 0.32
ARG-1975 Argentina ARG 1975 Argentine Peso 0.75 0.09 -0.10 0.42 0.27 0.33
ARG-1976 Argentina ARG 1976 Argentine Peso 0.68 0.07 -0.04 0.48 0.34 0.44
ARG-1977 Argentina ARG 1977 Argentine Peso 0.66 0.13 -0.06 0.54 0.32 0.45
ARG-1978 Argentina ARG 1978 Argentine Peso 0.66 0.13 -0.06 0.57 0.28 0.39
ARG-1979 Argentina ARG 1979 Argentine Peso 0.71 0.12 -0.08 0.62 0.24 0.31
ARG-1980 Argentina ARG 1980 Argentine Peso 0.77 0.11 -0.13 0.63 0.21 0.23
ARG-1981 Argentina ARG 1981 Argentine Peso 0.76 0.11 -0.12 0.67 0.29 0.30
ARG-1982 Argentina ARG 1982 Argentine Peso 0.73 0.14 -0.08 0.67 0.39 0.48
ARG-1983 Argentina ARG 1983 Argentine Peso 0.73 0.11 -0.05 0.67 0.42 0.52
ARG-1984 Argentina ARG 1984 Argentine Peso 0.74 0.11 -0.06 0.67 0.38 0.43
ARG-1985 Argentina ARG 1985 Argentine Peso 0.69 0.15 -0.06 0.69 0.38 0.42
ARG-1986 Argentina ARG 1986 Argentine Peso 0.76 0.10 -0.06 0.73 0.42 0.45
ARG-1987 Argentina ARG 1987 Argentine Peso 0.76 0.08 -0.07 0.69 0.47 0.50
ARG-1988 Argentina ARG 1988 Argentine Peso 0.73 0.10 -0.05 0.78 0.49 0.54
ARG-1989 Argentina ARG 1989 Argentine Peso 0.70 0.11 -0.04 0.50 0.50 0.53
ARG-1990 Argentina ARG 1990 Argentine Peso 0.76 0.12 -0.04 0.78 0.50 0.54
ARG-1991 Argentina ARG 1991 Argentine Peso 0.80 0.09 -0.06 0.89 0.57 0.59
ARG-1992 Argentina ARG 1992 Argentine Peso 0.80 0.09 -0.10 0.92 0.49 0.53
ARG-1993 Argentina ARG 1993 Argentine Peso 0.77 0.08 -0.10 0.83 0.51 0.52
ARG-1994 Argentina ARG 1994 Argentine Peso 0.75 0.08 -0.10 0.81 0.53 0.55
ARG-1995 Argentina ARG 1995 Argentine Peso 0.69 0.09 -0.08 0.77 0.57 0.59
ARG-1996 Argentina ARG 1996 Argentine Peso 0.62 0.08 -0.08 0.71 0.58 0.59
ARG-1997 Argentina ARG 1997 Argentine Peso 0.65 0.08 -0.10 0.72 0.57 0.57
ARG-1998 Argentina ARG 1998 Argentine Peso 0.67 0.09 -0.10 0.71 0.53 0.54
ARG-1999 Argentina ARG 1999 Argentine Peso 0.69 0.09 -0.09 0.69 0.52 0.54
ARG-2000 Argentina ARG 2000 Argentine Peso 0.69 0.10 -0.09 0.69 0.49 0.51
ARG-2001 Argentina ARG 2001 Argentine Peso 0.69 0.11 -0.08 0.69 0.48 0.49
ARG-2002 Argentina ARG 2002 Argentine Peso 0.69 0.13 -0.04 0.27 0.48 0.48
ARG-2003 Argentina ARG 2003 Argentine Peso 0.69 0.12 -0.06 0.33 0.53 0.51
ARG-2004 Argentina ARG 2004 Argentine Peso 0.69 0.12 -0.08 0.35 0.57 0.54
ARG-2005 Argentina ARG 2005 Argentine Peso 0.70 0.13 -0.09 0.38 0.59 0.56
ARG-2006 Argentina ARG 2006 Argentine Peso 0.69 0.13 -0.10 0.41 0.61 0.58
ARG-2007 Argentina ARG 2007 Argentine Peso 0.69 0.13 -0.11 0.47 0.67 0.63
ARG-2008 Argentina ARG 2008 Argentine Peso 0.69 0.14 -0.12 0.55 0.74 0.69
ARG-2009 Argentina ARG 2009 Argentine Peso 0.72 0.12 -0.09 0.52 0.69 0.64
ARG-2010 Argentina ARG 2010 Argentine Peso 0.71 0.13 -0.11 0.57 0.71 0.67
ARG-2011 Argentina ARG 2011 Argentine Peso 0.71 0.13 -0.13 0.62 0.75 0.70
ARG-2012 Argentina ARG 2012 Argentine Peso 0.72 0.13 -0.11 0.66 0.74 0.73
ARG-2013 Argentina ARG 2013 Argentine Peso 0.74 0.12 -0.12 0.64 0.75 0.70
ARG-2014 Argentina ARG 2014 Argentine Peso 0.74 0.11 -0.11 0.55 0.75 0.71

3. Use las funciones creadas en 1 y 2, para generar 2 DataFrames, que muestren los datos de “Mexico” y “Canada”, para el periodo de 2000-2014.

funcion_elegir_pais(iso_pais = "CAN",2000,2014) %>%
  kable(caption = "Datos de Canada de 2000 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Canada de 2000 a 2014
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
CAN-2000 Canada CAN 2000 Canadian Dollar 1167052 1127565 30.70 14.87 1779.13 3.50 795599.8 1074248 1139711 1150584 3311462 0.91 0.82 1170880 762779.9 1027360 3784067 1.04 0.92 0.61 0.04 1.49 0.68 0.65 0.64 interpolated benchmark market no NA NA 0.54 0.24 0.15 0.43 -0.37 0.01 0.64 0.55 0.83 0.56 0.56 0.62
CAN-2001 Canada CAN 2001 Canadian Dollar 1166188 1119308 30.99 15.06 1767.99 3.52 814203.9 1079932 1145022 1144414 3268334 0.90 0.82 1190649 782785.5 1041029 3905941 1.03 0.91 0.62 0.04 1.55 0.67 0.64 0.64 interpolated benchmark market no NA NA 0.56 0.23 0.15 0.42 -0.36 0.00 0.63 0.55 0.82 0.55 0.53 0.63
CAN-2002 Canada CAN 2002 Canadian Dollar 1173454 1127791 31.29 15.45 1749.47 3.53 836753.2 1105706 1156510 1159323 3207820 0.90 0.81 1224009 808856.4 1073323 4024192 1.04 0.92 0.62 0.04 1.57 0.68 0.65 0.65 benchmark benchmark market no NA NA 0.57 0.23 0.15 0.41 -0.37 0.00 0.64 0.56 0.84 0.53 0.52 0.67
CAN-2003 Canada CAN 2003 Canadian Dollar 1211094 1184269 31.60 15.85 1732.14 3.55 858441.9 1148489 1194611 1200543 3349291 0.89 0.81 1247575 832796.8 1119539 4151862 1.03 0.94 0.61 0.04 1.40 0.78 0.74 0.74 interpolated benchmark market no NA NA 0.56 0.24 0.15 0.39 -0.35 0.00 0.73 0.63 0.96 0.58 0.57 0.76
CAN-2004 Canada CAN 2004 Canadian Dollar 1260986 1235663 31.92 16.16 1751.06 3.56 877820.4 1189845 1244977 1252623 3571504 0.88 0.79 1286734 855641.8 1164602 4297140 1.03 0.94 0.61 0.04 1.30 0.86 0.82 0.81 interpolated benchmark market no NA NA 0.55 0.25 0.15 0.41 -0.36 0.00 0.81 0.70 1.05 0.62 0.61 0.83
CAN-2005 Canada CAN 2005 Canadian Dollar 1311424 1323181 32.26 16.44 1739.18 3.58 918976.9 1263380 1315081 1326233 3865556 0.90 0.80 1327435 882079.1 1221829 4462552 1.04 0.96 0.60 0.04 1.21 0.93 0.89 0.88 benchmark benchmark market no 0.90 NA 0.54 0.26 0.15 0.43 -0.39 0.00 0.87 0.77 1.13 0.63 0.62 0.89
CAN-2006 Canada CAN 2006 Canadian Dollar 1343928 1342066 32.61 16.79 1733.23 3.59 940558.9 1304562 1340375 1357210 4208085 0.89 0.80 1362237 915601.1 1273821 4637972 1.03 0.98 0.61 0.04 1.13 1.03 0.98 0.97 interpolated benchmark market no NA NA 0.54 0.27 0.15 0.45 -0.41 0.00 0.97 0.86 1.23 0.64 0.63 0.96
CAN-2007 Canada CAN 2007 Canadian Dollar 1376870 1384391 32.98 17.27 1724.69 3.61 969776.7 1342214 1370408 1395106 4445640 0.88 0.80 1389595 950916.3 1319552 4812567 1.02 0.98 0.61 0.04 1.07 1.11 1.06 1.04 interpolated benchmark market no NA NA 0.54 0.27 0.16 0.44 -0.40 -0.01 1.05 0.94 1.31 0.68 0.68 1.05
CAN-2008 Canada CAN 2008 Canadian Dollar 1404807 1456291 33.36 17.66 1713.39 3.62 1002613.3 1383169 1407829 1452164 4607176 0.90 0.81 1405929 982824.2 1358207 4983390 1.01 0.98 0.60 0.04 1.07 1.14 1.10 1.06 interpolated benchmark market no NA NA 0.53 0.26 0.16 0.44 -0.38 -0.01 1.09 0.97 1.33 0.71 0.74 1.11
CAN-2009 Canada CAN 2009 Canadian Dollar 1310934 1304883 33.75 17.44 1678.52 3.64 1000717.9 1325223 1306457 1323073 4794360 0.81 0.79 1367808 994270.1 1323141 5106391 0.99 0.97 0.63 0.04 1.14 1.09 1.05 1.04 interpolated benchmark market no NA NA 0.57 0.25 0.18 0.35 -0.34 -0.01 1.04 0.92 1.27 0.69 0.72 1.02
CAN-2010 Canada CAN 2010 Canadian Dollar 1371811 1387124 34.13 17.74 1685.54 3.66 1030334.4 1393576 1368504 1389695 5065393 0.80 0.78 1413961 1025854.7 1393300 5261183 0.99 0.99 0.61 0.04 1.03 1.23 1.18 1.16 interpolated benchmark market no NA NA 0.56 0.26 0.18 0.40 -0.39 -0.01 1.17 1.04 1.40 0.69 0.72 1.13
CAN-2011 Canada CAN 2011 Canadian Dollar 1423920 1455816 34.50 18.08 1683.57 3.66 1045868.8 1440603 1423920 1455816 5427466 0.81 0.77 1455816 1045868.8 1440603 5427466 1.00 1.00 0.61 0.04 0.99 1.32 1.26 1.23 benchmark benchmark market no 0.82 NA 0.54 0.27 0.18 0.44 -0.42 -0.01 1.26 1.09 1.49 0.71 0.74 1.16
CAN-2012 Canada CAN 2012 Canadian Dollar 1447882 1470333 34.87 18.34 1692.85 3.67 1064437.2 1469014 1443117 1454780 5597287 0.78 0.76 1483809 1063769.8 1472486 5605514 0.99 1.00 0.62 0.04 1.00 1.32 1.27 1.26 extrapolated benchmark market no NA NA 0.55 0.28 0.18 0.43 -0.43 -0.01 1.26 1.13 1.52 0.73 0.75 1.18
CAN-2013 Canada CAN 2013 Canadian Dollar 1478439 1493624 35.23 18.67 1682.74 3.68 1086339.8 1488701 1465085 1472069 5828469 0.78 0.76 1513537 1084256.5 1500049 5779532 0.99 0.99 0.62 0.04 1.03 1.31 1.26 1.25 extrapolated benchmark market no NA NA 0.56 0.27 0.18 0.42 -0.42 -0.01 1.24 1.12 1.51 0.74 0.75 1.15
CAN-2014 Canada CAN 2014 Canadian Dollar 1507209 1543374 35.59 18.83 1687.78 3.68 1109991.0 1505819 1492422 1522929 6097225 0.78 0.74 1550457 1104841.9 1518445 5949967 1.00 0.99 0.62 0.04 1.11 1.24 1.20 1.17 extrapolated benchmark market no NA NA 0.56 0.26 0.17 0.42 -0.40 -0.02 1.17 1.08 1.44 0.73 0.76 1.08
funcion_elegir_pais(iso_pais = "MEX",2000,2014) %>%
  kable(caption = "Datos de Mexico de 2000 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Mexico de 2000 a 2014
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
MEX-2000 Mexico MEX 2000 Mexican Peso 1241567 1203299 102.81 38.61 2173.99 2.42 976115.5 1233276 1210525 1196573 2683662 0.68 0.67 1458667 1084404 1414794 3850000 1.15 1.09 0.47 0.04 9.46 0.51 0.54 0.54 interpolated benchmark market no NA NA 0.67 0.21 0.14 0.26 -0.29 0.00 0.53 0.64 0.39 0.53 0.51 0.67
MEX-2001 Mexico MEX 2001 Mexican Peso 1249929 1211921 104.24 38.72 2145.48 2.44 1002729.4 1246226 1224590 1206757 2614578 0.69 0.68 1458188 1104663 1422147 4003552 1.13 1.08 0.48 0.04 9.34 0.55 0.57 0.58 interpolated benchmark market no NA NA 0.69 0.20 0.14 0.25 -0.28 0.00 0.57 0.64 0.43 0.52 0.50 0.75
MEX-2002 Mexico MEX 2002 Mexican Peso 1265801 1217542 105.58 39.60 2196.15 2.46 1021844.4 1259728 1243224 1219592 2552782 0.68 0.67 1469444 1119253 1433203 4150159 1.09 1.04 0.48 0.04 9.66 0.56 0.58 0.59 benchmark benchmark market no NA NA 0.69 0.20 0.14 0.25 -0.28 0.00 0.58 0.67 0.46 0.53 0.49 0.81
MEX-2003 Mexico MEX 2003 Mexican Peso 1307663 1254357 106.89 39.89 2142.68 2.48 1062501.9 1300092 1284939 1250878 2751030 0.67 0.67 1489874 1165511 1465882 4294486 1.09 1.05 0.47 0.04 10.79 0.53 0.56 0.57 interpolated benchmark market no NA NA 0.71 0.19 0.14 0.23 -0.27 0.00 0.55 0.66 0.46 0.57 0.51 0.75
MEX-2004 Mexico MEX 2004 Mexican Peso 1399936 1345215 108.26 41.24 2123.36 2.50 1114709.0 1384239 1376237 1344221 3077106 0.69 0.67 1552597 1225134 1551886 4461555 1.09 1.07 0.44 0.04 11.29 0.54 0.56 0.57 interpolated benchmark market no NA 74.44 0.70 0.20 0.13 0.24 -0.27 0.01 0.55 0.65 0.47 0.58 0.53 0.72
MEX-2005 Mexico MEX 2005 Mexican Peso 1462673 1458528 109.75 41.54 2188.80 2.52 1182328.0 1473434 1461590 1451331 3530969 0.70 0.65 1600348 1276755 1613770 4645160 1.08 1.07 0.43 0.04 10.90 0.57 0.59 0.60 benchmark benchmark market no 0.71 72.22 0.69 0.20 0.13 0.24 -0.26 0.00 0.59 0.66 0.50 0.61 0.59 0.70
MEX-2006 Mexico MEX 2006 Mexican Peso 1581637 1542631 111.38 43.07 2141.32 2.54 1244907.5 1576208 1571088 1546752 3770402 0.73 0.69 1679987 1343449 1719133 4852529 1.09 1.10 0.41 0.04 10.90 0.60 0.61 0.62 interpolated benchmark market no NA 68.89 0.67 0.21 0.13 0.26 -0.28 0.00 0.62 0.68 0.50 0.63 0.59 0.73
MEX-2007 Mexico MEX 2007 Mexican Peso 1654108 1615149 113.14 43.90 2125.25 2.56 1292900.2 1643707 1640507 1619805 3924124 0.75 0.71 1734164 1383181 1772975 5074072 1.09 1.10 0.40 0.04 10.93 0.62 0.64 0.64 interpolated benchmark market no NA 70.00 0.66 0.22 0.14 0.25 -0.27 0.01 0.65 0.70 0.48 0.67 0.64 0.76
MEX-2008 Mexico MEX 2008 Mexican Peso 1693705 1677677 114.97 45.01 2173.36 2.57 1345486.1 1729921 1692513 1672410 4036200 0.75 0.73 1758094 1411593 1826431 5305337 1.05 1.08 0.39 0.04 11.13 0.64 0.65 0.66 interpolated benchmark market no NA 77.78 0.65 0.23 0.15 0.24 -0.27 -0.01 0.68 0.70 0.47 0.72 0.68 0.81
MEX-2009 Mexico MEX 2009 Mexican Peso 1613604 1573495 116.82 44.60 2081.58 2.59 1292132.4 1632260 1604184 1582176 4474887 0.67 0.67 1674696 1337705 1695299 5489144 1.00 1.00 0.43 0.04 13.51 0.54 0.56 0.56 interpolated benchmark market no NA 81.11 0.64 0.21 0.18 0.21 -0.23 -0.01 0.59 0.60 0.38 0.68 0.64 0.64
MEX-2010 Mexico MEX 2010 Mexican Peso 1734610 1694514 118.62 48.30 2128.04 2.60 1381195.4 1742997 1728535 1697135 5054693 0.64 0.63 1761765 1405426 1779081 5671746 0.99 0.98 0.41 0.04 12.64 0.60 0.61 0.62 interpolated benchmark market no NA 85.56 0.63 0.21 0.19 0.25 -0.27 -0.01 0.66 0.64 0.39 0.71 0.66 0.65
MEX-2011 Mexico MEX 2011 Mexican Peso 1857210 1830819 120.37 48.62 2132.34 2.62 1467974.5 1862050 1857210 1830819 5878632 0.63 0.62 1830819 1467975 1862050 5878632 1.00 1.00 0.39 0.04 12.42 0.62 0.63 0.64 benchmark benchmark market no 0.73 88.89 0.61 0.22 0.19 0.26 -0.27 0.00 0.69 0.66 0.39 0.74 0.70 0.62
MEX-2012 Mexico MEX 2012 Mexican Peso 1908250 1862729 122.07 50.83 2106.86 2.64 1535906.1 1947835 1903657 1851572 6089364 0.61 0.62 1904764 1537147 1954599 6096434 1.00 1.01 0.39 0.04 13.17 0.61 0.62 0.64 extrapolated benchmark market no NA 88.00 0.64 0.22 0.19 0.27 -0.30 -0.02 0.68 0.66 0.39 0.74 0.67 0.61
MEX-2013 Mexico MEX 2013 Mexican Peso 1923613 1906050 123.74 51.17 2132.91 2.66 1567321.4 1961958 1910813 1891480 6357979 0.61 0.61 1931333 1568746 1977048 6297162 0.99 0.99 0.39 0.04 12.77 0.65 0.66 0.67 extrapolated benchmark market no NA 87.78 0.64 0.21 0.19 0.27 -0.28 -0.03 0.72 0.69 0.42 0.75 0.72 0.62
MEX-2014 Mexico MEX 2014 Mexican Peso 1987688 1945966 125.39 51.41 2136.77 2.68 1602949.4 2009978 1974138 1934006 6677512 0.60 0.60 1974418 1601032 2025506 6498114 0.98 0.99 0.39 0.04 13.29 0.65 0.66 0.67 extrapolated benchmark market no NA 85.56 0.64 0.21 0.19 0.27 -0.29 -0.02 0.72 0.69 0.42 0.76 0.70 0.60
funcion_TradeDetail(iso_pais = "MEX") %>% 
  filter(year %in% 2000:2014) %>%
  kable(caption = "Datos del Trade detail de Mexico de 2000 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos del Trade detail de Mexico de 2000 a 2014
country isocode year currency csh_c csh_x csh_m pl_c pl_x pl_m
MEX-2000 Mexico MEX 2000 Mexican Peso 0.67 0.26 -0.29 0.53 0.53 0.51
MEX-2001 Mexico MEX 2001 Mexican Peso 0.69 0.25 -0.28 0.57 0.52 0.50
MEX-2002 Mexico MEX 2002 Mexican Peso 0.69 0.25 -0.28 0.58 0.53 0.49
MEX-2003 Mexico MEX 2003 Mexican Peso 0.71 0.23 -0.27 0.55 0.57 0.51
MEX-2004 Mexico MEX 2004 Mexican Peso 0.70 0.24 -0.27 0.55 0.58 0.53
MEX-2005 Mexico MEX 2005 Mexican Peso 0.69 0.24 -0.26 0.59 0.61 0.59
MEX-2006 Mexico MEX 2006 Mexican Peso 0.67 0.26 -0.28 0.62 0.63 0.59
MEX-2007 Mexico MEX 2007 Mexican Peso 0.66 0.25 -0.27 0.65 0.67 0.64
MEX-2008 Mexico MEX 2008 Mexican Peso 0.65 0.24 -0.27 0.68 0.72 0.68
MEX-2009 Mexico MEX 2009 Mexican Peso 0.64 0.21 -0.23 0.59 0.68 0.64
MEX-2010 Mexico MEX 2010 Mexican Peso 0.63 0.25 -0.27 0.66 0.71 0.66
MEX-2011 Mexico MEX 2011 Mexican Peso 0.61 0.26 -0.27 0.69 0.74 0.70
MEX-2012 Mexico MEX 2012 Mexican Peso 0.64 0.27 -0.30 0.68 0.74 0.67
MEX-2013 Mexico MEX 2013 Mexican Peso 0.64 0.27 -0.28 0.72 0.75 0.72
MEX-2014 Mexico MEX 2014 Mexican Peso 0.64 0.27 -0.29 0.72 0.76 0.70
funcion_TradeDetail(iso_pais = "CAN") %>% 
  filter(year %in% 2000:2014) %>%
  kable(caption = "Datos del Trade detail de Canada de 2000 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos del Trade detail de Canada de 2000 a 2014
country isocode year currency csh_c csh_x csh_m pl_c pl_x pl_m
CAN-2000 Canada CAN 2000 Canadian Dollar 0.54 0.43 -0.37 0.64 0.56 0.56
CAN-2001 Canada CAN 2001 Canadian Dollar 0.56 0.42 -0.36 0.63 0.55 0.53
CAN-2002 Canada CAN 2002 Canadian Dollar 0.57 0.41 -0.37 0.64 0.53 0.52
CAN-2003 Canada CAN 2003 Canadian Dollar 0.56 0.39 -0.35 0.73 0.58 0.57
CAN-2004 Canada CAN 2004 Canadian Dollar 0.55 0.41 -0.36 0.81 0.62 0.61
CAN-2005 Canada CAN 2005 Canadian Dollar 0.54 0.43 -0.39 0.87 0.63 0.62
CAN-2006 Canada CAN 2006 Canadian Dollar 0.54 0.45 -0.41 0.97 0.64 0.63
CAN-2007 Canada CAN 2007 Canadian Dollar 0.54 0.44 -0.40 1.05 0.68 0.68
CAN-2008 Canada CAN 2008 Canadian Dollar 0.53 0.44 -0.38 1.09 0.71 0.74
CAN-2009 Canada CAN 2009 Canadian Dollar 0.57 0.35 -0.34 1.04 0.69 0.72
CAN-2010 Canada CAN 2010 Canadian Dollar 0.56 0.40 -0.39 1.17 0.69 0.72
CAN-2011 Canada CAN 2011 Canadian Dollar 0.54 0.44 -0.42 1.26 0.71 0.74
CAN-2012 Canada CAN 2012 Canadian Dollar 0.55 0.43 -0.43 1.26 0.73 0.75
CAN-2013 Canada CAN 2013 Canadian Dollar 0.56 0.42 -0.42 1.24 0.74 0.75
CAN-2014 Canada CAN 2014 Canadian Dollar 0.56 0.42 -0.40 1.17 0.73 0.76

Clave 2.

Usando los datos de la Penn World Table, de la Universidad de Groningen.

Resuelva los siguientes requerimientos (es importante mostrar todos sus resultados en formato tabular):

1 Construya una funcion que le permita eleger el pais y filtrar para un periodo (inicio, final). Muestre su uso filtrando los datos para Guatemala, en el periodo de 1990-2014.

data("pwt9.0")
options(scipen = 999999)
#crear la funcion.
funcion_elegir_pais2 <- function(iso_pais,anio_ini,anio_fin){
  enquo(iso_pais)->iso_pais
  pwt9.0 %>% filter(isocode==!!iso_pais,
                    year>=anio_ini,
                    year<=anio_fin)-> elegir_pais2
  return(elegir_pais2)
}
#Probando la funcion.
funcion_elegir_pais2(iso_pais = "GTM",1990,2014) %>%
  kable(caption = "Datos de Guatemala de 1990 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Guatemala de 1990 a 2014
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
GTM-1990 Guatemala GTM 1990 Quetzal 33234.62 34222.74 9.16 2.54 NA 1.51 32241.00 35134.41 33063.18 34293.31 45778.58 0.88 0.89 46215.35 41905.34 47471.36 126784.4 0.96 0.90 0.46 0.07 4.49 0.19 0.21 0.20 interpolated benchmark market no NA NA 0.83 0.08 0.11 0.07 -0.10 0.01 0.20 0.35 0.17 0.52 0.49 0.30
GTM-1991 Guatemala GTM 1991 Quetzal 35438.66 36470.83 9.38 2.61 NA 1.52 33555.41 37250.09 35158.59 36600.20 47208.34 0.90 0.92 47906.02 43432.05 50421.88 129355.2 0.97 0.94 0.46 0.07 5.03 0.23 0.24 0.23 interpolated benchmark market no NA NA 0.82 0.10 0.10 0.06 -0.10 0.02 0.23 0.36 0.18 0.54 0.53 0.30
GTM-1992 Guatemala GTM 1992 Quetzal 36326.25 37987.71 9.62 2.72 NA 1.53 35497.80 40458.93 35981.47 37812.49 49587.25 0.86 0.91 50223.88 45647.37 54848.88 133586.8 0.98 0.98 0.46 0.07 5.17 0.24 0.26 0.25 interpolated benchmark market no NA NA 0.84 0.13 0.10 0.07 -0.14 0.00 0.25 0.38 0.21 0.50 0.47 0.36
GTM-1993 Guatemala GTM 1993 Quetzal 38583.34 40375.68 9.86 2.83 NA 1.55 37369.67 42216.37 38180.74 40147.47 53500.32 0.86 0.89 52196.79 47680.36 56266.14 140097.1 0.96 0.95 0.46 0.07 5.64 0.25 0.27 0.25 interpolated benchmark market no NA NA 0.83 0.12 0.10 0.07 -0.14 0.03 0.25 0.40 0.22 0.51 0.47 0.33
GTM-1994 Guatemala GTM 1994 Quetzal 41145.23 42164.69 10.11 2.96 NA 1.56 39555.75 44458.89 40625.70 42118.18 57302.10 0.84 0.88 54301.95 49909.42 58601.23 144104.8 0.96 0.95 0.46 0.07 5.75 0.27 0.28 0.27 interpolated benchmark market no NA NA 0.84 0.12 0.10 0.07 -0.13 0.00 0.27 0.41 0.23 0.51 0.48 0.37
GTM-1995 Guatemala GTM 1995 Quetzal 43889.57 45114.49 10.36 3.03 NA 1.58 42208.83 47068.03 43522.26 45290.43 62316.18 0.86 0.88 56981.12 52361.34 60906.52 150601.8 0.96 0.94 0.46 0.07 5.81 0.28 0.30 0.29 interpolated benchmark market no NA NA 0.84 0.11 0.09 0.08 -0.14 0.02 0.29 0.45 0.24 0.55 0.52 0.33
GTM-1996 Guatemala GTM 1996 Quetzal 45516.44 46279.23 10.61 3.08 NA 1.59 43993.85 48135.54 45269.62 46609.67 66182.52 0.83 0.85 58669.06 53711.55 60829.76 154488.9 0.97 0.92 0.46 0.07 6.05 0.30 0.31 0.30 interpolated benchmark market no NA NA 0.86 0.09 0.08 0.08 -0.13 0.02 0.30 0.48 0.25 0.56 0.53 0.37
GTM-1997 Guatemala GTM 1997 Quetzal 48241.86 48901.27 10.87 3.18 NA 1.61 46064.64 51158.18 47688.03 49022.37 72300.22 0.81 0.84 61235.07 55940.71 64595.59 163422.1 0.96 0.93 0.46 0.07 6.07 0.32 0.33 0.32 interpolated benchmark market no NA NA 0.85 0.10 0.09 0.09 -0.16 0.02 0.32 0.47 0.25 0.54 0.51 0.34
GTM-1998 Guatemala GTM 1998 Quetzal 51417.23 51953.59 11.14 3.33 NA 1.62 48666.76 55740.56 50502.77 52091.17 79881.70 0.78 0.82 64293.27 58718.48 70643.41 172925.6 0.95 0.96 0.46 0.07 6.39 0.32 0.34 0.33 interpolated benchmark market no NA NA 0.85 0.14 0.09 0.10 -0.18 0.02 0.33 0.47 0.28 0.51 0.49 0.36
GTM-1999 Guatemala GTM 1999 Quetzal 53550.95 54882.24 11.41 3.45 NA 1.64 51127.00 58298.11 52587.78 54994.94 89126.99 0.75 0.77 66766.56 61015.44 72668.62 185427.2 0.93 0.93 0.46 0.07 7.39 0.29 0.31 0.30 interpolated benchmark market no NA 47.78 0.84 0.13 0.09 0.09 -0.17 0.02 0.29 0.44 0.28 0.49 0.49 0.29
GTM-2000 Guatemala GTM 2000 Quetzal 56102.14 57968.25 11.69 3.58 NA 1.65 53538.39 61430.30 55067.02 57636.36 96989.82 0.73 0.74 69175.77 63408.13 75548.16 192628.2 0.92 0.93 0.46 0.07 7.76 0.29 0.31 0.30 interpolated benchmark market no NA NA 0.83 0.14 0.09 0.10 -0.18 0.01 0.29 0.43 0.30 0.48 0.48 0.32
GTM-2001 Guatemala GTM 2001 Quetzal 58489.13 61418.70 11.98 3.72 NA 1.64 56344.38 65172.14 57608.37 61010.92 103967.48 0.74 0.75 70788.73 65909.31 78846.05 198709.3 0.92 0.94 0.46 0.06 7.86 0.31 0.32 0.31 interpolated benchmark market no NA NA 0.83 0.14 0.09 0.08 -0.19 0.04 0.31 0.42 0.33 0.47 0.48 0.39
GTM-2002 Guatemala GTM 2002 Quetzal 61456.70 63811.87 12.27 3.89 NA 1.64 58545.00 68691.82 60556.65 63553.07 112948.85 0.73 0.75 73525.86 67883.91 81973.27 205983.8 0.92 0.95 0.45 0.05 7.82 0.33 0.34 0.33 interpolated benchmark market no NA NA 0.83 0.16 0.09 0.07 -0.21 0.05 0.33 0.42 0.35 0.47 0.46 0.41
GTM-2003 Guatemala GTM 2003 Quetzal 63583.77 66275.41 12.57 4.03 NA 1.63 61206.75 71559.89 62545.62 66160.77 122840.91 0.72 0.74 75386.65 70127.82 84049.51 212495.2 0.92 0.95 0.45 0.05 7.94 0.34 0.35 0.33 interpolated benchmark market no NA NA 0.84 0.16 0.09 0.08 -0.20 0.04 0.33 0.43 0.36 0.52 0.50 0.41
GTM-2004 Guatemala GTM 2004 Quetzal 66131.61 69108.45 12.88 4.00 NA 1.62 63706.59 74806.21 64977.05 69019.59 136110.94 0.72 0.74 77762.90 72080.09 86489.88 218599.4 0.94 0.96 0.45 0.05 7.95 0.35 0.37 0.35 interpolated benchmark market no NA 81.11 0.84 0.16 0.08 0.08 -0.21 0.05 0.35 0.45 0.38 0.55 0.53 0.42
GTM-2005 Guatemala GTM 2005 Quetzal 68825.27 72399.19 13.18 4.24 NA 1.62 68320.18 79756.32 68791.45 72216.68 153376.92 0.71 0.72 80298.05 74990.95 89195.77 225095.9 0.94 0.95 0.45 0.05 7.63 0.38 0.40 0.38 interpolated benchmark market no NA 78.89 0.87 0.16 0.08 0.13 -0.27 0.03 0.38 0.47 0.40 0.55 0.54 0.42
GTM-2006 Guatemala GTM 2006 Quetzal 73486.25 76668.98 13.49 4.48 NA 1.65 72078.90 85189.21 72839.48 76602.49 173933.11 0.69 0.72 84617.91 78573.34 94445.38 234027.8 0.93 0.96 0.44 0.05 7.60 0.40 0.42 0.39 interpolated benchmark market no NA 80.00 0.86 0.17 0.08 0.07 -0.22 0.04 0.40 0.48 0.41 0.58 0.55 0.41
GTM-2007 Guatemala GTM 2007 Quetzal 79439.30 82025.16 13.80 4.48 NA 1.68 77205.08 91696.30 78528.68 82104.99 192681.02 0.71 0.74 89952.32 83017.79 100097.27 243391.2 0.97 0.99 0.43 0.05 7.67 0.42 0.43 0.42 interpolated benchmark market no NA 78.89 0.86 0.18 0.08 0.13 -0.28 0.03 0.42 0.49 0.43 0.64 0.60 0.40
GTM-2008 Guatemala GTM 2008 Quetzal 83265.55 85980.33 14.11 4.47 NA 1.71 82892.91 95164.66 82976.34 85649.05 209983.75 0.71 0.75 92903.74 87139.71 100861.81 251030.0 0.97 0.97 0.43 0.05 7.56 0.46 0.47 0.46 interpolated benchmark market no NA 82.22 0.88 0.14 0.09 0.13 -0.27 0.03 0.47 0.52 0.45 0.71 0.64 0.43
GTM-2009 Guatemala GTM 2009 Quetzal 87864.48 88414.58 14.42 4.47 NA 1.74 84656.93 95068.25 87094.73 88634.62 223994.41 0.71 0.74 93392.59 88072.64 99219.42 255899.8 0.97 0.95 0.43 0.05 8.16 0.43 0.43 0.43 interpolated benchmark market no NA 85.56 0.85 0.12 0.10 0.12 -0.22 0.02 0.43 0.47 0.43 0.67 0.60 0.39
GTM-2010 Guatemala GTM 2010 Quetzal 92085.59 93170.68 14.73 4.35 NA 1.76 89748.67 101272.45 91646.23 93270.40 241053.61 0.71 0.74 96072.38 91514.48 103506.62 260478.3 0.99 0.98 0.42 0.05 8.06 0.44 0.45 0.44 interpolated benchmark market no NA 85.56 0.86 0.12 0.10 0.13 -0.24 0.02 0.44 0.50 0.44 0.69 0.61 0.40
GTM-2011 Guatemala GTM 2011 Quetzal 98496.59 100070.86 15.05 4.46 NA 1.78 94919.23 109068.38 98496.59 100070.86 266095.22 0.71 0.74 100070.86 94919.24 109068.38 266095.2 1.00 1.00 0.42 0.05 7.79 0.48 0.48 0.48 benchmark benchmark market no 0.56 83.33 0.85 0.14 0.10 0.14 -0.26 0.03 0.48 0.51 0.48 0.71 0.64 0.40
GTM-2012 Guatemala GTM 2012 Quetzal 101200.23 102466.37 15.37 5.07 NA 1.80 98274.92 112493.70 101122.35 101964.92 272282.81 0.66 0.70 103042.98 98166.99 112555.04 272057.2 0.96 0.96 0.42 0.04 7.83 0.49 0.50 0.49 extrapolated benchmark market no NA 80.00 0.86 0.14 0.11 0.14 -0.27 0.02 0.49 0.53 0.49 0.69 0.62 0.42
GTM-2013 Guatemala GTM 2013 Quetzal 104637.66 105246.73 15.69 4.87 NA 1.82 102153.27 115864.62 104280.19 104663.09 281013.78 0.68 0.73 106852.91 101996.58 116153.33 277956.6 0.99 0.99 0.42 0.04 7.86 0.51 0.52 0.51 extrapolated benchmark market no NA 76.67 0.87 0.13 0.11 0.14 -0.27 0.03 0.51 0.55 0.50 0.70 0.62 0.42
GTM-2014 Guatemala GTM 2014 Quetzal 109715.60 110703.16 16.02 5.01 NA 1.85 106532.52 120539.55 109468.74 110100.03 292397.53 0.69 0.72 111393.91 106132.74 120699.96 284343.5 1.00 1.00 0.42 0.04 7.73 0.53 0.54 0.53 extrapolated benchmark market no NA 68.89 0.86 0.13 0.11 0.14 -0.26 0.02 0.53 0.57 0.53 0.71 0.64 0.42

2. Construya una funcion que le permita elegir todas las vaiables de la categoria “Labor detail”, muestre su uso para los datos de Argentina.

funcion_LaborDetail<-function(iso_pais){
  enquo(iso_pais)->iso_pais
  pwt9.0 %>% filter(isocode==!!iso_pais) %>%
    select(country,year,currency,pop,emp,avh,hc,ctfp,labsh) -> LaborDetail
  return(LaborDetail)
}

funcion_LaborDetail(iso_pais = "ARG") %>%
   kable(caption = "Datos de Labor Detail para Argentina de 1950-2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Labor Detail para Argentina de 1950-2014
country year currency pop emp avh hc ctfp labsh
ARG-1950 Argentina 1950 Argentine Peso 17.16 6.55 2034.00 1.82 0.69 0.53
ARG-1951 Argentina 1951 Argentine Peso 17.53 6.65 2037.87 1.83 0.67 0.53
ARG-1952 Argentina 1952 Argentine Peso 17.88 6.76 2041.74 1.85 0.58 0.53
ARG-1953 Argentina 1953 Argentine Peso 18.24 6.86 2045.62 1.86 0.58 0.53
ARG-1954 Argentina 1954 Argentine Peso 18.59 6.97 2049.51 1.87 0.61 0.53
ARG-1955 Argentina 1955 Argentine Peso 18.94 7.08 2053.41 1.89 0.62 0.53
ARG-1956 Argentina 1956 Argentine Peso 19.28 7.18 2057.31 1.90 0.62 0.53
ARG-1957 Argentina 1957 Argentine Peso 19.62 7.27 2061.22 1.91 0.63 0.53
ARG-1958 Argentina 1958 Argentine Peso 19.96 7.37 2065.14 1.93 0.66 0.53
ARG-1959 Argentina 1959 Argentine Peso 20.29 7.47 2069.07 1.94 0.60 0.53
ARG-1960 Argentina 1960 Argentine Peso 20.63 7.57 2073.00 1.95 0.62 0.53
ARG-1961 Argentina 1961 Argentine Peso 20.96 7.67 2066.20 1.96 0.62 0.53
ARG-1962 Argentina 1962 Argentine Peso 21.29 7.76 2059.42 1.98 0.61 0.53
ARG-1963 Argentina 1963 Argentine Peso 21.63 7.86 2052.67 1.99 0.58 0.53
ARG-1964 Argentina 1964 Argentine Peso 21.96 7.96 2045.94 2.00 0.59 0.53
ARG-1965 Argentina 1965 Argentine Peso 22.29 8.06 2039.22 2.01 0.64 0.53
ARG-1966 Argentina 1966 Argentine Peso 22.62 8.16 2032.54 2.02 0.63 0.53
ARG-1967 Argentina 1967 Argentine Peso 22.94 8.26 2025.87 2.04 0.63 0.53
ARG-1968 Argentina 1968 Argentine Peso 23.27 8.36 2019.22 2.05 0.63 0.53
ARG-1969 Argentina 1969 Argentine Peso 23.61 8.47 2012.60 2.06 0.66 0.53
ARG-1970 Argentina 1970 Argentine Peso 23.97 8.57 2006.00 2.08 0.66 0.53
ARG-1971 Argentina 1971 Argentine Peso 24.37 8.65 2002.66 2.10 0.65 0.53
ARG-1972 Argentina 1972 Argentine Peso 24.78 8.73 1999.33 2.12 0.62 0.53
ARG-1973 Argentina 1973 Argentine Peso 25.21 8.82 1996.00 2.14 0.63 0.53
ARG-1974 Argentina 1974 Argentine Peso 25.64 9.14 1992.84 2.16 0.65 0.53
ARG-1975 Argentina 1975 Argentine Peso 26.07 9.19 1989.69 2.18 0.63 0.53
ARG-1976 Argentina 1976 Argentine Peso 26.48 9.18 1986.54 2.20 0.61 0.53
ARG-1977 Argentina 1977 Argentine Peso 26.88 9.41 1983.40 2.21 0.62 0.53
ARG-1978 Argentina 1978 Argentine Peso 27.28 9.48 1980.26 2.22 0.59 0.53
ARG-1979 Argentina 1979 Argentine Peso 27.68 9.63 1977.13 2.24 0.61 0.53
ARG-1980 Argentina 1980 Argentine Peso 28.11 9.64 1974.00 2.25 0.61 0.53
ARG-1981 Argentina 1981 Argentine Peso 28.54 9.65 1961.23 2.28 0.59 0.53
ARG-1982 Argentina 1982 Argentine Peso 28.99 9.80 1948.54 2.32 0.60 0.53
ARG-1983 Argentina 1983 Argentine Peso 29.45 10.10 1935.94 2.35 0.61 0.53
ARG-1984 Argentina 1984 Argentine Peso 29.92 10.35 1923.41 2.39 0.61 0.53
ARG-1985 Argentina 1985 Argentine Peso 30.39 10.43 1910.97 2.42 0.56 0.53
ARG-1986 Argentina 1986 Argentine Peso 30.86 10.74 1898.61 2.44 0.58 0.53
ARG-1987 Argentina 1987 Argentine Peso 31.33 10.96 1886.33 2.46 0.58 0.53
ARG-1988 Argentina 1988 Argentine Peso 31.80 11.18 1874.12 2.49 0.58 0.53
ARG-1989 Argentina 1989 Argentine Peso 32.26 11.28 1862.00 2.51 0.53 0.53
ARG-1990 Argentina 1990 Argentine Peso 32.73 11.59 1850.00 2.53 0.57 0.53
ARG-1991 Argentina 1991 Argentine Peso 33.19 11.95 1837.96 2.55 0.62 0.53
ARG-1992 Argentina 1992 Argentine Peso 33.66 12.15 1826.00 2.57 0.66 0.53
ARG-1993 Argentina 1993 Argentine Peso 34.11 12.07 1850.34 2.59 0.70 0.53
ARG-1994 Argentina 1994 Argentine Peso 34.56 12.08 1875.00 2.60 0.74 0.52
ARG-1995 Argentina 1995 Argentine Peso 34.99 11.51 1897.22 2.62 0.77 0.47
ARG-1996 Argentina 1996 Argentine Peso 35.42 11.79 1846.07 2.63 0.86 0.44
ARG-1997 Argentina 1997 Argentine Peso 35.83 12.36 1917.29 2.63 0.84 0.42
ARG-1998 Argentina 1998 Argentine Peso 36.24 12.90 1903.00 2.64 0.81 0.43
ARG-1999 Argentina 1999 Argentine Peso 36.65 12.96 1893.25 2.65 0.75 0.46
ARG-2000 Argentina 2000 Argentine Peso 37.06 13.09 1861.00 2.66 0.74 0.46
ARG-2001 Argentina 2001 Argentine Peso 37.47 13.05 1803.42 2.68 0.71 0.47
ARG-2002 Argentina 2002 Argentine Peso 37.89 13.01 1610.57 2.71 0.68 0.37
ARG-2003 Argentina 2003 Argentine Peso 38.31 13.73 1719.39 2.74 0.68 0.36
ARG-2004 Argentina 2004 Argentine Peso 38.73 14.67 1739.67 2.76 0.70 0.38
ARG-2005 Argentina 2005 Argentine Peso 39.15 15.34 1755.35 2.79 0.73 0.40
ARG-2006 Argentina 2006 Argentine Peso 39.56 15.86 1809.43 2.80 0.74 0.43
ARG-2007 Argentina 2007 Argentine Peso 39.97 16.44 1816.90 2.81 0.76 0.43
ARG-2008 Argentina 2008 Argentine Peso 40.38 16.84 1835.88 2.81 0.78 0.43
ARG-2009 Argentina 2009 Argentine Peso 40.80 16.99 1736.91 2.82 0.79 0.43
ARG-2010 Argentina 2010 Argentine Peso 41.22 17.49 1728.73 2.83 0.83 0.43
ARG-2011 Argentina 2011 Argentine Peso 41.66 17.88 1762.29 2.86 0.87 0.43
ARG-2012 Argentina 2012 Argentine Peso 42.10 18.07 1788.99 2.89 0.85 0.43
ARG-2013 Argentina 2013 Argentine Peso 42.54 18.26 1776.66 2.92 0.84 0.43
ARG-2014 Argentina 2014 Argentine Peso 42.98 18.10 1776.66 2.95 0.82 0.43
3. Use las funciones creadas en 1 y 2, para generar 2 DataFrames, que muestren los datos de “EE.UU” y “Canada”, para el periodo de 2000-2014.
funcion_elegir_pais2(iso_pais = "USA",2000,2014) %>%
  kable(caption = "Datos de Estados Unidos de 2000 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE)
Datos de Estados Unidos de 2000 a 2014
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
USA-2000 United States of America USA 2000 US Dollar 13222419 13031820 282.90 139.30 1848.15 3.58 9977582 13511612 13035321 12983206 35997032 1 1 12975535 10500206 13647352 38439588 0.92 0.93 0.64 0.05 1 0.83 0.79 0.79 interpolated benchmark market no NA NA 0.68 0.27 0.09 0.11 -0.16 0.01 0.77 0.69 1.20 0.57 0.62 0.79
USA-2001 United States of America USA 2001 US Dollar 13355489 13127311 285.80 139.44 1823.75 3.59 10266814 13688775 13229581 13108072 37382932 1 1 13102174 10788220 13802928 39627500 0.93 0.94 0.65 0.05 1 0.84 0.80 0.81 interpolated benchmark market no NA NA 0.69 0.26 0.10 0.10 -0.15 0.01 0.79 0.68 1.22 0.55 0.59 0.81
USA-2002 United States of America USA 2002 US Dollar 13591523 13309916 288.47 139.08 1805.48 3.60 10524779 14027745 13503168 13339370 38467564 1 1 13336194 11088529 14123900 40679832 0.94 0.95 0.63 0.05 1 0.86 0.81 0.82 benchmark benchmark market no NA NA 0.69 0.26 0.10 0.09 -0.15 0.01 0.80 0.68 1.24 0.56 0.59 0.82
USA-2003 United States of America USA 2003 US Dollar 13961596 13679334 291.01 140.23 1782.33 3.61 10852183 14451386 13845560 13712711 39839628 1 1 13710512 11406928 14561711 41793132 0.96 0.97 0.63 0.05 1 0.88 0.83 0.84 interpolated benchmark market no NA NA 0.69 0.26 0.10 0.09 -0.15 0.01 0.82 0.69 1.24 0.60 0.64 0.84
USA-2004 United States of America USA 2004 US Dollar 14499944 14204685 293.53 141.63 1783.41 3.62 11251801 15090846 14366189 14232334 42071616 1 1 14229557 11796878 15181932 43024076 0.97 1.00 0.62 0.05 1 0.90 0.85 0.86 interpolated benchmark market no NA NA 0.69 0.27 0.10 0.09 -0.16 0.01 0.84 0.72 1.27 0.63 0.68 0.86
USA-2005 United States of America USA 2005 US Dollar 14958727 14683344 296.14 143.99 1779.60 3.63 11844568 15867237 15038908 14709193 45051164 1 1 14705564 12152636 15714073 44360180 0.98 1.01 0.61 0.05 1 0.91 0.87 0.89 benchmark benchmark market no 1 NA 0.70 0.27 0.11 0.10 -0.18 0.01 0.86 0.76 1.26 0.63 0.64 0.89
USA-2006 United States of America USA 2006 US Dollar 15353601 15083465 298.86 146.62 1778.53 3.64 12126527 16170304 15318001 15099868 47891040 1 1 15097712 12476968 16121374 45671956 0.99 1.01 0.61 0.05 1 0.94 0.90 0.92 interpolated benchmark market no NA NA 0.69 0.27 0.11 0.10 -0.18 0.01 0.89 0.80 1.28 0.65 0.69 0.92
USA-2007 United States of America USA 2007 US Dollar 15605977 15359941 301.66 148.20 1771.92 3.66 12419006 16287814 15517646 15368273 49404728 1 1 15366229 12736787 16304233 46844304 0.99 1.01 0.61 0.05 1 0.96 0.93 0.94 interpolated benchmark market no NA NA 0.70 0.25 0.11 0.11 -0.18 0.01 0.91 0.84 1.30 0.71 0.75 0.94
USA-2008 United States of America USA 2008 US Dollar 15357469 15305872 304.47 147.53 1761.32 3.67 12569281 16125585 15370500 15321926 50006724 1 1 15321422 12759836 16086510 47779436 0.98 0.99 0.62 0.05 1 0.99 0.96 0.96 interpolated benchmark market no NA NA 0.70 0.23 0.12 0.11 -0.18 0.01 0.93 0.86 1.31 0.75 0.81 0.96
USA-2009 United States of America USA 2009 US Dollar 15005201 14844276 307.23 142.11 1728.61 3.69 12451251 15338228 14928810 14896201 49243108 1 1 14896173 12685674 15474241 48245684 0.98 0.98 0.60 0.05 1 0.99 0.97 0.97 interpolated benchmark market no NA NA 0.71 0.19 0.13 0.10 -0.14 0.01 0.93 0.87 1.28 0.71 0.76 0.97
USA-2010 United States of America USA 2010 US Dollar 15368666 15250698 309.88 141.35 1738.00 3.70 12764841 15842214 15317448 15273702 48876336 1 1 15273331 12883714 15924426 48728140 1.00 1.00 0.60 0.05 1 1.00 0.98 0.98 interpolated benchmark market no NA NA 0.71 0.20 0.13 0.11 -0.16 0.01 0.95 0.89 1.28 0.73 0.78 0.98
USA-2011 United States of America USA 2011 US Dollar 15590957 15517930 312.39 142.22 1755.29 3.71 13049097 16173676 15590957 15517930 49279028 1 1 15517931 13049097 16173675 49279028 1.00 1.00 0.60 0.05 1 1.01 1.00 1.00 benchmark benchmark market no 1 NA 0.72 0.20 0.13 0.12 -0.18 0.01 0.96 0.92 1.30 0.76 0.81 1.00
USA-2012 United States of America USA 2012 US Dollar 15976742 15899255 314.80 144.86 1753.70 3.71 13206454 16505245 15946878 15863845 50020716 1 1 15863049 13182059 16509182 49960600 1.01 1.00 0.60 0.05 1 1.03 1.01 1.02 extrapolated benchmark market no NA NA 0.71 0.21 0.12 0.13 -0.18 0.01 0.98 0.95 1.32 0.76 0.81 1.02
USA-2013 United States of America USA 2013 US Dollar 16274530 16183547 317.14 146.21 1758.69 3.72 13356571 16668950 16175432 16100139 51340076 1 1 16099333 13302849 16715053 50633784 1.01 1.00 0.60 0.05 1 1.04 1.03 1.03 extrapolated benchmark market no NA NA 0.71 0.21 0.12 0.13 -0.17 0.01 0.99 0.98 1.34 0.77 0.81 1.04
USA-2014 United States of America USA 2014 US Dollar 16704698 16598099 319.45 148.46 1764.60 3.72 13685949 17113208 16605887 16490883 52849892 1 1 16490192 13585164 17137356 51190644 1.01 1.01 0.60 0.05 1 1.05 1.04 1.05 extrapolated benchmark market no NA NA 0.72 0.21 0.11 0.13 -0.18 0.01 1.00 1.01 1.37 0.77 0.80 1.05
funcion_elegir_pais2(iso_pais = "CAN",2000,2014) %>%
  kable(caption = "Datos de Canada de 2000 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Canada de 2000 a 2014
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
CAN-2000 Canada CAN 2000 Canadian Dollar 1167052 1127565 30.70 14.87 1779.13 3.50 795599.8 1074248 1139711 1150584 3311462 0.91 0.82 1170880 762779.9 1027360 3784067 1.04 0.92 0.61 0.04 1.49 0.68 0.65 0.64 interpolated benchmark market no NA NA 0.54 0.24 0.15 0.43 -0.37 0.01 0.64 0.55 0.83 0.56 0.56 0.62
CAN-2001 Canada CAN 2001 Canadian Dollar 1166188 1119308 30.99 15.06 1767.99 3.52 814203.9 1079932 1145022 1144414 3268334 0.90 0.82 1190649 782785.5 1041029 3905941 1.03 0.91 0.62 0.04 1.55 0.67 0.64 0.64 interpolated benchmark market no NA NA 0.56 0.23 0.15 0.42 -0.36 0.00 0.63 0.55 0.82 0.55 0.53 0.63
CAN-2002 Canada CAN 2002 Canadian Dollar 1173454 1127791 31.29 15.45 1749.47 3.53 836753.2 1105706 1156510 1159323 3207820 0.90 0.81 1224009 808856.4 1073323 4024192 1.04 0.92 0.62 0.04 1.57 0.68 0.65 0.65 benchmark benchmark market no NA NA 0.57 0.23 0.15 0.41 -0.37 0.00 0.64 0.56 0.84 0.53 0.52 0.67
CAN-2003 Canada CAN 2003 Canadian Dollar 1211094 1184269 31.60 15.85 1732.14 3.55 858441.9 1148489 1194611 1200543 3349291 0.89 0.81 1247575 832796.8 1119539 4151862 1.03 0.94 0.61 0.04 1.40 0.78 0.74 0.74 interpolated benchmark market no NA NA 0.56 0.24 0.15 0.39 -0.35 0.00 0.73 0.63 0.96 0.58 0.57 0.76
CAN-2004 Canada CAN 2004 Canadian Dollar 1260986 1235663 31.92 16.16 1751.06 3.56 877820.4 1189845 1244977 1252623 3571504 0.88 0.79 1286734 855641.8 1164602 4297140 1.03 0.94 0.61 0.04 1.30 0.86 0.82 0.81 interpolated benchmark market no NA NA 0.55 0.25 0.15 0.41 -0.36 0.00 0.81 0.70 1.05 0.62 0.61 0.83
CAN-2005 Canada CAN 2005 Canadian Dollar 1311424 1323181 32.26 16.44 1739.18 3.58 918976.9 1263380 1315081 1326233 3865556 0.90 0.80 1327435 882079.1 1221829 4462552 1.04 0.96 0.60 0.04 1.21 0.93 0.89 0.88 benchmark benchmark market no 0.90 NA 0.54 0.26 0.15 0.43 -0.39 0.00 0.87 0.77 1.13 0.63 0.62 0.89
CAN-2006 Canada CAN 2006 Canadian Dollar 1343928 1342066 32.61 16.79 1733.23 3.59 940558.9 1304562 1340375 1357210 4208085 0.89 0.80 1362237 915601.1 1273821 4637972 1.03 0.98 0.61 0.04 1.13 1.03 0.98 0.97 interpolated benchmark market no NA NA 0.54 0.27 0.15 0.45 -0.41 0.00 0.97 0.86 1.23 0.64 0.63 0.96
CAN-2007 Canada CAN 2007 Canadian Dollar 1376870 1384391 32.98 17.27 1724.69 3.61 969776.7 1342214 1370408 1395106 4445640 0.88 0.80 1389595 950916.3 1319552 4812567 1.02 0.98 0.61 0.04 1.07 1.11 1.06 1.04 interpolated benchmark market no NA NA 0.54 0.27 0.16 0.44 -0.40 -0.01 1.05 0.94 1.31 0.68 0.68 1.05
CAN-2008 Canada CAN 2008 Canadian Dollar 1404807 1456291 33.36 17.66 1713.39 3.62 1002613.3 1383169 1407829 1452164 4607176 0.90 0.81 1405929 982824.2 1358207 4983390 1.01 0.98 0.60 0.04 1.07 1.14 1.10 1.06 interpolated benchmark market no NA NA 0.53 0.26 0.16 0.44 -0.38 -0.01 1.09 0.97 1.33 0.71 0.74 1.11
CAN-2009 Canada CAN 2009 Canadian Dollar 1310934 1304883 33.75 17.44 1678.52 3.64 1000717.9 1325223 1306457 1323073 4794360 0.81 0.79 1367808 994270.1 1323141 5106391 0.99 0.97 0.63 0.04 1.14 1.09 1.05 1.04 interpolated benchmark market no NA NA 0.57 0.25 0.18 0.35 -0.34 -0.01 1.04 0.92 1.27 0.69 0.72 1.02
CAN-2010 Canada CAN 2010 Canadian Dollar 1371811 1387124 34.13 17.74 1685.54 3.66 1030334.4 1393576 1368504 1389695 5065393 0.80 0.78 1413961 1025854.7 1393300 5261183 0.99 0.99 0.61 0.04 1.03 1.23 1.18 1.16 interpolated benchmark market no NA NA 0.56 0.26 0.18 0.40 -0.39 -0.01 1.17 1.04 1.40 0.69 0.72 1.13
CAN-2011 Canada CAN 2011 Canadian Dollar 1423920 1455816 34.50 18.08 1683.57 3.66 1045868.8 1440603 1423920 1455816 5427466 0.81 0.77 1455816 1045868.8 1440603 5427466 1.00 1.00 0.61 0.04 0.99 1.32 1.26 1.23 benchmark benchmark market no 0.82 NA 0.54 0.27 0.18 0.44 -0.42 -0.01 1.26 1.09 1.49 0.71 0.74 1.16
CAN-2012 Canada CAN 2012 Canadian Dollar 1447882 1470333 34.87 18.34 1692.85 3.67 1064437.2 1469014 1443117 1454780 5597287 0.78 0.76 1483809 1063769.8 1472486 5605514 0.99 1.00 0.62 0.04 1.00 1.32 1.27 1.26 extrapolated benchmark market no NA NA 0.55 0.28 0.18 0.43 -0.43 -0.01 1.26 1.13 1.52 0.73 0.75 1.18
CAN-2013 Canada CAN 2013 Canadian Dollar 1478439 1493624 35.23 18.67 1682.74 3.68 1086339.8 1488701 1465085 1472069 5828469 0.78 0.76 1513537 1084256.5 1500049 5779532 0.99 0.99 0.62 0.04 1.03 1.31 1.26 1.25 extrapolated benchmark market no NA NA 0.56 0.27 0.18 0.42 -0.42 -0.01 1.24 1.12 1.51 0.74 0.75 1.15
CAN-2014 Canada CAN 2014 Canadian Dollar 1507209 1543374 35.59 18.83 1687.78 3.68 1109991.0 1505819 1492422 1522929 6097225 0.78 0.74 1550457 1104841.9 1518445 5949967 1.00 0.99 0.62 0.04 1.11 1.24 1.20 1.17 extrapolated benchmark market no NA NA 0.56 0.26 0.17 0.42 -0.40 -0.02 1.17 1.08 1.44 0.73 0.76 1.08
funcion_LaborDetail(iso_pais = "USA") %>%
  filter(year %in% 2000:2014) %>%
   kable(caption = "Datos de Labor Detail para Estados Unidos de 2000-2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Labor Detail para Estados Unidos de 2000-2014
country year currency pop emp avh hc ctfp labsh
USA-2000 United States of America 2000 US Dollar 282.90 139.30 1848.15 3.58 1 0.64
USA-2001 United States of America 2001 US Dollar 285.80 139.44 1823.75 3.59 1 0.65
USA-2002 United States of America 2002 US Dollar 288.47 139.08 1805.48 3.60 1 0.63
USA-2003 United States of America 2003 US Dollar 291.01 140.23 1782.33 3.61 1 0.63
USA-2004 United States of America 2004 US Dollar 293.53 141.63 1783.41 3.62 1 0.62
USA-2005 United States of America 2005 US Dollar 296.14 143.99 1779.60 3.63 1 0.61
USA-2006 United States of America 2006 US Dollar 298.86 146.62 1778.53 3.64 1 0.61
USA-2007 United States of America 2007 US Dollar 301.66 148.20 1771.92 3.66 1 0.61
USA-2008 United States of America 2008 US Dollar 304.47 147.53 1761.32 3.67 1 0.62
USA-2009 United States of America 2009 US Dollar 307.23 142.11 1728.61 3.69 1 0.60
USA-2010 United States of America 2010 US Dollar 309.88 141.35 1738.00 3.70 1 0.60
USA-2011 United States of America 2011 US Dollar 312.39 142.22 1755.29 3.71 1 0.60
USA-2012 United States of America 2012 US Dollar 314.80 144.86 1753.70 3.71 1 0.60
USA-2013 United States of America 2013 US Dollar 317.14 146.21 1758.69 3.72 1 0.60
USA-2014 United States of America 2014 US Dollar 319.45 148.46 1764.60 3.72 1 0.60
funcion_LaborDetail(iso_pais = "CAN") %>%
  filter(year %in% 2000:2014) %>%
   kable(caption = "Datos de Labor Detail para Canada de 2000-2014", digits = 2,align = "l") %>% kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Labor Detail para Canada de 2000-2014
country year currency pop emp avh hc ctfp labsh
CAN-2000 Canada 2000 Canadian Dollar 30.70 14.87 1779.13 3.50 0.91 0.61
CAN-2001 Canada 2001 Canadian Dollar 30.99 15.06 1767.99 3.52 0.90 0.62
CAN-2002 Canada 2002 Canadian Dollar 31.29 15.45 1749.47 3.53 0.90 0.62
CAN-2003 Canada 2003 Canadian Dollar 31.60 15.85 1732.14 3.55 0.89 0.61
CAN-2004 Canada 2004 Canadian Dollar 31.92 16.16 1751.06 3.56 0.88 0.61
CAN-2005 Canada 2005 Canadian Dollar 32.26 16.44 1739.18 3.58 0.90 0.60
CAN-2006 Canada 2006 Canadian Dollar 32.61 16.79 1733.23 3.59 0.89 0.61
CAN-2007 Canada 2007 Canadian Dollar 32.98 17.27 1724.69 3.61 0.88 0.61
CAN-2008 Canada 2008 Canadian Dollar 33.36 17.66 1713.39 3.62 0.90 0.60
CAN-2009 Canada 2009 Canadian Dollar 33.75 17.44 1678.52 3.64 0.81 0.63
CAN-2010 Canada 2010 Canadian Dollar 34.13 17.74 1685.54 3.66 0.80 0.61
CAN-2011 Canada 2011 Canadian Dollar 34.50 18.08 1683.57 3.66 0.81 0.61
CAN-2012 Canada 2012 Canadian Dollar 34.87 18.34 1692.85 3.67 0.78 0.62
CAN-2013 Canada 2013 Canadian Dollar 35.23 18.67 1682.74 3.68 0.78 0.62
CAN-2014 Canada 2014 Canadian Dollar 35.59 18.83 1687.78 3.68 0.78 0.62

Clave 3.

Usando los datos de la Penn World Table, de la Universidad de Groningen.

Resuelva los siguientes requerimientos (es importante mostrar todos sus resultados en formato tabular):

1. Construya una funcion que le permita eleger el pais y filtrar para un periodo (inicio, final). Muestre su uso filtrando los datos para Honduras, en el periodo de 1990-2014.

data("pwt9.0")
options(scipen = 999999)
#crear la funcion.
funcion_elegir_pais3 <- function(iso_pais,anio_ini,anio_fin){
  enquo(iso_pais)->iso_pais
  pwt9.0 %>% filter(isocode==!!iso_pais,
                    year>=anio_ini,
                    year<=anio_fin)-> elegir_pais3
  return(elegir_pais3)
}
#Probando la funcion.
funcion_elegir_pais3(iso_pais = "HND",1990,2014) %>%
  kable(caption = "Datos de Honduras de 1990 a 2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Honduras de 1990 a 2014
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
HND-1990 Honduras HND 1990 Lempira 13869.68 14479.95 4.90 1.21 NA 1.77 12349.56 14292.89 14019.55 14777.81 24019.17 0.63 0.60 15670.49 14036.91 16844.10 46727.57 1.25 1.15 0.58 0.05 4.11 0.24 0.26 0.25 interpolated benchmark market no NA NA 0.73 0.13 0.11 0.07 -0.13 0.09 0.23 0.40 0.32 0.51 0.50 0.39
HND-1991 Honduras HND 1991 Lempira 14668.76 15217.25 5.04 1.53 NA 1.78 12721.95 15095.52 14801.82 15593.70 24835.76 0.57 0.55 16180.10 14378.00 17783.92 48069.19 1.11 1.05 0.58 0.05 5.32 0.23 0.25 0.23 interpolated benchmark market no NA NA 0.73 0.15 0.09 0.07 -0.12 0.07 0.22 0.35 0.31 0.54 0.53 0.37
HND-1992 Honduras HND 1992 Lempira 15327.71 15702.40 5.18 1.67 NA 1.79 13162.22 15913.10 15452.53 15956.85 26166.61 0.52 0.51 17090.11 14913.27 18787.75 50292.81 1.10 1.03 0.58 0.05 5.50 0.25 0.26 0.26 interpolated benchmark market no NA NA 0.73 0.17 0.10 0.09 -0.14 0.05 0.23 0.35 0.32 0.50 0.48 0.38
HND-1993 Honduras HND 1993 Lempira 15933.56 17007.75 5.32 1.72 NA 1.80 13556.20 17219.01 16058.67 17298.61 28825.96 0.53 0.52 18154.83 15235.90 20400.85 53997.58 1.10 1.06 0.58 0.05 6.47 0.24 0.26 0.24 interpolated benchmark market no NA NA 0.70 0.21 0.08 0.08 -0.15 0.08 0.22 0.35 0.34 0.50 0.49 0.36
HND-1994 Honduras HND 1994 Lempira 16221.66 17431.77 5.46 1.78 NA 1.81 13626.76 17519.94 16247.20 17766.09 31565.97 0.51 0.50 17918.23 15181.68 20793.20 57415.96 1.03 1.03 0.58 0.05 8.41 0.22 0.25 0.23 interpolated benchmark market no NA NA 0.69 0.22 0.07 0.07 -0.15 0.10 0.21 0.36 0.33 0.51 0.49 0.33
HND-1995 Honduras HND 1995 Lempira 17476.45 19391.93 5.59 1.82 NA 1.82 13971.42 17967.27 17503.07 19796.22 33959.80 0.54 0.49 18649.27 15343.45 21133.80 59646.99 1.03 1.00 0.58 0.05 9.47 0.25 0.27 0.24 interpolated benchmark market no NA NA 0.64 0.20 0.06 0.06 -0.17 0.20 0.24 0.34 0.38 0.53 0.51 0.37
HND-1996 Honduras HND 1996 Lempira 17991.68 18534.55 5.72 1.97 NA 1.84 14862.28 18612.00 17993.62 18919.16 36097.18 0.47 0.46 19316.62 16146.38 21565.41 62041.05 1.00 0.96 0.58 0.06 11.71 0.24 0.27 0.26 interpolated benchmark market no NA NA 0.72 0.20 0.07 0.13 -0.18 0.07 0.23 0.37 0.40 0.56 0.53 0.35
HND-1997 Honduras HND 1997 Lempira 18783.43 19283.00 5.86 2.07 NA 1.85 15261.00 19375.77 18662.25 19602.26 38919.98 0.45 0.44 20281.24 16564.65 22439.02 65095.36 0.99 0.94 0.58 0.06 13.00 0.27 0.30 0.29 interpolated benchmark market no NA NA 0.71 0.21 0.06 0.14 -0.21 0.09 0.26 0.40 0.42 0.53 0.51 0.36
HND-1998 Honduras HND 1998 Lempira 19437.26 19877.25 5.99 2.13 NA 1.86 16084.09 20327.30 19169.84 20236.38 42338.37 0.43 0.42 20869.71 17542.46 23514.27 68522.87 0.98 0.94 0.58 0.06 13.39 0.30 0.33 0.31 interpolated benchmark market no NA NA 0.72 0.21 0.07 0.15 -0.26 0.10 0.29 0.42 0.46 0.49 0.48 0.39
HND-1999 Honduras HND 1999 Lempira 18722.69 19555.42 6.11 2.28 NA 1.87 16175.77 20880.68 18457.55 19883.22 46072.06 0.38 0.39 20475.37 17648.50 24128.66 72088.17 0.90 0.91 0.58 0.06 14.21 0.32 0.35 0.33 interpolated benchmark market no NA 60.56 0.73 0.24 0.08 0.12 -0.27 0.10 0.31 0.44 0.48 0.48 0.49 0.39
HND-2000 Honduras HND 2000 Lempira 20014.32 21004.32 6.24 2.28 NA 1.88 17440.45 22230.78 19769.88 21097.95 49552.57 0.39 0.39 21652.33 19076.11 25351.34 74802.02 0.93 0.93 0.58 0.06 14.84 0.35 0.36 0.34 interpolated benchmark market no NA NA 0.74 0.23 0.09 0.11 -0.24 0.07 0.33 0.42 0.50 0.46 0.50 0.39
HND-2001 Honduras HND 2001 Lempira 20637.62 21337.64 6.37 2.28 NA 1.90 18379.90 23177.14 20478.18 21473.39 52978.77 0.38 0.39 22241.96 19999.78 26027.96 77193.24 0.94 0.95 0.59 0.06 15.47 0.36 0.37 0.36 interpolated benchmark market no NA NA 0.76 0.22 0.10 0.14 -0.27 0.05 0.34 0.41 0.55 0.44 0.47 0.39
HND-2002 Honduras HND 2002 Lempira 21429.86 22322.82 6.50 2.31 NA 1.92 19132.07 23977.57 21306.53 22633.90 56023.19 0.38 0.39 23077.00 20740.80 26554.17 79013.09 0.96 0.95 0.60 0.06 16.43 0.36 0.37 0.35 interpolated benchmark market no NA NA 0.75 0.21 0.09 0.09 -0.27 0.12 0.34 0.39 0.56 0.45 0.47 0.37
HND-2003 Honduras HND 2003 Lempira 22293.72 23442.71 6.63 2.36 NA 1.94 20103.34 25232.91 22122.40 23866.67 59671.42 0.38 0.39 24126.32 21692.98 27731.18 81101.34 0.99 0.97 0.61 0.06 17.35 0.36 0.37 0.34 interpolated benchmark market no NA NA 0.75 0.21 0.09 0.09 -0.26 0.12 0.34 0.41 0.54 0.49 0.50 0.38
HND-2004 Honduras HND 2004 Lempira 23503.39 24886.89 6.75 2.38 NA 1.95 21223.06 27632.29 23295.61 25364.89 65749.49 0.39 0.40 25629.95 22787.18 30171.69 84672.58 1.02 1.03 0.60 0.06 18.21 0.37 0.38 0.35 interpolated benchmark market no NA 63.89 0.74 0.25 0.10 0.09 -0.27 0.09 0.35 0.41 0.55 0.52 0.53 0.37
HND-2005 Honduras HND 2005 Lempira 24863.05 27339.29 6.88 2.45 NA 1.97 23171.71 29687.92 25057.70 27758.67 72955.40 0.41 0.41 27180.79 24338.38 31628.39 87856.12 1.04 1.04 0.59 0.06 18.83 0.38 0.39 0.35 interpolated benchmark market no NA 63.33 0.73 0.23 0.10 0.09 -0.29 0.14 0.36 0.41 0.54 0.53 0.54 0.35
HND-2006 Honduras HND 2006 Lempira 26591.88 28317.32 7.01 2.64 NA 1.99 25053.55 32155.18 26569.55 28826.40 81215.07 0.39 0.41 28965.75 26253.87 34069.19 91934.22 1.04 1.05 0.58 0.06 18.90 0.40 0.41 0.38 interpolated benchmark market no NA 63.33 0.77 0.25 0.10 0.12 -0.30 0.07 0.38 0.44 0.56 0.55 0.57 0.36
HND-2007 Honduras HND 2007 Lempira 28196.94 30212.58 7.13 2.75 NA 2.01 26953.74 35926.29 28055.89 30818.34 89601.12 0.39 0.43 30758.23 28137.40 37910.04 98000.57 1.04 1.10 0.59 0.06 18.90 0.43 0.44 0.40 interpolated benchmark market no NA 70.00 0.77 0.29 0.11 0.13 -0.35 0.05 0.41 0.46 0.61 0.61 0.61 0.37
HND-2008 Honduras HND 2008 Lempira 28689.72 29158.39 7.26 2.78 NA 2.03 28240.20 38256.50 28743.01 29235.60 97798.84 0.36 0.44 32059.88 29045.71 39696.93 104314.83 1.05 1.12 0.59 0.06 18.90 0.48 0.48 0.47 interpolated benchmark market no NA 73.33 0.84 0.34 0.12 0.32 -0.48 -0.14 0.45 0.50 0.66 0.71 0.65 0.40
HND-2009 Honduras HND 2009 Lempira 29242.94 29286.39 7.38 2.89 NA 2.05 28587.59 34253.79 29066.95 29677.80 100695.90 0.35 0.39 31280.22 29424.54 35252.21 105943.45 1.00 0.97 0.60 0.06 18.90 0.50 0.50 0.49 interpolated benchmark market no NA 77.78 0.83 0.19 0.13 0.12 -0.33 0.05 0.46 0.53 0.71 0.70 0.61 0.42
HND-2010 Honduras HND 2010 Lempira 30846.39 31120.90 7.50 2.94 NA 2.07 29819.84 36243.63 30734.73 31326.93 104274.56 0.35 0.39 32447.37 30233.08 36788.32 107767.67 1.01 0.99 0.61 0.06 18.90 0.51 0.52 0.51 interpolated benchmark market no NA 77.78 0.83 0.21 0.12 0.15 -0.36 0.06 0.48 0.54 0.73 0.68 0.61 0.43
HND-2011 Honduras HND 2011 Lempira 32806.54 33691.91 7.62 3.05 NA 2.10 31070.36 39269.93 32806.54 33691.91 110959.42 0.35 0.39 33691.91 31070.36 39269.93 110959.42 1.00 1.00 0.61 0.06 18.92 0.53 0.54 0.53 benchmark benchmark market no 0.61 77.78 0.81 0.24 0.11 0.14 -0.40 0.09 0.51 0.56 0.74 0.72 0.64 0.45
HND-2012 Honduras HND 2012 Lempira 33772.98 34601.96 7.74 3.17 NA 2.14 32356.33 40233.31 33701.14 34306.44 114260.53 0.33 0.38 35082.96 32295.14 40251.67 114391.16 1.00 0.98 0.62 0.06 19.50 0.54 0.55 0.54 extrapolated benchmark market no NA 76.00 0.83 0.23 0.11 0.19 -0.38 0.02 0.51 0.58 0.76 0.72 0.66 0.45
HND-2013 Honduras HND 2013 Lempira 33759.91 33670.28 7.85 3.28 NA 2.18 33565.68 40386.88 33537.50 33307.57 118671.20 0.31 0.36 36062.30 33478.72 40477.25 117494.66 0.98 0.94 0.62 0.06 20.34 0.54 0.55 0.56 extrapolated benchmark market no NA 62.22 0.89 0.20 0.12 0.32 -0.44 -0.09 0.51 0.59 0.76 0.70 0.65 0.44
HND-2014 Honduras HND 2014 Lempira 35219.24 34835.65 7.96 3.38 NA 2.22 34384.08 41614.70 35008.41 34377.60 123703.28 0.30 0.35 37174.90 34161.48 41649.40 120378.56 0.97 0.93 0.62 0.06 21.01 0.55 0.56 0.57 extrapolated benchmark market no NA 73.33 0.88 0.21 0.12 0.34 -0.47 -0.08 0.52 0.59 0.76 0.70 0.63 0.44

2. Construya una funcion que le permita elegir todas las vaiables de la categoria “Capital detail”, muestre su uso para los datos de Panama.

funcion_CapitalDetail<-function(iso_pais){
  enquo(iso_pais)->iso_pais
  pwt9.0 %>% filter(isocode==!!iso_pais) %>%
    select(country,year,currency,ck,rkna,pl_i,pl_k) -> CapitalDetail
  return(CapitalDetail)
}

funcion_CapitalDetail(iso_pais = "PAN") %>% 
  kable(caption = "Datos de Capital Detail para Panama de 1950-2014", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Capital Detail para Panama de 1950-2014
country year currency ck rkna pl_i pl_k
PAN-1950 Panama 1950 Balboa 3974.41 7910.69 0.14 0.19
PAN-1951 Panama 1951 Balboa 4069.08 7852.89 0.15 0.20
PAN-1952 Panama 1952 Balboa 4146.32 7818.99 0.14 0.20
PAN-1953 Panama 1953 Balboa 4193.96 7919.25 0.14 0.20
PAN-1954 Panama 1954 Balboa 4124.01 7955.62 0.14 0.19
PAN-1955 Panama 1955 Balboa 4161.54 8047.85 0.14 0.19
PAN-1956 Panama 1956 Balboa 4363.73 8225.04 0.14 0.19
PAN-1957 Panama 1957 Balboa 4487.40 8408.98 0.14 0.19
PAN-1958 Panama 1958 Balboa 4531.01 8648.26 0.14 0.20
PAN-1959 Panama 1959 Balboa 4688.31 8946.78 0.14 0.20
PAN-1960 Panama 1960 Balboa 4690.70 9182.75 0.15 0.21
PAN-1961 Panama 1961 Balboa 4875.82 9531.83 0.16 0.22
PAN-1962 Panama 1962 Balboa 5083.90 9964.52 0.17 0.22
PAN-1963 Panama 1963 Balboa 5296.14 10468.62 0.16 0.22
PAN-1964 Panama 1964 Balboa 5434.30 10876.88 0.16 0.22
PAN-1965 Panama 1965 Balboa 5712.34 11372.26 0.17 0.22
PAN-1966 Panama 1966 Balboa 6161.97 12153.60 0.17 0.22
PAN-1967 Panama 1967 Balboa 6605.46 12955.64 0.17 0.23
PAN-1968 Panama 1968 Balboa 7103.50 13884.02 0.18 0.23
PAN-1969 Panama 1969 Balboa 7759.28 14962.66 0.18 0.23
PAN-1970 Panama 1970 Balboa 8744.86 16607.58 0.16 0.21
PAN-1971 Panama 1971 Balboa 9853.15 18485.28 0.16 0.21
PAN-1972 Panama 1972 Balboa 11258.13 20871.08 0.16 0.20
PAN-1973 Panama 1973 Balboa 12697.48 23114.24 0.18 0.23
PAN-1974 Panama 1974 Balboa 14108.17 24912.71 0.21 0.26
PAN-1975 Panama 1975 Balboa 15473.68 26847.09 0.22 0.28
PAN-1976 Panama 1976 Balboa 16559.01 28760.00 0.25 0.31
PAN-1977 Panama 1977 Balboa 17266.49 29532.18 0.28 0.33
PAN-1978 Panama 1978 Balboa 18411.53 30826.65 0.30 0.36
PAN-1979 Panama 1979 Balboa 19512.69 32049.46 0.34 0.38
PAN-1980 Panama 1980 Balboa 20876.89 33797.89 0.37 0.41
PAN-1981 Panama 1981 Balboa 22641.34 36217.00 0.38 0.41
PAN-1982 Panama 1982 Balboa 24276.00 38632.23 0.40 0.43
PAN-1983 Panama 1983 Balboa 24367.44 39796.43 0.44 0.48
PAN-1984 Panama 1984 Balboa 24464.84 40627.00 0.40 0.44
PAN-1985 Panama 1985 Balboa 24666.54 41321.05 0.45 0.50
PAN-1986 Panama 1986 Balboa 25712.54 42623.68 0.42 0.46
PAN-1987 Panama 1987 Balboa 26721.90 44186.40 0.44 0.47
PAN-1988 Panama 1988 Balboa 26434.91 43668.59 0.41 0.43
PAN-1989 Panama 1989 Balboa 25723.74 42711.34 0.47 0.50
PAN-1990 Panama 1990 Balboa 25448.71 42280.00 0.40 0.49
PAN-1991 Panama 1991 Balboa 25695.94 43114.36 0.45 0.50
PAN-1992 Panama 1992 Balboa 26580.91 44983.62 0.45 0.50
PAN-1993 Panama 1993 Balboa 28817.30 48241.75 0.45 0.48
PAN-1994 Panama 1994 Balboa 31240.93 51560.62 0.47 0.49
PAN-1995 Panama 1995 Balboa 34024.90 55079.75 0.50 0.50
PAN-1996 Panama 1996 Balboa 36206.36 58254.40 0.50 0.51
PAN-1997 Panama 1997 Balboa 39246.56 61684.64 0.49 0.50
PAN-1998 Panama 1998 Balboa 43127.16 65850.27 0.50 0.51
PAN-1999 Panama 1999 Balboa 47489.82 70507.17 0.46 0.47
PAN-2000 Panama 2000 Balboa 51416.66 74266.59 0.46 0.47
PAN-2001 Panama 2001 Balboa 53947.66 75946.75 0.43 0.45
PAN-2002 Panama 2002 Balboa 56263.82 77322.80 0.40 0.43
PAN-2003 Panama 2003 Balboa 60077.42 79968.25 0.41 0.44
PAN-2004 Panama 2004 Balboa 65767.67 83185.09 0.39 0.41
PAN-2005 Panama 2005 Balboa 73176.20 86754.70 0.39 0.40
PAN-2006 Panama 2006 Balboa 81943.73 91417.51 0.39 0.39
PAN-2007 Panama 2007 Balboa 92301.11 99499.91 0.63 0.50
PAN-2008 Panama 2008 Balboa 103622.45 109266.60 0.67 0.54
PAN-2009 Panama 2009 Balboa 112844.94 117964.95 0.67 0.55
PAN-2010 Panama 2010 Balboa 124656.47 128348.80 0.66 0.55
PAN-2011 Panama 2011 Balboa 142056.69 142056.69 0.68 0.57
PAN-2012 Panama 2012 Balboa 158524.39 159050.12 0.72 0.60
PAN-2013 Panama 2013 Balboa 179119.08 178155.89 0.50 0.46
PAN-2014 Panama 2014 Balboa 201345.03 197037.30 0.52 0.47

3. Use las funciones creadas en 1 y 2, para generar 2 DataFrames, que muestren los datos de “EE.UU” y “Reino Unido”, para el periodo de 1990-2000.

funcion_elegir_pais3(iso_pais = "USA",1990,2000) %>%
  kable(caption = "Datos de Estados Unidos de 1990 a 2000", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Estados Unidos de 1990 a 2000
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
USA-1990 United States of America USA 1990 US Dollar 9203227 9203558 252.85 123.40 1793.35 3.44 7180793 9379958 9259331 9259567 26453210 1 1 9241600 7644560 9454309 29208678 0.82 0.80 0.62 0.05 1 0.66 0.65 0.65 interpolated benchmark market no NA NA 0.67 0.24 0.11 0.07 -0.09 0.01 0.62 0.58 0.95 0.61 0.62 0.65
USA-1991 United States of America USA 1991 US Dollar 9191710 9171585 255.37 121.96 1782.94 3.45 7177849 9287654 9244829 9248708 26586270 1 1 9234885 7681240 9385194 29807548 0.82 0.80 0.62 0.05 1 0.69 0.67 0.67 interpolated benchmark market no NA NA 0.67 0.23 0.11 0.07 -0.08 0.01 0.64 0.59 1.00 0.66 0.66 0.67
USA-1992 United States of America USA 1992 US Dollar 9530917 9509170 257.91 122.23 1773.46 3.47 7393262 9636033 9585170 9573914 26769574 1 1 9563208 7915272 9717433 30447546 0.84 0.82 0.63 0.05 1 0.71 0.68 0.68 interpolated benchmark market no NA NA 0.67 0.23 0.11 0.08 -0.10 0.01 0.66 0.58 1.03 0.59 0.60 0.68
USA-1993 United States of America USA 1993 US Dollar 9827602 9786068 260.53 123.59 1789.84 3.49 7598004 9976447 9882773 9835906 27514982 1 1 9825721 8133447 10036044 31142584 0.84 0.83 0.62 0.05 1 0.73 0.70 0.70 interpolated benchmark market no NA NA 0.67 0.24 0.10 0.08 -0.10 0.01 0.68 0.59 1.07 0.61 0.60 0.70
USA-1994 United States of America USA 1994 US Dollar 10262589 10205495 263.30 126.20 1805.17 3.50 7875691 10382788 10252747 10232211 28433732 1 1 10222333 8395977 10477239 31914476 0.85 0.84 0.61 0.05 1 0.74 0.71 0.71 interpolated benchmark market no NA NA 0.67 0.25 0.10 0.08 -0.11 0.01 0.69 0.62 1.09 0.62 0.63 0.71
USA-1995 United States of America USA 1995 US Dollar 10550124 10501270 266.28 128.00 1822.32 3.52 8141430 10649630 10526347 10519550 29573488 1 1 10511666 8603863 10745698 32739804 0.85 0.83 0.61 0.05 1 0.75 0.73 0.73 extrapolated benchmark market no NA NA 0.68 0.24 0.10 0.08 -0.11 0.01 0.70 0.65 1.13 0.66 0.67 0.73
USA-1996 United States of America USA 1996 US Dollar 10988194 10926444 269.48 129.91 1818.63 3.53 8440640 11059940 10929891 10918888 30426092 1 1 10910675 8855808 11165208 33669848 0.86 0.85 0.61 0.05 1 0.76 0.74 0.74 benchmark benchmark market no 1 NA 0.68 0.24 0.09 0.08 -0.11 0.01 0.71 0.67 1.18 0.67 0.68 0.74
USA-1997 United States of America USA 1997 US Dollar 11538199 11437019 272.88 132.93 1830.80 3.54 8705518 11552962 11417703 11409474 31494458 1 1 11400236 9158386 11695571 34694968 0.88 0.86 0.61 0.05 1 0.78 0.75 0.75 interpolated benchmark market no NA NA 0.67 0.25 0.09 0.10 -0.12 0.01 0.73 0.68 1.16 0.63 0.65 0.76
USA-1998 United States of America USA 1998 US Dollar 12132393 11956923 276.35 135.08 1842.79 3.56 9099003 12138236 11924765 11916442 32851262 1 1 11907535 9590438 12341446 35854404 0.89 0.88 0.63 0.05 1 0.79 0.76 0.76 interpolated benchmark market no NA NA 0.67 0.26 0.09 0.09 -0.12 0.01 0.74 0.68 1.16 0.60 0.64 0.76
USA-1999 United States of America USA 1999 US Dollar 12720219 12510232 279.73 137.34 1849.39 3.57 9558780 12834665 12502540 12473554 34374992 1 1 12465426 10054181 13025560 37122332 0.91 0.91 0.63 0.05 1 0.80 0.77 0.77 benchmark benchmark market no NA NA 0.67 0.26 0.09 0.09 -0.13 0.01 0.75 0.69 1.18 0.60 0.64 0.77
USA-2000 United States of America USA 2000 US Dollar 13222419 13031820 282.90 139.30 1848.15 3.58 9977582 13511612 13035321 12983206 35997032 1 1 12975535 10500206 13647352 38439588 0.92 0.93 0.64 0.05 1 0.83 0.79 0.79 interpolated benchmark market no NA NA 0.68 0.27 0.09 0.11 -0.16 0.01 0.77 0.69 1.20 0.57 0.62 0.79
funcion_elegir_pais3(iso_pais = "GBR",1990,2000) %>%
  kable(caption = "Datos de Reino Unido de 1990 a 2000", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Reino Unido de 1990 a 2000
country isocode year currency rgdpe rgdpo pop emp avh hc ccon cda cgdpe cgdpo ck ctfp cwtfp rgdpna rconna rdana rkna rtfpna rwtfpna labsh delta xr pl_con pl_da pl_gdpo i_cig i_xm i_xr i_outlier cor_exp statcap csh_c csh_i csh_g csh_x csh_m csh_r pl_c pl_i pl_g pl_x pl_m pl_k
GBR-1990 United Kingdom GBR 1990 Pound Sterling 1417085 1385562 57.11 26.70 1757.43 3.20 1089023 1383493 1389299 1359320 3581698 0.86 0.86 1454251 1151596 1441845 6776786 0.85 0.79 0.63 0.04 0.56 0.78 0.79 0.80 interpolated benchmark market no NA NA 0.64 0.22 0.16 0.23 -0.28 0.04 0.74 0.82 0.93 0.60 0.58 1.10
GBR-1991 United Kingdom GBR 1991 Pound Sterling 1401382 1363587 57.26 25.93 1741.23 3.23 1069733 1341803 1372772 1344283 3680473 0.85 0.84 1435970 1141932 1405051 6870655 0.85 0.78 0.64 0.05 0.57 0.84 0.83 0.85 interpolated benchmark market no NA NA 0.63 0.20 0.16 0.20 -0.24 0.05 0.81 0.79 0.99 0.66 0.62 1.04
GBR-1992 United Kingdom GBR 1992 Pound Sterling 1414993 1376120 57.42 25.35 1710.73 3.26 1079084 1364559 1386354 1355717 3798598 0.84 0.84 1442380 1157180 1430968 6966938 0.86 0.81 0.63 0.05 0.57 0.88 0.85 0.87 interpolated benchmark market no NA NA 0.63 0.21 0.16 0.25 -0.29 0.04 0.84 0.75 1.04 0.57 0.56 0.95
GBR-1993 United Kingdom GBR 1993 Pound Sterling 1464740 1427750 57.58 25.17 1703.90 3.29 1109786 1408161 1434157 1398855 3989535 0.85 0.84 1480387 1194679 1478699 7066574 0.88 0.83 0.62 0.05 0.67 0.77 0.74 0.76 interpolated benchmark market no NA NA 0.64 0.21 0.16 0.20 -0.26 0.05 0.73 0.63 0.92 0.58 0.55 0.76
GBR-1994 United Kingdom GBR 1994 Pound Sterling 1519652 1478347 57.74 25.37 1718.15 3.32 1143430 1462102 1480134 1454296 4275514 0.84 0.84 1539957 1230659 1542677 7189067 0.90 0.85 0.60 0.05 0.65 0.80 0.77 0.78 interpolated benchmark market no NA NA 0.63 0.22 0.15 0.23 -0.27 0.03 0.76 0.67 0.95 0.60 0.58 0.73
GBR-1995 United Kingdom GBR 1995 Pound Sterling 1589475 1554254 57.90 25.65 1725.71 3.35 1170911 1539666 1544871 1524399 4596206 0.85 0.85 1578791 1257032 1623079 7350978 0.90 0.87 0.60 0.05 0.63 0.84 0.80 0.81 benchmark benchmark market no NA NA 0.62 0.24 0.14 0.24 -0.27 0.03 0.80 0.67 1.02 0.65 0.63 0.75
GBR-1996 United Kingdom GBR 1996 Pound Sterling 1674593 1641439 58.08 25.90 1727.99 3.38 1243814 1616862 1620570 1603619 4926870 0.85 0.84 1620910 1298540 1675014 7519430 0.90 0.88 0.59 0.05 0.64 0.83 0.81 0.81 benchmark benchmark market no 0.92 NA 0.64 0.23 0.14 0.24 -0.27 0.02 0.79 0.71 1.05 0.65 0.64 0.77
GBR-1997 United Kingdom GBR 1997 Pound Sterling 1801386 1756577 58.26 26.38 1705.12 3.41 1356676 1730260 1738406 1726820 5047923 0.89 0.88 1671142 1352621 1731868 7664252 0.91 0.89 0.59 0.05 0.61 0.85 0.83 0.84 benchmark benchmark market no NA NA 0.65 0.22 0.14 0.26 -0.29 0.02 0.81 0.76 1.02 0.62 0.62 0.83
GBR-1998 United Kingdom GBR 1998 Pound Sterling 1888442 1813215 58.46 26.65 1720.47 3.44 1437450 1828209 1813438 1801130 5103451 0.89 0.89 1727567 1407718 1817333 7832531 0.92 0.91 0.61 0.05 0.60 0.86 0.85 0.85 benchmark benchmark market no NA NA 0.66 0.22 0.14 0.25 -0.29 0.02 0.83 0.79 1.02 0.59 0.60 0.87
GBR-1999 United Kingdom GBR 1999 Pound Sterling 1962498 1884668 58.66 27.01 1712.21 3.48 1534616 1917937 1886983 1877945 5035408 0.91 0.90 1781342 1469890 1894809 7996396 0.93 0.94 0.62 0.05 0.62 0.84 0.83 0.83 benchmark benchmark market no NA NA 0.67 0.20 0.15 0.24 -0.28 0.02 0.81 0.80 0.98 0.58 0.60 0.92
GBR-2000 United Kingdom GBR 2000 Pound Sterling 2088803 2024305 58.87 27.32 1699.11 3.51 1650633 2054763 2015176 2011111 5134820 0.95 0.93 1849012 1538370 1967642 8162493 0.95 0.96 0.63 0.05 0.66 0.77 0.77 0.77 benchmark benchmark market no NA NA 0.67 0.20 0.15 0.27 -0.33 0.03 0.75 0.77 0.89 0.54 0.57 0.90
funcion_CapitalDetail(iso_pais = "USA") %>% 
  filter(year %in% 1990:2000) %>%
  kable(caption = "Datos de Capital Detail para Estados Unidos de 1990-2000", digits = 2,align = "l") %>%
  kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Capital Detail para Estados Unidos de 1990-2000
country year currency ck rkna pl_i pl_k
USA-1990 United States of America 1990 US Dollar 26453210 29208678 0.58 0.65
USA-1991 United States of America 1991 US Dollar 26586270 29807548 0.59 0.67
USA-1992 United States of America 1992 US Dollar 26769574 30447546 0.58 0.68
USA-1993 United States of America 1993 US Dollar 27514982 31142584 0.59 0.70
USA-1994 United States of America 1994 US Dollar 28433732 31914476 0.62 0.71
USA-1995 United States of America 1995 US Dollar 29573488 32739804 0.65 0.73
USA-1996 United States of America 1996 US Dollar 30426092 33669848 0.67 0.74
USA-1997 United States of America 1997 US Dollar 31494458 34694968 0.68 0.76
USA-1998 United States of America 1998 US Dollar 32851262 35854404 0.68 0.76
USA-1999 United States of America 1999 US Dollar 34374992 37122332 0.69 0.77
USA-2000 United States of America 2000 US Dollar 35997032 38439588 0.69 0.79
funcion_CapitalDetail(iso_pais = "GBR") %>% 
  filter(year %in% 1990:2000) %>%
  kable(caption = "Datos de Capital Detail para Reino Unido de 1990-2000", digits = 2,align = "l") %>% kable_styling(bootstrap_options = "striped",full_width = TRUE) 
Datos de Capital Detail para Reino Unido de 1990-2000
country year currency ck rkna pl_i pl_k
GBR-1990 United Kingdom 1990 Pound Sterling 3581698 6776786 0.82 1.10
GBR-1991 United Kingdom 1991 Pound Sterling 3680473 6870655 0.79 1.04
GBR-1992 United Kingdom 1992 Pound Sterling 3798598 6966938 0.75 0.95
GBR-1993 United Kingdom 1993 Pound Sterling 3989535 7066574 0.63 0.76
GBR-1994 United Kingdom 1994 Pound Sterling 4275514 7189067 0.67 0.73
GBR-1995 United Kingdom 1995 Pound Sterling 4596206 7350978 0.67 0.75
GBR-1996 United Kingdom 1996 Pound Sterling 4926870 7519430 0.71 0.77
GBR-1997 United Kingdom 1997 Pound Sterling 5047923 7664252 0.76 0.83
GBR-1998 United Kingdom 1998 Pound Sterling 5103451 7832531 0.79 0.87
GBR-1999 United Kingdom 1999 Pound Sterling 5035408 7996396 0.80 0.92
GBR-2000 United Kingdom 2000 Pound Sterling 5134820 8162493 0.77 0.90