add new emissions factor unit spellings in AI data

[cjyetman]

Recent AI data is using new spellings of emissions factor units.

library(tidyverse)
pams_path <- "~/data/pactarawdata/asset-impact/2024-02-15_AI_RMI_2023Q4/2024-02-14_AI_2023Q4_RMI-Company-Indicators.xlsx"
pams <- pacta.data.preparation::import_ar_advanced_company_indicators(pams_path)
pams %>% filter(value_type == "emission_intensity") %>% select(`Asset Sector`, `Activity Unit`) %>% distinct() %>% arrange(`Asset Sector`, `Activity Unit`)
#> # A tibble: 17 × 2
#>    `Asset Sector` `Activity Unit`
#>    <fct>          <fct>          
#>  1 Aviation       tCO2           
#>  2 Aviation       tCO2/pkm       
#>  3 Aviation       tCO2/tkm       
#>  4 Cement         tCO2e          
#>  5 Cement         tCO2e/t cement 
#>  6 Coal           tCO2e          
#>  7 Coal           tCO2e/t coal   
#>  8 LDV            tCO2           
#>  9 LDV            tCO2/km        
#> 10 Oil&Gas        tCO2e          
#> 11 Oil&Gas        tCO2e/GJ       
#> 12 Power          tCO2e          
#> 13 Power          tCO2e/MWh      
#> 14 Shipping       tCO2           
#> 15 Shipping       tCO2/dwt km    
#> 16 Steel          tCO2e          
#> 17 Steel          tCO2e/t steel

[github-actions[bot]]

Coverage Report

|file|head|main|diff| | :-- | --: | --: | --: | |Overall|95%|95%|:arrow_up: 0.048%| |R/assert_columns_exists.R|100%|100%|0%| |R/assert_regex.R|100%|100%|0%| |R/assert_subset.R| 92%| 92%|0%| |R/assert_valid_ai_company_id.R| 0%| 0%|0%| |R/assert_valid_asset_type.R|100%|100%|0%| |R/assert_valid_bics_sector_code.R| 0%| 0%|0%| |R/assert_valid_bics_subgroup_code.R| 0%| 0%|0%| |R/assert_valid_emissions_factor_unit.R|100%|100%|0%| |R/assert_valid_equity_market.R| 0%| 0%|0%| |R/assert_valid_factset_entity_id.R|100%|100%|0%| |R/assert_valid_factset_fund_id.R| 0%| 0%|0%| |R/assert_valid_factset_sym_id.R| 0%| 0%|0%| |R/assert_valid_indicator_for_sector.R|100%|100%|0%| |R/assert_valid_indicator.R|100%|100%|0%| |R/assert_valid_isin.R|100%|100%|0%| |R/assert_valid_iso2c.R|100%|100%|0%| |R/assert_valid_iso4217c.R|100%|100%|0%| |R/assert_valid_production_unit.R|100%|100%|0%| |R/assert_valid_scenario_geography.R| 0%| 0%|0%| |R/assert_valid_sector.R| 98%| 98%|0%| |R/assert_valid_sectors_with_assets.R|100%|100%|0%| |R/assert_valid_technology_for_sector.R|100%|100%|0%| |R/assert_valid_technology.R|100%|100%|0%| |R/assert_valid_units.R|100%|100%|0%| |R/assert_valid_value_range_for_sector_unit_scenario_prep.R|100%|100%|0%| |R/fake_abcd_flags_bonds.R|100%|100%|0%| |R/fake_abcd_flags_equity.R|100%|100%|0%| |R/fake_currencies.R|100%|100%|0%| |R/fake_financial_data.R|100%|100%|0%| |R/fake_intermediate_scenario_data.R|100%|100%|0%| |R/fake_masterdata_debt_datastore.R|100%|100%|0%| |R/fake_masterdata_ownership_datastore.R|100%|100%|0%| |R/is_valid_isin.R|100%|100%|0%| |R/matches_regex.R|100%|100%|0%| |R/set_collapse.R|100%|100%|0%| |R/simplify_if_one_col_df.R|100%|100%|0%| |R/validate_abcd_flags_bonds.R|100%|100%|0%| |R/validate_abcd_flags_equity.R|100%|100%|0%| |R/validate_currencies.R|100%|100%|0%| |R/validate_financial_data.R|100%|100%|0%| |R/validate_intermediate_scenario_output.R|100%|100%|0%| |R/validate_masterdata_debt_datastore.R|100%|100%|0%| |R/validate_masterdata_ownership_datastore.R|100%|100%|0%|

[cjyetman]

NB: again, does this suggest we require changes in scenario prep?

see comment here https://github.com/RMI-PACTA/pacta.data.validation/pull/66#issuecomment-2060565248

I guess we don't ever actually join on the unit column correct?

not that I know of