Understanding the data

In pacta.multi.loanbook: Run 'PACTA' on Multiple Loan Books Easily

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

library(pacta.multi.loanbook)

plot_table <- function(table) {
  table_plot <- gt::gt(dplyr::select(table, -"dataset"))

  table_plot <- 
    gt::cols_width(
      .data = table_plot,
      column ~ gt::px(150),
      typeof ~ gt::px(90)
    )

  table_plot <-
    gt::tab_style(
      data = table_plot,
      style = gt::cell_text(size = "smaller"),
      locations = gt::cells_body(columns = 1:2)
    )

  table_plot <-
    gt::tab_options(
      data = table_plot,
      ihtml.active = TRUE,
      ihtml.use_pagination = FALSE,
      ihtml.use_sorting = TRUE,
      ihtml.use_highlight = TRUE
    )

  gt::fmt_passthrough(table_plot)
}

Intro

In many cases, users of this package will want to use the outputs of the analyses for further processing, such as additional analyses or making visualizations based on the design guide of their own organisation. To facilitate such additional use cases, but also simplify interpretation of the outputs generated with this package, this data dictionary documents each type of output table in detail, focusing on data types and definitions.

This article is structured based on the output tables generated by pacta.multi.loanbook and follows the standard flow of the user experience as much as possible, so it can be read in the same sequence as the analysis is run.

Tables

The main steps that generate output tables are:

• Diagnostics and coverage
• Standard PACTA analysis
• Aggregated PACTA metrics

Diagnostics

The diagnostics section is split into determining the match success rate of the loan books analysed and inspecting the real economy activity related to the financing made by the banks through the matched loan books. The former is influenced by the quality of the input loan book data and the completeness of the reference production data against which the loan books are matched. The latter, while it depends on a solid match success rate, is mainly driven by the financing decisions and the portfolio allocation made by the banks. If a sector split is applied to the loan book, any companies that are lost in the process are documented for every loan book.

Match success rate

dplyr::filter(data_dictionary, .data[["dataset"]] == "lbk_match_success_rate")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "lbk_match_success_rate")
plot_table(table)

Loan book coverage

dplyr::filter(data_dictionary, .data[["dataset"]] == "summary_statistics_loanbook_coverage")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "summary_statistics_loanbook_coverage")
plot_table(table)

Companies lost in sector split

dplyr::filter(data_dictionary, .data[["dataset"]] == "lost_companies_sector_split")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "lost_companies_sector_split")
plot_table(table)

Standard PACTA analysis

The standard PACTA analysis is run across all input banking books, but produces the same output metrics as known from the r2dii.* packages. Results are given at portfolio level grouped by banking book. Beyond the standard output format, tables are provided that can be used as input for visualizations, for each of the standard sectors and technologies.

Target Market Share results (all groups)

Target market share results at the portfolio level for each included banking book

dplyr::filter(data_dictionary, .data[["dataset"]] == "tms_results")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "tms_results")
plot_table(table)

Sectoral Decarbonization Approach results (all groups)

SDA results at the portfolio level for each included banking book

dplyr::filter(data_dictionary, .data[["dataset"]] == "sda_results")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "sda_results")
plot_table(table)

Data tech mix

Results for a given portfolio and sector, tailored to be used in the tech mix chart

dplyr::filter(data_dictionary, .data[["dataset"]] == "data_tech_mix")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "data_tech_mix")
plot_table(table)

Data trajectory

Results for a given portfolio, sector and technology, tailored to be used in the volume trajectory chart

dplyr::filter(data_dictionary, .data[["dataset"]] == "data_trajectory")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "data_trajectory")
plot_table(table)

Data emission intensity

Results for a given portfolio and sector, tailored to be used in the emission intensity chart

dplyr::filter(data_dictionary, .data[["dataset"]] == "data_emission_intensity")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "data_emission_intensity")
plot_table(table)

Companies included

Lists all companies including exposures, that were analysed for the given loan book and that are therefore included in the data to be visualized.

dplyr::filter(data_dictionary, .data[["dataset"]] == "companies_included")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "companies_included")
plot_table(table)

Aggregated PACTA metrics

The aggregated PACTA metrics are also run across all input banking books. The calculations produce the net aggregate alignment metric, which is defined in the vignettes "Calculation of a company alignment metric" and "Calculation of exposure-weighted aggregated alignment metric" and allows producing the corresponding plots. Results are grouped at the level defined by the by_group parameter.

Company technology deviation

For each company in the analyzed banking books, shows the deviation of the technology build-out in the final year of the analysis from the corresponding allocated scenario value. This is an intermediate result that is further processed in the calculation of the net aggregate alignment metric. Only available for sectors, which have technology level calculations using the target market share, namely automotive, coal, oil and gas, power.

dplyr::filter(data_dictionary, .data[["dataset"]] == "company_technology_deviation_tms")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "company_technology_deviation_tms")
plot_table(table)

Company net alignment metric for TMS sectors

For each company in the analyzed banking books, shows the net aggregate alignment metric for sectors, which have technology level calculations using the target market share, namely automotive, coal, oil and gas, power. See vignette("company_alignment_metric") for methodological documentation.

dplyr::filter(data_dictionary, .data[["dataset"]] == "company_alignment_net_tms")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "company_alignment_net_tms")
plot_table(table)

Disaggregated company buildout/phaseout alignment metric for TMS sectors

For each company in the analyzed banking books, shows the aggregate alignment metric - disaggregated into its buildout and phaseout components - for sectors, which have technology level calculations using the target market share, namely automotive, coal, oil and gas, power. See vignette("company_alignment_metric") for methodological documentation.

dplyr::filter(data_dictionary, .data[["dataset"]] == "company_alignment_bo_po_tms")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "company_alignment_bo_po_tms")
plot_table(table)

Company net alignment metric for SDA sectors

For each company in the analyzed banking books, shows the net aggregate alignment metric for sectors, which have sector level calculations using the sectoral decarbonization approach (SDA), namely aviation, cement, steel. See vignette("company_alignment_metric") for methodological documentation.

dplyr::filter(data_dictionary, .data[["dataset"]] == "company_alignment_net_sda")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "company_alignment_net_sda")
plot_table(table)

Company net aggregate alignment metric with financial exposures

For each company in the analyzed banking books, shows the net aggregate alignment metric for all available sectors. This table includes the financial exposure to each of the analyzed parts of the banking books, split as defined in by_group.

dplyr::filter(data_dictionary, .data[["dataset"]] == "company_exposure_net_aggregate_alignment")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "company_exposure_net_aggregate_alignment")
plot_table(table)

Disaggregated company buildout/phaseout alignment metric with financial exposures

For each company in the analyzed banking books, shows the net aggregate alignment metric - disaggregated by its buildout and phaseout components - for all sectors that use technology level TMS calculations, namely automotive, coal, oil and gas, power. This table includes the financial exposure to each of the analyzed parts of the banking books, split as defined in by_group. Note that the financial exposure is not disaggregated, the alignment metric is.

dplyr::filter(data_dictionary, .data[["dataset"]] == "company_exposure_bo_po_aggregate_alignment")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "company_exposure_bo_po_aggregate_alignment")
plot_table(table)

Loan book net aggregate alignment metric with financial exposures

For each loan book level group (split as defined in by_group), shows the net aggregate alignment metric for all available sectors. This table includes the financial exposure to each of the analyzed parts of the banking books. Company level results are aggregated to the loan book level, using their relative financial exposure as weights.

dplyr::filter(data_dictionary, .data[["dataset"]] == "loanbook_exposure_net_aggregate_alignment")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "loanbook_exposure_net_aggregate_alignment")
plot_table(table)

Disaggregated loan book buildout/phaseout alignment metric with financial exposures

For each loan book level group (split as defined in by_group), shows the net aggregate alignment metric - disaggregated by its buildout and phaseout components - for all sectors using technology level TMS calculations, namely automotive, coal, oil and gas, power. Company level results are aggregated to the loan book level, using their relative financial exposure as weights.

dplyr::filter(data_dictionary, .data[["dataset"]] == "loanbook_exposure_bo_po_aggregate_alignment")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "loanbook_exposure_bo_po_aggregate_alignment")
plot_table(table)

Input data for Sankey plot

Data set meant to be used as input into plot_sankey().

dplyr::filter(data_dictionary, .data[["dataset"]] == "data_sankey")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "data_sankey")
plot_table(table)

Input data for alignment-by-exposure scatter plot

Data set meant to be used as input into plot_scatter_alignment_exposure().

dplyr::filter(data_dictionary, .data[["dataset"]] == "data_scatter_alignment_exposure")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "data_scatter_alignment_exposure")
plot_table(table)

Input data for buildout/phaseout scatter plot

Data set meant to be used as input into plot_scatter().

dplyr::filter(data_dictionary, .data[["dataset"]] == "data_scatter_sector")

table <- dplyr::filter(data_dictionary, .data[["dataset"]] == "data_scatter_sector")
plot_table(table)

pacta.multi.loanbook documentation built on April 4, 2025, 12:40 a.m.