{ "_id": "6ab7ace099f7aa8c6aa33aca", "Package": "pacta.data.preparation", "Title": "Prepare Data for PACTA for Investors", "Version": "0.1.0.9003", "Authors@R": "c(person(given = \"CJ\",\nfamily = \"Yetman\",\nrole = c(\"aut\", \"cre\", \"ctr\"),\nemail = \"cj@cjyetman.com\",\ncomment = c(ORCID = \"0000-0001-5099-9500\")),\nperson(given = \"Jackson\",\nfamily = \"Hoffart\",\nemail = \"jackson.hoffart@gmail.com\",\nrole = c(\"aut\", \"ctr\"),\ncomment = c(ORCID = \"0000-0002-8600-5042\")),\nperson(given = \"Jacob\",\nfamily = \"Kastl\",\nrole = c(\"aut\", \"ctr\"),\nemail = \"jacob.kastl@gmail.com\"),\nperson(given = \"Alex\",\nfamily = \"Axthelm\",\nrole = c(\"aut\", \"ctr\"),\nemail = \"aaxthelm@rmi.org\",\ncomment = c(ORCID = \"0000-0001-8579-8565\")),\nperson(given = \"RMI\",\nrole = c(\"cph\", \"fnd\"),\nemail = \"PACTA4investors@rmi.org\"))", "Description": "This package provides tools to prepare input datasets to\nbe run in the PACTA_analysis tool.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Language": "en-US", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "Config/testthat/edition": "3", "Config/Needs/website": "rmi-pacta/pacta.pkgdown.rmitemplate", "URL": "https://github.com/RMI-PACTA/pacta.data.preparation", "BugReports": "https://github.com/RMI-PACTA/pacta.data.preparation/issues", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "cmake libfontconfig1-dev libfreetype6-dev\nlibfribidi-dev git make libharfbuzz-dev libgit2-dev libicu-dev\nlibjpeg-dev libpng-dev libtiff-dev libuv1-dev libwebp-dev\nlibxml2-dev libssl-dev libx11-dev zlib1g-dev", "Repository": "https://rmi-pacta.r-universe.dev", "Date/Publication": "2026-03-25 14:01:10 UTC", "RemoteUrl": "https://github.com/rmi-pacta/pacta.data.preparation", "RemoteRef": "HEAD", "RemoteSha": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-26 11:27:10 UTC", "User": "root" }, "Author": "CJ Yetman [aut, cre, ctr] (ORCID:\n),\nJackson Hoffart [aut, ctr] (ORCID:\n),\nJacob Kastl [aut, ctr],\nAlex Axthelm [aut, ctr] (ORCID:\n),\nRMI [cph, fnd]", "Maintainer": "CJ Yetman ", "_user": "rmi-pacta", "_type": "src", "_file": "pacta.data.preparation_0.1.0.9003.tar.gz", "_fileid": "https://r2.ropensci.org/534e971fab16ce18599107c9b2fc930e61b99b3616f4d0d9e21d91b43d116bc4", "_filesize": 1809612, "_sha256": "534e971fab16ce18599107c9b2fc930e61b99b3616f4d0d9e21d91b43d116bc4", "_expires": "2027-01-04T11:30:38.000Z", "_created": "2026-09-26T11:27:10.000Z", "_published": "2026-09-26T11:30:40.613Z", "_jobs": [ { "job": 108395560190, "time": 159, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10905391804" }, { "job": 108395560208, "time": 175, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10905531433" }, { "job": 108395560184, "time": 92, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10905501273" }, { "job": 108395560187, "time": 108, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10905601151" }, { "job": 108394954863, "time": 262, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10905176633" }, { "job": 108395560212, "time": 163, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10904697566" }, { "job": 108395560224, "time": 96, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10904723899" }, { "job": 108395560236, "time": 98, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10905680629" }, { "job": 108395560191, "time": 90, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10905590964" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756", "_status": "success", "_upstream": "https://github.com/rmi-pacta/pacta.data.preparation", "_commit": { "id": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "author": "Jackson Hoffart ", "committer": "GitHub ", "message": "Add archive notice to README (#45)", "time": 1774447270 }, "_maintainer": { "name": "CJ Yetman", "email": "cj@cjyetman.com", "login": "cjyetman", "linkedin": "in/cjyetman", "orcid": "0000-0001-5099-9500", "twitter": "@cjyetman", "description": "Data wrangler\n#rstats #r-pkgs #dataviz #d3\nhttps://cjyetman.r-universe.dev", "uuid": 1708872 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.4.0", "role": "Depends" }, { "package": "cli", "version": ">= 3.5.0", "role": "Imports" }, { "package": "countrycode", "role": "Imports" }, { "package": "data.table", "role": "Imports" }, { "package": "devtools", "role": "Imports" }, { "package": "dplyr", "version": ">= 1.1.0", "role": "Imports" }, { "package": "dtplyr", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "tidyselect", "version": ">= 1.2.0", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "here", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "pkgdown", "role": "Suggests" }, { "package": "readr", "role": "Suggests" }, { "package": "readxl", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "rstudioapi", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "rmi-pacta", "_selfowned": true, "_usedby": 1, "_updates": [ { "week": "2025-48", "n": 2 }, { "week": "2025-51", "n": 1 }, { "week": "2026-10", "n": 1 }, { "week": "2026-13", "n": 1 } ], "_tags": [], "_topics": [ "climate-change", "pacta", "pactaverse", "sustainable-finance" ], "_stars": 1, "_contributors": [ { "user": "cjyetman", "count": 17, "uuid": 1708872 }, { "user": "jdhoffa", "count": 4, "uuid": 8741309 } ], "_userbio": { "uuid": 106075608, "type": "organization", "name": "RMI-PACTA", "followers": 17 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/pacta.data.preparation" }, "_devurl": "https://github.com/rmi-pacta/pacta.data.preparation", "_searchresults": 11, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/pacta.data.preparation.html", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_cranurl": false, "_exports": [ "calc_shares_all_classes", "dataprep_abcd_scen_connection", "determine_relevant_years", "import_ar_advanced_company_indicators", "import_ar_masterdata", "prepare_abcd_flags_bonds", "prepare_abcd_flags_equity", "prepare_ar_company_id__country_of_domicile", "prepare_ar_company_id__credit_parent_ar_company_id", "prepare_ar_company_id__sectors_with_assets__debt", "prepare_ar_company_id__sectors_with_assets__ownership", "prepare_company_id__creditor_company_id", "prepare_entity_info", "prepare_factset_entity_id__ar_company_id", "prepare_factset_entity_id__credit_parent_id", "prepare_factset_entity_id__security_mapped_sector", "prepare_financial_data", "prepare_fund_data", "prepare_isin_to_fund_table", "prepare_iss_average_sector_emission_intensities", "prepare_iss_company_emissions", "prepare_iss_entity_emission_intensities", "prepare_masterdata", "prepare_masterdata_debt", "prepare_total_fund_list", "quarter_to_factset_timestamp", "quarter_to_imf_timestamp", "standardize_asset_type_names", "write_manifest" ], "_help": [ { "page": "calc_shares_all_classes", "title": "Calculate the number of shares across all equity asset classes", "topics": [ "calc_shares_all_classes" ] }, { "page": "dataprep_abcd_scen_connection", "title": "Combine ABCD and scenario data into the [equity/bonds]_abcd_scenario.rds format that is used by portfolio.analysis", "topics": [ "dataprep_abcd_scen_connection" ] }, { "page": "determine_relevant_years", "title": "Determine relevant years", "topics": [ "determine_relevant_years" ] }, { "page": "import_ar_advanced_company_indicators", "title": "Import the data from a version of Asset Resolution's proprietary Advanced Company Indicators XLSX into a tidy data frame.", "topics": [ "import_ar_advanced_company_indicators" ] }, { "page": "import_ar_masterdata", "title": "Import the data from a version of Asset Resolution's bespoke 'masterdata_*.csv' files into a tidy data frame.", "topics": [ "import_ar_masterdata" ] }, { "page": "prepare_abcd_flags_bonds", "title": "Title", "topics": [ "prepare_abcd_flags_bonds" ] }, { "page": "prepare_abcd_flags_equity", "title": "Title", "topics": [ "prepare_abcd_flags_equity" ] }, { "page": "prepare_ar_company_id__country_of_domicile", "title": "Prepare an 'ar_company_id__country_of_domicile' lookup table from the 'entity_info' data", "topics": [ "prepare_ar_company_id__country_of_domicile" ] }, { "page": "prepare_ar_company_id__credit_parent_ar_company_id", "title": "Prepare an 'ar_company_id__credit_parent_ar_company_id' lookup table from the 'entity_info' data", "topics": [ "prepare_ar_company_id__credit_parent_ar_company_id" ] }, { "page": "prepare_ar_company_id__sectors_with_assets__debt", "title": "Prepare an 'ar_company_id__sectors_with_assets__debt' lookup table from the 'masterdata_debt_datastore' data", "topics": [ "prepare_ar_company_id__sectors_with_assets__debt" ] }, { "page": "prepare_ar_company_id__sectors_with_assets__ownership", "title": "Prepare an 'ar_company_id__sectors_with_assets__ownership' lookup table from the 'masterdata_ownership_datastore' data", "topics": [ "prepare_ar_company_id__sectors_with_assets__ownership" ] }, { "page": "prepare_company_id__creditor_company_id", "title": "Prepare a 'company_id__creditor_company_id' lookup table from Asset Impact's 'masterdata_debt' data", "topics": [ "prepare_company_id__creditor_company_id" ] }, { "page": "prepare_entity_info", "title": "Prepare the 'entity_info' output data frame from data frames imported from the 'factset_entity_info.rds' and 'ar_company_id__factset_entity_id.rds' files", "topics": [ "prepare_entity_info" ] }, { "page": "prepare_factset_entity_id__ar_company_id", "title": "Prepare a 'factset_entity_id__ar_company_id' lookup table from Asset Impact's 'ar_company_id__factset_entity_id' crosswalk", "topics": [ "prepare_factset_entity_id__ar_company_id" ] }, { "page": "prepare_factset_entity_id__credit_parent_id", "title": "Prepare a 'factset_entity_id__credit_parent_id' lookup table from 'entity_info'", "topics": [ "prepare_factset_entity_id__credit_parent_id" ] }, { "page": "prepare_factset_entity_id__security_mapped_sector", "title": "Prepare a 'factset_entity_id__security_mapped_sector' lookup table from 'entity_info'", "topics": [ "prepare_factset_entity_id__security_mapped_sector" ] }, { "page": "prepare_financial_data", "title": "Prepare the 'financial_data' output data frame from the imported 'factset_financial_data.rds' file", "topics": [ "prepare_financial_data" ] }, { "page": "prepare_fund_data", "title": "Prepare fund data, filtering to funds with data according to a given threshold and adding a 'MISSINGWEIGHT' holding for the difference", "topics": [ "prepare_fund_data" ] }, { "page": "prepare_isin_to_fund_table", "title": "Prepare 'isin_to_fund_table', filtering out fsyms that have more than 1 row and either no fund data or fund data for both rows", "topics": [ "prepare_isin_to_fund_table" ] }, { "page": "prepare_iss_average_sector_emission_intensities", "title": "Prepare a 'iss_average_sector_emission_intensities' object", "topics": [ "prepare_iss_average_sector_emission_intensities" ] }, { "page": "prepare_iss_company_emissions", "title": "Prepare an 'iss_company_emissions' object from 'factset_iss_emissions_data'", "topics": [ "prepare_iss_company_emissions" ] }, { "page": "prepare_iss_entity_emission_intensities", "title": "Prepare a 'iss_entity_emission_intensities' object", "topics": [ "prepare_iss_entity_emission_intensities" ] }, { "page": "prepare_masterdata", "title": "Prepare the 'masterdata_ownership_datastore' or 'masterdata_debt_datastore' output data frame from an import of a raw AR masterdata_* CSV", "topics": [ "prepare_masterdata" ] }, { "page": "prepare_masterdata_debt", "title": "Prepare the 'masterdata_debt_datastore' object from a raw masterdata_debt CSV", "topics": [ "prepare_masterdata_debt" ] }, { "page": "prepare_total_fund_list", "title": "Prepare a 'total_fund_list' object from 'fund_data'", "topics": [ "prepare_total_fund_list" ] }, { "page": "quarter_to_factset_timestamp", "title": "Convert a PACTA style quarter string to a FactSet style date string for the last day of that quarter", "topics": [ "quarter_to_factset_timestamp" ] }, { "page": "quarter_to_imf_timestamp", "title": "Convert a PACTA style quarter string to an IMF style quarter string", "topics": [ "quarter_to_imf_timestamp" ] }, { "page": "standardize_asset_type_names", "title": "Standardize asset type names", "topics": [ "standardize_asset_type_names" ] }, { "page": "write_manifest", "title": "Write a manifest.json file to the specified path including critical information about the files and parameters used to prepare the data", "topics": [ "write_manifest" ] } ], "_pkglogo": "https://github.com/rmi-pacta/pacta.data.preparation/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/rmi-pacta/pacta.data.preparation/raw/HEAD/README.md", "_rundeps": [ "askpass", "base64enc", "brew", "brio", "bslib", "cachem", "callr", "cli", "clipr", "commonmark", "countrycode", "cpp11", "crayon", "credentials", "curl", "data.table", "desc", "devtools", "diffobj", "digest", "downlit", "dplyr", "dtplyr", "ellipsis", "evaluate", "fansi", "fastmap", "fontawesome", "fs", "generics", "gert", "gitcreds", "glue", "highr", "htmltools", "htmlwidgets", "httpuv", "httr2", "ini", "jquerylib", "jsonlite", "knitr", "later", "lifecycle", "lubridate", "magrittr", "memoise", "mime", "miniUI", "openssl", "otel", "pak", "pillar", "pkgbuild", "pkgconfig", "pkgdown", "pkgload", "praise", "prettyunits", "processx", "profvis", "promises", "ps", "purrr", "R6", "ragg", "rappdirs", "rcmdcheck", "Rcpp", "rdtools", "rlang", "rmarkdown", "roxygen2", "rprojroot", "rstudioapi", "rversions", "sass", "sessioninfo", "shiny", "sourcetools", "stringi", "stringr", "sys", "systemfonts", "testthat", "textshaping", "tibble", "tidyr", "tidyselect", "timechange", "tinytex", "urlchecker", "usethis", "utf8", "vctrs", "waldo", "whisker", "withr", "xfun", "xml2", "xopen", "xtable", "yaml", "zip" ], "_vignettes": [ { "source": "share_ownership_methodology.Rmd", "filename": "share_ownership_methodology.html", "title": "Share Ownership Weighting and Share Class Inclusion in PACTA", "engine": "knitr::rmarkdown", "headings": [ "1. Background", "1.1 Ownership-based attribution methods", "1.2 Defining share ownership", "2. The share ownership weight attribution method", "3. The scope of share classes outstanding", "4. How share classes should be calculated", "4.1 Common and preferred share classes", "4.2 Treasury shares", "4.3 Depository note (ADR/GDR) ISINs", "4.4 Dual listed share class ISINs", "5. Corporate actions that may result in changes to ISINs" ], "created": "2024-04-15 12:05:51", "modified": "2024-04-15 12:05:51", "commits": 1 } ], "_score": 3.8195439355418688, "_indexed": true, "_nocasepkg": "pacta.data.preparation", "_universes": [ "rmi-pacta", "cjyetman" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0.9003", "date": "2026-09-26T11:29:43.000Z", "distro": "resolute", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/06c776164bdc3fae66926b0a04603d763d87d55b95a828f39b8f5526ad044f68", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0.9003", "date": "2026-09-26T11:29:54.000Z", "distro": "resolute", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/34d6ebe1ddd85fe66a726dbac86275a4dac163aa0cf0d879cfaf9e0e6cb8e517", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0.9003", "date": "2026-09-26T11:28:45.000Z", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/8484fcce73d8bc39323dfd12a31272a9d1b9fb906c175db0c8d082154cf8b5f6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0.9003", "date": "2026-09-26T11:28:57.000Z", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/0824bc62ce80b51a751b0f3308f41dcb52083513ee5391606fcd068cec546e0a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0.9003", "date": "2026-09-26T11:30:05.000Z", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/3b44aa7068feb9a7904cffbfc6e11c423eb4c84d0a9079fa2926ddfd38aa4d59", "status": "success", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" }, { "r": "4.7.0", "os": "win", "version": "0.1.0.9003", "date": "2026-09-26T11:28:28.000Z", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/c82824e31aba78dc448a5e8b7799f84da5a3bdd0593eb3ec94672c99aa77b4be", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" }, { "r": "4.5.3", "os": "win", "version": "0.1.0.9003", "date": "2026-09-26T11:28:31.000Z", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/26e4480de901bab22ec32686d76ecba90c60ec2c196c73911b8a6a64fe91f607", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" }, { "r": "4.6.1", "os": "win", "version": "0.1.0.9003", "date": "2026-09-26T11:28:20.000Z", "commit": "ec3298f994bd8234c7176fe84a3cdc00e9fe0048", "fileid": "https://r2.ropensci.org/8211244a45945a700a597b531c35f54343b6122e289d575347f55c40a47f74f8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/rmi-pacta/actions/runs/36238626756" } ] }