SOLUCION PARCIAL I

Carga de data y funciones.

source(file = "C:/Users/Febe Arias/Downloads/funciones_comercio_exterior (1).R",echo = TRUE,max.deparse.length = 100,encoding = "utf-8")

## 
## > options(scipen = 999)
## 
## > library(dplyr)
## 
## > library(readxl)
## 
## > library(stringr)
## 
## > load("C:/Users/Febe Arias/Documents/comercio/update_comerio_exterior.RData")
## 
## > nombre_archivo <- "C:/Users/Febe Arias/Downloads/Telegram Desktop/nombres_iso_paises.xlsx"
## 
## > nombres_iso_paises <- read_excel(nombre_archivo)
## 
## > data_comercio_exterior <- update_comerio_exterior %>% 
## +     left_join(nombres_iso_paises, by = c( .... [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(kableExtra)

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$)

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 Exportaciones ESA MM US$`=sum(valor_fob)) %>% 
  head() %>% kable(caption = "Exportaciones totales a El Salvador") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

## `summarise()` ungrouping output (override with `.groups` argument)

Exportaciones totales a El Salvador

anio	Total Exportaciones ESA MM US$
2019	2452792
2020	1503626
* 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$)

data_comercio_exterior %>%
  filter(sub_region=="Asia Sudoriental",anio %in% 2017:2019) %>%
  group_by(anio) %>%
  summarise(`Total Exportaciones MM US$`=sum(valor_fob)/1e6,
            `Total Importaciones MM US$`=sum(valor_cif)/1e6,
            `Balanza Comercial ESA-Asia Sudoriental MM $`=`Total Exportaciones MM US$`-`Total Importaciones MM US$`) %>% 
  head() %>% kable(caption = "Saldo de la Balanza comercial ESA-Asia Sudoriental") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

## `summarise()` ungrouping output (override with `.groups` argument)

Saldo de la Balanza comercial ESA-Asia Sudoriental

anio	Total Exportaciones MM US$	Total Importaciones MM US$	Balanza Comercial ESA-Asia Sudoriental MM $
2017	73.591111	269.4838	-195.8927
2018	16.609646	280.8837	-264.2740
2019	4.608928	262.5498	-257.9409
* Elaboracion 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?.

data_comercio_exterior %>% filter(valor_cif==0, valor_fob>0, anio==2019,region_intermedia=="Sudamerica") %>% 
  summarise(`Total de exportaciones de ESA a Sudamerica`=sum(valor_fob))->exportaciones

data_comercio_exterior %>%
filter(region_intermedia=="Sudamerica", valor_cif>0, valor_fob==0, anio==2019) %>% 
  summarise(`Total de importaciones de ESA a Sudamerica`=sum(valor_cif))->importaciones

ratio_comercio_exterior<- (importaciones/exportaciones)
print(ratio_comercio_exterior)  %>% 
  head() %>% kable(caption = "Exportaciones de El Salvador a Sudamerica") %>% kable_minimal() %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

##   Total de importaciones de ESA a Sudamerica
## 1                                   19.13248

Exportaciones de El Salvador a Sudamerica

Total de importaciones de ESA a Sudamerica
19.13248
* Elaboracion propia con base en datos del BCR

#Por cada dolar exportado a Sudamerica se importa $19.00 aproximadamente

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))%>%
   kable(caption = "Indicador de Balassa de El Salvador, con México, Estados Unidos y Canadá, durante el periodo 2017-2020, para el capitulo “01” del SAC",
        digits = 2,align = "l")%>%
  kable_minimal(bootstrap_options = "striped",
                full_width = TRUE)%>% 
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

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

años	IB_Mexico	IB_USA	IB_Canada
2017	-0.58	0.36	0.40
2018	-0.82	0.32	0.61
2019	-0.90	0.40	0.19
2020	-0.98	0.70	0.04
* Elaboración propia con base en datos del BCR

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

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

1- Calcule el indicador 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"
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_Canada"=sapply(X=2017:2020,FUN = indicadores_IVCR_capitulo,codigo_pais=124,capitulo=capitulo))%>%
  
head() %>% kable(caption = "Índice 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()

Índice IVCR de El Salvador, con México, Estados Unidos y Canadá para los años 2017-2020

años	IVCR_Mexico	IVCR_USA	IVCR_Canada
2017	-0.0006366	-0.1268112	0.0025811
2018	-0.0047801	-0.0997253	0.0000473
2019	-0.0014925	-0.0880920	0.0003483
2020	-0.0013685	-0.0841604	-0.0027953
* 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).

data_comercio_exterior %>% filter(valor_cif==0, valor_fob>0, anio==2017,region_intermedia=="Centroamérica") %>% 
  summarise(`Total de exportaciones de ESA a Sudamerica`=sum(valor_fob))->exportaciones

data_comercio_exterior %>%
filter(region_intermedia=="Centroamérica", valor_cif>0, valor_fob==0, anio==2017) %>% 
  summarise(`Total de importaciones de El Salvador a Centroamerica`=sum(valor_cif))->importaciones

ratio_comercio_exterior<- (importaciones/exportaciones)
print(ratio_comercio_exterior)  %>% 
  head() %>% kable(caption = "Exportaciones de El Salvador a Centroamérica Para el año 2017") %>% kable_minimal() %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

##   Total de importaciones de El Salvador a Centroamerica
## 1                                              1.580565

Exportaciones de El Salvador a Centroamérica Para el año 2017

Total de importaciones de El Salvador a Centroamerica
1.580565
* Elaboracion propia con base en datos del BCR

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

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

ratio_comercio_exterior<- (importaciones/exportaciones)
print(ratio_comercio_exterior)  %>% 
  head() %>% kable(caption = "Exportaciones de El Salvador a Centroamérica Para el año 2018") %>% kable_minimal() %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

##   Total de importaciones de El Salvador a Centroamerica
## 1                                              1.743028

Exportaciones de El Salvador a Centroamérica Para el año 2018

Total de importaciones de El Salvador a Centroamerica
1.743028
* Elaboracion propia con base en datos del BCR

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

data_comercio_exterior %>%
filter(region_intermedia=="Centroamérica", valor_cif>0, valor_fob==0, anio==2019) %>% 
  summarise(`Total de importaciones de El Salvador a Centroamerica`=sum(valor_cif))->importaciones

ratio_comercio_exterior<- (importaciones/exportaciones)
print(ratio_comercio_exterior)  %>% 
  head() %>% kable(caption = "Exportaciones de El Salvador a Centroamérica Para el año 2019") %>% kable_minimal() %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

##   Total de importaciones de El Salvador a Centroamerica
## 1                                              1.729294

Exportaciones de El Salvador a Centroamérica Para el año 2019

Total de importaciones de El Salvador a Centroamerica
1.729294
* Elaboracion propia con base en datos del BCR

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

data_comercio_exterior %>%
  filter(region_intermedia=="Caribe",anio %in% 2017:2019) %>%
  group_by(anio) %>%
  summarise(`Total Exportaciones MM US$`=sum(valor_fob)/1e6,
            `Total Importaciones MM US$`=sum(valor_cif)/1e6,
            `Balanza Comercial El Salvador-Caribe MM $`=`Total Exportaciones MM US$`-`Total Importaciones MM US$`) %>% 
  head() %>% kable(caption = "Saldo de la Balanza comercial ESA-Asia Sudoriental") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

## `summarise()` ungrouping output (override with `.groups` argument)

Saldo de la Balanza comercial ESA-Asia Sudoriental

anio	Total Exportaciones MM US$	Total Importaciones MM US$	Balanza Comercial El Salvador-Caribe MM $
2017	150.1824	46.04799	104.1345
2018	172.1331	34.04536	138.0877
2019	169.1371	21.61247	147.5247
* Elaboracion 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 Exportaciones El Salvador MM US$`=sum(valor_fob)/1e6) %>% 
  head() %>% kable(caption = "Exportaciones totales a El Salvador") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

## `summarise()` ungrouping output (override with `.groups` argument)

Exportaciones totales a El Salvador

anio	Total Exportaciones El Salvador MM US$
2019	19.80854
2020	12.15218
* Elaboracion propia con base en datos del BCR

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

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

1- Por cada 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`=sum(valor_fob))->exportaciones

data_comercio_exterior %>%
filter(region_intermedia=="Sudamerica", valor_cif>0, valor_fob==0, anio==2018) %>% 
  summarise(`Total de importaciones de El Salvador a Centroamerica`=sum(valor_cif))->importaciones

ratio_comercio_exterior<- (importaciones/exportaciones)
print(ratio_comercio_exterior)  %>% 
  head() %>% kable(caption = "Ratio de importaciones-exportaciones El Salvador a Sudamerica Para el año 2018") %>% kable_minimal() %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

##   Total de importaciones de El Salvador a Centroamerica
## 1                                              16.76119

Ratio de importaciones-exportaciones El Salvador a Sudamerica Para el año 2018

Total de importaciones de El Salvador a Centroamerica
16.76119
* Elaboracion propia con base en datos del BCR

data_comercio_exterior %>% filter(valor_cif==0, valor_fob>0, anio==2019,region_intermedia=="Sudamerica") %>% 
    summarise(`Total de importaciones de El Salvador a Sudamerica`=sum(valor_fob))->exportaciones

data_comercio_exterior %>%
filter(region_intermedia=="Sudamerica", valor_cif>0, valor_fob==0, anio==2019) %>% 
  summarise(`Total de importaciones de El Salvador a Sudamerica`=sum(valor_cif))->importaciones

ratio_comercio_exterior<- (importaciones/exportaciones)
print(ratio_comercio_exterior)  %>% 
  head() %>% kable(caption = "Ratio de importaciones-exportaciones El Salvador a Sudamerica Para el año 2019") %>% kable_minimal() %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()  

##   Total de importaciones de El Salvador a Sudamerica
## 1                                           19.13248

Ratio de importaciones-exportaciones El Salvador a Sudamerica Para el año 2019

Total de importaciones de El Salvador a Sudamerica
19.13248
* Elaboracion propia con base en datos del BCR

2- Calcule el IHH de El Salvador, con Mexico, Estados Unidos y Canada, 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 = "Indicador de IHH de El Salvador, con México, Estados Unidos y Canadá, durante el periodo 2017-2020,normalizado")%>%
  kable_minimal(bootstrap_options = "striped",
                full_width = TRUE)%>% 
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

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

anios	IHH_Mexico	IHH_USA	IHH_Canada
2017	0.0165526	0.0055910	0.1231022
2018	0.0182162	0.0056610	0.0084443
2019	0.0142813	0.0058727	0.1190248
2020	0.0146978	0.0098672	0.0590948
* Elaboración propia con base en datos del BCR

3- Calcule las exportaciones totales de El Salvador hacia la región de Africa Oriental, para el periodo 2017-2020 (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 Exportaciones ESA MM US$`=sum(valor_fob)/1e6) %>% 
  head() %>% kable(caption = "Exportaciones totales a El Salvador en Millones de dolares hacia region de África oriental") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboración propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

## `summarise()` ungrouping output (override with `.groups` argument)

Exportaciones totales a El Salvador en Millones de dolares hacia region de África oriental

anio	Total Exportaciones ESA MM US$
2017	0.6734228
2018	4.0123130
2019	0.8439266
2020	0.0007570
* 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 MM US$`=sum(valor_fob)/1e6,
            `Total Importaciones MM US$`=sum(valor_cif)/1e6,
            `Balanza Comercial El Salvador-Caribe MM $`=`Total Exportaciones MM US$`-`Total Importaciones MM US$`) %>% 
  head() %>% kable(caption = "Saldo de la Balanza comercial ES-América Latina Y El Caribe") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en datos del BCR",
               notation="symbol") %>%  kable_minimal()

## `summarise()` ungrouping output (override with `.groups` argument)

Saldo de la Balanza comercial ES-América Latina Y El Caribe

anio	Total Exportaciones MM US$	Total Importaciones MM US$	Balanza Comercial El Salvador-Caribe MM $
2017	2746.262	3770.895	-1024.633
2018	2922.872	4144.131	-1221.259
2019	3067.961	4553.745	-1485.784
* Elaboracion propia con base en datos del BCR

#Segunda Parte ## Usando los datos de la Penn World Table, de la Universidad de Groningen. #4 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(kableExtra)
library(dplyr)
library(pwt9)
data("pwt9.0")
options(scipen = 999999)

Funcion_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  1950-2014
Funcion_pais_periodo(country = "El Salvador",anio_inicio = 1950,anio_final = 2014) %>%
 kable(caption = "Probando Función consulta paises, SLV 1990-2014",
 digits = 1,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)

Probando Función consulta paises, SLV 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
SLV-1950	El Salvador	SLV	1950	US Dollar	1328.7	1163.0	2.0	NA	NA	1.2	1106.2	1178.1	1276.2	1136.4	1489.4	NA	NA	6510.5	6671.5	6988.9	14268.6	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.3	0	0.1	0.1	0.1	0.1	0.1	0.2
SLV-1951	El Salvador	SLV	1951	US Dollar	1406.2	1163.4	2.0	NA	NA	1.2	1178.9	1267.0	1349.9	1105.5	1544.8	NA	NA	6766.9	7134.1	7564.4	14326.2	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.4	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1952	El Salvador	SLV	1952	US Dollar	1488.1	1253.5	2.1	NA	NA	1.2	1251.2	1349.3	1420.9	1192.8	1588.6	NA	NA	7264.3	7644.2	8094.0	14409.0	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.4	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1953	El Salvador	SLV	1953	US Dollar	1593.6	1346.1	2.1	NA	NA	1.2	1362.8	1464.0	1525.1	1305.6	1600.3	NA	NA	7817.6	8292.7	8739.8	14508.4	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1954	El Salvador	SLV	1954	US Dollar	1690.6	1356.9	2.2	NA	NA	1.2	1451.0	1549.4	1615.6	1317.6	1580.2	NA	NA	8021.8	8827.7	9217.7	14583.3	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	1.0	0.1	0.1	0.2	-0.4	0	0.1	0.2	0.1	0.2	0.1	0.2
SLV-1955	El Salvador	SLV	1955	US Dollar	1753.4	1425.7	2.3	NA	NA	1.2	1517.9	1618.2	1669.6	1384.1	1582.7	NA	NA	8445.0	9284.1	9673.2	14673.4	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	1.0	0.1	0.1	0.2	-0.4	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1956	El Salvador	SLV	1956	US Dollar	1828.7	1514.2	2.3	NA	NA	1.3	1564.4	1707.0	1730.1	1459.7	1657.9	NA	NA	8990.8	9644.4	10412.6	15037.8	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.4	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1957	El Salvador	SLV	1957	US Dollar	1975.5	1593.0	2.4	NA	NA	1.3	1624.6	1784.3	1864.7	1527.8	1710.4	NA	NA	9393.5	10034.3	10928.6	15464.8	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.4	0	0.1	0.2	0.1	0.2	0.1	0.2
SLV-1958	El Salvador	SLV	1958	US Dollar	1892.2	1650.9	2.5	NA	NA	1.3	1628.0	1763.6	1785.9	1607.5	1703.7	NA	NA	9519.5	10066.1	10701.7	15672.7	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1959	El Salvador	SLV	1959	US Dollar	1908.1	1710.7	2.5	NA	NA	1.3	1668.1	1771.1	1790.0	1664.5	1698.6	NA	NA	9704.6	10381.5	10665.8	15646.0	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1960	El Salvador	SLV	1960	US Dollar	1935.0	1727.9	2.6	NA	NA	1.3	1713.0	1908.0	1833.1	1611.0	1723.0	NA	NA	10141.4	10527.9	11719.5	16277.7	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.4	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1961	El Salvador	SLV	1961	US Dollar	1988.4	1832.7	2.7	NA	NA	1.3	1722.9	1888.9	1898.7	1738.6	1761.3	NA	NA	10299.3	10425.4	11426.5	16665.3	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1962	El Salvador	SLV	1962	US Dollar	2190.9	2056.0	2.8	NA	NA	1.3	1908.8	2075.2	2094.6	2008.4	1795.5	NA	NA	11393.6	11522.7	12500.4	17063.0	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1963	El Salvador	SLV	1963	US Dollar	2263.0	2125.3	2.9	NA	NA	1.3	2000.3	2183.8	2154.5	2091.8	1823.3	NA	NA	11892.1	12173.6	13265.7	17543.1	NA	NA	NA	0.0	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.3	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1964	El Salvador	SLV	1964	US Dollar	2459.9	2274.7	3.0	NA	NA	1.3	2139.1	2404.7	2332.5	2232.8	1897.5	NA	NA	13026.6	13116.4	14919.8	18561.3	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.3	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1965	El Salvador	SLV	1965	US Dollar	2638.4	2413.0	3.1	NA	NA	1.3	2302.3	2551.6	2502.3	2375.6	1983.0	NA	NA	13802.4	14112.0	15722.1	19365.0	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1966	El Salvador	SLV	1966	US Dollar	2809.3	2571.7	3.2	NA	NA	1.3	2499.6	2791.0	2666.6	2550.2	2106.6	NA	NA	14927.1	15302.3	17257.2	20419.5	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.9	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1967	El Salvador	SLV	1967	US Dollar	2962.0	2743.2	3.3	NA	NA	1.3	2645.2	2897.4	2824.9	2745.1	2182.8	NA	NA	15570.7	16075.0	17633.5	21093.6	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1968	El Salvador	SLV	1968	US Dollar	2973.3	2871.8	3.4	NA	NA	1.3	2685.8	2881.1	2844.1	2889.2	2199.8	NA	NA	15887.0	16238.4	17227.9	21297.2	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.3	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1969	El Salvador	SLV	1969	US Dollar	3072.1	2982.8	3.5	NA	NA	1.3	2770.1	2991.3	2928.2	2991.9	2260.1	NA	NA	16480.5	16726.6	17930.4	21689.3	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.2	-0.2	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1970	El Salvador	SLV	1970	US Dollar	3365.3	3070.2	3.7	NA	NA	1.3	2927.8	3175.9	3199.6	3084.7	2350.4	NA	NA	17229.6	17737.8	19129.1	22254.2	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.2	-0.2	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1971	El Salvador	SLV	1971	US Dollar	3400.1	3162.7	3.8	NA	NA	1.3	2983.5	3288.7	3220.8	3166.8	2453.2	NA	NA	18064.8	18239.4	20145.9	23028.0	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.1	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1972	El Salvador	SLV	1972	US Dollar	3625.1	3332.8	3.9	NA	NA	1.3	3142.8	3429.8	3420.3	3342.6	2626.7	NA	NA	19058.4	19195.2	20843.3	24376.7	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.2	-0.3	0	0.1	0.2	0.1	0.1	0.1	0.2
SLV-1973	El Salvador	SLV	1973	US Dollar	3889.2	3535.1	4.0	NA	NA	1.3	3363.6	3739.7	3641.3	3510.5	2769.8	NA	NA	20023.2	20695.4	23138.5	25351.5	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.2	-0.3	0	0.1	0.2	0.1	0.2	0.1	0.3
SLV-1974	El Salvador	SLV	1974	US Dollar	3845.1	3708.9	4.1	NA	NA	1.4	3419.4	3909.5	3613.5	3589.1	2981.4	NA	NA	21304.8	21122.9	24593.1	26587.2	NA	NA	NA	0.1	1	0.1	0.1	0.1	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.3	-0.4	0	0.1	0.2	0.1	0.2	0.2	0.3
SLV-1975	El Salvador	SLV	1975	US Dollar	3991.9	3920.2	4.1	1.2	NA	1.4	3559.1	4010.1	3760.6	3768.4	3251.2	NA	NA	22492.8	21941.9	24788.4	28534.6	NA	NA	NA	0.1	1	0.1	0.2	0.2	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.3	-0.3	0	0.1	0.3	0.1	0.2	0.2	0.3
SLV-1976	El Salvador	SLV	1976	US Dollar	4631.0	4075.1	4.2	1.3	NA	1.4	3937.2	4431.4	4343.8	3940.4	3467.6	NA	NA	23378.4	24298.5	27443.9	30453.1	NA	NA	NA	0.1	1	0.2	0.2	0.2	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.2	-0.4	0	0.2	0.3	0.1	0.3	0.2	0.4
SLV-1977	El Salvador	SLV	1977	US Dollar	5449.4	4217.1	4.3	1.3	NA	1.4	4365.6	5064.4	5118.7	4090.6	3840.4	NA	NA	24789.6	26910.2	32121.7	33198.9	NA	NA	NA	0.1	1	0.2	0.2	0.2	extrapolated	extrapolated	market	no	NA	NA	0.9	0.2	0.2	0.2	-0.4	0	0.2	0.3	0.1	0.4	0.2	0.4
SLV-1978	El Salvador	SLV	1978	US Dollar	5117.9	4515.6	4.4	1.4	NA	1.4	4523.7	5243.2	4799.0	4355.5	4239.0	NA	NA	26388.0	27856.9	33214.9	35825.1	NA	NA	NA	0.1	1	0.2	0.2	0.2	extrapolated	extrapolated	market	no	NA	NA	0.8	0.2	0.2	0.2	-0.4	0	0.2	0.3	0.2	0.3	0.2	0.4
SLV-1979	El Salvador	SLV	1979	US Dollar	5126.8	4554.5	4.5	1.4	NA	1.4	4269.3	4817.5	4809.2	4363.9	4503.1	NA	NA	25934.4	26117.2	29952.8	37426.4	NA	NA	NA	0.1	1	0.2	0.2	0.3	extrapolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.3	-0.4	0	0.2	0.4	0.2	0.3	0.2	0.4
SLV-1980	El Salvador	SLV	1980	US Dollar	4649.4	4278.8	4.6	1.4	NA	1.4	3981.8	4354.7	4395.1	4056.5	4601.4	NA	NA	23680.8	24121.2	26371.4	37785.8	NA	NA	NA	0.1	1	0.3	0.3	0.3	benchmark	extrapolated	market	no	0.5	NA	0.8	0.1	0.2	0.3	-0.4	0	0.3	0.4	0.2	0.3	0.3	0.4
SLV-1981	El Salvador	SLV	1981	US Dollar	4158.9	4066.8	4.7	1.4	NA	1.4	3844.3	4213.6	3941.5	3838.3	4800.8	NA	NA	21722.4	22492.0	24689.9	37937.4	NA	NA	NA	0.1	1	0.3	0.3	0.3	interpolated	extrapolated	market	no	NA	NA	0.8	0.1	0.2	0.2	-0.3	0	0.3	0.4	0.2	0.3	0.3	0.5
SLV-1982	El Salvador	SLV	1982	US Dollar	4018.6	4018.7	4.7	1.4	NA	1.5	3696.3	4042.0	3824.0	3818.8	4955.2	NA	NA	20505.6	20884.3	22829.7	37910.2	NA	NA	NA	0.1	1	0.3	0.3	0.3	interpolated	extrapolated	market	no	NA	NA	0.7	0.1	0.2	0.2	-0.3	0	0.3	0.5	0.2	0.3	0.3	0.5
SLV-1983	El Salvador	SLV	1983	US Dollar	4132.6	4157.7	4.8	1.4	NA	1.5	3822.9	4145.3	3932.3	3985.5	4915.6	NA	NA	20664.0	21008.3	22708.6	37828.4	NA	NA	NA	0.1	1	0.3	0.3	0.3	interpolated	extrapolated	market	no	NA	NA	0.7	0.1	0.2	0.2	-0.3	0	0.4	0.5	0.2	0.3	0.4	0.5
SLV-1984	El Salvador	SLV	1984	US Dollar	4359.0	4385.9	4.9	1.4	NA	1.5	4078.1	4414.8	4134.6	4203.6	5056.1	NA	NA	21139.2	21835.7	23572.5	37889.2	NA	NA	NA	0.1	1	0.4	0.4	0.4	interpolated	benchmark	market	no	NA	NA	0.7	0.1	0.2	0.2	-0.3	0	0.4	0.5	0.3	0.4	0.4	0.6
SLV-1985	El Salvador	SLV	1985	US Dollar	4607.5	4457.2	4.9	1.4	NA	1.5	4401.0	4728.1	4395.9	4341.9	5212.9	NA	NA	21556.8	22713.4	24274.5	38249.9	NA	NA	NA	0.1	1	0.4	0.4	0.4	interpolated	benchmark	market	no	NA	NA	0.8	0.1	0.2	0.3	-0.3	0	0.5	0.6	0.3	0.4	0.4	0.7
SLV-1986	El Salvador	SLV	1986	US Dollar	4992.9	4838.0	5.0	1.4	NA	1.5	4592.7	4999.5	4789.9	4753.4	5513.2	NA	NA	21693.6	22798.4	24897.8	38841.2	NA	NA	NA	0.1	1	0.5	0.5	0.5	interpolated	benchmark	market	no	NA	NA	0.7	0.1	0.2	0.3	-0.4	0	0.6	0.8	0.3	0.4	0.4	0.9
SLV-1987	El Salvador	SLV	1987	US Dollar	5051.6	4840.5	5.1	1.5	NA	1.6	4786.6	5187.2	4842.9	4730.8	5833.6	NA	NA	22276.8	23019.1	24972.5	39691.3	NA	NA	NA	0.1	1	0.6	0.6	0.6	interpolated	benchmark	market	no	NA	NA	0.8	0.1	0.3	0.3	-0.4	0	0.7	0.9	0.3	0.5	0.5	1.0
SLV-1988	El Salvador	SLV	1988	US Dollar	5382.8	5085.7	5.1	1.5	NA	1.6	5001.6	5500.9	5166.4	4977.9	6169.6	NA	NA	22636.8	23238.7	25760.6	40608.0	NA	NA	NA	0.1	1	0.7	0.7	0.7	interpolated	benchmark	market	no	NA	NA	0.7	0.1	0.3	0.2	-0.3	0	0.8	0.9	0.4	0.5	0.5	1.0
SLV-1989	El Salvador	SLV	1989	US Dollar	5545.0	5135.8	5.2	1.6	NA	1.6	5268.3	5894.9	5337.0	5043.7	6527.5	NA	NA	22874.4	23690.6	26922.2	41774.4	NA	NA	NA	0.1	1	0.8	0.8	0.8	interpolated	benchmark	market	no	NA	NA	0.8	0.1	0.3	0.2	-0.4	0	0.9	1.0	0.4	0.5	0.5	1.1
SLV-1990	El Salvador	SLV	1990	US Dollar	5535.1	4805.5	5.3	1.7	NA	1.6	5606.0	6046.1	5366.2	4701.3	6861.5	NA	NA	23652.0	24139.1	26146.8	42318.5	NA	NA	NA	0.1	1	0.8	0.9	1.0	interpolated	benchmark	market	no	NA	NA	0.9	0.1	0.3	0.4	-0.7	0	1.0	1.5	0.4	0.5	0.5	1.5
SLV-1991	El Salvador	SLV	1991	US Dollar	5936.1	4939.2	5.3	1.7	NA	1.7	5953.3	6498.0	5734.9	4986.1	7202.9	NA	NA	24497.9	24876.0	27400.7	43371.3	NA	NA	NA	0.0	1	0.9	0.9	1.1	interpolated	benchmark	market	no	NA	NA	0.9	0.1	0.3	0.3	-0.6	0	1.0	1.5	0.4	0.5	0.5	1.5
SLV-1992	El Salvador	SLV	1992	US Dollar	6504.2	5411.8	5.4	1.8	NA	1.7	6571.2	7304.6	6278.4	5206.1	7687.2	NA	NA	26345.8	26750.5	30236.2	45022.5	NA	NA	NA	0.0	1	0.9	0.9	1.1	interpolated	benchmark	market	no	NA	NA	1.0	0.1	0.3	0.4	-0.8	0	1.0	1.5	0.4	0.5	0.5	1.6
SLV-1993	El Salvador	SLV	1993	US Dollar	7346.2	6345.9	5.5	1.9	NA	1.7	7273.7	8122.3	7078.1	6101.3	8461.3	NA	NA	28287.4	28806.2	32671.1	47214.1	NA	NA	NA	0.0	1	0.9	1.0	1.1	interpolated	benchmark	market	no	NA	NA	1.0	0.1	0.2	0.4	-0.8	0	1.0	1.5	0.4	0.5	0.5	1.6
SLV-1994	El Salvador	SLV	1994	US Dollar	8207.6	6780.7	5.5	2.0	NA	1.7	8116.9	9098.4	7895.2	6775.1	9419.2	NA	NA	29998.9	30968.7	35479.2	49824.1	NA	NA	NA	0.0	1	1.0	1.0	1.2	interpolated	benchmark	market	no	NA	NA	1.0	0.1	0.2	0.5	-0.8	0	1.1	1.6	0.5	0.5	0.5	1.6
SLV-1995	El Salvador	SLV	1995	US Dollar	9318.7	7888.3	5.6	2.0	NA	1.8	9281.1	10435.2	8986.6	7913.0	10640.5	NA	NA	31917.8	33815.8	39097.1	53000.3	NA	NA	NA	0.1	1	1.0	1.1	1.2	interpolated	benchmark	market	no	NA	NA	1.0	0.1	0.2	0.5	-0.8	0	1.1	1.6	0.5	0.5	0.6	1.6
SLV-1996	El Salvador	SLV	1996	US Dollar	9934.7	8648.7	5.6	2.0	NA	1.8	9901.1	10819.8	9587.3	8671.4	11636.6	NA	NA	32462.1	34372.5	38158.6	55270.5	NA	NA	NA	0.0	1	1.0	1.1	1.2	interpolated	benchmark	market	no	NA	NA	1.0	0.1	0.2	0.5	-0.7	0	1.1	1.7	0.6	0.5	0.6	1.6
SLV-1997	El Salvador	SLV	1997	US Dollar	10865.0	9510.3	5.7	2.0	NA	1.8	10656.5	11679.9	10460.3	9594.2	12896.6	NA	NA	33840.6	35405.3	39482.6	57859.7	NA	NA	NA	0.0	1	1.0	1.1	1.2	interpolated	benchmark	market	no	NA	NA	0.9	0.1	0.2	0.6	-0.8	0	1.1	1.6	0.6	0.5	0.5	1.5
SLV-1998	El Salvador	SLV	1998	US Dollar	11822.4	9966.7	5.7	2.1	NA	1.8	11420.5	12730.7	11336.9	10310.1	14480.6	NA	NA	35109.2	36252.9	41511.2	60866.6	NA	NA	NA	0.0	1	1.0	1.1	1.2	interpolated	benchmark	market	no	NA	NA	0.9	0.1	0.2	0.6	-0.8	0	1.1	1.6	0.6	0.5	0.5	1.4
SLV-1999	El Salvador	SLV	1999	US Dollar	12738.6	10614.2	5.8	2.1	NA	1.9	12412.8	13745.8	12235.4	11020.9	16210.3	NA	NA	36320.1	37471.4	42427.1	63673.3	NA	NA	NA	0.0	1	1.0	1.0	1.1	interpolated	benchmark	market	no	NA	66.7	0.9	0.1	0.2	0.6	-0.8	0	1.0	1.5	0.6	0.5	0.5	1.4
SLV-2000	El Salvador	SLV	2000	US Dollar	13578.5	11809.7	5.8	2.2	NA	1.9	13529.3	15016.8	13054.3	11989.0	18214.9	NA	NA	37102.0	38822.0	43901.1	66648.9	NA	NA	NA	0.0	1	1.0	1.0	1.1	interpolated	benchmark	market	no	NA	NA	0.9	0.1	0.2	0.7	-0.9	0	1.0	1.5	0.6	0.5	0.5	1.3
SLV-2001	El Salvador	SLV	2001	US Dollar	14789.4	12413.9	5.8	2.2	NA	1.9	14839.5	16534.2	14277.9	12443.0	20437.5	NA	NA	37736.0	40093.4	45452.2	69572.9	NA	NA	NA	0.0	1	0.9	1.0	1.1	interpolated	benchmark	market	no	NA	NA	1.0	0.1	0.2	0.6	-1.0	0	1.0	1.4	0.6	0.4	0.5	1.2
SLV-2002	El Salvador	SLV	2002	US Dollar	16034.2	13837.7	5.9	2.2	NA	1.9	15961.1	17768.1	15489.5	13999.2	22973.8	NA	NA	38619.3	40673.9	45837.0	72607.6	NA	NA	NA	0.0	1	0.9	0.9	1.0	interpolated	benchmark	market	no	NA	NA	1.0	0.1	0.2	0.6	-0.9	0	0.9	1.3	0.6	0.5	0.5	1.2
SLV-2003	El Salvador	SLV	2003	US Dollar	17350.3	15385.3	5.9	2.2	NA	1.9	17365.4	19451.2	16781.8	15672.6	26116.7	NA	NA	39507.7	41409.5	47055.9	75721.6	NA	NA	NA	0.0	1	0.9	0.9	1.0	interpolated	benchmark	market	no	NA	NA	0.9	0.1	0.2	0.5	-0.8	0	0.9	1.2	0.6	0.5	0.5	1.1
SLV-2004	El Salvador	SLV	2004	US Dollar	18765.1	16650.4	5.9	2.2	NA	1.9	19149.9	21319.1	18169.0	16952.9	30179.8	NA	NA	40238.8	42535.2	47876.0	78393.3	NA	NA	NA	0.0	1	0.8	0.9	0.9	interpolated	benchmark	market	no	NA	68.3	1.0	0.1	0.2	0.5	-0.7	0	0.9	1.2	0.5	0.5	0.6	1.0
SLV-2005	El Salvador	SLV	2005	US Dollar	20962.3	19788.2	5.9	2.2	NA	1.9	22115.6	24575.9	20735.3	19766.1	35501.4	NA	NA	41672.3	44661.0	50177.7	81070.2	NA	NA	NA	0.0	1	0.8	0.8	0.9	interpolated	benchmark	market	no	NA	71.7	1.0	0.1	0.2	0.4	-0.7	0	0.8	1.1	0.5	0.5	0.6	0.9
SLV-2006	El Salvador	SLV	2006	US Dollar	23670.1	22070.8	6.0	2.3	NA	2.0	25040.7	28038.2	23271.1	22347.1	42250.0	NA	NA	43302.6	46758.6	53000.1	84467.6	NA	NA	NA	0.0	1	0.8	0.8	0.8	interpolated	benchmark	market	no	NA	71.7	1.0	0.1	0.1	0.4	-0.6	0	0.8	1.0	0.5	0.6	0.6	0.8
SLV-2007	El Salvador	SLV	2007	US Dollar	26954.1	25463.7	6.0	2.4	NA	2.0	29046.2	32438.3	26499.2	25836.9	49601.4	NA	NA	44965.5	49451.0	55837.3	88289.6	NA	NA	NA	0.0	1	0.7	0.8	0.8	interpolated	benchmark	market	no	NA	73.3	1.0	0.1	0.1	0.3	-0.6	0	0.8	1.0	0.5	0.6	0.6	0.7
SLV-2008	El Salvador	SLV	2008	US Dollar	30053.3	28863.7	6.0	2.4	NA	2.0	33050.3	36672.1	29859.2	28644.2	57652.1	NA	NA	45538.1	50258.5	56225.4	91446.3	NA	NA	NA	0.0	1	0.7	0.7	0.7	interpolated	benchmark	market	no	NA	83.3	1.0	0.1	0.1	0.3	-0.6	0	0.7	0.9	0.5	0.7	0.7	0.7
SLV-2009	El Salvador	SLV	2009	US Dollar	32585.9	31136.0	6.0	2.4	NA	2.0	33882.8	37215.6	32227.4	31383.5	66042.6	NA	NA	44111.4	45806.5	50506.8	92998.6	NA	NA	NA	0.0	1	0.6	0.6	0.7	interpolated	benchmark	market	no	NA	83.3	0.9	0.1	0.1	0.2	-0.4	0	0.6	0.8	0.5	0.7	0.6	0.7
SLV-2010	El Salvador	SLV	2010	US Dollar	37684.8	37108.7	6.0	2.4	NA	2.0	39829.3	43812.2	37471.9	37264.9	77955.6	NA	NA	44713.6	46830.7	51644.9	94734.9	NA	NA	NA	0.0	1	0.6	0.6	0.6	interpolated	benchmark	market	no	NA	90.0	0.9	0.1	0.1	0.2	-0.4	0	0.6	0.7	0.5	0.7	0.6	0.6
SLV-2011	El Salvador	SLV	2011	US Dollar	45166.8	45704.8	6.1	2.4	NA	2.0	48017.3	53605.3	45166.8	45704.8	97264.7	NA	NA	45704.8	48017.3	53605.3	97264.7	NA	NA	NA	0.0	1	0.5	0.5	0.5	benchmark	benchmark	market	no	0.6	85.6	0.9	0.1	0.1	0.2	-0.4	0	0.5	0.6	0.5	0.7	0.6	0.5
SLV-2012	El Salvador	SLV	2012	US Dollar	46164.4	47179.4	6.1	2.5	NA	2.1	49225.0	54663.9	46147.6	46956.7	99345.6	NA	NA	46564.6	49170.9	54642.7	99598.2	NA	NA	NA	0.0	1	0.5	0.5	0.5	extrapolated	benchmark	market	no	NA	91.0	0.9	0.1	0.1	0.2	-0.4	0	0.5	0.6	0.5	0.7	0.6	0.5
SLV-2013	El Salvador	SLV	2013	US Dollar	46742.5	47393.0	6.1	2.6	NA	2.1	49761.2	55572.1	46618.4	47147.3	103172.3	NA	NA	47424.4	49694.7	55754.1	102483.9	NA	NA	NA	0.0	1	0.5	0.5	0.5	extrapolated	benchmark	market	no	NA	91.1	0.9	0.1	0.1	0.2	-0.4	0	0.5	0.6	0.5	0.7	0.6	0.5
SLV-2014	El Salvador	SLV	2014	US Dollar	47903.3	48970.3	6.1	2.6	NA	2.1	50944.9	56342.7	47846.7	48643.6	107174.8	NA	NA	48350.4	50767.7	56361.1	104730.7	NA	NA	NA	0.0	1	0.5	0.5	0.5	extrapolated	benchmark	market	no	NA	91.1	0.9	0.1	0.1	0.2	-0.3	0	0.5	0.6	0.6	0.7	0.6	0.5

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.

Funcion_variables_trade_detaill <- function(country,anio_inicio_1,anio_final_2) {
  pwt9.0 %>% filter(country==!!country,year>=anio_inicio_1,year<=anio_final_2) %>%
    select(country,
           year, 
           pl_x,pl_m,
           csh_x,csh_m)-> pais_periodo_1
  pais_periodo_1
}
Funcion_variables_trade_detaill(country = "Argentina",anio_inicio = 1950,anio_final = 2014) %>%
 kable(caption = "Probando Función consulta Trade detail, ARG 1990-2014",
 digits = 1,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)

Probando Función consulta Trade detail, ARG 1990-2014

	country	year	pl_x	pl_m	csh_x	csh_m
ARG-1950	Argentina	1950	0.1	0.1	0.1	-0.1
ARG-1951	Argentina	1951	0.2	0.1	0.1	-0.1
ARG-1952	Argentina	1952	0.1	0.1	0.1	-0.1
ARG-1953	Argentina	1953	0.1	0.1	0.1	0.0
ARG-1954	Argentina	1954	0.1	0.1	0.1	0.0
ARG-1955	Argentina	1955	0.1	0.1	0.1	-0.1
ARG-1956	Argentina	1956	0.2	0.2	0.1	0.0
ARG-1957	Argentina	1957	0.2	0.2	0.1	0.0
ARG-1958	Argentina	1958	0.2	0.2	0.1	0.0
ARG-1959	Argentina	1959	0.2	0.3	0.1	0.0
ARG-1960	Argentina	1960	0.2	0.2	0.1	-0.1
ARG-1961	Argentina	1961	0.2	0.2	0.1	-0.1
ARG-1962	Argentina	1962	0.1	0.3	0.1	-0.1
ARG-1963	Argentina	1963	0.2	0.3	0.1	0.0
ARG-1964	Argentina	1964	0.2	0.2	0.1	-0.1
ARG-1965	Argentina	1965	0.2	0.2	0.1	-0.1
ARG-1966	Argentina	1966	0.2	0.2	0.1	0.0
ARG-1967	Argentina	1967	0.2	0.3	0.1	0.0
ARG-1968	Argentina	1968	0.3	0.3	0.1	0.0
ARG-1969	Argentina	1969	0.2	0.3	0.1	0.0
ARG-1970	Argentina	1970	0.2	0.3	0.1	-0.1
ARG-1971	Argentina	1971	0.3	0.3	0.1	-0.1
ARG-1972	Argentina	1972	0.3	0.4	0.0	0.0
ARG-1973	Argentina	1973	0.3	0.3	0.0	0.0
ARG-1974	Argentina	1974	0.3	0.3	0.0	0.0
ARG-1975	Argentina	1975	0.3	0.3	0.1	-0.1
ARG-1976	Argentina	1976	0.3	0.4	0.1	0.0
ARG-1977	Argentina	1977	0.3	0.5	0.1	-0.1
ARG-1978	Argentina	1978	0.3	0.4	0.1	-0.1
ARG-1979	Argentina	1979	0.2	0.3	0.1	-0.1
ARG-1980	Argentina	1980	0.2	0.2	0.1	-0.1
ARG-1981	Argentina	1981	0.3	0.3	0.1	-0.1
ARG-1982	Argentina	1982	0.4	0.5	0.1	-0.1
ARG-1983	Argentina	1983	0.4	0.5	0.1	-0.1
ARG-1984	Argentina	1984	0.4	0.4	0.1	-0.1
ARG-1985	Argentina	1985	0.4	0.4	0.2	-0.1
ARG-1986	Argentina	1986	0.4	0.5	0.1	-0.1
ARG-1987	Argentina	1987	0.5	0.5	0.1	-0.1
ARG-1988	Argentina	1988	0.5	0.5	0.1	-0.1
ARG-1989	Argentina	1989	0.5	0.5	0.1	0.0
ARG-1990	Argentina	1990	0.5	0.5	0.1	0.0
ARG-1991	Argentina	1991	0.6	0.6	0.1	-0.1
ARG-1992	Argentina	1992	0.5	0.5	0.1	-0.1
ARG-1993	Argentina	1993	0.5	0.5	0.1	-0.1
ARG-1994	Argentina	1994	0.5	0.6	0.1	-0.1
ARG-1995	Argentina	1995	0.6	0.6	0.1	-0.1
ARG-1996	Argentina	1996	0.6	0.6	0.1	-0.1
ARG-1997	Argentina	1997	0.6	0.6	0.1	-0.1
ARG-1998	Argentina	1998	0.5	0.5	0.1	-0.1
ARG-1999	Argentina	1999	0.5	0.5	0.1	-0.1
ARG-2000	Argentina	2000	0.5	0.5	0.1	-0.1
ARG-2001	Argentina	2001	0.5	0.5	0.1	-0.1
ARG-2002	Argentina	2002	0.5	0.5	0.1	0.0
ARG-2003	Argentina	2003	0.5	0.5	0.1	-0.1
ARG-2004	Argentina	2004	0.6	0.5	0.1	-0.1
ARG-2005	Argentina	2005	0.6	0.6	0.1	-0.1
ARG-2006	Argentina	2006	0.6	0.6	0.1	-0.1
ARG-2007	Argentina	2007	0.7	0.6	0.1	-0.1
ARG-2008	Argentina	2008	0.7	0.7	0.1	-0.1
ARG-2009	Argentina	2009	0.7	0.6	0.1	-0.1
ARG-2010	Argentina	2010	0.7	0.7	0.1	-0.1
ARG-2011	Argentina	2011	0.8	0.7	0.1	-0.1
ARG-2012	Argentina	2012	0.7	0.7	0.1	-0.1
ARG-2013	Argentina	2013	0.8	0.7	0.1	-0.1
ARG-2014	Argentina	2014	0.7	0.7	0.1	-0.1

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_pais_periodo(country = c("Mexico","Canada"),anio_inicio = 2000,anio_final = 2014)->dataframe_1
print(dataframe_1)%>%
 kable(caption = "Probando Función consulta paises, Mexico y Canada 2000-2014",
 digits = 1,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

Probando Función consulta paises, Mexico y Canada 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	31.0	15.1	1768.0	3.5	814203.9	1079932	1145022	1144414	3268334	0.9	0.8	1190649	782785.5	1041029	3905941	1.0	0.9	0.6	0	1.5	0.7	0.6	0.6	interpolated	benchmark	market	no	NA	NA	0.6	0.2	0.2	0.4	-0.4	0	0.6	0.5	0.8	0.5	0.5	0.6
CAN-2003	Canada	CAN	2003	Canadian Dollar	1211094	1184269	31.6	15.8	1732.1	3.5	858441.9	1148489	1194611	1200543	3349291	0.9	0.8	1247575	832796.8	1119539	4151862	1.0	0.9	0.6	0	1.4	0.8	0.7	0.7	interpolated	benchmark	market	no	NA	NA	0.6	0.2	0.2	0.4	-0.3	0	0.7	0.6	1.0	0.6	0.6	0.8
CAN-2005	Canada	CAN	2005	Canadian Dollar	1311424	1323181	32.3	16.4	1739.2	3.6	918976.9	1263380	1315081	1326233	3865556	0.9	0.8	1327435	882079.1	1221829	4462552	1.0	1.0	0.6	0	1.2	0.9	0.9	0.9	benchmark	benchmark	market	no	0.9	NA	0.5	0.3	0.1	0.4	-0.4	0	0.9	0.8	1.1	0.6	0.6	0.9
CAN-2007	Canada	CAN	2007	Canadian Dollar	1376870	1384391	33.0	17.3	1724.7	3.6	969776.7	1342214	1370408	1395106	4445640	0.9	0.8	1389595	950916.3	1319552	4812567	1.0	1.0	0.6	0	1.1	1.1	1.1	1.0	interpolated	benchmark	market	no	NA	NA	0.5	0.3	0.2	0.4	-0.4	0	1.1	0.9	1.3	0.7	0.7	1.1
CAN-2009	Canada	CAN	2009	Canadian Dollar	1310934	1304883	33.7	17.4	1678.5	3.6	1000717.9	1325223	1306457	1323073	4794360	0.8	0.8	1367808	994270.1	1323141	5106391	1.0	1.0	0.6	0	1.1	1.1	1.0	1.0	interpolated	benchmark	market	no	NA	NA	0.6	0.2	0.2	0.3	-0.3	0	1.0	0.9	1.3	0.7	0.7	1.0
CAN-2011	Canada	CAN	2011	Canadian Dollar	1423920	1455816	34.5	18.1	1683.6	3.7	1045868.8	1440603	1423920	1455816	5427466	0.8	0.8	1455816	1045868.8	1440603	5427466	1.0	1.0	0.6	0	1.0	1.3	1.3	1.2	benchmark	benchmark	market	no	0.8	NA	0.5	0.3	0.2	0.4	-0.4	0	1.3	1.1	1.5	0.7	0.7	1.2
CAN-2013	Canada	CAN	2013	Canadian Dollar	1478439	1493624	35.2	18.7	1682.7	3.7	1086339.8	1488701	1465085	1472069	5828469	0.8	0.8	1513537	1084256.5	1500049	5779532	1.0	1.0	0.6	0	1.0	1.3	1.3	1.2	extrapolated	benchmark	market	no	NA	NA	0.6	0.3	0.2	0.4	-0.4	0	1.2	1.1	1.5	0.7	0.7	1.1
MEX-2000	Mexico	MEX	2000	Mexican Peso	1241567	1203299	102.8	38.6	2174.0	2.4	976115.5	1233276	1210525	1196573	2683662	0.7	0.7	1458667	1084404.0	1414794	3850000	1.1	1.1	0.5	0	9.5	0.5	0.5	0.5	interpolated	benchmark	market	no	NA	NA	0.7	0.2	0.1	0.3	-0.3	0	0.5	0.6	0.4	0.5	0.5	0.7
MEX-2002	Mexico	MEX	2002	Mexican Peso	1265801	1217542	105.6	39.6	2196.1	2.5	1021844.4	1259728	1243224	1219592	2552782	0.7	0.7	1469444	1119252.6	1433203	4150159	1.1	1.0	0.5	0	9.7	0.6	0.6	0.6	benchmark	benchmark	market	no	NA	NA	0.7	0.2	0.1	0.3	-0.3	0	0.6	0.7	0.5	0.5	0.5	0.8
MEX-2004	Mexico	MEX	2004	Mexican Peso	1399936	1345215	108.3	41.2	2123.4	2.5	1114709.0	1384239	1376237	1344221	3077106	0.7	0.7	1552597	1225134.2	1551886	4461555	1.1	1.1	0.4	0	11.3	0.5	0.6	0.6	interpolated	benchmark	market	no	NA	74.4	0.7	0.2	0.1	0.2	-0.3	0	0.6	0.6	0.5	0.6	0.5	0.7
MEX-2006	Mexico	MEX	2006	Mexican Peso	1581637	1542631	111.4	43.1	2141.3	2.5	1244907.5	1576208	1571088	1546752	3770402	0.7	0.7	1679987	1343449.2	1719133	4852529	1.1	1.1	0.4	0	10.9	0.6	0.6	0.6	interpolated	benchmark	market	no	NA	68.9	0.7	0.2	0.1	0.3	-0.3	0	0.6	0.7	0.5	0.6	0.6	0.7
MEX-2008	Mexico	MEX	2008	Mexican Peso	1693705	1677677	115.0	45.0	2173.4	2.6	1345486.1	1729921	1692513	1672410	4036200	0.7	0.7	1758094	1411593.2	1826431	5305337	1.1	1.1	0.4	0	11.1	0.6	0.7	0.7	interpolated	benchmark	market	no	NA	77.8	0.7	0.2	0.2	0.2	-0.3	0	0.7	0.7	0.5	0.7	0.7	0.8
MEX-2010	Mexico	MEX	2010	Mexican Peso	1734610	1694514	118.6	48.3	2128.0	2.6	1381195.4	1742997	1728535	1697135	5054693	0.6	0.6	1761765	1405425.9	1779081	5671746	1.0	1.0	0.4	0	12.6	0.6	0.6	0.6	interpolated	benchmark	market	no	NA	85.6	0.6	0.2	0.2	0.2	-0.3	0	0.7	0.6	0.4	0.7	0.7	0.6
MEX-2012	Mexico	MEX	2012	Mexican Peso	1908250	1862729	122.1	50.8	2106.9	2.6	1535906.1	1947835	1903657	1851572	6089364	0.6	0.6	1904764	1537147.2	1954599	6096434	1.0	1.0	0.4	0	13.2	0.6	0.6	0.6	extrapolated	benchmark	market	no	NA	88.0	0.6	0.2	0.2	0.3	-0.3	0	0.7	0.7	0.4	0.7	0.7	0.6
MEX-2014	Mexico	MEX	2014	Mexican Peso	1987688	1945966	125.4	51.4	2136.8	2.7	1602949.4	2009978	1974138	1934006	6677512	0.6	0.6	1974418	1601032.4	2025506	6498114	1.0	1.0	0.4	0	13.3	0.6	0.7	0.7	extrapolated	benchmark	market	no	NA	85.6	0.6	0.2	0.2	0.3	-0.3	0	0.7	0.7	0.4	0.8	0.7	0.6

#
Funcion_variables_trade_detaill(country = c("Mexico","Canada"),anio_inicio = 2000,anio_final = 2014)->dataframe_2
print(dataframe_2)%>%
 kable(caption = "Probando Función consulta paises, Mexico y Canada 2000-2014",
 digits = 1,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

Probando Función consulta paises, Mexico y Canada 2000-2014

	country	year	pl_x	pl_m	csh_x	csh_m
CAN-2001	Canada	2001	0.5	0.5	0.4	-0.4
CAN-2003	Canada	2003	0.6	0.6	0.4	-0.3
CAN-2005	Canada	2005	0.6	0.6	0.4	-0.4
CAN-2007	Canada	2007	0.7	0.7	0.4	-0.4
CAN-2009	Canada	2009	0.7	0.7	0.3	-0.3
CAN-2011	Canada	2011	0.7	0.7	0.4	-0.4
CAN-2013	Canada	2013	0.7	0.7	0.4	-0.4
MEX-2000	Mexico	2000	0.5	0.5	0.3	-0.3
MEX-2002	Mexico	2002	0.5	0.5	0.3	-0.3
MEX-2004	Mexico	2004	0.6	0.5	0.2	-0.3
MEX-2006	Mexico	2006	0.6	0.6	0.3	-0.3
MEX-2008	Mexico	2008	0.7	0.7	0.2	-0.3
MEX-2010	Mexico	2010	0.7	0.7	0.2	-0.3
MEX-2012	Mexico	2012	0.7	0.7	0.3	-0.3
MEX-2014	Mexico	2014	0.8	0.7	0.3	-0.3

#5 #### 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.

# Haciendo la funcion
options(scipen = 999999)
Funcion_pais_periodo_1 <- 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  1950-2014
Funcion_pais_periodo(country = "Guatemala",anio_inicio = 1990,anio_final = 2014) %>%
 kable(caption = "Probando Función consulta paises, Guatemala 1990-2014",
 digits = 1,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)

Probando Función consulta paises, 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_variables_Labor_detail <- function(country,anio_inicio_1,anio_final_2) {
  pwt9.0 %>% filter(country==!!country,year>=anio_inicio_1,year<=anio_final_2) %>%
    select(country,year,emp, avh, hc, labsh)-> pais_periodo_1
  pais_periodo_1
}
Funcion_variables_Labor_detail(country = "Argentina",anio_inicio = 1950,anio_final = 2014) %>%
 kable(caption = "Probando Función consulta Trade detail, ARG 1990-2014",
 digits = 1,align = "l") %>%
 kable_styling(bootstrap_options = "striped",
 full_width = TRUE)

Probando Función consulta Trade detail, ARG 1990-2014

	country	year	emp	avh	hc	labsh
ARG-1950	Argentina	1950	6.5	2034.0	1.8	0.5
ARG-1951	Argentina	1951	6.7	2037.9	1.8	0.5
ARG-1952	Argentina	1952	6.8	2041.7	1.8	0.5
ARG-1953	Argentina	1953	6.9	2045.6	1.9	0.5
ARG-1954	Argentina	1954	7.0	2049.5	1.9	0.5
ARG-1955	Argentina	1955	7.1	2053.4	1.9	0.5
ARG-1956	Argentina	1956	7.2	2057.3	1.9	0.5
ARG-1957	Argentina	1957	7.3	2061.2	1.9	0.5
ARG-1958	Argentina	1958	7.4	2065.1	1.9	0.5
ARG-1959	Argentina	1959	7.5	2069.1	1.9	0.5
ARG-1960	Argentina	1960	7.6	2073.0	2.0	0.5
ARG-1961	Argentina	1961	7.7	2066.2	2.0	0.5
ARG-1962	Argentina	1962	7.8	2059.4	2.0	0.5
ARG-1963	Argentina	1963	7.9	2052.7	2.0	0.5
ARG-1964	Argentina	1964	8.0	2045.9	2.0	0.5
ARG-1965	Argentina	1965	8.1	2039.2	2.0	0.5
ARG-1966	Argentina	1966	8.2	2032.5	2.0	0.5
ARG-1967	Argentina	1967	8.3	2025.9	2.0	0.5
ARG-1968	Argentina	1968	8.4	2019.2	2.0	0.5
ARG-1969	Argentina	1969	8.5	2012.6	2.1	0.5
ARG-1970	Argentina	1970	8.6	2006.0	2.1	0.5
ARG-1971	Argentina	1971	8.6	2002.7	2.1	0.5
ARG-1972	Argentina	1972	8.7	1999.3	2.1	0.5
ARG-1973	Argentina	1973	8.8	1996.0	2.1	0.5
ARG-1974	Argentina	1974	9.1	1992.8	2.2	0.5
ARG-1975	Argentina	1975	9.2	1989.7	2.2	0.5
ARG-1976	Argentina	1976	9.2	1986.5	2.2	0.5
ARG-1977	Argentina	1977	9.4	1983.4	2.2	0.5
ARG-1978	Argentina	1978	9.5	1980.3	2.2	0.5
ARG-1979	Argentina	1979	9.6	1977.1	2.2	0.5
ARG-1980	Argentina	1980	9.6	1974.0	2.3	0.5
ARG-1981	Argentina	1981	9.7	1961.2	2.3	0.5
ARG-1982	Argentina	1982	9.8	1948.5	2.3	0.5
ARG-1983	Argentina	1983	10.1	1935.9	2.4	0.5
ARG-1984	Argentina	1984	10.3	1923.4	2.4	0.5
ARG-1985	Argentina	1985	10.4	1911.0	2.4	0.5
ARG-1986	Argentina	1986	10.7	1898.6	2.4	0.5
ARG-1987	Argentina	1987	11.0	1886.3	2.5	0.5
ARG-1988	Argentina	1988	11.2	1874.1	2.5	0.5
ARG-1989	Argentina	1989	11.3	1862.0	2.5	0.5
ARG-1990	Argentina	1990	11.6	1850.0	2.5	0.5
ARG-1991	Argentina	1991	12.0	1838.0	2.6	0.5
ARG-1992	Argentina	1992	12.1	1826.0	2.6	0.5
ARG-1993	Argentina	1993	12.1	1850.3	2.6	0.5
ARG-1994	Argentina	1994	12.1	1875.0	2.6	0.5
ARG-1995	Argentina	1995	11.5	1897.2	2.6	0.5
ARG-1996	Argentina	1996	11.8	1846.1	2.6	0.4
ARG-1997	Argentina	1997	12.4	1917.3	2.6	0.4
ARG-1998	Argentina	1998	12.9	1903.0	2.6	0.4
ARG-1999	Argentina	1999	13.0	1893.2	2.6	0.5
ARG-2000	Argentina	2000	13.1	1861.0	2.7	0.5
ARG-2001	Argentina	2001	13.0	1803.4	2.7	0.5
ARG-2002	Argentina	2002	13.0	1610.6	2.7	0.4
ARG-2003	Argentina	2003	13.7	1719.4	2.7	0.4
ARG-2004	Argentina	2004	14.7	1739.7	2.8	0.4
ARG-2005	Argentina	2005	15.3	1755.3	2.8	0.4
ARG-2006	Argentina	2006	15.9	1809.4	2.8	0.4
ARG-2007	Argentina	2007	16.4	1816.9	2.8	0.4
ARG-2008	Argentina	2008	16.8	1835.9	2.8	0.4
ARG-2009	Argentina	2009	17.0	1736.9	2.8	0.4
ARG-2010	Argentina	2010	17.5	1728.7	2.8	0.4
ARG-2011	Argentina	2011	17.9	1762.3	2.9	0.4
ARG-2012	Argentina	2012	18.1	1789.0	2.9	0.4
ARG-2013	Argentina	2013	18.3	1776.7	2.9	0.4
ARG-2014	Argentina	2014	18.1	1776.7	2.9	0.4

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_pais_periodo_1(country = c("United States of America","Canada"),anio_inicio = 2000,anio_final = 2014)->dataframe_1_2
print(dataframe_1_2)%>%
 kable(caption = "Probando Función consulta paises, EE.UU y Canada 2000-2014",
 digits = 1,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

Probando Función consulta paises, EE.UU y Canada 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	31.0	15.1	1768.0	3.5	814203.9	1079932	1145022	1144414	3268334	0.9	0.8	1190649	782785.5	1041029	3905941	1.0	0.9	0.6	0.0	1.5	0.7	0.6	0.6	interpolated	benchmark	market	no	NA	NA	0.6	0.2	0.2	0.4	-0.4	0	0.6	0.5	0.8	0.5	0.5	0.6
CAN-2003	Canada	CAN	2003	Canadian Dollar	1211094	1184269	31.6	15.8	1732.1	3.5	858441.9	1148489	1194611	1200543	3349291	0.9	0.8	1247575	832796.8	1119539	4151862	1.0	0.9	0.6	0.0	1.4	0.8	0.7	0.7	interpolated	benchmark	market	no	NA	NA	0.6	0.2	0.2	0.4	-0.3	0	0.7	0.6	1.0	0.6	0.6	0.8
CAN-2005	Canada	CAN	2005	Canadian Dollar	1311424	1323181	32.3	16.4	1739.2	3.6	918976.9	1263380	1315081	1326233	3865556	0.9	0.8	1327435	882079.1	1221829	4462552	1.0	1.0	0.6	0.0	1.2	0.9	0.9	0.9	benchmark	benchmark	market	no	0.9	NA	0.5	0.3	0.1	0.4	-0.4	0	0.9	0.8	1.1	0.6	0.6	0.9
CAN-2007	Canada	CAN	2007	Canadian Dollar	1376870	1384391	33.0	17.3	1724.7	3.6	969776.7	1342214	1370408	1395106	4445640	0.9	0.8	1389595	950916.3	1319552	4812567	1.0	1.0	0.6	0.0	1.1	1.1	1.1	1.0	interpolated	benchmark	market	no	NA	NA	0.5	0.3	0.2	0.4	-0.4	0	1.1	0.9	1.3	0.7	0.7	1.1
CAN-2009	Canada	CAN	2009	Canadian Dollar	1310934	1304883	33.7	17.4	1678.5	3.6	1000717.9	1325223	1306457	1323073	4794360	0.8	0.8	1367808	994270.1	1323141	5106391	1.0	1.0	0.6	0.0	1.1	1.1	1.0	1.0	interpolated	benchmark	market	no	NA	NA	0.6	0.2	0.2	0.3	-0.3	0	1.0	0.9	1.3	0.7	0.7	1.0
CAN-2011	Canada	CAN	2011	Canadian Dollar	1423920	1455816	34.5	18.1	1683.6	3.7	1045868.8	1440603	1423920	1455816	5427466	0.8	0.8	1455816	1045868.8	1440603	5427466	1.0	1.0	0.6	0.0	1.0	1.3	1.3	1.2	benchmark	benchmark	market	no	0.8	NA	0.5	0.3	0.2	0.4	-0.4	0	1.3	1.1	1.5	0.7	0.7	1.2
CAN-2013	Canada	CAN	2013	Canadian Dollar	1478439	1493624	35.2	18.7	1682.7	3.7	1086339.8	1488701	1465085	1472069	5828469	0.8	0.8	1513537	1084256.5	1500049	5779532	1.0	1.0	0.6	0.0	1.0	1.3	1.3	1.2	extrapolated	benchmark	market	no	NA	NA	0.6	0.3	0.2	0.4	-0.4	0	1.2	1.1	1.5	0.7	0.7	1.1
USA-2000	United States of America	USA	2000	US Dollar	13222419	13031820	282.9	139.3	1848.1	3.6	9977582.0	13511612	13035321	12983206	35997032	1.0	1.0	12975535	10500206.0	13647352	38439588	0.9	0.9	0.6	0.1	1.0	0.8	0.8	0.8	interpolated	benchmark	market	no	NA	NA	0.7	0.3	0.1	0.1	-0.2	0	0.8	0.7	1.2	0.6	0.6	0.8
USA-2002	United States of America	USA	2002	US Dollar	13591523	13309916	288.5	139.1	1805.5	3.6	10524779.0	14027745	13503168	13339370	38467564	1.0	1.0	13336194	11088529.0	14123900	40679832	0.9	1.0	0.6	0.1	1.0	0.9	0.8	0.8	benchmark	benchmark	market	no	NA	NA	0.7	0.3	0.1	0.1	-0.2	0	0.8	0.7	1.2	0.6	0.6	0.8
USA-2004	United States of America	USA	2004	US Dollar	14499944	14204685	293.5	141.6	1783.4	3.6	11251801.0	15090846	14366189	14232334	42071616	1.0	1.0	14229557	11796878.0	15181932	43024076	1.0	1.0	0.6	0.0	1.0	0.9	0.9	0.9	interpolated	benchmark	market	no	NA	NA	0.7	0.3	0.1	0.1	-0.2	0	0.8	0.7	1.3	0.6	0.7	0.9
USA-2006	United States of America	USA	2006	US Dollar	15353601	15083465	298.9	146.6	1778.5	3.6	12126527.0	16170304	15318001	15099868	47891040	1.0	1.0	15097712	12476968.0	16121374	45671956	1.0	1.0	0.6	0.0	1.0	0.9	0.9	0.9	interpolated	benchmark	market	no	NA	NA	0.7	0.3	0.1	0.1	-0.2	0	0.9	0.8	1.3	0.7	0.7	0.9
USA-2008	United States of America	USA	2008	US Dollar	15357469	15305872	304.5	147.5	1761.3	3.7	12569281.0	16125585	15370500	15321926	50006724	1.0	1.0	15321422	12759836.0	16086510	47779436	1.0	1.0	0.6	0.0	1.0	1.0	1.0	1.0	interpolated	benchmark	market	no	NA	NA	0.7	0.2	0.1	0.1	-0.2	0	0.9	0.9	1.3	0.8	0.8	1.0
USA-2010	United States of America	USA	2010	US Dollar	15368666	15250698	309.9	141.3	1738.0	3.7	12764841.0	15842214	15317448	15273702	48876336	1.0	1.0	15273331	12883714.0	15924426	48728140	1.0	1.0	0.6	0.0	1.0	1.0	1.0	1.0	interpolated	benchmark	market	no	NA	NA	0.7	0.2	0.1	0.1	-0.2	0	0.9	0.9	1.3	0.7	0.8	1.0
USA-2012	United States of America	USA	2012	US Dollar	15976742	15899255	314.8	144.9	1753.7	3.7	13206454.0	16505245	15946878	15863845	50020716	1.0	1.0	15863049	13182059.0	16509182	49960600	1.0	1.0	0.6	0.0	1.0	1.0	1.0	1.0	extrapolated	benchmark	market	no	NA	NA	0.7	0.2	0.1	0.1	-0.2	0	1.0	0.9	1.3	0.8	0.8	1.0
USA-2014	United States of America	USA	2014	US Dollar	16704698	16598099	319.4	148.5	1764.6	3.7	13685949.0	17113208	16605887	16490883	52849892	1.0	1.0	16490192	13585164.0	17137356	51190644	1.0	1.0	0.6	0.0	1.0	1.1	1.0	1.1	extrapolated	benchmark	market	no	NA	NA	0.7	0.2	0.1	0.1	-0.2	0	1.0	1.0	1.4	0.8	0.8	1.1

#
Funcion_variables_Labor_detail(country = c("United States of America","Canada"),anio_inicio = 2000,anio_final = 2014)->dataframe_2_2
print(dataframe_2_2)%>%
 kable(caption = "Probando Función consulta paises, EE.UU y Canada 2000-2014",
 digits = 1,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

Probando Función consulta paises, EE.UU y Canada 2000-2014

	country	year	emp	avh	hc	labsh
CAN-2001	Canada	2001	15.1	1768.0	3.5	0.6
CAN-2003	Canada	2003	15.8	1732.1	3.5	0.6
CAN-2005	Canada	2005	16.4	1739.2	3.6	0.6
CAN-2007	Canada	2007	17.3	1724.7	3.6	0.6
CAN-2009	Canada	2009	17.4	1678.5	3.6	0.6
CAN-2011	Canada	2011	18.1	1683.6	3.7	0.6
CAN-2013	Canada	2013	18.7	1682.7	3.7	0.6
USA-2000	United States of America	2000	139.3	1848.1	3.6	0.6
USA-2002	United States of America	2002	139.1	1805.5	3.6	0.6
USA-2004	United States of America	2004	141.6	1783.4	3.6	0.6
USA-2006	United States of America	2006	146.6	1778.5	3.6	0.6
USA-2008	United States of America	2008	147.5	1761.3	3.7	0.6
USA-2010	United States of America	2010	141.3	1738.0	3.7	0.6
USA-2012	United States of America	2012	144.9	1753.7	3.7	0.6
USA-2014	United States of America	2014	148.5	1764.6	3.7	0.6

#6 #### 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

herramienta_mostrar_2<- function() {
  pwt9.0 %>% group_by(country, year) -> pais_por_periodo_4
  pais_por_periodo_4
}
herramienta_mostrar_2() %>% group_by(country,year) %>% 
  filter(country == "Honduras", year %in% 1990:2014)%>%
  kable(caption = "Datos Para Honduras") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en PWT9.0",
               notation="symbol") %>%  kable_minimal()

Datos Para Honduras

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
Honduras	HND	1990	Lempira	13869.68	14479.95	4.903363	1.212946	NA	1.767629	12349.56	14292.89	14019.55	14777.81	24019.17	0.6273910	0.5990154	15670.49	14036.91	16844.10	46727.57	1.2477888	1.1507260	0.5790429	0.0479281	4.111983	0.2379519	0.2594444	0.2461320	interpolated	benchmark	market	no	NA	NA	0.7289965	0.1315029	0.1066864	0.0737031	-0.1280089	0.0871200	0.2261269	0.3960259	0.3187529	0.5092028	0.4981820	0.3947745
Honduras	HND	1991	Lempira	14668.76	15217.25	5.041050	1.529694	NA	1.778764	12721.95	15095.52	14801.82	15593.70	24835.76	0.5656669	0.5452989	16180.10	14378.00	17783.92	48069.19	1.1127641	1.0493369	0.5790429	0.0484012	5.316667	0.2281345	0.2473101	0.2347512	interpolated	benchmark	market	no	NA	NA	0.7269562	0.1522135	0.0888826	0.0736594	-0.1166072	0.0748955	0.2186105	0.3500882	0.3060299	0.5368614	0.5298529	0.3703450
Honduras	HND	1992	Lempira	15327.71	15702.40	5.179557	1.667114	NA	1.789970	13162.22	15913.10	15452.53	15956.85	26166.61	0.5191000	0.5143396	17090.11	14913.27	18787.75	50292.81	1.0965490	1.0342450	0.5790429	0.0493221	5.497917	0.2450800	0.2639952	0.2556516	interpolated	benchmark	market	no	NA	NA	0.7276504	0.1723951	0.0972129	0.0927137	-0.1384448	0.0484727	0.2344678	0.3544996	0.3245134	0.4984363	0.4783411	0.3800623
Honduras	HND	1993	Lempira	15933.56	17007.75	5.318042	1.716850	NA	1.801246	13556.20	17219.01	16058.67	17298.61	28825.96	0.5295349	0.5196727	18154.83	15235.90	20400.85	53997.58	1.1015327	1.0619862	0.5790429	0.0512118	6.471583	0.2354946	0.2604541	0.2417851	interpolated	benchmark	market	no	NA	NA	0.7042156	0.2117400	0.0794425	0.0770114	-0.1530855	0.0806760	0.2231715	0.3528298	0.3447323	0.4989966	0.4925680	0.3600760
Honduras	HND	1994	Lempira	16221.66	17431.77	5.455481	1.775193	NA	1.812593	13626.76	17519.94	16247.20	17766.09	31565.97	0.5096037	0.4952551	17918.23	15181.68	20793.20	57415.96	1.0302681	1.0257515	0.5790429	0.0534466	8.408758	0.2199179	0.2520298	0.2304830	interpolated	benchmark	market	no	NA	NA	0.6941285	0.2191356	0.0728813	0.0680602	-0.1518366	0.0976310	0.2088324	0.3644269	0.3254969	0.5078282	0.4947444	0.3341411
Honduras	HND	1995	Lempira	17476.45	19391.93	5.591136	1.820764	NA	1.824012	13971.42	17967.27	17503.07	19796.22	33959.80	0.5411949	0.4851948	18649.27	15343.45	21133.80	59646.99	1.0304242	1.0018374	0.5790429	0.0544604	9.470987	0.2488675	0.2699223	0.2386552	interpolated	benchmark	market	no	NA	NA	0.6439156	0.2018491	0.0618464	0.0625456	-0.1704345	0.2002778	0.2358658	0.3435404	0.3842352	0.5298240	0.5120141	0.3707557
Honduras	HND	1996	Lempira	17991.68	18534.55	5.724587	1.969232	NA	1.835503	14862.28	18612.00	17993.62	18919.16	36097.18	0.4727955	0.4591877	19316.62	16146.38	21565.41	62041.05	1.0007118	0.9585197	0.5790429	0.0561350	11.705303	0.2449153	0.2705369	0.2573019	interpolated	benchmark	market	no	NA	NA	0.7196743	0.1981971	0.0658931	0.1251037	-0.1821674	0.0732991	0.2308974	0.3720898	0.3980164	0.5560105	0.5339137	0.3517663
Honduras	HND	1997	Lempira	18783.43	19283.00	5.855946	2.065996	NA	1.847066	15261.00	19375.77	18662.25	19602.26	38919.98	0.4525510	0.4417664	20281.24	16564.65	22439.02	65095.36	0.9939573	0.9435017	0.5790429	0.0583501	13.003474	0.2735510	0.3014578	0.2870017	interpolated	benchmark	market	no	NA	NA	0.7138742	0.2099128	0.0646589	0.1391080	-0.2140427	0.0864889	0.2603426	0.4049597	0.4193795	0.5301754	0.5118002	0.3647384
Honduras	HND	1998	Lempira	19437.26	19877.25	5.985675	2.129612	NA	1.858702	16084.09	20327.30	19169.84	20236.38	42338.37	0.4296251	0.4236698	20869.71	17542.46	23514.27	68522.87	0.9762488	0.9437152	0.5790429	0.0602006	13.385015	0.3027463	0.3274958	0.3102354	interpolated	benchmark	market	no	NA	NA	0.7218101	0.2096821	0.0730008	0.1549506	-0.2585347	0.0990911	0.2869599	0.4213099	0.4588381	0.4888291	0.4843364	0.3920445
Honduras	HND	1999	Lempira	18722.69	19555.42	6.114534	2.278612	NA	1.870411	16175.77	20880.68	18457.55	19883.22	46072.06	0.3832954	0.3911985	20475.37	17648.50	24128.66	72088.17	0.8964342	0.9063278	0.5790429	0.0609560	14.213168	0.3248484	0.3505927	0.3254545	interpolated	benchmark	market	no	NA	60.55556	0.7311782	0.2366271	0.0823608	0.1217707	-0.2738907	0.1019537	0.3076058	0.4391032	0.4779238	0.4809175	0.4909589	0.3880243
Honduras	HND	2000	Lempira	20014.32	21004.32	6.243080	2.277200	NA	1.882193	17440.45	22230.78	19769.88	21097.95	49552.57	0.3855208	0.3903347	21652.33	19076.11	25351.34	74802.02	0.9306372	0.9348506	0.5790429	0.0602743	14.839203	0.3468261	0.3635496	0.3406651	interpolated	benchmark	market	no	NA	NA	0.7356162	0.2270520	0.0910260	0.1101759	-0.2350611	0.0711909	0.3276480	0.4244360	0.5018118	0.4627264	0.5004598	0.3933881
Honduras	HND	2001	Lempira	20637.62	21337.64	6.371304	2.284981	NA	1.899813	18379.90	23177.14	20478.18	21473.39	52978.77	0.3769335	0.3895814	22241.96	19999.78	26027.96	77193.24	0.9438935	0.9476663	0.5914308	0.0595489	15.473667	0.3629830	0.3737027	0.3563830	interpolated	benchmark	market	no	NA	NA	0.7604110	0.2234040	0.0955274	0.1401108	-0.2656095	0.0461564	0.3397452	0.4147735	0.5479591	0.4414564	0.4716410	0.3868796
Honduras	HND	2002	Lempira	21429.86	22322.82	6.499001	2.310051	NA	1.917598	19132.07	23977.57	21306.53	22633.90	56023.19	0.3830226	0.3858492	23077.00	20740.80	26554.17	79013.09	0.9642826	0.9519697	0.5981197	0.0599975	16.433383	0.3626706	0.3689012	0.3472668	interpolated	benchmark	market	no	NA	NA	0.7532266	0.2140816	0.0920571	0.0942259	-0.2711890	0.1175978	0.3379519	0.3935021	0.5649227	0.4526783	0.4684044	0.3726304
Honduras	HND	2003	Lempira	22293.72	23442.71	6.626304	2.358234	NA	1.935549	20103.34	25232.91	22122.40	23866.67	59671.42	0.3844427	0.3856745	24126.32	21692.98	27731.18	81101.34	0.9875214	0.9738438	0.6054907	0.0600904	17.345292	0.3636180	0.3721932	0.3449919	interpolated	benchmark	market	no	NA	NA	0.7478350	0.2149259	0.0944836	0.0856145	-0.2634298	0.1205707	0.3407257	0.4058002	0.5448104	0.4854675	0.4998156	0.3768820
Honduras	HND	2004	Lempira	23503.39	24886.89	6.753352	2.380619	NA	1.953669	21223.06	27632.29	23295.61	25364.89	65749.49	0.3901497	0.4008462	25629.95	22787.18	30171.69	84672.58	1.0192550	1.0294384	0.5971574	0.0608004	18.206221	0.3718025	0.3808016	0.3497357	interpolated	benchmark	market	no	NA	63.88889	0.7415702	0.2526812	0.0951399	0.0903868	-0.2744031	0.0946250	0.3487100	0.4106006	0.5517979	0.5209755	0.5294741	0.3677614
Honduras	HND	2005	Lempira	24863.05	27339.29	6.880181	2.453150	NA	1.971957	23171.71	29687.92	25057.70	27758.67	72955.40	0.4087618	0.4052648	27180.79	24338.38	31628.39	87856.12	1.0415866	1.0398625	0.5903670	0.0612781	18.832342	0.3825670	0.3893809	0.3514934	interpolated	benchmark	market	no	NA	63.33333	0.7344357	0.2347449	0.1003200	0.0887210	-0.2937164	0.1354948	0.3605338	0.4136114	0.5438707	0.5255956	0.5420418	0.3525336
Honduras	HND	2006	Lempira	26591.88	28317.32	7.007029	2.636856	NA	1.990417	25053.55	32155.18	26569.55	28826.40	81215.07	0.3933462	0.4097231	28965.75	26253.87	34069.19	91934.22	1.0388225	1.0482956	0.5845672	0.0620216	18.895208	0.4038720	0.4109026	0.3787326	interpolated	benchmark	market	no	NA	63.33333	0.7675272	0.2463586	0.1015908	0.1177532	-0.3015383	0.0683084	0.3832936	0.4357059	0.5593431	0.5537532	0.5660859	0.3581534
Honduras	HND	2007	Lempira	28196.94	30212.58	7.133737	2.751748	NA	2.009050	26953.74	35926.29	28055.89	30818.34	89601.12	0.3912421	0.4303392	30758.23	28137.40	37910.04	98000.57	1.0444032	1.1044008	0.5925926	0.0633370	18.895100	0.4328700	0.4405943	0.4011008	interpolated	benchmark	market	no	NA	70.00000	0.7655122	0.2911433	0.1090883	0.1275888	-0.3476368	0.0543041	0.4075651	0.4637982	0.6104436	0.6081878	0.6095402	0.3706837
Honduras	HND	2008	Lempira	28689.72	29158.39	7.259470	2.777892	NA	2.027858	28240.20	38256.50	28743.01	29235.60	97798.84	0.3554068	0.4418927	32059.88	29045.71	39696.93	104314.83	1.0532839	1.1189380	0.5936449	0.0619876	18.903758	0.4769719	0.4829600	0.4748228	interpolated	benchmark	market	no	NA	73.33333	0.8429075	0.3426064	0.1230450	0.3158697	-0.4805019	-0.1439269	0.4501883	0.4998433	0.6604503	0.7080935	0.6503295	0.3979344
Honduras	HND	2009	Lempira	29242.94	29286.39	7.383098	2.891410	NA	2.046841	28587.59	34253.79	29066.95	29677.80	100695.90	0.3488050	0.3909848	31280.22	29424.54	35252.21	105943.45	1.0027796	0.9695888	0.5991222	0.0603257	18.895100	0.4962146	0.5018576	0.4915281	interpolated	benchmark	market	no	NA	77.77778	0.8329699	0.1909237	0.1302954	0.1249084	-0.3287673	0.0496698	0.4634882	0.5303282	0.7054326	0.7001138	0.6070395	0.4178108
Honduras	HND	2010	Lempira	30846.39	31120.90	7.503875	2.940079	NA	2.066002	29819.84	36243.63	30734.73	31326.93	104274.56	0.3470534	0.3871138	32447.37	30233.08	36788.32	107767.67	1.0137688	0.9861315	0.6076818	0.0594937	18.895100	0.5101559	0.5153565	0.5056143	interpolated	benchmark	market	no	NA	77.77778	0.8277879	0.2050566	0.1241036	0.1453721	-0.3624463	0.0601261	0.4771446	0.5394980	0.7303461	0.6815198	0.6072651	0.4301115
Honduras	HND	2011	Lempira	32806.54	33691.91	7.621414	3.051567	NA	2.104307	31070.36	39269.93	32806.54	33691.91	110959.42	0.3469205	0.3879624	33691.91	31070.36	39269.93	110959.42	1.0000000	1.0000000	0.6112589	0.0591796	18.917142	0.5341044	0.5398403	0.5256542	benchmark	benchmark	market	no	0.6087185	77.77778	0.8074962	0.2433691	0.1146944	0.1448321	-0.3961623	0.0857706	0.5053933	0.5615748	0.7362428	0.7241395	0.6399552	0.4511802
Honduras	HND	2012	Lempira	33772.98	34601.96	7.736131	3.165068	NA	2.143323	32356.33	40233.31	33701.14	34306.44	114260.53	0.3337609	0.3762115	35082.96	32295.14	40251.67	114391.16	0.9955488	0.9799768	0.6182181	0.0586203	19.502250	0.5429687	0.5497898	0.5400894	extrapolated	benchmark	market	no	NA	76.00000	0.8282939	0.2296066	0.1148623	0.1905468	-0.3827002	0.0193907	0.5126201	0.5778091	0.7618182	0.7184008	0.6585971	0.4533114
Honduras	HND	2013	Lempira	33759.91	33670.28	7.849059	3.276676	NA	2.183062	33565.68	40386.88	33537.50	33307.57	118671.20	0.3102254	0.3633257	36062.30	33478.72	40477.25	117494.66	0.9785456	0.9423326	0.6182181	0.0578064	20.341500	0.5441083	0.5519466	0.5557567	extrapolated	benchmark	market	no	NA	62.22222	0.8854985	0.2047944	0.1222507	0.3223343	-0.4402955	-0.0945822	0.5142024	0.5905170	0.7607258	0.6957347	0.6477398	0.4413261
Honduras	HND	2014	Lempira	35219.24	34835.65	7.961680	3.381201	NA	2.223537	34384.08	41614.70	35008.41	34377.60	123703.28	0.3039389	0.3545439	37174.90	34161.48	41649.40	120378.56	0.9671497	0.9296472	0.6182181	0.0573270	21.008742	0.5489583	0.5569289	0.5671483	extrapolated	benchmark	market	no	NA	73.33333	0.8831683	0.2103293	0.1170201	0.3396600	-0.4747215	-0.0754562	0.5208093	0.5948322	0.7614025	0.6971985	0.6341395	0.4374071
* Elaboracion propia con base en PWT9.0

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á

herramienta_capdetail <- function() {
  pwt9.0 %>% group_by(country,year) %>%
    select(country, year, ck, rkna, pl_k)-> pais_por_periodo_5
  pais_por_periodo_5
}
herramienta_capdetail() %>% group_by(country, year) %>%
  filter(country=="Panama")%>%
  kable(caption = "Datos Para Pananma") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en PWT9.0",
               notation="symbol") %>%  kable_minimal()

Datos Para Pananma

country	year	ck	rkna	pl_k
Panama	1950	3974.410	7910.694	0.1895729
Panama	1951	4069.082	7852.892	0.2021502
Panama	1952	4146.317	7818.988	0.1971682
Panama	1953	4193.964	7919.253	0.1957663
Panama	1954	4124.009	7955.621	0.1870918
Panama	1955	4161.539	8047.854	0.1918661
Panama	1956	4363.727	8225.043	0.1934949
Panama	1957	4487.399	8408.979	0.1946981
Panama	1958	4531.014	8648.259	0.2012523
Panama	1959	4688.309	8946.780	0.2008178
Panama	1960	4690.696	9182.746	0.2128764
Panama	1961	4875.821	9531.828	0.2185971
Panama	1962	5083.905	9964.521	0.2175967
Panama	1963	5296.139	10468.618	0.2168215
Panama	1964	5434.304	10876.881	0.2240854
Panama	1965	5712.339	11372.258	0.2227984
Panama	1966	6161.971	12153.596	0.2248411
Panama	1967	6605.460	12955.637	0.2267878
Panama	1968	7103.503	13884.022	0.2271825
Panama	1969	7759.279	14962.656	0.2271896
Panama	1970	8744.858	16607.580	0.2061746
Panama	1971	9853.147	18485.275	0.2069078
Panama	1972	11258.130	20871.076	0.2001030
Panama	1973	12697.484	23114.242	0.2287317
Panama	1974	14108.166	24912.709	0.2645331
Panama	1975	15473.685	26847.086	0.2768272
Panama	1976	16559.006	28760.000	0.3082120
Panama	1977	17266.492	29532.176	0.3335185
Panama	1978	18411.525	30826.646	0.3568919
Panama	1979	19512.686	32049.455	0.3849082
Panama	1980	20876.895	33797.895	0.4071580
Panama	1981	22641.340	36216.996	0.4083547
Panama	1982	24275.996	38632.230	0.4316643
Panama	1983	24367.436	39796.430	0.4769075
Panama	1984	24464.844	40627.000	0.4421882
Panama	1985	24666.543	41321.047	0.5035912
Panama	1986	25712.543	42623.680	0.4575144
Panama	1987	26721.904	44186.402	0.4708847
Panama	1988	26434.914	43668.590	0.4311623
Panama	1989	25723.736	42711.344	0.4961986
Panama	1990	25448.707	42280.000	0.4910560
Panama	1991	25695.943	43114.359	0.5035272
Panama	1992	26580.908	44983.621	0.5026234
Panama	1993	28817.303	48241.746	0.4818108
Panama	1994	31240.934	51560.621	0.4884358
Panama	1995	34024.902	55079.746	0.4997710
Panama	1996	36206.355	58254.402	0.5104893
Panama	1997	39246.559	61684.645	0.4993010
Panama	1998	43127.160	65850.273	0.5094305
Panama	1999	47489.816	70507.172	0.4654517
Panama	2000	51416.664	74266.586	0.4697045
Panama	2001	53947.656	75946.750	0.4477904
Panama	2002	56263.824	77322.797	0.4288248
Panama	2003	60077.422	79968.250	0.4449924
Panama	2004	65767.672	83185.086	0.4103632
Panama	2005	73176.195	86754.695	0.3986991
Panama	2006	81943.727	91417.508	0.3865827
Panama	2007	92301.109	99499.906	0.5006995
Panama	2008	103622.453	109266.602	0.5405082
Panama	2009	112844.938	117964.953	0.5463454
Panama	2010	124656.469	128348.797	0.5466264
Panama	2011	142056.688	142056.688	0.5664019
Panama	2012	158524.391	159050.125	0.6009493
Panama	2013	179119.078	178155.891	0.4638888
Panama	2014	201345.031	197037.297	0.4705792
* Elaboracion propia con base en PWT9.0

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.

dataframe_usa_ku <- herramienta_mostrar_2() %>%
  filter(country %in% c("United States of America", "United Kingdom"), year %in% 1990:2000)
print(dataframe_usa_ku)%>%
  kable(caption = "Datos Para USA y KU") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en PWT9.0",
               notation="symbol") %>%  kable_minimal()

## # A tibble: 22 x 47
## # Groups:   country, year [22]
##    country isocode  year currency  rgdpe  rgdpo   pop   emp   avh    hc   ccon
##    <fct>   <fct>   <int> <fct>     <dbl>  <dbl> <dbl> <dbl> <dbl> <dbl>  <dbl>
##  1 United~ GBR      1990 Pound S~ 1.42e6 1.39e6  57.1  26.7 1757.  3.20 1.09e6
##  2 United~ GBR      1991 Pound S~ 1.40e6 1.36e6  57.3  25.9 1741.  3.23 1.07e6
##  3 United~ GBR      1992 Pound S~ 1.41e6 1.38e6  57.4  25.3 1711.  3.26 1.08e6
##  4 United~ GBR      1993 Pound S~ 1.46e6 1.43e6  57.6  25.2 1704.  3.29 1.11e6
##  5 United~ GBR      1994 Pound S~ 1.52e6 1.48e6  57.7  25.4 1718.  3.32 1.14e6
##  6 United~ GBR      1995 Pound S~ 1.59e6 1.55e6  57.9  25.7 1726.  3.35 1.17e6
##  7 United~ GBR      1996 Pound S~ 1.67e6 1.64e6  58.1  25.9 1728.  3.38 1.24e6
##  8 United~ GBR      1997 Pound S~ 1.80e6 1.76e6  58.3  26.4 1705.  3.41 1.36e6
##  9 United~ GBR      1998 Pound S~ 1.89e6 1.81e6  58.5  26.7 1720.  3.44 1.44e6
## 10 United~ GBR      1999 Pound S~ 1.96e6 1.88e6  58.7  27.0 1712.  3.48 1.53e6
## # ... with 12 more rows, and 36 more variables: cda <dbl>, cgdpe <dbl>,
## #   cgdpo <dbl>, ck <dbl>, ctfp <dbl>, cwtfp <dbl>, rgdpna <dbl>, rconna <dbl>,
## #   rdana <dbl>, rkna <dbl>, rtfpna <dbl>, rwtfpna <dbl>, labsh <dbl>,
## #   delta <dbl>, xr <dbl>, pl_con <dbl>, pl_da <dbl>, pl_gdpo <dbl>,
## #   i_cig <fct>, i_xm <fct>, i_xr <fct>, i_outlier <fct>, cor_exp <dbl>,
## #   statcap <dbl>, csh_c <dbl>, csh_i <dbl>, csh_g <dbl>, csh_x <dbl>,
## #   csh_m <dbl>, csh_r <dbl>, pl_c <dbl>, pl_i <dbl>, pl_g <dbl>, pl_x <dbl>,
## #   pl_m <dbl>, pl_k <dbl>

Datos Para USA y KU

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
United Kingdom	GBR	1990	Pound Sterling	1417085	1385562	57.11012	26.70239	1757.428	3.197166	1089023	1383493	1389299	1359320	3581698	0.8565159	0.8605587	1454251	1151596	1441845	6776786	0.8450031	0.7902915	0.6305985	0.0448434	0.5631772	0.7784873	0.7868814	0.8042360	interpolated	benchmark	market	no	NA	NA	0.6439415	0.2166304	0.1572114	0.2256019	-0.2834871	0.0401019	0.7423567	0.8179252	0.9264792	0.6048944	0.5832911	1.0969303
United Kingdom	GBR	1991	Pound Sterling	1401382	1363587	57.26460	25.92645	1741.230	3.227114	1069733	1341803	1372772	1344283	3680473	0.8489506	0.8438308	1435970	1141932	1405051	6870655	0.8458234	0.7806858	0.6373916	0.0459844	0.5670153	0.8433968	0.8324515	0.8500934	interpolated	benchmark	market	no	NA	NA	0.6334063	0.2023899	0.1623586	0.1969872	-0.2442199	0.0490779	0.8053111	0.7894166	0.9919796	0.6590320	0.6238792	1.0401849
United Kingdom	GBR	1992	Pound Sterling	1414993	1376120	57.41947	25.34559	1710.730	3.257343	1079084	1364559	1386354	1355717	3798598	0.8363361	0.8363643	1442380	1157180	1430968	6966938	0.8621486	0.8068302	0.6349562	0.0469881	0.5697742	0.8785668	0.8509466	0.8701767	interpolated	benchmark	market	no	NA	NA	0.6331229	0.2105715	0.1628279	0.2457861	-0.2944569	0.0421485	0.8377092	0.7465436	1.0374331	0.5716438	0.5552554	0.9516477
United Kingdom	GBR	1993	Pound Sterling	1464740	1427750	57.57597	25.17171	1703.901	3.287855	1109786	1408161	1434157	1398855	3989535	0.8497868	0.8433889	1480387	1194679	1478699	7066574	0.8810428	0.8301398	0.6174870	0.0482306	0.6667566	0.7705053	0.7401265	0.7588046	interpolated	benchmark	market	no	NA	NA	0.6382427	0.2132991	0.1551104	0.2049004	-0.2565717	0.0450190	0.7349835	0.6271343	0.9166693	0.5840781	0.5459833	0.7636015
United Kingdom	GBR	1994	Pound Sterling	1519652	1478347	57.73667	25.37445	1718.147	3.318652	1143430	1462102	1480134	1454296	4275514	0.8437811	0.8360074	1539957	1230659	1542677	7189067	0.8962294	0.8469064	0.6022500	0.0499640	0.6534266	0.7998383	0.7705001	0.7841891	interpolated	benchmark	market	no	NA	NA	0.6347595	0.2191247	0.1514831	0.2260039	-0.2656137	0.0342425	0.7634724	0.6652314	0.9522221	0.6048408	0.5797722	0.7323192
United Kingdom	GBR	1995	Pound Sterling	1589475	1554254	57.90379	25.65179	1725.713	3.349738	1170911	1539666	1544871	1524399	4596206	0.8517603	0.8497828	1578791	1257032	1623079	7350978	0.8973457	0.8702112	0.5959819	0.0500356	0.6336681	0.8408791	0.8011183	0.8118767	benchmark	benchmark	market	no	NA	NA	0.6234065	0.2419023	0.1447063	0.2377808	-0.2730488	0.0252527	0.8004347	0.6748656	1.0151165	0.6465918	0.6281447	0.7535595
United Kingdom	GBR	1996	Pound Sterling	1674593	1641439	58.07932	25.90053	1727.994	3.381115	1243814	1616862	1620570	1603619	4926870	0.8475673	0.8436683	1620910	1298540	1675014	7519430	0.9019064	0.8791658	0.5876861	0.0490391	0.6409583	0.8347086	0.8062972	0.8148201	benchmark	benchmark	market	no	0.9190811	NA	0.6384134	0.2326292	0.1372159	0.2420737	-0.2748890	0.0245567	0.7892579	0.7115680	1.0461737	0.6533383	0.6413544	0.7715557
United Kingdom	GBR	1997	Pound Sterling	1801386	1756577	58.26386	26.38041	1705.119	3.412787	1356676	1730260	1738406	1726820	5047923	0.8867764	0.8775070	1671142	1352621	1731868	7664252	0.9148174	0.8943053	0.5861672	0.0484244	0.6108361	0.8518976	0.8320026	0.8375848	benchmark	benchmark	market	no	NA	NA	0.6466794	0.2163424	0.1389701	0.2603041	-0.2851157	0.0228198	0.8148154	0.7597539	1.0244550	0.6204850	0.6197602	0.8298763
United Kingdom	GBR	1998	Pound Sterling	1888442	1813215	58.45699	26.65316	1720.474	3.444755	1437450	1828209	1813438	1801130	5103451	0.8929624	0.8898261	1727567	1407718	1817333	7832531	0.9216082	0.9145252	0.6077729	0.0473513	0.6038236	0.8621315	0.8475854	0.8533775	benchmark	benchmark	market	no	NA	NA	0.6567524	0.2169524	0.1413301	0.2528893	-0.2868337	0.0189095	0.8288851	0.7940759	1.0166255	0.5934206	0.6036877	0.8749288
United Kingdom	GBR	1999	Pound Sterling	1962498	1884668	58.65779	27.01198	1712.213	3.477022	1534616	1917937	1886983	1877945	5035408	0.9110383	0.9042608	1781342	1469890	1894809	7996396	0.9324411	0.9355984	0.6241565	0.0465303	0.6180568	0.8372229	0.8296404	0.8336334	benchmark	benchmark	market	no	NA	NA	0.6697053	0.2041174	0.1474729	0.2423914	-0.2791518	0.0154649	0.8058096	0.7992844	0.9798775	0.5831355	0.6015144	0.9205824
United Kingdom	GBR	2000	Pound Sterling	2088803	2024305	58.86700	27.31735	1699.107	3.509591	1650633	2054763	2015176	2011111	5134820	0.9471037	0.9298179	1849012	1538370	1967642	8162493	0.9527478	0.9563877	0.6309897	0.0459023	0.6609308	0.7730830	0.7715102	0.7730696	benchmark	benchmark	market	no	NA	NA	0.6695670	0.2009486	0.1511896	0.2721535	-0.3255441	0.0316854	0.7461854	0.7650863	0.8922034	0.5387948	0.5723231	0.9000055
United States of America	USA	1990	US Dollar	9203227	9203558	252.84781	123.40108	1793.348	3.435097	7180793	9379958	9259331	9259567	26453210	1.0000000	1.0000000	9241600	7644560	9454309	29208678	0.8194728	0.8043448	0.6205937	0.0505045	1.0000000	0.6647873	0.6457918	0.6457753	interpolated	benchmark	market	no	NA	NA	0.6682413	0.2375019	0.1072586	0.0696767	-0.0904981	0.0078196	0.6182825	0.5837670	0.9545210	0.6089282	0.6175903	0.6470308
United States of America	USA	1991	US Dollar	9191710	9171585	255.36716	121.96242	1782.940	3.452303	7177849	9287654	9244829	9248708	26586270	1.0000000	1.0000000	9234885	7681240	9385194	29807548	0.8189521	0.7985377	0.6207349	0.0510970	1.0000000	0.6916000	0.6678329	0.6675526	interpolated	benchmark	market	no	NA	NA	0.6675106	0.2281189	0.1085815	0.0691286	-0.0828615	0.0095220	0.6414561	0.5869737	0.9998621	0.6593493	0.6641042	0.6685519
United States of America	USA	1992	US Dollar	9530917	9509170	257.90821	122.23189	1773.457	3.469595	7393262	9636033	9585170	9573914	26769574	1.0000000	1.0000000	9563208	7915272	9717433	30447546	0.8403289	0.8192613	0.6259861	0.0512877	1.0000000	0.7121214	0.6822309	0.6830331	interpolated	benchmark	market	no	NA	NA	0.6659960	0.2342586	0.1062337	0.0786810	-0.0960980	0.0109287	0.6611473	0.5836974	1.0316866	0.5938390	0.6016038	0.6837977
United States of America	USA	1993	US Dollar	9827602	9786068	260.52742	123.59286	1789.835	3.486973	7598004	9976447	9882773	9835906	27514982	1.0000000	1.0000000	9825721	8133447	10036044	31142584	0.8427125	0.8258529	0.6202356	0.0509976	1.0000000	0.7298232	0.6960294	0.6993458	interpolated	benchmark	market	no	NA	NA	0.6700311	0.2418123	0.1024452	0.0779927	-0.1029224	0.0106411	0.6784149	0.5880738	1.0660539	0.6058393	0.5958048	0.7000707
United States of America	USA	1994	US Dollar	10262589	10205495	263.30132	126.19808	1805.167	3.504440	7875691	10382788	10252747	10232211	28433732	1.0000000	1.0000000	10222333	8395977	10477239	31914476	0.8503121	0.8361810	0.6138800	0.0508853	1.0000000	0.7428809	0.7128529	0.7142835	interpolated	benchmark	market	no	NA	NA	0.6700110	0.2450200	0.0996848	0.0803991	-0.1066071	0.0114922	0.6915565	0.6185242	1.0878472	0.6227808	0.6316585	0.7149737
United States of America	USA	1995	US Dollar	10550124	10501270	266.27553	127.99717	1822.320	3.521993	8141430	10649630	10526347	10519550	29573488	1.0000000	1.0000000	10511666	8603863	10745698	32739804	0.8507296	0.8344105	0.6131054	0.0509954	1.0000000	0.7527744	0.7280835	0.7285540	extrapolated	benchmark	market	no	NA	NA	0.6780313	0.2384323	0.0959020	0.0837377	-0.1089028	0.0127995	0.6987903	0.6479387	1.1344443	0.6617960	0.6728488	0.7291004
United States of America	USA	1996	US Dollar	10988194	10926444	269.48322	129.91119	1818.629	3.533239	8440640	11059940	10929891	10918888	30426092	1.0000000	1.0000000	10910675	8855808	11165208	33669848	0.8649735	0.8492648	0.6127331	0.0511477	1.0000000	0.7635167	0.7411053	0.7418521	benchmark	benchmark	market	no	1.0000000	NA	0.6820182	0.2398870	0.0910130	0.0849851	-0.1100589	0.0121556	0.7074198	0.6688849	1.1838868	0.6711445	0.6803800	0.7424105
United States of America	USA	1997	US Dollar	11538199	11437019	272.88286	132.93214	1830.795	3.544521	8705518	11552962	11417703	11409474	31494458	1.0000000	1.0000000	11400236	9158386	11695571	34694968	0.8755475	0.8618117	0.6149386	0.0513795	1.0000000	0.7794309	0.7539608	0.7545046	interpolated	benchmark	market	no	NA	NA	0.6707152	0.2495684	0.0922927	0.0951182	-0.1202996	0.0126052	0.7266533	0.6760906	1.1629795	0.6335261	0.6542725	0.7551160
United States of America	USA	1998	US Dollar	12132393	11956923	276.35410	135.07707	1842.790	3.555839	9099003	12138236	11924765	11916442	32851262	1.0000000	1.0000000	11907535	9590438	12341446	35854404	0.8888780	0.8839169	0.6289788	0.0512883	1.0000000	0.7885633	0.7622087	0.7627411	interpolated	benchmark	market	no	NA	NA	0.6714191	0.2550454	0.0921480	0.0947524	-0.1244996	0.0111347	0.7377932	0.6833072	1.1584898	0.6026288	0.6365294	0.7633117
United States of America	USA	1999	US Dollar	12720219	12510232	279.73080	137.33710	1849.386	3.567193	9558780	12834665	12502540	12473554	34374992	1.0000000	1.0000000	12465426	10054181	13025560	37122332	0.9052219	0.9075477	0.6317638	0.0516960	1.0000000	0.8018377	0.7726926	0.7744882	benchmark	benchmark	market	no	NA	NA	0.6738073	0.2626264	0.0925163	0.0924161	-0.1327325	0.0113664	0.7504094	0.6876494	1.1763964	0.6009801	0.6397626	0.7749932
United States of America	USA	2000	US Dollar	13222419	13031820	282.89574	139.29607	1848.147	3.578582	9977582	13511612	13035321	12983206	35997032	1.0000000	1.0000000	12975535	10500206	13647352	38439588	0.9205835	0.9289908	0.6426795	0.0521203	1.0000000	0.8255066	0.7889932	0.7921603	interpolated	benchmark	market	no	NA	NA	0.6758358	0.2722001	0.0926633	0.1060347	-0.1566473	0.0099135	0.7741043	0.6859053	1.2004077	0.5668258	0.6185908	0.7926286
* Elaboracion propia con base en PWT9.0

#
dataframe_us_ku2 <- herramienta_capdetail() %>%
  filter(country %in% c("United States of America", "United Kingdom"), year %in% 1990:2000)
print(dataframe_us_ku2)%>%
   kable(caption = "Datos Para USA y KU") %>% kable_minimal()  %>% 
  add_footnote(label="Elaboracion propia con base en PWT9.0",
               notation="symbol") %>%  kable_minimal()

## # A tibble: 22 x 5
## # Groups:   country, year [22]
##    country         year       ck     rkna  pl_k
##    <fct>          <int>    <dbl>    <dbl> <dbl>
##  1 United Kingdom  1990 3581698  6776786. 1.10 
##  2 United Kingdom  1991 3680472. 6870654. 1.04 
##  3 United Kingdom  1992 3798598. 6966938. 0.952
##  4 United Kingdom  1993 3989535  7066574. 0.764
##  5 United Kingdom  1994 4275514. 7189066. 0.732
##  6 United Kingdom  1995 4596206  7350978  0.754
##  7 United Kingdom  1996 4926870  7519430. 0.772
##  8 United Kingdom  1997 5047923  7664252  0.830
##  9 United Kingdom  1998 5103450. 7832531  0.875
## 10 United Kingdom  1999 5035408  7996396. 0.921
## # ... with 12 more rows

Datos Para USA y KU

country	year	ck	rkna	pl_k
United Kingdom	1990	3581698	6776786	1.0969303
United Kingdom	1991	3680473	6870655	1.0401849
United Kingdom	1992	3798598	6966938	0.9516477
United Kingdom	1993	3989535	7066574	0.7636015
United Kingdom	1994	4275514	7189067	0.7323192
United Kingdom	1995	4596206	7350978	0.7535595
United Kingdom	1996	4926870	7519430	0.7715557
United Kingdom	1997	5047923	7664252	0.8298763
United Kingdom	1998	5103451	7832531	0.8749288
United Kingdom	1999	5035408	7996396	0.9205824
United Kingdom	2000	5134820	8162493	0.9000055
United States of America	1990	26453210	29208678	0.6470308
United States of America	1991	26586270	29807548	0.6685519
United States of America	1992	26769574	30447546	0.6837977
United States of America	1993	27514982	31142584	0.7000707
United States of America	1994	28433732	31914476	0.7149737
United States of America	1995	29573488	32739804	0.7291004
United States of America	1996	30426092	33669848	0.7424105
United States of America	1997	31494458	34694968	0.7551160
United States of America	1998	32851262	35854404	0.7633117
United States of America	1999	34374992	37122332	0.7749932
United States of America	2000	35997032	38439588	0.7926286
* Elaboracion propia con base en PWT9.0