1 Libraries

knitr::opts_chunk$set(
  echo = TRUE,
  message = FALSE,
  warning = FALSE
)
library(tidyverse)
library(ExPanDaR)      # explore panel data interactively  

theme_set(theme_minimal())

# Change the presentation of decimal numbers to 4 and avoid scientific notation
options(prompt="R> ", digits=6, scipen=7)

2 Import data

dat <- read_csv("https://raw.githubusercontent.com/quarcs-lab/mendez2020-convergence-clubs-code-data/master/assets/dat.csv")
glimpse(dat)
Rows: 2,700
Columns: 29
$ id            <dbl> 62, 62, 62, 62, 62, 62, 62, 13, 13, 13,…
$ country       <chr> "Mozambique", "Mozambique", "Mozambique…
$ year          <dbl> 1990, 1991, 1992, 1993, 1994, 1995, 199…
$ Y             <dbl> 7034, 7743, 6792, 7223, 8194, 7671, 912…
$ K             <dbl> 6262, 6462, 6592, 6859, 7246, 7734, 812…
$ pop           <dbl> 13.37197, 13.71985, 14.20399, 14.77588,…
$ L             <dbl> 5.41371, 5.59319, 5.84473, 6.18786, 6.5…
$ s             <dbl> 0.996469, 0.982938, 0.969407, 0.955876,…
$ alpha_it      <dbl> 0.573771, 0.573771, 0.573771, 0.573771,…
$ GDPpc         <dbl> 526.026, 564.365, 478.176, 488.837, 533…
$ lp            <dbl> 1299.29, 1384.36, 1162.07, 1167.29, 125…
$ h             <dbl> 1.34708, 1.34363, 1.34018, 1.33672, 1.3…
$ kl            <dbl> 1156.69, 1155.33, 1127.85, 1108.46, 111…
$ kp            <dbl> 1.123283, 1.198236, 1.030340, 1.053069,…
$ ky            <dbl> 0.890247, 0.834560, 0.970554, 0.949605,…
$ TFP           <dbl> 203.955, 220.003, 189.115, 194.962, 213…
$ log_GDPpc_raw <dbl> 6.26535, 6.33570, 6.16998, 6.19203, 6.2…
$ log_lp_raw    <dbl> 7.16958, 7.23299, 7.05796, 7.06244, 7.1…
$ log_ky_raw    <dbl> -0.11625594, -0.18085031, -0.02988867, …
$ log_h_raw     <dbl> 0.297936, 0.295377, 0.292805, 0.290219,…
$ log_tfp_raw   <dbl> 5.31790, 5.39364, 5.24235, 5.27280, 5.3…
$ log_GDPpc     <dbl> 6.16375, 6.19572, 6.22795, 6.26104, 6.2…
$ log_lp        <dbl> 7.05023, 7.07574, 7.10155, 7.12835, 7.1…
$ log_ky        <dbl> -0.129063, -0.130162, -0.131228, -0.132…
$ log_h         <dbl> 0.277040, 0.279689, 0.282389, 0.285233,…
$ log_tfp       <dbl> 5.25749, 5.28692, 5.31650, 5.34665, 5.3…
$ region        <chr> "Africa", "Africa", "Africa", "Africa",…
$ hi1990        <chr> "no", "no", "no", "no", "no", "no", "no…
$ isocode       <chr> "MOZ", "MOZ", "MOZ", "MOZ", "MOZ", "MOZ…

Select all variables but id

dat <- dat %>% 
  select(
    -id
  )

3 Definitions of variables

df_definitions <- read_csv("https://raw.githubusercontent.com/quarcs-lab/mendez2020-convergence-clubs-code-data/master/assets/dat-definitions.csv")
df_definitions 

4 Interactive exploration

4.1 Initial exploration

# Run it in the console
ExPanD(
  df = dat,
  df_def = df_definitions,
  title = "Automatic data exploration",
  abstract = paste("Full sample")
    )

4.2 Customized exploration

customized <- readRDS("customized.RDS")
# Run it in the console
ExPanD(
  df = dat,
  df_def = df_definitions,
  config_list = customized,
  #export_nb_option = TRUE,
  title = "Customized data exploration",
  abstract = paste("Full sample")
    )

END

LS0tCnRpdGxlOiAiQXV0b21hdGljIGRhdGEgZXhwbG9yYXRpb24iCnN1YnRpdGxlOiAiTGFib3IgcHJvZHVjdGl2aXR5IGFuZCBpdHMgcHJveGltYXRlIGRldGVybWluYW50cyIKYXV0aG9yOiAiIgpvdXRwdXQ6CiAgaHRtbF9kb2N1bWVudDoKICAgIGNvZGVfZG93bmxvYWQ6IHRydWUKICAgIGRmX3ByaW50OiBwYWdlZAogICAgdG9jOiB0cnVlCiAgICB0b2NfZmxvYXQ6CiAgICAgIGNvbGxhcHNlZDogZmFsc2UKICAgICAgc21vb3RoX3Njcm9sbDogZmFsc2UKICAgIHRvY19kZXB0aDogNAogICAgbnVtYmVyX3NlY3Rpb25zOiB0cnVlCiAgICBjb2RlX2ZvbGRpbmc6ICJzaG93IgogICAgdGhlbWU6ICJjb3NtbyIKICAgIGhpZ2hsaWdodDogIm1vbm9jaHJvbWUiCiAgaHRtbF9ub3RlYm9vazoKICAgIGNvZGVfZm9sZGluZzogInNob3ciCiAgICBoaWdobGlnaHQ6ICJtb25vY2hyb21lIgogICAgbnVtYmVyX3NlY3Rpb25zOiB5ZXMKICAgIHRoZW1lOiAiY29zbW8iCiAgICB0b2M6IHllcwogICAgdG9jX2RlcHRoOiA0CiAgICB0b2NfZmxvYXQ6CiAgICAgIGNvbGxhcHNlZDogbm8KICAgICAgc21vb3RoX3Njcm9sbDogbm8KICBwZGZfZG9jdW1lbnQ6IGRlZmF1bHQKICB3b3JkX2RvY3VtZW50OiBkZWZhdWx0CiAgZ2l0aHViX2RvY3VtZW50OiBkZWZhdWx0Ci0tLQoKPHN0eWxlPgpoMS50aXRsZSB7Zm9udC1zaXplOiAxOHB0OyBjb2xvcjogRGFya0JsdWU7fSAKYm9keSwgaDEsIGgyLCBoMywgaDQge2ZvbnQtZmFtaWx5OiAiUGFsYXRpbm8iLCBzZXJpZjt9CmJvZHkge2ZvbnQtc2l6ZTogMTJwdDt9Ci8qIEhlYWRlcnMgKi8KaDEsaDIsaDMsaDQsaDUsaDZ7Zm9udC1zaXplOiAxNHB0OyBjb2xvcjogIzAwMDA4Qjt9CmJvZHkge2NvbG9yOiAjMzMzMzMzO30KYSwgYTpob3ZlciB7Y29sb3I6ICM4QjNBNjI7fQpwcmUge2ZvbnQtc2l6ZTogMTJweDt9Cjwvc3R5bGU+CgoKIyBMaWJyYXJpZXMKCmBgYHtyIHNldHVwLCBpbmNsdWRlPVR9CmtuaXRyOjpvcHRzX2NodW5rJHNldCgKICBlY2hvID0gVFJVRSwKICBtZXNzYWdlID0gRkFMU0UsCiAgd2FybmluZyA9IEZBTFNFCikKbGlicmFyeSh0aWR5dmVyc2UpCmxpYnJhcnkoRXhQYW5EYVIpICAgICAgIyBleHBsb3JlIHBhbmVsIGRhdGEgaW50ZXJhY3RpdmVseSAgCgp0aGVtZV9zZXQodGhlbWVfbWluaW1hbCgpKQoKIyBDaGFuZ2UgdGhlIHByZXNlbnRhdGlvbiBvZiBkZWNpbWFsIG51bWJlcnMgdG8gNCBhbmQgYXZvaWQgc2NpZW50aWZpYyBub3RhdGlvbgpvcHRpb25zKHByb21wdD0iUj4gIiwgZGlnaXRzPTYsIHNjaXBlbj03KQpgYGAKCgojIEltcG9ydCBkYXRhCgpgYGB7cn0KZGF0IDwtIHJlYWRfY3N2KCJodHRwczovL3Jhdy5naXRodWJ1c2VyY29udGVudC5jb20vcXVhcmNzLWxhYi9tZW5kZXoyMDIwLWNvbnZlcmdlbmNlLWNsdWJzLWNvZGUtZGF0YS9tYXN0ZXIvYXNzZXRzL2RhdC5jc3YiKQpgYGAKCmBgYHtyfQpnbGltcHNlKGRhdCkKYGBgCgoKClNlbGVjdCBhbGwgdmFyaWFibGVzIGJ1dCBpZAoKYGBge3J9CmRhdCA8LSBkYXQgJT4lIAogIHNlbGVjdCgKICAgIC1pZAogICkKYGBgCgoKIyBEZWZpbml0aW9ucyBvZiB2YXJpYWJsZXMKCgpgYGB7cn0KZGZfZGVmaW5pdGlvbnMgPC0gcmVhZF9jc3YoImh0dHBzOi8vcmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbS9xdWFyY3MtbGFiL21lbmRlejIwMjAtY29udmVyZ2VuY2UtY2x1YnMtY29kZS1kYXRhL21hc3Rlci9hc3NldHMvZGF0LWRlZmluaXRpb25zLmNzdiIpCmRmX2RlZmluaXRpb25zIApgYGAKCiMgSW50ZXJhY3RpdmUgZXhwbG9yYXRpb24KCiMjIEluaXRpYWwgZXhwbG9yYXRpb24KCmBgYHtyIGV2YWw9RkFMU0UsIGluY2x1ZGU9VH0KIyBSdW4gaXQgaW4gdGhlIGNvbnNvbGUKRXhQYW5EKAogIGRmID0gZGF0LAogIGRmX2RlZiA9IGRmX2RlZmluaXRpb25zLAogIHRpdGxlID0gIkF1dG9tYXRpYyBkYXRhIGV4cGxvcmF0aW9uIiwKICBhYnN0cmFjdCA9IHBhc3RlKCJGdWxsIHNhbXBsZSIpCiAgICApCmBgYAoKCgojIyBDdXN0b21pemVkIGV4cGxvcmF0aW9uCgpgYGB7cn0KY3VzdG9taXplZCA8LSByZWFkUkRTKCJjdXN0b21pemVkLlJEUyIpCmBgYAoKCgoKCgpgYGB7ciBldmFsPUZBTFNFLCBpbmNsdWRlPVR9CiMgUnVuIGl0IGluIHRoZSBjb25zb2xlCkV4UGFuRCgKICBkZiA9IGRhdCwKICBkZl9kZWYgPSBkZl9kZWZpbml0aW9ucywKICBjb25maWdfbGlzdCA9IGN1c3RvbWl6ZWQsCiAgI2V4cG9ydF9uYl9vcHRpb24gPSBUUlVFLAogIHRpdGxlID0gIkN1c3RvbWl6ZWQgZGF0YSBleHBsb3JhdGlvbiIsCiAgYWJzdHJhY3QgPSBwYXN0ZSgiRnVsbCBzYW1wbGUiKQogICAgKQpgYGAKCgoKCkVORAoKCgoK