valueprhr (version 0.1.0)

prepare_panel_data: Prepare Panel Data from Wide Format Matrices

Description

Converts wide-format price matrices (with Year as first column and sectors as subsequent columns) into long-format panel data suitable for panel regression analysis.

Usage

prepare_panel_data(direct_prices, production_prices, log_transform = TRUE)

Value

A data frame in panel (long) format with columns:

year

Year of observation

sector

Sector identifier

sector_id

Numeric sector identifier

time

Time index (year minus minimum year plus 1)

direct_price

Direct price value

production_price

Price of production value

log_direct

Log of direct price (if log_transform = TRUE)

log_production

Log of production price (if log_transform = TRUE)

Arguments

direct_prices

Data frame with direct prices (labor value-based). First column must be 'Year', remaining columns are sector values.

production_prices

Data frame with prices of production. Must have same structure as direct_prices.

log_transform

Logical. Apply natural log transformation. Default TRUE.

Examples

set.seed(123)
years <- 2000:2010
sectors <- c("Agriculture", "Manufacturing", "Services")

direct <- data.frame(
  Year = years,
  Agriculture = 100 + cumsum(rnorm(11)),
  Manufacturing = 120 + cumsum(rnorm(11)),
  Services = 90 + cumsum(rnorm(11))
)

production <- data.frame(
  Year = years,
  Agriculture = 102 + cumsum(rnorm(11)),
  Manufacturing = 118 + cumsum(rnorm(11)),
  Services = 92 + cumsum(rnorm(11))
)

panel <- prepare_panel_data(direct, production)
head(panel)