#carga de datos

load("C:/Users/pc/Downloads/data_comercio_exterior_actualizada.RData")
library(kableExtra)
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following object is masked from 'package:kableExtra':
## 
##     group_rows
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
source(file = "C:/Users/pc/Downloads/funciones_comercio_exterior.R", echo = TRUE,max.deparse.length = 100,encoding = "utf-8")
## 
## > options(scipen = 999)
## 
## > library(dplyr)
## 
## > library(readxl)
## 
## > library(stringr)
## 
## > load("C:/Users/pc/Downloads/data_comercio_exterior_actualizada.RData")
## 
## > nombre_archivo <- "C:/Users/pc/Downloads/nombres_iso_paises.xlsx"
## 
## > nombres_iso_paises <- read_excel(nombre_archivo)
## 
## > data_comercio_exterior <- data_comercio_exterior %>% 
## +     left_join(nombres_iso_paises, by = c(p .... [TRUNCATED] 
## 
## > herramientas_mostrar_paises <- function() {
## +     paises <- nombres_iso_paises %>% select(nom_pais .... [TRUNCATED] 
## 
## > herramientas_mostrar_regiones <- function() {
## +     nombres_iso_paises %>% group_by(region, cod_re .... [TRUNCATED] 
## 
## > herramientas_mostrar_paises_en_tabla <- function() {
## +     data_comercio_exterior %>% group_by(pai .... [TRUNCATED] 
## 
## > indicadores_IVCR_capitulo <- function(codigo_pais, 
## +     capitulo, anio) {
## +     codigo_pais <- e .... [TRUNCATED] 
## 
## > indicadores_IVCR_partida <- function(codigo_pais, 
## +     partida, anio) {
## +     codigo_pais <- enq .... [TRUNCATED] 
## 
## > indicadores_Balassa_capitulo <- function(codigo_pais, 
## +     capitulo, anio, normalizado = TRUE) { .... [TRUNCATED] 
## 
## > indicadores_Balassa_partida <- function(codigo_pais, 
## +     partida, anio, normalizado = TRUE) {
## + .... [TRUNCATED] 
## 
## > indicadores_IHH_Herfindahl_Hirschmann_anual_texto <- function(codigo_pais, 
## +     anio, normalizad .... [TRUNCATED] 
## 
## > indicadores_IHH_Herfindahl_Hirschmann_anual <- function(codigo_pais, 
## +     anio, normalizado = TR .... [TRUNCATED]
library(pwt9)
data("pwt9.0")

#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 región de África Sub-Sahariana, para el periodo 2019-2020 son (en millones de US$)

library(dplyr)
library(kableExtra)
data_comercio_exterior %>%
  select("pais", "sac","anio","mes","valor_fob","sub_region") %>%
  filter(sub_region=="Africa Sub-Sahariana",anio %in% 2019:2020,valor_fob>0) %>%
  group_by(anio) %>%
  summarise(`Total de Exportaciones ESA a África Sub-Sahariana  MM US$`=sum(valor_fob)) %>% 
  head() %>% kable(caption = "exportaciones totales de El Salvador hacia la región de África Sub-Sahariana (2019-2020)") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()
exportaciones totales de El Salvador hacia la región de África Sub-Sahariana (2019-2020)
anio Total de Exportaciones ESA a África Sub-Sahariana MM US$
2019 529041.2
2020 1838169.5
* Elaboracion propia con base en datos del BCR

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

library(kableExtra)
data_comercio_exterior %>%
  filter(sub_region=="Asia Sudoriental", anio %in% 2017:2019) %>%
  group_by(anio) %>%
  summarise(`Total de Exportaciones a Asia Sudoriental MM US$`=sum(valor_fob)/1e6,
            `Total de Importaciones de Asia Sudoriental MM US$`=sum(valor_cif)/1e6,
            `Balanza Comercial El Salvador-Asia Sudoriental MM $`=`Total de Exportaciones a Asia Sudoriental MM US$`-`Total de Importaciones de Asia Sudoriental MM US$`) %>% 
  head() %>% kable(caption = "Saldo de  Balanza comercial El Salvador-Asia Sudoriental(2017-2019)") %>% kable_minimal()  %>%  
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_styling()
Saldo de Balanza comercial El Salvador-Asia Sudoriental(2017-2019)
anio Total de Exportaciones a Asia Sudoriental MM US$ Total de Importaciones de Asia Sudoriental MM US$ Balanza Comercial El Salvador-Asia Sudoriental MM $
2017 74.202336 392.7116 -318.5092
2018 8.270964 435.8792 -427.6083
2019 5.719074 346.4777 -340.7586
* Elaboración propia con base en datos del BCR

#3- Por cada dólar exportado a la región Sudamericana, en el año 2019, ¿Cuánto se importo?

library(kableExtra)
data_comercio_exterior %>% 
filter(valor_cif==0, valor_fob>0, anio==2019,region_intermedia=="Sudamerica") %>% 
summarise(`Total de exportaciones de El Salvador a Sudamérica`=sum(valor_fob)/1e6)->exportaciones

data_comercio_exterior %>%
filter(valor_cif>0,valor_fob==0, anio==2019,region_intermedia=="Sudamerica") %>% 
  summarise(`proporcion importaciones/exportaciones  a Sudamérica`=sum(valor_cif)/1e6)->importaciones

proporcion_importaciones_exportaciones<-(importaciones/exportaciones)
print(proporcion_importaciones_exportaciones)
##   proporcion importaciones/exportaciones  a Sudamérica
## 1                                             19.70506

#4- Calcule el indicador de Balassa de El Salvador, con México, Estados Unidos y Canadá, durante el periodo 2017-2020, para el capitulo “01” del SAC

library(dplyr)
library(kableExtra)
capitulo<-"01"
data.frame("años"=2017:2020,
"IB_Mexico"=sapply(X=2017:2020,FUN = indicadores_Balassa_capitulo,codigo_pais=484,capitulo=capitulo),                     "IB_USA"=sapply(X=2017:2020,FUN=indicadores_Balassa_capitulo,codigo_pais=840,capitulo=capitulo),
"IB_Canada"=sapply(X=2017:2020,FUN=indicadores_Balassa_capitulo,codigo_pais=124,capitulo=capitulo))%>%
head() %>% kable(caption = "Balassa Version Nueva") %>% kable_minimal() %>% 
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_styling(bootstrap_options = "striped",full_width = TRUE)
Balassa Version Nueva
años IB_Mexico IB_USA IB_Canada
2017 -0.3907528 0.5515435 0.5797836
2018 -0.7289427 0.5218149 0.7442666
2019 -0.8360047 0.5896986 0.3886110
2020 -0.9860838 0.6875276 0.5448175
* Elaboración propia con base en datos del BCR

#1- Calcule el indicador de IVCR de El Salvador, con México, Estados Unidos y Canadá, durante el periodo 2017-2020, para el capitulo “01” del SAC

capitulo<-"01"
options(scipen = 99999)
data.frame("años"=2017:2020,
"IVCR_Mexico"=sapply(X=2017:2020,FUN = indicadores_IVCR_capitulo,codigo_pais=484,capitulo=capitulo),
"IVCR_USA"=sapply(X=2017:2020,FUN=indicadores_IVCR_capitulo,codigo_pais=840,capitulo=capitulo),
"IVCR_Canadá"=sapply(X=2017:2020,FUN = indicadores_IVCR_capitulo,codigo_pais=124,capitulo=capitulo))%>%
head() %>% kable(caption = "IVCR de El Salvador, con México, Estados Unidos y Canadá para los años 2017-2020") %>% kable_minimal() %>% 
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_styling(bootstrap_options = "striped",full_width = TRUE)
IVCR de El Salvador, con México, Estados Unidos y Canadá para los años 2017-2020
años IVCR_Mexico IVCR_USA IVCR_Canadá
2017 -0.0006366 -0.1268112 0.0025811
2018 -0.0047819 -0.0995279 0.0000473
2019 -0.0015082 -0.0898908 0.0001743
2020 -0.0008395 -0.0781483 -0.0007660
* Elaboración propia con base en datos del BCR

#2- Por cada dólar exportado a la región Centroamericana , en el periodo 2017-2019, ¿Cuánto se importo? (resultado por año)calcular 3 veces

data_comercio_exterior %>% 
filter(valor_cif==0, valor_fob>0, anio==2018,region_intermedia=="Centroamérica") %>% 
  summarise(`Total de exportaciones de El Salvador a CA`=sum(valor_fob))->exportaciones_2018

data_comercio_exterior %>%
filter(region_intermedia=="Centroamérica", valor_cif>0, valor_fob==0, anio==2018) %>% 
  summarise(`proporcion importaciones/exportaciones  a Centroamérica`=sum(valor_cif))->importaciones_2018

proporcion_importaciones_exportaciones_2018<- (importaciones_2018/exportaciones_2018)
print(proporcion_importaciones_exportaciones_2018)
##   proporcion importaciones/exportaciones  a Centroamérica
## 1                                                1.705863

#3- Obtenga el Saldo de la balanza comercial de El Salvador, con el “Caribe”, para el periodo 2017-2019, (en millones de US$)

data_comercio_exterior %>%
filter(region_intermedia=="Caribe",anio %in% 2017:2019) %>%
group_by(anio) %>%
summarise(`Total Exportaciones al Caribe en millones de US$`=sum(valor_fob)/1e6,
          `Total Importaciones del Caribe en millones de US$`=sum(valor_cif)/1e6,
          `Balanza Comercial de El Salvador con el Caribe en millones de US$`=`Total Exportaciones al Caribe en millones de US$`-`Total Importaciones del Caribe en millones de US$`) %>% 
  head() %>% kable(caption = "Saldo de Balanza comercial El Salvador con el Caribe (2017-2019)") %>% kable_minimal()  %>%  
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_styling()
Saldo de Balanza comercial El Salvador con el Caribe (2017-2019)
anio Total Exportaciones al Caribe en millones de US$ Total Importaciones del Caribe en millones de US$ Balanza Comercial de El Salvador con el Caribe en millones de US$
2017 292.3646 43.06761 249.2970
2018 335.0604 37.47720 297.5832
2019 323.5656 41.62496 281.9406
* Elaboración propia con base en datos del BCR

#4- Calcule las exportaciones totales de El Salvador hacia la región Norte De Europa, para el periodo 2019-2020 son (en millones de US$)

data_comercio_exterior %>%
  select("anio","valor_fob","sub_region") %>%
  filter(sub_region=="Norte De Europa",anio %in% 2019:2020,valor_fob>0) %>%
  group_by(anio) %>%
  summarise(`Total de Exportaciones de El Salvador hacia el Norte de Europa en millones de US$`=sum(valor_fob)/1e6) %>% 
  head() %>% kable(caption = "Exportaciones totales de El Salvador hacia el Norte de Europa (2019-2020)") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()
Exportaciones totales de El Salvador hacia el Norte de Europa (2019-2020)
anio Total de Exportaciones de El Salvador hacia el Norte de Europa en millones de US$
2019 20.76947
2020 10.49692
* Elaboracion propia con base en datos del BCR

#1- Por cada dólar exportado a la región Suramericana, en el periodo 2018-2019, ¿Cuánto se importo? (resultado por año)

data_comercio_exterior%>% 
filter(valor_cif==0, valor_fob>0, anio==2018,region_intermedia=="Sudamerica") %>% 
  summarise(`Total de Exportaciones de El Salvador a Sudamerica MM US$`=sum(valor_fob))->exportaciones_2018

data_comercio_exterior %>%
filter(region_intermedia=="Sudamerica", valor_cif>0, valor_fob==0, anio==2018) %>% 
  summarise(`proporcion_Importaciones/Exportaciones a Sudamerica`=sum(valor_cif))->importaciones_2018

proporcion_importaciones_exportaciones_2018<- (importaciones_2018/exportaciones_2018)
print(proporcion_importaciones_exportaciones_2018)
##   proporcion_Importaciones/Exportaciones a Sudamerica
## 1                                            17.61518

#2- Calcule el IHH de El Salvador, con México, Estados Unidos y Canadá, durante el periodo 2017-2020, normalizado

data.frame("anios"=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))%>%
  kable(caption = "Índice IHH normalizado de El Salvador, con México, Estados Unidos y Canadá (2017-2020)")%>%
  kable_styling(bootstrap_options = "striped",
                full_width = TRUE)%>% 
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()
Índice IHH normalizado de El Salvador, con México, Estados Unidos y Canadá (2017-2020)
anios IHH_Mexico IHH_USA IHH_Canada
2017 0.0082731 0.0027951 0.0614871
2018 0.0091048 0.0028299 0.0042184
2019 0.0071807 0.0029499 0.0596321
2020 0.0051876 0.0029361 0.0144775
* Elaboración propia con base en datos del BCR

#3- Calcule las exportaciones totales de El Salvador hacia la región de África Oriental, para el periodo 2017-2020 son (en millones de US$)

data_comercio_exterior %>%
 select("anio","valor_fob","region_intermedia") %>%
 filter(region_intermedia=="África Oriental",anio %in% 2017:2020,valor_fob>0) %>%
group_by(anio) %>%
summarise(`Total de Exportaciones de El Salvador hacia África Oriental,  millones US$`=sum(valor_fob)/1e6) %>% 
head() %>% kable(caption = "Exportaciones totales de El Salvador hacia la region de África oriental,(2017-2020)") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()
Exportaciones totales de El Salvador hacia la region de África oriental,(2017-2020)
anio Total de Exportaciones de El Salvador hacia África Oriental, millones US$
2017 0.6697564
2018 0.0461678
2019 0.2439199
2020 0.0175347
* Elaboración propia con base en datos del BCR

#4- Obtenga el Saldo de la balanza comercial de El Salvador, con Latinoamérica, para el periodo 2017-2019, (en millones de US$)

data_comercio_exterior %>%
filter(sub_region=="América Latina Y El Caribe",anio %in% 2017:2019) %>%
group_by(anio) %>%
summarise(`Total Exportaciones a América Latina Y El Caribe MM US$`=sum(valor_fob)/1e6,
            `Total Importaciones de América Latina Y El Caribe MM US$`=sum(valor_cif)/1e6,
            `Saldo Balanza Comercial El Salvador-América Latina Y El Caribe MM $`=`Total Exportaciones a América Latina Y El Caribe MM US$`-`Total Importaciones de América Latina Y El Caribe MM US$`) %>% 
  head() %>% kable(caption = "Saldo de Balanza comercial de El Salvador con América Latina Y El Caribe,(2017-2019)") %>% kable_minimal()  %>%  
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_styling()
Saldo de Balanza comercial de El Salvador con América Latina Y El Caribe,(2017-2019)
anio Total Exportaciones a América Latina Y El Caribe MM US$ Total Importaciones de América Latina Y El Caribe MM US$ Saldo Balanza Comercial El Salvador-América Latina Y El Caribe MM $
2017 5480.583 7492.751 -2012.168
2018 5832.641 8127.847 -2295.206
2019 6063.206 9008.408 -2945.202
* Elaboración propia con base en datos del BCR

#______________________________________________________________

#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 función que le permita elegir el país y filtrar para un periodo(inicio,final), muestre su uso filtrando los datos para El Salvador, en el periodo de 1950-2014

library(pwt9)
data("pwt9.0")
options(scipen = 999999)
# Función consulta pais, para un periodo especifico
funcion_elegir_pais_periodo<- function(country,anio_inicio,anio_final) {
pwt9.0 %>% filter(country==!!country,year>=anio_inicio,year<=anio_final) -> pais_periodo_1
pais_periodo_1
}
# Filtrando todos los datos para El Salvador, período 1950-2014
funcion_elegir_pais_periodo(country = "El Salvador",anio_inicio  = 1950,anio_final  = 2014) %>%
 kable(caption = "Datos de El Salvador (SLV), periodo 1950-2014",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
Datos de El Salvador (SLV), periodo 1950-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 función que le permita elegir todas las variables de la categoria “Trade detail”, muestre su uso para los datos de Argentina

# Construyendo la función
funcion_elegir_variables_trade_detail <- function(country,anio_inicio,anio_final) {
  pwt9.0 %>% filter(country==!!country,year>=anio_inicio,year<=anio_final) %>%
    select(country,
           year, 
           pl_x,pl_m,
           csh_x,csh_m)-> variables_trade
 variables_trade
}
funcion_elegir_variables_trade_detail(country = "Argentina",1950,2014) %>%
 kable(caption = "Variables de la categoría Trade detail para Argentina",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
Variables de la categoría Trade detail para Argentina
country year pl_x pl_m csh_x csh_m
ARG-1950 Argentina 1950 0.13 0.12 0.11 -0.05
ARG-1951 Argentina 1951 0.16 0.13 0.09 -0.07
ARG-1952 Argentina 1952 0.14 0.15 0.07 -0.05
ARG-1953 Argentina 1953 0.12 0.11 0.10 -0.04
ARG-1954 Argentina 1954 0.10 0.10 0.10 -0.05
ARG-1955 Argentina 1955 0.12 0.12 0.08 -0.05
ARG-1956 Argentina 1956 0.22 0.25 0.09 -0.04
ARG-1957 Argentina 1957 0.20 0.25 0.09 -0.05
ARG-1958 Argentina 1958 0.19 0.23 0.08 -0.04
ARG-1959 Argentina 1959 0.25 0.28 0.09 -0.04
ARG-1960 Argentina 1960 0.25 0.23 0.09 -0.05
ARG-1961 Argentina 1961 0.24 0.17 0.07 -0.06
ARG-1962 Argentina 1962 0.14 0.30 0.10 -0.05
ARG-1963 Argentina 1963 0.21 0.32 0.09 -0.05
ARG-1964 Argentina 1964 0.19 0.22 0.09 -0.06
ARG-1965 Argentina 1965 0.22 0.18 0.07 -0.07
ARG-1966 Argentina 1966 0.20 0.25 0.08 -0.04
ARG-1967 Argentina 1967 0.25 0.27 0.07 -0.05
ARG-1968 Argentina 1968 0.25 0.30 0.06 -0.05
ARG-1969 Argentina 1969 0.25 0.34 0.07 -0.05
ARG-1970 Argentina 1970 0.22 0.32 0.09 -0.05
ARG-1971 Argentina 1971 0.26 0.34 0.07 -0.06
ARG-1972 Argentina 1972 0.28 0.36 0.04 -0.03
ARG-1973 Argentina 1973 0.27 0.31 0.05 -0.03
ARG-1974 Argentina 1974 0.25 0.32 0.05 -0.03
ARG-1975 Argentina 1975 0.27 0.33 0.09 -0.10
ARG-1976 Argentina 1976 0.34 0.44 0.07 -0.04
ARG-1977 Argentina 1977 0.32 0.45 0.13 -0.06
ARG-1978 Argentina 1978 0.28 0.39 0.13 -0.06
ARG-1979 Argentina 1979 0.24 0.31 0.12 -0.08
ARG-1980 Argentina 1980 0.21 0.23 0.11 -0.13
ARG-1981 Argentina 1981 0.29 0.30 0.11 -0.12
ARG-1982 Argentina 1982 0.39 0.48 0.14 -0.08
ARG-1983 Argentina 1983 0.42 0.52 0.11 -0.05
ARG-1984 Argentina 1984 0.38 0.43 0.11 -0.06
ARG-1985 Argentina 1985 0.38 0.42 0.15 -0.06
ARG-1986 Argentina 1986 0.42 0.45 0.10 -0.06
ARG-1987 Argentina 1987 0.47 0.50 0.08 -0.07
ARG-1988 Argentina 1988 0.49 0.54 0.10 -0.05
ARG-1989 Argentina 1989 0.50 0.53 0.11 -0.04
ARG-1990 Argentina 1990 0.50 0.54 0.12 -0.04
ARG-1991 Argentina 1991 0.57 0.59 0.09 -0.06
ARG-1992 Argentina 1992 0.49 0.53 0.09 -0.10
ARG-1993 Argentina 1993 0.51 0.52 0.08 -0.10
ARG-1994 Argentina 1994 0.53 0.55 0.08 -0.10
ARG-1995 Argentina 1995 0.57 0.59 0.09 -0.08
ARG-1996 Argentina 1996 0.58 0.59 0.08 -0.08
ARG-1997 Argentina 1997 0.57 0.57 0.08 -0.10
ARG-1998 Argentina 1998 0.53 0.54 0.09 -0.10
ARG-1999 Argentina 1999 0.52 0.54 0.09 -0.09
ARG-2000 Argentina 2000 0.49 0.51 0.10 -0.09
ARG-2001 Argentina 2001 0.48 0.49 0.11 -0.08
ARG-2002 Argentina 2002 0.48 0.48 0.13 -0.04
ARG-2003 Argentina 2003 0.53 0.51 0.12 -0.06
ARG-2004 Argentina 2004 0.57 0.54 0.12 -0.08
ARG-2005 Argentina 2005 0.59 0.56 0.13 -0.09
ARG-2006 Argentina 2006 0.61 0.58 0.13 -0.10
ARG-2007 Argentina 2007 0.67 0.63 0.13 -0.11
ARG-2008 Argentina 2008 0.74 0.69 0.14 -0.12
ARG-2009 Argentina 2009 0.69 0.64 0.12 -0.09
ARG-2010 Argentina 2010 0.71 0.67 0.13 -0.11
ARG-2011 Argentina 2011 0.75 0.70 0.13 -0.13
ARG-2012 Argentina 2012 0.74 0.73 0.13 -0.11
ARG-2013 Argentina 2013 0.75 0.70 0.12 -0.12
ARG-2014 Argentina 2014 0.75 0.71 0.11 -0.11

#3- Use las funciones creadas en 1 y 2, para generar 2 dataframes, que muestren los datos de “México” y “Canadá” para el periodo 2000-2014

funcion_elegir_pais_periodo(c("Mexico","Canada"),2000,2014) -> dataframe_1
print(dataframe_1) %>%
  kable(caption = "Datos de México y Canadá (2000-2014)",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
##          country isocode year        currency   rgdpe   rgdpo       pop
## CAN-2001  Canada     CAN 2001 Canadian Dollar 1166188 1119308  30.99134
## CAN-2003  Canada     CAN 2003 Canadian Dollar 1211094 1184269  31.59659
## CAN-2005  Canada     CAN 2005 Canadian Dollar 1311424 1323181  32.25633
## CAN-2007  Canada     CAN 2007 Canadian Dollar 1376870 1384391  32.98228
## CAN-2009  Canada     CAN 2009 Canadian Dollar 1310934 1304883  33.74656
## CAN-2011  Canada     CAN 2011 Canadian Dollar 1423920 1455816  34.49990
## CAN-2013  Canada     CAN 2013 Canadian Dollar 1478439 1493624  35.23061
## MEX-2000  Mexico     MEX 2000    Mexican Peso 1241567 1203299 102.80859
## MEX-2002  Mexico     MEX 2002    Mexican Peso 1265801 1217542 105.57830
## MEX-2004  Mexico     MEX 2004    Mexican Peso 1399936 1345215 108.25782
## MEX-2006  Mexico     MEX 2006    Mexican Peso 1581637 1542631 111.38286
## MEX-2008  Mexico     MEX 2008    Mexican Peso 1693705 1677677 114.97282
## MEX-2010  Mexico     MEX 2010    Mexican Peso 1734610 1694514 118.61754
## MEX-2012  Mexico     MEX 2012    Mexican Peso 1908250 1862729 122.07096
## MEX-2014  Mexico     MEX 2014    Mexican Peso 1987688 1945966 125.38583
##               emp      avh       hc      ccon     cda   cgdpe   cgdpo      ck
## CAN-2001 15.05903 1767.990 3.518916  814203.9 1079932 1145022 1144414 3268334
## CAN-2003 15.84749 1732.136 3.548723  858441.9 1148489 1194611 1200543 3349291
## CAN-2005 16.43793 1739.182 3.578782  918976.9 1263380 1315081 1326233 3865556
## CAN-2007 17.26695 1724.689 3.609095  969776.7 1342214 1370408 1395106 4445640
## CAN-2009 17.43560 1678.515 3.639666 1000717.9 1325223 1306457 1323073 4794360
## CAN-2011 18.07691 1683.574 3.662325 1045868.8 1440603 1423920 1455816 5427466
## CAN-2013 18.66565 1682.736 3.676923 1086339.8 1488701 1465085 1472069 5828469
## MEX-2000 38.60970 2173.992 2.417732  976115.5 1233276 1210525 1196573 2683662
## MEX-2002 39.59854 2196.150 2.456598 1021844.4 1259728 1243224 1219592 2552782
## MEX-2004 41.23692 2123.364 2.496088 1114709.0 1384239 1376237 1344221 3077106
## MEX-2006 43.06945 2141.324 2.536212 1244907.5 1576208 1571088 1546752 3770402
## MEX-2008 45.01016 2173.356 2.571415 1345486.1 1729921 1692513 1672410 4036200
## MEX-2010 48.29945 2128.041 2.599173 1381195.4 1742997 1728535 1697135 5054693
## MEX-2012 50.82909 2106.862 2.637690 1535906.1 1947835 1903657 1851572 6089364
## MEX-2014 51.41257 2136.773 2.676779 1602949.4 2009978 1974138 1934006 6677512
##               ctfp     cwtfp  rgdpna    rconna   rdana    rkna    rtfpna
## CAN-2001 0.9022754 0.8153173 1190649  782785.5 1041029 3905941 1.0337603
## CAN-2003 0.8915871 0.8093318 1247575  832796.8 1119539 4151862 1.0330168
## CAN-2005 0.9038564 0.7981808 1327435  882079.1 1221829 4462552 1.0369463
## CAN-2007 0.8834894 0.8020070 1389595  950916.3 1319552 4812567 1.0226208
## CAN-2009 0.8118237 0.7897093 1367808  994270.1 1323141 5106391 0.9890912
## CAN-2011 0.8070218 0.7662106 1455816 1045868.8 1440603 5427466 1.0000000
## CAN-2013 0.7754062 0.7574083 1513537 1084256.5 1500049 5779532 0.9928653
## MEX-2000 0.6776875 0.6711588 1458667 1084404.0 1414794 3850000 1.1481084
## MEX-2002 0.6798000 0.6677148 1469444 1119252.6 1433203 4150159 1.0850003
## MEX-2004 0.6890303 0.6691776 1552597 1225134.2 1551886 4461555 1.0916569
## MEX-2006 0.7279464 0.6927031 1679987 1343449.2 1719133 4852529 1.0932913
## MEX-2008 0.7459487 0.7331457 1758094 1411593.2 1826431 5305337 1.0535300
## MEX-2010 0.6361806 0.6299252 1761765 1405425.9 1779081 5671746 0.9895102
## MEX-2012 0.6145336 0.6213605 1904764 1537147.2 1954599 6096434 1.0019095
## MEX-2014 0.6035797 0.6044779 1974418 1601032.4 2025506 6498114 0.9832620
##            rwtfpna     labsh      delta         xr    pl_con     pl_da
## CAN-2001 0.9134005 0.6171623 0.04350585  1.5487608 0.6702421 0.6399313
## CAN-2003 0.9367892 0.6124471 0.04180438  1.4010517 0.7807368 0.7431563
## CAN-2005 0.9645296 0.5987505 0.04020973  1.2117633 0.9279599 0.8852534
## CAN-2007 0.9813300 0.6059821 0.03873762  1.0740992 1.1123220 1.0638244
## CAN-2009 0.9668959 0.6315947 0.03881708  1.1431006 1.0911957 1.0492800
## CAN-2011 1.0000000 0.6074459 0.03708802  0.9895307 1.3175685 1.2562085
## CAN-2013 0.9944088 0.6191180 0.03645137  1.0297966 1.3056631 1.2551931
## MEX-2000 1.0948994 0.4670270 0.04038701  9.4555583 0.5079750 0.5357581
## MEX-2002 1.0404917 0.4771637 0.03962168  9.6559583 0.5620881 0.5825984
## MEX-2004 1.0728562 0.4381100 0.03732139 11.2859667 0.5380411 0.5595008
## MEX-2006 1.1000023 0.4061596 0.03668293 10.8992417 0.5956349 0.6144006
## MEX-2008 1.0761238 0.3901641 0.03644980 11.1297167 0.6365756 0.6506737
## MEX-2010 0.9824765 0.4086950 0.03668989 12.6360083 0.5986645 0.6074073
## MEX-2012 1.0108787 0.3860400 0.03684472 13.1694583 0.6110190 0.6222254
## MEX-2014 0.9917858 0.3860400 0.03734821 13.2924500 0.6468756 0.6558278
##            pl_gdpo        i_cig      i_xm   i_xr i_outlier   cor_exp  statcap
## CAN-2001 0.6402714 interpolated benchmark market        no        NA       NA
## CAN-2003 0.7394839 interpolated benchmark market        no        NA       NA
## CAN-2005 0.8778094    benchmark benchmark market        no 0.9038276       NA
## CAN-2007 1.0449910 interpolated benchmark market        no        NA       NA
## CAN-2009 1.0361022 interpolated benchmark market        no        NA       NA
## CAN-2011 1.2286866    benchmark benchmark market        no 0.8238315       NA
## CAN-2013 1.2492380 extrapolated benchmark market        no        NA       NA
## MEX-2000 0.5420051 interpolated benchmark market        no        NA       NA
## MEX-2002 0.5938877    benchmark benchmark market        no        NA       NA
## MEX-2004 0.5728266 interpolated benchmark market        no        NA 74.44444
## MEX-2006 0.6240674 interpolated benchmark market        no        NA 68.88889
## MEX-2008 0.6584950 interpolated benchmark market        no        NA 77.77778
## MEX-2010 0.6186453 interpolated benchmark market        no        NA 85.55556
## MEX-2012 0.6397288 extrapolated benchmark market        no        NA 88.00000
## MEX-2014 0.6694366 extrapolated benchmark market        no        NA 85.55556
##              csh_c     csh_i     csh_g     csh_x      csh_m         csh_r
## CAN-2001 0.5601038 0.2321958 0.1513555 0.4177729 -0.3644541  0.0030260538
## CAN-2003 0.5621071 0.2415964 0.1529374 0.3902732 -0.3496419  0.0027277917
## CAN-2005 0.5438991 0.2596853 0.1490238 0.4328717 -0.3851879 -0.0002920294
## CAN-2007 0.5394937 0.2669595 0.1556341 0.4428070 -0.3985552 -0.0063390261
## CAN-2009 0.5724548 0.2452664 0.1839038 0.3453314 -0.3370062 -0.0099502383
## CAN-2011 0.5405646 0.2711428 0.1778429 0.4387028 -0.4166212 -0.0116318641
## CAN-2013 0.5595505 0.2733303 0.1784177 0.4206315 -0.4186161 -0.0133138811
## MEX-2000 0.6732539 0.2149140 0.1425054 0.2626764 -0.2947699  0.0014201968
## MEX-2002 0.6941089 0.1950519 0.1437490 0.2504522 -0.2809940 -0.0023679789
## MEX-2004 0.6979996 0.2005101 0.1312609 0.2391311 -0.2745519  0.0056501571
## MEX-2006 0.6725003 0.2141908 0.1323524 0.2579798 -0.2801102  0.0030869977
## MEX-2008 0.6508341 0.2298687 0.1536851 0.2416872 -0.2696986 -0.0063766162
## MEX-2010 0.6285632 0.2131835 0.1852762 0.2481539 -0.2698361 -0.0053406847
## MEX-2012 0.6352695 0.2224750 0.1942454 0.2695678 -0.2984421 -0.0231155679
## MEX-2014 0.6356119 0.2104586 0.1932114 0.2715108 -0.2945466 -0.0162459742
##               pl_c      pl_i      pl_g      pl_x      pl_m      pl_k
## CAN-2001 0.6292517 0.5470572 0.8219304 0.5460286 0.5313601 0.6292847
## CAN-2003 0.7315946 0.6319304 0.9613546 0.5810179 0.5726507 0.7568532
## CAN-2005 0.8729587 0.7712987 1.1287004 0.6280424 0.6155325 0.8875628
## CAN-2007 1.0543412 0.9375428 1.3133082 0.6796820 0.6845841 1.0519462
## CAN-2009 1.0351254 0.9200191 1.2657314 0.6898180 0.7204297 1.0221647
## CAN-2011 1.2595756 1.0936318 1.4938417 0.7052622 0.7428895 1.1579119
## CAN-2013 1.2401137 1.1189287 1.5112380 0.7374130 0.7493351 1.1488672
## MEX-2000 0.5336822 0.6412158 0.3865237 0.5290740 0.5086392 0.6657988
## MEX-2002 0.5839284 0.6707015 0.4566301 0.5262772 0.4921273 0.8063704
## MEX-2004 0.5515599 0.6482526 0.4661525 0.5847969 0.5332708 0.7196133
## MEX-2006 0.6152702 0.6849153 0.4958651 0.6264205 0.5910664 0.7278860
## MEX-2008 0.6767916 0.7000160 0.4662665 0.7205961 0.6841487 0.8066145
## MEX-2010 0.6602539 0.6407837 0.3897180 0.7083094 0.6583319 0.6478299
## MEX-2012 0.6784819 0.6640091 0.3903852 0.7425870 0.6709370 0.6141177
## MEX-2014 0.7153954 0.6910835 0.4214644 0.7570050 0.7021390 0.6044782
Datos de México y Canadá (2000-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-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-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-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-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-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-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-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
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.0 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-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 1119252.6 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-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.2 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-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.2 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-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.2 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-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 1405425.9 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-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.2 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-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.4 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_elegir_variables_trade_detail(c("Mexico","Canada"),2000,2014)-> dataframe_2
print(dataframe_2 )%>%
  kable(caption = "Variables de la categoría Trade detail para México y Canadá (2000-2014)",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
##          country year      pl_x      pl_m     csh_x      csh_m
## CAN-2001  Canada 2001 0.5460286 0.5313601 0.4177729 -0.3644541
## CAN-2003  Canada 2003 0.5810179 0.5726507 0.3902732 -0.3496419
## CAN-2005  Canada 2005 0.6280424 0.6155325 0.4328717 -0.3851879
## CAN-2007  Canada 2007 0.6796820 0.6845841 0.4428070 -0.3985552
## CAN-2009  Canada 2009 0.6898180 0.7204297 0.3453314 -0.3370062
## CAN-2011  Canada 2011 0.7052622 0.7428895 0.4387028 -0.4166212
## CAN-2013  Canada 2013 0.7374130 0.7493351 0.4206315 -0.4186161
## MEX-2000  Mexico 2000 0.5290740 0.5086392 0.2626764 -0.2947699
## MEX-2002  Mexico 2002 0.5262772 0.4921273 0.2504522 -0.2809940
## MEX-2004  Mexico 2004 0.5847969 0.5332708 0.2391311 -0.2745519
## MEX-2006  Mexico 2006 0.6264205 0.5910664 0.2579798 -0.2801102
## MEX-2008  Mexico 2008 0.7205961 0.6841487 0.2416872 -0.2696986
## MEX-2010  Mexico 2010 0.7083094 0.6583319 0.2481539 -0.2698361
## MEX-2012  Mexico 2012 0.7425870 0.6709370 0.2695678 -0.2984421
## MEX-2014  Mexico 2014 0.7570050 0.7021390 0.2715108 -0.2945466
Variables de la categoría Trade detail para México y Canadá (2000-2014)
country year pl_x pl_m csh_x csh_m
CAN-2001 Canada 2001 0.55 0.53 0.42 -0.36
CAN-2003 Canada 2003 0.58 0.57 0.39 -0.35
CAN-2005 Canada 2005 0.63 0.62 0.43 -0.39
CAN-2007 Canada 2007 0.68 0.68 0.44 -0.40
CAN-2009 Canada 2009 0.69 0.72 0.35 -0.34
CAN-2011 Canada 2011 0.71 0.74 0.44 -0.42
CAN-2013 Canada 2013 0.74 0.75 0.42 -0.42
MEX-2000 Mexico 2000 0.53 0.51 0.26 -0.29
MEX-2002 Mexico 2002 0.53 0.49 0.25 -0.28
MEX-2004 Mexico 2004 0.58 0.53 0.24 -0.27
MEX-2006 Mexico 2006 0.63 0.59 0.26 -0.28
MEX-2008 Mexico 2008 0.72 0.68 0.24 -0.27
MEX-2010 Mexico 2010 0.71 0.66 0.25 -0.27
MEX-2012 Mexico 2012 0.74 0.67 0.27 -0.30
MEX-2014 Mexico 2014 0.76 0.70 0.27 -0.29

#1-Construya una función que le permita elegir el país y filtrar para un periodo(inicio,final), muestre su uso filtrando los datos para Guatemala , en el periodo de 1990-2014

# construyendo la funcion
options(scipen = 9999)
funcion_elegir_pais_periodo_1 <- function(country,anio_inicio,anio_final) {
  pwt9.0 %>% filter(country==!!country,year>=anio_inicio,year<=anio_final) -> pais_periodo_1
}
# Filtrando todos los datos para El Salvador  1950-2014
funcion_elegir_pais_periodo_1(country = "Guatemala",anio_inicio = 1990,anio_final = 2014) %>%
 kable(caption = " Datos de Guatemala  (1990-2014) ",
 digits = 1,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
Datos de Guatemala (1990-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.6 34222.7 9.2 2.5 NA 1.5 32241.0 35134.4 33063.2 34293.3 45778.6 0.9 0.9 46215.4 41905.3 47471.4 126784.4 1.0 0.9 0.5 0.1 4.5 0.2 0.2 0.2 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.1 0.0 0.2 0.4 0.2 0.5 0.5 0.3
GTM-1991 Guatemala GTM 1991 Quetzal 35438.7 36470.8 9.4 2.6 NA 1.5 33555.4 37250.1 35158.6 36600.2 47208.3 0.9 0.9 47906.0 43432.1 50421.9 129355.2 1.0 0.9 0.5 0.1 5.0 0.2 0.2 0.2 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.1 0.0 0.2 0.4 0.2 0.5 0.5 0.3
GTM-1992 Guatemala GTM 1992 Quetzal 36326.2 37987.7 9.6 2.7 NA 1.5 35497.8 40458.9 35981.5 37812.5 49587.2 0.9 0.9 50223.9 45647.4 54848.9 133586.8 1.0 1.0 0.5 0.1 5.2 0.2 0.3 0.2 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.1 0.0 0.2 0.4 0.2 0.5 0.5 0.4
GTM-1993 Guatemala GTM 1993 Quetzal 38583.3 40375.7 9.9 2.8 NA 1.5 37369.7 42216.4 38180.7 40147.5 53500.3 0.9 0.9 52196.8 47680.4 56266.1 140097.1 1.0 1.0 0.5 0.1 5.6 0.2 0.3 0.3 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.1 0.0 0.3 0.4 0.2 0.5 0.5 0.3
GTM-1994 Guatemala GTM 1994 Quetzal 41145.2 42164.7 10.1 3.0 NA 1.6 39555.8 44458.9 40625.7 42118.2 57302.1 0.8 0.9 54301.9 49909.4 58601.2 144104.8 1.0 0.9 0.5 0.1 5.8 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.1 0.0 0.3 0.4 0.2 0.5 0.5 0.4
GTM-1995 Guatemala GTM 1995 Quetzal 43889.6 45114.5 10.4 3.0 NA 1.6 42208.8 47068.0 43522.3 45290.4 62316.2 0.9 0.9 56981.1 52361.3 60906.5 150601.8 1.0 0.9 0.5 0.1 5.8 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.1 0.0 0.3 0.4 0.2 0.5 0.5 0.3
GTM-1996 Guatemala GTM 1996 Quetzal 45516.4 46279.2 10.6 3.1 NA 1.6 43993.9 48135.5 45269.6 46609.7 66182.5 0.8 0.9 58669.1 53711.6 60829.8 154488.9 1.0 0.9 0.5 0.1 6.0 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.9 0.1 0.1 0.1 -0.1 0.0 0.3 0.5 0.2 0.6 0.5 0.4
GTM-1997 Guatemala GTM 1997 Quetzal 48241.9 48901.3 10.9 3.2 NA 1.6 46064.6 51158.2 47688.0 49022.4 72300.2 0.8 0.8 61235.1 55940.7 64595.6 163422.1 1.0 0.9 0.5 0.1 6.1 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.9 0.1 0.1 0.1 -0.2 0.0 0.3 0.5 0.3 0.5 0.5 0.3
GTM-1998 Guatemala GTM 1998 Quetzal 51417.2 51953.6 11.1 3.3 NA 1.6 48666.8 55740.6 50502.8 52091.2 79881.7 0.8 0.8 64293.3 58718.5 70643.4 172925.6 0.9 1.0 0.5 0.1 6.4 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.2 0.0 0.3 0.5 0.3 0.5 0.5 0.4
GTM-1999 Guatemala GTM 1999 Quetzal 53551.0 54882.2 11.4 3.4 NA 1.6 51127.0 58298.1 52587.8 54994.9 89127.0 0.8 0.8 66766.6 61015.4 72668.6 185427.2 0.9 0.9 0.5 0.1 7.4 0.3 0.3 0.3 interpolated benchmark market no NA 47.8 0.8 0.1 0.1 0.1 -0.2 0.0 0.3 0.4 0.3 0.5 0.5 0.3
GTM-2000 Guatemala GTM 2000 Quetzal 56102.1 57968.2 11.7 3.6 NA 1.7 53538.4 61430.3 55067.0 57636.4 96989.8 0.7 0.7 69175.8 63408.1 75548.2 192628.2 0.9 0.9 0.5 0.1 7.8 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.2 0.0 0.3 0.4 0.3 0.5 0.5 0.3
GTM-2001 Guatemala GTM 2001 Quetzal 58489.1 61418.7 12.0 3.7 NA 1.6 56344.4 65172.1 57608.4 61010.9 103967.5 0.7 0.8 70788.7 65909.3 78846.1 198709.3 0.9 0.9 0.5 0.1 7.9 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.8 0.1 0.1 0.1 -0.2 0.0 0.3 0.4 0.3 0.5 0.5 0.4
GTM-2002 Guatemala GTM 2002 Quetzal 61456.7 63811.9 12.3 3.9 NA 1.6 58545.0 68691.8 60556.7 63553.1 112948.9 0.7 0.8 73525.9 67883.9 81973.3 205983.8 0.9 0.9 0.5 0.1 7.8 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.8 0.2 0.1 0.1 -0.2 0.1 0.3 0.4 0.4 0.5 0.5 0.4
GTM-2003 Guatemala GTM 2003 Quetzal 63583.8 66275.4 12.6 4.0 NA 1.6 61206.7 71559.9 62545.6 66160.8 122840.9 0.7 0.7 75386.6 70127.8 84049.5 212495.2 0.9 0.9 0.5 0.1 7.9 0.3 0.4 0.3 interpolated benchmark market no NA NA 0.8 0.2 0.1 0.1 -0.2 0.0 0.3 0.4 0.4 0.5 0.5 0.4
GTM-2004 Guatemala GTM 2004 Quetzal 66131.6 69108.5 12.9 4.0 NA 1.6 63706.6 74806.2 64977.1 69019.6 136110.9 0.7 0.7 77762.9 72080.1 86489.9 218599.4 0.9 1.0 0.4 0.1 7.9 0.4 0.4 0.3 interpolated benchmark market no NA 81.1 0.8 0.2 0.1 0.1 -0.2 0.1 0.4 0.5 0.4 0.5 0.5 0.4
GTM-2005 Guatemala GTM 2005 Quetzal 68825.3 72399.2 13.2 4.2 NA 1.6 68320.2 79756.3 68791.5 72216.7 153376.9 0.7 0.7 80298.1 74991.0 89195.8 225095.9 0.9 1.0 0.4 0.1 7.6 0.4 0.4 0.4 interpolated benchmark market no NA 78.9 0.9 0.2 0.1 0.1 -0.3 0.0 0.4 0.5 0.4 0.6 0.5 0.4
GTM-2006 Guatemala GTM 2006 Quetzal 73486.2 76669.0 13.5 4.5 NA 1.6 72078.9 85189.2 72839.5 76602.5 173933.1 0.7 0.7 84617.9 78573.3 94445.4 234027.8 0.9 1.0 0.4 0.0 7.6 0.4 0.4 0.4 interpolated benchmark market no NA 80.0 0.9 0.2 0.1 0.1 -0.2 0.0 0.4 0.5 0.4 0.6 0.6 0.4
GTM-2007 Guatemala GTM 2007 Quetzal 79439.3 82025.2 13.8 4.5 NA 1.7 77205.1 91696.3 78528.7 82105.0 192681.0 0.7 0.7 89952.3 83017.8 100097.3 243391.2 1.0 1.0 0.4 0.0 7.7 0.4 0.4 0.4 interpolated benchmark market no NA 78.9 0.9 0.2 0.1 0.1 -0.3 0.0 0.4 0.5 0.4 0.6 0.6 0.4
GTM-2008 Guatemala GTM 2008 Quetzal 83265.5 85980.3 14.1 4.5 NA 1.7 82892.9 95164.7 82976.3 85649.1 209983.8 0.7 0.7 92903.7 87139.7 100861.8 251030.0 1.0 1.0 0.4 0.0 7.6 0.5 0.5 0.5 interpolated benchmark market no NA 82.2 0.9 0.1 0.1 0.1 -0.3 0.0 0.5 0.5 0.5 0.7 0.6 0.4
GTM-2009 Guatemala GTM 2009 Quetzal 87864.5 88414.6 14.4 4.5 NA 1.7 84656.9 95068.2 87094.7 88634.6 223994.4 0.7 0.7 93392.6 88072.6 99219.4 255899.8 1.0 0.9 0.4 0.0 8.2 0.4 0.4 0.4 interpolated benchmark market no NA 85.6 0.9 0.1 0.1 0.1 -0.2 0.0 0.4 0.5 0.4 0.7 0.6 0.4
GTM-2010 Guatemala GTM 2010 Quetzal 92085.6 93170.7 14.7 4.3 NA 1.8 89748.7 101272.5 91646.2 93270.4 241053.6 0.7 0.7 96072.4 91514.5 103506.6 260478.3 1.0 1.0 0.4 0.0 8.1 0.4 0.5 0.4 interpolated benchmark market no NA 85.6 0.9 0.1 0.1 0.1 -0.2 0.0 0.4 0.5 0.4 0.7 0.6 0.4
GTM-2011 Guatemala GTM 2011 Quetzal 98496.6 100070.9 15.0 4.5 NA 1.8 94919.2 109068.4 98496.6 100070.9 266095.2 0.7 0.7 100070.9 94919.2 109068.4 266095.2 1.0 1.0 0.4 0.0 7.8 0.5 0.5 0.5 benchmark benchmark market no 0.6 83.3 0.8 0.1 0.1 0.1 -0.3 0.0 0.5 0.5 0.5 0.7 0.6 0.4
GTM-2012 Guatemala GTM 2012 Quetzal 101200.2 102466.4 15.4 5.1 NA 1.8 98274.9 112493.7 101122.4 101964.9 272282.8 0.7 0.7 103043.0 98167.0 112555.0 272057.2 1.0 1.0 0.4 0.0 7.8 0.5 0.5 0.5 extrapolated benchmark market no NA 80.0 0.9 0.1 0.1 0.1 -0.3 0.0 0.5 0.5 0.5 0.7 0.6 0.4
GTM-2013 Guatemala GTM 2013 Quetzal 104637.7 105246.7 15.7 4.9 NA 1.8 102153.3 115864.6 104280.2 104663.1 281013.8 0.7 0.7 106852.9 101996.6 116153.3 277956.6 1.0 1.0 0.4 0.0 7.9 0.5 0.5 0.5 extrapolated benchmark market no NA 76.7 0.9 0.1 0.1 0.1 -0.3 0.0 0.5 0.6 0.5 0.7 0.6 0.4
GTM-2014 Guatemala GTM 2014 Quetzal 109715.6 110703.2 16.0 5.0 NA 1.8 106532.5 120539.6 109468.7 110100.0 292397.5 0.7 0.7 111393.9 106132.7 120700.0 284343.5 1.0 1.0 0.4 0.0 7.7 0.5 0.5 0.5 extrapolated benchmark market no NA 68.9 0.9 0.1 0.1 0.1 -0.3 0.0 0.5 0.6 0.5 0.7 0.6 0.4

#2- Construya una función que le permita elegir todas las variables de la categoría “Labor detail”, muestre su uso para los datos de Argentina

funcion_elegir_variables_labor_detail <- function(country,anio_inicio,anio_final) {
 pwt9.0 %>% filter(country==!!country,year>=anio_inicio,year<=anio_final) %>%
 select(country,year,emp, avh, hc, labsh)-> pais_periodo_1
  pais_periodo_1
}
funcion_elegir_variables_labor_detail(country = "Argentina",anio_inicio= 1950,anio_final = 2014) %>%
 kable(caption = "Variables de la categoría Labor detail para Argentina (1990-2014)",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
Variables de la categoría Labor detail para Argentina (1990-2014)
country year emp avh hc labsh
ARG-1950 Argentina 1950 6.55 2034.00 1.82 0.53
ARG-1951 Argentina 1951 6.65 2037.87 1.83 0.53
ARG-1952 Argentina 1952 6.76 2041.74 1.85 0.53
ARG-1953 Argentina 1953 6.86 2045.62 1.86 0.53
ARG-1954 Argentina 1954 6.97 2049.51 1.87 0.53
ARG-1955 Argentina 1955 7.08 2053.41 1.89 0.53
ARG-1956 Argentina 1956 7.18 2057.31 1.90 0.53
ARG-1957 Argentina 1957 7.27 2061.22 1.91 0.53
ARG-1958 Argentina 1958 7.37 2065.14 1.93 0.53
ARG-1959 Argentina 1959 7.47 2069.07 1.94 0.53
ARG-1960 Argentina 1960 7.57 2073.00 1.95 0.53
ARG-1961 Argentina 1961 7.67 2066.20 1.96 0.53
ARG-1962 Argentina 1962 7.76 2059.42 1.98 0.53
ARG-1963 Argentina 1963 7.86 2052.67 1.99 0.53
ARG-1964 Argentina 1964 7.96 2045.94 2.00 0.53
ARG-1965 Argentina 1965 8.06 2039.22 2.01 0.53
ARG-1966 Argentina 1966 8.16 2032.54 2.02 0.53
ARG-1967 Argentina 1967 8.26 2025.87 2.04 0.53
ARG-1968 Argentina 1968 8.36 2019.22 2.05 0.53
ARG-1969 Argentina 1969 8.47 2012.60 2.06 0.53
ARG-1970 Argentina 1970 8.57 2006.00 2.08 0.53
ARG-1971 Argentina 1971 8.65 2002.66 2.10 0.53
ARG-1972 Argentina 1972 8.73 1999.33 2.12 0.53
ARG-1973 Argentina 1973 8.82 1996.00 2.14 0.53
ARG-1974 Argentina 1974 9.14 1992.84 2.16 0.53
ARG-1975 Argentina 1975 9.19 1989.69 2.18 0.53
ARG-1976 Argentina 1976 9.18 1986.54 2.20 0.53
ARG-1977 Argentina 1977 9.41 1983.40 2.21 0.53
ARG-1978 Argentina 1978 9.48 1980.26 2.22 0.53
ARG-1979 Argentina 1979 9.63 1977.13 2.24 0.53
ARG-1980 Argentina 1980 9.64 1974.00 2.25 0.53
ARG-1981 Argentina 1981 9.65 1961.23 2.28 0.53
ARG-1982 Argentina 1982 9.80 1948.54 2.32 0.53
ARG-1983 Argentina 1983 10.10 1935.94 2.35 0.53
ARG-1984 Argentina 1984 10.35 1923.41 2.39 0.53
ARG-1985 Argentina 1985 10.43 1910.97 2.42 0.53
ARG-1986 Argentina 1986 10.74 1898.61 2.44 0.53
ARG-1987 Argentina 1987 10.96 1886.33 2.46 0.53
ARG-1988 Argentina 1988 11.18 1874.12 2.49 0.53
ARG-1989 Argentina 1989 11.28 1862.00 2.51 0.53
ARG-1990 Argentina 1990 11.59 1850.00 2.53 0.53
ARG-1991 Argentina 1991 11.95 1837.96 2.55 0.53
ARG-1992 Argentina 1992 12.15 1826.00 2.57 0.53
ARG-1993 Argentina 1993 12.07 1850.34 2.59 0.53
ARG-1994 Argentina 1994 12.08 1875.00 2.60 0.52
ARG-1995 Argentina 1995 11.51 1897.22 2.62 0.47
ARG-1996 Argentina 1996 11.79 1846.07 2.63 0.44
ARG-1997 Argentina 1997 12.36 1917.29 2.63 0.42
ARG-1998 Argentina 1998 12.90 1903.00 2.64 0.43
ARG-1999 Argentina 1999 12.96 1893.25 2.65 0.46
ARG-2000 Argentina 2000 13.09 1861.00 2.66 0.46
ARG-2001 Argentina 2001 13.05 1803.42 2.68 0.47
ARG-2002 Argentina 2002 13.01 1610.57 2.71 0.37
ARG-2003 Argentina 2003 13.73 1719.39 2.74 0.36
ARG-2004 Argentina 2004 14.67 1739.67 2.76 0.38
ARG-2005 Argentina 2005 15.34 1755.35 2.79 0.40
ARG-2006 Argentina 2006 15.86 1809.43 2.80 0.43
ARG-2007 Argentina 2007 16.44 1816.90 2.81 0.43
ARG-2008 Argentina 2008 16.84 1835.88 2.81 0.43
ARG-2009 Argentina 2009 16.99 1736.91 2.82 0.43
ARG-2010 Argentina 2010 17.49 1728.73 2.83 0.43
ARG-2011 Argentina 2011 17.88 1762.29 2.86 0.43
ARG-2012 Argentina 2012 18.07 1788.99 2.89 0.43
ARG-2013 Argentina 2013 18.26 1776.66 2.92 0.43
ARG-2014 Argentina 2014 18.10 1776.66 2.95 0.43

#3- Use las funciones creadas en 1 y 2, para generar 2 dataframes, que muestren los datos de “EE.UU” y “Canadá” para el periodo 2000-2014

funcion_elegir_pais_periodo(c("United States of America","Canada"),2000,2014)-> dataframe_3 
print(dataframe_3) %>% 
  kable(caption = "Datos de Estados Unidos y Canadá (2000-2014)",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
##                           country isocode year        currency    rgdpe
## CAN-2001                   Canada     CAN 2001 Canadian Dollar  1166188
## CAN-2003                   Canada     CAN 2003 Canadian Dollar  1211094
## CAN-2005                   Canada     CAN 2005 Canadian Dollar  1311424
## CAN-2007                   Canada     CAN 2007 Canadian Dollar  1376870
## CAN-2009                   Canada     CAN 2009 Canadian Dollar  1310934
## CAN-2011                   Canada     CAN 2011 Canadian Dollar  1423920
## CAN-2013                   Canada     CAN 2013 Canadian Dollar  1478439
## USA-2000 United States of America     USA 2000       US Dollar 13222419
## USA-2002 United States of America     USA 2002       US Dollar 13591523
## USA-2004 United States of America     USA 2004       US Dollar 14499944
## USA-2006 United States of America     USA 2006       US Dollar 15353601
## USA-2008 United States of America     USA 2008       US Dollar 15357469
## USA-2010 United States of America     USA 2010       US Dollar 15368666
## USA-2012 United States of America     USA 2012       US Dollar 15976742
## USA-2014 United States of America     USA 2014       US Dollar 16704698
##             rgdpo       pop       emp      avh       hc       ccon      cda
## CAN-2001  1119308  30.99134  15.05903 1767.990 3.518916   814203.9  1079932
## CAN-2003  1184269  31.59659  15.84749 1732.136 3.548723   858441.9  1148489
## CAN-2005  1323181  32.25633  16.43793 1739.182 3.578782   918976.9  1263380
## CAN-2007  1384391  32.98228  17.26695 1724.689 3.609095   969776.7  1342214
## CAN-2009  1304883  33.74656  17.43560 1678.515 3.639666  1000717.9  1325223
## CAN-2011  1455816  34.49990  18.07691 1683.574 3.662325  1045868.8  1440603
## CAN-2013  1493624  35.23061  18.66565 1682.736 3.676923  1086339.8  1488701
## USA-2000 13031820 282.89574 139.29607 1848.147 3.578583  9977582.0 13511612
## USA-2002 13309916 288.47085 139.08432 1805.477 3.598119 10524779.0 14027745
## USA-2004 14204685 293.53089 141.63098 1783.413 3.617761 11251801.0 15090846
## USA-2006 15083465 298.86052 146.61525 1778.528 3.642329 12126527.0 16170304
## USA-2008 15305872 304.47314 147.52623 1761.316 3.671921 12569281.0 16125585
## USA-2010 15250698 309.87617 141.34911 1738.001 3.701753 12764841.0 15842214
## USA-2012 15899255 314.79946 144.86284 1753.699 3.712276 13206454.0 16505245
## USA-2014 16598099 319.44863 148.46339 1764.597 3.722829 13685949.0 17113208
##             cgdpe    cgdpo       ck      ctfp     cwtfp   rgdpna     rconna
## CAN-2001  1145022  1144414  3268334 0.9022754 0.8153173  1190649   782785.5
## CAN-2003  1194611  1200543  3349291 0.8915871 0.8093318  1247575   832796.8
## CAN-2005  1315081  1326233  3865556 0.9038564 0.7981808  1327435   882079.1
## CAN-2007  1370408  1395106  4445640 0.8834894 0.8020070  1389595   950916.3
## CAN-2009  1306457  1323073  4794360 0.8118237 0.7897093  1367808   994270.1
## CAN-2011  1423920  1455816  5427466 0.8070218 0.7662106  1455816  1045868.8
## CAN-2013  1465085  1472069  5828469 0.7754062 0.7574083  1513537  1084256.5
## USA-2000 13035321 12983206 35997032 1.0000000 1.0000000 12975535 10500206.0
## USA-2002 13503168 13339370 38467564 1.0000000 1.0000000 13336194 11088529.0
## USA-2004 14366189 14232334 42071616 1.0000000 1.0000000 14229557 11796878.0
## USA-2006 15318001 15099868 47891040 1.0000000 1.0000000 15097712 12476968.0
## USA-2008 15370500 15321926 50006724 1.0000000 1.0000000 15321422 12759836.0
## USA-2010 15317448 15273702 48876336 1.0000000 1.0000000 15273331 12883714.0
## USA-2012 15946878 15863845 50020716 1.0000000 1.0000000 15863049 13182059.0
## USA-2014 16605887 16490883 52849892 1.0000000 1.0000000 16490192 13585164.0
##             rdana     rkna    rtfpna   rwtfpna     labsh      delta        xr
## CAN-2001  1041029  3905941 1.0337603 0.9134005 0.6171623 0.04350585 1.5487608
## CAN-2003  1119539  4151862 1.0330168 0.9367892 0.6124471 0.04180438 1.4010517
## CAN-2005  1221829  4462552 1.0369463 0.9645296 0.5987505 0.04020973 1.2117633
## CAN-2007  1319552  4812567 1.0226208 0.9813300 0.6059821 0.03873762 1.0740992
## CAN-2009  1323141  5106391 0.9890912 0.9668959 0.6315947 0.03881708 1.1431006
## CAN-2011  1440603  5427466 1.0000000 1.0000000 0.6074459 0.03708802 0.9895307
## CAN-2013  1500049  5779532 0.9928653 0.9944088 0.6191180 0.03645137 1.0297966
## USA-2000 13647352 38439588 0.9205835 0.9289908 0.6426795 0.05212035 1.0000000
## USA-2002 14123900 40679832 0.9388351 0.9539754 0.6347357 0.05012728 1.0000000
## USA-2004 15181932 43024076 0.9741488 0.9972088 0.6222099 0.04774661 1.0000000
## USA-2006 16121374 45671956 0.9863822 1.0105580 0.6123036 0.04556167 1.0000000
## USA-2008 16086510 47779436 0.9808996 0.9881262 0.6150548 0.04627780 1.0000000
## USA-2010 15924426 48728140 0.9990609 0.9994178 0.5952319 0.04710827 1.0000000
## USA-2012 16509182 49960600 1.0051460 1.0036752 0.6020187 0.04788478 1.0000000
## USA-2014 17137356 51190644 1.0141082 1.0111778 0.6035975 0.04704589 1.0000000
##             pl_con     pl_da   pl_gdpo        i_cig      i_xm   i_xr i_outlier
## CAN-2001 0.6702421 0.6399313 0.6402714 interpolated benchmark market        no
## CAN-2003 0.7807368 0.7431563 0.7394839 interpolated benchmark market        no
## CAN-2005 0.9279599 0.8852534 0.8778094    benchmark benchmark market        no
## CAN-2007 1.1123220 1.0638244 1.0449910 interpolated benchmark market        no
## CAN-2009 1.0911957 1.0492800 1.0361022 interpolated benchmark market        no
## CAN-2011 1.3175685 1.2562085 1.2286866    benchmark benchmark market        no
## CAN-2013 1.3056631 1.2551931 1.2492380 extrapolated benchmark market        no
## USA-2000 0.8255066 0.7889932 0.7921603 interpolated benchmark market        no
## USA-2002 0.8584893 0.8129588 0.8229414    benchmark benchmark market        no
## USA-2004 0.9002079 0.8544319 0.8624678 interpolated benchmark market        no
## USA-2006 0.9395798 0.9045495 0.9176166 interpolated benchmark market        no
## USA-2008 0.9851168 0.9575869 0.9606227 interpolated benchmark market        no
## USA-2010 0.9968326 0.9769499 0.9797481 interpolated benchmark market        no
## USA-2012 1.0294040 1.0130669 1.0183694 extrapolated benchmark market        no
## USA-2014 1.0537966 1.0446941 1.0519795 extrapolated benchmark market        no
##            cor_exp statcap     csh_c     csh_i      csh_g      csh_x      csh_m
## CAN-2001        NA      NA 0.5601038 0.2321958 0.15135552 0.41777286 -0.3644541
## CAN-2003        NA      NA 0.5621071 0.2415964 0.15293744 0.39027315 -0.3496419
## CAN-2005 0.9038276      NA 0.5438991 0.2596853 0.14902379 0.43287170 -0.3851879
## CAN-2007        NA      NA 0.5394937 0.2669595 0.15563411 0.44280696 -0.3985552
## CAN-2009        NA      NA 0.5724548 0.2452664 0.18390381 0.34533143 -0.3370062
## CAN-2011 0.8238315      NA 0.5405646 0.2711428 0.17784286 0.43870276 -0.4166212
## CAN-2013        NA      NA 0.5595505 0.2733303 0.17841771 0.42063153 -0.4186161
## USA-2000        NA      NA 0.6758358 0.2722001 0.09266327 0.10603466 -0.1566473
## USA-2002        NA      NA 0.6889258 0.2626036 0.10007539 0.09348762 -0.1526167
## USA-2004        NA      NA 0.6870325 0.2697411 0.10354772 0.09122263 -0.1587287
## USA-2006        NA      NA 0.6949668 0.2678021 0.10812150 0.10488261 -0.1837855
## USA-2008        NA      NA 0.7019295 0.2321056 0.11841653 0.11299946 -0.1750899
## USA-2010        NA      NA 0.7068287 0.2014818 0.12891109 0.11498131 -0.1603202
## USA-2012        NA      NA 0.7113655 0.2079439 0.12112205 0.12747377 -0.1780486
## USA-2014        NA      NA 0.7167840 0.2078275 0.11312606 0.12769014 -0.1767433
##                  csh_r      pl_c      pl_i      pl_g      pl_x      pl_m
## CAN-2001  0.0030260538 0.6292517 0.5470572 0.8219304 0.5460286 0.5313601
## CAN-2003  0.0027277917 0.7315946 0.6319304 0.9613546 0.5810179 0.5726507
## CAN-2005 -0.0002920294 0.8729587 0.7712987 1.1287004 0.6280424 0.6155325
## CAN-2007 -0.0063390261 1.0543412 0.9375428 1.3133082 0.6796820 0.6845841
## CAN-2009 -0.0099502383 1.0351254 0.9200191 1.2657314 0.6898180 0.7204297
## CAN-2011 -0.0116318641 1.2595756 1.0936318 1.4938417 0.7052622 0.7428895
## CAN-2013 -0.0133138811 1.2401137 1.1189287 1.5112380 0.7374130 0.7493351
## USA-2000  0.0099134836 0.7741043 0.6859053 1.2004077 0.5668258 0.6185908
## USA-2002  0.0075242864 0.8035018 0.6761612 1.2370269 0.5558824 0.5905658
## USA-2004  0.0071848887 0.8447491 0.7202677 1.2681735 0.6299770 0.6751730
## USA-2006  0.0080124773 0.8866088 0.7995001 1.2800587 0.6548091 0.6914976
## USA-2008  0.0096388310 0.9310760 0.8602863 1.3054508 0.7507930 0.8069550
## USA-2010  0.0081172762 0.9450076 0.8944773 1.2809926 0.7277685 0.7809259
## USA-2012  0.0101433368 0.9792322 0.9476624 1.3240701 0.7639757 0.8052509
## USA-2014  0.0113156438 1.0038527 1.0083452 1.3702492 0.7692084 0.8049124
##               pl_k
## CAN-2001 0.6292847
## CAN-2003 0.7568532
## CAN-2005 0.8875628
## CAN-2007 1.0519462
## CAN-2009 1.0221647
## CAN-2011 1.1579119
## CAN-2013 1.1488672
## USA-2000 0.7926286
## USA-2002 0.8231374
## USA-2004 0.8626361
## USA-2006 0.9177476
## USA-2008 0.9606543
## USA-2010 0.9797719
## USA-2012 1.0184206
## USA-2014 1.0520236
Datos de Estados Unidos y Canadá (2000-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-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-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-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-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-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-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-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
USA-2000 United States of America USA 2000 US Dollar 13222419 13031820 282.90 139.30 1848.15 3.58 9977582.0 13511612 13035321 12983206 35997032 1.00 1.00 12975535 10500206.0 13647352 38439588 0.92 0.93 0.64 0.05 1.00 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-2002 United States of America USA 2002 US Dollar 13591523 13309916 288.47 139.08 1805.48 3.60 10524779.0 14027745 13503168 13339370 38467564 1.00 1.00 13336194 11088529.0 14123900 40679832 0.94 0.95 0.63 0.05 1.00 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-2004 United States of America USA 2004 US Dollar 14499944 14204685 293.53 141.63 1783.41 3.62 11251801.0 15090846 14366189 14232334 42071616 1.00 1.00 14229557 11796878.0 15181932 43024076 0.97 1.00 0.62 0.05 1.00 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-2006 United States of America USA 2006 US Dollar 15353601 15083465 298.86 146.62 1778.53 3.64 12126527.0 16170304 15318001 15099868 47891040 1.00 1.00 15097712 12476968.0 16121374 45671956 0.99 1.01 0.61 0.05 1.00 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-2008 United States of America USA 2008 US Dollar 15357469 15305872 304.47 147.53 1761.32 3.67 12569281.0 16125585 15370500 15321926 50006724 1.00 1.00 15321422 12759836.0 16086510 47779436 0.98 0.99 0.62 0.05 1.00 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-2010 United States of America USA 2010 US Dollar 15368666 15250698 309.88 141.35 1738.00 3.70 12764841.0 15842214 15317448 15273702 48876336 1.00 1.00 15273331 12883714.0 15924426 48728140 1.00 1.00 0.60 0.05 1.00 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-2012 United States of America USA 2012 US Dollar 15976742 15899255 314.80 144.86 1753.70 3.71 13206454.0 16505245 15946878 15863845 50020716 1.00 1.00 15863049 13182059.0 16509182 49960600 1.01 1.00 0.60 0.05 1.00 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-2014 United States of America USA 2014 US Dollar 16704698 16598099 319.45 148.46 1764.60 3.72 13685949.0 17113208 16605887 16490883 52849892 1.00 1.00 16490192 13585164.0 17137356 51190644 1.01 1.01 0.60 0.05 1.00 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_variables_labor_detail(c("United States of America","Canada"),2000,2014)-> dataframe_4
print(dataframe_4) %>%
  kable(caption = "Variables de la categoría Labor Detail para Estados Unidos y Canadá (2000-2014)",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
##                           country year       emp      avh       hc     labsh
## CAN-2001                   Canada 2001  15.05903 1767.990 3.518916 0.6171623
## CAN-2003                   Canada 2003  15.84749 1732.136 3.548723 0.6124471
## CAN-2005                   Canada 2005  16.43793 1739.182 3.578782 0.5987505
## CAN-2007                   Canada 2007  17.26695 1724.689 3.609095 0.6059821
## CAN-2009                   Canada 2009  17.43560 1678.515 3.639666 0.6315947
## CAN-2011                   Canada 2011  18.07691 1683.574 3.662325 0.6074459
## CAN-2013                   Canada 2013  18.66565 1682.736 3.676923 0.6191180
## USA-2000 United States of America 2000 139.29607 1848.147 3.578583 0.6426795
## USA-2002 United States of America 2002 139.08432 1805.477 3.598119 0.6347357
## USA-2004 United States of America 2004 141.63098 1783.413 3.617761 0.6222099
## USA-2006 United States of America 2006 146.61525 1778.528 3.642329 0.6123036
## USA-2008 United States of America 2008 147.52623 1761.316 3.671921 0.6150548
## USA-2010 United States of America 2010 141.34911 1738.001 3.701753 0.5952319
## USA-2012 United States of America 2012 144.86284 1753.699 3.712276 0.6020187
## USA-2014 United States of America 2014 148.46339 1764.597 3.722829 0.6035975
Variables de la categoría Labor Detail para Estados Unidos y Canadá (2000-2014)
country year emp avh hc labsh
CAN-2001 Canada 2001 15.06 1767.99 3.52 0.62
CAN-2003 Canada 2003 15.85 1732.14 3.55 0.61
CAN-2005 Canada 2005 16.44 1739.18 3.58 0.60
CAN-2007 Canada 2007 17.27 1724.69 3.61 0.61
CAN-2009 Canada 2009 17.44 1678.52 3.64 0.63
CAN-2011 Canada 2011 18.08 1683.57 3.66 0.61
CAN-2013 Canada 2013 18.67 1682.74 3.68 0.62
USA-2000 United States of America 2000 139.30 1848.15 3.58 0.64
USA-2002 United States of America 2002 139.08 1805.48 3.60 0.63
USA-2004 United States of America 2004 141.63 1783.41 3.62 0.62
USA-2006 United States of America 2006 146.62 1778.53 3.64 0.61
USA-2008 United States of America 2008 147.53 1761.32 3.67 0.62
USA-2010 United States of America 2010 141.35 1738.00 3.70 0.60
USA-2012 United States of America 2012 144.86 1753.70 3.71 0.60
USA-2014 United States of America 2014 148.46 1764.60 3.72 0.60

#1- Construya una función que le permita elegir el país y filtrar para un periodo(inicio,final), muestre su uso filtrando los datos para Honduras, en el periodo de 1990-2014.

# construyendo la funcion
options(scipen = 9999)
funcion_elegir_pais_periodo_1 <- function(country,anio_inicio,anio_final) {
  pwt9.0 %>% filter(country==!!country,year>=anio_inicio,year<=anio_final) -> pais_periodo_1
}
# Filtrando todos los datos para El Salvador  1950-2014
funcion_elegir_pais_periodo_1(country = "Honduras",anio_inicio = 1990,anio_final = 2014) %>%
 kable(caption = " Datos de  Honduras (1990-2014) ",
 digits = 1,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
Datos de Honduras (1990-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.7 14480.0 4.9 1.2 NA 1.8 12349.6 14292.9 14019.5 14777.8 24019.2 0.6 0.6 15670.5 14036.9 16844.1 46727.6 1.2 1.2 0.6 0.0 4.1 0.2 0.3 0.2 interpolated benchmark market no NA NA 0.7 0.1 0.1 0.1 -0.1 0.1 0.2 0.4 0.3 0.5 0.5 0.4
HND-1991 Honduras HND 1991 Lempira 14668.8 15217.2 5.0 1.5 NA 1.8 12721.9 15095.5 14801.8 15593.7 24835.8 0.6 0.5 16180.1 14378.0 17783.9 48069.2 1.1 1.0 0.6 0.0 5.3 0.2 0.2 0.2 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.1 0.1 0.2 0.4 0.3 0.5 0.5 0.4
HND-1992 Honduras HND 1992 Lempira 15327.7 15702.4 5.2 1.7 NA 1.8 13162.2 15913.1 15452.5 15956.8 26166.6 0.5 0.5 17090.1 14913.3 18787.8 50292.8 1.1 1.0 0.6 0.0 5.5 0.2 0.3 0.3 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.1 0.0 0.2 0.4 0.3 0.5 0.5 0.4
HND-1993 Honduras HND 1993 Lempira 15933.6 17007.8 5.3 1.7 NA 1.8 13556.2 17219.0 16058.7 17298.6 28826.0 0.5 0.5 18154.8 15235.9 20400.8 53997.6 1.1 1.1 0.6 0.1 6.5 0.2 0.3 0.2 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.2 0.1 0.2 0.4 0.3 0.5 0.5 0.4
HND-1994 Honduras HND 1994 Lempira 16221.7 17431.8 5.5 1.8 NA 1.8 13626.8 17519.9 16247.2 17766.1 31566.0 0.5 0.5 17918.2 15181.7 20793.2 57416.0 1.0 1.0 0.6 0.1 8.4 0.2 0.3 0.2 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.2 0.1 0.2 0.4 0.3 0.5 0.5 0.3
HND-1995 Honduras HND 1995 Lempira 17476.4 19391.9 5.6 1.8 NA 1.8 13971.4 17967.3 17503.1 19796.2 33959.8 0.5 0.5 18649.3 15343.4 21133.8 59647.0 1.0 1.0 0.6 0.1 9.5 0.2 0.3 0.2 interpolated benchmark market no NA NA 0.6 0.2 0.1 0.1 -0.2 0.2 0.2 0.3 0.4 0.5 0.5 0.4
HND-1996 Honduras HND 1996 Lempira 17991.7 18534.6 5.7 2.0 NA 1.8 14862.3 18612.0 17993.6 18919.2 36097.2 0.5 0.5 19316.6 16146.4 21565.4 62041.0 1.0 1.0 0.6 0.1 11.7 0.2 0.3 0.3 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.2 0.1 0.2 0.4 0.4 0.6 0.5 0.4
HND-1997 Honduras HND 1997 Lempira 18783.4 19283.0 5.9 2.1 NA 1.8 15261.0 19375.8 18662.3 19602.3 38920.0 0.5 0.4 20281.2 16564.7 22439.0 65095.4 1.0 0.9 0.6 0.1 13.0 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.2 0.1 0.3 0.4 0.4 0.5 0.5 0.4
HND-1998 Honduras HND 1998 Lempira 19437.3 19877.3 6.0 2.1 NA 1.9 16084.1 20327.3 19169.8 20236.4 42338.4 0.4 0.4 20869.7 17542.5 23514.3 68522.9 1.0 0.9 0.6 0.1 13.4 0.3 0.3 0.3 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.2 -0.3 0.1 0.3 0.4 0.5 0.5 0.5 0.4
HND-1999 Honduras HND 1999 Lempira 18722.7 19555.4 6.1 2.3 NA 1.9 16175.8 20880.7 18457.6 19883.2 46072.1 0.4 0.4 20475.4 17648.5 24128.7 72088.2 0.9 0.9 0.6 0.1 14.2 0.3 0.4 0.3 interpolated benchmark market no NA 60.6 0.7 0.2 0.1 0.1 -0.3 0.1 0.3 0.4 0.5 0.5 0.5 0.4
HND-2000 Honduras HND 2000 Lempira 20014.3 21004.3 6.2 2.3 NA 1.9 17440.5 22230.8 19769.9 21097.9 49552.6 0.4 0.4 21652.3 19076.1 25351.3 74802.0 0.9 0.9 0.6 0.1 14.8 0.3 0.4 0.3 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.2 0.1 0.3 0.4 0.5 0.5 0.5 0.4
HND-2001 Honduras HND 2001 Lempira 20637.6 21337.6 6.4 2.3 NA 1.9 18379.9 23177.1 20478.2 21473.4 52978.8 0.4 0.4 22242.0 19999.8 26028.0 77193.2 0.9 0.9 0.6 0.1 15.5 0.4 0.4 0.4 interpolated benchmark market no NA NA 0.8 0.2 0.1 0.1 -0.3 0.0 0.3 0.4 0.5 0.4 0.5 0.4
HND-2002 Honduras HND 2002 Lempira 21429.9 22322.8 6.5 2.3 NA 1.9 19132.1 23977.6 21306.5 22633.9 56023.2 0.4 0.4 23077.0 20740.8 26554.2 79013.1 1.0 1.0 0.6 0.1 16.4 0.4 0.4 0.3 interpolated benchmark market no NA NA 0.8 0.2 0.1 0.1 -0.3 0.1 0.3 0.4 0.6 0.5 0.5 0.4
HND-2003 Honduras HND 2003 Lempira 22293.7 23442.7 6.6 2.4 NA 1.9 20103.3 25232.9 22122.4 23866.7 59671.4 0.4 0.4 24126.3 21693.0 27731.2 81101.3 1.0 1.0 0.6 0.1 17.3 0.4 0.4 0.3 interpolated benchmark market no NA NA 0.7 0.2 0.1 0.1 -0.3 0.1 0.3 0.4 0.5 0.5 0.5 0.4
HND-2004 Honduras HND 2004 Lempira 23503.4 24886.9 6.8 2.4 NA 2.0 21223.1 27632.3 23295.6 25364.9 65749.5 0.4 0.4 25629.9 22787.2 30171.7 84672.6 1.0 1.0 0.6 0.1 18.2 0.4 0.4 0.3 interpolated benchmark market no NA 63.9 0.7 0.3 0.1 0.1 -0.3 0.1 0.3 0.4 0.6 0.5 0.5 0.4
HND-2005 Honduras HND 2005 Lempira 24863.1 27339.3 6.9 2.5 NA 2.0 23171.7 29687.9 25057.7 27758.7 72955.4 0.4 0.4 27180.8 24338.4 31628.4 87856.1 1.0 1.0 0.6 0.1 18.8 0.4 0.4 0.4 interpolated benchmark market no NA 63.3 0.7 0.2 0.1 0.1 -0.3 0.1 0.4 0.4 0.5 0.5 0.5 0.4
HND-2006 Honduras HND 2006 Lempira 26591.9 28317.3 7.0 2.6 NA 2.0 25053.5 32155.2 26569.6 28826.4 81215.1 0.4 0.4 28965.8 26253.9 34069.2 91934.2 1.0 1.0 0.6 0.1 18.9 0.4 0.4 0.4 interpolated benchmark market no NA 63.3 0.8 0.2 0.1 0.1 -0.3 0.1 0.4 0.4 0.6 0.6 0.6 0.4
HND-2007 Honduras HND 2007 Lempira 28196.9 30212.6 7.1 2.8 NA 2.0 26953.7 35926.3 28055.9 30818.3 89601.1 0.4 0.4 30758.2 28137.4 37910.0 98000.6 1.0 1.1 0.6 0.1 18.9 0.4 0.4 0.4 interpolated benchmark market no NA 70.0 0.8 0.3 0.1 0.1 -0.3 0.1 0.4 0.5 0.6 0.6 0.6 0.4
HND-2008 Honduras HND 2008 Lempira 28689.7 29158.4 7.3 2.8 NA 2.0 28240.2 38256.5 28743.0 29235.6 97798.8 0.4 0.4 32059.9 29045.7 39696.9 104314.8 1.1 1.1 0.6 0.1 18.9 0.5 0.5 0.5 interpolated benchmark market no NA 73.3 0.8 0.3 0.1 0.3 -0.5 -0.1 0.5 0.5 0.7 0.7 0.7 0.4
HND-2009 Honduras HND 2009 Lempira 29242.9 29286.4 7.4 2.9 NA 2.0 28587.6 34253.8 29066.9 29677.8 100695.9 0.3 0.4 31280.2 29424.5 35252.2 105943.4 1.0 1.0 0.6 0.1 18.9 0.5 0.5 0.5 interpolated benchmark market no NA 77.8 0.8 0.2 0.1 0.1 -0.3 0.0 0.5 0.5 0.7 0.7 0.6 0.4
HND-2010 Honduras HND 2010 Lempira 30846.4 31120.9 7.5 2.9 NA 2.1 29819.8 36243.6 30734.7 31326.9 104274.6 0.3 0.4 32447.4 30233.1 36788.3 107767.7 1.0 1.0 0.6 0.1 18.9 0.5 0.5 0.5 interpolated benchmark market no NA 77.8 0.8 0.2 0.1 0.1 -0.4 0.1 0.5 0.5 0.7 0.7 0.6 0.4
HND-2011 Honduras HND 2011 Lempira 32806.5 33691.9 7.6 3.1 NA 2.1 31070.4 39269.9 32806.5 33691.9 110959.4 0.3 0.4 33691.9 31070.4 39269.9 110959.4 1.0 1.0 0.6 0.1 18.9 0.5 0.5 0.5 benchmark benchmark market no 0.6 77.8 0.8 0.2 0.1 0.1 -0.4 0.1 0.5 0.6 0.7 0.7 0.6 0.5
HND-2012 Honduras HND 2012 Lempira 33773.0 34602.0 7.7 3.2 NA 2.1 32356.3 40233.3 33701.1 34306.4 114260.5 0.3 0.4 35083.0 32295.1 40251.7 114391.2 1.0 1.0 0.6 0.1 19.5 0.5 0.5 0.5 extrapolated benchmark market no NA 76.0 0.8 0.2 0.1 0.2 -0.4 0.0 0.5 0.6 0.8 0.7 0.7 0.5
HND-2013 Honduras HND 2013 Lempira 33759.9 33670.3 7.8 3.3 NA 2.2 33565.7 40386.9 33537.5 33307.6 118671.2 0.3 0.4 36062.3 33478.7 40477.3 117494.7 1.0 0.9 0.6 0.1 20.3 0.5 0.6 0.6 extrapolated benchmark market no NA 62.2 0.9 0.2 0.1 0.3 -0.4 -0.1 0.5 0.6 0.8 0.7 0.6 0.4
HND-2014 Honduras HND 2014 Lempira 35219.2 34835.7 8.0 3.4 NA 2.2 34384.1 41614.7 35008.4 34377.6 123703.3 0.3 0.4 37174.9 34161.5 41649.4 120378.6 1.0 0.9 0.6 0.1 21.0 0.5 0.6 0.6 extrapolated benchmark market no NA 73.3 0.9 0.2 0.1 0.3 -0.5 -0.1 0.5 0.6 0.8 0.7 0.6 0.4

#2- Construya una función que le permita elegir todas las variables de la categoría “Capital detail”, muestre su uso para los datos de Panamá

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

funcion_elegir_pais_periodo_1(c("United States of America","United Kingdom"),1990,2000)-> dataframe_5
print(dataframe_5)%>%
  kable(caption = "Datos de Estados Unidos y Reino Unido (1990-2000)",
 digits = 2,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
##                           country isocode year       currency    rgdpe    rgdpo
## GBR-1990           United Kingdom     GBR 1990 Pound Sterling  1417085  1385562
## GBR-1992           United Kingdom     GBR 1992 Pound Sterling  1414993  1376120
## GBR-1994           United Kingdom     GBR 1994 Pound Sterling  1519652  1478347
## GBR-1996           United Kingdom     GBR 1996 Pound Sterling  1674593  1641439
## GBR-1998           United Kingdom     GBR 1998 Pound Sterling  1888442  1813215
## GBR-2000           United Kingdom     GBR 2000 Pound Sterling  2088803  2024305
## USA-1990 United States of America     USA 1990      US Dollar  9203227  9203558
## USA-1992 United States of America     USA 1992      US Dollar  9530917  9509170
## USA-1994 United States of America     USA 1994      US Dollar 10262589 10205495
## USA-1996 United States of America     USA 1996      US Dollar 10988194 10926444
## USA-1998 United States of America     USA 1998      US Dollar 12132393 11956923
## USA-2000 United States of America     USA 2000      US Dollar 13222419 13031820
##                pop       emp      avh       hc    ccon      cda    cgdpe
## GBR-1990  57.11012  26.70239 1757.428 3.197166 1089023  1383493  1389299
## GBR-1992  57.41947  25.34559 1710.730 3.257343 1079084  1364559  1386354
## GBR-1994  57.73667  25.37445 1718.147 3.318652 1143430  1462102  1480134
## GBR-1996  58.07932  25.90053 1727.994 3.381115 1243814  1616862  1620570
## GBR-1998  58.45699  26.65316 1720.474 3.444755 1437450  1828209  1813438
## GBR-2000  58.86700  27.31735 1699.107 3.509591 1650633  2054763  2015176
## USA-1990 252.84781 123.40108 1793.348 3.435097 7180793  9379958  9259331
## USA-1992 257.90821 122.23189 1773.457 3.469595 7393262  9636033  9585170
## USA-1994 263.30132 126.19808 1805.167 3.504440 7875691 10382788 10252747
## USA-1996 269.48322 129.91119 1818.629 3.533239 8440640 11059940 10929891
## USA-1998 276.35410 135.07707 1842.790 3.555839 9099003 12138236 11924765
## USA-2000 282.89574 139.29607 1848.147 3.578583 9977582 13511612 13035321
##             cgdpo       ck      ctfp     cwtfp   rgdpna   rconna    rdana
## GBR-1990  1359320  3581698 0.8565159 0.8605587  1454251  1151596  1441845
## GBR-1992  1355717  3798598 0.8363361 0.8363643  1442380  1157180  1430968
## GBR-1994  1454296  4275514 0.8437811 0.8360074  1539957  1230659  1542677
## GBR-1996  1603619  4926870 0.8475673 0.8436683  1620910  1298540  1675014
## GBR-1998  1801130  5103451 0.8929624 0.8898261  1727567  1407718  1817333
## GBR-2000  2011111  5134820 0.9471037 0.9298179  1849012  1538370  1967642
## USA-1990  9259567 26453210 1.0000000 1.0000000  9241600  7644560  9454309
## USA-1992  9573914 26769574 1.0000000 1.0000000  9563208  7915272  9717433
## USA-1994 10232211 28433732 1.0000000 1.0000000 10222333  8395977 10477239
## USA-1996 10918888 30426092 1.0000000 1.0000000 10910675  8855808 11165208
## USA-1998 11916442 32851262 1.0000000 1.0000000 11907535  9590438 12341446
## USA-2000 12983206 35997032 1.0000000 1.0000000 12975535 10500206 13647352
##              rkna    rtfpna   rwtfpna     labsh      delta        xr    pl_con
## GBR-1990  6776786 0.8450031 0.7902915 0.6305985 0.04484341 0.5631772 0.7784873
## GBR-1992  6966938 0.8621486 0.8068302 0.6349562 0.04698808 0.5697742 0.8785668
## GBR-1994  7189067 0.8962294 0.8469064 0.6022500 0.04996404 0.6534266 0.7998383
## GBR-1996  7519430 0.9019064 0.8791658 0.5876861 0.04903908 0.6409583 0.8347086
## GBR-1998  7832531 0.9216082 0.9145252 0.6077729 0.04735128 0.6038236 0.8621315
## GBR-2000  8162493 0.9527478 0.9563877 0.6309897 0.04590227 0.6609308 0.7730830
## USA-1990 29208678 0.8194728 0.8043448 0.6205937 0.05050447 1.0000000 0.6647873
## USA-1992 30447546 0.8403289 0.8192613 0.6259861 0.05128768 1.0000000 0.7121214
## USA-1994 31914476 0.8503121 0.8361810 0.6138800 0.05088532 1.0000000 0.7428809
## USA-1996 33669848 0.8649735 0.8492648 0.6127331 0.05114771 1.0000000 0.7635167
## USA-1998 35854404 0.8888780 0.8839169 0.6289788 0.05128827 1.0000000 0.7885633
## USA-2000 38439588 0.9205835 0.9289908 0.6426795 0.05212035 1.0000000 0.8255066
##              pl_da   pl_gdpo        i_cig      i_xm   i_xr i_outlier   cor_exp
## GBR-1990 0.7868814 0.8042360 interpolated benchmark market        no        NA
## GBR-1992 0.8509466 0.8701767 interpolated benchmark market        no        NA
## GBR-1994 0.7705001 0.7841891 interpolated benchmark market        no        NA
## GBR-1996 0.8062972 0.8148201    benchmark benchmark market        no 0.9190811
## GBR-1998 0.8475854 0.8533775    benchmark benchmark market        no        NA
## GBR-2000 0.7715102 0.7730696    benchmark benchmark market        no        NA
## USA-1990 0.6457918 0.6457753 interpolated benchmark market        no        NA
## USA-1992 0.6822309 0.6830331 interpolated benchmark market        no        NA
## USA-1994 0.7128529 0.7142835 interpolated benchmark market        no        NA
## USA-1996 0.7411053 0.7418521    benchmark benchmark market        no 1.0000000
## USA-1998 0.7622087 0.7627411 interpolated benchmark market        no        NA
## USA-2000 0.7889932 0.7921603 interpolated benchmark market        no        NA
##          statcap     csh_c     csh_i      csh_g      csh_x       csh_m
## GBR-1990      NA 0.6439415 0.2166304 0.15721136 0.22560194 -0.28348714
## GBR-1992      NA 0.6331229 0.2105715 0.16282789 0.24578607 -0.29445687
## GBR-1994      NA 0.6347595 0.2191247 0.15148313 0.22600386 -0.26561368
## GBR-1996      NA 0.6384134 0.2326292 0.13721594 0.24207374 -0.27488899
## GBR-1998      NA 0.6567524 0.2169524 0.14133006 0.25288931 -0.28683373
## GBR-2000      NA 0.6695670 0.2009486 0.15118961 0.27215350 -0.32554415
## USA-1990      NA 0.6682413 0.2375019 0.10725861 0.06967672 -0.09049807
## USA-1992      NA 0.6659960 0.2342586 0.10623372 0.07868098 -0.09609801
## USA-1994      NA 0.6700110 0.2450200 0.09968483 0.08039907 -0.10660714
## USA-1996      NA 0.6820182 0.2398870 0.09101298 0.08498514 -0.11005893
## USA-1998      NA 0.6714191 0.2550454 0.09214798 0.09475239 -0.12449959
## USA-2000      NA 0.6758358 0.2722001 0.09266327 0.10603466 -0.15664728
##                csh_r      pl_c      pl_i      pl_g      pl_x      pl_m
## GBR-1990 0.040101860 0.7423567 0.8179252 0.9264792 0.6048944 0.5832911
## GBR-1992 0.042148478 0.8377092 0.7465436 1.0374331 0.5716438 0.5552554
## GBR-1994 0.034242544 0.7634724 0.6652314 0.9522221 0.6048408 0.5797722
## GBR-1996 0.024556704 0.7892579 0.7115680 1.0461737 0.6533383 0.6413544
## GBR-1998 0.018909538 0.8288851 0.7940759 1.0166255 0.5934206 0.6036877
## GBR-2000 0.031685416 0.7461854 0.7650863 0.8922034 0.5387948 0.5723231
## USA-1990 0.007819587 0.6182825 0.5837670 0.9545210 0.6089282 0.6175903
## USA-1992 0.010928692 0.6611473 0.5836974 1.0316866 0.5938390 0.6016038
## USA-1994 0.011492195 0.6915565 0.6185242 1.0878472 0.6227808 0.6316585
## USA-1996 0.012155626 0.7074198 0.6688849 1.1838868 0.6711445 0.6803800
## USA-1998 0.011134692 0.7377932 0.6833072 1.1584898 0.6026288 0.6365294
## USA-2000 0.009913484 0.7741043 0.6859053 1.2004077 0.5668258 0.6185908
##               pl_k
## GBR-1990 1.0969303
## GBR-1992 0.9516477
## GBR-1994 0.7323192
## GBR-1996 0.7715557
## GBR-1998 0.8749288
## GBR-2000 0.9000055
## USA-1990 0.6470308
## USA-1992 0.6837977
## USA-1994 0.7149737
## USA-1996 0.7424105
## USA-1998 0.7633117
## USA-2000 0.7926286
Datos de Estados Unidos y Reino Unido (1990-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-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-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-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-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-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
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.00 1.00 9241600 7644560 9454309 29208678 0.82 0.80 0.62 0.05 1.00 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-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.00 1.00 9563208 7915272 9717433 30447546 0.84 0.82 0.63 0.05 1.00 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-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.00 1.00 10222333 8395977 10477239 31914476 0.85 0.84 0.61 0.05 1.00 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-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.00 1.00 10910675 8855808 11165208 33669848 0.86 0.85 0.61 0.05 1.00 0.76 0.74 0.74 benchmark benchmark market no 1.00 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-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.00 1.00 11907535 9590438 12341446 35854404 0.89 0.88 0.63 0.05 1.00 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-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.00 1.00 12975535 10500206 13647352 38439588 0.92 0.93 0.64 0.05 1.00 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_variables_capital_detail(c("United States of America","United Kingdom"),1990,2000) -> dataframe_6
print(dataframe_6) %>%
  kable(caption = "Variables de la categoría Capital Detail para Estados Unidos y Reino Unido (1990-2000)",
 digits = 2,align = "l") %>%
kable_styling(bootstrap_options = "striped",
 full_width = TRUE)
##                           country year       ck     rkna      pl_k
## GBR-1990           United Kingdom 1990  3581698  6776786 1.0969303
## GBR-1992           United Kingdom 1992  3798598  6966938 0.9516477
## GBR-1994           United Kingdom 1994  4275514  7189067 0.7323192
## GBR-1996           United Kingdom 1996  4926870  7519430 0.7715557
## GBR-1998           United Kingdom 1998  5103451  7832531 0.8749288
## GBR-2000           United Kingdom 2000  5134820  8162493 0.9000055
## USA-1990 United States of America 1990 26453210 29208678 0.6470308
## USA-1992 United States of America 1992 26769574 30447546 0.6837977
## USA-1994 United States of America 1994 28433732 31914476 0.7149737
## USA-1996 United States of America 1996 30426092 33669848 0.7424105
## USA-1998 United States of America 1998 32851262 35854404 0.7633117
## USA-2000 United States of America 2000 35997032 38439588 0.7926286
Variables de la categoría Capital Detail para Estados Unidos y Reino Unido (1990-2000)
country year ck rkna pl_k
GBR-1990 United Kingdom 1990 3581698 6776786 1.10
GBR-1992 United Kingdom 1992 3798598 6966938 0.95
GBR-1994 United Kingdom 1994 4275514 7189067 0.73
GBR-1996 United Kingdom 1996 4926870 7519430 0.77
GBR-1998 United Kingdom 1998 5103451 7832531 0.87
GBR-2000 United Kingdom 2000 5134820 8162493 0.90
USA-1990 United States of America 1990 26453210 29208678 0.65
USA-1992 United States of America 1992 26769574 30447546 0.68
USA-1994 United States of America 1994 28433732 31914476 0.71
USA-1996 United States of America 1996 30426092 33669848 0.74
USA-1998 United States of America 1998 32851262 35854404 0.76
USA-2000 United States of America 2000 35997032 38439588 0.79

MANEJO DE UN DATA FRAME

SELECC ··Ejemplo 1: dataframe %>% select(columna1,columna2,…) Usando la base de datos de comercio exterior, para El Salvador, creada en la sesión anterior, seleccione las columnas de “pais”, “sac”,“anio”,“mes”,“valor_cif”.

#Cargamos el paquete "dplyr"
library(dplyr)
library(kableExtra) #Sólo es para formato de las tablas de estos apuntes

data_comercio_exterior %>%
  select("pais", "sac","anio","mes","valor_cif") %>% 
  head() %>% kable(caption = "Ejemplo 1") %>% kable_minimal()
Ejemplo 1
pais sac anio mes valor_cif
Afganistan 4010390000 2017 4 58.06
Afganistan 4010390000 2017 4 58.06
Afganistan 6812999090 2017 4 88.38
Afganistan 6812999090 2017 4 88.38
Afganistan 8487900000 2017 4 20.93
Afganistan 8487900000 2017 4 20.93

FILTER ··dataframe %>% filter(columna1 operadores “criterio 1”,columna2 operadores “criterio 2,…)

Ejemplo 1: Seleccione todas las transacciones de exportación del año 2019, con Honduras o Guatemala, que sean superiores a los 100,000 US$

library(dplyr)
data_comercio_exterior %>%
  select("pais", "sac","anio","mes","valor_fob") %>%
  filter(anio=="2019", pais %in% c("Guatemala","Honduras"),valor_fob>100000)
## # A tibble: 5,744 × 5
##    pais      sac         anio   mes valor_fob
##    <chr>     <chr>      <dbl> <dbl>     <dbl>
##  1 Guatemala 0105110000  2019     1   402629 
##  2 Guatemala 0105110000  2019     1   402629 
##  3 Guatemala 0403209000  2019     1   333543.
##  4 Guatemala 0403209000  2019     1   333543.
##  5 Guatemala 0406202000  2019     1   727621.
##  6 Guatemala 0406202000  2019     1   727621.
##  7 Guatemala 0406909000  2019     1   161111.
##  8 Guatemala 0406909000  2019     1   161111.
##  9 Guatemala 1101000000  2019     1   561071.
## 10 Guatemala 1101000000  2019     1   561071.
## # … with 5,734 more rows

MUTATE ··Permiten agregar transformaciones de columnas (variables) de un dataframe. mutate agrega nuevas variables con la transformación de las columnas.

Sintaxis simple:

dataframe %>% mutate(nueva_variable= operaciones con variables,…)

Ejemplo 1: calcule el saldo de la balanza comercial para todas las transacciones, disponibles en la base de comercio exterior.

data_comercio_exterior %>% 
  mutate(saldo_bc=valor_fob-valor_cif) %>% 
  select("pais","sac","anio","mes","saldo_bc")
## # A tibble: 2,874,460 × 5
##    pais       sac         anio   mes saldo_bc
##    <chr>      <chr>      <dbl> <dbl>    <dbl>
##  1 Afganistan 4010390000  2017     4    -58.1
##  2 Afganistan 4010390000  2017     4    -58.1
##  3 Afganistan 6812999090  2017     4    -88.4
##  4 Afganistan 6812999090  2017     4    -88.4
##  5 Afganistan 8487900000  2017     4    -20.9
##  6 Afganistan 8487900000  2017     4    -20.9
##  7 Afganistan 8511800000  2017     4    -98.9
##  8 Afganistan 8511800000  2017     4    -98.9
##  9 Afganistan 8708930000  2017     4    -62.2
## 10 Afganistan 8708930000  2017     4    -62.2
## # … with 2,874,450 more rows

Ejemplo 2: Calcule las exportaciones y las importaciones como porcentaje del comercio total, en cada transacción disponible en la base de comercio exterior, muestre sólo aquellas partidas que registren exportaciones

options(scipen = 99999)
data_comercio_exterior %>% 
  mutate(Xpt=round(valor_fob/(valor_cif+valor_fob)*100,2),
         Mpt=round(valor_cif/(valor_cif+valor_fob)*100,2)) %>% 
  select("pais","sac","anio","mes","Xpt","Mpt") %>% filter(Xpt>0)
## # A tibble: 668,834 × 6
##    pais       sac         anio   mes   Xpt   Mpt
##    <chr>      <chr>      <dbl> <dbl> <dbl> <dbl>
##  1 Afganistan 3004909100  2019     9   100     0
##  2 Afganistan 3004909100  2019     9   100     0
##  3 Afganistan 7009920000  2021     5   100     0
##  4 Afganistan 7009920000  2021     5   100     0
##  5 Afganistan 8302419000  2021     5   100     0
##  6 Afganistan 8302419000  2021     5   100     0
##  7 Afganistan 8306290000  2021     5   100     0
##  8 Afganistan 8306290000  2021     5   100     0
##  9 Afganistan 9401710000  2021     5   100     0
## 10 Afganistan 9401710000  2021     5   100     0
## # … with 668,824 more rows

ARRANGE ··Permite ordenar las filas del dataframe(ascendente A-Z o descendente Z-A), por una o varias columnas (variables).

Sintaxis simple:

dataframe %>% arrange(variable 1, desc(variable 2), …)

Nota: si la ordenación que se requiere es descendente, escriba la variable dentro de la función desc(), como se indica en la sintaxis. Esta función fue implementada también al momento de generar la Base de Comercio Exterior que estamos usando.

Ejemplo: Ordenar los resultados del Ejemplo 2 de mutate, mostrando primero los resultados más recientes.

options(scipen = 99999)
data_comercio_exterior %>% 
  mutate(Xpt=round(valor_fob/(valor_cif+valor_fob)*100,2),
         Mpt=round(valor_cif/(valor_cif+valor_fob)*100,2)) %>% 
  select("pais","sac","anio","mes","Xpt","Mpt") %>% 
  filter(Xpt>0) %>%
  arrange(desc(anio),desc(mes))
## # A tibble: 668,834 × 6
##    pais     sac         anio   mes   Xpt   Mpt
##    <chr>    <chr>      <dbl> <dbl> <dbl> <dbl>
##  1 Alemania 0409000000  2022     7   100     0
##  2 Alemania 0409000000  2022     7   100     0
##  3 Alemania 0901113000  2022     7   100     0
##  4 Alemania 0901113000  2022     7   100     0
##  5 Alemania 1301909000  2022     7   100     0
##  6 Alemania 1301909000  2022     7   100     0
##  7 Alemania 1604149000  2022     7   100     0
##  8 Alemania 1604149000  2022     7   100     0
##  9 Alemania 3808930000  2022     7   100     0
## 10 Alemania 3808930000  2022     7   100     0
## # … with 668,824 more rows

SUMMARISE ··Permite realizar operaciones de agregación de columnas (variables), de cualquier tipo, suma, producto, incluso funciones personalizadas.

Puede usarse en conjunto con group_by para obtener agregados a nivel de grupos.

Sintaxis simple:

dataframe %>% group_by(variable 1, variable 2…) %>% summarise(resultado 1= función de agregación(variable),resultado 2= función de agregación(variable)

Ejemplo 1: Obtenga los totales anuales de importaciones y exportaciones.

data_comercio_exterior %>% 
  group_by(anio) %>%
  summarise(`Total Exportaciones MM US$`=sum(valor_fob)/1e6,
            `Total Importaciones MM US$`=sum(valor_cif)/1e6)
## # A tibble: 6 × 3
##    anio `Total Exportaciones MM US$` `Total Importaciones MM US$`
##   <dbl>                        <dbl>                        <dbl>
## 1  2017                       11520.                       21143.
## 2  2018                       11811.                       22929.
## 3  2019                       11810.                       23204.
## 4  2020                       10057.                       20496.
## 5  2021                       13258.                       30152.
## 6  2022                        8988.                       20770.

Ejemplo 2: Obtenga los totales anuales de importaciones y exportaciones, que se realizan por país

data_comercio_exterior %>% 
  group_by(pais,anio) %>%
  summarise(`Total Exportaciones`=sum(valor_fob),
            `Total Importaciones`=sum(valor_cif))
## `summarise()` has grouped output by 'pais'. You can override using the
## `.groups` argument.
## # A tibble: 1,217 × 4
## # Groups:   pais [241]
##    pais        anio `Total Exportaciones` `Total Importaciones`
##    <chr>      <dbl>                 <dbl>                 <dbl>
##  1 Afganistan  2017                    0                  2222.
##  2 Afganistan  2018                    0                 47146.
##  3 Afganistan  2019                  764.                26228.
##  4 Afganistan  2020                    0                 10853.
##  5 Afganistan  2021                75747.                    0 
##  6 Afganistan  2022                    0                  4733.
##  7 Albania     2017                    0                 25286.
##  8 Albania     2018                    0                 36615.
##  9 Albania     2019               102785                 51320.
## 10 Albania     2020                    0                736595.
## # … with 1,207 more rows