Skip to contents

Pivot Data360 dataset to wide format

pivot_data360.Rd

This function reshapes a Data360-style dataset from long to wide format. It spreads indicator values (OBS_VALUE) across multiple columns based on the indicator variable (INDICATOR), while keeping the reference area and time period identifiers. The resulting dataset is renamed and cleaned to have snake_case variable names.

Usage

pivot_data360(data)

Arguments

data

A data frame or tibble containing the variables:

  • REF_AREA: Country or region code

  • TIME_PERIOD: Year or time reference

  • INDICATOR: Indicator code or name

  • OBS_VALUE: Observation value for the indicator

Value

A tibble in wide format with columns:

  • country_code: The country or region code (from REF_AREA)

  • year: The year or time period (from TIME_PERIOD)

  • One column per unique INDICATOR, containing corresponding values from OBS_VALUE

Details

This function is particularly useful for preparing Data360 or similar datasets for analysis, where multiple indicators are recorded by country and year. The output dataset is cleaned using janitor::clean_names() to ensure consistent naming.

Examples

library(dplyr)
library(tidyr)

data_long <- tibble(
  REF_AREA = c("USA", "USA", "CAN", "CAN"),
  TIME_PERIOD = c(2020, 2020, 2020, 2020),
  INDICATOR = c("GDP", "POP", "GDP", "POP"),
  OBS_VALUE = c(21000, 330, 1800, 38)
)

data_wide <- pivot_data360(data_long)
print(data_wide)
#> # A tibble: 2 × 4
#>   country_code  year   gdp   pop
#>   <chr>        <dbl> <dbl> <dbl>
#> 1 USA           2020 21000   330
#> 2 CAN           2020  1800    38