An interactive exploration of panel data

Using the package ExPanDaR to generate interactive web applications

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

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

Suggested Citation:

Mendez Carlos (2020). An interactive exploration of panel data: Using the package ExPanDaR to generate interactive web applications. R Studio/RPubs. Available at https://rpubs.com/econdata777/explore-panel-interactively

This work is licensed under the Creative Commons Attribution-Share Alike 4.0 International License.

1 Load the data

Let us use the gapminder data set:

Gapminder Data: Life Expectancy and GDP per capita across countries from 1952 to 2007

Documentation of the gapminder dataset

gapminder

2 Transform the data

• Take the log of GDP

• Re-scale the population variable

gapminder <- gapminder %>% 
  mutate(
    logGDPpc = log(gdpPercap),
    pop = pop / 1e6
  )

3 Order and select variables

• The order of the variables is important

gapminder_selected <- gapminder %>% 
  select(country, year, logGDPpc, lifeExp, pop, gdpPercap, continent)

gapminder_selected

4 Import dataframe of definitions

df_definitions <- read_csv("df_def.csv") 
df_definitions

5 Interactive exploration

# Run it in the console
ExPanD(
  df = gapminder_selected,
  df_def = df_definitions,
  export_nb_option = TRUE,
  title = "Panel exploration",
  abstract = paste("The relationship between life expectancy and GDP per capita")
    )

6 Shiny app

https://carlosmendez777.shinyapps.io/short-project-explore-panel-interactively

7 Research Tasks

• Evaluate the relationship between life expectancy and log of GDP per capita for each continent. How does this relatioship change across continents?

• Evaluate the relationship between life expectancy and log of GDP per capita in the years 1952, 1972, and 1992. How does this relationship change over time?

• Create an interactive web application of your analysis.

8 References

• https://joachim-gassen.github.io/ExPanDaR/
• https://cran.r-project.org/web/packages/ExPanDaR/index.html

END