merge_data: Merging the three financial datasets

View source: R/merge_data.R

merge_dataR Documentation

Merging the three financial datasets

Description

Function to merge the three financial datasets from the three different platforms to obtain a complete dataset to have a comprhensive overview of the investements.

Usage

merge_data(data_RENDIS, data_OBDAP, data_OC)

Arguments

data_RENDIS

Dataset of class 'data.frame'. Specify the dataset obtained from the ReNDiS database by the get_data_RENDIS function.

data_OBDAP

Dataset of class 'data.frame'. Specify the dataset obtained from the OpenBDAP database by the get_data_OBDAP function.

data_OC

Dataset of class 'data.frame'. Specify the dataset obtained from the OpenCoesione database by the get_data_region_OC or get_data_theme_OC function.

Value

Object of class data.frame showing 28 variables:

Descriptive Variables:

  • CUP (character)

  • Intervention (character)

  • Source (character)

Financial Variables:

  • State Funding (numeric)

  • EU Funding (numeric)

  • Local Authorities Funding (numeric)

  • Private Funding (numeric)

  • Other Funding (numeric)

  • Finance (numeric)

Geographical References:

  • DEN_REGION (character)

  • DEN_PROVINCE (character)

  • DEN_MUNICIPALITY (character)

  • COD_REGION (character)

  • COD_PROVINCE (character)

  • COD_MUNICIPALITY (character)

  • geom (character)

Legislative process main steps:

  • Feasibility Study Starting Date (character)

  • Feasibility Study Ending Date (character)

  • Preliminary Design Starting Date (character)

  • Preliminary Design Ending Date (character)

  • Definitive Design Starting Date (character)

  • Definitive Design Ending Date (character)

  • Executive Design Starting Date (character)

  • Executive Design Ending Date (character)

  • Works Execution Starting Date (character)

  • Works Execution Ending Date (character)

  • Conclusion Starting Date (character)

  • Conclusion Ending Date (character)

Author(s)

Lorena Ricciotti

Examples

data(OCpoint)
data(OBDAPpoint)
data(RENDISpoint)
data_all <- merge_data(RENDISpoint, OBDAPpoint, OCpoint)


PublicWorksFinanceIT documentation built on April 3, 2025, 6:11 p.m.